Database Management Basics


Database management is the system to manage information that is essential to the company’s business operations. It involves storing and distributing data it to applications and users and editing it as required as well as monitoring changes in data and making sure that data integrity is not compromised due to unexpected failure. It is a part of the informational infrastructure of a company that aids in decision-making in corporate growth, as well as compliance with laws such as the GDPR and California Consumer Privacy Act.

The first database systems were developed in the 1960s by Charles Bachman, IBM and others. They evolved into the information management systems (IMS) that made it possible to store and retrieve massive amounts of data for a wide range of purposes, ranging from calculating inventory to supporting complex human resources realizasoftware.com.br and financial accounting functions.

A database is a collection of tables which organize data in accordance with an established pattern, such as one-to-many relationships. It utilizes primary key to identify records and allows cross-references among tables. Each table contains a number of fields, called attributes, which provide information about the data entities. Relational models, created by E. F. “TedCodd Codd in the 1970s at IBM as a database, are the most widely used type of database in the present. This model is based on normalizing the data, making it more easy to use. It is also easier to update data because it doesn’t require changing certain sections of the database.

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

+ There are no comments

Add yours