What is Database Management System?
DBMS – Database Management System is a computer software application and a software package that is designed to define, manipulate, retrieve and manage data. It is also a management system that interacts with end-users, other applications, and the database itself to capture and analyze data.
What is the purpose of using DBMS?
Database Management Systems offer solutions to problems related to data redundancy and inconsistency that arises due to the scattering of data in various files with various formats that were built using file systems.
Problems of a file-based system could be length development, difficulty in getting quick answers, complex system administration, lack of security, extensive programming, limited data sharing, structural dependence and more. DBMS came into existence to solve these problems which earlier was faced by developers when they used traditional file-processing system.
DBMS offers easy solutions by removing redundancy by data normalization, accessing data is much simpler and flexible ways as per the needs.
How did it start – History?
DBMS was first designed by Charles Bachman at GE and came into existence in early 1960 and was called as IMS which was developed on IBM 360, it was originally written for the Apollo program.
1970 – Edgar Codd proposed a new approach to database construction, through which Relational DBMS was created.
1980 – The age where the desktop computing ushered the market. There was also the introduction of object-oriented DBMS.
1990 – The new object-oriented approach emerged with relational DBMS, where text, internet, web and multimedia use in conjunction with DBMS were made available and possible.
2000 – Database applications continue to grow with introductions to new interactive applications that were developed for PDAs, point-of-sale transactions and more. Microsoft, IBM, and Oracle being the three leading database companies in the world.
Why is DBMS important for your business?
While thousands of companies are taking advantage of the software, it is important because it manages data efficiently and allows users to perform multiple tasks with ease.
Database management system is a pool of information that stores, organizes and manages a large amount of information within a single software application
Today companies rely on an accurate recording, updating and tracking of their data every minute and certainly DBMS play a major role in several ways from Employees being able to use this data to complete accounting reports, calculate sales estimates and invoice customers and many more. It is available for access through a computerized database.
It is a proven method for Data Access, Data updating, Data relationships and Data searches.
Pros and Cons of using DBMS over file system.
Pros of DBMS:
- Flexibility – Data are independent making it easy for programmers.
- Fast response to information requests – Rapid access to complex requests as the data can be integrated into a single database.
- Easy and Multiple access – Data can be accessed in variety of ways through several programming languages.
- Lower user training costs
- Less storage
- No redundant data
- Data Consistency and Integrity
- Privacy – Limited access
- Secure – Each user has a different set of access
- Easy recovery
Cons of DBMS:
- DBMS implementation is of high in cost when compared to the file system.
- They are subject to risk and critical data loss.
- Security issues may arise if a weak password is used.
- Database systems are complex to understand.
- Performance: Though DBMS systems are suitable for various applications, some feature affect regarding performance for some of the applications
Some of the major DBMS Software systems.
- Oracle RDBMS
- Microsoft SQL Server
- IBM DB2
- SAP ASE (Sybase)
- Microsoft Access