Database management is the system to manage information that is essential to the business operations of an organization. It involves storing data, distributing it to users and applications and editing it when needed, monitoring data changes, and preventing data corruption due to unexpected failure. It’s a component of a company’s informational infrastructure that aids in decision-making and corporate growth, as well as compliance with laws like the GDPR and the California Consumer Privacy Act.
The first database systems were invented in the 1960s by Charles Bachman, IBM and others. They developed 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 aiding complex financial accounting functions as well as human resource functions.
A database is a collection of tables that store data according to a certain scheme, like one-to-many relationships. It uses primary keys to identify records and allow cross-references between tables. Each table has a set of fields, referred to as attributes, that provide information about the entities that comprise the data. Relational models, invented by E. F. “TedCodd Codd in the 1970s at IBM and IBM, are the most popular database type in the present. This design is based upon normalizing data to make it more user-friendly. It is also easier to update data because it does not require the changing of many sections of the databases.
Most DBMSs support various types of databases, by providing different levels of internal and external organization. The internal level addresses costs, scalability, and other operational issues, such as the layout of the physical storage. The external level is the representation of the database in user interfaces and applications. It could comprise a mix of various external views based on different models of data and may include batdongsanphuquy.vn virtual table that are calculated using generic data to enhance the performance.