公开(公告)号：US20070073644A1

公开(公告)日：2007-03-29

申请号：US11277146

申请日：2006-03-22

申请人： Jeremy Arnold ,  Eric Barsness ,  Richard Dettinger ,  John Santosuosso

发明人： Jeremy Arnold ,  Eric Barsness ,  Richard Dettinger ,  John Santosuosso

IPC分类号： G06F17/30

CPC分类号： G06F16/211 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A database optimizer collects statistics regarding applications accessing a database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and is less than a second predefined threshold level, and creates a new column in the database so the data is present in both formats.

摘要翻译： 数据库优化器收集有关访问数据库的应用程序的统计信息，并对数据库模式进行一个或多个更改以根据收集的统计信息优化性能。 在第一实施例中，优化器检测特定类型的应用程序何时访问数据库超过预定阈值级别的时间百分比，并且如果数据库中的数据以针对应用的不是最佳格式存储，则 将数据库中的一个或多个列的数据类型更改为应用程序的更优化格式。 在第二实施例中，优化器检测何时一个应用程序访问列超过第一预定义阈值级别并小于第二预定义阈值级别的时间百分比，并在数据库中创建新列，以便数据存在 在两种格式。

公开(公告)号：US20070033240A1

公开(公告)日：2007-02-08

申请号：US11197603

申请日：2005-08-04

申请人： Eric Barsness ,  John Santosuosso

发明人： Eric Barsness ,  John Santosuosso

IPC分类号： G06F17/30

CPC分类号： G06F12/0253

摘要： Scheduling garbage collection by gathering garbage collection information about two or more garbage collection processes, and determining when at least one of the two or more garbage collection processes should execute in dependence upon the garbage collection information is disclosed. Garbage collection information may be gathered through inter-process communication between two or more garbage collection processes, or by gathering garbage collection information from a computer on which at least one garbage collection processes is running. Determining when at least one of garbage collection processes should execute in dependence upon the garbage collection information may include determining a time to execute at least one garbage collection process so as to reduce the likelihood that execution of two or more of the garbage collection processes will overlap. A master garbage collection scheduler may be provided to schedule garbage collection.

摘要翻译： 通过收集关于两个或更多垃圾收集过程的垃圾收集信息以及根据垃圾收集信息来确定两个或多个垃圾收集过程中的至少一个应该执行的调度垃圾收集。 垃圾收集信息可以通过两个或多个垃圾回收进程之间的进程间通信收集，或者通过收集来自运行至少一个垃圾回收进程的计算机的垃圾收集信息来收集垃圾收集信息。 确定垃圾收集过程中的至少一个何时根据垃圾收集信息执行可以包括确定执行至少一个垃圾收集过程的时间，以便减少两个或更多垃圾收集过程的执行重叠的可能性 。 可以提供主垃圾收集调度器来调度垃圾收集。

公开(公告)号：US20070033181A1

公开(公告)日：2007-02-08

申请号：US11197604

申请日：2005-08-04

申请人： Eric Barsness ,  John Santosuosso ,  John Stroh

发明人： Eric Barsness ,  John Santosuosso ,  John Stroh

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： A database journal mechanism stores both row operations and database queries in a database journal. The database queries in the journal provide significant additional information that may be used in a number of different ways. For example, a database replication send mechanism in accordance with the preferred embodiments could read a database query in the journal and determine that the query affects several rows. The database replication send mechanism could then transmit the database query to the computer system that hosts the replicated database. A database replication receive mechanism in accordance with the preferred embodiments receives the database query, and executes the database query on the replicated database. As a result, the transmission of a single database query can replace the transmission of many row operations.

摘要翻译： 数据库日志机制将行操作和数据库查询都存储在数据库日志中。 期刊中的数据库查询提供可以以多种不同方式使用的重要附加信息。 例如，根据优选实施例的数据库复制发送机制可以读取日志中的数据库查询，并确定查询影响多行。 然后，数据库复制发送机制可以将数据库查询传送到承载复制数据库的计算机系统。 根据优选实施例的数据库复制接收机制接收数据库查询，并对复制数据库执行数据库查询。 因此，单个数据库查询的传输可以替代许多行操作的传输。

公开(公告)号：US20060101418A1

公开(公告)日：2006-05-11

申请号：US10970412

申请日：2004-10-21

申请人： Eric Barsness ,  John Santosuosso

发明人： Eric Barsness ,  John Santosuosso

IPC分类号： G06F9/44

CPC分类号： G06F11/3664 ,  G06F8/33

摘要： An apparatus and method automatically generate an event profile in an integrated development environment. In one specific implementation, an event profile is automatically created that identifies portions of the computer program that have changed since the last time the computer program was run. The automatically-generated event profile may be used by a profiler to generate a trace of the computer program. By automatically creating the event profile based on the code that changed, the code developer is relieved of the burden of manually creating many event profiles.

摘要翻译： 设备和方法在集成开发环境中自动生成事件简档。 在一个具体实现中，自动创建事件简档，其识别自上次计算机程序运行以来已经改变的计算机程序的部分。 分析器可以使用自动生成的事件简档来生成计算机程序的跟踪。 通过根据更改的代码自动创建事件配置文件，代码开发人员将免除手动创建许多事件配置文件的负担。

公开(公告)号：US20060064426A1

公开(公告)日：2006-03-23

申请号：US10948774

申请日：2004-09-23

申请人： Eric Barsness ,  Mahdad Majd ,  John Santosuosso

发明人： Eric Barsness ,  Mahdad Majd ,  John Santosuosso

IPC分类号： G06F17/30

CPC分类号： G06F17/30365

摘要： A database system has a contention monitor which determines when the level of contention for accessing or inserting records in the database rises above a threshold, and inhibits non-critical access to the database to reduce the level of contention. In a preferred embodiment, the level of contention is determined by periodically measuring the time for an INSERT operation on the database, and comparing the time to a threshold derived from a baseline time measurement for the operation during a time of normal database activity. Thus the contention level is inferred from the time to do the operation, in this case the INSERT query. In one embodiment, the contention monitor notifies a system administrator to take action to reduce the contention. In another embodiment, the contention monitor informs the system to take action automatically according to predetermined selections by the system administrator.

摘要翻译： 数据库系统具有竞争监视器，其确定何时访问或插入数据库中的记录的竞争级别高于阈值，并且禁止对数据库的非关键访问以降低竞争级别。 在优选实施例中，通过周期性地测量数据库上的INSERT操作的时间，并将时间与从正常数据库活动期间的操作的基线时间测量得出的阈值进行比较来确定争用级别。 因此，从执行操作的时间推断争用级别，在这种情况下是INSERT查询。 在一个实施例中，争用监视器通知系统管理员采取行动以减少争用。 在另一个实施例中，争用监控器通知系统根据系统管理员的预定选择自动采取行动。

公开(公告)号：US20060048013A1

公开(公告)日：2006-03-02

申请号：US10932731

申请日：2004-09-02

申请人： Eric Barsness ,  Cary Bates ,  Mahdad Majd ,  John Santosuosso

发明人： Eric Barsness ,  Cary Bates ,  Mahdad Majd ,  John Santosuosso

IPC分类号： G06F11/00

CPC分类号： G06F11/366

摘要： A run-time monitor allows defining sets of run-time error criteria and corresponding diagnostic action to take when the run-time error criteria is satisfied. One way to define the run-time error criteria is to take a baseline measurement of run-time errors that occur during normal processing conditions. A run-time error criteria may then be defined that is based on the baseline measurement. In this manner, a rate of run-time errors that normally occur may be ignored, while a rate of run-time errors in excess of the run-time error criteria could automatically initiate diagnostic action. In this manner, the ability of a programmer to debug run-time errors is significantly enhanced.

摘要翻译： 运行时监视器允许在满足运行时错误标准时定义运行时错误标准集和相应的诊断动作。 定义运行时错误标准的一种方法是对在正常处理条件下发生的运行时错误进行基线测量。 然后可以基于基线测量定义运行时错误标准。 以这种方式，通常发生的运行时错误率可能被忽略，而运行时错误超出运行时错误标准的速率可以自动启动诊断动作。 以这种方式，程序员调试运行时错误的能力显着增强。

公开(公告)号：US20050240933A1

公开(公告)日：2005-10-27

申请号：US10829626

申请日：2004-04-22

申请人： Eric Barsness ,  John Santosuosso

发明人： Eric Barsness ,  John Santosuosso

IPC分类号： G06F9/46 ,  G06F9/50

CPC分类号： G06F11/3404 ,  G06F9/485 ,  G06F9/5077 ,  G06F11/3409 ,  G06F2201/81 ,  G06F2209/5022 ,  G06F2209/508

摘要： A method, apparatus, system, and signal-bearing medium that in an embodiment collect a performance metric of a first partition in a logically-partitioned computer. If the difference between the performance metric and an expected performance metric exceeds a threshold, then a job or another partition is shut down or suspended. The expected performance metric is calculated based on the performance that is expected if the first partition is the only partition.

摘要翻译： 一种方法，装置，系统和信号承载介质，其在一个实施例中收集逻辑分区计算机中的第一分区的性能度量。 如果性能指标和预期性能指标之间的差异超过阈值，则作业或其他分区将被关闭或暂停。 预期性能度量是根据第一个分区是唯一分区所预期的性能计算的。

公开(公告)号：US20050154757A1

公开(公告)日：2005-07-14

申请号：US10753523

申请日：2004-01-08

申请人： Eric Barsness ,  Brian Muras ,  John Santosuosso

发明人： Eric Barsness ,  Brian Muras ,  John Santosuosso

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30702 ,  G06F17/30867 ,  Y10S707/99933 ,  Y10S707/99935 ,  Y10S707/99936 ,  Y10S707/99937 ,  Y10S707/99945 ,  Y10S707/99948

摘要： A database engine and optimizer framework support creation of a series of profiling indices over a column having character string data, such as a traditional “varchar” data type. The profiling indices result in a reduction of the number of records that are searched when searching for a sub-string match within that column. In some embodiments, the series of indices are created over a column that is typically searched using the LIKE predicate or some similar technique; these indices indicate for each record whether certain sub-strings may exist in that record's value in the column. Thus, the indices are used to find the rows that may match one or more portions of the particular term being queried or, in other words, eliminate those records that do not have at least a portion of the term to be matched. The number of records actually retrieved and searched for the query sub-string is thereby reduced.

摘要翻译： 数据库引擎和优化器框架支持在具有字符串数据的列（例如传统的“varchar”数据类型）上创建一系列概要分析索引。 分析索引导致在搜索该列中的子字符串匹配时减少搜索的记录数。 在一些实施例中，通过使用LIKE谓词或一些类似技术通常搜索的列创建一系列索引; 这些索引为每个记录指示该列中该记录的值中是否存在某些子字符串。 因此，索引用于找到可以匹配要查询的特定术语的一个或多个部分的行，或者换句话说，消除不具有要匹配的术语的至少一部分的那些记录。 由此减少实际检索和查询查询子串的记录数。

公开(公告)号：US20080052720A1

公开(公告)日：2008-02-28

申请号：US11930765

申请日：2007-10-31

申请人： Eric Barsness ,  Mahdad Majd ,  Randy Ruhlow ,  John Santosuosso

发明人： Eric Barsness ,  Mahdad Majd ,  Randy Ruhlow ,  John Santosuosso

IPC分类号： G06F9/50

CPC分类号： G06F17/30445 ,  G06F9/50 ,  G06F9/5072 ,  G06F9/5077 ,  G06F17/30463

摘要： Methods, systems, and computer program products for dynamically adjusting computer resources, as appropriate, in response to predictions of query runtimes as well as for rendering costs of the computer resources actually utilized, which costs are consistent with consumer demands.

摘要翻译： 适用于动态调整计算机资源的方法，系统和计算机程序产品，以响应查询运行时间的预测以及实际使用的计算机资源的成本，哪些成本与消费者需求一致。

公开(公告)号：US20080034007A1

公开(公告)日：2008-02-07

申请号：US11870225

申请日：2007-10-10

申请人： Jeremy Arnold ,  Eric Barsness ,  Richard Dettinger ,  John Santosuosso

发明人： Jeremy Arnold ,  Eric Barsness ,  Richard Dettinger ,  John Santosuosso

IPC分类号： G06F17/30

CPC分类号： G06F17/3056 ,  G06F17/30442 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99936

摘要： An apparatus, program product and method dynamically optimize prepared statements resident in a statement pool to permit subsequent reuses of such statements to utilize the optimized representations of such statements. The optimization of pooled statements may be performed responsive to the tracked usage of the statements in a statement pool, to direct the overhead associated with such optimization to those statements that are more likely to be utilized in the future. Among a multitude of possible optimizations, a pooled statement that requests data in a format other than that utilized by the database being accessed may be modified to request the data in the format used by the database, thereby decreasing the overhead in the database associated with format conversions.

摘要翻译： 一种装置，程序产品和方法动态地优化驻留在语句池中的准备语句，以允许这些语句的后续重用以利用这些语句的优化表示。 可以响应于语句池中的语句的跟踪使用来执行合并语句的优化，以将与这种优化相关联的开销定向到将来更有可能被利用的那些语句。 在许多可能的优化中，可以修改以不同于被访问的数据库所使用的格式以外的格式的数据库的汇总语句，以以数据库使用的格式请求数据，从而减少与格式相关联的数据库中的开销 转换。