专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20090234800A1 COMPUTER PROGRAM PRODUCT FOR DATABASE QUERY OPTIMIZATION 有权
标题翻译：用于数据库查询优化的计算机程序产品
公开(公告)号：US20090234800A1
公开(公告)日：2009-09-17
申请号：US12049644
申请日：2008-03-17
申请人： Snehal S. Antani , Chon N. Lei , Adarsh R. Pannu , Rajesh P. Ramachandran
发明人： Snehal S. Antani , Chon N. Lei , Adarsh R. Pannu , Rajesh P. Ramachandran
IPC分类号： G06F17/30
CPC分类号： 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.
摘要翻译：一种用于数据库查询优化的计算机程序产品，包括具有计算机可读程序的计算机可用介质，其中所述计算机可读程序在计算机上执行时使计算机接收数据库查询，在数据库查询中搜索文本术语，替换数据库查询中的字面术语用占位符术语将数据库查询放在模板表单中，在目录中搜索与模板表单中数据库查询相对应的替换查询，将数据库查询替换为替换查询，并将替换查询中的占位符术语，并将替换查询中的占位符术语替换为相应的文字术语，将替换查询放在可执行格式中，其中替换查询是数据库查询的优化替代。

2. 发明授权

US07970757B2 Computer program product for database query optimization 有权
标题翻译：用于数据库查询优化的计算机程序产品
公开(公告)号：US07970757B2
公开(公告)日：2011-06-28
申请号：US12049644
申请日：2008-03-17
申请人： Snehal S. Antani , Chon N. Lei , Adarsh R. Pannu , Rajesh P. Ramachandran
发明人： Snehal S. Antani , Chon N. Lei , Adarsh R. Pannu , Rajesh P. Ramachandran
IPC分类号： G06F17/30
CPC分类号： 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. 发明申请

US20080168025A1 METHODS, SYSTEMS, AND COMPUTER PROGRAM PRODUCTS FOR REDUCING DATABASE WORKLOAD VOLUME 失效
标题翻译：用于减少数据库工作量的方法，系统和计算机程序产品
公开(公告)号：US20080168025A1
公开(公告)日：2008-07-10
申请号：US11619797
申请日：2007-01-04
申请人： Geoffrey G. Kratz , Chon N. Lei , Rajesh P. Ramachandran
发明人： Geoffrey G. Kratz , Chon N. Lei , Rajesh P. Ramachandran
IPC分类号： G06F17/30
CPC分类号： G06Q40/04 , G06F17/3046
摘要： Methods, systems and computer program products for reducing database workload volume. Methods include collecting a sequence of database commands directed to a single database record in a database. The sequence of database commands are reduced to a net result by combining database commands within the sequence of database commands. The net result is written to an output entity when the net result includes a database command.
摘要翻译：减少数据库工作量的方法，系统和计算机程序产品。方法包括收集指向数据库中单个数据库记录的数据库命令序列。通过在数据库命令的顺序中组合数据库命令，将数据库命令的顺序减少到最终结果。当净结果包括数据库命令时，净结果将写入输出实体。

4. 发明授权

US08234241B2 Methods, systems, and computer program products for reducing database workload volume 失效
标题翻译：减少数据库工作量的方法，系统和计算机程序产品
公开(公告)号：US08234241B2
公开(公告)日：2012-07-31
申请号：US11619797
申请日：2007-01-04
申请人： Geoffrey G. Kratz , Chon N. Lei , Rajesh P. Ramachandran
发明人： Geoffrey G. Kratz , Chon N. Lei , Rajesh P. Ramachandran
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06Q40/04 , G06F17/3046
摘要： Methods, systems and computer program products for reducing database workload volume. Methods include collecting a sequence of database commands directed to a single database record in a database. The sequence of database commands are reduced to a net result by combining database commands within the sequence of database commands. The net result is written to an output entity when the net result includes a database command.
摘要翻译：减少数据库工作量的方法，系统和计算机程序产品。方法包括收集指向数据库中单个数据库记录的数据库命令序列。通过在数据库命令的顺序中组合数据库命令，将数据库命令的顺序减少到最终结果。当净结果包括数据库命令时，净结果将写入输出实体。

5. 发明申请

US20120191641A1 CHARACTERIZING BUSINESS INTELLIGENCE WORKLOADS 有权
标题翻译：表征商业智能工作
公开(公告)号：US20120191641A1
公开(公告)日：2012-07-26
申请号：US13011389
申请日：2011-01-21
申请人： Gary W. CRUPI , Chon N. Lei , Mei Hing Jackson
发明人： Gary W. CRUPI , Chon N. Lei , Mei Hing Jackson
IPC分类号： G06F17/30
CPC分类号： G06F17/30289
摘要： One or more embodiments characterize workloads in a data warehouse system. A set of accounting data associated with a data warehouse system comprising at least one database is collected. A set of query concurrency information associated with the database is determined determining based on the set of accounting data. The set of query concurrency information identifies a plurality of queries executed on the database simultaneously and a duration of this execution. A set of processor utilization distribution information associated with the plurality of queries is determined based on the set of accounting data. A set of data access information indicating a quantity of data accessed by each query in the plurality of queries is determined. A workload profile associated with the database is generated based on the set of query concurrency information, the set of processor utilization distribution information, and the set of data access information.
摘要翻译：一个或多个实施例表征数据仓库系统中的工作负载。收集与包括至少一个数据库的数据仓库系统相关联的一组会计数据。基于该组会计数据确定与数据库相关联的一组查询并发信息。查询并发信息的集合同时识别在数据库上执行的多个查询以及该执行的持续时间。基于会计数据的集合来确定与多个查询相关联的一组处理器利用率分布信息。确定指示多个查询中的每个查询访问的数据量的一组数据访问信息。基于查询并发信息集合，处理器利用率分布信息集合和数据访问信息集合来生成与数据库相关联的工作负载配置文件。

6. 发明授权

US08768878B2 Characterizing business intelligence workloads 有权
标题翻译：表征商业智能工作负载
公开(公告)号：US08768878B2
公开(公告)日：2014-07-01
申请号：US13011389
申请日：2011-01-21
申请人： Gary W. Crupi , Chon N. Lei , Mei Hing Jackson
发明人： Gary W. Crupi , Chon N. Lei , Mei Hing Jackson
IPC分类号： G06F17/30
CPC分类号： G06F17/30289
摘要： One or more embodiments characterize workloads in a data warehouse system. A set of accounting data associated with a data warehouse system comprising at least one database is collected. A set of query concurrency information associated with the database is determined determining based on the set of accounting data. The set of query concurrency information identifies a plurality of queries executed on the database simultaneously and a duration of this execution. A set of processor utilization distribution information associated with the plurality of queries is determined based on the set of accounting data. A set of data access information indicating a quantity of data accessed by each query in the plurality of queries is determined. A workload profile associated with the database is generated based on the set of query concurrency information, the set of processor utilization distribution information, and the set of data access information.
摘要翻译：一个或多个实施例表征数据仓库系统中的工作负载。收集与包括至少一个数据库的数据仓库系统相关联的一组会计数据。基于该组会计数据确定与数据库相关联的一组查询并发信息。查询并发信息的集合同时识别在数据库上执行的多个查询以及该执行的持续时间。基于会计数据的集合来确定与多个查询相关联的一组处理器利用率分布信息。确定指示多个查询中的每个查询访问的数据量的一组数据访问信息。基于查询并发信息集合，处理器利用率分布信息集合和数据访问信息集合来生成与数据库相关联的工作负载配置文件。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式