Technical Terminology

Did you see a term somewhere else and I didn't explain it? Chances are it is explained below.

---

A

AI

Means Artificial Intelligence. Field of computer science where computers can be trained on data to do things they are specifically programmed to do using math and statistics.

L

LLM

Means Large Language Model. It's a type of machine learning model that can have human like conversations. It is the technology behind chatbots.

M

Machine Learning

Subset of AI concerned with building models that can be trained to do things without programming.

N

Normalization

Database design pattern that uses relationships between tables.

NoSQL

Means Not Only SQL. Type of databases system using primarily in big data.

Null

Means no value. Think of a toilet paper holder. There is nothing there, not even an empty tube.

O

OLAP

Means Online Analytical Processing. Database design philosophy designed for analytics and used in data warehouses.

OLTP

Means Online Transactional Processing. Database design philosophy designed for transactional system such as apps.

S

Snowflake Schema

Database schema with more normalization. Also the name for a cloud data warehouse provider.

SQL

Means Structured Query Language. Language used to query databases.

Star Schema

Database schema with fewer relationships. Gets its name because it has a facts table which stores metrics surrounded by dimension tables which give context to the facts, which looks like a star when viewing the relationship diagram.