Programmable and Networked Information · Processing and transforming

Database management systems

A database management system is not a large file and not a disk drive. It is a software and institutional system that defines persistent data structures, mediates queries and updates, coordinates multiple users, enforces rules, records changes and attempts recovery after failure. Its central historical achievement is the separation of applications from many details of physical storage while allowing a shared.

When it emerged
Production database systems in the early 1960s; hierarchical and network models through the 1960s; relational model in 1970 and experimental relational systems in the 1970s
What changed
Coordinates shared persistent data through logical schemas, queries, controlled updates and recovery without requiring every application to manage physical storage directly
Reading time
17 minutes
The essential questions

Database management systems, clearly explained

A database management system is not a large file and not a disk drive. It is a software and institutional system that defines persistent data structures, mediates queries and updates, coordinates multiple users, enforces rules, records changes and attempts recovery after failure. Its central historical achievement is the separation of applications from many details of physical storage while allowing a shared collection to remain operational under repeated change.

What is it?

A database management system is software that defines and manages a persistent organised collection of data while providing controlled interfaces for creation, retrieval, update, deletion, concurrency, integrity, security and recovery. A DBMS may use hierarchical, network, relational, object, document, key-value, graph or other data models.

What problem did it solve?

The primary constraint reduced is the difficulty of maintaining large persistent record collections that must be shared, queried and updated by multiple applications without each program controlling physical placement and recovery.

How did it work?

It is a software and institutional system that defines persistent data structures, mediates queries and updates, coordinates multiple users, enforces rules, records changes and attempts recovery after failure. Its central historical achievement is the separation of applications from many details of physical storage while allowing a shared collection to remain operational under repeated change. Early electronic data processing often tied programs closely to file layouts, record sequences and storage locations.

What came before?

It built on Electromechanical tabulation, Programming languages and compilers, Khipu and other knot-record systems, Numerical notation and Magnetic digital storage.

What did it make possible?

It helped make possible Search Engines, Digital Provenance and Authenticity Systems, Recommendation Algorithms and Personalised Feeds, Conversational AI Assistants and Retrieval-Augmented Generation and Autonomous and Semi-Autonomous AI Agents.

What survived?

Systems still maintain metadata describing the data they manage.

Why does it still matter?

Multiple applications and users can consult and update one managed collection rather than maintaining disconnected copies. Applications can describe desired information without controlling every block, pointer or access path. Concurrency controls, transactions and integrity rules reduce contradictory or partially applied changes.

Deep dive

The deeper story

A database management system is not a large file and not a disk drive. It is a software and institutional system that defines persistent data structures, mediates queries and updates, coordinates multiple users, enforces rules, records changes and attempts recovery after failure. Its central historical achievement is the separation of applications from many details of physical storage while allowing a shared collection to remain operational under repeated change.

Early electronic data processing often tied programs closely to file layouts, record sequences and storage locations. Charles Bachman's Integrated Data Store, developed in the early 1960s, assembled direct-access storage, data descriptions, linked records, recovery and manipulation facilities into an early production DBMS [1][2]. IBM's IMS, developed during the 1960s and released in 1968, organised records hierarchically and supported high-volume operational use [3]. CODASYL network systems formalised navigational relationships among record types.

Edgar F. Codd's 1970 relational model proposed that users of large shared data banks should be insulated from internal storage organisation and work through relations and values rather than physical navigation [4]. IBM's System R demonstrated relational architecture, SQL, views, authorisation, integrity, logging, recovery, shared updates and cost-based access-path selection during the 1970s [5][6][7]. The relational model did not make physical design disappear. It transferred route selection to a query optimiser and storage manager.

Database systems therefore add a new information layer: managed shared state. They turn stored information into a continuously updated institutional reference point. This enables banking, reservations, inventory, payroll, public administration and online services. It also concentrates power. Schema designers decide which entities and relationships exist. Administrators control permissions. Query logs expose behaviour. A technically consistent database can preserve socially biased categories with ruthless efficiency.

The big idea

Database management systems make persistent information jointly usable by separating logical requests from physical placement and by coordinating update, retrieval, integrity and recovery. Their power lies as much in governing shared state as in storing records.

Main problem addressed

Coordinates shared persistent data through logical schemas, queries, controlled updates and recovery without requiring every application to manage physical storage directly

Connections

What came before and what followed

Start with the key connections, then reveal the wider network when you need more context.

Enabling connection
Search Engines

Provides indexing, query processing and persistent data management.

Enabling connection
Time-sharing

Makes interactive shared access and terminal queries practical.

Extended or built upon
World Wide Web

Uses databases behind dynamic sites and services.

Timeline

Key moments

How Database management systems emerged

This marks the broad emergence and development of Database management systems. Why it mattered: Coordinates shared persistent data through logical schemas, queries, controlled updates and recovery without requiring every application to manage physical storage directly.

Database management systems · broad emergence

Early production DBMS, early 1960s

IDS integrates reusable data-management services above direct-access storage.

Database management systems · practical implementation

Hierarchical and network systems, 1960s-1970s

IMS and CODASYL approaches organise operational data through navigational relationships.

Database management systems · practical implementation

Relational theory, 1970 onward

Logical relations and value-based operations challenge pointer-oriented access.

Database management systems · practical implementation

Relational prototypes and SQL, 1970s

System R and related projects demonstrate practical declarative query processing.

Database management systems · practical implementation

Commercial relational expansion, 1980s-1990s

Relational DBMS become standard enterprise infrastructure.

Database management systems · standardisation
People and organisations

Who helped shape it?

Charles Bachman

Charles Bachman is one of the people connected to this topic. Open the profile for the wider historical context.

Edgar F. Codd

Edgar F. Codd is one of the people connected to this topic. Open the profile for the wider historical context.

IBM

IBM is one of the organisations connected to this topic. Open the profile for the wider historical context.

The Database Task Group

The Database Task Group is one of the organisations connected to this topic. Open the profile for the wider historical context.

Research notes

Open the full research notes

These expandable sections preserve the detailed research behind the public explanation.

1. Executive Summary

A database management system is not a large file and not a disk drive. It is a software and institutional system that defines persistent data structures, mediates queries and updates, coordinates multiple users, enforces rules, records changes and attempts recovery after failure. Its central historical achievement is the separation of applications from many details of physical storage while allowing a shared collection to remain operational under repeated change.

Early electronic data processing often tied programs closely to file layouts, record sequences and storage locations. Charles Bachman's Integrated Data Store, developed in the early 1960s, assembled direct-access storage, data descriptions, linked records, recovery and manipulation facilities into an early production DBMS [1][2]. IBM's IMS, developed during the 1960s and released in 1968, organised records hierarchically and supported high-volume operational use [3]. CODASYL network systems formalised navigational relationships among record types.

Edgar F. Codd's 1970 relational model proposed that users of large shared data banks should be insulated from internal storage organisation and work through relations and values rather than physical navigation [4]. IBM's System R demonstrated relational architecture, SQL, views, authorisation, integrity, logging, recovery, shared updates and cost-based access-path selection during the 1970s [5][6][7]. The relational model did not make physical design disappear. It transferred route selection to a query optimiser and storage manager.

Database systems therefore add a new information layer: managed shared state. They turn stored information into a continuously updated institutional reference point. This enables banking, reservations, inventory, payroll, public administration and online services. It also concentrates power. Schema designers decide which entities and relationships exist. Administrators control permissions. Query logs expose behaviour. A technically consistent database can preserve socially biased categories with ruthless efficiency.

The big idea

Database management systems make persistent information jointly usable by separating logical requests from physical placement and by coordinating update, retrieval, integrity and recovery. Their power lies as much in governing shared state as in storing records.

2. Identification

| Field | Value | |---|---| | Public title | Database management systems | | Analytical title | Managed Shared Data, Query and Transaction Systems | | Recommended type | Logical data-management, query and transaction system | | Primary category | Processing & transformation | | Secondary categories | Storage; discovery; interaction; governance; authentication; auditability | | Emergence | Production database-management systems in the early 1960s; hierarchical and network systems during the 1960s; relational model from 1970 and relational implementations during the 1970s |

3. Operational Definition

A database management system is software that defines and manages a persistent organised collection of data while providing controlled interfaces for creation, retrieval, update, deletion, concurrency, integrity, security and recovery. A DBMS may use hierarchical, network, relational, object, document, key-value, graph or other data models.

The topic excludes the physical storage device, a static data file without management services, the application interface presented to end users and information-retrieval systems whose primary function is ranking documents rather than maintaining operational shared state. A database is the managed collection; the DBMS is the system that governs it. A data model describes permitted structures and operations; a query language expresses requests; an application uses these capabilities for a domain.

4. Why the Topic Matters

4.1 Data becomes shared institutional state

Multiple applications and users can consult and update one managed collection rather than maintaining disconnected copies.

4.2 Logical and physical organisation can diverge

Applications can describe desired information without controlling every block, pointer or access path.

4.3 Updates become coordinated

Concurrency controls, transactions and integrity rules reduce contradictory or partially applied changes.

4.4 Retrieval becomes declarative

Relational query languages allow users to specify what result is required while the system chooses an execution plan.

4.5 Recovery becomes a system responsibility

Logs, checkpoints and restart procedures attempt to restore a consistent state after faults.

4.6 Schemas become instruments of power

What the database can represent, require, link and expose is decided through institutional categories and permissions.

5. Terminology
  • Database: Persistent organised collection managed as a coherent resource.
  • DBMS: Software system controlling definition, access, update, integrity and recovery.
  • Data model: Formal account of data structures, relationships and operations.
  • Schema: Declared structure and constraints of a database.
  • Instance: Data values present at a particular time.
  • Record: Group of related fields treated as a unit.
  • Key: Attribute or combination used to identify or relate records.
  • Pointer: Stored reference to another record or location.
  • Hierarchical model: Organises records primarily as parent-child trees.
  • Network model: Allows records to participate in multiple linked sets or relationships.
  • Relational model: Represents data as relations and derives results through operations over values.
  • Query: Request to retrieve or transform selected data.
  • Data definition language: Commands defining schemas and structures.
  • Data manipulation language: Commands retrieving or changing data.
  • View: Derived or restricted representation of underlying data.
  • Transaction: Bounded logical unit of work whose effects are coordinated.
  • Concurrency control: Mechanisms managing simultaneous operations.
  • Integrity constraint: Rule limiting valid database states.
  • Log: Sequential record of changes used for audit or recovery.
  • Checkpoint: Recorded recovery position reducing restart work.
  • Index: Auxiliary structure accelerating selected access paths.
  • Query optimiser: Component selecting an execution strategy.
  • Data independence: Ability to change some storage or structural details without rewriting every application.
  • Authorisation: Rules determining who may perform which operations.
6. Boundary With Neighbouring Topics

6.1 Database versus storage device

A disk stores addressable blocks. A DBMS defines records, relations, constraints, indexes, transactions and permissions over those blocks.

6.2 Database versus file

A file may hold records, but a DBMS additionally coordinates schemas, concurrent access, queries, recovery and integrity.

6.3 Data model versus DBMS product

The relational model is a formal framework. System R, Db2, Oracle and PostgreSQL are implementations with practical compromises and extensions.

6.4 Query language versus application interface

SQL or another language expresses operations to the DBMS. A payroll screen or booking site is a domain application above it.

6.5 Database query versus search engine

A database query normally operates over structured managed data with defined semantics. Search engines index large document collections and rank approximate relevance.

6.6 Consistency versus truth

A database can satisfy all internal constraints while containing inaccurate, biased or fraudulent records.

7. Communication Pattern

| Dimension | Assessment | |---|---| | Participants | Data modeller, application programmer, administrator, operator, user, auditor and automated client. | | Time | Persistent and continuously updated; supports batch and interactive use. | | Direction | Bidirectional query and update among many users and one or more managed stores. | | Feedback | Milliseconds to hours depending on query, lock, queue and workload. | | Visibility | Users see logical views while physical placement and execution plans are mediated. |

A DBMS is a multi-party communication institution. It receives formal requests, checks identity and permissions, selects access paths, coordinates shared resources, changes durable state and returns results. The system communicates not only data but rules about who may see or alter it.

8. Expanded Communication Model

| Dimension | Assessment | |---|---| | Domain source | Business event, measurement, administrative decision or user action. | | Data capture | Form, sensor, import, message or application transaction. | | Schema | Entity, attribute, relationship, type and constraint definitions. | | Query/update language | Navigational commands, DL/I, SQL or API operations. | | Parser and planner | Validates request and chooses an execution strategy. | | Transaction manager | Coordinates atomicity, concurrency and commit decisions. | | Storage manager | Maps logical records to pages, blocks, files and indexes. | | Recovery manager | Uses logs, checkpoints and backups after failure. | | Authorisation layer | Applies identity, role, privilege and view rules. | | Output | Result set, report, changed state, event or error. | | Noise | Bad capture, schema mismatch, race condition, deadlock, corruption, stale replica, operator error or malicious update. |

The DBMS converts social events into governed persistent state. That conversion is never neutral. Capture rules and schema definitions decide which distinctions become computable.

9. Historical Emergence

9.1 File processing and unit records

Punched-card and early magnetic-file systems stored records but often required each application to know physical layouts and processing sequences.

9.2 Direct-access storage creates opportunity

Magnetic disks made online record retrieval and update practical, encouraging software that could manage relationships and access paths.

9.3 Integrated Data Store

Charles Bachman's IDS, developed at General Electric in the early 1960s, combined linked record structures, data descriptions, recovery and manipulation facilities. It is widely treated as an early production DBMS [1][2].

9.4 Hierarchical databases and IMS

IBM's IMS was created during the 1960s for complex bill-of-material and operational data. Released in 1968, it used hierarchical structures and a specialised data language [3].

9.5 CODASYL network model

The Database Task Group formalised navigational databases in which programs followed declared set relationships among records. This provided performance and explicit control at the cost of physical and structural dependence.

9.6 Codd's relational model

Codd's 1970 paper argued that users and applications should be protected from internal representation and proposed relations as the basis for large shared data banks [4].

9.7 System R

IBM's System R project tested relational design, high-level queries, shared updates, integrity, logging, recovery, views and authorisation [5][6].

9.8 SQL and optimisation

System R work developed SQL and cost-based access-path selection, transferring navigation choices from the application programmer to the optimiser [6][7].

9.9 Commercial relational systems

Relational products expanded in the late 1970s and 1980s. SQL became a dominant interface for enterprise data, though implementations diverged from pure relational theory.

9.10 Distributed and specialised databases

Databases later spread across machines and adopted object, document, graph, column-family and key-value models. The underlying problem remained managed shared persistent state under failure and concurrency.

10. Prerequisites
  • Electronic digital computers
  • Magnetic or other persistent storage
  • Addressable records and indexes
  • Operating systems and file management
  • Formal data description
  • Programming languages and compilers
  • Interactive terminals and time-sharing
  • Concurrency and scheduling mechanisms
  • Logging and backup media
  • Authentication and access control
  • Organisational recordkeeping and standard identifiers
11. Periodisation

11.1 Application-specific files and unit records

Programs remain tightly coupled to physical layouts and batch passes.

11.2 Early production DBMS, early 1960s

IDS integrates reusable data-management services above direct-access storage.

11.3 Hierarchical and network systems, 1960s-1970s

IMS and CODASYL approaches organise operational data through navigational relationships.

11.4 Relational theory, 1970 onward

Logical relations and value-based operations challenge pointer-oriented access.

11.5 Relational prototypes and SQL, 1970s

System R and related projects demonstrate practical declarative query processing.

11.6 Commercial relational expansion, 1980s-1990s

Relational DBMS become standard enterprise infrastructure.

11.7 Web-scale, distributed and specialised systems

Replication, partitioning and diverse models respond to new availability and scale requirements.

11.8 Cloud-managed databases

Database operation becomes an external service while physical and administrative control concentrates in providers.

12. Main Problem Addressed

The primary constraint reduced is the difficulty of maintaining large persistent record collections that must be shared, queried and updated by multiple applications without each program controlling physical placement and recovery.

Secondary constraints reduced include:

  • Duplicate and inconsistent files
  • Tight coupling between programs and storage layout
  • Manual navigation through record sequences
  • Partial updates after failure
  • Conflicting simultaneous changes
  • Weak enforcement of identifiers and constraints
  • Slow creation of new reports
  • Poor authorisation granularity
  • Limited audit and recovery capability
13. Evaluation Matrix

| Dimension | Assessment | |---|---| | Data model | Hierarchical, network, relational, object, document, graph or other. | | Schema visibility | Explicit, inferred, application-owned or flexible. | | Logical independence | Degree to which applications avoid physical storage details. | | Physical independence | Degree to which placement and indexes can change without semantic change. | | Query expressiveness | Fixed transactions, navigational access, declarative queries or analytics. | | Update semantics | Insert, delete, modify, merge and domain-specific operations. | | Transaction boundary | Defines which changes succeed or fail together. | | Concurrency model | Locks, timestamps, serialisation, optimistic control or weaker coordination. | | Recovery model | Logging, checkpoints, backup, replay and replica recovery. | | Integrity | Keys, types, referential rules, assertions and application constraints. | | Authorisation | User, role, privilege, row, column, view or policy control. | | Auditability | Logs, histories and provenance of change. | | Optimisation | Degree to which the system chooses access paths automatically. | | Distribution | Local, replicated, partitioned or federated. | | Consistency/availability trade-off | Behaviour during delay, partition and failure. | | Service latency | Includes parsing, planning, locking, I/O, network and queue delays. | | Administrative burden | Schema design, tuning, backup, migration and incident response. | | Portability | Limited by language dialect, data types, procedures and operational tooling. |

The matrix separates internal consistency from external accuracy. A perfectly serialised transaction can faithfully preserve a false input. Database correctness is not social truth.

14. Advantages and Capabilities

1. Shared persistent state

Many applications can coordinate through one managed collection.

2. Data independence

Logical requests can remain stable while physical access structures change.

3. Declarative query

Users can request results without specifying every navigation step.

4. Coordinated transactions

Related changes can be treated as one unit and isolated from conflicting work.

5. Recovery

Logs and checkpoints support restoration after failure.

6. Integrity and authorisation

The system can enforce structural rules and access boundaries centrally.

7. Reusable views

Different users can receive tailored representations of common underlying data.

15. Civilisational Contributions

1. Transactional economies

Banking, reservations, retail, billing and securities systems depend on coordinated shared records.

2. Administrative continuity

Governments and firms maintain long-lived operational histories across staff and application changes.

3. Online services

Web and mobile applications rely on databases to preserve accounts, content, state and relationships.

4. Scientific data management

Structured datasets, metadata and queries support reproducible analysis, though not automatically.

5. Organisational memory

Databases turn repeated events into searchable institutional records.

6. Analytics and decision support

Managed data collections become inputs to reporting, modelling and machine learning.

16. Organisations, Access and Power

1. Database administrators

DBAs control schemas, accounts, performance, backup and recovery, creating a specialised authority role.

2. Software vendors and standards bodies

Products and SQL dialects shape portability, while standards negotiate common behaviour.

3. Data-owning organisations

Banks, governments, platforms and employers determine whose records are created and how they are used.

4. Application developers

Interfaces may hide or expose data-model assumptions and can bypass database protections.

5. Cloud providers

Managed databases reduce local operational burden while concentrating infrastructure, metadata and jurisdictional control.

6. Subjects of records

People represented in databases often cannot inspect, correct or contest the schemas and inferences governing them.

17. Limitations, Harms and Trade-Offs

1. Schema rigidity

Formal structures can exclude ambiguity, changing identities and context.

2. Centralised surveillance

Shared integrated records make linkage and population monitoring easier.

3. Correlated failure

One database defect or compromised administrator can affect many applications at once.

4. Lock-in

Dialect, procedures, proprietary tooling and data volume can make migration expensive.

5. Performance opacity

Declarative queries transfer control to an optimiser whose choices may be difficult to predict.

6. False authority

Users may treat database output as objective because it is structured and consistent.

7. Concurrency anomalies

Weak or misunderstood isolation can produce lost updates, stale reads and contradictory decisions.

8. Retention and breach amplification

Large historical datasets increase the consequences of unauthorised access.

9. Administrative complexity

Backups, replication, upgrades, indexes and recovery require continuing expert labour.

18. Predecessors, Successors and Relationships

| Relationship | Topic or system | Explanation | |---|---|---| | Predecessor | Electromechanical tabulation Electromechanical tabulation | Establishes structured administrative records, sorting and recurring reports. | | Predecessor | Magnetic digital storage Magnetic digital storage | Supplies persistent addressable blocks for online records and indexes. | | Predecessor | Programming languages and compilers Programming languages and compilers | Supplies formal data-definition and manipulation languages. | | Predecessor | Time-sharing Time-sharing | Makes interactive shared access and terminal queries practical. | | Successor | Online transaction-processing systems | Apply DBMS coordination to continuous business events. | | Successor | World Wide Web World Wide Web | Uses databases behind dynamic sites and services. | | Successor | Search Engines Search engines | Use specialised storage and indexing systems for large retrieval tasks. | | Successor | Cloud platforms and analytics | Distribute, replicate and analyse managed datasets at scale. | | Neighbour | File systems | Manage named stored objects but usually provide weaker data semantics and transactions. |

The DBMS is a semantic and coordination layer above storage and below applications. It is neither simply a file cabinet nor merely a query language.

19. What Survived

1. Schema and catalogue

Systems still maintain metadata describing the data they manage.

2. Logical-physical separation

Applications expect storage layouts and indexes to change beneath stable requests.

3. Transactions

Bounded units of work remain central to operational systems.

4. Logs and recovery

Durable change histories support restart, replication and audit.

5. Declarative query

Users specify desired results while optimisers select access paths.

6. Views and authorisation

Different users receive controlled representations of shared data.

7. Schema politics

Every operational system still embeds assumptions about entities, identity and valid relationships.

20. Representative Cases

20.1 Integrated Data Store

IDS demonstrates an early reusable system for direct-access linked records, recovery and data manipulation [1][2].

20.2 IBM IMS

IMS shows hierarchical database management supporting large operational workloads from the late 1960s onward [3].

20.3 CODASYL network systems

CODASYL formalised navigational database structures and programmer-controlled paths.

20.4 Codd's relational model

The 1970 paper articulates a deliberate separation between users and internal data representation [4].

20.5 System R

System R demonstrates relational views, SQL, integrity, authorisation, logging, recovery and shared update architecture [5][6].

20.6 Cost-based optimisation

The System R optimiser shows how physical navigation becomes an automated planning problem [7].

20.7 Transaction-processing research

Jim Gray's work formalised methods for concurrency and recovery in reliable shared data systems [8].

21. Research Uncertainty and Open Questions
  • Which definition best supports a first-DBMS claim without erasing earlier file-management systems?
  • Should online transaction processing become a distinct topic?
  • Should file systems receive dedicated treatment between storage devices and DBMS?
  • How should non-relational systems be represented without treating relational history as an inevitable endpoint?
  • Which transaction properties belong in the master evaluation framework rather than only this research notes?
  • How should distributed consistency and availability trade-offs be scored across different failure assumptions?
  • How should data lineage, deletion and right-to-correction be represented?
  • Where should data warehouses and analytical lakes sit in the topic register?

The research notes avoids treating “database” as synonymous with “relational database”. Relational systems are historically dominant, not definitionally exhaustive.

22. Claim Register

|---|---|---|---| | Database management systems-C01 | A database and a DBMS are analytically distinct. | High | S01-S10 | | Database management systems-C02 | A DBMS manages definition, access, update, integrity and recovery above physical storage. | High | S01-S10 | | Database management systems-C03 | IDS was an early production random-access DBMS developed in the early 1960s. | High | S01-S02 | | Database management systems-C04 | IMS emerged during the 1960s and was released in 1968. | High | S03 | | Database management systems-C05 | Codd published the relational model in 1970. | High | S04 | | Database management systems-C06 | Codd explicitly sought to insulate users from internal representation. | High | S04 | | Database management systems-C07 | System R implemented a high-level relational interface and data-independence architecture. | High | S05-S06 | | Database management systems-C08 | System R included authorisation, integrity, logging, recovery and shared-update facilities. | High | S05-S06 | | Database management systems-C09 | SQL supports both ad hoc queries and embedded transaction programs. | High | S06 | | Database management systems-C10 | Cost-based optimisation selects access paths for declarative requests. | High | S07 | | Database management systems-C11 | Internal consistency does not guarantee truthful source data. | High | Analytical synthesis | | Database management systems-C12 | Database systems govern shared state as well as storing records. | High | Analytical synthesis |

23. Comparative Analysis

| Comparison | Main difference | Analytical value | |---|---|---| | Punched-card tabulation | Physical unit records processed in passes. | Shows transition from decks to persistent shared state. | | File processing | Application controls layout and access sequence. | Shows the coupling reduced by DBMS services. | | Hierarchical DBMS | Parent-child navigation. | Shows performance and structural rigidity. | | Network DBMS | Explicit linked sets and navigational paths. | Shows flexible relationships with programmer path dependence. | | Relational DBMS | Value-based relations and declarative operations. | Shows logical independence and optimiser mediation. | | Search engine | Ranked retrieval over indexed documents. | Separates relevance ranking from operational transactions. | | Spreadsheet | User-controlled grid with weak multi-user integrity. | Shows accessibility without full database governance. | | Distributed database | State spread across topics. | Exposes consistency, latency and failure trade-offs. |

The defining transition is from data stored for one program to data managed as a shared institutional resource.

28. Final perspective

The database-management system transforms stored data into governed shared state. It does this by placing a formal institution between the physical device and the application. That institution defines structures, accepts requests, selects access paths, coordinates competing updates, records change and attempts repair after failure.

Earlier systems made records machine-readable. DBMS architecture made those records continuously reusable across applications. Relational systems pushed the separation further by allowing requests to describe desired results rather than physical paths. The optimiser became an invisible navigator.

This convenience should not hide the political work of data modelling. Every schema says what kinds of things exist, which identifiers matter and which relationships are permitted. Every permission system decides who can know or alter those things. Every retention rule decides how long the past remains actionable.

A database is not merely where an institution keeps facts. It is where the institution formalises what a fact is, who may change it and which version of reality its software will act upon.

Evidence

Sources and further reading

  1. Computer History Museum, *Assembling the Integrated Data Store (IDS)*. https://computerhistory.org/events/assembling-integrated-data-store-ids/

    Open source ↗

  2. Computer History Museum, *Charles W. Bachman*. https://computerhistory.org/profile/charles-w-bachman/

    Open source ↗

  3. IBM, *Information Management System*. https://www.ibm.com/history/information-management-system

    Open source ↗

  4. E. F. Codd, *A Relational Model of Data for Large Shared Data Banks*, Communications of the ACM 13(6), 1970. https://dl.acm.org/doi/10.1145/362384.362685

    Open source ↗

  5. M. M. Astrahan et al., *System R: Relational Approach to Database Management*, IBM Research, 1976. https://research.ibm.com/publications/system-r-relational-approach-to-database-management

    Open source ↗

  6. D. D. Chamberlin et al., *Support for Repetitive Transactions and Ad Hoc Queries in System R*, IBM Research, 1981. https://research.ibm.com/publications/support-for-repetitive-transactions-and-ad-hoc-queries-in-system-r

    Open source ↗

  7. P. G. Selinger et al., *Access Path Selection in a Relational Database Management System*, IBM Research, 1979. https://research.ibm.com/publications/access-path-selection-in-a-relational-database-management-system

    Open source ↗

  8. ACM, *Jim Gray: A.M. Turing Award Laureate*. https://amturing.acm.org/award_winners/gray_3649936.cfm

    Open source ↗

  9. Computer History Museum, *RDBMS Plenary 1: Early Years*. https://archive.computerhistory.org/resources/access/text/2013/05/102702562-05-01-acc.pdf

    Open source ↗

  10. IBM, *The Relational Database*. https://www.ibm.com/history/relational-database The database-management system transforms stored data into governed shared state. It does this by placing a formal institution between the physical device and the application. That institution defines structures, accepts requests, selects access paths, coordinates competing updates, records change and attempts repair after failure. Earlier systems made records machine-readable. DBMS architecture made those records continuously reusable across applications. Relational systems pushed the separation further by allowing requests to describe desired results rather than physical paths. The optimiser became an invisible navigator. This convenience should not hide the political work of data modelling. Every schema says what kinds of things exist, which identifiers matter and which relationships are permitted. Every permission system decides who can know or alter those things. Every retention rule decides how long the past remains actionable. > **A database is not merely where an institution keeps facts. It is where the institution formalises what a fact is, who may change it and which version of reality its software will act upon.**

    Open source ↗