Data Warehouse Glossary

ADW - Active Data Warehouse [Teradata]

AMPP - Asymmetric Massively Parallel Processing [Netezza NPS]

AJI - Aggregate Join Indexes [Teradata]

CLR - Common Language Runtime

DBMS - Database Management System

DM - Data Mart

DW - Data Warehouse

DWA - Data Warehouse Appliance

EDW - Enterprise Data Warehouse

I/O - Input/Output Interconnection

JDBC - Java Database Connectivity

MOLAP - Multi-dimensional Online Analytical Processing [Cubes]

MPP - Massively Parallel Processing

NLB - Network Load Balancing

ODBC - Open Database Connectivity

ODM - Object Database Model

OLTP - Online Transaction Processing

RDMS - Relational Data Management System

ROLAP - Relational Online Analytical Processing

SAN - Storage Area Network

SMP - Symmetric Multiprocessors [Also see MPP]

SN - Shared Nothing Architecture

SPU - Snippet Processing Units [Netezza NPS]

SQL - Sequel Query Language

SSAS - Microsoft SQL Server Analysis Services [for OLAP and data mining]

Back To Top