Home Page   More about Data Engineering   SQL and NoSQL DB   sn.renauld@gmail.com
Introduction Definitions
Getting Started Pre-Requirements
SQL Databases
NoSQL Databases
More Info

Introduction

What is the difference between SQL and NoSQL databases? When we should use them?
The Short answer, if your data is very structured and ACID compliance is a must, SQL is a great choice. On the other hand, if your data requirements aren't clear or if your data is unstructured, NoSQL may be your best bet. This page document boths databases types and differences.

Definitions

  • SQL Structure Query Language: (CRUD) Create read update delete. Almost universal among SQL databases engines.
  • NoSQL Tables, Document, graphs. Build to scale with High Performance but queries less flexible.

References

Mongo DB SQL vs NoSQL
Building a Scalable Data Warehouse with Data Vault 2.0

Getting Started

Job scraping is to gather job posting information online in a programmatic manner. This automated way of extracting data from the web to build resourceful job database by integrating various data sources into one.