Josephine Miukung Cheng

US Patent:

6356896, Mar 12, 2002

Filed:

Aug 16, 1999

Appl. No.:

09/375259

Inventors:

Josephine Miu Cheng - San Jose CA
Michael Leon Pauser - Morgan Hill CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 4, 345440, 345775, 345848

Abstract:

A method, apparatus, and article of manufacture for data visualization of queries over joins. One or more commands are executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. Initially, a selection of a join indicator associated with a row of a table in the relational database is received. It is determined whether to perform a table level join operation or a row level join operation. The determined join operation is performed.

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.

US Patent:

6401059, Jun 4, 2002

Filed:

May 25, 1999

Appl. No.:

09/318689

Inventors:

HongHai Shen - San Jose CA
Josephine Miu Cheng - San Jose CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 9455

US Classification:

703 27, 341176, 386 83

Abstract:

The present invention provides a method and system for controlling a device. The system includes a personal digital assistant with a computer program for receiving a program information from a source and selecting a program based upon the program information; and an emulator for sending a signal to a device based upon the selected program. The personal digital assistant receives the program information from a source and selects a program based upon the program information. In the preferred embodiment, the device includes a television and a video cassette recorder. With the method and system of the present invention, a user can place into use the program schedule information in the personal digital assistant without the need for a separate remote control. This simplifies the use of the program schedule information in the personal digital assistant.

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.

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.

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.

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.

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.