Skip to main content

Database Management Basics

By 17.5.2023No Comments

Database management is a method for managing the data that is used to support a company’s business operations. It involves storing data, disseminating it to users and applications making edits as needed and monitoring changes to data and stopping data corruption due unexpected failure. It is one component 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.

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

A database consists of tables that are organized according to some schema, such as one-to many relationships. It uses the primary key to identify records, and also allows cross-references among tables. Each table is comprised of a set of fields called attributes which provide information about data entities. The most well-known type of database currently is a relational model created by E. F. ”Ted” Codd at IBM in the 1970s. This design is based on normalizing the data, making it simpler to use. It also makes it simpler to update data since it eliminates the necessity of changing various databases.

Most DBMSs support multiple types of databases through different levels of internal and external organization. The internal level addresses cost, scalability and other operational issues like the layout of the physical storage. 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 the various data models) and can also include virtual tables that are created using generic data to improve performance.