Data Models
This model lays out all of the data in the open with no labyrinthine nested structures.
What is the relation model?
Probably the best known data model today, based on the relational model proposed by Edgar Codd in 1970
What is SQL?
The latest attempt in the 2010s to overthrow the relational models dominance.
What is NoSql?
A framework to reduce the amount of boilerplate code required for a transaction layer to a DB.
What is an ORM?
At the time of writing this DB does not support joins.
What is MongoDB?
this data model was remarkably similar to JSON model used by Document DBs.
What is the hierarchical model?
This DB offers the locality property using a feature called multi-table index cluster tables.
What is Oracle SQL?
When the structure of data is implicit, and only interpreted when the data is read.
When the structure of data is implicit, and only interpreted when the data is read.
A way of accessing a record by following this from the root record along chains of links.
What is an access path?
These constraints allow you to restrict modification, but such constraints are not required by Relational DB. Joins on these are performed at query time even with constraints.
What is a foreign key?
this specific model was generalized hierarchical model where every record has one parent.
What is the network model?
A technique of splitting a document-like structure into multiple tables.
What is Shredding?
This relationship type is simplified with DocumentDB by removing the need for shredding data across different tables.
What is one-to-many?
A technique that makes it possible to reduce the need for joins, but then the application code needs to do additional work to keep the resulting data consistent.
What is denormalizing?
A term referenced from Jessica Kerr's "Provenance and Causality in Distributed Systems" that retroactively reinterpreted another similar term
What is Not Only Sql?
The most natural data model for highly interconnected data.
What are graph data models?
This DB offers the locality properties in a relational data model by allowing the schema to declare that a table's rows should be nested within a parent table.
What is Google's Spanner DB?
A binary variant of a document encoding used in MongoDB.
What is BSON?
A way for related items to be uniquely identified in a Document DB.
What is a document reference?
The idea of using or relational DB along side nonrelational datastores referenced in Pat Helland and Dave Campbell's "Building on Quicksand"
What is Polyglot Persistence?
A data model used by Cassandra and Hbase.
By the mid 1980s this relational database management system along with SQL had become the tools of choice for most people who needed to store and query data with some kind of regular structure.
What is RDBMSes?
A Document DB that supports relational-like joins in its query language.
What is RethinkDB?
A performance improvement resulting from using a document usually stored as a single continuous encoded string.
What is storage locality?
Codd's original description of the relational model that actually allowed something quite similar to JSON documents within a relational schema.
What are nonsimple domains?