Database management is the system to manage information that is essential to the business operations of an organization. It involves storing data, disseminating it to users and applications making edits as needed and monitoring changes to data and preventing data corruption due to unexpected failure. It is part of the informational infrastructure of a company that supports decision making and corporate growth as well as compliance with laws such as the GDPR and California Consumer Privacy Act.
In the 1960s, Charles soluciones.tv Bachman and IBM among others came up with the first database systems. They evolved into the information management systems (IMS) which enabled the storage and retrieve massive amounts of information for a range of applications, from the calculation of inventory to supporting complex human resources and financial accounting functions.
A database is a collection of tables which organize data in accordance with a specific pattern, such as one-to many relationships. It utilizes primary keys to identify records and allow cross-references between tables. Each table contains a number of fields, also known as attributes, that provide information about the entities that comprise the data. Relational models, which were developed by E. F. “Ted” Codd in the 1970s at IBM as a database, are the most popular database type currently. The design is based on normalizing the data, making it easier to use. It is also simpler to update data because it does not require changing many sections of the databases.
Most DBMSs support multiple database types by providing different levels of internal and external organization. The internal level focuses on costs, scalability, and other operational issues including the design of the database’s physical storage. The external level is the representation of the database on user interfaces and 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 data that is generic to enhance performance.