Database Management Basics

Database management is the method for managing data that supports the business operations of an organization. It includes data storage, distributing it to applications and users and modifying it as needed and monitoring changes to the data and preventing the data from becoming damaged due to unexpected failure. It’s a component of a company’s total informational infrastructure that aids in decision-making, corporate growth and compliance with laws like the GDPR and the California Consumer Privacy Act.

In the 1960s, Charles Bachman and IBM along with others created the first database systems. They developed into information management systems (IMS) which allowed large amounts of data to be stored and retrieved for a variety of purposes. From calculating inventory to aiding complicated financial accounting functions, and human resource functions.

A database is a set of tables that are organized according to some arrangement, like one-to-many relationships. It utilizes primary keys to identify records and permit cross-references between tables. Each table contains a number of fields, referred to as attributes, that provide information about the data entities. The most popular kind of database is a relational model developed by E. F. “Ted” Codd at IBM in the 1970s. This design is based on normalizing data to make it easier to use. It also makes it simpler to update data without the need to update various databases.

Most DBMSs can accommodate multiple types of databases through different levels of external and internal organization. The internal level is concerned with the cost, scalability, and other operational issues like 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 that are based on different data models and can include virtual tables that are calculated using generic data to improve the performance.

Join The Discussion

Compare listings