Sponsored Links

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 Database is the database of record consisting of system specific reference data and event data belonging to a transaction update system It may also contain system control data such as indicators flags and counters The operational database is the source of data for the data warehouse It contains detailed data used to run the day to day...
An Operational Data Store ODS is an integrated database of operational data Its sources include legacy systems and it contains current or near term data An ODS may contain 30 to 60 days of information while a data warehouse typically contains years of data An operational data store is basically a database that is used for being an interim area...
On Line Analytical Processing On Line Analytical Processing is a processing that supports the analysis of business trends and projections It is also known as decision support processing and OLAP An OLAP software enables companies to have real time analysis of data stored in a database An OLAP server is typically a separate component of an...
On Line Transaction Processing On Line Transaction Processing is a processing that supports the daily business operations Also know as operational processing and OLTP An OLTP is a database which must typically allow the real time processing of SQL transactions to support traditional retail processes e commerce and other time critical applications...
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...
Administrative data is used to help the data warehouse administrator manage the warehouse These data may include profiles of users and order history data Many organizational policies standards conventions and definitions are based on administrative data In a data warehouse a multiple variety of information from different sources are integrated...
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...
In the broadest sense of the word aggregation means collecting and combining of data horizontally vertically and chronologically and then expressed in summary form to be used for statistical analysis In the more technical sense aggregation is a special kind association that specified a part of whole relationship between the component part and the...
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...
Automatic data partitioning is the process of breaking down large chunks of data and metadata at a specific data site into partitions according to the request specification of the client Data sites contain multitudes of varied data which can be extremely useful as a statistical basis for determining many trends in businesses Because data in the...
Automatic Data Replication is the process wherein created data and metadata automatically replicates based in the request of the client at a specific data site A data site could maintain many computers working as a system to manage one or more data warehouses These warehouses are repositories of millions of millions of data and more are gathered...
Business data refers to the information about people places things business rules and events in relation to operating a business Serious businesses need to consider setting up business intelligence and data warehouses In pursuing these capabilities they need to adopt a holistic view coupled with wise investment and careful execution...
A Business driven approach is any process of identifying the data needed to support business activities acquiring or capturing those data and maintaining them in the data resource Everyday billions of data and information gets carried across different communications media The number medium is of course the internet Another data communications...