Database Management Basics

Database management is a system for managing the data that supports a business’s operations. It includes data storage, distributing it to users and application programs and modifying it as needed, monitoring changes in the data and preventing it from being corrupted due to unexpected failure. It is an integral part of the entire informational infrastructure of a company which supports decision-making and corporate growth as well as compliance with laws like the GDPR and the California Consumer Privacy Act.

In the 1960s, Charles Bachman and IBM along with other companies developed the first database systems. They evolved into information management systems (IMS), which allowed large amounts data to be stored and retrieved for a variety of purposes. From calculating inventory, to aiding complex financial accounting functions and human resource functions.

A database is a collection of tables that arrange data in accordance with a specific pattern, such as one-to-many relationships. It utilizes primary key to identify records, and also allows cross-references between tables. Each table is comprised of a variety of fields, known as attributes, that contain information about the entities that comprise the data. The most widely used kind of database is a relational model, developed by E. F. “Ted” Codd at IBM in the 1970s. This design is based upon normalizing data to make it simpler to use. It also makes it easier to update data without the need to update different sections of the database.

The majority of DBMSs support a variety of databases and offer different internal and external levels of organization. The internal level concerns cost, scalability, as well as other operational issues like the physical layout of the database. The external level is the way the database is represented in user interfaces and other applications. It could include a mix of various external views (based on different data models) and may also include virtual tables that are computed using generic data to improve performance.

Leave a Comment

websdesain Adalah Industri kreatif yang membantu bisnis ukm dan profesional untuk berkembang di dunia online.


Webs Desain Solution

Jl. Poncol Jaya No.73
RT.12 / RW.4, Kuningan Barat, Mampang Prapatan, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12710 – Indonesia