Multi-HBase table association method based on snowflake model

The invention discloses a multi-HBase table association method based on a snowflake model and belongs to the technical field of big data. Each HBase table comprises an inquiry entrance table, a main fact table, a supplement fact table and a dimension table, wherein the main fact table serves as a center table of the snowflake model and an association starting point; a main key of the main fact table contains inquiry entrance table conditions; the inquiry entrance table designs a combined main key according to the corresponding relation between input conditions and objects; according to the supplement fact table of the main fact table, a combined main key the same with the main key of the main fact table is designed; dimension table main keys are designed on the basis of outer keys of the main fact table and the supplement fact table; in the multi-table association implementation process, all objects and items meeting conditions are scanned in the main fact table according to input; the inquiry entrance table is inquired for related information according to input/objects; the supplement fact table is inquired for supplement information of main fact table items according to input/object/item; the dimension table is inquired for related information according to pk in the main fact table items. The multi-HBase table association method improves the implementation efficiency.