Database

GATE CSEIT/Database/. Transaction in Database ( With basic introduction). [fvplayer id=”290″] Transaction in Database Management System (DBMS) Introduction to Transactions A transaction in a Database Management System (DBMS) is a sequence of one or more database operations that are executed as a single logical unit of work. Transactions are used to maintain data integrity, consistency, […]

GATE CSEIT/Database Relational algebra part 1 ( Selection and projection operator). [fvplayer id=”288″] Relational algebra is a foundational aspect of database query languages, providing a formal framework for manipulating and retrieving data from relational databases. Two fundamental unary operations in relational algebra are selection and projection. Selection Operator (σ): The selection operator filters rows (tuples) […]

GATE CSEIT/Database/ Hashing introduction with hashing function and hashing table [fvplayer id=”293″]  Hashing in Databases – GATE CSE/IT  What is Hashing? Hashing is a technique used in databases, data structures, and indexing to store and retrieve data efficiently. It uses a hash function to map keys to a specific location in a hash table. Key […]

GATE CSEIT/Database/Collision in Hashing Hashing collision. [fvplayer id=”292″] Hashing and Collision Handling in Databases (GATE CSE/IT)  What is Hashing? Hashing is a technique used in database indexing & data structures to store and retrieve data efficiently. It uses a hash function to convert keys into a fixed-size address (hash value). Formula for Hash Function: h(K)=Kmod  Mh(K) […]

GATE CSEIT/Database/Hashing example ( Which clear your all doubt). [fvplayer id=”291″] Hashing in Databases – GATE CSE/IT Example with Explanation What is Hashing in Databases? Hashing is a technique used in databases to quickly access records using a hash function that maps keys to locations in a hash table. It helps in:Efficient retrieval of data […]

GATE CSEIT/Database/ Transition theory with Transition state and transition diagram [fvplayer id=”289″] Transition Theory in Databases (GATE CSE/IT) 1. Introduction to Transition Theory Transition theory in databases is related to the concept of transactions in a database management system (DBMS). A transaction is a sequence of operations that transforms a database from one consistent state […]