System and method for implementing online analytical processing (olap) solution using mapreduce

A Online Analytical Processing (OLAP) processing computing system, comprising a processor and a memory coupled to the processor which is configured to be capable of executing programmed instructions comprising and stored in the memory to:

• parse a received OLAP query;
• retrieve metadata information from the parsed OLAP query;
• validate the parsed OLAP query and generating a MapReduce job execution plan based on the retrieved metadata information;
• identify a scope for optimization in the generated MapReduce job execution plan and optimizing the MapReduce job execution plan using the identified scope;
• execute the optimized MapReduce job execution plan;
• and
• store data output as a result of the execution in a cube specific distributed file system (DFS) directory.

A non-transitory computer readable medium having stored thereon instructions for implementing an Online Analytical Processing (OLAP) solution using Map Reduce comprising executable code which when executed by a processor, causes the processor to perform steps comprising:

• parsing a received OLAP query;
• retrieving metadata information from the parsed OLAP query;
• validating the parsed OLAP query and generating a MapReduce job execution plan based on the retrieved metadata information;
• identifying a scope for optimization in the generated MapReduce job execution plan and optimizing the MapReduce job execution plan using the identified scope;
• executing the optimized MapReduce job execution plan;
• and
• storing data output as a result of the execution in a cube specific distributed file system (DFS) directory.