Loading

Topic - Database Management Systems

Database Management Systems (DBMS)

 

Database Management System (or DBMS) refers to the technology of efficiently storing and retrieving data and security measures for protecting the data within a database system. 

Structures that exist in a relational database system:

Database - A database is a logical grouping of data. It contains a set of related table spaces and index spaces.

Table - A table is a logical structure made up of rows and columns. 

Indexes - An index is an ordered set of pointers to rows of a table.

Keys - A key is one or more columns that are identified as such in the creation of a table or index, or in the definition of referential integrity.

DBMSs are of two types: General-purpose and special-purpose DBMSs

 

General-purpose DBMS: General-purpose DBMSs aim to meet the needs of as many applications as possible. They are complex software systems and are expensive but their cost can be spread over a large number of users, making them cost-effective for most organizations. Oracle is an example of a general-purpose DBMS.

 

Special-purpose DBMS: an email system is an example of a special-purpose DBMS; it performs many of the functions of a general-purpose DBMS but these functions are limited to what is required to handle email and don't provide the user with all of the functionality that would be available using a general-purpose DBMS.

 

Start studying Alison's Diploma in Information Technology Management course.

Learn more about what Information Technology Project Managers do and how people become Information Technology Project Managers.

Notification

You have received a new notification

Click here to view them all