International Business Machines Corporation

Amit Radheshyam Somani

Rakesh Agrawal

Eileen Tien Lin

Yang Sun

Tina Louise Mukai

Lan Huang

Yirong Xu

Ronald Jason Barber

Chandrasekaran Mohan

Bruce Gilbert Lindsay

Eugene Jon Shekita

Honesty Cheng Young

Jyh-Herng Chow

John Frederick Hornibrook

Steven John Watts

Todd L Leyba

Markos Zaharioudakis

Geoffrey Peddle

Surendra Kumar Verma

David Mark Herbert

Arthur Choi

Beate Porst

An apparatus and computer program product determine a target data type in an environment having a plurality of levels. The plurality of levels comprise a source level, zero or more intermediate levels, and a target level. The zero or more intermediate levels are between the source level and the target level. A target data type representing a transformation of a data type of an associated datum as the datum passes from the source level through the zero or more intermediate levels to the target level is generated. The target data type comprises a sequence of nested transformation functions having an innermost transformation function and an outermost transformation function.

Determining a target data type in a heterogeneous multi-level environment

A method, system, business method, and computer program product for retrieving and organizing networked data, wherein fetch rules and extraction rules enable a user to automatically collect and extract information from a remote network site. The fetch rules reproduce the interaction a client executes if interacting directly with the remote site, so a server cannot be shut out. The extraction rules allow the client, preferably via an applet, to glean relevant information from the acquired pages for presentation in a general interface. As an electronic commerce business method, information about remote site responsiveness, fetch rules, and extraction rules may be shared between server and client for a fee. The server accumulates vendor contacts, stores query rules, and provides common interface rules. The invention can gather statistics on vendor responsiveness and can resell information to vendors or others.

System and method for distributed querying and presentation of information from heterogeneous data sources

A method of determining a target data type in an environment having a plurality of levels is provided. Zero or more intermediate levels are between the source level and the target level. A target data type representing the transformation of a data type of an associated datum as the datum passes from the source level through the zero or more intermediate levels to the target level is generated. In another aspect of the invention, the datum is assigned to the target level in accordance with the target data type. In yet another aspect of the invention, the target data type is passed with the associated datum, via the zero or more intermediate levels to the target level.

Technique for determining a target data type in a heterogeneous multi-level environment

A database including vertical tables useful for storing large numbers of objects having potentially thousands of attributes in, e.g., e-commerce applications. To support querying the vertical database using conventional SQL, a horizontal view over the underlying vertical tables is defined, and then queries are posed against the view. The queries are automatically transformed and executed against the vertical tables. If desired, the query results can be transformed back to a horizontal format. In this way, it appears to the user that a conventional horizontal data format is being used.

System and method for generating horizontal view for SQL queries to vertical database

Method, system, and program product for searching unstructured data. The unstructured data, as text data or image data, is searched by first searching the unstructured data through an extended search broker. The extended search broker has intermediary components between a search requestor and a search agent for unstructured data searching. The search agent returns the search results to the broker for aggregation. The broker aggregates the search results and returns the search results to a wrapper. The wrapper then takes result attributes from the aggregated search results and makes the attributes available, e.g., as one or more columns in a nickname table. This nickname table is searchable by a relational database using a structured query language.

Real-time aggregation of unstructured data into structured data for SQL processing by a relational database engine

In a multiprocessing system, multiple concurrently operating task execution units are operated to perform an aggregate task by using incremental and on-demand sub-task allocation. A command is received to perform a machine-executed task divisible into multiple sub-tasks, i.e., an &ldquo;aggregate task&rdquo;. A granularity is then established, for dividing the aggregate task into sub-tasks. Preferably, the granularity is not too large to permit potentially uneven sub-task allocation, and not too small to incur excessive overhead in allocating sub-tasks. Having established the granularity, multiple task execution units are independently operated on-demand to sequentially self-allocate and execute sub-tasks of the aggregate tasks. Each sub-task is sized according to the established granularity. Operating &ldquo;on-demand&rdquo;, each task execution unit sequentially allocates and executes one sub-task at a time, then proceeding to the next unexecuted sub-task. Thus, the multiprocessing system operates like multiple people drinking water from a common glass through individual straws&mdash;although each drinker works independently, all finish simultaneously, thus completing the aggregate task as expeditiously as possible.

Aggregate job performance in a multiprocessing system by incremental and on-demand task allocation among multiple concurrently operating threads

A method, apparatus, and article of manufacture for providing transaction control for a computer-implemented database management system. The database management system manages one or more databases, wherein each of the databases contains one or more documents and each document contains one or more objects. The database management system also supports a file cache for those databases. A transaction control system provides transaction control for the databases, documents, and objects managed by the database management system, wherein the transaction control system monitors and controls the file cache to ensure that modified objects are stored on a data storage device in manner that reflects an accurate status for a log file maintained by the transaction control system.

Data recovery in a transactional database using write-ahead logging and file caching

Growing community of inventors

San Jose, CA, United States of America

Amit Radheshyam Somani