Databases Reference
In-Depth Information
Basic networking of computers, via a local area or wireless network, is
another example of infrastructure.
Junk dimension
A dimension that brings together single attributes that may
or may not have any true relationship to each other in order to simplify the
model, improve query performance, and/or reduce data storage.
Master data management (MDM)
The processes and tools to help an orga-
nization consistently define and manage core reference or descriptive data
across the organization. This may involve providing a centralized view of
the data to ensure that its use for all business processes is consistent and
accurate.
Multi-dimensional OLAP (MOLAP)
OLAP technology whereby the data is
stored in proprietary array structures called
multi-dimensional cubes
.
See also
OLAP.
Normalized model
A data model organized to clarify pure data relationships
and targeted at gaining efficiencies in data storage and maintenance. This
is used for the design of transaction processing systems. There are specific
rules for normalization. Depending upon the number of rules followed (for
different purposes) there are different ''forms,'' such as third normal form.
See also
entity-relationship model.
Online analytical processing (OLAP)
A collection of common business
analysis functions that are difficult to perform directly with SQL. Some of
the specific functions that fall under the OLAP umbrella include time series
comparisons, ranking, ratios, penetration, thresholds, and contribution to
report or to the whole data population. Most business intelligence tools
provide this type of functionality. The capabilities can be implemented in
a variety of different data storage mechanisms.
See also
MOLAP, ROLAP,
HOLAP.
Online transaction processing (OLTP)
Online transaction processing
(OLTP) systems are the fundamental systems used to run the business.
These are also called operational systems or operational applications. They
are often used as sources of data for the data warehouse.
Operational data store (ODS)
A collection of data from operational systems,
most often integrated together, that is used for some operational purpose.
The most critical characteristic here is that this is used for some opera-
tional function. This operational dependency takes precedence and the ODS
should not be considered a central component of the data warehousing
