Skip to main content

Database Management Basics

By May 16, 2023Uncategorized

Database management is a system of managing the information that is used to support a company’s business operations. It involves storing data, distributing it to users and applications and then modifying it if necessary, monitoring changes in the data and preventing it from getting damaged due to unexpected failure. It is a part of a company’s overall informational infrastructure that supports decision-making and growth of the company 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 evolved into the information management systems (IMS) which enabled the storage and retrieve large amounts of information for a range of applications, from the calculation of inventory to supporting complex human resources and financial accounting functions.

A database is a collection of tables that organizes data according to a certain scheme, like one-to many relationships. It utilizes primary keys to identify records and allows cross-references between tables. Each table is comprised of a set of attributes, or fields, which provide information about data entities. The most well-known type of database that is currently in use is a relational model, designed by E. F. “Ted” Codd at IBM in the 1970s. This model is based on normalizing data to make it easier to use. It also makes it simpler to update data since it eliminates the necessity of changing different sections of the database.

Most DBMSs can support multiple types of databases by offering different internal and external levels of organization. The internal level deals with costs, scalability, and other operational concerns including the design of the database’s physical storage. The external level is the representation of the database in user interfaces and applications. It could include a mix of external views based on different data models. It can include virtual tables that are calculated using generic data to improve the performance.

Leave a Reply