SYSTEM AND METHOD FOR IMPLEMENTING ONLINE ANALYTICAL PROCESSING (OLAP) SOLUTION USING MAPREDUCE

摘要

The technique relates to a system and method for implementing peta-byte scale online analytical processing solution using MapReduce. The technique involves receiving an OLAP query from a user through an OLAP-QL Driver. After receiving the query it is parsed through the compiler. Then the metadata information is retrieved from the parsed query through the metadata manager. Validating the parsed query using plan generator module for generating a MapReduce job execution plan based on the retrieved metadata information. The next step is to identify the scope for optimization in the generated MapReduce job execution plan and optimizing the MapReduce job execution plan using the identified scope. Then executing the optimized MapReduce job plan using the execution engine and finally storing the output data in the cube specific distributed file system directory. REF FIG: 1