Within the OrcaHouse project, we utilize a limited number of terminologies and follow conventions from a warehouse methodology that has been adopted.
They are documented in the following glossary table.
| Short | Long |
|---|---|
| RDBMS | Relational Database Management System |
| OLTP | Online Transaction Processing |
| OLAP | Online Analytical Processing |
| ETL | Extract, Transform, Load |
| ELT | Extract, Load, Transform |
| EDW | Enterprise Data Warehouse |
| DWH | Data Warehouse |
| BI | Business Intelligence |
| DM | Data Mart |
| IM | Information Mart |
| SQL | Structured Query Language |
| FDW | Foreign Data Wrapper |
| CDC | Change Data Capture |
| ODS | Operational Data Store |
| TSA | Transient Staging Area |
| PSA | Persistent Staging Area |
| DCL | Data Consolidation Layer |
| LDTS | Load Date Timestamp |
| RSRC | Record Source |
| DV2 | Data Vault 2.0 |
| RV | Raw Vault (DV2) |
| BV | Business Vault (DV2) |
| HUB | Hub Entity (DV2) |
| SAT | Satellite Entity (DV2) |
| LNK | Link Entity (DV2) |
| EFFSAT | Effectivity Satellite |