Category: RDBMS

Who is database administrator and what are all his functions?

The person who has the central control over the data, and the programs that access the data, is called the database administrator (DBA). Following are the functions of the Database administrator (DBA). This is one of the main reasons for using Database management systems (DBMS)s. Schema definition: The Database administrator (DBA) creates the original database …

Read More Who is database administrator and what are all his functions?

Why storage management is important in a database management system

The databases of any organization typically require a large amount of storage space to store their daily operational information. Corporate company’s database sizes are usually of gigabytes of data or sometimes for largest companies these databases will be of terabytes of data. 1 gigabyte is 1000 megabytes (1 Billion bytes), and 1 terabyte is 1 …

Read More Why storage management is important in a database management system

What is a data model?

The structure of the underlying database is called the data model. This structure consists of a collection of conceptual tools for describing data, data relationships, data semantics, and consistency constraints. The various data models falls into three different groups: object-based logical models, record based logical models, and physical models. Object-based logical models Object based logical …

Read More What is a data model?