Cube construction for an OLAP system

    公开(公告)号:US11023485B2

    公开(公告)日:2021-06-01

    申请号:US16133807

    申请日:2018-09-18

    Abstract: Embodiments relate to cube construction. According to a method, a plurality of valid history queries that request to retrieve a cube comprising a first number of cuboids in an On-Line Analytical Processing (OLAP) system are collected. A plurality of dimension combinations is acquired from the plurality of valid history queries. A query frequency of each cuboid of a second number of cuboids with the plurality of dimension combinations is determined, the second number of cuboids being a subset of the first number of cuboids. A cuboid construction sequence for the second number of cuboids is determined based on the query frequency. The cube is constructed based on the cuboid construction sequence.

    CUBE CONSTRUCTION FOR AN OLAP SYSTEM
    3.
    发明申请

    公开(公告)号:US20200089799A1

    公开(公告)日:2020-03-19

    申请号:US16133807

    申请日:2018-09-18

    Abstract: Embodiments relate to cube construction. According to a method, a plurality of valid history queries that request to retrieve a cube comprising a first number of cuboids in an On-Line Analytical Processing (OLAP) system are collected. A plurality of dimension combinations is acquired from the plurality of valid history queries. A query frequency of each cuboid of a second number of cuboids with the plurality of dimension combinations is determined, the second number of cuboids being a subset of the first number of cuboids. A cuboid construction sequence for the second number of cuboids is determined based on the query frequency. The cube is constructed based on the cuboid construction sequence.

Patent Agency Ranking