Database Management Basics

Database management is a method for managing the data that a company needs to run its business operations. It includes data storage, distributing it to application programs and users making changes as needed and monitoring changes to the data and preventing it from being corrupted by unexpected failures. It is a component of the entire informational infrastructure of a company that aids in decision-making, corporate growth, and compliance with laws like the GDPR and 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 allowed large amounts data to be stored and retrieved for a range of purposes. From calculating inventory, to aiding complicated financial accounting functions, and human resource functions.

A database is a set of tables that arrange data according to the specific scheme, for example one-to-many relationships. It uses primary key to identify records and allows cross-references among tables. Each table contains a set of attributes, or fields, that provide information about data entities. Relational models, created by E. F. “TedCodd Codd in the 1970s at IBM, are the most popular database type today. The design is based on normalizing the data, making it more easy to use. It is also simpler to update data since it doesn’t require changing certain sections of the database.

Еще по теме:  Tech Education at Drexel University

Most DBMSs support multiple types of databases and offer different internal and external levels of organization. The internal level deals with cost, scalability and other operational issues like the design of the database’s physical storage. The external level is the way the database is presented in user interfaces and other applications. It may include a mix of various external views (based on the various data models) and may include virtual tables that are created from generic data to improve performance.

Вас может заинтересовать