Generation of cube metadata and query statement based on an enhanced star schema

摘要

A method for generating cube metadata based on an enhanced star schema may be provided. In some embodiments, the method may include extracting dimension references from a factless fact table in an enhanced star schema. The enhanced star schema may include a fact table, a plurality of dimension tables of the fact table and the factless fact table. In some embodiments, a hierarchy reference may be constructed based on the dimension references. In some embodiments, cube metadata may be generated by combining the hierarchy reference with measures obtained from the fact table and a hierarchy obtained from the dimension tables in the enhanced star schema.