Databases
Storing and querying structured data at scale: relational, graph and other database models and their query languages.
- also
- Data management
- scheme
- traditions
Where it answered
This tradition's column of the issues map: which questions its works mainly answer, and the earliest of each.
| issue | works | earliest |
|---|---|---|
| Technical 22 works · 92% | ||
| Identification | ||
| Linking | 2 | Linked Movie Database 2009 |
| Data model | 11 | Canada Geographic Information System 1963 |
| Serialization | ||
| Reasoning | ||
| Query & validation | 3 | On Closed World Data Bases 1978 |
| Scale & performance | 6 | Virtuoso 1998 |
| Bridge 2 works · 8% | ||
| Vocabulary | 2 | YAGO 2007 |
| Human 0 works · 0% | ||
| Topology | ||
| Trust | ||
| Governance | ||
| Adoption & incentives | ||
| Sustainability | ||
| Usability | ||
Shares works with Web standards (8) · Knowledge representation (4) · Media (2) · Geospatial (1) · Industry and engineering (1)
Counts use each work's main design issue, as on the full map; 24 works in all.
Timeline
Everything from this tradition, in lanes by type. Bars run from start to end where both are known; marks people, projects and organizations still active. 19 entries have no date and are not shown. Hover over or focus an entry to draw its links. Scroll sideways, or use the decades above.
Entries (47)
Concepts 5
-
Relational model
1969
concept
formalism
Model of data as relations, that is tables of rows with named columns, queried by declarative operations on whole sets; proposed by E.F. Codd and the basis of SQL databases.
-
Entity–relationship model
1976
concept
formalism
Way of modelling a domain as entities, their attributes and the relationships between them, drawn as ER diagrams; introduced by Peter Chen in 1976 as a unified view of the network, relational and entity-set models.
-
Big data
concept
Data too large, fast-moving or varied for ordinary databases, and the methods for drawing value from it by analysis at scale; the term spread around 2010 as companies mined logs, clicks and sensor data.
-
Labeled property graph
concept
formalism
Graph model in which nodes and relationships carry labels and key–value properties; the model behind Neo4j and GQL, and the main rival to RDF for graph data.
-
Triplestore
concept
technique
Database built to store RDF triples and answer SPARQL queries; Virtuoso is one example.
Writings 11
-
A Relational Model of Data for Large Shared Data Banks
1970
writing
★ seminal
formalism
E.F. Codd's 1970 paper in Communications of the ACM proposing that data be organized as relations (tables), independently of how it is stored.
-
The Entity-Relationship Model: Toward a Unified View of Data
1976
writing
★ seminal
formalism
Peter Chen's paper in the first issue of ACM Transactions on Database Systems, proposing to model data as entities and the relationships between them.
-
On Closed World Data Bases
1978
writing
★ seminal
formalism
Raymond Reiter's 1978 paper formalizing the closed-world assumption: a database may treat any fact it cannot show to be true as false.
-
MapReduce: Simplified Data Processing on Large Clusters
2004
writing
★ seminal
2004 OSDI paper by Jeffrey Dean and Sanjay Ghemawat describing how Google split computations over huge datasets across thousands of ordinary machines; it set the pattern for big data processing.
-
YAGO: A Core of Semantic Knowledge Unifying WordNet and Wikipedia
2007
writing
WWW 2007 paper presenting YAGO, a knowledge base that attaches facts extracted from Wikipedia to WordNet's taxonomy, with high measured accuracy.
-
Linked Movie Data Base
2009
writing
technique
2009 workshop paper by Oktie Hassanzadeh and Mariano Consens presenting LinkedMDB, linked open data about films and their links to other datasets.
-
Semantics and Complexity of SPARQL
2009
writing
★ seminal
formalism
Paper by Pérez, Arenas and Gutiérrez giving SPARQL a compositional formal semantics and proving the complexity of evaluating it; general SPARQL patterns are PSPACE-complete.
-
Executing SPARQL Queries over the Web of Linked Data
2009
writing
technique
ISWC 2009 paper by Hartig, Bizer and Freytag proposing link-traversal querying: a SPARQL query is answered by following links and looking up URIs as it runs, so the data sources need not be known in advance.
-
Foundations of RDF* and SPARQL*
2017
writing
formalism
Olaf Hartig's 2017 paper proposing to nest RDF triples, so a statement can carry metadata such as a source or a certainty score without standard reification's bloat. It led to RDF-star and to triple terms in RDF 1.2.
-
Report of the W3C Workshop on Web Standardization for Graph Data
2019
writing
debate
Report of a W3C workshop held in Berlin in March 2019 that brought the RDF, property-graph and SQL communities together. It backed a property-graph query language developed alongside SQL (GQL) and discussed extending RDF to make statements about statements.
-
Knowledge Graphs
2021
writing
★ seminal
Survey by Aidan Hogan and 17 co-authors of the data models, query languages, reasoning and methods behind knowledge graphs.
Standards 2
-
STEP
1994
standard
ISO's family of standards for describing manufactured products so CAD, manufacturing and archive systems can exchange them, begun in 1984 and first published in 1994–95; its EXPRESS schema language is an early example of a formal shared data model across an industry.
-
GQL
2024
standard
ISO standard query language for property graphs, published in April 2024 and partly derived from Neo4j's Cypher; the property-graph counterpart to SPARQL.
Projects 6
-
Canada Geographic Information System
c. 1963–c. 1989
project
Early geographic information system built for the Government of Canada from the early 1960s to store and analyse the Canada Land Inventory; it ran until the late 1980s.
-
Virtuoso
1998
project
OpenLink Software's database server for SQL and RDF data, used to publish DBpedia and many other Linked Data sets.
-
Apache Hadoop
2006
project
Open-source framework, started in 2006 by Doug Cutting and Mike Cafarella, that implemented MapReduce and a distributed file system and made big data processing available outside Google.
-
Neo4j
2007
project
Property-graph database queried with the Cypher language; begun as an open-source project in Sweden in 2007, with version 1.0 in 2010.
-
YAGO
2007
project
Knowledge base built at the Max Planck Institute for Informatics that combines facts from Wikipedia with WordNet's taxonomy (later with schema.org's); with DBpedia, one of the first large knowledge bases extracted from Wikipedia.
-
Linked Movie Database
2009
project
Linked open data about films, built at the University of Toronto and presented in April 2009, with links from its films to DBpedia and other datasets.
Organizations 2
-
ISO
1947
organization
International Organization for Standardization, which publishes GQL and Topic Maps.
-
OpenLink Software
1992
organization
Database and Linked Data software company founded by Kingsley Idehen; it develops Virtuoso.
People 21
-
Edgar F. Codd
1923–2003
person
British computer scientist at IBM who invented the relational model of data in 1969–1970, the basis of relational databases; he received the 1981 Turing Award.
-
Raymond Reiter
1939–2002
person
Canadian computer scientist and logician who formalized the closed-world assumption for databases in 1978.
-
Peter Chen
b. 1947
person
Taiwanese-American computer scientist who introduced the entity–relationship model in 1976, later at Carnegie Mellon and Louisiana State University.
-
Gerhard Weikum
b. 1957
person
German database researcher at the Max Planck Institute for Informatics, co-author of the YAGO paper (2007).
-
Kingsley Idehen
b. 1965
person
Founder and CEO of OpenLink Software and a chief architect of its Virtuoso server, which publishes DBpedia.
-
Aidan Hogan
person
Semantic Web researcher at the University of Chile and lead author of the 2021 survey 'Knowledge Graphs'.
-
Alon Halevy
person
Israeli-American computer scientist working on data integration; co-author of 'The Unreasonable Effectiveness of Data' (2009).
-
Claudio Gutiérrez
person
Chilean computer scientist at the Universidad de Chile and co-author of the formal semantics of SPARQL (2009).
-
Doug Cutting
person
American software designer who co-created Apache Hadoop, as well as the search libraries Lucene and Nutch.
-
Fabian M. Suchanek
person
Computer scientist, now a professor at Télécom Paris, who created YAGO.
-
Gjergji Kasneci
person
Computer scientist, co-author of the YAGO paper (2007).
-
Jeff Dean
person
American computer scientist at Google who co-designed MapReduce and co-wrote word2vec.
-
Johann-Christoph Freytag
person
German computer scientist and database researcher who co-authored the 2009 paper on querying the Web of Linked Data by following links.
-
Jorge Pérez
person
Chilean computer scientist at the Pontificia Universidad Católica de Chile and co-author of the formal semantics of SPARQL (2009).
-
Marcelo Arenas
person
Chilean computer scientist at the Pontificia Universidad Católica de Chile and co-author of the formal semantics of SPARQL (2009).
-
Mariano Consens
person
University of Toronto computer scientist and co-author of the Linked Movie Database.
-
Martin Kleppmann
person
Associate professor at the University of Cambridge working on local-first software and distributed systems; lead author of the 2024 Bluesky paper.
-
Mike Cafarella
person
American computer scientist who co-created Apache Hadoop.
-
Oktie Hassanzadeh
person
Computer scientist who built the Linked Movie Database at the University of Toronto, presented in 2009.
-
Sanjay Ghemawat
person
American software engineer at Google, co-author of MapReduce.
-
Xin Luna Dong
person
Chinese-American computer scientist who led Google's Knowledge Vault and later Amazon's product knowledge graph.