Saileshwar Krishnamurthy

6973572, Dec 6, 2005

Feb 28, 2000

09/514607

Steven K. Elliot - Sunnyvale CA, US
Saileshwar Krishnamurthy - San Jose CA, US
Bruce Gilbert Lindsay - San Jose CA, US
Rajendra Bhagwatisingh Panwar - San Jose CA, US

International Business Machines Corporation - Armonk NY

H04I009/28

713176, 707203

A method, apparatus, and article of manufacture for providing to a signature hash for checking versions of abstract data types. An identifier is constructed for the abstract data type that is substantially unique to the abstract data type, wherein the identifier comprises a concatenation of various attributes for the abstract data type. The constructed identifier is hashed to generate a signature hash value for the abstract data type, which is then stored both in the database and a class definition for the abstract data type. When the class definition is instantiated as a library function, it accesses the abstract data type from the database, and compares the signature hash value from the database and the signature hash value from the class definition in order to verify that the class definition is not outdated. The class definition is outdated when the abstract data type has been altered without the signature hash value being re-generated and re-stored in the database and the class definition.

7136872, Nov 14, 2006

Apr 16, 2002

10/123478

Saileshwar Krishnamurthy - Berkeley CA, US
Leo Lau - Richmondhill, CA

International Business Machines Corporation - Armonk NY

G06F 7/00
G06F 17/00

7071041, 707101, 707103 R, 707103 Z

Provided is a method, system, and an article of manufacture for transferring structured data between different data stores. Data stores include a type identifier with every instance of a structured data type. A typeID-typeName map within each data store includes the mapping between the type identifiers and the type names of the structured data types. The typeID-typeName map is sent as metadata while transferring data from a source database to a target database. An application replaces the type identifiers of the source database with the corresponding type identifiers of the target database.

7395258, Jul 1, 2008

Jul 30, 2004

10/902583

Mehmet Altinel - San Jose CA, US
Christof Bornhoevd - San Francisco CA, US
Chandrasekaran Mohan - San Jose CA, US
Mir Hamid Pirahesh - San Jose CA, US
Berthold Reinwald - Los Gatos CA, US
Saileshwar Krishnamurthy - Palo Alto CA, US

International Business Machines Corporation - Armonk NY

G06F 17/30

707 3

A local database cache enabling persistent, adaptive caching of either full or partial content of a remote database is provided. Content of tables comprising a local cache database is defined on per-table basis. A table is either: defined declaratively and populated in advance of query execution, or is determined dynamically and asynchronously populated on-demand during query execution. Based on a user input query originally issued against a remote DBMS and referential cache constraints between tables in a local database cache, a Janus query plan, comprising local, remote, and probe query portions is determined. A probe query portion of a Janus query plan is executed to determine whether up-to-date results can be delivered by the execution of a local query portion against a local database cache, or whether it is necessary to retrieve results from a remote database by executing a remote query portion of Janus query plan.

7945577, May 17, 2011

May 19, 2008

12/123101

Mehmet Altinel - San Jose CA, US
Chandrasekaran Mohan - San Jose CA, US
Mir Hamid Pirahesh - San Jose CA, US
Berthold Reinwald - Los Gatos CA, US
Saileshwar Krishnamurthy - Palo Alto CA, US

International Business Machines Corporation - Armonk NY

G06F 17/00

707769

A local database cache enabling persistent, adaptive caching of either full or partial content of a remote database is provided. Content of tables comprising a local cache database is defined on per-table basis. A table is either: defined declaratively and populated in advance of query execution, or is determined dynamically and asynchronously populated on-demand during query execution. Based on a user input query originally issued against a remote DBMS and referential cache constraints between tables in a local database cache, a Janus query plan, comprising local, remote, and probe query portions is determined. A probe query portion of a Janus query plan is executed to determine whether up-to-date results can be delivered by the execution of a local query portion against a local database cache, or whether it is necessary to retrieve results from a remote database by executing a remote query portion of Janus query plan.

8484243, Jul 9, 2013

May 5, 2011

13/101967

Saileshwar Krishnamurthy - Palo Alto CA, US
Michael R. Lewis - San Francisco CA, US
Wing Li - Foster City CA, US
Neil Thombre - Santa Clara CA, US
Jeffrey A. Davis - Santa Clara CA, US
Daniel Robert Farina - San Francisco CA, US

Cisco Technology, Inc. - San Jose CA

G06F 17/30

707771

In a system and method for order-independent stream query processing, one or more input streams of data are received, and the one or more input streams are analyzed to determine data which is older than an already emitted progress indicator. The data which is older than the already emitted progress indicator is partitioned into one or more partitions, and each of the one or more partitions are independently processed using out-of-order processing techniques. A query is received, rewritten and decomposed into one or more sub-queries that produce partial results for each of the one or more partitions, where each of the one or more sub-queries correspond to a partition. A view is also produced that consolidates the partial results for each partition. The partial results are consolidated at a consolidation time specified by the query to produce final results, and the final results are provided.

20090228465, Sep 10, 2009

Mar 5, 2009

12/398959

Saileshwar Krishnamurthy - Palo Alto CA, US
Neil Thombre - Santa Clara CA, US
Neil Conway - Berkeley CA, US
Wing Hang Li - San Bruno CA, US

G06F 17/30

707 4, 707 3, 707E17014, 707E17136

A streaming database management system may provide support for creating a new continuous query operator for on-the-fly addition of a new query, e.g., a new SQL query and/or new continuous query operator, into a shared continuous query plan. Alternatively, the streaming database management system may associate the new query on-the-fly with an existing continuous query operator, such as a relational operator and expression evaluator, to reuse the existing continuous query operator. In some embodiments, multiple operators are grouped for on-the-fly addition to the shared continuous query plan. Alternatively, the streaming database management system may identify a group of multiple operators in the shared continuous query plan for reuse by the new query.

20120124031, May 17, 2012

Jan 5, 2012

13/344562

Saileshwar Krishnamurthy - Palo Alto CA, US
Neil Thombre - Santa Clara CA, US
Neil Conway - Berkeley CA, US
Wing Hang Li - San Bruno CA, US
Morten Hover - Montclair NJ, US

G06F 17/30

707718

Systems, methods, and media are disclosed herein that can be embodied in a traditional Relational Database Management System (RDBMS) in order to transform it into a Streaming Relational Database Management System (SRDBMS). An SRDBMS may provide functionality such as to manage and populate streams, tables, and archived stream histories and support the evaluation of continuous queries on streams and tables. Both continuous and snapshot queries support the full spectrum of the industry standard, widely used, Structured Query Language. The present technology can support a high number of concurrent continuous queries using a scalable and efficient shared query evaluation scheme, support on-the-fly addition of continuous queries into a mechanism that implements the shared evaluation scheme, reuse RDBMS modules such as relational operators and expression evaluators, and visualize results of continuous queries in real time

20120124096, May 17, 2012

Jan 5, 2012

13/344559

Saileshwar Krishnamurthy - Palo Alto CA, US
Neil Thombre - Santa Clara CA, US
Neil Conway - Berkeley CA, US
Wing Hang Li - San Bruno CA, US
Morten Hoyer - Montclair NJ, US

G06F 17/30

707792, 707E17005

Systems, methods, and media are disclosed herein that can be embodied in a traditional Relational Database Management System (RDBMS) in order to transform it into a Streaming Relational Database Management System (SRDBMS). An SRDBMS may provide functionality such as to manage and populate streams, tables, and archived stream histories and support the evaluation of continuous queries on streams and tables. Both continuous and snapshot queries support the full spectrum of the industry standard, widely used, Structured Query Language. The present technology can support a high number of concurrent continuous queries using a scalable and efficient shared query evaluation scheme, support on-the-fly addition of continuous queries into a mechanism that implements the shared evaluation scheme, reuse RDBMS modules such as relational operators and expression evaluators, and visualize results of continuous queries in real time