1
Donald S Maier, Roberta S Marton, James H Troisi, Pedro Celis: Relational database system and method with high data availability during table data restructuring. Tandem Computers Incorporated, Flehr Hohbach Test Albritton & Herbert, April 29, 1997: US05625815 (212 worldwide citation)

A database computer system includes memory, residing in a plurality of interconnected computer nodes, for storing database tables. Each database table has a plurality of columns, a primary key index based on a specified subset of the columns, and an associated table schema. At least a subset of the ...


2
Goetz Graefe, Pedro Celis, Jay Vaishnav, Hansjorg Zeller: System and method for optimizing database queries. Tandem Computers, Gary S Flehr Hohbach Test Albritton & Herbert Williams Esq, October 13, 1998: US05822747 (171 worldwide citation)

A system and method for optimizing a database query is herein disclosed. The system consists of a search engine and a database implementor that determines an optimal plan for executing a SQL query. The SQL query is represented as a query tree consisting of a number of nested expressions. The search ...


3
Christopher M Farrar, Harry A Leslie, Pedro Celis, Diana L Shak, Jay H Vaishnav, Michael J Skarpelos: Database query cost model optimizer. Compaq, Fenwick & West, December 11, 2001: US06330552 (91 worldwide citation)

A method and apparatus is disclosed for accurately estimating the cost of a database query, including the total computer resources used and estimated elapsed time for the production of a first row and last row of an operator involved in the query and/or the total resources used and elapsed time for ...


4
Pedro Celis, Jay Vaishnav, Hansjorg Zeller: System and method for database query optimization. Tandem Computers, Gary S Flehr Hohbach Test Albritton & Herbert Williams, October 6, 1998: US05819255 (83 worldwide citation)

A system and method for optimizing a database query with improved performance enhancements is herein disclosed. The database query consists of one or more logical expressions. Through the repeated application of one or more rules, the logical expressions are transformed into physical expressions and ...


5
Louise M Madrid, Richard A Meier, Franco Putzolu, Sunil Sharma, Thomas J O Shea, James H Troisi, Hansjorg Zeller, Gary M Gilbert, Donald S Maier, Elizabeth G Davis, Pedro Celis: Relational database system and method with high availability compliation of SQL programs. Tandem Computers, Flehr Hohbach Test Albritton & Herbert, February 10, 1998: US05717911 (81 worldwide citation)

An SQL program executor and an SOL compiler both include options for avoiding recompilations of execution plans whenever the runtime object and the compile time object referenced by an execution plan meet predefined schema similarity criteria. Thus, recompilation is sometimes avoided even though the ...


6
Quentin J Clark, Anil K Nori, Pedro Celis, Peter M Spiro, David G Campbell: Storage platform for organizing, searching, and sharing data. Microsoft Corporation, Woodcock Washburn, March 25, 2008: US07349913 (75 worldwide citation)

Various embodiments of the present invention are directed to a storage platform comprising a database engine, a data store, an application programming interface. The data store is implemented on the database engine for storing data therein, and the data store implements a data model that supports th ...


7
Pedro Celis, Diana Shak, Jay Vaishnav, Hansjorg Zeller: System and method for optimizing database queries with improved performance enhancements. Tandem Computers, Pennie & Edmonds, February 1, 2000: US06021405 (56 worldwide citation)

A system and method for optimizing a database query with improved performance enhancements is herein disclosed. The database query consists of one or more logical expressions. Through the repeated application of one or more rules, the logical expressions are transformed into execution plans. The que ...


8
Hansjorg Zeller, Pedro Celis: Method and apparatus for a complete SQL subquery elimination process. Tandem Computers Incorporated, Graham & James, March 3, 1998: US05724570 (40 worldwide citation)

A method for subquery elimination for a relational model database based on the SQL language running a database management system (DBMS) under the TANDEM NONSTOP (tm) operating kernel. A series of seven transformation rules are applied to eliminate nested queries in the SQL language. The method and t ...


9
Anil K Nori, Sameet Agarwal, J Patrick Thompson, Pedro Celis, David G Campbell, F Soner Terek: Systems and methods for data modeling in an item-based storage platform. Microsoft Corporation, Woodcock Washburn, September 23, 2008: US07428546 (33 worldwide citation)

Various embodiments of the present invention are directed to a data store comprising Items, Elements, and Relationships. An Item is a unit of data storable in a data store and further comprises said Element and said Relationship. An Element is an instance of a type comprising one or more fields. A R ...


10
Pedro Celis: Efficient inter-task queue protocol. Compaq Information Technologies Group, Pennie & Edmonds, January 22, 2002: US06341302 (33 worldwide citation)

In a system for executing database queries, a directed graph of logically interconnected tasks represents an execution plan for executing a specified database query. A pair of queues are stored in a computer memory for each pair of interconnected tasks in the directed graph. One of the queues in eac ...