Database Management Basics

Database management is the process to manage information that is essential to the business operations of an organization. It includes data storage and distribution to applications and users and then modifying it if necessary and monitoring changes to the data and preventing it from becoming damaged by unexpected failure. It’s a component of a company’s overall informational infrastructure that supports decision-making and growth of the company as well as compliance with laws like the GDPR and the California Consumer Privacy Act.

The first database systems were created in the 1960s by Charles Bachman, IBM and others. They evolved into information management systems (IMS), which allowed huge amounts of data to be stored and retrieved for a variety of reasons. From calculating inventory, to supporting complex financial accounting functions as well as human resource functions.

A database is tables that are organized according to a certain pattern, for example, one-to-many relationships. It utilizes primary key to identify records, and also allows cross-references between tables. Each table is comprised of a set of fields called attributes that contain information about data entities. The most well-known type of database that is currently in use is a relational model designed by E. F. « Ted » Codd at IBM in the 1970s. The design is based on normalizing the data, making it easier to use. It also makes it easier to update data without the need to update different sections of the database.

Most DBMSs support multiple types of databases by offering different internal and external levels of organization. The internal level concerns costs, scalability and other operational issues, such as the physical layout of the database. The external level is the representation of the database on user interfaces and applications. It could comprise a combination of various external views (based on different data models) and may also include virtual tables that are constructed using generic data to improve performance.

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *