Database Management Basics

Share on facebook
Share on pinterest
Share on twitter

Database management is a system for managing information that supports an organization’s business operations. It involves storing data, disseminating it to applications and users and editing it when needed and monitoring changes to the data and making sure that data integrity is not compromised due to unexpected failure. It is a part of an organization’s overall informational infrastructure which aids in decision making, corporate growth and compliance with laws such as the GDPR and the California Consumer Privacy Act.

In the 1960s, Charles Bachman and IBM along with others created the first database systems. They evolved into information management systems (IMS) which made it possible to store and retrieve large amounts data for a wide range of purposes, ranging from calculating inventory to supporting complex human resources and financial accounting functions.

A database consists of tables that organize data according to some schema, such as one-to many relationships. It makes use of primary keys to identify records and allows cross-references between tables. Each table has a set of fields, also known as attributes, that provide information about the entities that comprise the data. Relational models, created by E. F. “TedCodd Codd in the 1970s at IBM and IBM, are among the most well-known database type currently. This design is based upon normalizing data to make it more user-friendly. It is also simpler to update data because it doesn’t require the modification of many sections of the databases.

The majority of DBMSs are able to support different types of databases by offering different levels of internal and external organization The internal level focuses on cost, scalability and other operational concerns like the layout of the physical storage. The external level is how the database appears in user interfaces and other applications. It can include a mixture of different external views based on different models of data and may also include virtual tables that are calculated with generic data to enhance the performance.

Leave a Reply

Your email address will not be published. Required fields are marked *