Jian Xu from 1394 Piedmont Rd, San Jose, CA 95132, age 59

Method And Apparatus For Querying Structured Documents Using A Database Extender

View page

US Patent:

6366934, Apr 2, 2002

Filed:

Jun 2, 1999

Appl. No.:

09/324827

Inventors:

Josephine M. Cheng - San Jose CA
Jian Xu - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707513, 707200, 709246

Abstract:

An extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. A method and apparatus using an extender having a âconditional selectâ functionality is further disclosed for querying structured documents. The âconditional selectâ functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. A method and apparatus using an extender having a set of user defined functions is further disclosed for creating one or more indexes for structured documents stored in the relational database system. The method uses the set of functions to create the indexes and uses already created B+ tree index structures implemented in the database system to support the indexes.

Method And Apparatus For Creating Structure Indexes For A Data Base Extender

View page

US Patent:

6421656, Jul 16, 2002

Filed:

Jun 2, 1999

Appl. No.:

09/324826

Inventors:

Josephine M. Cheng - San Jose CA
Jian Xu - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 2, 707 3, 707 4, 709236

Abstract:

A method and apparatus using an extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. The extender has âconditional selectâ functionality, âconditional selectâ functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. The extender also has a set of user defined functions for creating one or more indexes for structured documents stored in the relational database system using already created B+ tree index structures implemented in the database system to support the indexes. The method includes a tag counting system for indexing structured documents and for implementing the structure indexes within the relational database.

Method And Apparatus For Indexing Structured Documents With Rich Data Types

View page

US Patent:

6519597, Feb 11, 2003

Filed:

Jun 2, 1999

Appl. No.:

09/324499

Inventors:

Josephine M. Cheng - San Jose CA
Gene Y. C. Fuh - San Jose CA
Jian Xu - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 10, 707102, 707513

Abstract:

An extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. A method and apparatus using an extender having a âconditional selectâ functionality is further disclosed for querying structured documents. The âconditional selectâ functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. A method and apparatus using an extender having a set of user defined functions is further disclosed for creating one or more indexes for structured documents stored in the relational database system. The method uses the set of functions to create the indexes and uses already created B+ tree index structures implemented in the database system to support the indexes.

Database Extender For Storing, Querying, And Retrieving Structured Documents

View page

US Patent:

6584459, Jun 24, 2003

Filed:

Jun 2, 1999

Appl. No.:

09/325661

Inventors:

Daniel T. Chang - San Jose CA
Josephine M. Cheng - San Jose CA
Jian Xu - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 3

Abstract:

An extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. A method and apparatus using an extender having a âconditional selectâ functionality is further disclosed for querying structured documents. The âconditional selectâ functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. A method and apparatus using an extender having a set of user defined functions is further disclosed for creating one or more indexes for structured documents stored in the relational database system. The method uses the set of functions to create the indexes and uses already created B+ tree index structures implemented in the database system to support the indexes.

Generating One Or More Xml Documents From A Single Sql Query

View page

US Patent:

6636845, Oct 21, 2003

Filed:

Jan 31, 2002

Appl. No.:

10/066523

Inventors:

Hoang K. Chau - Sunnyvale CA
Isaac Kam-Chak Cheng - San Jose CA
Josephine Miu Cheng - San Jose CA
Suet Mui Chiu - San Jose CA
Michael Leon Pauser - Morgan Hill CA
Jian Xu - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 1, 707513

Abstract:

A technique is provided for generating one or more XML documents from a single SQL query. Data stored on a data storage device that is connected to a computer is transformed. A query is received that selects data stored in a relational database management system on the data storage device, wherein a data access definition defines: (1) a collection of one or more tables in the relational database management system for storing attributes from an XML document, (2) how data stored in the tables maps to the XML document, (3) a query for mapping the data stored in the tables to the XML document, and (4) a table that will contain the XML document after the XML document is generated. Then, one or more XML documents are generated from the selected data using the data access definition.

Storing Fragmented Xml Data Into A Relational Database By Decomposing Xml Documents With Application Specific Mappings

View page

US Patent:

6643633, Nov 4, 2003

Filed:

Jan 31, 2002

Appl. No.:

10/062069

Inventors:

Hoang K. Chau - Sunnyvale CA
Isaac Kam-Chak Cheng - San Jose CA
Josephine Miu Cheng - San Jose CA
Suet Mui Chiu - San Jose CA
Michael Leon Pauser - Morgan Hill CA
Jian Xu - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 1, 707513

Abstract:

A technique is provided to store fragmented XML data into a relational database by decomposing XML documents with application specific mappings. Data stored on a data store that is connected to a computer is transformed. Initially, an XML document containing XML data is received. A document access definition that identifies one or more relational tables and columns is received. The XML data is mapped from the application DTD to the relational tables and columns using the document access definition by generating a first document object model tree using the XML document, generating a second document object model tree using the document access definition, and mapping the data from the first document object model tree into columns in one or more relational rabies using the second document object model tree.

Xml Document Stored As Column Data

View page

US Patent:

6721727, Apr 13, 2004

Filed:

Nov 29, 2000

Appl. No.:

09/725363

Inventors:

Hoang K. Chau - Sunnyvale CA
Isaac Kam-Chak Cheng - San Jose CA
Josephine Miu Cheng - San Jose CA
Suet Mui Chiu - San Jose CA
Michael Leon Pauser - Morgan Hill CA
Jian Xu - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 3, 707 4

Abstract:

A technique is provided for creating metadata for fast search of XML documents stored as column data. Data is stored in a data store connected to a computer. A main table is created in a relational database management system, wherein the main table has a column for storing an extensible markup language (XML) document in a native XML format One or more side tables are created in the relational database management system, wherein each side table has one or more columns that store one or more attributes extracted from die XML document for fast searching of the XML document. Thereafter, the side tables are used to locate data in the main table.

Stable Mechanical Devices For Precision Optical Alignment And Packaging

View page

US Patent:

7073952, Jul 11, 2006

Filed:

Jun 5, 2002

Appl. No.:

10/163405

Inventors:

Frank Xi Wu - Fremont CA, US
Jian Xu - Pleasanton CA, US
Ming Li - Pleasanton CA, US
Song Peng - Pleasanton CA, US

Assignee:

Avanex Corporation - Fremont CA

International Classification:

G02B 6/26
G02B 7/00

US Classification:

385 62, 385 90, 385 28, 359896, 24828831

Abstract:

An optical alignment device holds fiber collimators in place with extremely good mechanical and environmental stability. The device includes a ball with a hole traversing the ball, an upper clamping block with a first inner concave spherical surface and a lower clamping block with a second inner concave spherical surface. The hole includes a shape that can accommodate or contact an optical component whose alignment is to be controlled. The ball, together with the enclosed optical component is firmly held between the first and second inner concave surfaces of the clamping blocks, which are tightened against the ball with screws. When firmly clamped within the concave surfaces, the ball is prevented from accidental movement but can still rotate about any axis to align the optical component. Once alignment is achieved, the optical component and the ball are secured in place by epoxy, glue, solder or other suitable adhesive.