Skip to content

Instantly share code, notes, and snippets.

@Mattia46

Mattia46/Database.md

Last active November 2, 2015 16:17
Show Gist options
  • Save Mattia46/30232a7cd11c3b8b6293 to your computer and use it in GitHub Desktop.
Save Mattia46/30232a7cd11c3b8b6293 to your computer and use it in GitHub Desktop.
Download ZIP
Differences between Relational DB, NoSQL and Flat files
Raw
Database.md

Relational DB vs NoSQL vs Flat files:

Relational DB: The relational database organizes data into table with columns and row.Each row has an unique 'primary key' identifying the row. The column represent a row attribute. Most of the relational database system use SQL (Structured Query Language) as the language for insert, querying, updating and deleting information.

NoSQL is a non relational database so without a predefined schema. The simplest NoSql structure is the Hash (key => value) that let the NoSQL being more scalable, agile and provides superior performance.

The Flat Files has not relational structure. An example of Flat Files is a text document or lines of ASCII test. Usually the flat files contain one record per line separated with a comma.

Mattia & Julien

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