Database Management BasicsHuấn
Database management is the method for managing information that supports the company’s business operations. It involves storing data and distribution to users and application programs making changes as needed and monitoring changes to the data and preventing it from getting corrupted by unexpected failures. It’s a component of a company’s overall informational infrastructure, which supports decision-making and corporate growth, as well as compliance with laws such as the GDPR and the California Consumer Privacy Act.
The first database systems were created in the 1960s by Charles Bachman, IBM and others. They evolved into information management systems (IMS), which allowed massive 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 is a collection of tables that arrange data in accordance with a certain scheme, like one-to-many relationships. It uses primary key to identify records and allow cross-references among tables. Each table has a variety of fields, called attributes, that provide information about the entities that comprise the data. Relational models, developed by E. F. “TedCodd Codd in the 1970s at IBM and IBM, are among the most widely used type of database today. This design is based on normalizing the data, making it easier to use. It also makes it easier to update data without the necessity of changing several databases.
Most DBMSs support multiple types of databases by providing different internal and external levels of organization. The internal level deals with costs, scalability and other operational issues, like the physical layout of the database. The external level is the representation of the database on user interfaces and applications. It may include a mix of various external views based on different data models and could include virtual tables that are calculated with generic data to enhance the performance.