attribute
|
A field or column of a dimension
(or other) table.
|
BI
Business
Intelligence
|
A suite of software tools used
primarily by business administrative staff to navigate through the data of
the data warehouse. BI tools provide functionality including managed
reporting, queyring, data analysis, data visualization, etc.
|
|
|
data cube
cube
|
A multi-dimensional representation
of business data in which the cells of the cube contain data measures (i.e.
facts) and the edges of the cube represent the data dimensions.
Although a cube implies only 3 dimensions in geometry, a data cube may
represent any number of dimensions.
|
data mart
|
A subset of the organization's
data, focused on a specific subject area or business area.
|
data warehouse
DW
|
(1) A collection of data pulled
together primarily from operational business systems, structured and tuned
for easy access and use by consumers and analysts, especially in support of
forecasting and decision-making.
(2) A subject-oriented, integrated, time-varying, non-volatile collection of
data in support of the management's decision-making process. (John Inmon)
|
dimension
|
A set of attributes, usually
hierarchical, that is used to describe an organization's business by
constraining and grouping facts.
Example dimensions include time, students, faculty, organization, funds, etc.
|
DSS
Decision
Support
System
|
A software system used to support
decision-making processes within an organization.
|
EIS
Executive
Information
System
|
A concise set of customized,
high-level, generally graphical views of the organization's information,
enabling executive-level management to see the overall health of their
business.
|
ETL
Extraction,
Transformation,
Loading
|
A set of back-end data staging
steps that are used to (1) obtain data from operational sources (i.e. the
extraction step), (2) cleanse and prepare data for import into the data
warehouse (i.e. the transformation step), and (3) actually importing the
transformed data into the data warehouse (i.e. the loading step).
|
fact
|
A numeric (or other type of) data
element by which an organization measures aspects of its business. The most
useful facts are indeed numeric and often additive.
Example facts include dollar amounts (e.g. budget, expenditure, encumbrance,
revenue), counts (e.g. headcount, credit hours), etc.
|
grain
|
The meaning of a single record in
a fact table.
|
metadata
|
Data about data; any data
maintained to support the operation or use of a data warehouse, including
business names and definitions of facts, dimensions, attributes, etc.
|
ODBC
Open
Database
Connectivity
|
Often used in a Microsoft Windows
environment, ODBC is a standard protocol for accessing a majority of database
systems, including Oracle, Access, etc.
|
OLAP
On-Line
Analytical
Processing
|
A category of database software
systems that primarily involves aggregating large amounts of data from a data
warehouse environment.
|
OLTP
On-Line
Transactional
Processing
|
A category of database software
systems that typically involves processing transactions in real time.
|
RDBMS
Relational
Database
Management
System
|
A database (e.g. Oracle) in which
information is represented via tables and relationships between such tables.
The term RDBMS is also often used to refer to software that helps to
administer a database.
|
snapshot
|
Typically describes a fact
table that represents the state of affairs at the end of each time period.
|
SQL
Structured
Query
Language
|
A standard language for creating,
modifying, and querying an RDBMS.
|
star schema
|
A collection of dimensions joined
together with a single fact table that is used to construct queries against a
data warehouse.
|
No comments :
Post a Comment