Database management is the process for managing information that supports an organization’s business operations. It involves storing and distributing data it to applications and users, editing it as needed, monitoring data changes, and making sure that data integrity is not compromised due to unexpected failure. It is an integral part of the overall infrastructure of a business which supports decision-making as well as corporate growth and compliance with laws like the GDPR and the California Consumer Privacy Act.

In the 1960s, Charles Bachman and IBM along with other companies developed the first database systems. They developed into information management systems (IMS) which allowed massive amounts of data to be stored and retrieved for a range of reasons. From calculating inventory to aiding complicated financial accounting functions, and human resource functions.

A database is a collection of tables that arrange data according to a certain scheme, like one-to many relationships. It makes use of primary keys to identify records, and also allows cross-references between tables. Each table has a variety of fields, also known as attributes, which provide information about the entities that comprise the data. Relational models, which were developed by E. F. “Ted” Codd in the 1970s at IBM, are the most well-known database type today. This design is based on normalizing the data, making it simpler to use. It is also simpler to update data because it doesn’t require changing certain sections of the database.

Most DBMSs can support multiple types of databases through different levels of internal and external organization. The internal level addresses costs, scalability, and other operational concerns like the layout of the physical storage. The external level determines how the database appears in user interfaces and other applications. It can include a combination of various external views (based on the various data models) and may also include virtual tables that are constructed from generic data to improve performance.

bình luận