International Business Machines Corporation

James C Kleewein

Eileen Tien Lin

Yun Yu Wang

Edison Lao Ting

Tina Louise Mukai

Shivakumar Venkataraman

Steven John Watts

Hemant Maheshwari

Jeffrey Mark Nick

Mir Hamid Pirahesh

David Harold Surman

Charles Daniel Wolfson

Michael D Swanson

Ting Yu Leung

Berthold Reinwald

Roberta Jo Cochrane

Michael J Dockter

Joel Frank Farber

Peter Martin Schwarz

Kelly B Pushong

Larry Justin Brown

Kevin D Seppi

Ruth A Allen

Jaime F Anaya

Ronald Elliott Parrish

Lisa M Goetze

Sam Sampson Lightstone

James Alan Ruddy

John A McPherson, Jr

Elizabeth Belva Hamel

Tu-An Cheng

Narayana Iyer Subramanian

Rong Qu

David W Tolleson

Tony Kuen Lee

Mark Donald Leitch

Roger L Brockmeyer

Michael T Ho

Shivkumar Venkataraman

Jeffrey D Gordon

Roger L Brookmeyer

Narayana Subramanina

John Ai Mcpherson

An external service at a service provider server is invoked from a database by accessing from over a network a description of the external service published by the service provider external to the database. A database invocation mechanism is generated from the accessed description of the external service, wherein the database invocation mechanism comprises code within the database. A database program invokes the database invocation mechanism code within the database to invoke and interact with the external service. The database receives data from the external service in response to invoking and interacting with the external service.

Automatic generation of database invocation mechanism for external web services

The present invention provides a method, system and program product for integrating a service external to a database into a database such that the service may be easily invoked from the database. Preferably, the service is a web service available over the internet The service may be invoked from any of a number of invoking mechanisms of the database. In a first specific embodiment, the mechanism comprises a user-defined function within an SQL statement. In a second specific embodiment, the mechanism comprises a virtual table. In a third specific embodiment, the mechanism comprises a stored procedure. In a fourth specific embodiment, the mechanism comprises a trigger. In a fifth specific embodiment, the mechanism comprises a federated table accessed via a nickname and implemented using a wrapper.

Invocation of web services from a database

A method (and an article of manufacture having computer readable program code to implement the method) is disclosed to version a node range and locate a versioned node range in a storage architecture, wherein the method comprises: maintaining a set of node ranges, with each node range being formed from a range of node ID values assigned to each node among a plurality of nodes, receiving a node modification request for a node range from a database system, versioning the node range by copying (to a storage) a node range to which the node modification request is to be made, labeling the copied node range with a timestamp, locating the labeled node range via the timestamp and a hash on the node range, and outputting the located labeled node range. Optionally, versioning is done by shadowing nodes in the range to a version hash table based on a range identifier.

Transient range versioning based on redirection

Method for ordering nodes within hierarchical data. The concept of isolated ordered regions to maintain coordinates of nodes is used by associating each node with coordinates relative to a containing region. Modifications to nodes within a region only affect the nodes in that region, and not nodes in other regions. Traversals that retrieve information from the nodes can rebase the coordinates from their containing region and return with a total order.

Isolated ordered regions (IOR) node order

A method, apparatus and article of manufacture is provided for loading data from a remote data source record by record, in a computer system network connecting a source site and a target site via a database connection communication line. The source site has at least one data source and a Distributed Relational Database Architecture (DRDA) software server having multi-database access to DBMSs. The target site requests data loading from the source site DRDA via a block of Structured Query Language (SQL) statements. Data are transported record by record via the database connection communication line according to the DRDA communication protocol, wherein the target site loads records concurrently with the unloading of records in the source site. The data loading may also be performed in a pipeline manner, loading data records in multiple partitions with a plurality of parallel streams, pointed to by a plurality of data source partition cursors.

Data loading from a remote data source record by record

The concept of isolated ordered regions to maintain coordinates of nodes is used by associating each node with coordinates relative to a containing region. Modifications to nodes within a region only affect the nodes in that region, and not nodes in other regions. Traversals that retrieve information from the nodes can rebase the coordinates from their containing region and return with a total order. Access patterns and usage are used to recognize and prefetch pages. The probability of revisiting traversed nodes are identified and pages in a bufferpool are replaced based upon the identified probabilities (e.g., replacing pages with the least probability of a revisit).

Isolated ordered regions (IOR) prefetching and page replacement

A system, method, and article of manufacture for supporting summary tables in a database system that does not otherwise support summary tables is disclosed. The system generally comprises a central program and one or more database systems that may be heterogeneous. At least one of the database systems does not support the generation, maintenance, and/or querying of summary tables. The central program is configured to communicate with the database systems and to identify relations corresponding to summary tables (also referred to as materialized views) within one or more of the database systems. The central program may initiate the generation of summary tables, which may be populated local to the central program or local to one or more of the database systems. The central program may also maintain or coordinate maintenance of the summary tables. In addition, the central program is preferably configured to receive user queries on one or more of the database systems and to generate optimized query plans based upon the user queries, considering in so doing, the contents of the summary tables.

Support for summary tables in a database system that does not otherwise support summary tables

A system, method, and article of manufacture for supporting summary tables in a distributed database environment is disclosed. The system generally comprises a central program and a plurality of remote database systems that may be heterogeneous. The central program is configured to communicate with the database systems and to support summary tables (also referred to as materialized views) within the central program or within one or more of the database systems. The summary tables may contain summary data from one or more of the database systems. The central program may initiate the generation of summary tables, which may be populated local to the central program or local to one or more of the database systems. The central program may also maintain or coordinate maintenance of the summary tables. In addition, the central program may be configured to receive user queries on one or more of the database systems and to generate optimized query plans based upon the user queries, considering in so doing, the summary tables.

Support for summary tables in a heterogeneous database environment

A system and method for compensating for functional differences between heterogeneous database management systems, wherein data associated with a client is distributed among the heterogeneous database management systems, is discussed. The system simulates support of multiple pending actions on a single connection in any of the heterogeneous database management systems which does not support multiple pending actions on a single connection. Also, the system: (1) simulates support of cursors declared &ldquo;with hold&rdquo; in any of the heterogeneous database management systems which does not support cursors declared &ldquo;with hold&rdquo;; (2) simulates support of positioned update actions in any of the heterogeneous database management systems which does not support positioned update actions; (3) simulates support of host variables in any of the heterogeneous database management systems which does not support host variables; and (4) compensates for security log-in procedure differences between the heterogeneous database management systems.

System and method for compensation of functional differences between heterogeneous database management systems

Computer program product for functional compensation in a heterogeneous, distributed database environment

A system, method and computer program product for providing a common interface to a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among the plurality of heterogeneous database management systems. The system simulates support of host variables in any of the heterogeneous database management systems which does not support host variables.

System, method and computer program product for host variable support

A system, method and computer program product for providing a common interface to a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among the plurality of heterogeneous database management systems. The system simulates support of multiple pending database actions on a single connection in any of the heterogenous database management systems which does not support multiple pending database actions on a single connection. Also, the system simulates support of cursors declared &ldquo;with hold&rdquo; in any of the heterogenous database management systems which does not support cursors declared &ldquo;with hold&rdquo;.

Compensation for different connection and cursor characteristics among heterogeneous database management systems

A database management method enables an improved efficiency processing action in a computer wherein manipulation of data from a table is required in accord with a query request, wherein the table is stored remotely from said computer and at least some data in the table includes large data objects (LOBs). The method includes the steps of: responding to the request by transmitting a query to the table; configuring a result set from the table in response to the query, wherein the result set includes one or more unique identifiers of any LOB data associated with the result set; receiving the result set and performing a data manipulation action on data contained in the result set to form a response; transferring the response to the query requester; and accessing LOB data from the table that is referenced by the one or more unique identifiers in the result set and causing transfer of the LOB data to the query requester.

Method and apparatus for deferring large object retrievals from a remote

Growing community of inventors

San Jose, CA, United States of America

James C Kleewein