公开(公告)号：US07630958B2

公开(公告)日：2009-12-08

申请号：US12175048

申请日：2008-07-17

Applicant: Paul Reuben Day ,  Brian Robert Muras ,  Anne Marie Ryg

Inventor： Paul Reuben Day ,  Brian Robert Muras ,  Anne Marie Ryg

IPC: G06F17/30

CPC classification number: G06F17/30471 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99934

Abstract: A query plan modification system and method relate to a database system that includes a cost-based optimizer for generating access plans. The database system also permits a user to view an access plan that has been generated by a particular SQL query and modify the access plan if desired. The user specifies customizations that are associated with the access plan so that when that plan is executed, the customizations are executed as well. Exemplary customizations include specifying an initialization file specific to a query, specifying different implementation methods than those in the original access plan, prohibiting rebuilding of an access plan, and over-riding or ignoring a clause within the query that is used to generate the access plan.

Abstract translation: 查询计划修改系统和方法涉及包括用于生成访问计划的基于成本的优化器的数据库系统。 数据库系统还允许用户查看由特定SQL查询生成的访问计划，并根据需要修改访问计划。 用户指定与访问计划相关联的自定义，以便在执行该计划时，还会执行自定义。 示例性定制包括指定特定于查询的初始化文件，指定与原始访问计划中的不同的实现方法，禁止重建访问计划，以及覆盖或忽略用于生成访问计划的查询内的子句 。

公开(公告)号：US07573598B2

公开(公告)日：2009-08-11

申请号：US10050385

申请日：2002-01-16

Applicant: Brian John Cragun ,  Paul Reuben Day

Inventor： Brian John Cragun ,  Paul Reuben Day

IPC: G06K15/00 ,  G06F3/12

CPC classification number: H04N1/32133 ,  H04N1/00326 ,  H04N1/00331 ,  H04N1/00968 ,  H04N2201/3225 ,  H04N2201/3269 ,  H04N2201/3271

Abstract: A document and image management system that can manage handwritten comments and/or edits on conventional paper. The invention may be embodied as an enhanced photocopier adapted to locate and classify handwritten notations using optical character recognition techniques. This embodiment allows the user to select options to selectively copy only those pages with notations, to create an index of handwritten notations, to add side margin locator marks to the document, and to compare subsequent comments on different drafts.

Abstract translation: 可以管理传统纸上手写评论和/或编辑的文件和图像管理系统。 本发明可以被实现为适于使用光学字符识别技术定位和分类手写符号的增强型复印机。 该实施例允许用户选择选项以仅选择性地仅复制具有符号的页面，以创建手写符号索引，向文档添加边缘定位符标记，并且对不同草稿的后续评论进行比较。

公开(公告)号：US07493306B2

公开(公告)日：2009-02-17

申请号：US11132659

申请日：2005-05-19

Applicant: Paul Reuben Day ,  Brian Robert Muras

Inventor： Paul Reuben Day ,  Brian Robert Muras

IPC: G06F17/30

CPC classification number: G06F17/30522 ,  G06F17/30312 ,  Y10S707/99932 ,  Y10S707/99933

Abstract: Methods that utilize at least one prematurely terminated processing of a database query to improve the processing of the database query. The embodiments discussed track termination information associated with at least one user initiated premature termination of processing of a database query to improve the processing of the database query. Information related to the premature terminations of a database query may be utilized by a DBMS to generate and/or implement suggestions to improve the processing of the database query, resulting in improved query processing, improved performance, fewer premature terminations, and more satisfied users.

Abstract translation: 利用至少一个过早终止的数据库查询处理来改进数据库查询的处理的方法。 实施例讨论了与至少一个用户发起的数据库查询的处理提前终止相关联的跟踪终止信息，以改进数据库查询的处理。 与数据库查询的过早终止相关的信息可被DBMS用于生成和/或实施建议以改进数据库查询的处理，从而改进查询处理，改进的性能，更少的过早终止以及更满意的用户。

公开(公告)号：US07493304B2

公开(公告)日：2009-02-17

申请号：US10988354

申请日：2004-11-12

Applicant: Paul Reuben Day ,  Brian Robert Muras ,  Anne Marie Ryg

Inventor： Paul Reuben Day ,  Brian Robert Muras ,  Anne Marie Ryg

IPC: G06F7/00

CPC classification number: G06F17/30477 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99943

Abstract: In an embodiment, a problem record associated with a query is saved to a log if the query encountered a problem. The amount of data in the record is increased if an access plan associated with the query has changed within a threshold amount of time and decreased if the access plan has not changed. In various embodiments, the problem is that the query executes longer than a historical average for the query, the query executes longer than a threshold, or the query encounters a functional error. In an embodiment, a benchmark record is also saved to the log, the problem record is compared to the benchmark record, and the difference is presented. In various embodiments, an oldest record is periodically removed from the log, or an oldest record is removed from the log if the associated query has more than a threshold number of records.

Abstract translation: 在一个实施例中，如果查询遇到问题，则与查询相关联的问题记录被保存到日志。 如果与查询相关联的访问计划在阈值时间内发生更改，则记录中的数据量会增加，如果访问计划未更改则减少。 在各种实施例中，问题是查询执行时间超过查询的历史平均值，查询执行时间超过阈值，或查询遇到功能错误。 在一个实施例中，基准记录也保存到日志中，将问题记录与基准记录进行比较，并且提供差异。 在各种实施例中，如果相关联的查询具有多于阈值数量的记录，则从日志周期性地删除最早的记录，或者从日志中删除最旧的记录。

公开(公告)号：US20080281779A1

公开(公告)日：2008-11-13

申请号：US12175036

申请日：2008-07-17

Applicant: Paul Reuben Day ,  Brian Robert Muras ,  Anne Marie Ryg

Inventor： Paul Reuben Day ,  Brian Robert Muras ,  Anne Marie Ryg

IPC: G06F17/30

CPC classification number: G06F17/30471 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99934

Abstract: A query plan modification system and method relate to a database system that includes a cost-based optimizer for generating access plans. The database system also permits a user to view an access plan that has been generated by a particular SQL query and modify the access plan if desired. The user specifies customizations that are associated with the access plan so that when that plan is executed, the customizations are executed as well. Exemplary customizations include specifying an initialization file specific to a query, specifying different implementation methods than those in the original access plan, prohibiting rebuilding of an access plan, and over-riding or ignoring a clause within the query that is used to generate the access plan.

公开(公告)号：US20080215535A1

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

申请号：US12107938

申请日：2008-04-23

Applicant: Paul Reuben Day ,  Brian Robert Muras ,  Anne Marie Ryg

Inventor： Paul Reuben Day ,  Brian Robert Muras ,  Anne Marie Ryg

IPC: G06F17/30

CPC classification number: G06F17/30433 ,  G06F17/30463

Abstract: A database query optimizer allows specifying a performance specification for a query. When an access plan is created, the actual performance for executing the query using the access plan is determined and compared to the performance specification for the query. If the actual performance does not satisfy the performance specification for the query, the query optimizer autonomically generates a different access plan to see if the performance improves. If an access plan that meets the performance specification is generated, the new access plan is stored in the access plan cache for the query. If no access plan can be generated that meets the performance specification for the query, the access plan that provided the best performance is selected and stored in the access plan cache for the query.

Abstract translation: 数据库查询优化器允许为查询指定性能规范。 当创建访问计划时，确定使用访问计划执行查询的实际性能，并将其与查询的性能规范进行比较。 如果实际性能不符合查询的性能规范，则查询优化器将自动生成不同的访问计划，以查看性能是否提高。 如果生成符合性能规范的访问计划，则新访问计划将存储在查询的访问计划缓存中。 如果不能生成满足查询性能规范的访问计划，则提供最佳性能的访问计划被选择并存储在查询的访问计划缓存中。

公开(公告)号：US07296189B2

公开(公告)日：2007-11-13

申请号：US10664553

申请日：2003-09-19

Applicant: Paul Reuben Day ,  Brian Robert Muras

Inventor： Paul Reuben Day ,  Brian Robert Muras

IPC: G06F11/00

CPC classification number: G06F11/3672

Abstract: A method, apparatus and computer program product are provided for implementing autonomic testing and verification of software fix programs or program temporary fixes (PTFs). A software fix program including multiple patches or a program temporary fix (PTF) including multiple programs is received. Each patch or program of the multiple patches or multiple programs of the software fix program or PTF is sequentially applied to a software product. The software product is tested responsive to each sequentially applied patch or program. Then next iterations or different combinations of patches or programs are sequentially applied to a software product and then the software product is tested responsive to each of the applied iterations.

Abstract translation: 提供了一种方法，装置和计算机程序产品，用于实现软件修复程序或程序临时修复（PTF）的自主测试和验证。 接收包括多个补丁或包括多个程序的程序临时修复（PTF）的软件修复程序。 软件修复程序或PTF的多个修补程序或多个程序的每个修补程序或程序被顺序应用于软件产品。 对每个顺序应用的补丁或程序进行测试。 然后将补丁或程序的下一个迭代或不同的组合顺序地应用于软件产品，然后响应每个应用的迭代测试软件产品。

公开(公告)号：US07275206B1

公开(公告)日：2007-09-25

申请号：US09292444

申请日：1999-04-15

Applicant: Cary Lee Bates ,  Paul Reuben Day

Inventor： Cary Lee Bates ,  Paul Reuben Day

IPC: G06F17/00

CPC classification number: G06F17/30899 ,  G06F17/215 ,  G06F17/2235 ,  G06F2216/17

Abstract: A method, apparatus and computer program product are provided for identifying hypertext links in document printouts. A document to be printed is scanned for identifying local hypertext links within the document. A page location of each identified local hypertext links within the document is computed and stored. Printable objects are sequentially checked to identify each printable object within a hypertext anchor tag. Each identified printable object within a hypertext anchor tag is rendered with a predefined indication of the hypertext link. A local hypertext link is printed with a page number of the hypertext link within the document. An external hypertext link is printed with a uniform resource locator (URL) for the external hypertext link. Both the page number of the local hypertext link within the document and the uniform resource locator (URL) for the external hypertext link can be printed, for example, in superscript form and bolded or with other highlighting.

Abstract translation: 提供了用于识别文档打印输出中的超文本链接的方法，装置和计算机程序产品。 扫描要打印的文档以识别文档内的本地超文本链接。 计算并存储文档内每个标识的本地超文本链接的页面位置。 顺序地检查可打印对象以识别超文本锚标签内的每个可打印对象。 用超文本链接的预定义指示呈现超文本锚标签内的每个识别的可打印对象。 本地超文本链接在文档中打印超文本链接的页码。 用外部超文本链接的统一资源定位符（URL）打印外部超文本链接。 文档内的本地超文本链接的页码和外部超文本链接的统一资源定位符（URL）可以例如以上标形式和粗体或其他突出显示打印。

公开(公告)号：US07194693B2

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

申请号：US10282567

申请日：2002-10-29

Applicant: Brian John Cragun ,  Paul Reuben Day

Inventor： Brian John Cragun ,  Paul Reuben Day

IPC: G06F3/00

CPC classification number: G06F17/30716 ,  G09G5/34

Abstract: An apparatus and method helps a user to determine parts of an electronic document that are of interest by allowing the user to define preferences for processing an electronic document, and by automatically highlighting one or more portions of the document according to the user preferences. Highlighting includes any way to enhance or alter the appearance of text, including bold, italics, underlining, change in font style, change in font size, change in color, change in background color, etc. The automatic highlighting of portions of the document attract the user's eyes to that portion of the document, which helps the user to discern whether or not the highlighted portion is relevant or interesting. The preferred embodiments also include a document generator that takes an input document and generates therefrom an output document that has one or more highlighted portions that are hard-coded into the document according to the user preferences. The preferred embodiments further include the ability to automatically enable or disable the highlighting of a document according to characteristics of the electronic document, or the user's actions (such as the speed of scrolling through a document). In addition, the preferred embodiments include markup language tags that allow an author of a document to define portions of interest that may be highlighted when highlighting is enabled.

Abstract translation: 一种装置和方法帮助用户通过允许用户定义用于处理电子文档的偏好以及根据用户偏好自动突出显示文档的一个或多个部分来确定感兴趣的电子文档的部分。 突出显示包括增强或改变文字外观的任何方式，包括粗体，斜体，下划线，字体样式更改，字体大小变化，颜色变化，背景颜色变化等。文档部分的自动高亮吸引 用户对文档的该部分的看法，这有助于用户辨别突出部分是否相关或有趣。 优选实施例还包括文档生成器，其从输入文档中获取输出文档，该输出文档具有根据用户偏好将硬编码到文档中的一个或多个突出显示部分。 优选实施例还包括根据电子文档的特征或用户的动作（诸如滚动通过文档的速度）来自动启用或禁用文档的突出显示的能力。 此外，优选实施例包括标记语言标签，其允许文档的作者定义当突出显示被启用时可以突出显示的感兴趣的部分。

公开(公告)号：US07165220B1

公开(公告)日：2007-01-16

申请号：US09563271

申请日：2000-05-03

Applicant: Cary Lee Bates ,  Paul Reuben Day ,  John Matthew Santosuosso

Inventor： Cary Lee Bates ,  Paul Reuben Day ,  John Matthew Santosuosso

IPC: G06F9/00

CPC classification number: G06F17/30884

Abstract: An apparatus and method define one or more events that run a Java script when a web page is bookmarked. In the preferred embodiments, a browser determines whether a requested web page was requested from a bookmark, whether the requested page is currently bookmarked, and whether the requested page is the browser's home page. This information is sent along with the page request so the web server can take appropriate action based on this information. One or more events are defined that each run a corresponding Java script to indicate when a page was loaded from a bookmark, when a page is bookmarked, when a page is not bookmarked, and when a page is the home page of the browser. The preferred embodiments allow bookmark information to be communicated to a web server, which can then use the bookmark information in a variety of ways. One preferable way to use the bookmark information is to vary the presentation of the web page depending on whether the page is bookmarked or not.

Abstract translation: 设备和方法定义当网页被加书签时运行Java脚本的一个或多个事件。 在优选实施例中，浏览器确定是否从书签请求了所请求的网页，请求的页面当前是否被加书签，以及所请求的页面是否是浏览器的主页。 此信息与页面请求一起发送，因此Web服务器可以根据此信息采取适当的措施。 定义一个或多个事件，每个事件都运行相应的Java脚本来指示何时从书签加载页面，页面被加书签时，页面未被加入书签，以及何时页面是浏览器的主页。 优选实施例允许将书签信息传送到web服务器，该Web服务器然后可以以各种方式使用书签信息。 使用书签信息的一种优选方式是根据该页面是否被加书签来改变网页的呈现。