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

1. 发明授权

US06349310B1 Database management system and method for accessing rows in a partitioned table 失效
标题翻译：用于访问分区表中行的数据库管理系统和方法
公开(公告)号：US06349310B1
公开(公告)日：2002-02-19
申请号：US09347998
申请日：1999-07-06
申请人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee
发明人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee
IPC分类号： G06F1200
CPC分类号： G06F17/30339
摘要： In a database management system, when the table to be accessed by a statement is partitioned, a respective partition scan operator is used to access rows of each respective database table partition. A fan out operator receives requests from a calling application to access rows from table, and responds by sending requests for rows to the partition scan operators. It receives rows of the table from the partition scan operators and sends the received rows of the database table to another node in the execution tree. Each of the partition scan operators responds to the requests for rows by returning to the fan out operator qualifying rows, if any, from the corresponding table partition. If the statement being executed includes an embedded delete or update operation, the qualifying rows are deleted or updated at the same time that the qualifying rows are returned to the fan out operator. Control is returned to the calling application only after all rows deleted or updated by the partition scan operators have been sent to the calling application. When the statement being executed is a streaming mode query, the fan out operator sends non-blocking requests to the partition scan operators so that when one access to one partition is blocked, rows from another partition are processed.
摘要翻译：在数据库管理系统中，当要由语句访问的表被分区时，相应的分区扫描运算符用于访问每个相应的数据库表分区的行。扇出操作员接收来自呼叫应用程序的请求以从表访问行，并通过向行扫描运算符发送行请求来进行响应。它从分区扫描运算符接收表的行，并将接收到的数据库表的行发送到执行树中的另一个节点。每个分区扫描运算符通过返回到扇出操作符来对相应表分区中的行（如果有的话）进行限定来响应行的请求。如果正在执行的语句包括嵌入式删除或更新操作，则在合格行返回到扇出操作符的同时删除或更新合格行。只有在分区扫描运算符已删除或更新的所有行已发送到调用应用程序之后，才将控制权返回给调用应用程序。当正在执行的语句是流模式查询时，扇出操作员向分区扫描运算符发送非阻塞请求，以便当阻止对一个分区的访问时，处理来自另一个分区的行。

2. 发明授权

US06453313B1 Database management system and method for dequeuing rows published to a database table 失效
标题翻译：数据库管理系统和方法，用于将列发布到数据库表的行
公开(公告)号：US06453313B1
公开(公告)日：2002-09-17
申请号：US09347996
申请日：1999-07-06
申请人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee
发明人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee
IPC分类号： G06F1730
CPC分类号： G06F17/30421 , G06F17/30516 , Y10S707/99933 , Y10S707/99952
摘要： The SQL compiler and SQL executor in a database management system are extended to execute statements for dequeuing rows from a database table and statements that both updating tuples and return those tuples to a calling application. During execution of a select statement that includes an embedded update or delete operation, a table access operator accesses a defined range of rows in a database table. The table access operator receives from a calling application a request for rows dequeued from the database table. The table access operator responds to the requests for rows by returning to the calling application qualifying rows, if any, from the database table and also by performing the embedded delete or update operation. The SQL executor returns control to the calling application only after all rows deleted or updated by the table access operator have been sent to the calling application.
摘要翻译：数据库管理系统中的SQL编译器和SQL执行程序被扩展为执行语句，用于从数据库表中将行排队，并且更新元组并将这些元组返回给调用应用程序的语句。在执行包含嵌入式更新或删除操作的select语句期间，表访问运算符访问数据库表中定义的行范围。表访问运算符从调用应用程序接收对从数据库表排队的行的请求。表访问操作符通过返回到调用应用程序来响应行的请求，从数据库表中限定行（如果有的话），还通过执行嵌入式删除或更新操作。只有在由表访问运算符删除或更新的所有行已发送到调用应用程序之后，SQL执行程序将控制权返回给调用应用程序。

3. 发明授权

US06604102B2 System and method for performing database operations on a continuous stream of tuples 有权
公开(公告)号：US06604102B2
公开(公告)日：2003-08-05
申请号：US09997823
申请日：2001-11-29
申请人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee , Hansjorg Zeller
发明人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee , Hansjorg Zeller
IPC分类号： G06F1730
CPC分类号： G06F17/30492 , G06F17/30516 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： The SQL compiler and SQL executor in a database management system are extended to process queries requiring streaming mode processing of data stored in a table. A scan operator performs table access functions during execution of the streaming mode query. The scan operator first performs an initial scan to access rows in a specified database table, and then performs a delta scan to access new rows added to the table, as well as rows modified by other queries. The scan operator continues to process new data added to the table until the initiating user or application closes the associated cursor. A set of data structures are provided to keep track of active scan operators, including a session control block that includes fields for keeping track of whether the scan operator is performing an initial scan or a delta scan. The session control block also includes, for streaming mode scan operators, a delta scan list of new and modified rows to be processed in the delta scan. When a transaction terminates, any streaming mode scan operators whose operation was suspended because of rows locked by the transaction are automatically rescheduled for execution.

4. 发明授权

US06339772B1 System and method for performing database operations on a continuous stream of tuples 有权
标题翻译：在连续的元组流中执行数据库操作的系统和方法
公开(公告)号：US06339772B1
公开(公告)日：2002-01-15
申请号：US09347997
申请日：1999-07-06
申请人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee , Hansjorg Zeller
发明人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee , Hansjorg Zeller
IPC分类号： G06F1730
CPC分类号： G06F17/30492 , G06F17/30516 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： The SQL compiler and SQL executor in a database management system are extended to process queries requiring streaming mode processing of data stored in a table. A scan operator performs table access functions during execution of the streaming mode query. The scan operator first performs an initial scan to access rows in a specified database table, and then performs a delta scan to access new rows added to the table, as well as rows modified by other queries. The scan operator continues to process new data added to the table until the initiating user or application closes the associated cursor. A set of data structures are provided to keep track of active scan operators, including a session control block that includes fields for keeping track of whether the scan operator is performing an initial scan or a delta scan. The session control block also includes, for streaming mode scan operators, a delta scan list of new and modified rows to be processed in the delta scan. When a transaction terminates, any streaming mode scan operators whose operation was suspended because of rows locked by the transaction are automatically rescheduled for execution.
摘要翻译：数据库管理系统中的SQL编译器和SQL执行器被扩展到处理需要对存储在表中的数据进行流模式处理的查询。扫描运算符在执行流模式查询期间执行表访问功能。扫描操作员首先执行初始扫描以访问指定数据库表中的行，然后执行增量扫描以访问添加到表中的新行以及其他查询修改的行。扫描运算符继续处理添加到表中的新数据，直到启动用户或应用程序关闭相关联的光标。提供了一组数据结构来跟踪主动扫描运算符，包括会话控制块，其包括用于跟踪扫描运算符是执行初始扫描还是增量扫描的字段。对于流模式扫描运算符，会话控制块还包括在delta扫描中要处理的新行和修改行的增量扫描列表。当事务终止时，由于事务锁定行被暂停运行的任何流模式扫描运算符都将自动重新计划执行。

5. 发明授权

US06397227B1 Database management system and method for updating specified tuple fields upon transaction rollback 失效
标题翻译：数据库管理系统和方法，用于在事务回滚时更新指定的元组字段
公开(公告)号：US06397227B1
公开(公告)日：2002-05-28
申请号：US09347994
申请日：1999-07-06
申请人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee , Anoop Sharma
发明人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee , Anoop Sharma
IPC分类号： G06F1730
CPC分类号： G06F17/30516 , G06F17/30348 , G06F17/30377 , G06F17/30418 , Y10S707/99938
摘要： A database management system includes an execution engine that, upon rollback of an aborted transaction, has the ability to set fields of the rows that are updated or deleted by the transaction prior to aborting. In particular, when a select, update or delete statement includes a “set on rollback” clause, the respective table access operator of the execution engine modifies the “before image” of each row that is stored by the transaction log manager. The modified before image includes the field updates specified by the set on rollback clause. If a transaction associated with the statement aborts, when the transaction log manager restores the before images of each row that was deleted or updated by the transaction, the restored before images include the field updates specified by the set on rollback clause.
摘要翻译：数据库管理系统包括一个执行引擎，在中止事务的回滚之后，能够在中止之前设置事务更新或删除的行的字段。特别地，当select，update或delete语句包括“set on rollback”子句时，执行引擎的相应表访问操作符修改由事务日志管理器存储的每一行的“before image”。修改后的图像包括由rollback子句中指定的字段更新。如果与该语句关联的事务中止，则当事务日志管理器恢复由事务删除或更新的每一行的先前图像时，恢复的映像之前包括由rollback子句设置的字段更新。

6. 发明授权

US06304873B1 System and method for performing database operations and for skipping over tuples locked in an incompatible mode 有权
标题翻译：用于执行数据库操作并跳过锁定在不兼容模式的元组的系统和方法
公开(公告)号：US06304873B1
公开(公告)日：2001-10-16
申请号：US09347995
申请日：1999-07-06
申请人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee
发明人： Johannes Klein , Robbert C. Van der Linden , Raj K. Rathee
IPC分类号： G06F1730
CPC分类号： G06F17/30421 , G06F17/30362 , G06F17/30516 , Y10S707/99938 , Y10S707/99952
摘要： A database management system is extended to process SQL statements so as to skip over rows that are locked in conflicting modes. Normally, a table access operator is blocked when it attempts to access a row that is locked in a conflicting mode, such as a write lock mode, that is inconsistent with the read or write access required by the operator. Generally, the lock in the conflicting mode will be held by a transaction other than the transaction associated with the operator in question. When the SQL statement being executed uses the “skip conflict” syntax provided by the present invention, the operator skips over rows that are locked in conflicting modes, which would otherwise cause the operator to suspend operation. Furthermore, if the operator is operating in streaming mode, a key that identifies such skipped rows is added to the operator's list of rows to be processed at a later time.
摘要翻译：扩展数据库管理系统以处理SQL语句，以便跳过在冲突模式下锁定的行。通常，表访问运算符尝试访问锁定在冲突模式（例如写锁定模式）的行时，该行与操作员所需的读取或写入访问不一致。通常，冲突模式中的锁将由与所讨论的运算符相关联的事务以外的事务来保持。当正在执行的SQL语句使用本发明提供的“跳过冲突”语法时，操作者跳过锁定在冲突模式的行，否则将导致操作者暂停操作。此外，如果操作者在流模式下操作，则识别这种跳过的行的密钥将被添加到操作者的稍后将被处理的行的列表中。

7. 发明授权

US08156082B2 System and methods for temporary data management in shared disk cluster 有权
标题翻译：共享磁盘集群中临时数据管理的系统和方法
公开(公告)号：US08156082B2
公开(公告)日：2012-04-10
申请号：US11756925
申请日：2007-06-01
申请人： Ajay Kumar Srivastava , Raj K. Rathee , Yanhong Wang
发明人： Ajay Kumar Srivastava , Raj K. Rathee , Yanhong Wang
IPC分类号： G06F17/30
CPC分类号： G06F17/30575
摘要： System and methods for temporary data management in shared disk cluster configurations is described. In one embodiment, a method for managing temporary data storage comprises: creating a global temporary database accessible to all nodes of the cluster on shared storage; creating a local temporary database accessible to only a single node (owner node) of the cluster; providing failure recovery for the global temporary database without providing failure recovery for the local temporary database, so that changes to the global temporary database are transactionally recovered upon failure of a node; binding an application or database login to the local temporary database on the owner node for providing the application with local temporary storage when connected to the owner node; and storing temporary data used by the application or database login in the local temporary database without requiring use of write ahead logging for transactional recovery of the temporary data.
摘要翻译：描述了共享磁盘集群配置中临时数据管理的系统和方法。在一个实施例中，一种用于管理临时数据存储的方法包括：创建可在所述共享存储器上的所述集群的所有节点访问的全局临时数据库; 创建仅可以访问集群的单个节点（所有者节点）的本地临时数据库; 为全局临时数据库提供故障恢复，而不会为本地临时数据库提供故障恢复，以便在节点故障时事务性地恢复对全局临时数据库的更改; 将应用程序或数据库登录绑定到所有者节点上的本地临时数据库，以在连接到所有者节点时向应用程序提供本地临时存储; 以及将应用程序或数据库登录使用的临时数据存储在本地临时数据库中，而不需要使用写入提前日志来进行临时数据的事务恢复。

8. 发明申请

US20080086480A1 System and Methods For Temporary Data Management in Shared Disk Cluster 有权
标题翻译：共享磁盘集群临时数据管理系统与方法
公开(公告)号：US20080086480A1
公开(公告)日：2008-04-10
申请号：US11756925
申请日：2007-06-01
申请人： Ajay K. Srivastava , Raj K. Rathee , Yanhong Wang
发明人： Ajay K. Srivastava , Raj K. Rathee , Yanhong Wang
IPC分类号： G06F7/00
CPC分类号： G06F17/30575
摘要： System and methods for temporary data management in shared disk cluster configurations is described. In one embodiment, a method for managing temporary data storage comprises: creating a global temporary database accessible to all nodes of the cluster on shared storage; creating a local temporary database accessible to only a single node (owner node) of the cluster; providing failure recovery for the global temporary database without providing failure recovery for the local temporary database, so that changes to the global temporary database are transactionally recovered upon failure of a node; binding an application or database login to the local temporary database on the owner node for providing the application with local temporary storage when connected to the owner node; and storing temporary data used by the application or database login in the local temporary database without requiring use of write ahead logging for transactional recovery of the temporary data.
摘要翻译：描述了共享磁盘集群配置中临时数据管理的系统和方法。在一个实施例中，一种用于管理临时数据存储的方法包括：创建可在所述共享存储器上的所述集群的所有节点访问的全局临时数据库; 创建仅可以访问集群的单个节点（所有者节点）的本地临时数据库; 为全局临时数据库提供故障恢复，而不会为本地临时数据库提供故障恢复，以便在节点故障时对全局临时数据库的更改进行事务性恢复; 将应用程序或数据库登录绑定到所有者节点上的本地临时数据库，以在连接到所有者节点时向应用程序提供本地临时存储; 以及将应用程序或数据库登录使用的临时数据存储在本地临时数据库中，而不需要使用写入提前日志来进行临时数据的事务恢复。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式