Part 1 : You can find HERE
dimension tables
Tables
used to establish the context of the facts.
dimensional database
A
single large table of facts described using measures and dimensions.
dimensions
In a
dimensional database, the context for a fact and is used in queries to group
related facts together.
disparate data
sources
Sources
that provide heterogeneous data, which cannot be integrated easily with a
database management system.
Document-driven
support system
Converts
documents such as oral communication transcripts, written reports, and memos
into standardized data formats to enable decision making.
DOLAP
(Desktop
OLAP). An OLAP system that allows you to download a section of the data from
the database or source and work with that dataset locally or on your desktop.
Enterprise-driven
support system
Connected
to large data warehouses that help managers make important decisions at all
levels of an organization.
external data source
A data
source that is a collection of data gathered from external sources such as an
organization's statistics and market share data of competitors.
Extract-Transform-Load
(ETL)
A
process that involves extracting data from the source systems and transforming
data to meet quality and consistency standards, and finally delivering data in
a user friendly format.
fact tables
Tables
used to record actual facts or measures in a business.
fields
In a
relational database, the smallest structure in a table; contains data
describing the subject of a table.
Forecasting
Involves
predicting the business outlook at a given time frame in the future by
analyzing data from the data warehouse.
Genetic Algorithms
A data
mining tool that uses principles such as survival of the fittest, mutation, and
genetic evolution to classify data sets.
GIS
Geographic
Information Systems (GIS). A system that captures, stores, analyzes, manages
and presents data with reference to geographic location data.
HOLAP
(Hybrid
OLAP). An OLAP system that divides the total data between the relational
database and the specialized storage area for storing important data elements.
internal data source
A data
source that is a collection of private data maintained by users in an
organization, portions of which could be used to build a data warehouse.
Key Performance
Indicators
A set
of defined indicators of performance for a particular process in the company.
Knowledge-driven
support system
Analyzes
large volumes of data, identifies patterns or trends in them, and provides
results based on the analysis to aid decision making.
Link Analysis
A
technique used to identify links and establish patterns in data by analyzing
the relationships between data items.
measures
In a
dimensional database, as quantity describing the fact.
Memory-Based
Reasoning (MBR)
A
technique used to classify a set of data by referring to past results.
metadata
The
data that describes data warehousing.
Model-driven support
system
Manipulates
and represents data in specific formats such as statistical reports or
simulations that will aid in decision making.
MOLAP
(Multidimensional
OLAP). An OLAP system where data is pre-summarized and is stored in an
optimized format in a multidimensional cube.
mOLAP
(Mobile
OLAP). An OLAP system that enables you to access and work on OLAP data and
applications remotely through the use of a mobile device.
multidimensional
database
A
database constructed with the multiple dimensions pre-filled in hyper
dimensional cubes of data rather than the traditional two dimensional tables of
relational databases.
Nearest neighbor
A
prediction technique based on the principle that data items close to one
another display similar characteristics.
Neural Networks
A data
mining tool similar to a biological neural network and that tries to function
in the same way.
Non-volatility
A
characteristic of data where data cannot be updated once it is loaded into the
data warehouse.
normalization
The
process of organizing data to minimize redundancy.
Online Analytical
Processing (OLAP)
Is used
to analyze database information from multiple database systems at one time.
Online Transaction
Processing (OLTP)
A class
of systems that facilitate and manage transaction-oriented applications,
typically for data entry and retrieval transaction processing.
Operational Data
Store
(ODS) A
database designed to integrate data from multiple sources for additional
operations on the data.
primary key
A
unique identifier for a database record.
record
In a
relational database, a particular instance of the subject of a table.
relational database
A set
of tables that contains data fitted into predefined categories.
ROLAP
(Relational
OLAP). An OLAP system that works primarily from the data in a relational
database, where the base data and dimension tables are stored as relational
tables.
schema
A
graphical representation of the database structure.
slowly changing
dimension
A
dimension whose data changes over time.
snowflake schema
A more
complex data warehouse schema than a star schema, in which the fact table is
indirectly linked to a number of dimension tables, which have parent-child
relationships.
SOLAP
(Spatial
OLAP). An OLAP system that facilitates the management of both spatial and
non-spatial data.
star schema
A
relational database schema used to represent multidimensional data, in which
every dimension is connected to every other through a fact.
subject-orientation
A
characteristic of data where data is collected based on a particular subject
such as products or customers.
surrogate key
A
system-generated artificial primary key that is not derived from any data in
the database.
tables
In a
relational database, a collection of data arranged in rows and columns. A table
is the largest structure in a relational database.
time-variance
A
characteristic of data where data is stored from the time it was created till
any time in the future.
transactional
database
A
Database Management System (DBMS) where transactions on the database can be
rolled back if they are not completed properly.
WOLAP
(Web
OLAP). An OLAP system that is accessible via the web browser.