Optimizing a join operation

A computer system, comprising:

• one or more processors;
• one or more memory devices coupled to the one or more processors;
• and
• one or more computer readable storage devices coupled to the one or more processors, wherein the one or more storage devices contain program code executable by the one or more processors via the one or more memory devices to implement a method for optimizing a join operation, the method comprising:
• receiving, by the one or more processors of the computer system, a join request associated with a fact table and a plurality of related dimension tables, wherein the fact table and the plurality of related dimension tables comprise a NoSQL database, and wherein the join request is a NoSQL join request;
• identifying, by the one or more processors of the computer system, a join relationship from the fact table and the plurality of related dimension tables;
• matching, by the one or more processors of the computer system, different tables of the fact table and the plurality of related dimension tables, wherein the matching is based on a NoSQL query;
• filtering, by the one or more processors of the computer system using data parallelism, the fact table and the plurality of related dimension tables, wherein the filtering includes drilling down, by the one or more processors of the computer system, on a special dimension table of the plurality of dimension tables as another fact table to extract data into the fact table, and wherein the filtering occurs prior to performing the join operation;
• performing, by the one or more processors of the computer system, the join operation pursuant to the join request;
• and
• transmitting, by the one or more processors of the computer system, joined data after the performed join operation.

A computer program product, comprising one or more computer readable hardware storage devices storing a computer readable program code, the computer readable program code comprising an algorithm that when executed by one or more processors of a computing system implements a method for optimizing a join operation, the method comprising:

• receiving, by the one or more processors of the computer system, a join request associated with a fact table and a plurality of related dimension tables, wherein the fact table and the plurality of related dimension tables comprise a NoSQL database, and wherein the join request is a NoSQL join request;
• identifying, by the one or more processors of the computer system, a join relationship from the fact table and the plurality of related dimension tables;
• matching, by the one or more processors of the computer system, different tables of the fact table and the plurality of related dimension tables, wherein the matching is based on a NoSQL query;
• filtering, by the one or more processors of the computer system using data parallelism, the fact table and the plurality of related dimension tables, wherein the filtering includes drilling down, by the one or more processors of the computer system, on a special dimension table of the plurality of dimension tables as another fact table to extract data into the fact table, and wherein the filtering occurs prior to performing the join operation;
• performing, by the one or more processors of the computer system, the join operation pursuant to the join request;
• and
• transmitting, by the one or more processors of the computer system, joined data after the performed join operation.