Whenever we complete a task or prepare a report, we inevitably rely on one of our most valuable resources: data. Today, as we enter a data-driven generation marked by the rapid growth of data volumes and the increasing need to manage information on a large scale, traditional manual archiving methods, such as storing files on flash drives, are no longer considered reliable. These methods come with several limitations, including the risk of data inconsistency, weak security and data recovery mechanisms, and vulnerability to human error, particularly the duplication of unnecessary or redundant data.

To overcome these limitations, Database Management Systems (DBMS) were developed as a more structured approach to managing and organizing data. In essence, a DBMS is a system designed to manage and organize data within a database. It enables users to access and retrieve data based on specific criteria through queries, while also supporting data tracking through history tables and audit logs. In practice, DBMSs are divided into several models that can be selected according to the required scalability and intended use.

1. RDBMS (Relational Database Management System)

RDBMS is one of the most widely used DBMS models across various industries. Fundamentally, an RDBMS manages data using a relational structure, where information is organized into tables and connected to one another through primary keys and foreign keys.

We can think of an RDBMS as a system in which a pointer directs us to a specific piece of information within a structured data framework. This relational approach allows data from different tables to be connected and accessed efficiently. Some commonly used examples of RDBMS platforms today include PostgreSQL, Oracle, and MySQL.

2. OODBMS (Object-Oriented Database Management System)

At first glance, OODBMS may appear to operate similarly to an RDBMS. However, the key difference lies in how data is stored and represented. While an RDBMS stores and manages data primarily in separate tables, an OODBMS stores data as complete objects, including their attributes, processing functions, and methods or behaviors. Each object is identified through a unique identifier known as an Object ID.

In simple terms, an OODBMS can be compared to a burger served as one complete unit, rather than Nasi Padang served as separate components. The data and the functions associated with an object are packaged together as a single entity.

OODBMS platforms can be found in systems such as ObjectDB and Versant. Because they integrate data and its associated objects into a single structure, OODBMSs are often applied in relatively complex fields, including video game development and manufacturing engineering, such as applications involving AutoCAD.

3. HDBMS (Hierarchical Database Management System)

Unlike an RDBMS, which allows users to retrieve data based on specific keys, an HDBMS (Hierarchical Database Management System) organizes and accesses data according to a hierarchical structure.

An HDBMS essentially relies on a parent-child relationship, where each database has a parent that serves as the central data point, along with several children that branch out from it. Although this structure may appear somewhat similar to an RDBMS, an HDBMS requires users to navigate through the established hierarchy to reach specific branches of data.

Because access follows a predetermined hierarchical path, HDBMSs are generally considered less flexible than RDBMSs. However, this structure can still be useful for applications where data naturally follows a clear parent-child relationship.

As data continues to evolve and change every second, it is important for us to understand how different data management models work and how to choose the right one based on personal or industry-specific needs. For Kawan UNDIRA who are interested in exploring the world of database management and software development, the Software Engineering concentration within the Informatics Engineering Program at Universitas Dian Nusantara (UNDIRA) can be an excellent place to start.

In a data-driven era, the future does not belong only to those who possess data, but also to those who are capable of building the systems behind it. So, do not simply become a user of technology. Be one of the people who build it, and start with the fundamentals together with Software Engineering at UNDIRA!