Database Management Basics

Database management is a method for managing the data that a company needs to run its business operations. It involves storing and distributing data it to applications and users making edits as needed and monitoring changes to data and making sure that data integrity is not compromised due to unexpected failure. It’s a component of a company’s informational infrastructure, which supports decision-making and growth of the company 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 developed into information management systems (IMS) which allowed for the storage and retrieve large amounts data for a variety of uses, from calculating inventory to supporting complex human resources and financial accounting functions.

A database is a collection of tables that store data according to an established pattern, such as one-to-many relationships. It uses the primary key to identify records and allow cross-references among tables. Each table has a set of fields, known as attributes, that provide information about the data entities. Relational models, which were developed by E. F. “Ted” Codd in the 1970s at IBM and IBM, are the most popular database type today. This model is based on normalizing the data, making it simpler to use. It is also simpler to update data since it doesn’t require the modification of several databases.

Most DBMSs support multiple types of databases through different levels of external and internal organization. The internal level deals with cost, scalability and other operational issues including the design of the database’s physical storage. The external level is the way the database appears in user interfaces and other applications. It can include a mixture of different external views that are based on different models of data and could include virtual tables that are computed with generic data to enhance the performance.