index structure for the fact table of a star-join schema and template query processing
Star-join is a database scheme designed for the purpose of data warehousing. A typical query on a star-join scheme as well as an algorithm for its processing has been examined. An index structure for the star-join fact table has been proposed with the aim of facilitating template query processing. A multilevel index for the fact table's composite key has been built having time_key as a top'level. Stream processing technique has been implemented for resolving query's application and join constraints as well as the aggregation step of the query processing algorithm.
fact table star-join schema query processing multilevel index stream processing