Database management is a method for managing the data that supports a company’s business operations. It involves storing data and distribution to applications and users and modifying it as needed and monitoring changes to the data and preventing it from becoming damaged due to unexpected failures. It is an integral part of the overall infrastructure of a business that supports decision making as well as corporate growth and compliance with laws like the GDPR and California Consumer Privacy Act.\n<\/p>\n
In the 1960s, Charles Bachman and IBM among others came up with the first database systems. They evolved into information management systems (IMS) which allowed for the storage and retrieve massive amounts of data for a variety of purposes, ranging from calculating inventory to supporting complex human resources and financial accounting functions.\n<\/p>\n
A database is a collection of tables which organize data according to 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 is comprised of a variety of fields, referred to as attributes, that contain information about the entities that comprise the data. The most widely used kind of database is a relational model designed by E. F. “Ted” Codd at IBM in the 1970s. The concept is based on normalizing data to make it easier to use. It is also easier to update data since it doesn’t require changing certain sections of the database.\n<\/p>\n
Most DBMSs can accommodate different types of databases by offering different levels of internal and external organization. The internal level addresses cost, scalability and other operational concerns like the layout of the database’s physical storage. The external level determines how the database appears in user interfaces and other applications. It could include a mix of various external views (based on the different data models) and could also include virtual tables that are computed from generic data in order to improve performance.\n<\/p>\n