专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20130262435A1 ADAPTIVE QUERY EXECUTION PLAN ENHANCEMENT 失效
标题翻译：自适应查询执行计划增强
公开(公告)号：US20130262435A1
公开(公告)日：2013-10-03
申请号：US13431981
申请日：2012-03-28
申请人： Patrick D. BOSSMAN , Curt L. COTNER , You-Chin FUH , Adarsh S. PANNU , Kun Peng REN
发明人： Patrick D. BOSSMAN , Curt L. COTNER , You-Chin FUH , Adarsh S. PANNU , Kun Peng REN
IPC分类号： G06F17/30
CPC分类号： G06F17/30477 , G06F17/30463 , G06F17/30675 , G06F17/30935 , G06F17/30938
摘要： An adaptive query execution plan enhancement is provided by: selecting a sample of literal sets from an execution history of a query statement; determining a plurality of access paths by applying each literal set in the sample to the query statement; for each given access path of the plurality of access paths, determining a total execution cost by applying each literal set in the sample to the given access path; and selecting a preferred access path from the plurality of access paths based on the total execution costs for each given access path. A plurality of preferred access paths for a plurality of query statements in an application workload is collected and may be presented as a query execution plan enhancement recommendation to users.
摘要翻译：通过以下方式提供自适应查询执行计划增强：从查询语句的执行历史中选择文字集合的样本; 通过将样本中的每个文字集合应用于查询语句来确定多个访问路径; 对于所述多个访问路径中的每个给定访问路径，通过将所述样本中的每个文字集合应用于所述给定访问路径来确定总执行成本; 以及基于每个给定访问路径的总执行成本从多个访问路径中选择优选的访问路径。收集用于应用工作负载中的多个查询语句的多个优选访问路径，并且可以将其作为查询执行计划增强推荐呈现给用户。

2. 发明授权

US08239389B2 Persisting external index data in a database 有权
标题翻译：在数据库中保留外部索引数据
公开(公告)号：US08239389B2
公开(公告)日：2012-08-07
申请号：US12240343
申请日：2008-09-29
申请人： Margaret Zagelow , Curt L. Cotner , John A. McPherson, Jr. , Claus Kempfert
发明人： Margaret Zagelow , Curt L. Cotner , John A. McPherson, Jr. , Claus Kempfert
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30336
摘要： Systems, methods, and computer program products to persist external index data in a database are disclosed. In an embodiment, a method includes maintaining a database including a first data table that is configured to store data in a database format and a second data table that is configured to store index data. The index data represents an index of a first portion of the first data table, and the index maintained externally to the database by an index manager. The method also includes generating a data update representing a modification to the first data table and communicating the data update to the index manager. The method further includes receiving index update data from the index manager representing a modification to the index as a result of the data update and applying the index update data to the second data table.
摘要翻译：公开了在数据库中保持外部索引数据的系统，方法和计算机程序产品。在一个实施例中，一种方法包括维护包括被配置为以数据库格式存储数据的第一数据表的数据库和被配置为存储索引数据的第二数据表。索引数据表示第一数据表的第一部分的索引，并且由索引管理器在数据库外部维护的索引。该方法还包括生成表示对第一数据表的修改的数据更新，并将数据更新传送给索引管理器。该方法还包括从索引管理器接收索引更新数据，该索引更新数据作为数据更新的结果表示对索引的修改，并将索引更新数据应用于第二数据表。

3. 发明申请

US20100082630A1 PERSISTING EXTERNAL INDEX DATA IN A DATABASE 有权
标题翻译：在数据库中记录外部索引数据
公开(公告)号：US20100082630A1
公开(公告)日：2010-04-01
申请号：US12240343
申请日：2008-09-29
申请人： Margaret Zagelow , Curt L. Cotner , John A. McPherson, JR. , Claus Kempfert
发明人： Margaret Zagelow , Curt L. Cotner , John A. McPherson, JR. , Claus Kempfert
IPC分类号： G06F17/30
CPC分类号： G06F17/30336
摘要： Systems, methods, and computer program products to persist external index data in a database are disclosed. In an embodiment, a method includes maintaining a database including a first data table that is configured to store data in a database format and a second data table that is configured to store index data. The index data represents an index of a first portion of the first data table, and the index maintained externally to the database by an index manager. The method also includes generating a data update representing a modification to the first data table and communicating the data update to the index manager. The method further includes receiving index update data from the index manager representing a modification to the index as a result of the data update and applying the index update data to the second data table.
摘要翻译：公开了在数据库中保持外部索引数据的系统，方法和计算机程序产品。在一个实施例中，一种方法包括维护包括被配置为以数据库格式存储数据的第一数据表的数据库和被配置为存储索引数据的第二数据表。索引数据表示第一数据表的第一部分的索引，并且由索引管理器在数据库外部维护的索引。该方法还包括生成表示对第一数据表的修改的数据更新，并将数据更新传送给索引管理器。该方法还包括从索引管理器接收索引更新数据，该索引更新数据作为数据更新的结果表示对索引的修改，并将索引更新数据应用于第二数据表。

4. 发明授权

US07568039B2 Method for providing and utilizing a network trusted context 失效
标题翻译：提供和利用网络信任上下文的方法
公开(公告)号：US07568039B2
公开(公告)日：2009-07-28
申请号：US11023921
申请日：2004-12-27
申请人： Paul M. Bird , Gayathiri R. Chandran , Curt L. Cotner , Adrian B. Lobo , James W. Pickel , Walid Rjaibi
发明人： Paul M. Bird , Gayathiri R. Chandran , Curt L. Cotner , Adrian B. Lobo , James W. Pickel , Walid Rjaibi
IPC分类号： G06F21/00
CPC分类号： H04L63/08 , H04L63/102
摘要： A method for establishing a connection between a data server and a middleware server is disclosed. The method includes defining a plurality of trust attributes corresponding to a trusted context between the middleware server and the data server and validating the plurality of trust attributes against a plurality of attributes corresponding to the middleware server. The plurality of attributes provided in a connection request. The method also includes establishing the trusted context based on the validating the plurality of trust attributes.
摘要翻译：公开了一种在数据服务器和中间件服务器之间建立连接的方法。该方法包括定义与中间件服务器和数据服务器之间的信任上下文相对应的多个信任属性，并针对对应于中间件服务器的多个属性来验证多个信任属性。在连接请求中提供的多个属性。该方法还包括基于验证多个信任属性来建立可信赖的上下文。

5. 发明授权

US07526489B2 Methods to integrate user-defined operations into a database 失效
标题翻译：将用户定义的操作集成到数据库中的方法
公开(公告)号：US07526489B2
公开(公告)日：2009-04-28
申请号：US10717407
申请日：2003-11-18
申请人： Vander R. Alves , Curt L. Cotner , Mary A. Roth , Morgan Y. Tong , Charles Daniel Wolfson
发明人： Vander R. Alves , Curt L. Cotner , Mary A. Roth , Morgan Y. Tong , Charles Daniel Wolfson
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F9/466 , Y10S707/99933 , Y10S707/99952 , Y10S707/99953
摘要： Systems, methods, and computer products that support techniques associated with highly reliable transaction protocol semantics in databases. Such techniques extend database transaction semantics that support a single-phase or a two-phase commit protocol to include user-defined operations while supporting the XA X/Open® Distributed Transaction Processing Protocol (“XA Transaction Protocol”). The preferred embodiment of the present invention novelly enables user-defined operations that access external resources by means of the XA Transaction Protocol to be included in database transaction processing features. Thereby user-level access to well-defined APIs is provided. Further, the preferred embodiment of the present invention novelly ensures atomicity for the results of the database transaction that includes both the user-defined operations and database operations. According to the preferred embodiment of the present invention the database acts, in part, as an XA transaction manager.
摘要翻译：支持与数据库中高度可靠的事务协议语义相关联的技术的系统，方法和计算机产品。这种技术扩展了支持单阶段或两阶段提交协议的数据库事务语义，以包括用户定义的操作，同时支持XA X / Open（R）分布式事务处理协议（“XA事务处理协议”）。本发明的优选实施例新颖地使得能够通过XA事务协议访问外部资源的用户定义的操作被包括在数据库事务处理特征中。从而提供对定义良好的API的用户级访问。此外，本发明的优选实施例新颖地确保包括用户定义的操作和数据库操作的数据库事务的结果的原子性。根据本发明的优选实施例，数据库部分地作为XA事务管理器。

6. 发明申请

US20090070304A1 LOW-OVERHEAD BUILT-IN TIMESTAMP COLUMN FOR RELATIONAL DATABASE SYSTEMS 审中-公开
标题翻译：用于关系数据库系统的低成本内置TIMESTAMP列
公开(公告)号：US20090070304A1
公开(公告)日：2009-03-12
申请号：US12272718
申请日：2008-11-17
申请人： Yao-Ching Stephen CHEN , Curt L. COTNER
发明人： Yao-Ching Stephen CHEN , Curt L. COTNER
IPC分类号： G06F17/30
CPC分类号： G06F16/284 , Y10S707/99933 , Y10S707/99943
摘要： An improved automatically updated timestamp for database systems is disclosed. The automatically updated timestamp can be provided in a hidden timestamp column for a table, where the value of the timestamp column can be retrieved with a query that calls the column by name. Optionally, the timestamp column can be provided for each table in the database system to ensure its availability to applications. For cases where a timestamp for each row in a table is not desired, an automatically updated timestamp can be provided for a data page. This timestamp can be retrieved from an update timestamp recorded on disk and in the buffer pool or from a log relative byte address. Although this is a page-level timestamp, its use may be desirable for infrequently updated tables or where space on the disk and buffer pool is at a premium.
摘要翻译：公开了一种用于数据库系统的改进的自动更新时间戳。可以在表的隐藏时间戳列中提供自动更新的时间戳，其中可以使用按名称调用列的查询来检索时间戳列的值。可选地，可以为数据库系统中的每个表提供时间戳列，以确保其对应用程序的可用性。对于不需要表中每行的时间戳的情况，可以为数据页提供自动更新的时间戳。可以从记录在磁盘和缓冲池中的更新时间戳记或从日志相对字节地址检索此时间戳。虽然这是一个页面级的时间戳，但是对于不经常更新的表或者磁盘和缓冲池上的空间是非常重要的，它的使用可能是可取的。

7. 发明授权

US06959305B2 Unique identification of SQL cursor occurrences in a repetitive, nested environment 失效
标题翻译：重复嵌套环境中SQL游标出现的唯一标识
公开(公告)号：US06959305B2
公开(公告)日：2005-10-25
申请号：US10317234
申请日：2002-12-10
申请人： Paul M. Bird , Timothy J. Vincent , Curt L. Cotner
发明人： Paul M. Bird , Timothy J. Vincent , Curt L. Cotner
IPC分类号： G06F17/30
CPC分类号： G06F17/30286 , Y10S707/954 , Y10S707/99932 , Y10S707/99933 , Y10S707/99942 , Y10S707/99945
摘要： A cursor query identifier is defined to uniquely identify cursors in a relational database system that supports nested routine invocation. The identifier includes a cursor nesting level value that corresponds to the nested level at which the cursor is opened. The identifier also includes a invocation identifier that corresponds to the routine within which a cursor is opened. The third part of the identifier is a unique cursor counter. The definition of the cursor query identifier permits cursors to be opened within nested levels of the same relational database context and to be uniquely identified for reference by database system and by applications accessing the system.
摘要翻译：定义游标查询标识符以唯一标识支持嵌套例程调用的关系数据库系统中的游标。标识符包括与光标所在的嵌套级别相对应的游标嵌套级别值。标识符还包括对应于光标被打开的例程的调用标识符。标识符的第三部分是唯一的光标计数器。游标查询标识符的定义允许在相同关系数据库上下文的嵌套级别中打开游标，并且被唯一标识以供数据库系统和访问系统的应用程序引用。

8. 发明授权

US06931630B1 Method of, system for, and computer program product for providing automatic identification of a computer program code candidate for web deployment or a stored procedure 失效
标题翻译：用于提供Web部署或存储过程的计算机程序代码候选者的自动识别的方法，系统和计算机程序产品
公开(公告)号：US06931630B1
公开(公告)日：2005-08-16
申请号：US09672172
申请日：2000-09-27
申请人： Curt L. Cotner , Laurence E. England , Howard J. Glaser , Howard M. Hess
发明人： Curt L. Cotner , Laurence E. England , Howard J. Glaser , Howard M. Hess
IPC分类号： G06F9/44 , G06F9/45
CPC分类号： G06F8/70
摘要： Computer program code which is a candidate for Web enablement or stored procedures is identified. Source code corresponding to computer program code is scanned and parsed to determine static information concerning the computer program code. The static information is stored in a database. Dynamic information concerning the computer program code during an execution of the computer program code is also collected and stored in the database. Responsive to the static information and dynamic information stored in the database, relationships and dependencies are then developed and stored in the database. The database may then be queried to produce a set of potential candidates of computer program code meeting a constraint of the query. If insufficient candidates are returned by the query, then the query constraint may be relaxed, and the query repeated.
摘要翻译：识别作为Web启用或存储过程的候选者的计算机程序代码。对与计算机程序代码相对应的源代码进行扫描和解析，以确定有关计算机程序代码的静态信息。静态信息存储在数据库中。在执行计算机程序代码期间关于计算机程序代码的动态信息也被收集并存储在数据库中。响应于存储在数据库中的静态信息和动态信息，然后开发关系和依赖关系并将其存储在数据库中。然后可以查询数据库以产生满足查询约束的计算机程序代码的一组潜在候选者。如果查询返回的候选人不足，则可以放宽查询约束，重复查询。

9. 发明授权

US06424974B1 Storing P-code in a database 失效
标题翻译：将P代码存储在数据库中
公开(公告)号：US06424974B1
公开(公告)日：2002-07-23
申请号：US08928620
申请日：1997-09-12
申请人： Curt L. Cotner , Wendy Lynne Koontz , Gerald H. Roth , Frederick Thomas Sharp , Shu-Huar Joseph Yeh
发明人： Curt L. Cotner , Wendy Lynne Koontz , Gerald H. Roth , Frederick Thomas Sharp , Shu-Huar Joseph Yeh
IPC分类号： G06F1700
CPC分类号： G06F17/2229 , G06F3/0482 , G06F8/38 , G06F9/45512 , G06F9/547 , G06F11/3664 , G06F17/218 , G06F17/22 , G06F17/2247 , G06F17/2264 , G06F17/24 , G06F17/30595 , G06F17/30607 , Y10S707/99943 , Y10S707/99944
摘要： A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of portable server routines. More specifically, the present invention discloses a method for storing and retrieving server routines within the database independent of any file I/O system. Also, the present invention discloses a debugging environment that allows debugging of server routines in a multi-tier environment, wherein the source code being debugged runs on the development machine.
摘要翻译：一种用于提供支持便携式服务器例程的开发的编程开发环境的方法，装置和制品。更具体地，本发明公开了一种用于在数据库内独立于任何文件I / O系统存储和检索服务器例程的方法。此外，本发明公开了一种调试环境，允许调试多层环境中的服务器例程，其中被调试的源代码在开发机器上运行。

10. 发明授权

US5632015A Computer program product to efficiently process diverse result sets returned by a stored procedure 失效
标题翻译：用于有效处理存储过程返回的各种结果集的计算机程序产品
公开(公告)号：US5632015A
公开(公告)日：1997-05-20
申请号：US474111
申请日：1995-06-07
申请人： Melvin R. Zimowski , Curt L. Cotner , Peter K. L. Shum
发明人： Melvin R. Zimowski , Curt L. Cotner , Peter K. L. Shum
IPC分类号： G06F17/30
CPC分类号： G06F17/3041 , G06F17/30415 , Y10S707/99933 , Y10S707/99939
摘要： A system for processing diverse and non-diverse result sets is described. The system includes a client process in a client computer system that constructs a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that the client process is capable of handling. The client process execution request is transferred from the client process in the client computer system to a server process in a server computer system. The server process invokes the stored procedure identified by the client process execution request. Execution of the stored procedure results in the generation of answer set data for a plurality of diverse query result sets. Result set generators obtain answer set data for X of the query result sets, where X is defined by the constraints. The server process then generates an initial response containing, for each of the X query result sets, an amount of the obtained answer set data consistent with the constraints. The initial response is transferred from the server computer system to the client process in the client computer system. The client application is then able to access and process answer set data for the diverse result sets in any order.
摘要翻译：描述了一种用于处理多样化和非多样化结果集的系统。该系统包括在客户端计算机系统中的客户端进程，其构建客户端进程执行请求，该客户端进程执行请求标识存储过程，并且指定客户端进程能够处理的响应数据量的约束。客户端进程执行请求从客户端计算机系统中的客户端进程传输到服务器计算机系统中的服务器进程。服务器进程调用由客户端进程执行请求标识的存储过程。存储过程的执行导致生成用于多个不同查询结果集的应答集数据。结果集生成器获取查询结果集的X的答案集数据，其中X由约束定义。然后，服务器进程生成包含针对X个查询结果集中的每一个的初始响应，所获得的答案集数据与约束一致。初始响应从服务器计算机系统传输到客户端计算机系统中的客户端进程。然后，客户端应用程序可以以任何顺序访问和处理各种结果集的应答集数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式