Components of a Database Management System (DBMS): A Comprehensive Overview, Exercises of Database Management Systems (DBMS)

Đây là tài liệu về topic database ,mô tả các thành phần của database

Typology: Exercises

2020/2021

Uploaded on 11/09/2021

Ha-Hoc
Ha-Hoc 🇻🇳

1 document

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Components of databasemanagement system
With each component of DMBS, the database management system is understood as software
for creating database and retrieving tools.
Organizations use dbms (database management system) in managing to maximize the
efficiency of their data and get relevant information from it.#DBMS is a technology tool that
directly supports the management of data.#It is a package designed to identify or manipulate
and manage data in a database.
We can DBMS into the main parts as follows, which are:
1.Hardware
2.Software
3. Data
4.Procedures
5.Language access database
6.User
Now we go deep and every component of DBMS
I.Hardware
- These components are programs used to control and manage the overall database.
Hardware usually refers to all the things that can be seen and touched.#Includes PCs, their
storage devices, etc.: such as Hard Drives, inputs
(includingkeyboards,#mice,#scanners...)#and output (audio equipment...)#.#All of this helps
the computer to have a link between itself and reality.#It would not be feasible to deploy
DBMS in the absence of hardware equipment.
We see that, when running Oracle or MySQL on our personal computer, the hard disk of the
computer, the keyboard we often use to type all the commands, RAM, ROM of the computer
becomes part of dbms hardware.
II.Software
This is the main component, since this is the program that controls everything.
pf3
pf4

Partial preview of the text

Download Components of a Database Management System (DBMS): A Comprehensive Overview and more Exercises Database Management Systems (DBMS) in PDF only on Docsity!

Components of database management system

With each component of DMBS, the database management system is understood as software for creating database and retrieving tools. Organizations use dbms (database management system) in managing to maximize the efficiency of their data and get relevant information from it. DBMS is a technology tool that directly supports the management of data. It is a package designed to identify or manipulate and manage data in a database. We can DBMS into the main parts as follows, which are: 1.Hardware 2.Software

3. Data 4.Procedures 5.Language access database 6.User Now we go deep and every component of DBMS I.Hardware

  • These components are programs used to control and manage the overall database. Hardware usually refers to all the things that can be seen and touched. Includes PCs, their storage devices, etc.: such as Hard Drives, inputs

(includingkeyboards, mice, scanners...) and output (audio equipment...). All of this helps

the computer to have a link between itself and reality. It would not be feasible to deploy DBMS in the absence of hardware equipment. We see that, when running Oracle or MySQL on our personal computer, the hard disk of the computer, the keyboard we often use to type all the commands, RAM, ROM of the computer becomes part of dbms hardware. II.Software This is the main component, since this is the program that controls everything.

  • DBMS software is like a membrane block wrapped around a physical database, which supports us with an easy-to-use interface for storing, accessing and updating data.
  • Physical electronics such as PCs, storage devices, etc. this provides an interface between the PC and the actual system.
  • Here it is capable of understanding the language of accessing databases and interpreting it into actual database commands to execute them on DB.
  • Although the most easily identifiable software is DBMS itself, to make the database system fully operational, there are three types of software: operating system, DBMS and application programs and utilities.  Operating system:
  • It manages all the hardware and makes others run on the computer.
  • It is also responsible for executing data to allocate resources. Example: Windows 10 - 11, Linux, MacOS, UNIX and MVS.  DBMS:
  • It refers to the database in the database system. Example: Microsoft SQL Server  Application programs and utilities
  • Refers to the fact that it is used to aggregate and guide the access and manipulation of data in DBMS and to ensure that access and manipulation of data are conducted normally on the computer.
  • It is most commonly used to access data found in databases to create reports or statistical tables to facilitate decision-making for convenience.
  • Utilities are software tools that help manage the computer components of a database system. III.Data
  • Of the components, this component can be considered the most important of the

database management system. Without this component, having DBMS would be

unnecessary because the main purpose of DBMS is to process the input data.

  • Databases are identified, built, and ultimately data is stored, updated, and retrieved to and from the database.
  • It contains activity data as well as metadata. This shows how important data is as a component of DBMS. IV.Procedures
  • It refers to the guidelines, as well as the rules that support how to use DBMS, which helps design and run databases, dbms managers need the procedures written down about the instructions to operate and manage it.
  • Individuals who interact with DBMS perform various activities on the database including: creating, updating, reading, and deleting records.
  • As well as other components "Users" are also important for DBMS. Each user type, described below, performs both unique and additional functions.