Database Management Basics

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

In the 1960s, Charles Bachman and IBM among others developed the first database systems. They developed into information management systems (IMS) which allowed the storage and retrieve massive amounts of data for a variety of purposes, from calculating inventory to supporting complex human resources and financial accounting functions.

A database consists of a set of tables that organize data in accordance with a specific arrangement, like one-to-many relationships. It makes use of primary keys to identify records and allow cross-references between tables. Each table has a variety of fields, referred to as attributes, which provide information about the entities that comprise the data. The most popular kind of database is a relational model, created by E. F. «Ted» Codd at IBM in the 1970s. This design is based on normalizing the data, making it more easy to use. It also makes it simpler to update data by avoiding the need to modify several databases.

Most DBMSs can accommodate different types of databases by offering different levels of external and internal organization. The internal level addresses costs, scalability, and other operational concerns such as the design of the database’s physical storage. The external level is the representation of the database in user interfaces and applications. It can include a mixture of different external views that are based on different data models. It could include virtual tables that are calculated using generic data to enhance the performance.

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Carrito de compra