Database management is the system for managing information that supports an organization’s business operations. It involves storing data, disseminating it to applications and users and editing it as required and monitoring changes to data and preventing data corruption due to unexpected failure. It is a part of the overall infrastructure of a company that assists 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 created in the 1960s by Charles Bachman, IBM and others. They evolved into information management systems (IMS) that enabled the storage and retrieve large amounts data for a broad range of uses, from calculating inventory to supporting complex human resources and financial accounting functions.
A database consists of a set of tables that are organized in accordance with a specific pattern, for example, one-to-many relationships. It uses primary key to identify records and permits cross-references between tables. Each table is comprised of a set of fields called attributes which provide information about data entities. The most popular type of database today is a relational model, created by E. F. “Ted” Codd at IBM in the 1970s. This design is based upon normalizing data to make it easier to use. It is also simpler to update data since it doesn’t require changing several databases.
Most DBMSs can accommodate different types of databases by offering different levels of external and internal organization. The internal level is concerned with cost, scalability and other operational concerns like the layout of the database’s physical storage. The external level is the representation of the database in user interfaces and applications. It can include a mixture of various external views based on different data models. It could include virtual tables that are computed using generic data to enhance the performance.
0 comentário