利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

83 条记录 (耗时 0.026 秒)

    Dynamic optimization of prepared statements in a statement pool
    1.
    发明授权
    Dynamic optimization of prepared statements in a statement pool 有权
    动态优化语句池中的准备语句

    公开(公告)号：US07912848B2

    公开(公告)日：2011-03-22

    申请号：US11870225

    申请日：2007-10-10

    申请人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    发明人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew 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.

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

    Dynamic optimization of prepared statements in a statement pool
    2.
    发明授权
    Dynamic optimization of prepared statements in a statement pool 有权
    动态优化语句池中的准备语句

    公开(公告)号：US07356523B2

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

    申请号：US10154023

    申请日：2002-05-23

    申请人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    发明人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew 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.

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

    Database optimization apparatus and method
    4.
    发明授权
    Database optimization apparatus and method 失效

    公开(公告)号：US07089260B2

    公开(公告)日：2006-08-08

    申请号：US10075651

    申请日：2002-02-14

    申请人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    发明人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30292 ,  Y10S707/99942 ,  Y10S707/99943

    摘要： A database optimizer collects statistics regarding which types of applications are accessing the 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. This means that the database optimizer must recognize when a different type of application requests data from any changed column, and must potentially perform a conversion from the new data type to the old data type before returning the requested data. 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 that accesses the column a percentage of time that is less than a second predefined threshold level. In this case, a new column is created in the database so the data is present in both formats, thereby optimizing the performance of both old and new applications that access the data. The database optimizer looks at what type of application requested data, and returns the data in the format optimized for that type of application.

    Computer apparatus and method for caching results of a database query
    5.
    发明授权
    Computer apparatus and method for caching results of a database query 失效

    公开(公告)号：US07089228B2

    公开(公告)日：2006-08-08

    申请号：US10125190

    申请日：2002-04-18

    申请人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    发明人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    IPC分类号： G06F17/30

    CPC分类号： G06F17/3048 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99945 ,  Y10S707/99953

    摘要： A query processor caches data retrieved from executing prepared statements, and uses the cached data for subsequent accesses to the data, if certain conditions for using the cached data are met. The preferred embodiments also include a data staleness handler that takes care of issues that arise from data that may have changed in the database but is not reflected in the cache. One way to handle data staleness in the cache is to specifically enable or disable caching in a query. If caching is disabled, the query processor will access the data in the database. Another way to handle data staleness in the cache is to provide a timer that causes the cache to be invalidated when the timer times out. Yet another way to handle data staleness in the cache is to provide specified conditions that must be met for caching to occur, such as time or date limitations. Still another way to handle data staleness in the cache is to provide an update trigger for the data in the database that corresponds to the cached data. When the data in the database is updated, the update trigger fires, causing the cache to be invalidated. Note that invalidating the cache could also be followed by automatically updating the cache. By caching the results of processing a prepared statement, other queries that use the same prepared statement may be able to access data in the cache instead of going to the database.

    DATABASE OPTIMIZATION THROUGH SCHEMA MODIFICATION
    6.
    发明申请
    DATABASE OPTIMIZATION THROUGH SCHEMA MODIFICATION 审中-公开
    通过原理图进行数据库优化

    公开(公告)号：US20080215532A1

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

    申请号：US12053910

    申请日：2008-03-24

    申请人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    发明人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew 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.

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

    Optimization of database network traffic based upon data-use analysis
    9.
    发明授权
    Optimization of database network traffic based upon data-use analysis 有权
    基于数据使用分析优化数据库网络流量

    公开(公告)号：US08639710B2

    公开(公告)日：2014-01-28

    申请号：US11189395

    申请日：2005-07-26

    申请人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    发明人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    IPC分类号： G06F7/00 ,  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.

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

    Dynamic optimization of prepared statements in a statement pool
    10.
    发明授权
    Dynamic optimization of prepared statements in a statement pool 有权
    动态优化语句池中的准备语句

    公开(公告)号：US07653620B2

    公开(公告)日：2010-01-26

    申请号：US11870189

    申请日：2007-10-10

    申请人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew Santosuosso

    发明人： Jeremy Alan Arnold ,  Eric Lawrence Barsness ,  Richard Dean Dettinger ,  John Matthew 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.

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