Relational Algebra Relational algebra is a procedural query language. It gives a step by step process to obtain the result of the…
DBMS Tutorial
-
-
SQL SQL stands for Structured Query Language. It is used for storing and managing data in relational database management system (RDMS). It…
-
Transaction The transaction is a set of logically related operation. It contains a group of tasks. A transaction is an action or…
-
External Sort-Merge Algorithm Till now, we saw that sorting is an important term in any database system. It means arranging the data…
-
Implementation of Pipelining For implementing a pipeline in order to evaluate multiple operations of the given user query, we need to construct…
-
Multiple Granularity Let’s start by understanding the meaning of granularity. Granularity: It is the size of data item allowed to lock. Multiple…
-
Relational Calculus There is an alternate way of formulating queries known as Relational Calculus. Relational calculus is a non-procedural query language. In…
-
SQL JOIN As the name shows, JOIN means to combine something. In case of SQL, JOIN means “to combine two or more…
-
Transaction property The transaction has the four properties. These are used to maintain consistency in a database, before and after the transaction.…
-
File Organization Storage There are different ways of storing data in the database. Storing data in files is one of them. A…