公开(公告)号：US08423534B2

公开(公告)日：2013-04-16

申请号：US12313252

申请日：2008-11-18

申请人： Louis M. Burger ,  Douglas P. Brown ,  Thomas Julien

发明人： Louis M. Burger ,  Douglas P. Brown ,  Thomas Julien

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30433 ,  G06F17/30442

摘要： A computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis.

公开(公告)号：US20100125565A1

公开(公告)日：2010-05-20

申请号：US12313252

申请日：2008-11-18

申请人： Louis M. Burger ,  Douglas P. Brown ,  Thomas Julien

发明人： Louis M. Burger ,  Douglas P. Brown ,  Thomas Julien

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30433 ,  G06F17/30442

摘要： A computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis.

摘要翻译： 用于优化数据库查询的计算机实现的方法，装置和制品。 监视计算机系统的一个或多个资源的资源使用情况。 存储表示所监视的资源使用的条件代码。 使用存储的条件代码修改成本模型。 使用修改的成本模型为数据库查询生成查询执行计划。 然后执行查询执行计划以从存储在计算机系统上的数据库检索数据，其中将检索到的数据呈现给用户以供后续使用和分析。

公开(公告)号：US08745032B1

公开(公告)日：2014-06-03

申请号：US12952561

申请日：2010-11-23

申请人： Douglas P. Brown ,  Anita Richards ,  Thomas P. Julien ,  Louis M. Burger

发明人： Douglas P. Brown ,  Anita Richards ,  Thomas P. Julien ,  Louis M. Burger

IPC分类号： G06F7/00

CPC分类号： G06F17/30442

摘要： A filter receives a request to perform an operation in a database system, and the filter receives a resource estimate relating to the request from an optimizer. The filter determines whether the resource estimate exceeds an available resource of the database system, and if so, the filter rejects the request prior to execution of the request.

摘要翻译： 过滤器接收在数据库系统中执行操作的请求，并且过滤器从优化器接收与该请求相关的资源估计。 过滤器确定资源估计是否超过数据库系统的可用资源，如果是这样，则过滤器在执行请求之前拒绝该请求。

公开(公告)号：US08775413B2

公开(公告)日：2014-07-08

申请号：US12229383

申请日：2008-08-22

申请人： Douglas P. Brown ,  Anita Richards ,  Thomas P. Julien ,  Louis M. Burger

发明人： Douglas P. Brown ,  Anita Richards ,  Thomas P. Julien ,  Louis M. Burger

IPC分类号： G06F17/30

CPC分类号： G06F17/30474 ,  G06F17/30463

摘要： A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan is generated for the database query, which may be stored in an in-line query capture database. Execution of the query execution plan may be monitored in order to generate performance information, which also may be stored in the in-line query capture database. The data stored in in-line query capture database may be used during the initial generation of query execution plans, as well as for the re-optimization of a query execution plan, during the execution of the query execution plan.

摘要翻译： 用于优化数据库查询的计算机实现的方法，装置和制品。 为数据库查询生成查询执行计划，该查询执行计划可能存储在一个内联查询捕获数据库中。 可以监视查询执行计划的执行，以便生成性能信息，该信息也可以存储在在线查询捕获数据库中。 存储在在线查询捕获数据库中的数据可以在查询执行计划的初始生成期间以及在执行查询执行计划期间重新优化查询执行计划时使用。

公开(公告)号：US20120059817A1

公开(公告)日：2012-03-08

申请号：US12876373

申请日：2010-09-07

申请人： Louis M. Burger ,  Thomas P. Julien ,  Douglas P. Brown

发明人： Louis M. Burger ,  Thomas P. Julien ,  Douglas P. Brown

IPC分类号： G06F17/30

CPC分类号： G06F16/2455

摘要： A computer-implemented method, apparatus and article of manufacture for optimizing execution of database queries in a computer system. In one embodiment, the steps and functions include: generating first and second query execution plans for first and second requests, wherein the first and second query execution plans are each comprised of one or more steps that scan a specified table in a database stored on the computer system in order to retrieve data from the table; and executing the first and second query execution plans, wherein intelligent query dispatching is performed on the steps of the first and second query execution plans to ensure that the steps share the data retrieved from the table and cached in memory.

摘要翻译： 用于优化计算机系统中的数据库查询的执行的计算机实现的方法，装置和制品。 在一个实施例中，步骤和功能包括：为第一和第二请求生成第一和第二查询执行计划，其中第一和第二查询执行计划各自包括扫描存储在该数据库中的数据库中的指定表的一个或多个步骤 计算机系统为了从表中检索数据; 以及执行所述第一和第二查询执行计划，其中对所述第一和第二查询执行计划的步骤执行智能查询调度，以确保所述步骤共享从所述表检索并缓存在存储器中的数据。

公开(公告)号：US20090327242A1

公开(公告)日：2009-12-31

申请号：US12229383

申请日：2008-08-22

申请人： Douglas P. Brown ,  Anita Richards ,  Thomas P. Julien ,  Louis M. Burger

发明人： Douglas P. Brown ,  Anita Richards ,  Thomas P. Julien ,  Louis M. Burger

IPC分类号： G06F17/30

CPC分类号： G06F17/30474 ,  G06F17/30463

摘要： A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan is generated for the database query, which may be stored in an in-line query capture database. Execution of the query execution plan may be monitored in order to generate performance information, which also may be stored in the in-line query capture database. The data stored in in-line query capture database may be used during the initial generation of query execution plans, as well as for the re-optimization of a query execution plan, during the execution of the query execution plan.

摘要翻译： 用于优化数据库查询的计算机实现的方法，装置和制品。 为数据库查询生成查询执行计划，该查询执行计划可能存储在一个内联查询捕获数据库中。 可以监视查询执行计划的执行，以便生成性能信息，该信息也可以存储在在线查询捕获数据库中。 存储在在线查询捕获数据库中的数据可以在查询执行计划的初始生成期间以及在执行查询执行计划期间重新优化查询执行计划时使用。

公开(公告)号：US08924981B1

公开(公告)日：2014-12-30

申请号：US12945064

申请日：2010-11-12

申请人： Douglas P. Brown ,  Thomas P. Julien ,  Louis M. Burger ,  Anita Richards

发明人： Douglas P. Brown ,  Thomas P. Julien ,  Louis M. Burger ,  Anita Richards

IPC分类号： G06F9/46 ,  G06F15/173 ,  G06F7/00

CPC分类号： G06F9/4881 ,  G06F17/30445 ,  G06F2209/483

摘要： Requests to be executed in the database system are received, where a plurality of the requests are provided in a queue for later execution. Priority indicators are calculated for assignment to corresponding ones of the plurality of requests in the queue, where the priority indicators are calculated based on delay times and predefined priority levels of the requests. The requests in the queue are executed in order according to the calculated priority indicators.

摘要翻译： 接收在数据库系统中执行的请求，其中在队列中提供多个请求以供稍后执行。 计算优先级指示符以分配给队列中的多个请求中的相应的请求，其中基于请求的延迟时间和预定义的优先级来计算优先级指示符。 队列中的请求按照计算出的优先级指示按顺序执行。

公开(公告)号：US08818988B1

公开(公告)日：2014-08-26

申请号：US12482780

申请日：2009-06-11

申请人： Douglas P. Brown ,  Anita Richards ,  Louis M. Burger ,  Stephen A. Brobst

发明人： Douglas P. Brown ,  Anita Richards ,  Louis M. Burger ,  Stephen A. Brobst

IPC分类号： G06F17/30

CPC分类号： G06F17/30306

摘要： A database system includes an optimizer to generate resource estimates regarding execution of a request in the database system, and a regulator to monitor execution of a request and to adjust a priority level of the request based on the monitored execution and based on the resource estimates provided by the optimizer. The regulator is executable to further feed back statistics regarding execution of the request to the optimizer to improve accuracy of resource estimates provided by the optimizer.

摘要翻译： 数据库系统包括：优化器，用于生成关于在数据库系统中执行请求的资源估计;以及调节器，用于监视请求的执行，并且基于所监视的执行并基于提供的资源估计来调整请求的优先级 由优化器。 调节器可执行以进一步反馈关于执行请求的统计信息给优化器，以提高由优化器提供的资源估计的准确性。

公开(公告)号：US20090327216A1

公开(公告)日：2009-12-31

申请号：US12229397

申请日：2008-08-22

申请人： Douglas P. Brown ,  Anita Richards ,  Louis M. Burger ,  Thomas P. Julien

发明人： Douglas P. Brown ,  Anita Richards ,  Louis M. Burger ,  Thomas P. Julien

IPC分类号： G06F7/06 ,  G06F17/30

CPC分类号： G06F16/24549

摘要： A computer-implemented apparatus, method, and article of manufacture for optimizing a database query. System conditions and operating environment events that occur during operation of the computer system are monitored. An n-dimensional optimizer matrix is used to identify at least one rule resulting from the monitored system conditions and operating environment events. An optimal query execution plan is selected from among a plurality of query execution plans generated for the query in response to the identified rule.

摘要翻译： 用于优化数据库查询的计算机实现的装置，方法和制品。 监视在计算机系统运行期间发生的系统状况和操作环境事件。 使用n维优化器矩阵来识别由受监视的系统条件和操作环境事件产生的至少一个规则。 从响应于所识别的规则为查询生成的多个查询执行计划中选择最佳查询执行计划。

公开(公告)号：US10042674B2

公开(公告)日：2018-08-07

申请号：US13249922

申请日：2011-09-30

申请人： Douglas P. Brown ,  Thomas Julien ,  Anita Richards ,  Louis Burger

发明人： Douglas P. Brown ,  Thomas Julien ,  Anita Richards ,  Louis Burger

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30 ,  G06F9/50

摘要： Capacity of a database system and/or a computing system that includes a database can be effectively changed from a current computing capacity to another computing capacity. This can be achieved by causing usage capacity of at least one of resource to be changed when the database is active. By way of example, capacity of a database system can be regulated by delaying the execution of the database work based on a target capacity. As a result, database work can take relatively longer to complete when the capacity of a database is effectively regulated to be below its full capacity. In effect, a portion of available capacity (excess capacity) can be made inaccessible to the database. However, excess capacity can be used to manage various services of the database in accordance with one or more service criteria (e.g., Service Level Goals or Agreements).