Database

Database Languages in DBMS – DDL, DML, DCL, DQL

Programming languages which are used to create and operate database, known as database language like Structured Query language aka SQL etc. Most of database languages are non-procedural, means the language focus on “what to do instead of how to do?” We can further divide database languages in these 4 categories as per the type of …

Database Languages in DBMS – DDL, DML, DCL, DQL Read More »

Parallel Database Architecture in DBMS – Advantages & Disadvantages

In this kind of architecture multiple processors, memory drives, and storage disks are associated to collaborate with each other and work as a single unit. In this type of database system, the hardware profile is designed to fulfill all the requirements of the database and user transactions to speed up the process. The arrangement of …

Parallel Database Architecture in DBMS – Advantages & Disadvantages Read More »