Chapter 3: Data Models and Query Languages

Reference 1 in Chapter 3: Unexplanations: Query Optimization Works Because SQL Is Declarative

Jamie Brandon

2024

scattered-thoughts.net

Reference 2 in Chapter 3: What Declarative Languages Are

Neel Krishnaswami

2013

semantic-domain.blogspot.com

Reference 3 in Chapter 3: The Declarative Imperative: Experiences and Conjectures in Distributed Logic

Joseph M. Hellerstein

2010

www2.eecs.berkeley.edu PDF gone archived copy

Reference 4 in Chapter 3: A Relational Model of Data for Large Shared Data Banks

Edgar F. Codd

Communications of the ACM 1970

seas.upenn.edu PDF doi

Reference 5 in Chapter 3: What Goes Around Comes Around

Michael Stonebraker and Joseph M. Hellerstein

Readings in Database Systems 2005

mitpress2.mit.edu PDF

Reference 6 in Chapter 3: Modern SQL: Beyond Relational

Markus Winand

2015

modern-sql.com

Reference 7 in Chapter 3: Orm Hate

Martin Fowler

2012

martinfowler.com

Reference 8 in Chapter 3: N+1 Query Problem with JPA and Hibernate

Vlad Mihalcea

2023

vladmihalcea.com

Reference 9 in Chapter 3: This Is the Beginning of the End of the N+1 Problem: Introducing Single Query Loading

Jens Schauder

2023

spring.io

Reference 10 in Chapter 3: SQL Needed Structure

Jamie Brandon

2025

scattered-thoughts.net

Reference 11 in Chapter 3: 6 Rules of Thumb for MongoDB Schema Design

William Zola

2014

mongodb.com

Reference 12 in Chapter 3: Data Modeling in Azure Cosmos DB

Sidney Andrews and Christopher McClister

2023

learn.microsoft.com

Reference 13 in Chapter 3: Timelines at Scale

Raffi Krikorian

QCon San Francisco 2012

infoq.com

Reference 14 in Chapter 3: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

Ralph Kimball and Margy Ross

2013

learning.oreilly.com

Reference 15 in Chapter 3: Data Warehouse Modeling: Star Schema vs. OBT

Michael Kaminsky

2022

fivetran.com

Reference 16 in Chapter 3: User-defined Order in SQL

Joe Nelson

2018

begriffs.com

Reference 17 in Chapter 3: Realtime Editing of Ordered Sequences

Evan Wallace

2017

figma.com

Reference 18 in Chapter 3: Implementing Fractional Indexing

David Greenspan

2020

observablehq.com

Reference 19 in Chapter 3: Schemaless Data Structures

Martin Fowler

2013

martinfowler.com

Reference 20 in Chapter 3: Schema-on-Read vs. Schema-on-Write

Amr Awadallah

Berkeley EECS RAD Lab Retreat 2009

slideshare.net

Reference 21 in Chapter 3: The Trouble with Types

Martin Odersky

Strange Loop 2013

infoq.com

Reference 22 in Chapter 3: MongoDB—Confessions of a PostgreSQL Lover

Conrad Irwin

HTML5DevConf 2013

speakerdeck.com

Reference 23 in Chapter 3: Percona Toolkit Documentation: pt-online-schema-change

2023

docs.percona.com

Reference 24 in Chapter 3: gh-ost: GitHub's Online Schema Migration Tool for MySQL

Shlomi Noach

2016

github.blog

Reference 25 in Chapter 3: pg-osc: Zero Downtime Schema Changes in PostgreSQL

Shayon Mukherjee

2022

shayon.dev

Reference 26 in Chapter 3: Introducing pgroll: Zero-Downtime, Reversible, Schema Migrations for Postgres

Carlos Pérez-Aradros Herce

2023

xata.io

Reference 27 in Chapter 3: Spanner: Google’s Globally-Distributed Database

10th USENIX Symposium on Operating System Design and Implementation 2012

research.google

Reference 28 in Chapter 3: Reduce I/O with Oracle Cluster Tables

Donald K. Burleson

dba-oracle.com

perma.cc

Reference 29 in Chapter 3: Bigtable: A Distributed Storage System for Structured Data

Fay Chang, Jeffrey Dean, Sanjay Ghemawat and 6 others

7th USENIX Symposium on Operating System Design and Implementation 2006

research.google

Reference 30 in Chapter 3: XQuery*, 2nd edition

Priscilla Walmsley

2015

learning.oreilly.com

Reference 31 in Chapter 3: JavaScript Object Notation (JSON) Pointer

Paul C. Bryan, Kris Zyp and Mark Nottingham

2013

rfc-editor.org

Reference 32 in Chapter 3: JSONPath: Query Expressions for JSON

Stefan Gössner, Glyn Normington and Carsten Bormann

2024

rfc-editor.org

Reference 33 in Chapter 3: What Goes Around Comes Around… And Around…

Michael Stonebraker and Andrew Pavlo

ACM SIGMOD Record 2024

db.cs.cmu.edu PDF doi

Reference 34 in Chapter 3: The PageRank Citation Ranking: Bringing Order to the Web

Lawrence Page, Sergey Brin, Rajeev Motwani and Terry Winograd

ilpubs.stanford.edu gone

Reference 35 in Chapter 3: TAO: Facebook’s Distributed Data Store for the Social Graph

Nathan Bronson, Zach Amsden, George Cabrera and 12 others

USENIX Annual Technical Conference 2013

usenix.org

Reference 36 in Chapter 3: Industry-Scale Knowledge Graphs: Lessons and Challenges

Natasha Noy, Yuqing Gao, Anshu Jain and 3 others

Communications of the ACM 2019

cacm.acm.org doi

Reference 37 in Chapter 3: KÙZU Graph Database Management System

Xiyang Feng, Guodong Jin, Ziyi Chen and 2 others

13th Annual Conference on Innovative Data Systems Research 2023

cidrdb.org PDF

Reference 38 in Chapter 3: Demystifying Graph Databases: Analysis and Taxonomy of Data Organization, System Designs, and Graph Queries

Maciej Besta, Emanuel Peter, Robert Gerstenberger and 5 others

arXiv 2019

arxiv.org PDF

Reference 39 in Chapter 3: Apache TinkerPop. TinkerPop 3.6.3 Documentation

2023

tinkerpop.apache.org

Reference 40 in Chapter 3: Cypher: An Evolving Query Language for Property Graphs

Nadime Francis, Alastair Green, Paolo Guagliardo and 7 others

International Conference on Management of Data 2018

core.ac.uk PDF gone doi

Reference 41 in Chapter 3: Twitter correspondence

Emil Eifrem

2014

twitter.com

Reference 42 in Chapter 3: Explore the New SEARCH and CYCLE Features in PostgreSQL® 14

Francesco Tisiot

2021

aiven.io

Reference 43 in Chapter 3: Understanding Hierarchies in Oracle

Gaurav Goel

towardsdatascience.com 2020

medium.com

Reference 44 in Chapter 3: Seamless Syntactic and Semantic Integration of Query Primitives over Relational and Graph Data in GSQL

Alin Deutsch, Yu Xu and Mingxi Wu

tigergraph.com 2018

cdn2.hubspot.net PDF

Reference 45 in Chapter 3: PGQL: A Property Graph Query Language

Oskar van Rest, Sungpack Hong, Jinha Kim and 2 others

4th International Workshop on Graph Data Management Experiences and Systems 2016

event.cwi.nl PDF doi

Reference 46 in Chapter 3: GQL: The ISO Standard for Graphs Has Arrived

Philip Rathle and Brad Bebee

2024

aws.amazon.com

Reference 47 in Chapter 3: Graph Pattern Matching in GQL and SQL/PGQ

Alin Deutsch, Nadime Francis, Alastair Green and 15 others

International Conference on Management of Data 2022

victor.marsault.xyz PDF doi

Reference 48 in Chapter 3: SQL...And Now GQL

Alastair Green

2019

opencypher.org

Reference 49 in Chapter 3: Neptune Graph Data Model

Amazon Web Services

docs.aws.amazon.com

Reference 50 in Chapter 3: Datomic Data Model

Cognitect

docs.datomic.com

Reference 51 in Chapter 3: Turtle—Terse RDF Triple Language

David Beckett and Tim Berners-Lee

2011

w3.org

Reference 52 in Chapter 3: Whatever Happened to the Semantic Web?

Sinclair Target

2018

twobithistory.org

Reference 53 in Chapter 3: The Semantic Web Is Dead—Long Live the Semantic Web!

Gavin Mendel-Gleason

terminusdb.com 2022

github.com

Reference 54 in Chapter 3: JSON-LD and Why I Hate the Semantic Web

Manu Sporny

manu.sporny.org 2014

perma.cc

Reference 55 in Chapter 3: Biomedical Ontologies and Controlled Vocabularies

University of Michigan Library

guides.lib.umich.edu/ontology

guides.lib.umich.edu

Reference 56 in Chapter 3: The Open Graph Protocol

Facebook

ogp.me

Reference 57 in Chapter 3: Everything You Ever Wanted to Know About Unfurling but Were Afraid to Ask /or/ How to Make Your Site Previews Look Amazing in Slack

Matt Haughey

2015

medium.com

Reference 58 in Chapter 3: Resource Description Framework (RDF)

W3C RDF Working Group

2004

w3.org

Reference 59 in Chapter 3: SPARQL 1.1 Query Language

Steve Harris, Andy Seaborne and Eric Prud'hommeaux

2013

w3.org

Reference 60 in Chapter 3: Datalog and Recursive Query Processing

Todd J. Green, Shan Shan Huang, Boon Thau Loo and Wenchao Zhou

Foundations and Trends in Databases 2013

blogs.evergreen.edu PDF gone doi

Reference 61 in Chapter 3: What You Always Wanted to Know About Datalog (And Never Dared to Ask)

Stefano Ceri, Georg Gottlob and Letizia Tanca

IEEE Transactions on Knowledge and Data Engineering 1989

www2.cs.sfu.ca PDF doi

Reference 62 in Chapter 3: Foundations of Databases

Serge Abiteboul, Richard Hull and Victor Vianu

webdam.inria.fr/Alice 1995

webdam.inria.fr

Reference 63 in Chapter 3: LIquid: The Soul of a New Graph Database, Part 2

Scott Meyer, Andrew Carter and Andrew Rodriguez

2020

engineering.linkedin.com

Reference 64 in Chapter 3: Why, After 6 Years, I’m over GraphQL

Matt Bessey

2024

bessey.dev

Reference 65 in Chapter 3: Exploring CQRS and Event Sourcing

Dominic Betts, Julián Domínguez, Grigori Melnik and 2 others

2012

learn.microsoft.com gone archived copy

Reference 66 in Chapter 3: CQRS and Event Sourcing

Greg Young

Code on the Beach 2014

youtube.com

Reference 67 in Chapter 3: CQRS Documents

Greg Young

cqrs.wordpress.com 2010

cqrs.files.wordpress.com PDF

Reference 68 in Chapter 3: Crypto Shredding: How It Can Solve Modern Data Retention Challenges

Brent Robinson

2019

medium.com

Reference 69 in Chapter 3: Towards Scalable Dataframe Systems

Devin Petersohn, Stephen Macke, Doris Xin and 7 others

Proceedings of the VLDB Endowment 2020

vldb.org PDF doi

Reference 70 in Chapter 3: The TileDB Array Data Storage Manager

Stavros Papadopoulos, Kushal Datta, Samuel Madden and Timothy Mattson

Proceedings of the VLDB Endowment 2016

vldb.org PDF doi

Reference 71 in Chapter 3: Multidimensional Array Data Management

Florin Rusu

Foundations and Trends in Databases 2023

faculty.ucmerced.edu PDF doi

Reference 72 in Chapter 3: Bloomberg, Man Group Team Up to Develop Open Source 'ArcticDB' Database

Ed Targett

2023

thestack.technology

Reference 73 in Chapter 3: GenBank

Dennis A. Benson, Ilene Karsch-Mizrachi, David J. Lipman and 2 others

Nucleic Acids Research 2008

academic.oup.com doi