Efficient mid-query re-optimization of sub-optimal query execution plans
For a number of reasons, even the best query optimizers can very often produce sub-optimal
query execution plans, leading to a significant degradation of performance. This is …
query execution plans, leading to a significant degradation of performance. This is …
Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer
S Lawande, M Ziauddin, GS Smith - US Patent 8,825,629, 2014 - Google Patents
5,806,076 5,860,069 5,870,760 5,870,761 5,940,826 5,963,933 5,963,934 5.991, 765
6,052,694 6,122,640 6, 195,653 6.212, 514 6,266,658 6,275,818 6,321,218 6,330,552 …
6,052,694 6,122,640 6, 195,653 6.212, 514 6,266,658 6,275,818 6,321,218 6,330,552 …
Toward a progress indicator for database queries
G Luo, JF Naughton, CJ Ellmann… - Proceedings of the 2004 …, 2004 - dl.acm.org
Many modern software systems provide progress indicators for long-running tasks. These
progress indicators make systems more user-friendly by helping the user quickly estimate …
progress indicators make systems more user-friendly by helping the user quickly estimate …
SQL tuning sets
K Yagoub, B Dageville, M Ziauddin, K Dias - US Patent 7,664,778, 2010 - Google Patents
US7664778B2 - SQL tuning sets - Google Patents US7664778B2 - SQL tuning sets - Google
Patents SQL tuning sets Download PDF Info Publication number US7664778B2 …
Patents SQL tuning sets Download PDF Info Publication number US7664778B2 …
The CORAL deductive system
CORAL is a deductive system that supports a rich declarative language, and an interface to
C++, which allows for a combination of declarative and imperative programming. A CORAL …
C++, which allows for a combination of declarative and imperative programming. A CORAL …
Automatic SQL tuning advisor
B Dageville, M Ziauddin, K Yagoub, M Zait… - US Patent …, 2010 - Google Patents
6,529,901 B1 3/2003 Chaudhuri et al. 6,571.233 B2 5, 2003 Beavin et al. 6,594,653 B2
7/2003 Colby et al. 6,598,038 B1* 7/2003 Guay et al..................... 707/2 6,721,724 B1 4/2004 …
7/2003 Colby et al. 6,598,038 B1* 7/2003 Guay et al..................... 707/2 6,721,724 B1 4/2004 …
Database task processing optimization based on performance evaluation and machine learning algorithm.
A Deng - Soft Computing-A Fusion of Foundations …, 2023 - search.ebscohost.com
One of the key components of artificial intelligence algorithms is machine learning, involving
a variety of fields, and has been applied in many artificial intelligence systems, including …
a variety of fields, and has been applied in many artificial intelligence systems, including …
Increasing the accuracy and coverage of SQL progress indicators
G Luo, JF Naughton, CJ Ellmann… - … Conference on Data …, 2005 - ieeexplore.ieee.org
Recently, progress indicators have been proposed for long-running SQL queries in
RDBMSs. Although the proposed techniques work well for a subset of SQL queries, they are …
RDBMSs. Although the proposed techniques work well for a subset of SQL queries, they are …
Auto-tuning SQL statements
M Ziauddin, B Dageville, M Zait, D Das - US Patent 7,805,411, 2010 - Google Patents
(73) Assignee: Oracle International Corporation, 5,794.227 A 8, 1998 Brown...........................
707/2 Redwood Shores, CA (US) 5,794,229 A 8/1998 French et al.(*) Notice: Subject to any …
707/2 Redwood Shores, CA (US) 5,794,229 A 8/1998 French et al.(*) Notice: Subject to any …
Method and system for implementing a SQL profile
M Ziauddin, B Dageville, M Zait, K Yagoub - US Patent 7,664,730, 2010 - Google Patents
A method, apparatus, and computer program product with a persistent data structure for
storing a profile of tuning information for a query statement separately from the query …
storing a profile of tuning information for a query statement separately from the query …