Home / Computer / Understanding RDBMS With Functions and Differences with DBMS

Understanding RDBMS With Functions and Differences with DBMS

In this era of digitization, the term database is no longer an alien thing to be heard. Because, the database has influenced all areas of human life. Not only companies that use databases the government even up to education also utilize the use of databases. With the database, you do not need a long time to look for an outdated document.

The technology used to process the database continues to evolve. It happens because the human need to process the existing data into a very useful information. Currently, relational databases become one of the most commonly used technologies for processing databases. This relational database creates tables into components for storing data from an object which then the table is connected to another table through a key that belongs to each table called the primary key. Primary key is linked to the second table so that the second table becomes a foreign key.

There are several concepts for relational database processing, including hierarchical models, network models and RDBMS Relational Database Management System . However, up to now the concept of RDBMS has become a popular and widely used concept by users. The concept of RDBMS is a simple concept in which data is presented into two dimensional tables, consisting of rows (tuples) and columns (attribute).

In this article, the author will discuss and explain in more detail the definition of RDBMS, the function and the difference of RDBMS with DBMS. (19659006) The definition of RDBMS is ” width=”256″ height=”256″ />

As it is well known that in the relational model, a database is built with many tables. A table consists of columns and comes with rows that are data or content. However, in processing an integrated database requires a concept to link the table to one another through the key. That is what is called the RDBMS ( Relational Database Management System ).

The concept of RDBMS is a system that supports relationships or relationship between tables in a database. Each table has a key called the primary key to connect to the next table that has a foreign key.

RDBMS has been widely used by various vendors since the 1970s. Along with the development of RDBMS advantages, many companies initially used the hierarchical and network model to switch to the RDBMS model. Because, this model is easy to use and understand. Initially this model is only used by large companies, but now there are many types of databases that implement the RDBMS model in it, such as Microsoft Access, MySQL SQL Server, Oracle, PostgreSQL, OpenOffice Base and FoxBase.


 RDBMS Function

Basically, relational databases are a type of database maintained by RDBMS ( Relational Database Management System ). Where relational databases refer to the storage of structured data into table forms, using rows and columns. While the RDBMS itself refers to on the system how the database keeps the data consistent.

The basic functions of RDBMS are related to creating multiple tables in a single database, reading data contained in the database, updating the database structure, and remove structures that are no longer needed in the database. In other words, RDBMS has a basic function known as CRUD ( Create Read Update and Delete ). [19659002] Typically, RDBMS provides data dictionaries and metadata used to handle data. That's what causes RDBMS has a function to make relationships (relationships) data between tables to be well defined. The relationship occurs because the assignment of a key called the primary key in the first table to be connected to the second table that has a guest key (foreign key). In addition, RDBMS also has a function to prevent duplication of data or data repeatedly and can be used to build a complex database.

Differences of RDBMS and DBMS

Although the notion of RDBMS , there is still the opinion that RDBMS and DBMS have the same function. Many people assume that RDBMS and DBMS have a function to store information from a database. Though the two terms are different. Therefore, RDBMS is not just presenting data as a collection of rows and columns but also creating the integrity that the database generates.

The main difference between RDBMS and DBMS is that RDBMS stores data in the form of tables consisting of columns and rows. Is there a table in the DBMS? May be in the DBMS has tables, but the table has not been related to one another. With the RDBMS, the data contained in one table can be linked to other tables. In the DBMS, data is usually presented in a hierarchical or network model. That is the limitations of the hierarchical model because it can not accommodate many problems in a database. Unlike the RDBMS, where the data stored in the table has an identifier key called the primary key. The value of the primary key is stored in the table. That way, data is easy to access and update by system. In addition, RDBMS can also accommodate many logical problems in the database

Given the primary key or primary key contained in a table it will prevent the occurrence of data redundancy. That's what the RDBMS has. RDBMS provides a normalization process. While in the DBMS, normalization is not done because there is no key that distinguishes it

RDBMS is specifically designed to handle large data and has many users, while the DBMS is only able to handle small data with a limited number of users. Thus, RDBMS implements security, such as ACID ( Atomicity Consistency Isolation and Durability ) to improve the integrity of a database. [19659002] That is the full explanation of the definition of RDBMS, its function along with the difference of RDBMS with DBMS. Although it can be said that RDBMS is a development of DBMS which still has many weaknesses. The authors hope the above article can help you understand the RDBMS and be able to distinguish the term RDBMS with DBMS.


Check Also

LG G8 teased to get touchless interaction, but what does that mean?

LG has teased an alternative to touch input for an upcoming device. The teaser video …

%d bloggers like this: