|
A remote data source tfgefwefeefw fwhat users can query/access via a central
gateway that provides a logical view of corporate data in terms that users can
understand. The gateway parses and distributes queries in real time to remote
data sources and returns result sets back to users.
|
|
|
Decision Support Systems (DSS) |
|
Software that supports exception reporting, stop light reporting, standard
repository, data analysis and rule-based analysis. A database created for
end-user ad-hoc query processing.
|
|
|
the technique of placing normalized data in a physical location that optimizes
the performance of the system.
|
|
|
Data whose values are determined by equations or algorithms.
|
|
|
Dimension is typically a qualifiable and text value, such as a region, product
line, and includes date values. It defines the secondary headings or labels that
make up the body of the report. Each of the dimensions is repeated within each
group. Usually, you use items containing text values (for example, Year or item
type) for table dimensions. For example, if you select Item Type to be your
table dimension, Item Type is a dimension within each group header. Under the
dimension "Item Type," appears the name of each kind of item (for example, CD
ROM, or HARD Drive). and corresponds to the . A fact is an quantifiable value,
such amount of sales, budget or revenue.
|
|
The ability to move between levels of the hierarchy when viewing data with
multiple levels.
A) Drill down – changing a view to a greateer level of
detail
B) Drill up – changing a view to a greater level of aggregation.
|
|
|
EDI (Electronic Data Interchange) |
|
is a standard format for exchanging business data.
|
|
|
the transformation of data from a recognizable format to a form unrecognizable
without the algorithm used for the transformation.
|
|
|
ETL (Extract, Transform and Load) |
|
ETL refers to the process of getting data out of one data store (extract),
modifying it (transfer), and inserting it into a different data store (load).
|
|
|
ETL is sometimes referred as ETT- Extraction, Transformation and Transportation.
It is a series of batch interface between the systems.
|
|
|
Executive/Enterprise Information Systems (EIS) |
|
Tools programmed to provide canned reports or briefing books to top-level
executives. They offer strong reporting and drill-down capabilities. Today these
tools allow ad-hoc querying against a multi-dimensional database, and most offer
analytical applications along functional lines such as sales or financial
analysis. (Also known as Decision Support System.)
|
|
|
The ability to easily add new functionality to existing services without major
software rewrites or without redefining the basic architecture.
|
|
|
a logical description of a user's method of organizing and structuring data.
|
|
|
The tables which are extracted from heterogeneous sources and used in the Data
Wareahouse
|
|
|
A fact table without any metrics in it
|
|
|
a collection of records containing no data aggregates, nested repeated data
items, or groups of data items.
|
|
|
the division of operations into hierarchical functions that form the basis for
procedures.
|
|
|
Provides access to information scattered throughout an enterprise under the
control of different divisions or departments with different databases and data
models. This type of data warehouse is difficult to build because it requires
users from different divisions to come together to define a common data model
for the warehouse.
|
|
|
The level of detail of the data stored in a data warehouse.
|
|
|
Within an enterprise, a network of different types of servers and databases.
|
|
Glossary 
