Database Management Basics

Database management is a method of coordinating the information that is used to support a company’s business operations. It involves storing data, distributing it to users and applications and editing it as required and monitoring changes to the data and preventing data corruption 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 such as the GDPR and the California Consumer Privacy Act.

In the 1960s, Charles Bachman and IBM among others came up with the first database systems. They evolved into information management systems (IMS), which allowed large amounts of data to be stored and retrieved for a range of reasons. From calculating inventory to supporting complicated financial accounting functions, and human resource functions.

A database is a collection of tables which organize data in accordance with a specific pattern, such as one-to-many relationships. It uses the primary key to identify records and allows cross-references between tables. Each table has a collection of attributes, or fields, that contain information about data entities. Relational models, created by E. F. “TedCodd Codd in the 1970s at IBM and IBM, are among the most used database type in the present. This design is based upon normalizing data to make it easier to use. It is also easier to update data since it does not require changing many sections of the databases.

Most DBMSs can support different types of databases by offering different levels of external and internal organization. The internal level deals with costs, scalability, and other operational concerns including the layout of the database’s physical storage. The external level is the representation of the database in user interfaces and applications. It could comprise a combination of different external views (based on the various data models) and may also include virtual tables that are created from generic data in order to improve performance.

Trả lời

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 *