Archive for the ‘OLAP’ tag
What are OLAP Types in Data Warehouse?
Definition of OLAP
OLAP : System used to change data stored in data warehouse transform the data to multi dimensional structure or cube.
| Item | OLTP | OLAP |
| User | IT Professional | Knowledge worker |
| Functional | Daily task | Decision Making |
| DB Design | Application oriented | Subject oriented |
| Data | Up to date, detail, relational | Historical, multidimensional, integrated |
| Access | Read/write | Read only |
| DB Size | 100 MB-GB | 100 GB-TB |
Type of OLAP
- Relational OLAP: Extended RDBMS with multidimensional data mapping to standard relational operation.
- Multidimensional OLAP: Implemented operation in multidimensional data.
- Hybrid OLAP: Could use different partition that will be used.
OLAP Query
- Roll-up : display data that increase in aggregation level
- Drill-down : display details using query for dimension table hierarchy
- Pivot : makes cross tabulation
- Slice and dice: Makes range selection on one or more dimension.
Similar Posts:
- None Found