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.

C

CRM

Means Customer Relationship Managment. Application to manage customer contacts and relationships.

G

GIS

Means Geographic Information Systems. It is a system that mixes both hardware, software and data to visualize geographic data on maps and applications.

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.

P

POS

Means Point of Sale. It is the system a business uses to process transactions.

R

RIO

Means Return On Investment. It is how great of a return you get when you invest in something such as equipment.

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.