Database Management System
A database management system is a collection of computer software which forms the interface between users and databases. It gives us the provision to analyze the data using software applications. In simple words we can say that D.B.M.S is a collection of interrelated data with a set of programs to access the data, also called database system, or simply database.
The primary goal of such system is to provide an environment that is both convenient and efficient to use in retrieving and storing information. Basically D.B.M.S software are designed to manage a large body of information. Data system involves both defining structures for storing information and providing mechanisms for manipulating the information.
Example of the use of database system include airline reservation system, banking system,etc…..
Major purpose of database system is to provide users with an abstract view of the data. The overall structure of the database is called the database schema. The schema specifies data, data relationships, data semantics, and consistency constraints on the data.
A suite of programs which typically manage large structured sets of persistent data, they are widely used in business applications. database can be extremely complex set of software programs that controls the organisation, storage and retrieval of data in a database. the D.B.M.S accepts requests for the data from the application program and instructs the operating system to transfer the appropriate data. System for quick search and retrieval of information from a database. D.B.M.S determines how data are stored and retrieved. It must address problems such as security, accuracy, consistency among different records, response time, and memory requirements. D.B.M.S allows its users to create their own databases as per their requirement.
Why D.B.M.S is important ?
A database management system is important because it manages data efficiently and allows users to perform multiple tasks with ease…Database management systems are important to business and organizations because they provide a highly efficient method for handling multiples types of data.
It allows users to perform multiple tasks with ease. It stores, organizes and manages large amount of information within a single software application. Use of this system increases efficiency of business operations and reduces overall costs.
Database are very much important in business field because they provide a highly efficient method for handling multiple types of data. Some of the data are easily managed with this type of system include: employee records, employee details, etc without database management, tasks have to be done manually and take more time. Data is entered into the system and accessed on a routine basis by assigned users.
What is the role of D.B.M.S ?
A D.B.M.S plays a crucial role in both the creation and management of data. Without a database management system, running and managing data effectively is not possible. Serving as the intermediary between the users and the database, a D.B.M.S provides users access to files stored in a database. system has a collection of programs which manages the database structure and controls access to the data stored in the database.
Advantage of Database System
The benefits of a database management system include its ability to handle huge volumes of data and multiple concurrent users. Although the database system yields considerable advantages over previous data management approaches.
⦁ Improved data sharing.
⦁ improved data security.
⦁ better data integration.
⦁ minimized data inconsistency.
⦁ improved data access.
⦁ improved decision making.
⦁ increased end-user productivity.
Disadvantage of Database System
Although the database system yields considerable advantages over previous data management approaches, database systems do carry significant disadvantages.
⦁ increased costs.
⦁ management complexity
⦁ maintaining currency.
⦁ Frequent upgrade / replacement cycles.
D.B.M.S is system software for creating and managing databases. the D.B.M.S provides users and programmers with a systematic way to create , retrieve, update and manage data. it makes it possible for end users to create, read, update and delete data in a database.