-
公开(公告)号：US20080027999A1
公开(公告)日：2008-01-31
申请号：US11870218
申请日：2007-10-10
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.
-
公开(公告)号：US20070073644A1
公开(公告)日：2007-03-29
申请号：US11277146
申请日：2006-03-22
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.
摘要翻译： 数据库优化器收集有关访问数据库的应用程序的统计信息，并对数据库模式进行一个或多个更改以根据收集的统计信息优化性能。 在第一实施例中，优化器检测特定类型的应用程序何时访问数据库超过预定阈值级别的时间百分比，并且如果数据库中的数据以针对应用的不是最佳格式存储，则 将数据库中的一个或多个列的数据类型更改为应用程序的更优化格式。 在第二实施例中，优化器检测何时一个应用程序访问列超过第一预定义阈值级别并小于第二预定义阈值级别的时间百分比，并在数据库中创建新列，以便数据存在 在两种格式。
-
公开(公告)号：US20060155675A1
公开(公告)日：2006-07-13
申请号：US11277229
申请日：2006-03-22
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
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.
摘要翻译： 一种装置，程序产品和方法利用一个或多个使用统计信息，其反映在处理数据库查询时客户端实际和/或可能使用的数据，以减少或消除客户端之间的不必要数据传输 和服务器在客户端 - 服务器数据库管理系统中。 可以利用诸如已被使用的列和/或已经被访问的列的数量的信息来标识在处理数据库查询期间可能不被使用的某些数据。 基于已经识别的数据，可以识别否则将作为数据库查询的结果返回的数据的子集，并将其返回给客户端，这通常显着地减少客户端需要检索的数据量 与数据库查询的连接。
-
公开(公告)号：US20080028382A1
公开(公告)日：2008-01-31
申请号：US11870189
申请日：2007-10-10
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.
-
公开(公告)号：US20080034007A1
公开(公告)日：2008-02-07
申请号：US11870225
申请日：2007-10-10
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
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.
摘要翻译： 一种装置，程序产品和方法利用一个或多个使用统计信息，其反映在处理数据库查询时客户端实际和/或可能使用的数据，以减少或消除客户端之间的不必要数据传输 和服务器在客户端 - 服务器数据库管理系统中。 可以利用诸如已被使用的列和/或已经被访问的列的数量的信息来标识在处理数据库查询期间可能不被使用的某些数据。 基于已经识别的数据，可以识别否则将作为数据库查询的结果返回的数据的子集，并将其返回给客户端，这通常显着地减少客户端需要检索的数据量 与数据库查询的连接。
-
公开(公告)号：US20050273765A1
公开(公告)日：2005-12-08
申请号：US11197895
申请日：2005-08-05
申请人： Jeremy Arnold , John Santosuosso
发明人： Jeremy Arnold , John Santosuosso
CPC分类号： G06F11/3644
摘要： A computer system, program product and method debug an object-oriented computer program by tracking the creation of objects by a plurality of creators (e.g., constructor methods) of a selected class. A user need not separately track each creator. Instead, a debugger identifies each creator and associates breakpoints with all or a user-specified subset of creators to facilitate tracking. Any of the breakpoints may then trigger a halting of execution during debugging. Moreover, in some instances it may be desirable to track the number of creations by all or the subset of the creators for the selected class during program execution until a user-specified condition is satisfied, whereupon program execution is terminated and debugging information is provided to the user.
摘要翻译： 计算机系统，程序产品和方法通过跟踪所选类的多个创建者（例如，构造方法）来跟踪对象的创建来调试面向对象的计算机程序。 用户不需要单独跟踪每个创建者。 相反，调试器识别每个创建者，并将断点与所有或用户指定的创建者子集相关联，以便于跟踪。 任何断点可能会在调试期间触发停止执行。 此外，在某些情况下，可能期望在程序执行期间跟踪所选择的类的创建者的全部或子集的创建次数，直到满足用户指定的条件，从而终止程序执行并且将调试信息提供给 用户。
-
-
-
-
-
-
-
搜索结果
8 条记录 (耗时 0.026 秒)