Who among you is a programmer? Of course, you are already familiar with this term. DBMS is a term related to the database that will be used by the user.
user who is a programmer must of course work to do several things such as changing data, deleting data, and so on.
To do this, the DBMS exists as a visual intermediary that can make the job easier.
What is a DBMS and what is its function, as well as what are the advantages and disadvantages of this database system, here is a full review.
What is DBMS?
database management system or DBMS is a software designed to connect databases with users, so that data management can proceed properly.
According to its understanding, DBMS is a system that functions as a database engine, database schema, and data management so that the organization and management process can also run smoothly.
DBMS can also be interpreted as a visual intermediary needed to make reading, organizing, updating, and deleting data that have been stored in the database easier.
When you want to operate a DBMS, the user must use a computer language that is in accordance with the related system. There are two types of computer languages that are recommended, in order to communicate through the DBMS, namely:
- Data Manipulation Language, this language is generally used for a command that will manipulate data in the database. This command is shaped like data retrieval, changing data, deleting data and also adding data
- . Data Definition Language, this language is used to change and create the structure of an object in the database such as index, table, views, schema and so on.
In addition to these two languages, one other programming language that is indeed used in databases is SQL (structure query language).
Functions of DBMS
As a database management, DBMS has several functions, namely:
Accelerating Data Access
The first function is to speed up data access and enable users to obtain the results of their queries accurately and quickly.
This database management system can certainly increase work productivity related to databases.
Reducing the occurrence of Data Inconsistencies
The next function of DBMS is inconsistencies that occur in a file that is in several places at once. Its role is to ensure that the data that has been stored is in the form of a new version.
For Data Security, the
database must be secure, so that it can run properly. User authorization settings must be facilitated with an access authorization feature by using a password and username.
A database usually has a large scope of information, and is stored in the form of documents and tables. DBMS is an information that is located along with the relationship of that information.
To Improve Data Integrity
In a DBMS, a database management must be ensured that it is accurate and consistently well structured. The existence of a database management system, ensures that the data is more structured and consistent.
DBMS is a system that can function as data backup. This is very useful for preventing the loss of important data. The system has automatically prepared a backup of the data.
Improving Data Integrity
DBMS is a system of multiple databases that can be accessed by the user. So the level of consistency and accuracy of the data is absolute. This data management system will keep all data organized consistently.
Defining Data and Its Relationship
This database already has a large scope of information and is stored in the form of a document or a table. DBMS can assist in defining information related to the document.
Types of DBMS
After knowing some of the functions of the database management system or DBMS, the next step is to know the types of DBMS. The following is an explanation:
The first type of DBMS is Hierarchical Database or hierarchical database. The data management is connected like a parent-child structure.
This database also stores information about mothers and children in a group. Examples of several types of Hierarchical databases are RDM Mobile, XML and XAML, Windows Registry and so on.
The second type is a database in the form of a network structure between entities. This seems to be an instance of Hierarchical database, but can have relationships with one other entity. Examples of network databases such as IDS ( Integrated Data Store), IDMS (integrated data management system), TurboIMAGE and so on.
Next is RDBMS or relational DBMS which is a relational relationship and stores data in the form of tables with columns and rows.
Where, column part will be filled by attribute, and row will be filled by data record. To run it, such as deleting, and manipulating data must use SQL.
Advantages and Disadvantages of DBMS
As a system, DBMS is a database system which of course has advantages and disadvantages in its performance. The following is an explanation:
The advantage of DBMS is that it is
quality of data sharing, where users can easily access data neatly
. the quality of the data information, thus influencing the decisions taken.
Disadvantages of DBMS are
operational costs, in hardware and software configurations that are quite complicated, need to be handled by skilled workers and have certain skills. Operational costs will be required in this case.
If an organization chooses to use a DBMS, it requires a system capable of managing all aspects of the database, technical and non-technical.
Update frequency, new features will always be updated for this DBMS, the latest features are also sold separately and sometimes must be balanced with hardware updates as well.
Studying a DBMS or database management system does take time. Especially for those of you who are studying and want to become a developer or programmer.
It’s good, to understand how it functions, its types, and also its application from database . database is a collection of important information about various kinds of data, including financial data. Financial databases are needed in the use of accounting and business software to create financial reports.