公开(公告)号：US10810198B2

公开(公告)日：2020-10-20

申请号：US15918132

申请日：2018-03-12

申请人： Oracle International Corporation

发明人： Albert Hopeman, IV ,  Ekrem S. C. Soylemez ,  Martin Roth

IPC分类号： G06F16/00 ,  G06F16/2453 ,  G06F16/28 ,  G06F16/22 ,  G06F16/2455

摘要： Techniques related to group determination based on multi-table dictionary codes are disclosed. In some embodiments, one or more non-transitory storage media store a sequence of instructions which, when executed by one or more computing devices, cause performance of a method. The method comprises storing a fact table and a dimension table that share a domain dictionary. The fact table and the dimension table each have a column of encoded join keys that is decodable using the shared domain dictionary. A query may specify one or more row groups for the dimension table. To efficiently process the query, one or more group identifiers are assigned to the one or more row groups. Each row group corresponds to a different group identifier. This enables a code-to-group-identifier mapping to be generated. The code-to-group-identifier mapping correlates the encoded join keys to the one or more group identifiers.

公开(公告)号：US20190095486A1

公开(公告)日：2019-03-28

申请号：US15918132

申请日：2018-03-12

申请人： Oracle International Corporation

发明人： Albert Hopeman, IV ,  Ekrem S.C. Soylemez ,  Martin Roth

IPC分类号： G06F17/30

CPC分类号： G06F16/24537 ,  G06F16/2264 ,  G06F16/2282 ,  G06F16/24544 ,  G06F16/2456 ,  G06F16/283

摘要： Techniques related to group determination based on multi-table dictionary codes are disclosed. In some embodiments, one or more non-transitory storage media store a sequence of instructions which, when executed by one or more computing devices, cause performance of a method. The method comprises storing a fact table and a dimension table that share a domain dictionary. The fact table and the dimension table each have a column of encoded join keys that is decodable using the shared domain dictionary. A query may specify one or more row groups for the dimension table. To efficiently process the query, one or more group identifiers are assigned to the one or more row groups. Each row group corresponds to a different group identifier. This enables a code-to-group-identifier mapping to be generated. The code-to-group-identifier mapping correlates the encoded join keys to the one or more group identifiers.