DW software Definitions
-
A
Apache Hive
Apache Hive is an open source data warehouse system for querying and analyzing large data sets that are principally stored in Hadoop files.
-
D
data mart (datamart)
A data mart is a repository of data that is designed to serve a particular community of knowledge workers.
-
data warehouse
A data warehouse is a federated repository for all the data collected by an enterprise's various operational systems, be they physical or logical.
-
data warehouse as a service (DWaaS)
Data warehousing as a service (DWaaS) is an outsourcing model in which a service provider configures and manages the hardware and software resources a data warehouse requires, and the customer provides the data and pays for the managed service.
-
E
Extract, Load, Transform (ELT)
Extract, Load, Transform (ELT) is a data integration process for transferring raw data from a source system to a target database and then preparing the information for downstream uses.
-
extract, transform, load (ETL)
In managing databases, extract, transform, load (ETL) refers to three separate functions combined into a single programming tool.
-
O
OLAP (online analytical processing)
OLAP (online analytical processing) enables a user to easily and selectively extract and view data from different points-of-view.
-
S
semantic technology
Semantic technology is a set of methods and tools that provide advanced means for categorizing and processing data, as well as for discovering relationships within varied data sets.
-
T
tree structure
A tree structure is an algorithm for placing and locating files (called records or keys) in a database. The algorithm finds data by repeatedly making choices at decision points called nodes. A node can have as few as two branches (also called children)...