International Business Machines Corporation

Josephine Miu Cheng

Jyh-Herng Chow

Jian J Xu

HongHai Shen

Michael Leon Pauser

Isaac Kam-Chak Cheng

Suet Mui Chiu

Hoang K Chau

Mir Hamid Pirahesh

Chandrasekaran Mohan

Yun Yu Wang

I-Shin Andy Wang

Thanh Tan Pham

Balakrishna Raghavendra Iyer

Ting Yu Leung

Donald J Haderle

Daniel T Chang

Jay A Yothers

Akira Shibamiya

Steven John Watts

Gene Y C Fuh

Chi-Pei Michael Hsing

Frank Meng

Richard W Hedges

Shu-jen Wang

Nicholas V Nomm

A system and method for interfacing a portable electronic device, having a plurality of commands including a plurality of resource commands and a plurality of local commands, with a remote resource over a costed communications channel includes processing the plurality of commands on the device without communicating any of the resource commands over the channel to the remote resource while aggregating the resource commands to produce a set of resource commands; communicating the set of resource commands to the remote resource over the channel to produce a resource output responsive to the set of resource commands; communicating the resource output to the device from the remote resource; and processing the resource output on the device using the set of local commands.

Remote user substitution at ODBC/CLI level and stored procedure authorization

A technique is provided for generating one or more XML documents from a relational database using the XPath data model. Data stored on a data storage device that is connected to a computer is transformed. Initially, a document object model tee is generated using a document access definition, which defines the mapping between an XML tree structure and relational tables. The document object model tree is traversed to obtain information to retrieve relational data. The relational data is mapped to one or more XML documents.

Generating one or more XML documents from a relational database using XPath data model

A method, apparatus, and article of manufacture for a computer implemented modification system for supporting localized data changes in a computer. A change is executed to data in a computer having a local database. The change is performed by the computer to modify data in the local database stored within a data storage device at the computer. The change is indicated as being global. When the local database on the computer is synchronized with a main database on another computer, only global changes are transmitted from the local database to the main database.

Modification system for supporting localized data changes in a mobile device

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.

XML document stored as column data

The present invention discloses a method, apparatus, and article of manufacture for generating a database application. In accordance with the present invention, a features list is built for the database application. The features list contains user-selected functions. The database application is dynamically configured based on the built features list.

Generating small footprint applications for mobile devices

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.

Storing fragmented XML data into a relational database by decomposing XML documents with application specific mappings

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.

Generating one or more XML documents from a single SQL query

Database extender for storing, querying, and retrieving structured documents

Method and apparatus for indexing structured documents with rich data types

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 &ldquo;conditional select&rdquo; functionality, &ldquo;conditional select&rdquo; 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&plus; 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 creating structure indexes for a data base extender

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.

Method and system for using a personal digital assistant as a remote control

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 &ldquo;conditional select&rdquo; functionality is further disclosed for querying structured documents. The &ldquo;conditional select&rdquo; 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&plus; tree index structures implemented in the database system to support the indexes. A method and apparatus using an extender is further disclosed for creating and supporting structure 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 querying structured documents using a database extender

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.

Data visualization of queries over joins

A method, apparatus, and article of manufacture for a computer-implemented live connection manager. A statement is executed in a computer to retrieve data from a database stored on a data storage device connected to the computer. In particular, a first statement is received from another computer via an internet network. The first statement is prepared to create an executable structure for executing the first statement. A second statement is received from another computer via an internet network. Then, when the received second statement or portion thereof is the same as the first statement or portion thereof, processing the second statement or portion thereof by executing the executable structure created for the first statement or portion thereof.

Multi-level live connection for fast dynamic access to business

Method for specifying SQL 'full outer joins' which enables the use of arbitrary join conditions in specifying the query. This is enabled by equating a full outer join with a left outer join unioned with a right outer join less the matched tuples from the right outer join. A number of embodiments further present improvements in execution speed. One such improvement utilizes as a second operand of the union query a novel operator, the 'ANTI-JOIN'. The anti-join is implemented as a right outer join coupled with an ISNULL predicate.

Growing community of inventors

San Jose, CA, United States of America

Josephine Miu Cheng