Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivability
R Bello, J Finnerty, M Ziauddin, A Witkowski - US Patent 6,496,819, 2002 - Google Patents
5,584,024 A 12/1996 Schwartz....................... 707/4 are to be grouped by a? rst Set of one or
more Columns' 5,734,884 A* 3/1998 Eberhard et aL _ 707/200 Where the materialized vieW …
more Columns' 5,734,884 A* 3/1998 Eberhard et aL _ 707/200 Where the materialized vieW …
Rule-based autonomous database cloud service framework
H Hung, K Rajamani, J Lee, S Jain, G Ravipati… - US Patent …, 2022 - Google Patents
Provided herein are data cloud administration techniques that achieve autonomy by using a
rules engine that reacts to a database system event by autonomously submitting an …
rules engine that reacts to a database system event by autonomously submitting an …
Method and apparatus for optimizing computation of OLAP ranking functions
S Bellamkonda, B Ghosh, A Witkowski - US Patent 6,622,138, 2003 - Google Patents
(54) METHOD AND APPARATUS FOR 6,134,543 A 10/2000 Witkowski et al. OPTIMIZING
COMPUTATION OF OLAP 6,199,063 B1 3/2001 Colby et al. RANKING FUNCTIONS …
COMPUTATION OF OLAP 6,199,063 B1 3/2001 Colby et al. RANKING FUNCTIONS …
Maintaining and utilizing SQL execution plan histories
D Das, Y Zhu, M Ziauddin, B Dageville, H Su - US Patent 8,335,767, 2012 - Google Patents
5,412,804 5,412,806 5,444,820 5,452,468 5,459,837 5,469,560 5,495.419 5,495,606
5,504.894 5,537,588 5,551,027 5,572,640 5,574,900 5,590,319 5,642,515 5,671,403 …
5,504.894 5,537,588 5,551,027 5,572,640 5,574,900 5,590,319 5,642,515 5,671,403 …
Range-based query optimizer
G Antoshenkov - US Patent 6,439,783, 2002 - Google Patents
42557796 A: 3/1981 Gabbe ct a1~ 395/603 ranges of record values related by logical
operators. The 436063252 A* 8/1986 Walsman et a1 '' 392/603 query is converted to a …
operators. The 436063252 A* 8/1986 Walsman et a1 '' 392/603 query is converted to a …
Executing alternative plans for a SQL statement
M Zait - US Patent 7,877,373, 2011 - Google Patents
4,769,772 A 9/1988 Dwyer 4,803,614. A 2/1989 Banba et al. 4,829,427 A 5, 1989 Green
Under automated alternate plan analysis, a query optimizer 4.956, 774 A 9, 1990 Shibamiya …
Under automated alternate plan analysis, a query optimizer 4.956, 774 A 9, 1990 Shibamiya …
Method and apparatus for efficiently refreshing sets of summary tables and materialized views in a database management system
WD Norcott, M Ziauddin - US Patent 6,334,128, 2001 - Google Patents
A method and apparatus for refreshing stale materialized views is provided. Prior to
executing a query to refresh a materialized view from data in the base tables of the …
executing a query to refresh a materialized view from data in the base tables of the …
Proactive impact measurement of database changes on production systems
Database change test system that includes an SQL perfor mance analyzer (SPA) to
efficiently test execute workload set of queries on a production or test database …
efficiently test execute workload set of queries on a production or test database …
SQL execution plan verification
4,769,772 A 9/1988 Dwyer 4,803,614 A 2f1989 Banba et al. 4,829,427 A 5/1989 Green
4.956, 774 A 9/1990 Shibamiya et al. 5,091,852 A 2f1992 TSuchida et al. 5,251,131 A 10 …
4.956, 774 A 9/1990 Shibamiya et al. 5,091,852 A 2f1992 TSuchida et al. 5,251,131 A 10 …
SQL performance analyzer
P Belknap, B Dageville, K Dias, K Yagoub - US Patent 8,341,178, 2012 - Google Patents
Techniques are provided for analyzing performance differences for a set of database query
language statements on two different database systems. The performance analysis is based …
language statements on two different database systems. The performance analysis is based …