We hope you have found the information in this chapter as fun, exciting, and useful as we have. As we've said repeatedly throughout this book, it should be no wonder to you why Oracle Essbase is the number one data analytics tool in the world! It's almost as though Essbase is a product that is never finished, because just when you think it can't get any better, it gets even better!
You should now have a good understanding of the two very different but complimentary Essbase database architectures. The BSO is the old standby foundation in the world of Essbase, and the ASO is the streamlined speedster.
The differences in many cases between ASO and BSO are minor, but their affect can be dramatic. The BSO utilizes the standard data block method of storing data, while the ASO uses the aggregate method. The BSO is built for rugged and robust computing and analysis. The ASO is built for high speed, high volume data analysis and reporting.
We're sure you see by now that whether you use ASO,...