发明名称 Rewrite of queries containing rank or rownumber or Min/Max aggregate functions using a materialized view
摘要 Techniques are provided for improving efficiency of database systems, and in particular, to refreshing materialized views maintained by database systems and rewriting queries to access the materialized views. According to the approaches, a ranked materialized view is incrementally refreshed, and during the incremental refresh operation, rows in the partitions of the materialized view are ranked within the partitions.
申请公布号 US7912834(B2) 申请公布日期 2011.03.22
申请号 US20060437072 申请日期 2006.05.19
申请人 ORACLE INTERNATIONAL CORPORATION 发明人 GUPTA ABHINAV;WITKOWSKI ANDREW
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项
地址