会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 1. 发明授权
    • Query execution plan efficiency in a database management system
    • 在数据库管理系统中查询执行计划效率
    • US08060495B2
    • 2011-11-15
    • US12255520
    • 2008-10-21
    • Thomas A. BeavinPatrick D. BossmanYou-Chin FuhAdarsh R. PannuTerence P. Purcell
    • Thomas A. BeavinPatrick D. BossmanYou-Chin FuhAdarsh R. PannuTerence P. Purcell
    • G06F17/30
    • G06F17/30463
    • An apparatus, system, and method are disclosed for improving query execution plan efficiency in a database management system. The present invention binds both static database queries and dynamic database queries to new query execution plans (QEPs) that produce the same result set as a former QEP bound to the database queries. Next, the present invention identifies one of the former QEPs and the new QEP as an active QEP and automatically collects execution statistics for one of the former QEPs and the new QEP. Finally, the present invention automatically selects one of the former QEPs and the new QEP as the active QEP in response to completion of the automatic collection of execution statistics, the active QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the active QEP selected based on the execution statistics.
    • 公开了一种用于提高数据库管理系统中的查询执行计划效率的装置,系统和方法。 本发明将静态数据库查询和动态数据库查询绑定到新的查询执行计划(QEP),该查询执行计划(QEP)产生与数据库查询绑定的前一个QEP相同的结果集。 接下来,本发明将前一个QEP和新的QEP之一识别为活动QEP,并自动收集前一个QEP和新的QEP之一的执行统计信息。 最后,本发明响应于完成执行统计的自动收集而自动选择前者QEP和新QEP中的一个作为活动QEP,选择活动QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比,基于执行统计信息选择活动QEP。
    • 2. 发明申请
    • COMPUTER PROGRAM PRODUCT FOR DATABASE QUERY OPTIMIZATION
    • 用于数据库查询优化的计算机程序产品
    • US20090234800A1
    • 2009-09-17
    • US12049644
    • 2008-03-17
    • Snehal S. AntaniChon N. LeiAdarsh R. PannuRajesh P. Ramachandran
    • Snehal S. AntaniChon N. LeiAdarsh R. PannuRajesh P. Ramachandran
    • G06F17/30
    • G06F17/30442
    • A computer program product for database query optimization including a computer usable medium having a computer readable program, wherein the computer readable program, when executed on a computer, causes the computer to receive a database query, search the database query for a literal term, replace the literal term in the database query with a placeholder term to put the database query in a template form, search a directory for a replacement query that corresponds to the database query in the template form, replace the database query with the replacement query and include the placeholder term in the replacement query, and replace the placeholder term in the replacement query with the corresponding literal term to put the replacement query in an executable format, wherein the replacement query is an optimized substitute for the database query.
    • 一种用于数据库查询优化的计算机程序产品,包括具有计算机可读程序的计算机可用介质,其中所述计算机可读程序在计算机上执行时使计算机接收数据库查询,在数据库查询中搜索文本术语,替换 数据库查询中的字面术语用占位符术语将数据库查询放在模板表单中,在目录中搜索与模板表单中数据库查询相对应的替换查询,将数据库查询替换为替换查询,并将 替换查询中的占位符术语,并将替换查询中的占位符术语替换为相应的文字术语,将替换查询放在可执行格式中,其中替换查询是数据库查询的优化替代。
    • 3. 发明授权
    • Computer program product for database query optimization
    • 用于数据库查询优化的计算机程序产品
    • US07970757B2
    • 2011-06-28
    • US12049644
    • 2008-03-17
    • Snehal S. AntaniChon N. LeiAdarsh R. PannuRajesh P. Ramachandran
    • Snehal S. AntaniChon N. LeiAdarsh R. PannuRajesh P. Ramachandran
    • G06F17/30
    • G06F17/30442
    • A computer program product for database query optimization including a computer usable medium having a computer readable program, wherein the computer readable program, when executed on a computer, causes the computer to receive a database query, search the database query for a literal term, replace the literal term in the database query with a placeholder term to put the database query in a template form, search a directory for a replacement query that corresponds to the database query in the template form, replace the database query with the replacement query and include the placeholder term in the replacement query, and replace the placeholder term in the replacement query with the corresponding literal term to put the replacement query in an executable format, wherein the replacement query is an optimized substitute for the database query.
    • 一种用于数据库查询优化的计算机程序产品,包括具有计算机可读程序的计算机可用介质,其中所述计算机可读程序在计算机上执行时使计算机接收数据库查询,在数据库查询中搜索文本术语,替换 数据库查询中的字面术语用占位符术语将数据库查询放在模板表单中,在目录中搜索与模板表单中数据库查询相对应的替换查询,将数据库查询替换为替换查询,并将 替换查询中的占位符术语,并将替换查询中的占位符术语替换为相应的文字术语,将替换查询放在可执行格式中,其中替换查询是数据库查询的优化替代。
    • 5. 发明申请
    • QUERY EXECUTION PLAN EFFICIENCY IN A DATABASE MANAGEMENT SYSTEM
    • 查询执行数据库管理系统中的计划效率
    • US20100114868A1
    • 2010-05-06
    • US12255520
    • 2008-10-21
    • Thomas A. BeavinPatrick D. BossmanYou-Chin FuhAdarsh R. PannuTerence P. Purcell
    • Thomas A. BeavinPatrick D. BossmanYou-Chin FuhAdarsh R. PannuTerence P. Purcell
    • G06F17/30G06F7/00
    • G06F17/30463
    • An apparatus, system, and method are disclosed for improving query execution plan efficiency in a database management system. The present invention binds both static database queries and dynamic database queries to new query execution plans (QEPs) that produce the same result set as a former QEP bound to the database queries. Next, the present invention identifies one of the former QEPs and the new QEP as an active QEP and automatically collects execution statistics for one of the former QEPs and the new QEP. Finally, the present invention automatically selects one of the former QEPs and the new QEP as the active QEP in response to completion of the automatic collection of execution statistics, the active QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the active QEP selected based on the execution statistics.
    • 公开了一种用于提高数据库管理系统中的查询执行计划效率的装置,系统和方法。 本发明将静态数据库查询和动态数据库查询绑定到新的查询执行计划(QEP),该查询执行计划(QEP)产生与数据库查询绑定的前一个QEP相同的结果集。 接下来,本发明将前一个QEP和新的QEP之一识别为活动QEP,并自动收集前一个QEP和新的QEP之一的执行统计信息。 最后,本发明响应于完成执行统计的自动收集而自动选择前者QEP和新QEP中的一个作为活动QEP,选择活动QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比,基于执行统计信息选择活动QEP。