Database Management Basics

Database management is a system for managing data that supports the company’s business operations. It involves storing data and distribution to users and application programs and modifying it as needed and monitoring the changes in the data and preventing the data from becoming damaged by unexpected failures. It is one component of a company’s overall informational infrastructure, which supports decision-making and growth for the business as well as compliance with laws such as 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 evolved into information management systems (IMS), which allowed large amounts data to be stored and retrieved for a variety of purposes. From calculating inventory to supporting complex financial accounting functions as well as human resource functions.

A database consists of a set of tables that arrange data according to a particular pattern, for example, one-to-many relationships. It makes use of primary keys to identify records and permits cross-references between tables. Each table has a collection of attributes or fields that contain information about data entities. Relational models, developed by E. F. “TedCodd Codd in the 1970s at IBM as a database, are the most popular database type in the present. This design is based upon normalizing data to make it more user-friendly. It also makes it simpler to update data since it eliminates the need to modify several databases.

Most DBMSs can accommodate multiple types of databases through different levels of internal and external 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 on user interfaces and applications. It could comprise a combination of various external views (based on different data models) and can also include virtual tables that are created from generic data in order to improve performance.