Database management is the system to manage information that is essential to the organization’s business processes. It involves storing data and distribution to application programs and users making changes as needed, monitoring changes in the data and preventing it from becoming damaged due to unexpected failure. It is a component of the overall infrastructure of a business that supports decision making, corporate growth, and compliance with laws such as the GDPR and California Consumer Privacy Act.
The first database systems were developed in the 1960s by Charles Bachman, IBM and others. They developed into information management systems (IMS) that allowed for the storage and retrieve large amounts of data for a variety of purposes, ranging from calculating inventory to supporting complex financial accounting and human resources functions.
A database is a set of tables that store data according to a specific pattern, such as one-to many relationships. cedeng.org It utilizes primary key to identify records and allows cross-references among tables. Each table contains a set of attributes, or fields, that contain information about data entities. The most well-known kind of database is a relational model created by E. F. „Ted” Codd at IBM in the 1970s. The design is based on normalizing the data, making it simpler to use. It is also easier to update data because it doesn’t require changing certain sections of the database.
Most DBMSs support multiple types of databases through different levels of internal and external organization. The internal level deals with cost, scalability and other operational concerns, 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 may include a mix of different external views (based on different data models) and could also include virtual tables that are computed from generic data in order to improve performance.
