-
公开(公告)号：US20100042631A1
公开(公告)日：2010-02-18
申请号：US12190187
申请日：2008-08-12
Applicant: Yefim Shuf , Hong Min , Terence Patrick Purcell , Ou Jin , Fen-Ling Lin , Brian Thinh-Vinh Tran , Patrick Dooling Bossman
Inventor： Yefim Shuf , Hong Min , Terence Patrick Purcell , Ou Jin , Fen-Ling Lin , Brian Thinh-Vinh Tran , Patrick Dooling Bossman
IPC: G06F17/30
CPC classification number: G06F17/30445
Abstract: Techniques for partitioning a query are provided. The techniques include establishing one or more criterion for partitioning a query, wherein the query comprises one or more tables, materializing a first of the one or more tables, partitioning the first of the one or more tables until the one or more criterion have been satisfied, and partitioning and joining a remainder of the one or more tables of the query.
Abstract translation: 提供了分割查询的技术。 这些技术包括建立用于划分查询的一个或多个标准，其中该查询包括一个或多个表，实现该一个或多个表中的第一个表，划分一个或多个表中的第一个，直到满足一个或多个标准 ，以及分割和加入查询的一个或多个表的其余部分。
-
公开(公告)号：US20090030875A1
公开(公告)日：2009-01-29
申请号：US12140994
申请日：2008-06-17
Applicant: Patrick Dooling Bossman , You-Chin Fuh , Chan-Hua Liu
Inventor： Patrick Dooling Bossman , You-Chin Fuh , Chan-Hua Liu
IPC: G06F17/30
CPC classification number: G06F17/30536 , G06F17/30306 , Y10S707/99934 , Y10S707/99943 , Y10S707/99945
Abstract: Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.
Abstract translation: 公开了一种维护统计的技术。 接收到查询。 执行列组生成以形成一个或多个列组。 基于针对先前接收到的查询生成的统计数据执行列组细化。 统计检查自动执行。 生成统计信息收集命令，获取统计信息。
-
公开(公告)号：US07930294B2
公开(公告)日：2011-04-19
申请号：US12190187
申请日：2008-08-12
Applicant: Yefim Shuf , Hong Min , Terence Patrick Purcell , Ou Jin , Fen-Ling Lin , Brian Thinh-Vinh Tran , Patrick Dooling Bossman
Inventor： Yefim Shuf , Hong Min , Terence Patrick Purcell , Ou Jin , Fen-Ling Lin , Brian Thinh-Vinh Tran , Patrick Dooling Bossman
IPC: G06F17/30
CPC classification number: G06F17/30445
Abstract: Techniques for partitioning a query are provided. The techniques include establishing one or more criterion for partitioning a query, wherein the query comprises one or more tables, materializing a first of the one or more tables, partitioning the first of the one or more tables until the one or more criterion have been satisfied, and partitioning and joining a remainder of the one or more tables of the query.
Abstract translation: 提供了分割查询的技术。 这些技术包括建立用于划分查询的一个或多个标准，其中该查询包括一个或多个表，实现该一个或多个表中的第一个表，划分一个或多个表中的第一个，直到满足一个或多个标准 ，以及分割和加入查询的一个或多个表的其余部分。
-
公开(公告)号：US07412439B2
公开(公告)日：2008-08-12
申请号：US10752915
申请日：2004-01-07
Applicant: Patrick Dooling Bossman , You-Chin Fuh , Chan-Hua Liu
Inventor： Patrick Dooling Bossman , You-Chin Fuh , Chan-Hua Liu
CPC classification number: G06F17/30536 , G06F17/30306 , Y10S707/99934 , Y10S707/99943 , Y10S707/99945
Abstract: Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.
Abstract translation: 公开了一种维护统计的技术。 接收到查询。 执行列组生成以形成一个或多个列组。 基于针对先前接收到的查询生成的统计数据执行列组细化。 统计检查自动执行。 生成统计信息收集命令，获取统计信息。
-
Patent Agency Ranking
公开(公告)号：US07984024B2
公开(公告)日：2011-07-19
申请号：US12140994
申请日：2008-06-17
Applicant: Patrick Dooling Bossman , You-Chin Fuh , Chan-Hua Liu
Inventor： Patrick Dooling Bossman , You-Chin Fuh , Chan-Hua Liu
CPC classification number: G06F17/30536 , G06F17/30306 , Y10S707/99934 , Y10S707/99943 , Y10S707/99945
Abstract: Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.
Abstract translation: 公开了一种维护统计的技术。 接收到查询。 执行列组生成以形成一个或多个列组。 基于针对先前接收到的查询生成的统计数据执行列组细化。 统计检查自动执行。 生成统计信息收集命令，获取统计信息。
-
公开(公告)号：US07302422B2
公开(公告)日：2007-11-27
申请号：US10824856
申请日：2004-04-14
Applicant: Patrick Dooling Bossman , You-Chin Fuh , Shuanglin Guo , Chan-Hua Liu , Yoichi Tsuji
Inventor： Patrick Dooling Bossman , You-Chin Fuh , Shuanglin Guo , Chan-Hua Liu , Yoichi Tsuji
CPC classification number: G06F17/30306 , Y10S707/99932 , Y10S707/99934
Abstract: In various embodiments, a method, apparatus, and article of manufacture collect statistics in a database management system. A workload comprising a plurality of database queries is received. Query statistics for the database queries are identified. The query statistics for the database queries are consolidated to provide consolidated statistics. One or more statistics collection requests are generated based on the consolidated statistics.
Abstract translation: 在各种实施例中，方法，装置和制品在数据库管理系统中收集统计数据。 接收包括多个数据库查询的工作负载。 识别数据库查询的查询统计信息。 合并数据库查询的查询统计信息以提供统一统计信息。 基于统一统计信息生成一个或多个统计信息收集请求。
-
公开(公告)号：US07814072B2
公开(公告)日：2010-10-12
申请号：US11028186
申请日：2004-12-30
Applicant: Patrick Dooling Bossman , You-Chin Fuh , Shuanglin Guo , Chan-hua Liu , Yoichi Tsuji , Changjiu Xian
Inventor： Patrick Dooling Bossman , You-Chin Fuh , Shuanglin Guo , Chan-hua Liu , Yoichi Tsuji , Changjiu Xian
IPC: G06F17/00
CPC classification number: G06F17/30315
Abstract: A method of, a computer program product for and a computer system for managing statistics in a database management system are provided. A value of a volatility of a statistic is determined. A value of a staleness of the statistic is determined using the value of the volatility. A statistics collection task is generated in response to, at least in part, the value of the staleness exceeding a value of a staleness threshold. The statistics collection task is executed to collect an additional value of the statistic. The additional value of the statistic is stored.
Abstract translation: 提供了一种用于管理数据库管理系统中的统计的计算机程序产品和计算机系统的方法。 确定统计量的波动率的值。 使用波动率的值确定统计量的平均值。 响应于至少部分地响应于超过平常阈值的陈旧值的值来生成统计收集任务。 执行统计信息收集任务以收集统计信息的附加值。 存储统计信息的附加值。
-
8.发明申请METHOD AND APPARATUS FOR AGGREGATING DATABASE RUNTIME INFORMATION AND ANALYZING APPLICATION PERFORMANCE 审中-公开用于聚合数据库运行信息和分析应用性能的方法和装置公开(公告)号：US20080140627A1
公开(公告)日：2008-06-12
申请号：US11849181
申请日：2007-08-31
Applicant: Patrick Dooling BOSSMAN , You-Chin FUH , Kun Peng REN , Chan-Hua LIU , Bing Jiang SUN , Fang XING
Inventor： Patrick Dooling BOSSMAN , You-Chin FUH , Kun Peng REN , Chan-Hua LIU , Bing Jiang SUN , Fang XING
IPC: G06F17/30
CPC classification number: G06F16/217
Abstract: The present invention provides a method and an apparatus for aggregating database runtime information and analyzing application performance. According to one aspect of the present invention, there is provided a method for aggregating database runtime information, comprising: aggregating said database runtime information based on queries; and aggregating, based on objects, said database runtime information that is aggregated based on queries.
Abstract translation: 本发明提供了一种用于聚合数据库运行时信息并分析应用性能的方法和装置。 根据本发明的一个方面，提供了一种用于聚合数据库运行时信息的方法，包括：基于查询聚合所述数据库运行时信息; 并基于对象聚合基于查询聚合的所述数据库运行时信息。
-
公开(公告)号：US07139749B2
公开(公告)日：2006-11-21
申请号：US10373237
申请日：2003-02-24
Applicant: Patrick Dooling Bossman , You-Chin Fuh , Chan-Hua Liu , Ping Wang , Yun Wang , Jie Zhang
Inventor： Patrick Dooling Bossman , You-Chin Fuh , Chan-Hua Liu , Ping Wang , Yun Wang , Jie Zhang
IPC: G06F17/30
CPC classification number: G06F17/30306 , Y10S707/99931 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
Abstract: Provided are a method, system, an program for tuning a database query. Provided are a base access plan to implement the database query and statistics including information on a layout of the database against which the query will be executed. The statistics are processed to determine performance problems with the base access plan as part of a first analysis of the base access plan and the determined performance problems are processed as part of a second analysis to provide an analysis of the determined performance problems and processing cost of the base access plan. Recommendations are generated to tune the base access plan to improve performance.
-
-
-
-
-
-
-
-
Search Results
9
records
(took 0.014 seconds)
