Database Management System Concepts and Functions
Classified in Computers
Written on in 
English with a size of 2.49 KB
Database Terminology and Structure
Tip: A set of characters with some meaning can be numeric, alphanumeric, or alphabetical.
Information: Ordered set of data that are managed according to user needs.
Field: It is the smallest unit to which we refer to in a program.
Record: Collection of equal fields or different types.
File: Collection of records stored homogeneously following a structure.
Database: Collection of interrelated files that typically contain information about a particular company.
DBMS: A computer-based system (software) that manages a database or a collection of databases or files.
Uses and Functions of a DBMS
- Allow users to access and manipulate the database.
- Provide administrators with the tools to perform maintenance and data management.
Some Functions of a DBMS:
- Creating the database – storing data in a defined database.
- Data Recovery – consultations and reports.
- Update data – change the contents of the database.
- Application Programming for software development.
- Monitoring the integrity of the database.
- Monitoring the performance of the database.
Key Features of Database Management Systems
Control of Data Redundancy:
This is to ensure a minimum amount of storage space to store data without duplicating information.
Data Sharing:
One of the main features of the databases is that data can be shared among many users simultaneously, thus maximizing efficiency.
Maintaining Integrity:
Data integrity is the guarantee of the accuracy or correctness of the information contained in a database.
Support for Transaction Control:
A transaction is known as all operations to be done on the database. Transactions must be controlled so as not to disturb the integrity of the database.
Independence of Data:
In file-based applications, the application program must know both the organization of the data and the techniques that allow access to data.
Security:
The availability of data can be restricted to certain users. According to the privileges held by each user of the database, they can access more or less information than others.
Speed:
Modern DBMS systems have high rates of response and process.