Definition
We cannot imagine living in this day and age without database systems. However, if we were to manually handle all of our data, we can't even begin to conceive how complicated our lives would become. The interconnected software components that make up a database system enable us to store, retrieve, update, and remove data from a computer system.
A database management system (DBMS), which effectively processes and queries the data, is in charge of this information. It makes it easier to access, manage, update, alter, control, and organize the data.
A database system is a group of associated files and applications that give users an abstract picture of data while concealing the actual, low-level details. They are organized using data models, which are conceptual tools for defining semantics, consistency requirements, relationships, and data.
Components of Database System
1. Hardware
Computers, hard drives, and other physical electronic components that provide an interface between computers and real-world systems are referred to as hardware.
2. Software
Database software, operating system software, network software for sharing data with other users, and apps for accessing data are all examples of software for managing and controlling databases.
3. Data
Data are unprocessed facts and information that require organization and processing in order to have greater significance. Within an enterprise, database dictionaries are used to organize, record, manage, and coordinate data utilization. A database is a storehouse of metadata, or information about a database.
4. Procedures
Procedures are the instructions used in a database management system. They include setup and installation instructions, login and logout instructions, daily operations management instructions, data backup instructions, and report generation instructions.
5. Database Access Language
Data stored in a database can be accessed, updated, and deleted using commands written in Database Access Language. Database Access Language allows users to write instructions and then submit them to the database for execution. Users can insert, remove, and create new databases and tables by using the language.
