Database Management Basics
Database management is the process for managing information that aids the organization’s business processes. It involves storing and distributing data it to users and applications and editing it when needed and monitoring changes to data and making sure that data integrity is not compromised due to unexpected failure. It is one component of an organization’s overall informational infrastructure, which supports 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 along with others created the first database systems. They evolved into information management systems (IMS) which allowed for the storage and retrieve large amounts data for a variety of purposes, ranging from calculating inventory to supporting complex human resources and financial accounting functions.
A database consists of tables that are organized according to a particular scheme, such as one-to-many relationships. It makes use of primary keys to identify records and permit cross-references between tables. Each table has a set of attributes or fields that represent facts about data entities. Relational models, created by E. F. “Ted” Codd in the 1970s at IBM and IBM, are among the most widely used type of database in the present. This model is based on normalizing the data, making it easier to use. It is also easier to update data since it does not require changing various databases.
Most DBMSs support multiple database types by providing different levels of internal and external organization. The internal level focuses on cost, scalability and other operational concerns like the layout of the physical storage. The external level is the representation of the database on user interfaces and applications. It may include a mix of different external views that are based on different lilamainvest.com models of data and may include virtual table that are calculated using generic data to enhance the performance.