Database Management Basics

Database management is a method for managing the data that supports a business’s operations. It involves storing data and distribution to users and applications and then modifying it if necessary and monitoring changes to the data and preventing it from being damaged due to unexpected failure. It is an element of a company’s overall informational infrastructure, which supports decision-making, corporate growth and compliance with laws such as the GDPR and the California Consumer Privacy Act.

In the 1960s, Charles Bachman and IBM along with others created the first database systems. They developed into information management systems (IMS) which made it possible to store and retrieve large amounts of data for a wide range of applications, from the calculation of inventory to supporting complicated human resources and financial accounting functions.

A database is tables that store data according to some schema, such as one-to many relationships. It utilizes primary keys to identify records and allows cross-references between tables. Each table has a collection of attributes or fields that contain information about data entities. The most well-known type of database currently is a relational model, developed by E. F. “Ted” Codd at IBM in the 1970s The concept is based on normalizing data to make it more user-friendly. It also makes it easier to update data, avoiding the need to modify several databases.

The majority of DBMSs support a variety of databases by providing different internal and external levels of organization. The internal level is focused on the cost, scalability, and other operational issues, such as the physical layout of the database. The external level is the way the database is represented in user interfaces and other applications. It can include a combination of different external views (based on the various data models) and may also include virtual tables that are computed from data that is generic to enhance performance.