Database Management Basics


Database management is a system for managing the data that is used to support a company’s business operations. It involves storing and distributing data it to applications and users and editing it when needed and monitoring changes to data and protecting against data corruption due to unexpected failure. It is a part of an organization’s overall informational infrastructure that aids in 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 among others came up with the first database systems. They developed into information management systems (IMS), which allowed large amounts of data to be stored and retrieved for a range of reasons. From calculating inventory, to aiding complex financial accounting functions and human resource functions.

A database consists of a set of tables that arrange data according to a certain arrangement, like one-to-many relationships. It utilizes primary keys to identify records, and allow cross-references between tables. Each table has a collection of fields called attributes that represent facts about data entities. The most widely used type of database currently is a relational model developed by E. F. “Ted” Codd at IBM in the 1970s. This design is based on normalizing data to make it easier to use. It also makes it simpler to update data by avoiding the need to madeindominican.com modify various databases.

The majority of DBMSs are able to support various types of databases, by providing different levels of internal and external organization. The internal level focuses on costs, scalability, and other operational issues such as the layout of the database’s physical storage. The external level is the representation of the database in user interfaces and applications. It can include a combination of different external views (based on the various data models) and could also include virtual tables that are computed from data that is generic to enhance performance.