Database Management Basics

16 de maio de 2023 0 Por teste

Database management is the system for managing data that supports an organization’s business operations. It involves storing data, disseminating it to users and applications and editing it when needed as well as monitoring changes in data and making sure that data integrity is not compromised due to unexpected failure. It’s a component of an organization’s overall informational infrastructure that aids in decision-making and corporate growth, 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 developed into information management systems (IMS) which allowed for the storage and retrieve massive amounts of data for a variety of applications, from the calculation of inventory to supporting complicated human resources and financial accounting functions.

A database is a set of tables that store data in accordance with the specific scheme, for example one-to-many relationships. It utilizes primary keys to identify records, and allow cross-references between tables. Each table has a set of attributes, or fields, that represent facts about data entities. The most well-known type of database currently is a relational model designed by E. F. “Ted” Codd at IBM in the 1970s. This model is based on normalizing the data, making it more easy to use. It is also simpler to update data since it does not require changing various databases.

Most DBMSs can accommodate multiple types of databases through different levels of external and internal organization. The internal level is concerned with 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 can include a mixture of different external views based on different data models and can include virtual tables that are calculated using generic data to improve the performance.