Wednesday, July 17, 2013

DWH One Liners - Part-2


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.