Database Management Basics

Database management is a system of managing the information that is used to support a company’s business operations. It involves storing data, disseminating it to users and applications, editing it as needed and monitoring changes to data and stopping data corruption due unexpected failure. It is an element of a company’s overall informational infrastructure that aids in 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 along with other companies developed the first database systems. They developed into information management systems (IMS) which made it possible to store and retrieve large amounts data for a variety of purposes, ranging from calculating inventory to supporting complicated human resources and financial accounting functions.

A database is a collection of tables that store data according to the specific scheme, for example one-to many relationships. It uses the primary key to identify records and allow cross-references between tables. Each table is comprised of a variety of fields, referred to as attributes, which provide information about the entities that comprise the data. The most widely used type of database currently is a relational model, developed by E. F. “Ted” Codd at IBM in the 1970s. The design is based on normalizing the data, making it more easy to use. It is also easier to update data because it does not require the changing of various databases.

Most DBMSs are able to support different types of databases and offer different internal and external levels of organization. The internal level is focused on costs, scalability and other operational issues, such as the physical layout of the database. The external level is how the database is represented in user interfaces and other applications. It may include a mix of different external views (based on the different data models) and may also include virtual tables that are constructed from data that is generic to enhance performance.

Laat een reactie achter

Het e-mailadres wordt niet gepubliceerd. Vereiste velden zijn gemarkeerd met *