ASO Vs BSO

Agenda

1. When ASO and BSO Cubes are useful


2. How ASO Cubes offer new data base types


3. Performance of ASO Cubes versus BSO Cubes


4. Differences between ASO and BSO Cubes


5. When to use ASO Cubes and how users see ASO Cubes

BSO Cubes

1. Useful for systems that involve complex calculations


2. BSO Engine cannot handle much sparse data

ASO Cubes

1. Different method for storage and calculations


2. Different storage kernel


3. Useful for databases which are read only


4. Useful for cases where dimensions are large in number

Eg. Customer analysis, procurement analysis

ASO vs BSO

1. Load time in ASO is 20% faster than BSO


2. Calculation time is 20 times faster


3. Storage space is 10 times smaller


4. ASO Cubes becomes slower than BSO Cubes for Queries


5. ASO Cubes can have many more dimensions

End Users

1. No difference for end users during use with Smart View, Add in, FR Reports

When to use ASO

1. Database is sparse and has many dimensions. Aggregation is much faster


2. Calculation of the database is frequent

Storage Kernel of ASO

1. Multidimensional Index


2. Indexes the index to facilitate faster aggregation


3. Unlike BSO Storage is not in Blocks but in optimized aggregation nodes


4. Loads data at only Level 0


5. Algorithm selects and stores queries and increased speed


6. These queries will pre calculate data values and store pre calculate data results in aggregations