Invention Grant
US08775413B2 Parallel, in-line, query capture database for real-time logging, monitoring and optimizer feedback
有权
并行的在线查询捕获数据库,用于实时记录,监控和优化器反馈
- Patent Title: Parallel, in-line, query capture database for real-time logging, monitoring and optimizer feedback
- Patent Title (中): 并行的在线查询捕获数据库,用于实时记录,监控和优化器反馈
-
Application No.: US12229383Application Date: 2008-08-22
-
Publication No.: US08775413B2Publication Date: 2014-07-08
- Inventor: Douglas P. Brown , Anita Richards , Thomas P. Julien , Louis M. Burger
- Applicant: Douglas P. Brown , Anita Richards , Thomas P. Julien , Louis M. Burger
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agency: Gates & Cooper LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
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.
Public/Granted literature
- US20090327242A1 Parallel, in-line, query capture database for real-time logging, monitoring and opitmizer feedback Public/Granted day:2009-12-31
Information query