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

21. 发明授权

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.
摘要翻译：公开了在数据库中保持外部索引数据的系统，方法和计算机程序产品。在一个实施例中，一种方法包括维护包括被配置为以数据库格式存储数据的第一数据表的数据库和被配置为存储索引数据的第二数据表。索引数据表示第一数据表的第一部分的索引，并且由索引管理器在数据库外部维护的索引。该方法还包括生成表示对第一数据表的修改的数据更新，并将数据更新传送给索引管理器。该方法还包括从索引管理器接收索引更新数据，该索引更新数据作为数据更新的结果表示对索引的修改，并将索引更新数据应用于第二数据表。

22. 发明申请

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.
摘要翻译：公开了在数据库中保持外部索引数据的系统，方法和计算机程序产品。在一个实施例中，一种方法包括维护包括被配置为以数据库格式存储数据的第一数据表的数据库和被配置为存储索引数据的第二数据表。索引数据表示第一数据表的第一部分的索引，并且由索引管理器在数据库外部维护的索引。该方法还包括生成表示对第一数据表的修改的数据更新，并将数据更新传送给索引管理器。该方法还包括从索引管理器接收索引更新数据，该索引更新数据作为数据更新的结果表示对索引的修改，并将索引更新数据应用于第二数据表。

23. 发明授权

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事务管理器。

24. 发明授权

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启用或存储过程的候选者的计算机程序代码。对与计算机程序代码相对应的源代码进行扫描和解析，以确定有关计算机程序代码的静态信息。静态信息存储在数据库中。在执行计算机程序代码期间关于计算机程序代码的动态信息也被收集并存储在数据库中。响应于存储在数据库中的静态信息和动态信息，然后开发关系和依赖关系并将其存储在数据库中。然后可以查询数据库以产生满足查询约束的计算机程序代码的一组潜在候选者。如果查询返回的候选人不足，则可以放宽查询约束，重复查询。

25. 发明授权

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系统存储和检索服务器例程的方法。此外，本发明公开了一种调试环境，允许调试多层环境中的服务器例程，其中被调试的源代码在开发机器上运行。

26. 发明授权

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个查询结果集中的每一个的初始响应，所获得的答案集数据与约束一致。初始响应从服务器计算机系统传输到客户端计算机系统中的客户端进程。然后，客户端应用程序可以以任何顺序访问和处理各种结果集的应答集数据。

27. 发明授权

US08645356B2 Adaptive query execution plan enhancement 失效
标题翻译：自适应查询执行计划增强
公开(公告)号：US08645356B2
公开(公告)日：2014-02-04
申请号：US13431981
申请日：2012-03-28
申请人： Patrick D Bossman , Curt L. Cotner , You-Chin Fuh , Adarsh R. Pannu , Kun Peng Ren
发明人： Patrick D Bossman , Curt L. Cotner , You-Chin Fuh , Adarsh R. Pannu , Kun Peng Ren
IPC分类号： G06F7/00 , 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.
摘要翻译：通过以下方式提供自适应查询执行计划增强：从查询语句的执行历史中选择文字集合的样本; 通过将样本中的每个文字集合应用于查询语句来确定多个访问路径; 对于所述多个访问路径中的每个给定访问路径，通过将所述样本中的每个文字集合应用于所述给定访问路径来确定总执行成本; 以及基于每个给定访问路径的总执行成本从多个访问路径中选择优选的访问路径。收集用于应用工作负载中的多个查询语句的多个优选访问路径，并且可以将其作为查询执行计划增强推荐呈现给用户。

28. 发明申请

US20130325826A1 MATCHING TRANSACTIONS IN MULTI-LEVEL RECORDS 失效
公开(公告)号：US20130325826A1
公开(公告)日：2013-12-05
申请号：US13483778
申请日：2012-05-30
申请人： Manoj K. Agarwal , Curt L. Cotner , Amitava Kundu , Prasan Roy , Rajesh Sambandhan
发明人： Manoj K. Agarwal , Curt L. Cotner , Amitava Kundu , Prasan Roy , Rajesh Sambandhan
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , G06F17/30008 , G06F17/303
摘要： A method for identifying matching transactions between two log files where each transaction includes one or more statements. Each log file record records the execution of a statement and includes a transaction identifier. Each record in turn in one log file is compared to an advancing window of records in the other log file. A first table contains associations of statements to transactions and transactions to statements for records in the window. If a match is found between a record in the one file and a record in the window, information associating partial transactions in the one file to potential transactions of the records in the window is added to a second table. If an end-of-transaction record is read from the one file, a best match is found between the ended transaction and the potential transactions based on information in the first and second tables.

29. 发明申请

US20110276584A1 MULTI-TENANCY IN DATABASE NAMESPACE 有权
标题翻译：数据库中的多元数据
公开(公告)号：US20110276584A1
公开(公告)日：2011-11-10
申请号：US12777011
申请日：2010-05-10
申请人： Curt L. Cotner , Namik Hrle
发明人： Curt L. Cotner , Namik Hrle
IPC分类号： G06F17/30
CPC分类号： G06F17/30008 , G06F17/30566
摘要： Database systems are presented including: a database; a database instance of the database, where the database instance includes a set of instance database objects, and where the database instance is accessible by an instance user; and a database tenant associated with the database instance, where the database tenant includes a set of tenant database objects, where the database tenant provides access to the database instance by the tenant user, such that the instance user and the tenant user may independently access the database instance without affecting one another where each of the instance user and the tenant user are configured with independent accessibility. In some embodiments, systems further include: an instance production table associated with the database instance and a tenant production table associated with the database instance.
摘要翻译：提供数据库系统，包括：数据库; 数据库的数据库实例，数据库实例包含一组实例数据库对象，数据库实例可由实例用户访问; 以及与数据库实例相关联的数据库租户，其中数据库租户包括一组租户数据库对象，其中数据库租户提供租户用户对数据库实例的访问，使得该实例用户和租户用户可以独立地访问数据库实例，而不影响其中每个实例用户和租户用户都具有独立的可访问性。在一些实施例中，系统还包括：与数据库实例相关联的实例生产表和与数据库实例相关联的租户生产表。

30. 发明授权

US07716213B2 Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements 有权
标题翻译：用于有效支持通用SQL数据操作语句的设备，系统和方法
公开(公告)号：US07716213B2
公开(公告)日：2010-05-11
申请号：US11740457
申请日：2007-04-26
申请人： Curt L. Cotner , Christopher M. Farrar , Robert T. Miller , Maryela E. Weihrauch
发明人： Curt L. Cotner , Christopher M. Farrar , Robert T. Miller , Maryela E. Weihrauch
IPC分类号： G06F7/00
CPC分类号： G06F17/30463 , G06F17/30306
摘要： An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an authorization check for an operation for an SQL statement using extended indicators, and bypassing an SQL exception where an otherwise unauthorized operation involves an UNASSIGNED variable. The method further includes bypassing a database operation such as a referential integrity check where a data change would induce the database operation, but the data change involves an UNASSIGNED variable. The method further includes modifying the SQL statement when the SQL statement involves an UNASSIGNED variable in a predicate clause, allowing the SQL statement to properly execute.
摘要翻译：公开了用于有效支持通用SQL数据操作语句的装置，系统和方法。该方法包括确定SQL语句是否包含扩展指示符参数，如DEFAULT和UNASSIGNED指示符。该方法还包括使用扩展指示器延迟对SQL语句的操作的授权检查，以及绕过除非未经授权的操作涉及UNASSIGNED变量的SQL异常。该方法还包括绕过诸如引用完整性检查的数据库操作，其中数据改变将引起数据库操作，但数据更改涉及UNASSIGNED变量。该方法还包括在SQL语句涉及到谓词子句中的UNASSIGNED变量时修改SQL语句，从而允许SQL语句正确执行。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式