Database management is a method of managing the information that a company needs to run its business operations. It involves storing data, distributing it to applications and users and then modifying it if necessary and monitoring the changes in the data and preventing it from getting damaged due to unexpected failure. It is an integral part of the entire informational infrastructure of a company which supports decision-making as well as corporate growth and compliance with laws like the GDPR and the California Consumer Privacy Act.
The first database systems were developed in the 1960s nguyentrananhquoc.top by Charles Bachman, IBM and others. They evolved into information management systems (IMS) which allowed massive amounts of data to be stored and retrieved for a variety of reasons. From calculating inventory, to supporting complex financial accounting functions and human resource functions.
A database is a collection of tables that store data according to the specific scheme, for example one-to many relationships. It uses primary key to identify records and permits cross-references among tables. Each table has a set of fields, also known as attributes, that represent facts about the data entities. Relational models, which were developed by E. F. “TedCodd Codd in the 1970s at IBM as a database, are the most popular database type in the present. The design is based on normalizing the data, making it easier to use. It is also easier to update data because it doesn’t require changing many sections of the databases.
The majority of DBMSs are able to support different types of databases by offering different levels of external and internal organization. The internal level focuses on cost, scalability and other operational issues such as the layout of the database’s physical storage. The external level is the representation of the database in user interfaces and applications. It could include a mix of different external views that are based on different models of data and could include virtual tables that are computed using generic data in order to improve the performance.