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
   204   205   206   207   208   209   210   211   212   213   214