UNDERSTANDING ENTITIES - CHAPTER 2

What is an Entity ?An entity is s physical representation of a logical grouping of data. Entities can be tangible, real things, such as a PERSON or ICE CREAM, or intangible concepts, such as a COST CENTER or MARKET. Entities do not represent single things. Instead, they represent collections of instances that contain the information of interest...

Read more »

DATA MODELING CONCEPTS CHAPTER 1

CHAPTER 1-DATA MODELING CONCEPTS The Role of Data Modeling Data modeling tasks provide the most benefit when performed early in the development lifecycle. The model provides information critical to understanding the scope of a project for iterative development phases. Beginning the implementation phase without a clear understanding of...

Read more »

Data warehouse Concepts

Central Data warehouseA 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.Active Metadata WarehouseAn Active Metadata Warehouse is a repository of Metadata to help speed up data reporting and analyses from an active data warehouse....

Read more »

ODS Vs. Data Warehouse

ODS Vs. Data WarehouseOperational Data store- Data Focused Integration From Transaction Processing Focused Systems - Age Of The Data is Current, Near Term (Today, Last Week’s)- Primary Use: Day-To-Day Decisions Tactical Reporting Current Operational Results - Frequency Of Load: Twice Daily , Daily, WeeklyDatawarehouse- Subject Oriented,Integrated,Non-Volatile,Time Variant- Age of the Data is Historic (Last Month, Qtrly,...

Read more »

Incompatible objects

Incompatible objects nothing but Sometimes it is not possible to use certain combinations of objects in data providers. This situation arises when objects bear no relationship to one another. These objects are called incompatible objects.For example, the Island Resorts Marketing universe contains the[Reservation Year] and [Revenue] objects, which are incompatible. This isbecause there is no revenue associated with a reservation....

Read more »

What is a scope of analysis?

The scope of analysis for a query is extra data that you can retrieve from thedatabase to give more details on the data returned by each of the objects in aquery. This extra data does not appear in the initial result document, but itremains available in the data cube, so you can pull this data in to the report toallow you to access more detail at any time. This process of refining the datato lower levels of detail is called drilling...

Read more »