January 28, 2020
Amitraj
What is Database System ?
The database and DBMS software together is called as database system.
Purpose of the Database System -
-> It is a collection of programs that enables the user to create and maintain a database. In other words, it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.
-> Database systems are designed to manage large bodies of information. Management of data involves both defining structures for storage of information and providing mechanisms for the manipulation of information. In addition, the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results.
-> The major purpose of a database system is to provide users with an abstract view of the system. The system hides certain details of how data is stored and created and maintained complexity should be hidden from database users.
Types Of Database System -
The DBMS can be classified according to the number of users and the database site locations. these are:
On the basis of number of users -
1. Single-user DBMS
2. Multi-user DBMS
On the basis of site location -
1. Centralized DBMS
2. Parallel DBMS
3. Distributed DBMS
4. Client / Server DBMS
Application or Function of DBMS -
-> Banking: all transactions
-> Airlines: reservations, schedules
-> Universities: registration, grades
-> Sales: customers, products, purchases
-> Online retailers: order tracking, customized recommendations
-> Manufacturing: production, inventory, orders, supply chain
The database and DBMS software together is called as database system.
Purpose of the Database System -
-> It is a collection of programs that enables the user to create and maintain a database. In other words, it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.
-> Database systems are designed to manage large bodies of information. Management of data involves both defining structures for storage of information and providing mechanisms for the manipulation of information. In addition, the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results.
-> The major purpose of a database system is to provide users with an abstract view of the system. The system hides certain details of how data is stored and created and maintained complexity should be hidden from database users.
Types Of Database System -
The DBMS can be classified according to the number of users and the database site locations. these are:
On the basis of number of users -
1. Single-user DBMS
2. Multi-user DBMS
On the basis of site location -
1. Centralized DBMS
2. Parallel DBMS
3. Distributed DBMS
4. Client / Server DBMS
Application or Function of DBMS -
-> Banking: all transactions
-> Airlines: reservations, schedules
-> Universities: registration, grades
-> Sales: customers, products, purchases
-> Online retailers: order tracking, customized recommendations
-> Manufacturing: production, inventory, orders, supply chain
