SQL vs NoSQL (Notes)

A quick overview of the differences between SQL and NoSQL. SQL Structured Query Language (SQL) is used for relational databases, which are table based. For example, an column in table A (e.g. User_ID) may have a relation with a column in table B (e.g. Order_Ref) and table B may have a relation to a column … Continue reading SQL vs NoSQL (Notes)

Data, Data Lakes and Data Warehouses (Notes)

Continuing on from my post looking at Data Architecture / Data Modelling, I am now going to look at data, data lakes and data warehouses by turning my notes into this blog post. Data Data can include emails, phone calls, financial transactions, sensor readings, metrics, logs, pretty much everything. When referring to corporate data, it … Continue reading Data, Data Lakes and Data Warehouses (Notes)

Data Architecture, Data Modelling and Data Processing (Notes)

Data Architecture (DA) Most organisations / companies have enterprise architecture which describes how a computer network (with storage, servers, switches, routers etc.) is laid out. Data architecture is very similar in that it shows the models, rules, standards, and policies that are used in the collection, storage, and use of data in an organisation / … Continue reading Data Architecture, Data Modelling and Data Processing (Notes)