- May 18, 2023
- Posted by: admin
- Categories:
Database management is a method of managing the information that supports a company’s business operations. It involves storing and distributing data it to applications and users, editing it as needed and monitoring changes to the data and stopping data corruption due unexpected failure. It is a part of the overall infrastructure of a business that assists in decision making as well as corporate growth and compliance with laws such as the GDPR and California Consumer Privacy Act.
The first database systems were invented in the 1960s by Charles Bachman, IBM and others. They developed into information management systems (IMS) which allowed huge amounts of data to be stored and retrieved for a variety of purposes. From calculating inventory, to supporting complicated financial accounting functions, and human resource functions.
A database consists of a set of tables that arrange data according to a particular arrangement, like one-to-many relationships. It utilizes primary key to identify records and allow cross-references between tables. Each table is comprised of a set of attributes or fields which provide information about data entities. Relational models, invented by E. F. “Ted” Codd in the 1970s at IBM, are the most used database type in the present. The design is based on normalizing the data, making it more easy to use. It also makes it simpler to update data since it eliminates the need to change various databases.
Most DBMSs support multiple types of databases by offering different internal and external levels of organization. The internal level addresses costs, scalability, and other operational issues such as the layout of the database’s physical storage. The external level is the representation of the database on user interfaces and applications. It may include a mix of different external views based on different data models. It can include virtual tables that are calculated with generic data to enhance the performance.