公开(公告)号：US20070150871A1

公开(公告)日：2007-06-28

申请号：US11316287

申请日：2005-12-22

申请人： Eric Barsness ,  Daniel Beuch ,  Richard Saltness ,  John Santosuosso

发明人： Eric Barsness ,  Daniel Beuch ,  Richard Saltness ,  John Santosuosso

IPC分类号： G06F9/44

CPC分类号： G06F11/3616 ,  G06F11/3612

摘要： A program product, an apparatus, and method of autonomically adjusting when performance data from a call stack is collected during a trace. In particular, the sampling interval between call stack collections may be autonomically adjusted while a trace is executing based upon the call stack, various performance metrics, and/or previous call stack collections.

摘要翻译： 在跟踪期间收集来自呼叫堆栈的性能数据时的自动调整的程序产品，装置和方法。 特别地，调用堆栈集合之间的采样间隔可以在基于调用堆栈，各种性能度量和/或先前的调用堆栈集合执行跟踪的情况下自动调整。

公开(公告)号：US20060130001A1

公开(公告)日：2006-06-15

申请号：US11000449

申请日：2004-11-30

申请人： Daniel Beuch ,  Richard Saltness ,  John Santosuosso

发明人： Daniel Beuch ,  Richard Saltness ,  John Santosuosso

IPC分类号： G06F9/44

CPC分类号： G06F11/3612 ,  G06F11/3466 ,  G06F2201/865 ,  G06F2201/88

摘要： A method and apparatus for monitoring the performance of a computer system with one or more active programs. A periodic sampling of the call stack is obtained. The sampled call stack is examined to infer the system performance similar to that obtained using prior art event based profiling. Embodiments also are directed to a combination approach to describing the system performance using a historical sampling to infer additional detail to fill in the gaps of the sampled data.

摘要翻译： 一种用于利用一个或多个活动程序监视计算机系统的性能的方法和装置。 获得调用堆栈的周期性采样。 检查采样的调用堆栈以推断与使用现有技术的基于事件的分析获得的系统性能类似的系统性能。 实施例还涉及使用历史采样来描述系统性能以推断附加细节以填补采样数据的间隙的组合方法。

公开(公告)号：US20050192988A1

公开(公告)日：2005-09-01

申请号：US10787632

申请日：2004-02-26

申请人： Eric Barsness ,  Daniel Beuch ,  Randy Ruhlow ,  John Santosuosso

发明人： Eric Barsness ,  Daniel Beuch ,  Randy Ruhlow ,  John Santosuosso

IPC分类号： G06F17/00

CPC分类号： G06F17/30489 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A method, system and article of manufacture for processing aggregation queries that are executed against a database and, more particularly, for managing aggregation data structures associated with tables of a database. One embodiment provides a method for managing creation of aggregation data structures for tables of a database. The method comprises receiving an aggregation query specifying at least one aggregation operation on data of a table of the database, determining aggregation information for the aggregation query, the aggregation information describing aspects of the aggregation query and its respective aggregation operation, determining whether the aggregation information satisfies predefined conditions, and, if the predefined conditions are satisfied by the aggregation information, creating an aggregation data structure for the table of the database in a manner allowing return of aggregation data of the created aggregation data structure upon receipt of a suitable aggregation query without executing the suitable aggregation query against the table of the database, wherein the suitable aggregation query includes the aggregation operation contained in the aggregation query for which the aggregation data structure was created.

摘要翻译： 一种用于处理针对数据库执行的聚合查询的方法，系统和制品，更具体地，用于管理与数据库的表相关联的聚合数据结构。 一个实施例提供了一种管理数据库表的聚合数据结构的创建的方法。 该方法包括接收指定对数据库表的数据的至少一次聚合操作的聚合查询，确定聚合查询的聚合信息，描述聚合查询的各个聚合信息及其各自的聚合操作，确定聚合信息 满足预定条件，并且如果通过聚合信息满足预定义条件，则在接收到合适的聚集查询后，以允许返回所创建的聚合数据结构的聚合数据的方式为数据库的表创建聚合数据结构，而没有 针对数据库的表执行合适的聚合查询，其中合适的聚合查询包括聚合数据结构被创建的聚合查询中包含的聚合操作。

公开(公告)号：US20070005631A1

公开(公告)日：2007-01-04

申请号：US11171728

申请日：2005-06-30

申请人： Eric Barsness ,  Daniel Beuch ,  John Santosuosso

发明人： Eric Barsness ,  Daniel Beuch ,  John Santosuosso

IPC分类号： G06F7/00

CPC分类号： G06F16/2272

摘要： The activity of a database is monitored, and index split options are dynamically determined from the monitored database activity. Appropriate action may then be taken based on the dynamically determined index split options. For example, the index may be automatically split using the dynamically determined index split options. A user command that specifies index split options may be compared to the dynamically determined index split options, and if the user command is not compatible with the dynamically determined index split options, the command may be inhibited, or the user may receive a warning message in response to the command. In addition, existing index use may be monitored, and if the monitored index use indicates the index is split poorly, the index may be re-generated using the dynamically determined index split options.

摘要翻译： 监视数据库的活动，并从监视的数据库活动动态确定索引拆分选项。 然后可以基于动态确定的索引拆分选项进行适当的动作。 例如，可以使用动态确定的索引拆分选项自动拆分索引。 可以将指定索引拆分选项的用户命令与动态确定的索引拆分选项进行比较，并且如果用户命令与动态确定的索引拆分选项不兼容，则该命令可能被禁止，或者用户可能接收到警告消息 回应命令。 此外，可以监视现有的索引使用，并且如果监视的索引使用指示索引被拆分差，则可以使用动态确定的索引拆分选项重新生成索引。

公开(公告)号：US20060085464A1

公开(公告)日：2006-04-20

申请号：US10965124

申请日：2004-10-14

申请人： Daniel Beuch ,  John Santosuosso

发明人： Daniel Beuch ,  John Santosuosso

IPC分类号： G06F7/00

CPC分类号： G06F16/24565

摘要： A master table and one or more slave tables are linked together by different referential integrity constraints. A database engine maintains a separate data structure that includes information about which slave tables include corresponding records that may be affected by a constraint. Accordingly, when an operation is performed on the master table, the data structure is referenced to determine which slave tables has records which are affected as well. The data structure may be a bitmap, an encoded vector index, or separate fields within the master database. As a result of this data structure, unnecessary I/O operations are avoided involving slave tables without a corresponding record.

摘要翻译： 主表和一个或多个从表通过不同的引用完整性约束链接在一起。 数据库引擎维护一个单独的数据结构，其中包含关于哪些从表包括可能受约束影响的对应记录的信息。 因此，当对主表进行操作时，参考数据结构来确定哪些从属表具有受影响的记录。 数据结构可以是位图，编码矢量索引或主数据库中的单独字段。 作为这种数据结构的结果，避免了不必要的I / O操作，涉及从属表而没有相应的记录。