Category: Database Fundamentals

Normalization forms

Normalization In DBMS

Database normalization or data normalization is a technique for decomposing record sets to eliminate data redundancy based on the relationship between record attributes. Normalization concept became popular with the adoption of relational database management...

Page placement in block

Disk Space Management And Pages

From persistence and price concerns, all the data of a database needs to be stored on disk. The disk space manager is the DBMS component that works closely to the operating system. The disk...

Storage Memory Hierarchy in database

Let’s discuss the storage memory hierarchy based on speed of access used in database systems. CPU: It is very fast. Stores the data in registers. Processes the data values, evaluates the arithmetics expressions, computes...

What is a DBMS ?

A DBMS is a piece of software intended to manage large amount of data in a robust and efficient manner. A DBMS simplifies the storage and retrieval of data from user perspective. It engages a...