Tian G Zhang

6526403, Feb 25, 2003

Dec 17, 1999

09/466492

Eileen Tien Lin - San Jose CA
Tina Louise Mukai - San Jose CA
Shivakumar Venkataraman - Sunnyvale CA
Tian Zhang - San Jose CA

International Business Machines Corporation - Armonk NY

G06F 1730

707 4, 707200

A method, computer product, and system for rewriting database without decreasing pushdownability is provided. First, a pushdown analysis of the query in its entirety is performed prior to the application of any query rewrite rules in order to establish a baseline on pushdownability for the query. The results of this analysis is stored with the internal query representation. After each rule is applied to rewrite a portion of a query, that rewritten portion is analyzed again for pushdownability. If pushdownability is not decreased, then the rewritten query remains and the internal representation of the query is updated to reflect the pushdownability of that portion. If pushdownability is decreased, then an undo operation is applied to the rewritten portion of the query to back out the effects of the rule and leave the query in the same state as before the rewrite. Finally, additional rewrite rules that are directed to the heterogeneous database environment are also provided.

6615203, Sep 2, 2003

Dec 17, 1999

09/466560

Eileen Tien Lin - San Jose CA
Tina Louise Mukai - San Jose CA
Shivakumar Venkataraman - Sunnyvale CA
Tian Zhang - San Jose CA

International Business Machines Corporation - Armonk NY

G06F 1730

707 3

A method, computer product, and system for pushdown analysis during query plan generation is provided. Rather than do pushdown analysis for portions of a query that are query execution plan independent, the present invention provides pushdown analysis for features of a query that are plan dependent. This is done by evaluating a portion of the query plan for pushdownability to a remote database system; and if pushdownable to the remote database system, generating cost parameters for the portion of the plan if executed at a local database system and if executed at the remote database system. With both sets of cost parameters, the query optimizer has added information on which to select an optimal query plan.

7900046, Mar 1, 2011

Jan 11, 2006

11/331334

Priya Baliga - San Jose CA, US
Randy M. Nakagawa - San Jose CA, US
Tian Zhang - San Jose CA, US

International Business Machines Corporation - Armonk NY

H04L 9/00
G06F 7/04

713169, 713155, 713156, 713157, 713158, 713159, 726 3, 726 4, 726 5, 726 6, 726 7

A system, method, and computer program product for establishing mutual trust on a per-deployment basis between two software modules. For example, the first software module may be a Websphere (WS) Information Integrator (II) deployment instance, and the second software module may be a plugin instance. By executing for this deployment an initial handshake between the software modules, both modules identify themselves and exchange digital certificates received from a trusted certification authority and respective public keys. Subsequent communications for this deployment between the software modules proceed with each module encrypting its communications with the public key of the other module; thereby establishing mutual trust between the software modules for each deployment.

8171014, May 1, 2012

Aug 29, 2007

11/847269

David W. Adler - Mount Tremper NY, US
Fain Butt - Milpitas CA, US
Alvin K. Cho - San Jose CA, US
Tian Zhang - San Jose CA, US

International Business Machines Corporation - Armonk NY

G06F 7/00

707713

A method for executing a distributed spatial data query. The present invention allows a client to perform spatial queries against spatial data stored in a various formats in various separate databases. A view of the data is created in the relevant databases, wherein the spatial data is converted to WKB and stored as a BLOB. A federated server contains nicknames for the various database views, and also contains views of the data where the BLOB is converted back to a spatial data type. The federated server presents to clients an application view of the distributed heterogeneous spatial data such that the clients can treat the data as if it were a homogenous data source. Also taught is incorporating distributed non-spatial data into the application view by creating a nickname and a view on top of the nickname which derives spatial information from the non-spatial location information.

8239368, Aug 7, 2012

Aug 29, 2007

11/847272

David W. Adler - Mount Tremper NY, US
Fain Butt - Milpitas CA, US
Alvin K. Cho - San Jose CA, US
Tian Zhang - San Jose CA, US

International Business Machines Corporation - Armonk NY

G06F 7/00

707713

An apparatus, system, and method for executing a distributed spatial data query. The present invention allows a client to perform spatial queries against spatial data stored in a various formats in various separate databases. A view of the data is created in the relevant databases, wherein the spatial data is converted to WKB and stored as a BLOB. A federated server contains nicknames for the various database views, and also contains views of the data where the BLOB is converted back to a spatial data type. The federated server presents to clients an application view of the distributed heterogeneous spatial data such that the clients can treat the data as if it were a homogenous data source. Also taught is incorporating distributed non-spatial data into the application view by creating a nickname and a view on top of the nickname which derives spatial information from the non-spatial location information.

20110208719, Aug 25, 2011

Feb 19, 2010

12/709207

Mayank Pradhan - San Jose CA, US
Radhika Reddy - San Francisco CA, US
Normen Seemann - San Jose CA, US
Edison L Ting - San Jose CA, US
Tuong Truong - San Jose CA, US
Tian Zhang - San Jose CA, US

INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY

G06F 17/30
G06F 7/00

707714, 707803, 707E17044, 707E17131

Embodiments are included for methods, systems, and computer program products for evaluating operations in a shared nothing parallelism system using an electronic computing device are presented, the methods and computer program products including: causing the electronic computing device to receive the operation, where the operation is non-collocated, reference based operation, and where the operation is configured for execution on a first partition in the shared nothing parallelism system; causing the electronic computing device to insert a table queue operator on a second partition, where the second partition includes a reference to input data, causing the electronic computing device to place the reference to the input data on the first partition by the table queue operator; and causing the electronic computing device to execute the operation on the reference to the input data on the first partition.

20150254239, Sep 10, 2015

Mar 2, 2015

14/635555

- Armonk NY, US
Shivakumar Vaithyanathan - San Jose CA, US
Haojun Wang - San Jose CA, US
Tian Zhang - San Jose CA, US

G06F 17/30
G06F 3/0484

According to one embodiment of the present invention, a computer-implemented method of performing analytics on a large quantity of data accommodated by an external mass storage device is provided. The analytics may be divided into a set of modules, wherein each module is selectively executed and comprises a script for a parallel processing engine to perform a corresponding atomic operation on the analytics. A user selection is received of one or more modules to perform desired analytics on the large quantity of data from the external mass storage device, and the selected modules execute scripts for the parallel processing engine to perform the corresponding atomic operations of the desired analytics.

20150254322, Sep 10, 2015

Mar 5, 2014

14/197890

- Armonk NY, US
Shivakumar Vaithyanathan - San Jose CA, US
Haojun Wang - San Jose CA, US
Tian Zhang - San Jose CA, US

International Business Machines Corporation - Armonk NY

G06F 17/30

According to one embodiment of the present invention, a computer-implemented method of performing analytics on a large quantity of data accommodated by an external mass storage device is provided. The analytics may be divided into a set of modules, wherein each module is selectively executed and comprises a script for a parallel processing engine to perform a corresponding atomic operation on the analytics. A user selection is received of one or more modules to perform desired analytics on the large quantity of data from the external mass storage device, and the selected modules execute scripts for the parallel processing engine to perform the corresponding atomic operations of the desired analytics.