Database Management Basics

Database management is the method for managing information that supports the organization’s business processes. It involves storing and distributing data it to users and applications and editing it when needed and monitoring changes to the data and preventing data corruption due to unexpected failure. It is part of the entire informational infrastructure of a company that assists in decision making, corporate growth, and compliance with laws such as the GDPR and the California Consumer Privacy Act.

In the 1960s, Charles Bachman and IBM among others developed the first database systems. They evolved into the information management systems (IMS) that made it possible to store and retrieve large amounts data for a variety of purposes, ranging from calculating inventory to supporting complex human resources and financial accounting functions.

A database is a collection of tables that organizes data in accordance with an established 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 set of fields, referred to as attributes, that contain information about data entities. Relational models, invented by E. F. “TedCodd Codd in the 1970s at IBM, are the most popular database type today. The design is based on normalizing the data, making it more easy to use. It is also easier to update data because it does not require changing several databases.

Most DBMSs can support multiple types of databases through different levels of internal and external 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 how the database is displayed in user interfaces and other applications. It could comprise a combination of different external views (based on the various data models) and could also include virtual tables that are computed using generic data to improve performance.

We will be happy to hear your thoughts

Leave a reply

VN678 Club