Raj K Rathee

US Patent:

6339772, Jan 15, 2002

Filed:

Jul 6, 1999

Appl. No.:

09/347997

Inventors:

Johannes Klein - San Francisco CA
Robbert C. Van der Linden - Scotts Valley CA
Raj K. Rathee - Santa Clara CA
Hansjorg Zeller - Los Altos CA

Assignee:

Compaq Computer Corporation - Houston TX

International Classification:

G06F 1730

US Classification:

707 4, 707 3, 707 5

Abstract:

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.

US Patent:

6349310, Feb 19, 2002

Filed:

Jul 6, 1999

Appl. No.:

09/347998

Inventors:

Johannes Klein - San Francisco CA
Robbert C. Van der Linden - Scotts Valley CA
Raj K. Rathee - Santa Clara CA

Assignee:

Compaq Computer Corporation - Houston TX

International Classification:

G06F 1200

US Classification:

707200, 707100

Abstract:

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.

US Patent:

6397227, May 28, 2002

Filed:

Jul 6, 1999

Appl. No.:

09/347994

Inventors:

Johannes Klein - San Francisco CA
Robbert C. Van der Linden - Scotts Valley CA
Raj K. Rathee - Santa Clara CA
Anoop Sharma - San Jose CA

Assignee:

Compaq Computer Corporation - Houston TX

International Classification:

G06F 1730

US Classification:

707200, 707 8

Abstract:

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.

US Patent:

6453313, Sep 17, 2002

Filed:

Jul 6, 1999

Appl. No.:

09/347996

Inventors:

Johannes Klein - San Francisco CA
Robbert C. Van der Linden - Scotts Valley CA
Raj K. Rathee - Santa Clara CA

Assignee:

Compaq Information Technologies Group, L.P. - Houston TX

International Classification:

G06F 1730

US Classification:

707 3, 707201

Abstract:

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.

US Patent:

6604102, Aug 5, 2003

Filed:

Nov 29, 2001

Appl. No.:

09/997823

Inventors:

Johannes Klein - San Francisco CA
Robbert C. Van der Linden - Scotts Valley CA
Raj K. Rathee - Santa Clara CA
Hansjorg Zeller - Los Altos CA

Assignee:

Hewlett-Packard Development Company, LP. - Houston TX

International Classification:

G06F 1730

US Classification:

707 4, 703 3, 703 5, 703 1

Abstract:

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.

US Patent:

8156082, Apr 10, 2012

Filed:

Jun 1, 2007

Appl. No.:

11/756925

Inventors:

Ajay Kumar Srivastava - Fremont CA, US
Raj K. Rathee - San Ramon CA, US
Yanhong Wang - Dublin CA, US

Assignee:

Sybase, Inc. - Dublin CA

International Classification:

G06F 17/30

US Classification:

707674, 707609, 714 2, 714100

Abstract:

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.

US Patent:

63048736, Oct 16, 2001

Filed:

Jul 6, 1999

Appl. No.:

9/347995

Inventors:

Johannes Klein - San Francisco CA
Robbert C. Van der Linden - Scotts Valley CA
Raj K. Rathee - Santa Clara CA

Assignee:

Compaq Computer Corporation - Houston TX

International Classification:

G06F 1730

US Classification:

707 8

Abstract:

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.