Design And Realization Of The Middleware That Apply In OLAP Query

Along with OLAP(Online Analytical Processing) development and mature, its application more and more widespread, the basically each enterprise application procedure all has the stable data support. Now the higher computer language all is object-oriented, but their data accessing method is not object-oriented, then this has had the nonuniformity. Moreover when multiuser concurrent visit data server, all of them must carry on the same initialization and the destruction to each connection, this must consume the quite big system resources, thus affects theinteractive speed.Therefore, the method that uses data accessing middleware to realize OLAP inquiry is proposed. This middleware seals to the OLAP server operation code and it belongs to the data accessing middleware category. The primary content is as followed.Firstly, the persistence object level is added to the middleware, it constructs data mapping pair elephant which saves through the read object mapping document in the OLAP server, and then is stored in entity class various attributes. The users just operate the object, then it can make the users object-oriented truely.Secendly, a kind of object query language that assists the users to query the objects is defined. The query language uses corresponding classes to transform it to the MDX sentence.Thirdly, the data accessing level in the middleware is added, the data accessing level has sealed the data buffer pool (ConneciontPool mechanism), in the begging, the data accessing level through reads configuration files to initialize connection number and other connection variables, in this way it can omit the time that many times connections's initialization and destroyed, theseconnections are unification managed by the data buffer pool, it can effectively enhance the application procedure visit database efficiency.Finally, this paper uses the E-TEST tool to test the ConnectionPool, and gives an example to explain the workflow of how to utilize this middleware to develop.