发明名称 |
Fact table storage in a decision support system environment |
摘要 |
A fact table is set up without any dimension columns. The data in the table is ordered according to an order corresponding to the ordering of the dimensions. The table is divided into segments corresponding to contiguous portions of data. The portions of the table containing non-null values for the measures are placed into the segments. The size of the segments and the location segments may be determined according to the density of discontinuities in the data. An indexed organized table is used to determine the beginning and end of each segment of the table, the locations of the discontinuities in the data, and to facilitate accessing the measures of the table.
|
申请公布号 |
US2005004936(A1) |
申请公布日期 |
2005.01.06 |
申请号 |
US20030719819 |
申请日期 |
2003.11.20 |
申请人 |
ORACLE INTERNATIONAL CORPORATION |
发明人 |
POTAPOV DMITRY;KARRA VISHWANATH;GANESH AMIT;KLEIN JONATHAN |
分类号 |
G06F17/00;G06F17/30;(IPC1-7):G06F17/00 |
主分类号 |
G06F17/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|