Oliver Bodemer
IBM J. Res. Dev
Enterprises have been storing multidimensional data, using a star or snowflake schema, in relational databases for many years. Over time, relational database vendors have added optimizations that enhance query performance on these schemas. During the 1990s many special-purpose databases were developed that could handle added calculational complexity and that generally performed better than relational engines. DB2® has added a number of features that make it more competitive with these special-purpose databases. In this paper, we define meta-data extensions that allow designers of multidimensional schemas to describe the structure of those schemas to multidimensional query and analysis tools. The SQL (Structured Query Language) extensions include a "cube" object that returns row sets that are "slices" of the cube. We also describe Web services for OLAP (online analytical processing) that provide meta-data for multidimensional data, as well as XML (Extensible Markup Language) query results.
Oliver Bodemer
IBM J. Res. Dev
Matthias Kaiserswerth
IEEE/ACM Transactions on Networking
Limin Hu
IEEE/ACM Transactions on Networking
N.K. Ratha, A.K. Jain, et al.
Workshop CAMP 2000