- 专利标题: Materializing expressions within in-memory virtual column units to accelerate analytic queries
-
申请号: US15146799申请日: 2016-05-04
-
公开(公告)号: US10204135B2公开(公告)日: 2019-02-12
- 发明人: Aurosish Mishra , Shasank K. Chavan , Allison L. Holloway , Jesse Kamp , Ramesh Kumar , Zhen Hua Liu , Niloy Mukherjee , Amit Ganesh , Tirthankar Lahiri , Vineet Marwah
- 申请人: Oracle International Corporation
- 申请人地址: US CA Redwood Shores
- 专利权人: Oracle International Corporation
- 当前专利权人: Oracle International Corporation
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Hickman Palermo Becker Bingham LLP
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Techniques are described for materializing pre-computed results of expressions. In an embodiment, a set of one or more column units are stored in volatile or non-volatile memory. Each column unit corresponds to a column that belongs to an on-disk table within a database managed by a database server instance and includes data items from the corresponding column. A set of one or more virtual column units, and data that associates the set of one or more column units with the set of one or more virtual column units, are also stored in memory. The set of one or more virtual column units includes a particular virtual column unit storing results that are derived by evaluating an expression on at least one column of the on-disk table.
公开/授权文献
信息查询