DBMS is software used to manage and operate programs and data requested by many users. Because of this, you need to know DBMS if you want to be a developer, a data analyst, or even a programmer.
Definition of DBMS
DBMS stands for Database Management System. Then what is the database? A database is a collection of information stored in a computer and then processed with specific commands.
Meanwhile, the definition of DBMS is a system or software designed to connect databases with users so that data can be appropriately processed. There are at least two languages commonly used in database programming: Database Definition Language (DDL) and Database Manipulation Language (DML).
Database Definition Language (DDL) is the overall database design that allows the creation of new tables, specified indexes, and many other everyday database activities.
Meanwhile, Database Manipulation Language (DML) is a language used to manipulate the collection of data available in the database, such as deleting and summing data.
Read Also About Fundamentals of Front End and Back End Development
DBMS example
DBMS is beneficial in everyday life. If it can be used correctly, it can provide excellent benefits for its users. Some examples of DBMS implementation are as follows:
- Library management system
- Automatic system on the cash register
- Data recovery on computer
- Flight ticket reservation system
- Spare parts recording system
DBMS function
Various DBMS functions are interesting for you to know so that you can use the it properly, friend. Some DBMS functions are:
- Defining and processing data
- Handle various user requests to manage and access data
- Handling data security and integrity
- Handle and monitor data updates
- Control access to data that is done together
- Supervision of database backups and restoration of database backups from errors
- Shows data dictionary
- Processing and accessing data as efficiently as possible
DBMS type
The DBMS extension mentioned earlier certainly makes you even more curious to find out what types of database processing systems this is. The following are some examples of DBMS types:
Hierarchical database
A hierarchical database or hierarchical form database is a database in which the work system uses a hierarchical data form, that is, with a parent and child relationship structure.
So, each database group will have its respective mothers and children. An example of data processing of this type is IMS-2 (Information Management System) in 1968 by IBM.
Network database
A network database is a derivative of a hierarchical database. It is because this network structure will form the entities in it. In the following database, each mother and child may have a relationship with more than one other entity. IDMS (Integrated Database Management System) 1972 by Cullinet Software is an example of a network database.
Relational database
The processing in this database is done by grouping data relationships. To operate a relational database, such as adding, subtracting, deleting, and manipulating data, users need to use Structured Query Language (SQL).
This database is often used because there is an ease in integrating data between one another. Examples of database processing are DBASE II by Ashton-Tate, 1981; ORACLE by Relational Software Inc., 1979; system-r by IBM Research, 1975; and INGRE by UN of CA & Relational Tech., 1973.
DBMS advantages and disadvantages
There are various advantages and disadvantages of DBMS that you should know. This can be your consideration, so you can think carefully about whether you need to use it.
Advantages of DBMS
- Reducing data repetition
- Can retrieve some data and information quickly
- Improve data security
- Balancing various needs and comparing them with economies of scale
- The data provided is consistent
- Faster recovery of damaged data
- Facilitate decision making
Disadvantages of DBMS
- The software that applies to the majority is expensive
- The hardware configuration is quite large
- The usage is complex
- There are various additional costs, depending on the function and needs
- Performance degrades over time
- Have to update frequently
Sagara Technology so well summarizes the definition of an effective DBMS. Its existence of it is essential for the data management of businesses. Similarly, if you own a business, database management will significantly assist you in determining the business’s performance.