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.
-
What is data management and why is it important?
Data management is the process of ingesting, storing, organizing and maintaining the data created and collected by an organization, as explained in this in-depth look at the process.
-
E
Extract, Load, Transform (ELT)
Extract, Load, Transform (ELT) is a data integration process for transferring raw data from a source server to a data system (such as a data warehouse or data lake) on a target server 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)...