公开(公告)号：US07363617B2

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

申请号：US10153978

申请日：2002-05-23

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

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

IPC分类号： G06F9/44 ,  G06F17/30

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.

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

公开(公告)号：US08010949B2

公开(公告)日：2011-08-30

申请号：US11957426

申请日：2007-12-15

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

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

IPC分类号： G06F9/44 ,  G06F7/00

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.

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

公开(公告)号：US07305629B2

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

申请号：US10255917

申请日：2002-09-26

申请人： Eric Lawrence Barsness ,  Richard Dean Dettinger ,  Brian Edward Olson ,  John Matthew Santosuosso

发明人： Eric Lawrence Barsness ,  Richard Dean Dettinger ,  Brian Edward Olson ,  John Matthew Santosuosso

IPC分类号： G06F3/00

CPC分类号： G06F8/73

摘要： An apparatus, program product and method effectively merge computer documentation for multiple API sets together to facilitate user access to such computer documentation. Such merging of computer documentation may include, in part, the incorporation, into a navigation file, of a plurality of API set links associated with a plurality of API sets, as well as the incorporation, into an index file, of a plurality of index links to documentation files for at least two of the plurality of API sets. Furthermore, computer documentation may be displayed to a user by displaying selected information in a plurality of display regions of a computer display. In a first display region, at least a portion of a first navigation file may be displayed, with the first navigation file including a plurality of API set links associated with a plurality of API sets. In a second display region, at least a portion of a second navigation file associated with a selected API set among the plurality of API sets may be displayed, with the second navigation file including a plurality of program entity links associated with a plurality of program entities in the selected API set. In a third display region, at least a portion of an index file may be displayed, with the index file including a plurality of index links associated with documentation files for at least two API sets from the plurality of API sets.

摘要翻译： 一种设备，程序产品和方法有效地将多个API集合的计算机文档合并在一起，以方便用户访问此类计算机文档。 计算机文档的这种合并可以部分地包括将与多个API集合相关联的多个API集合链接并入到导航文件中，以及将索引文件合并到多个索引中 指向多个API集合中的至少两个的文档文件的链接。 此外，可以通过在计算机显示器的多个显示区域中显示所选择的信息来向用户显示计算机文档。 在第一显示区域中，可以显示第一导航文件的至少一部分，其中第一导航文件包括与多个API集相关联的多个API集合链接。 在第二显示区域中，可以显示与多个API集合中的所选API集相关联的第二导航文件的至少一部分，其中第二导航文件包括与多个节目实体相关联的多个节目实体链接 在所选的API集中。 在第三显示区域中，可以显示索引文件的至少一部分，索引文件包括与来自多个API集合的至少两个API集合的文档文件相关联的多个索引链接。

公开(公告)号：US08566810B2

公开(公告)日：2013-10-22

申请号：US11675395

申请日：2007-02-15

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

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

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

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

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

公开(公告)号：US07792950B2

公开(公告)日：2010-09-07

申请号：US10255484

申请日：2002-09-26

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

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

IPC分类号： G06F15/173 ,  G06F9/44

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

摘要： An apparatus, program product and method collect operational statistics associated with database access by a computer program for use in performing coverage analysis on the program. In particular, coverage analysis may be performed for a computer program that accesses a database by tracking accesses to records in the database by the computer program during coverage analysis, and calculating at least one database coverage statistic based upon the tracked accesses to the records in the database.

摘要翻译： 一种装置，程序产品和方法收集与计算机程序的数据库访问相关联的操作统计，以用于对该程序进行覆盖分析。 特别地，可以对于在覆盖分析期间通过计算机程序跟踪对数据库中的记录的访问来访问数据库的计算机程序进行覆盖分析，并且基于对所述数据库中的记录的跟踪访问来计算至少一个数据库覆盖统计量 数据库。

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

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

公开(公告)号：US09146974B2

公开(公告)日：2015-09-29

申请号：US11870218

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

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

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