Database management is a system to manage information that is essential to the business operations of an organization. It includes data storage and distribution to applications and users and modifying it as needed and monitoring the changes in the data and preventing it from becoming damaged due to unexpected failures. It is one component of a company’s total informational infrastructure that supports decision-making and corporate growth, as well as compliance with laws like 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 allowed large amounts of data to be stored and retrieved for a range of purposes. From calculating inventory to supporting complicated financial accounting functions, and human resource functions.

A database is a set of tables that store data in accordance with the specific scheme, for example one-to many relationships. It uses the primary key to identify records and permits cross-references among tables. Each table has a set of fields, referred to as attributes, that contain information about data entities. The most widely used type of database today is a relational model designed by E. F. « Ted » Codd at IBM in the 1970s. This design is based on normalizing data to make it simpler to use. It also makes it simpler to update data without the need to modify several databases.

The majority of DBMSs support a variety of databases by offering different internal and external levels of organization. The internal level concerns cost, scalability, and other operational issues like the physical layout of the database. The external level is the way the database is presented in user interfaces and other applications. It may include a mix of different external views that are based on different models of data and could include virtual tables that are calculated with generic data to enhance the performance.

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *