公开(公告)号：US20060155675A1

公开(公告)日：2006-07-13

申请号：US11277229

申请日：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.

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

公开(公告)号：US20050256884A1

公开(公告)日：2005-11-17

申请号：US11189395

申请日：2005-07-26

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

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

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

CPC分类号： G06F17/3048 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99945

摘要： An apparatus, program product and method utilize one or more usage statistics, which are reflective of what data is actually and/or likely to be used by a client when processing a database query, to reduce or eliminate the transfer of unnecessary data between a client and server in a client-server database management system. Information such as the columns that are or have been used and/or the number of rows that have been accessed, may be utilized to identify certain data that is likely to not be used during processing of the database query. Based upon the data that has been identified, a subset of the data that would otherwise be returned as a result of the database query may be identified and returned to a client, often substantially reducing the amount of data required to be retrieved by a client in connection with a database query.

摘要翻译： 一种装置，程序产品和方法利用一个或多个使用统计信息，其反映在处理数据库查询时客户端实际和/或可能使用的数据，以减少或消除客户端之间的不必要数据传输 和服务器在客户端 - 服务器数据库管理系统中。 可以利用诸如已被使用的列和/或已经被访问的列的数量的信息来标识在处理数据库查询期间可能不被使用的某些数据。 基于已经识别的数据，可以识别否则将作为数据库查询的结果返回的数据的子集，并将其返回给客户端，这通常显着地减少客户端需要检索的数据量 与数据库查询的连接。

公开(公告)号：US20080027999A1

公开(公告)日：2008-01-31

申请号：US11870218

申请日：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.

公开(公告)号：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.

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

公开(公告)号：US20060294080A1

公开(公告)日：2006-12-28

申请号：US11465246

申请日：2006-08-17

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/3048 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99945

摘要： An apparatus, program product and method utilize one or more usage statistics, which are reflective of what data is actually and/or likely to be used by a client when processing a database query, to reduce or eliminate the transfer of unnecessary data between a client and server in a client-server database management system. Information such as the columns that are or have been used and/or the number of rows that have been accessed, may be utilized to identify certain data that is likely to not be used during processing of the database query. Based upon the data that has been identified, a subset of the data that would otherwise be returned as a result of the database query may be identified and returned to a client, often substantially reducing the amount of data required to be retrieved by a client in connection with a database query.

摘要翻译： 一种装置，程序产品和方法利用一个或多个使用统计信息，其反映在处理数据库查询时客户端实际和/或可能使用的数据，以减少或消除客户端之间的不必要数据传输 和服务器在客户端 - 服务器数据库管理系统中。 可以利用诸如已被使用的列和/或已经被访问的列的数量的信息来标识在处理数据库查询期间可能不被使用的某些数据。 基于已经识别的数据，可以识别否则将作为数据库查询的结果返回的数据的子集，并将其返回给客户端，这通常显着地减少客户端需要检索的数据量 与数据库查询的连接。

公开(公告)号：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.

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

公开(公告)号：US20080028382A1

公开(公告)日：2008-01-31

申请号：US11870189

申请日：2007-10-10

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

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

IPC分类号： G06F9/45

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.

公开(公告)号：US20060085423A1

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

申请号：US10965190

申请日：2004-10-14

申请人： Eric Barsness ,  Richard Dettinger ,  Scott Gerard ,  Daniel Kolz ,  Cale Rath ,  Richard Saltness ,  John Santosuosso ,  Richard Stevens ,  Shannon Wenzel

发明人： Eric Barsness ,  Richard Dettinger ,  Scott Gerard ,  Daniel Kolz ,  Cale Rath ,  Richard Saltness ,  John Santosuosso ,  Richard Stevens ,  Shannon Wenzel

IPC分类号： G06F17/30

CPC分类号： H04L41/5083 ,  G06F16/9574

摘要： Methods, articles of manufacture and systems for managing Web services. One embodiment provides a method comprising providing one or more rules configured to determine whether a Web service is deterministic. A deterministic Web service produces in subsequent executions identical output in response to identical input. The one or more rules are associated with the Web service.

摘要翻译： 方法，制造和管理Web服务的系统。 一个实施例提供了一种方法，包括提供被配置为确定Web服务是否是确定性的一个或多个规则。 确定性Web服务在后续执行中产生相同的输出以响应相同的输入。 一个或多个规则与Web服务相关联。

公开(公告)号：US20070169050A1

公开(公告)日：2007-07-19

申请号：US11675395

申请日：2007-02-15

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

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

IPC分类号： G06F9/45

CPC分类号： G06F8/443

摘要： A code optimizer is used to optimize a computer program that references a database by reading database metadata and making suitable optimizations based on the metadata. By taking into account the metadata of a database referenced in the computer program, the optimizer may make suitable optimizations to the computer program. Such optimizations include, without limitation, removing unnecessary calls to the database, removing unnecessary loops, removing unnecessary database operations, providing compile-time errors, and replacing dynamic calls with static data.

摘要翻译： 代码优化器用于优化通过读取数据库元数据并基于元数据进行适当优化来引用数据库的计算机程序。 通过考虑计算机程序中引用的数据库的元数据，优化器可以对计算机程序进行适当的优化。 这种优化包括但不限于删除对数据库的不必要的调用，删除不必要的循环，删除不必要的数据库操作，提供编译时错误，以及用静态数据替换动态调用。

公开(公告)号：US20080098363A1

公开(公告)日：2008-04-24

申请号：US11957426

申请日：2007-12-15

申请人： Eric Barsness ,  Michael Brutman ,  Richard Dettinger ,  Mahdad Majd ,  Brian Olson ,  John Santosuosso

发明人： Eric Barsness ,  Michael Brutman ,  Richard Dettinger ,  Mahdad Majd ,  Brian Olson ,  John Santosuosso

IPC分类号： G06F9/44

CPC分类号： G06F11/3664 ,  Y10S707/99932 ,  Y10S707/99934

摘要： An apparatus and method define the concept of a “database breakpoint.” One or more conditions in the database are specified as a database breakpoint in a debug environment for debugging a computer program that accesses the database. When the database conditions exist, one or more debug functions may be performed with respect to the execution of the computer program. Examples of debug functions include halting execution of the computer program and halting operations to the database by other programs. With both the computer program and database halted, the user may then interrogate the database to determine its state, and may interrogate the program to determine its state. Database breakpoints greatly enhance the utility of a debugger by providing additional conditions for debugging a computer program that accesses a database.

摘要翻译： 一种设备和方法定义了“数据库断点”的概念。 数据库中的一个或多个条件在调试环境中指定为数据库断点，用于调试访问数据库的计算机程序。 当存在数据库条件时，可以针对计算机程序的执行执行一个或多个调试功能。 调试功能的示例包括停止计算机程序的执行和其他程序停止对数据库的操作。 随着计算机程序和数据库都停止，用户然后可以询问数据库以确定其状态，并且可以询问程序以确定其状态。 数据库断点通过提供调试访问数据库的计算机程序的附加条件，大大提高了调试器的效用。