Invention Grant
US07933867B1 Maintaining views of cube-based operations in a database system
有权
在数据库系统中维护基于立方体的操作的视图
- Patent Title: Maintaining views of cube-based operations in a database system
- Patent Title (中): 在数据库系统中维护基于立方体的操作的视图
-
Application No.: US10706656Application Date: 2003-11-12
-
Publication No.: US07933867B1Publication Date: 2011-04-26
- Inventor: Hong Gui , Ambuj Shatdal , Curt J. Ellmann
- Applicant: Hong Gui , Ambuj Shatdal , Curt J. Ellmann
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agency: Trop, Pruner & Hu P.C
- Main IPC: G06F17/00
- IPC: G06F17/00
Abstract:
A database system includes a storage to store a view containing results of a cube-based operation on at least one base table, with the view containing a first result set for a group-by on a first grouping set, and a second result set for a group-by on a second grouping set. In response to a change to the at least one base table, a controller updates the first result set by computing a change to the first result set based on a change in the at least one base table, and updates the second result set by computing a change to the second result set based on the change to the first result set.
Information query
