OLTP-OLAP-CRUD-ACID and other acronyms.

On-line, on-line … processing

OLTP: On-Line Transaction Processing

— does typical database stuff, provides data to the warehouse for OLAP

OLAP – On-Line Analytic Processing

— does analysis

CRUD – create, read, update and delete
— SCRUD (Search…)
— BREAD (Browse, Read, Edit, Add, Delete)

ACID – Atomicity, Consistency, Isolation, Durability

RBAR –  row by agonizing row

from Don Jones (SQL Server Admin in AMOLunches)
– SQL – Structured Query Language
– DML – Data Manipulation Language
– DDL – Data Definition Language
– SSRS – SQL Server Reporting Services
– SSIS – SQL Server Integration Services
– SSAS – SQL Server Analysis Services
– DMO – Database Management Obejcts

Advertisements