Page 209 - IT_V1.0_Class10
P. 209
In a database, data can be accessed by multiple users simultaneously. This not only saves storage space
but also ensures accessibility for all authorised users that promotes collaborative work environments.
Databases provide robust data protection and features such as recovery and backup, facilitating easy data
retrieval.
Database can scale to handle increasing amounts of data and users without significant performance
degradation, ensuring long-term reliability and flexibility.
Data stored in a database remains permanent until it is manually deleted from the system or server that
ensures data persistence.
Do you know?
LibreOffice Base is a cross-platform application. It runs on Windows, macOS, and Linux operating systems.
DATABASE MANAGEMENT SYSTEM (DBMS)
A database management system is a software package that controls the creation, maintenance and use of a
database. It allows organisations to develop databases for various applications according to their needs. A
database is defined as an integrated collection of data records, files and other objects. DBMS enables users
to store, modify and maintain the database properly. It also helps the users to extract useful information from
the database as and when required.
Notes
A DBMS is a computerised record-keeping system whose purpose is to manage the data and make it
available as per the requirement. Database can be referred to as a digital filing system.
DBMS is designed to store, handle and process the information. It manipulates different types of information
in such a way that it helps to analyse the data and thus help in decision-making.
A DBMS performs the tasks of maintaining databases so that information is readily available. It helps to
manage the data of different sectors like banks, corporates, railways, airlines, universities, hospitals, space
exploration, etc.
A DBMS is used to build the database and also manage the databases in different ways like:
Adding new records (appending)
Editing (changing/modifying the existing data)
Deleting (removing unwanted data)
Sorting (arranging in an order [ascending/descending])
Extracting the data based on queries
Updating and manipulating data items
Viewing data and generating reports
Performing calculations on it, etc.
A DBMS allows various user application programs to simultaneously access the same database. Most popular
DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, SQLite,
LibreOffice Base, etc.
Introduction to Database Management System 207

