Jignesh I Patel

US Patent:

6507834, Jan 14, 2003

Filed:

Dec 22, 1999

Appl. No.:

09/470927

Inventors:

Navin Kabra - Madison WI
Jignesh M. Patel - Ann Arbor MI
Jie-Bing Yu - Carlsbad CA
Biswadeep Nag - Fremont CA
Jian-Jun Chen - Madison WI

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

707 2, 703 3, 703 4, 703102, 7031041

Abstract:

A method, apparatus, and an article of manufacture for parallel execution of SQL operations from stored procedures. One or more embodiments of the invention provide the stored procedure (stored procedure) with a C++ class (hereinafter referred to as âdispatcherâ) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling stored procedure. To provide the single stream to the calling stored procedure, one or more embodiments of the invention utilize a class that provides the stored procedure with a simple and easy-to-use interface to access the results of the nested SQL execution.

US Patent:

6594651, Jul 15, 2003

Filed:

Dec 22, 1999

Appl. No.:

09/470215

Inventors:

Navin Kabra - Madison WI
Jignesh M. Patel - Ann Arbor MI
Jie-Bing Yu - Carlsbad CA
Biswadeep Nag - Fremont CA
Jian-Jun Chen - Madison WI

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

707 2, 707 3

Abstract:

A method, apparatus, and an article of manufacture for parallel execution of SQL operations from within user defined functions. One or more embodiments of the invention provide the user defined function (UDF) with a C++ class (hereinafter referred to as âdispatcherâ) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling UDF. To provide the single stream to the calling UDF, one or more embodiments of the invention utilize a class that provides the UDF with a simple and easy-to-use interface to access the results of the nested SQL execution.

US Patent:

6601064, Jul 29, 2003

Filed:

Nov 24, 1999

Appl. No.:

09/449704

Inventors:

Biswadeep Nag - Fremont CA
Jie-Bing Yu - Carlsbad CA
Jignesh M. Patel - Ann Arbor MI
Zhe Wang - Santa Clara CA

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

707 4, 707 2

Abstract:

A method, apparatus, article of manufacture, and a memory structure for providing access to an array-based data object to a client is disclosed. The method comprises the steps of receiving a database query from a client; generating a first execution plan from the database query; transmitting at least a portion of the first execution plan to a data server; compiling a query result from the execution of the first execution plan; and transmitting the query result to the client on a first communication path wherein the query result comprises an identification for a master data object responsive to the database query and the master data object comprises an identification for a plurality of array-based objects associated with the master data object. Further, the method comprises the establishment of a second communication path between the data server and the client and the transmission of the master data object to the client via this second communication path. This is followed by a third request by the client for the required array-based objects.

US Patent:

6678686, Jan 13, 2004

Filed:

Dec 28, 1999

Appl. No.:

09/474040

Inventors:

Jignesh M. Patel - Ann Arbor MI
Navin Kabra - Madison WI

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 700

US Classification:

707100, 715513

Abstract:

A method, apparatus, article of manufacture, and a memory structure for providing access to abstract data types using an index providing a tuple. The method comprises the steps of accepting a database query; generating an index predicate from the database query; and determining a tuple from an index using the index predicate. The tuple is associated with an abstract or complex data type responsive to the database query. A data stream is initialized with the index predicate; and the tuple is returned in the data stream. The apparatus comprises means for performing the above method steps, and the article of manufacture comprises a medium tangibly embodying computer instructions for performing these method steps.

US Patent:

6728694, Apr 27, 2004

Filed:

Apr 17, 2000

Appl. No.:

09/550707

Inventors:

Karthikeyan Ramasamy - Madison WI
Jignesh M. Patel - Ann Arbor MI
Jeffrey F. Naughton - Madison WI

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

707 2, 707 1, 707102

Abstract:

A novel partition-based set containment join algorithm, known as Set Partitioning Algorithm (SPA), is performed by a relational database management system to aggressively partition set-valued attributes into a very large number of partitions, in order to minimize the impact of excessive replication and improve performance.

US Patent:

6732084, May 4, 2004

Filed:

Dec 22, 1999

Appl. No.:

09/470227

Inventors:

Navin Kabra - Madison WI
Jignesh M. Patel - Ann Arbor MI
Jie-Bing Yu - Carlsbad CA
Biswadeep Nag - Fremont CA
Jian-Jun Chen - Madison WI

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 1730

US Classification:

707 2, 707 3

Abstract:

A method and apparatus for parallel execution of trigger actions. One or more embodiments of the invention comprise providing a C++ class (hereinafter referred to as âdispatcherâ) that can take an SQL query or trigger action and start parallel execution of the trigger action. The trigger action is optimized and parallelized. The dispatcher executes the trigger action, sets up the communication links between the various operators in the trigger action, and ensures that all the results are sent back to the trigger.

US Patent:

8155880, Apr 10, 2012

Filed:

May 9, 2008

Appl. No.:

12/151799

Inventors:

Jignesh M Patel - Ann Arbor MI, US
Yun Chen - San Jose CA, US
Karthikeyan Ramasamy - Santa Clara CA, US

Assignee:

Locomatix Inc. - Santa Clara CA

International Classification:

G01C 21/00

US Classification:

701400, 4554563

Abstract:

A computer-implemented method includes probing a first band along a centerline dimension for a distribution of Location Based Notifications (LBNs), the distribution including a majority of LBNs clustered along and overlapping with the centerline.

US Patent:

8447320, May 21, 2013

Filed:

May 9, 2008

Appl. No.:

12/151800

Inventors:

Jignesh M Patel - Ann Arbor MI, US
Yun Chen - San Jose CA, US
Karthikeyan Ramasamy - Santa Clara CA, US

Assignee:

Locomatix - Santa Clara CA

International Classification:

G06F 17/30

US Classification:

4554561, 4554565

Abstract:

A computer-implemented location tracking system includes an index comprising separate organizations of a) entity information and location based notifications for the entities, and b) independent location based notifications, and the index further comprising a spatial organization of references to the entity information, location based notifications for the entities, and independent location based notifications.