18 Mai Database Management Basics
Database management is a method of managing the information that is used to support a company’s business operations. It includes data storage and distribution to applications and users and then modifying it if necessary and monitoring the changes in the data and preventing it from becoming corrupted due to unexpected failures. It is part of the entire informational infrastructure of a company which supports decision-making as well as corporate growth and compliance with laws like the GDPR and California Consumer Privacy Act.
The first database systems were developed in the 1960s by Charles Bachman, IBM and others. They developed into information management systems (IMS) that allowed the storage and retrieve large amounts data for a variety of purposes, ranging from calculating inventory to supporting complicated human resources and financial accounting functions.
A database is a collection of tables that organizes data according to a specific pattern, such as one-to-many relationships. It makes use of primary keys to identify records and allow cross-references between tables. Each table is comprised of a variety of fields, called attributes, that provide information about the data entities. Relational models, developed by E. F. “TedCodd Codd in the 1970s at IBM and IBM, are among the most widely used type of database in the present. This design is based on normalizing the data, making it simpler to use. It is also easier to update data because it does not require changing many sections of the databases.
The majority of DBMSs support a variety of databases by offering different internal and external levels of organization. The internal level concerns cost, 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 can include a combination of various external views (based on different data models) and could also include virtual tables that are computed from generic data in order to improve performance.
Sorry, the comment form is closed at this time.