Database Management Basics

Database management is a method of managing information that supports a business’s operations. It includes data storage, distributing it to applications and users making changes as needed and monitoring changes to the data and preventing it from becoming damaged due to unexpected failures. It is part of the overall infrastructure of a company that supports decision making in corporate growth, 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 aiding complex financial accounting functions as well as human resource functions.

A database consists of a set of tables that arrange data according to a particular schema, such as one-to many relationships. It uses primary keys to identify records, and allow cross-references between tables. Each table has a variety of fields, also known as attributes, that represent facts about the data entities. Relational models, invented by E. F. “TedCodd Codd in the 1970s at IBM and IBM, are among the most used database type in the present. This model is based on normalizing the data, making it more easy to use. It also makes it simpler to update data by avoiding the need to modify many sections of the database.

Most DBMSs can support multiple database types by providing different levels of internal and external organization. The internal level focuses on costs, scalability, and other operational concerns 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 can include a mixture of different external views that are based on different models of data and could include virtual tables that are calculated using generic data to enhance the performance.

Gửi bình luận

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *