Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search

View all Portals

Scheduled Events

White Paper Library
Research Papers

View Job Listings
Post a job


DM Review Home
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

Buyer's Guide
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

About Us
Press Releases
Advertising/Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service



If you do not see a particular word or phrase that you would like to know the definition of, please let us know by writing to MaryJo.Nott@sourcemedia.com and indicate the term you would like us to add to the Glossary.

Fact Table
A central table in a data warehouse schema that contains numerical measures and keys relating facts to dimension tables. Fact tables contain data that describes specific events within a business, such as bank transactions or product sales.

A technology that typically replaces a specific DBMS load function. A fastload technology obtains significantly faster load times by preprocessing data and bypassing data integrity checks and logging.

Federated Data
The federated data warehouse approach supports the iterative development of a data warehousing system containing independent data marts.

A method of posting a transaction in first-in-first-out order. In other words, transactions are posted in the same order that the data producer entered them.

File Transfer Protocol (FTP)
A service that allows you to transfer files to and from other computers on the Internet. Anyone who has access to ftp can transfer publicly available files to his or her computer. Files retrieved from outside sources can contain viruses. All files retrieved from the Internet should be check with a virus protection program.

Saved sets of chosen criteria that specify a subset of information in a data warehouse.

Financial Accounting Standards Board (FASB)
FASB was created in 1973, replacing the Accounting Principles Board and the Committee on Accounting Procedure of the American Institute of Certified Public Accountants before it. The FASB is a private body whose mission is to establish and improve standards of financial accounting and reporting for the guidance and education of the public, including issuers, auditors and users of financial information. The FASB publishes the Generally Accepted Accounting Procedures (GAAP).*

Financial Consolidation
The process of consuming data from different financial systems and combining that information through aggregation and consolidation to create financial analytic views and comprehensive financial statements, which are compliant with accounting and financial reporting standards.*

Financial Integrity
Refers to compliant and reliable financial data achieved through quality integrated systems and processes, strong internal control, validations to ensure accuracy and conformance with accounting and reporting standards.*

A combination of specialized hardware and software set up to monitor traffic between an internal network and an external network (i.e. the Internet). Its primary purpose if for security and is designed to keep unauthorized outsiders from tampering with or accessing information on a networked computer system.

First Normal Form
The result of normalizing to ensure that every attribute is dependent upon the key of an entity. In practice this is achieved by removing repeating groups and multi-valued attributes and modeling them as distinct entities.

Provide baseline metrics to support, track and measure the performance of an initiative.

Foreign Key
A foreign key is the primary key of one data structure that is placed into a related data structure to represent a relationship among those structures. Foreign keys resolve relationships, and support navigation among data structures.

Fraud Detection Application
The process of detecting patterns, trends or correlations in consumer or corporate behavior that might indicate that fraudulent activity is taking place; e.g., identifying potential or existing fraud through analysis and comparison of standard and aberrant behaviors.

The timing characteristics of the data.

Functional Data Warehouse
A warehouse that draws data from nearby operational systems. Each functional warehouse serves a distinct and separate group (such as a division), functional area (such as manufacturing), geographic unit, or product marketing group.

* definition provided by Hyperion.

Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.