Database Management Basics
dkc.pekalongan.pramukajateng.or.id
Database management is the system for managing information that supports the company’s business operations. It involves storing data, distributing it to applications and users and editing it when needed and monitoring changes to the data and making sure that data integrity is not compromised due to unexpected failure. It is part of the overall infrastructure of a company that assists in decision making, corporate growth, and compliance with laws like the GDPR and California Consumer Privacy Act.
The first database systems were created in the 1960s by Charles Bachman, IBM and others. They developed into information management systems (IMS) which allowed the storage and retrieve large amounts of data for a variety of applications, from the calculation of inventory to supporting complicated human resources and financial accounting functions.
A database is a set of tables which organize data according to an established pattern, such as one-to-many relationships. It utilizes primary key to identify records and allows cross-references among tables. Each table has a set of fields, referred to as attributes, that provide information about the data entities. Relational models, which were developed by E. F. “TedCodd Codd in the 1970s at IBM and IBM, are among the most well-known database type currently. This design is based on normalizing the data, making it easier to use. It is also easier to update data because it doesn’t require the modification of various databases.
Most DBMSs can accommodate multiple database types by providing different levels of internal and external organization. The internal level is concerned with costs, scalability and other operational issues, such as the physical layout of the database. The external level focuses on how the database is represented in user interfaces and other applications. It can include a mixture of different external views based on different data models and may also include virtual tables that are computed using generic data to enhance the performance.