A Central Data Warehouse is a repository of company data where a database is created from operational data extracts. This database adheres to a single consistent enterprise data model to ensure consistency in decision making support across the company. A Central Data Warehouse is a single physical database which contains business data for a specific...

Active Data Warehouse is repository of any form of captured transactional data so that they can be used for the purpose of finding trends and patterns to be used for future decision making. According to Bill Inmon a prominent data warehousing practitioner data warehouse defined in terms of subject-oriented time variant non-volatile and integrated. Subject-oriented...

An Active Metadata Warehouse is a repository of Metadata to help speed up data reporting and analyses from an active data warehouse. In its most simple definition a Metadata is data describing data. Many companies have spent years and billions of dollars trying to cleanse profile extract transform load and aggregate many different types of data...

Enterprise Data Warehouse is a centralized warehouse which provides service for the entire enterprise. A data warehouse is by essence a large repository of historical and current transaction data of an organization. An Enterprise Data Warehouse is a specialized data warehouse which may have several interpretations. Several terms used in information...

Today s business environment is very data driven and more companies are hoping to create competitive advantage over other business organization competitors by creating a system whereby they can assess the current status of their operations any at any given moment and at the same time they can also analyze trends and patterns within the company operation...

Operational Metadata are metadata about operational data. Metadata is basically a kind of data that describes another data content item or another collection of data which includes multiple content items. Its main purpose is to facilitate better understanding use and management of data. The use and requirement of metadata varied depending on the...

A Centralized Data Warehouse is a data warehousing implementation wherein a single data warehouse serves the needs of several separate business unites simultaneously using a single data model that spans the needs of multiple business divisions. Today having information means having power. In any a lot of aspects of daily living having relevant...

Metadata Warehouse is a database that contains the common metadata and client-friendly search routines to help people fully understand and utilize the data resource. It contains common metadata about the data resource in a single organization or an integrated data resource that crosses multiple disciplines and multiple jurisdictions. It contains a history...

An aggregate data is the data that is the result of applying a process to combine data elements from different sources. The aggregate data is usually taken collectively or in summary form. In relational database technology aggregate data refers to the values returned when one issues an aggregate function. The query function examines the aspects...

Atomic data are data elements that represent the lowest level of detail. For example in a daily sales report the individual items sold would be atomic data while rollups such as invoice and summary totals from invoices are aggregate data. The word atomic data is based on the atom where in chemistry and physics is the smallest particle that can...