Database Management Basics

Database management is the process for managing information that supports the company’s business operations. It involves storing and distributing data it to applications and users, editing it as needed and monitoring changes to the data and making sure that data integrity is not compromised due to unexpected failure. It is one component of a company’s informational infrastructure that aids in decision-making and growth of the company as well as 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 huge amounts of data to be stored and retrieved for a variety of reasons. From calculating inventory to aiding complex financial accounting functions and human resource functions.

A database consists of a set of tables that store data according to a certain pattern, for example, one-to-many relationships. It makes use of primary keys to identify records and permit cross-references between tables. Each table contains a number of fields, known as attributes, which provide information about the data entities. Relational models, invented by E. F. “Ted” Codd in the 1970s at IBM and IBM, are among the most widely used type of database currently. The design is based on normalizing the data, making it simpler to use. It also makes it easier to update data without the need to change different sections of the database.

The majority of DBMSs are able to support various types of databases, by providing different levels of external and internal organization. The internal level is concerned with costs, scalability and other operational issues, including the physical layout of the database. The external level determines how the database is presented in user interfaces and other applications. It can include a mixture of external views based on different models of data and may include virtual table that are computed using generic data to improve the performance.

Tinggalkan Komentar

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *