Basic Concept of Database - English | Innovative Sun | Imtiaz Saifullah



Published
❓What Is Database Management?
❓What is a Database Management System (DBMS)?
❓Functions of a DBMS
❓DBMS Concepts
❓DBMS Categories and Technologies
✔️Database management is the process of collecting, storing, organizing, maintaining and analyzing data. Organizations leverage various database management practices and tools, for the purpose of driving data-based decisions and strategic planning.
✔️A DBMS enables organizations to effectively manage databases. DevOps and DataOps teams leverage DBMS technology to perform tasks such as creating and updating databases, as well as reading, writing, and deleting data.
✔️The main purpose of a DBMS is to provide an interface that enables organizations to standardize data management consistently across teams and departments. This is achieved through the management of three core aspects:
Data-which is aggregated, stored, and analyzed by the organization.
Database engines-enables organizations to access, store, and modify data.
Database schema-determines the logical structure for each database.
✔️DBMS solutions come equipped with a unique set of components, each responsible for performing different tasks. Here are the most basic DBMS components:
Software-A DBMS is a software-based system that provides a management interface, which helps users control databases and data sources.
Data-DBMS provides controls for managing operational data, such as records and metadata, as well as index files, data dictionaries, and administrative information.
Procedures-documents that standardize database management, used as guidelines by employees and users, and as automation policies.
Database languages-DBMS use various languages to perform tasks such as controlling user access and specifying database schema. DBMS languages include Data Manipulation Language (DML), Data Definition Language (DDL), Data Control Language (DCL), and Database Access Language (DAL).
Query processor-serves as a communication intermediary between users and the DBMS data engine. The query processor enables users to query requests, for example, by entering instructions in Structured Query Language (SQL).
Runtime database manager-enables DBMS to centralize management of runtime data. A runtime database manager validates user authorizations, processes approved queries, determines which strategy provides optimal query results, ensures data integrity, and handles any task that requires handling query and runtime data.
Database manager-handles database jobs and enables administrators to perform database operations and maintenance tasks, including data backup and restore, cloning, deleting, updating the database, and executing patches.
Database engine-performs the main data storage and retrieval tasks. A database engine can be built into the DBMS software or as a remote resource accessed via an API.
Report generator-enables users to extract DBMS files and display the information in structured formats, according to predefined specifications. Report generation processes help users perform analyses and derive actionable insights.
✔️There is a wide range of DBMS solutions, dedicated to different data types, sources, and use cases. Here are the most common types of DBMS categories and technologies:
RDBMS-a relational database management system (RDBMS) is designed specifically for relational databases, which store data in structured formats such as columns and rows. Popular RDBMS solutions include Oracle Database, MySQL, and Microsoft SQL Server.
Network DBMS-a database in which inter-record type relationships are organized using one-to-many sets. This differs from a Hierarchical Model in that it allows a record type to be a member of more than one set. Individual rows can be retrieved using API functions that allow an application to navigate through individual set instances.
#databasemanagement #DBMS #MySQL #sqldatabase #imtiazsaifullah
Category
Management
Be the first to comment