Mondrian Intermediate Code Optimization Based On Oracle Optimizer

Mondrian is a MDX Parser implemented by Java.Combined with the presentation layer tool-Jpivot,Mondrian servers as a popular OLAP Server in today's BI domain.Since its intrinsic character brought by its implementing method,Mondrian can be integrated with heterogeneous system composed of many different software tools in data warehouse easily.it enables the Citibank's data wareshouse to have the ability to respond to the MDX queryFirstly, author of this paper analyze the algorithm and mechanism used for implementing the MDX parser, which is the core for Mondrian, as a OLAP server. After establishing a deep understanding to the key algorithm of Mondrian, author analyzes the performance of Mondrian and does the study on the policy of Oracle Optimizer.Secondly, based on the latter study, according to working policy and performce tunning method provide by Oracle optimizer, author design and implement the optimization mechanism for Mondrian output SQL code-MDXOptimizer, which includs 2 level optimizing methods.providing the ability of analyzing before SQL's execution,of watching the process of executing SQL and fetching results and of tunning when problem occour.Finally, author analyzes the result from test cases, which illustrating the MDXOptimizer do provide an enhancement for Mondrian.