Database Management Basics

maio 16, 2023

Database management is a system for managing information that aids an organization’s business operations. It includes data storage and distribution to users and application programs and then modifying it if necessary, monitoring changes in the data and preventing it from being corrupted 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 like the GDPR and the California Consumer Privacy Act.

The first database systems were created in the 1960s by Charles Bachman, IBM and others. They developed into information management systems (IMS) which allowed huge amounts of data to be stored and retrieved for a variety of reasons. From calculating inventory, to supporting complex financial accounting functions and human resource functions.

A database is tables that store data according to some pattern, for example, one-to-many relationships. It utilizes primary keys to identify records and permit cross-references between tables. Each table contains a set of attributes, or fields, which provide information about data entities. The most widely used type of database that is currently in use is a relational model developed by E. F. “Ted” Codd at IBM in the 1970s. This model is based upon normalizing the data, making it more easy to use. It also makes it easier to update data by avoiding the need to modify various databases.

Most DBMSs support multiple types of databases through different levels of external and internal organization. The internal level is concerned with cost, scalability, as well as other operational issues like the physical layout of the database. The external level focuses on how the database appears in user interfaces and other applications. It could include a mix of various external views (based on different data models) and may include virtual tables that are computed from data that is generic to enhance performance.

Deixe um comentário