MATERIALIZED VIEWS WITH USER-DEFINED AGGREGATES

Patent №

US 7,844,600

Granted

2010-11-30

Filed 2007

Owner

ORACLE INTERNATIONAL CORPORATION

Lab

AI components

4

nlp · kr · planning · hardware

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

11827796

Systems, methodologies, media, and other embodiments associated with supporting materialized views with user-defined aggregates are described. One example system includes logic for exposing a set of interface actions to support a user-defined aggregate in a materialized view associated with a base table. The materialized view may store both the user-defined aggregate and a user-defined aggregate context that facilitates logically connecting the user-defined aggregate to the base table. The example system may also include logic for supporting the user-defined aggregate. The support may be based on the set of interface actions. Example systems and methods may, therefore, facilitate incremental updating of the materialized view and/or rewriting a query to access the materialized view.

AI classification

AI hardware0.99
Knowledge representation0.96
Planning0.96
Natural language0.84
Vision0.01
Machine learning0.00
Evolutionary computation0.00
Speech0.00

Ownership

ORACLE INTERNATIONAL CORPORATION

assignment · 196310434

Assignors

HU, YING, SUNDARA, SEEMA, SRINIVASAN, JAGANNATHAN

On an employer assignment, the assignors are typically the inventors.

© 2026 NYSGPT2525 LLC