Method and system of mapreduce implementations on indexed datasets in a distributed database environment

A non-transitory computer-readable storage medium comprising program instructions for MapReduce implementations on indexed datasets in a distributed database environment, wherein execution of the program instructions by one or more processors of a computer system causes the one or more processors to carry out the steps of:

• receiving a query in a query language from a client with a distributed database system;
• locating an index that matches the query, wherein the index is pre-generated from a database table in the distributed database system, and wherein the index is maintained substantially current with a relevant modification of the database table;
• executing a map function of a MapReduce programming model using the index;
• and
• executing a reduce function of the MapReduce programming model using the output of the map function.

A distributed database system comprising:

• a processor;
• a client node that provides a query in a query language to the distributed database system;
• a distributed database system comprising a cluster of server nodes:
• and
• a server node that:
• creates at least one index from a data store in the distributed database,
• maintains the at least one index in a substantially current state based on the data store,
• receives a query from a client node,
• matches the query to the at least one index when the query is received from the client node, and
• implements a map function of a MapReduce programming model using the index.