Invention Grant
- Patent Title: Determining a height-balanced histogram incrementally
- Patent Title (中): 逐步确定高度平衡直方图
-
Application No.: US12190885Application Date: 2008-08-13
-
Publication No.: US08392406B1Publication Date: 2013-03-05
- Inventor: Fatih Emekci , Sunil P. Chakkappen , Uri Shaft
- Applicant: Fatih Emekci , Sunil P. Chakkappen , Uri Shaft
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Silicon Valley Patent Group LLP
- Agent Omkar Suryadevara
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
A table-level histogram is maintained incrementally without requiring rescanning of the entire table when new data values are added to the table. A table has multiple partitions of data values. A histogram for data values of the partitions is generated. When a new partition of data values is added to the table, a histogram for only the new partition is generated. To generate a histogram for the entire table, the histograms for the previously generated and newly added partitions are used without needing to refer to the underlying data. A similar approach is applicable when modifying data values in a partition.
Information query