ROLAP Disadvantages :- Poor query performance. Some limitations Front end tool Specialized SQL Servers
ROLAP Advantages :- servers are highly scalable. Existing RDBMS. No zero facts can be stored. Do not use pre-calculated data cubes.
Relational OLAP Architecture :- Database Server ROLAP Server
OLAP Operations :- Roll-up Drill-down Slice and dice Pivot (rotate)
Types of OLAP Servers :- Relational OLAP(ROLAP) Multidimensional OLAP (MOLAP) Hybrid OLAP (HOLAP)
Bottom Tier :- The bottom tier of the architecture is the data warehouse database server.It is the relational database system
3.Hybrid OLAP (HOLAP)- is a combination of ROLAP and MOLAP. which are other possible implementations of OLAP
2.Multidimensional OLAP (MOLAP)-which directly implements multidimensional data and operations.
1.Relational OLAP (ROLAP) - which is an extended relational database management system.
Top-Tier :-This tier is the front-end client layer.This layer hold the query tools and reporting tool, analysis tools and data mining tools.
Data Warehouse Architecture ( Three-Tier Arch ):- Top-Tier Middle Tier Bottom Tier
DWH Architecture:- we are having 3 kinds of architecture for DWH. 1.Centralized Architecture 2.Fedarated Arch 3.Tiered Arch
Enterprise Warehouse:-The enterprise warehouse collects all the information all the subjects spanning the entire organization.
Data mart:- Data mart contains the subset of organization-wide data.
Virtual Warehouse :- The view over a operational data warehouse is known as virtual warehouse. It is easy to built the virtual warehouse.
Data Warehouse Models :- Virtual Warehouse Data mart Enterprise Warehouse
Why we need DWH :- Integrate Data From Multiple Diverse Source Allow for Analysis of data over time Provide ad-hoc Querying, Reporting
United States الاتجاهات
- 1. Black Friday 442K posts
- 2. Nebraska 9,606 posts
- 3. Iowa 11.4K posts
- 4. Jalon Daniels N/A
- 5. Go Birds 10.7K posts
- 6. Black Ops 7 Blueprint 8,146 posts
- 7. Rhule 1,575 posts
- 8. Sumrall 2,763 posts
- 9. Egg Bowl 7,067 posts
- 10. Kamario Taylor N/A
- 11. Mississippi State 4,489 posts
- 12. #Huskers 1,061 posts
- 13. #kufball N/A
- 14. Black Ops 7 XP 6,209 posts
- 15. Stribling N/A
- 16. Kansas 15.9K posts
- 17. Emmett Johnson 1,017 posts
- 18. Kiffin 10.2K posts
- 19. #Illini N/A
- 20. Scott Stricklin 1,500 posts
Something went wrong.
Something went wrong.