Databases Reference
In-Depth Information
Of course, these are just one possibility or scenario. The beauty of Essbase is that you
can do most anything with it. Heck, you could easily have a large Oracle relational
database as the backend data source for your ASO cubes.
The possibilities are endless!
Summary
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 topic, 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, BSO, or both together,
you can be confident you have made the right choice.
Yes, there are several imitators out there. There are some that are even pushing their
product for free. We are confident you will agree with us that when all is said and
done, Essbase is the clearly superior tool. Read on in fact, for an introduction to some
of the new components available in what is now a suite of Essbase applications.
