Hansjorg Zeller

6339772, Jan 15, 2002

Jul 6, 1999

09/347997

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

Compaq Computer Corporation - Houston TX

G06F 1730

707 4, 707 3, 707 5

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.

6438741, Aug 20, 2002

Mar 31, 1999

09/283309

Awny K. Al-omari - Santa Clara CA
Hansjorg Zeller - Los Altos CA
Diana L. Shak - San Jose CA

Compaq Computer Corporation - Cupertino CA

G06F 945

717 9, 707 2, 717 8

The present invention reduces the compile time in a top-down rule based system by identifying the complexity of a query prior to applying a rule to an expression. If the complexity of the query is above a threshold, the present invention determines whether the rule should be applied based upon several factors including the type of rule and the position of the node in the search space. Those rules that need not be applied are randomly pruned at a determined rate that prevents search space explosion and prevents the elimination of large contiguous portions of the search space. Pruned rules are not applied, while those rules that are not pruned are applied.

6604102, Aug 5, 2003

Nov 29, 2001

09/997823

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

Hewlett-Packard Development Company, LP. - Houston TX

G06F 1730

707 4, 703 3, 703 5, 703 1

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.

7680771, Mar 16, 2010

Dec 20, 2004

11/017490

Enzo Cialini - Mississauga, CA
Laura Myers Haas - San Jose CA, US
Balakrishna Raghavendra Iyer - San Jose CA, US
Allen William Luniewski - Cupertino CA, US
Jayashree Subrahmonia - San Jose CA, US
Noshir Cavas Wadia - Morgan Hill CA, US
Hansjorg Zeller - Los Altos CA, US

International Business Machines Corporation - Armonk NY

G06F 7/00
G06F 17/00
G06F 17/30

707 3, 707 10, 707100

An apparatus, system, and method are disclosed for provisioning database resource within a grid database system. The apparatus comprises an analysis module and a provision module. The analysis module analyzes a data query stream from an application to a database instance and determines that the data query stream exhibits a predetermined performance attribute. The provision module provisions a database resource in response to a determination that the data query stream exhibits the predetermined performance attribute. The provisioned database resource may be a database instance, a database server, or a cache. The provisioning of the new database resource advantageously is substantially transparent to a client on the database system.

7765531, Jul 27, 2010

Oct 6, 2004

10/960708

Gary Martin Gilbert - Arlington Heights IL, US
Hansjorg Zeller - Los Altos CA, US
Robert Matthew Wehrmeister - Austin TX, US
Thomas Canivel Reyes - Austin TX, US
Anoop Sharma - San Jose CA, US
David Wayne Birdsall - Santa Clara CA, US
Michael James Hanlon - Austin TX, US

Hewlett-Packard Development Company, L.P. - Houston TX

G06F 9/45

717141, 717143

Systems and methods to indicate whether to store a database query language module in a local directory or a global directory are disclosed. An application program can be created once, tested once, and deployed in separate environments. The database query language modules can be shared among a group of application programs running in a common environment. Separate query language modules can be maintained for each environment.

7818297, Oct 19, 2010

Mar 31, 2003

10/403500

Nitzan Peleg - Haifa, IL
Yuval Sherman - Sunnyvale CA, US
Hansjorg Zeller - Los Altos CA, US

Hewlett-Packard Development Company, L.P. - Houston TX

G06F 7/00
G06F 17/00

707625, 707624, 707610, 707609

The disclosed embodiments relate to a system for refreshing a table to produce a refreshed table. The system may include a refresh log that may contain a plurality of entries that each comprise an epoch identifier. The system may also include a refresh manager that may be adapted to perform a refresh operation on the table using entries that have corresponding epoch identifiers.

8380699, Feb 19, 2013

Sep 4, 2009

12/554254

Awny K. Al-Omari - Cedar Park TX, US
Hansjorg Zeller - Los Altos CA, US
Tom C. Reyes - Austin TX, US

Hewlett-Packard Development Company, L.P. - Houston TX

G06F 17/30

707713, 707718, 707719, 707769

There is provided a computer-implemented method of optimizing a query. An exemplary method comprises determining a maximum cardinality for an operator. The query may comprise the operator. The exemplary method also comprises determining a plurality of potential implementations for the operator. The exemplary method additionally comprises generating a query plan for the query based on the maximum cardinality and the potential implementations.

8554760, Oct 8, 2013

Oct 7, 2009

12/574911

Suresh Subbiah - Plano TX, US
Lars Fredriksen - Downers Grove IL, US
Murali Mallela Krishna - Vancouver WA, US
Hansjorg Zeller - Los Altos CA, US

Hewlett-Packard Development Company, L.P. - Houston TX

G06F 17/30

707713, 707714

There is provided a computer-implemented method of optimizing a query. An exemplary method comprises receiving a first query configured to generate a result set. The query may comprise an operation for an outer table, a first predicate, and a second predicate. The second predicate may comprise a subquery correlated to the operation. Additionally, the first predicate and the second predicate may be disjunctive. The exemplary method also comprises generating a first query tree representing the first query, and generating a second query tree representing a second query. The second query may be configured to generate the result set, and may not comprise the subquery. The exemplary method additionally comprises generating a query plan based on the second query tree.