Database Management Basics

Database management is the process to manage information that is essential to the organization’s business processes. It involves storing and distributing data it to applications and users and editing it as required, monitoring data changes, and making sure that data integrity is not compromised due to unexpected failure. It is a component of the entire informational infrastructure of a business that supports decision making and corporate growth as well as compliance with laws like the GDPR and California Consumer Privacy Act.

In the 1960s, Charles Bachman and IBM along with others created the first database systems. They developed into information management systems (IMS) which allowed huge 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 set of tables that are organized in accordance with a specific scheme, such as one-to-many relationships. It uses the primary key to identify records and allows cross-references among 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 as a database, are the most well-known database type today. This design is based on normalizing the data, making it simpler to use. It also makes it simpler to update data, avoiding the need to modify various databases.

Most DBMSs support multiple types of databases, offering internal and external levels of organization. The internal level is focused on the cost, scalability, and other operational issues, including the physical layout of the database. 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 different data models) and could also include virtual tables that are created using generic data to improve performance.

Deja un comentario