Database Management Basics 18 mayo, 2023
Database management is a system of managing information that is used to support a company’s business operations. It involves storing data, disseminating it to users and applications, editing it as needed as well as monitoring changes in data and making sure that data integrity is not compromised due to unexpected failure. It is a part of the overall informational infrastructure of a company that assists in decision making as well as corporate growth and compliance with laws like the GDPR and the California Consumer Privacy Act.
In the 1960s, Charles Bachman and IBM among others came up with the first database systems. They developed into information management systems (IMS), which allowed massive amounts of data to be stored and retrieved for a range of purposes. From calculating inventory, to aiding complicated financial accounting functions, and human resource functions.
A database is a set of tables which organize data in accordance with a specific pattern, such as one-to many relationships. It makes use of primary keys to identify records and permit cross-references between tables. Each table has a set of fields, also known as attributes, which provide information about the data entities. The most well-known kind of database is a relational model, created by E. F. «Ted» Codd at IBM in the 1970s. This design is based upon normalizing data to make it easier to use. It is also easier to update data because it does not require changing several databases.
Most DBMSs can accommodate multiple types of databases through different levels of external and internal organization. The internal level is concerned with costs, scalability and other operational issues, like the physical layout of the database. The external level is how the database appears in user interfaces and other applications. It can include a combination of different external views (based on the different data models) and can also include virtual tables that are constructed from generic data in order to improve performance.
