Database Management Basics

Database management is a method of managing information that supports a business’s operations. It involves storing data, disseminating it to applications and users and editing it as required and monitoring changes to the data and preventing data corruption due to unexpected failure. It is an integral part of the overall infrastructure of a business that aids in decision-making as well as corporate growth and compliance with laws such as the GDPR and 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 reasons. From calculating inventory, to supporting complex financial accounting functions and human resource functions.

A database is a collection of tables that organizes data in accordance with a specific pattern, such as one-to many relationships. It uses primary keys to identify records and allows cross-references between tables. Each table has a collection of fields called attributes that contain information about data entities. The most widely used type of database that is currently in use 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 is also easier to update data since it doesn’t require changing several databases.

Most DBMSs can support different types of databases by offering different levels of external and internal organization. The internal level is concerned with cost, scalability, as well as other operational issues, such as the physical layout of the database. The external level is the representation of the database in user interfaces and applications. It could comprise a mix of different external views that are based on different models of data and may also include virtual tables that are calculated using generic data in order to improve the performance.

Leave feedback about this

  • Quality
  • Price
  • Service
Choose Image