Skip to content

Instantly share code, notes, and snippets.

@O-I

O-I/object-relational-impedance-mismatch.md

Last active November 6, 2017 23:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save O-I/e177cd52c811928fad9d124d8c029bd8 to your computer and use it in GitHub Desktop.
Save O-I/e177cd52c811928fad9d124d8c029bd8 to your computer and use it in GitHub Desktop.
Download ZIP
Object-Relational Impedance Mismatch
Raw
object-relational-impedance-mismatch.md

The fundamental difficulty

Straight from the wiki:

Fundamentally, objects (instances) reference one another and therefore form a graph in the mathematical sense (a network including loops and cycles). Relational schemas are, in contrast, tabular and based on the relational algebra, which defines linked heterogeneous tuples (groupings of data fields into a "row" with different types for each field).

Converting linked tabular rows to graph structures is hard, and even described as the Vietnam of Computer Science.

Further reading:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment