What is Atomic Data
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 summar...
Author Archives: Editorial Team
What is Aggregation
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 analys...
Aggregate Data
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 relatio...
What is Administrative Data
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, co...
Metadata Warehouse
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...
Centralized Data Warehouse
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 sp...
Operational Metadata
Operational Metadata 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 inclu...
On-Line Transaction Processing
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 m...
On-Line Analytical Processing
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. A...
What is Operational Data Store (ODS)
Operational Data Store (ODS) 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 co...