International Business Machines Corporation

Paul Arnold Ostler

Bilung Lee

Anshul Dawra

Stephen Andrew Brodsky

Sherry X Guo

David W Chang

Huaxin Gao

David Wei-Jye Chang

Tony Leung

Randall William Horman

Swaminathan Gounder

Satheesh E Bandaram

Vijay R Bommireddipalli

Maryela Evelin Weihrauch

William Robert Bireley

Delmar Eugene Blevins

Curt Lee Cotner

Holger Karn

David Joseph Wisneski

Timothy Jon Vincent

Brent P Gross

Tony Kai-chi Leung

Soloman J Barghouthi

Suavi Ali Demir

Dilip Kumar Biswal

Robert Alan Begg

Jaijeet Chakravorty

Ryan Kern

Sigitas Bigelis

Lawrence E Dunnell

Loic Raymond Robert Julien

Manish Sehgal

Catalina Y Wei

According to one embodiment of the present invention, a system enables control of database applications. The system comprises a computer system including a database application to provide access to a database system, and at least one processor. The computer system requests retrieval of application specific property information for the database application from a data repository, and applies the retrieved application specific property information to the database application to control operation of the database application. Embodiments of the present invention further include a method and computer program product for controlling database applications in substantially the same manner described above.

Method and system for centralized control of database applications

Provided are techniques for, under control of an agent: receiving a request from a first database client to access a service from a set of services, wherein the agent is associated with the service; receiving a request from a second database client to access the service, wherein the agent is shared by the first database client and the second database client; combining information from the first database client and the second database client; and sending the combined information to the service using a single physical connection in a client-side Client Management Extension (CMX) connection, wherein the first database client and the second database client share the single physical connection.

Universal architecture for client management extensions on monitoring, control, and configuration

Embodiments of the invention provide techniques for disaster recovery in the event of a database connection failure. In one embodiment, a network address for a secondary server may be stored in multiple data objects of a client computer. In the event of a failed connection to a primary server, the network address of the secondary server may be retrieved from one of the data objects stored in the client computer. When an updated network address for the secondary server is received, it may be propagated to the data objects of the client computer.

Intelligent disaster recovery for database connection failures

Systems, methods and articles of manufacture are disclosed for batching heterogeneous database commands. The heterogeneous database commands may include at least two database command types. Further, at least two of the heterogeneous database commands may include host variables. A request to execute the heterogeneous database commands may be received. The heterogeneous database commands may be sent to a database system for execution, responsive to the request.

Batching heterogeneous database commands

A system and method for connection of an application program to its corresponding database in a relational database system environment. Rather than embedding connection configuration information or properties in an application program, connection configurations are stored in a connection configuration repository. The connection configuration repository is likewise stored in a database within the relational database system environment. The connection configuration information stored in the configuration repository may be updated, revised, deleted or assembled into groups/subgroups, without affecting the application programs.

Common connection definitions for database clients

Provided are techniques for extending functionality of an application. A request to create an application object is received. In response to receiving the request, the application object is created, and an extension proxy object is created. The extension proxy object is wrapped around the application object. An invocation of a function of the extension proxy object is received from the application object.

Integrated extension framework

A method, system, and computer program product for managing a heterogeneous connection pooling structure. The heterogeneous architecture of pooling management comprises connections having different connection attributes (i.e. different data source properties) that can share a same connection pool (i.e. same connection pool data source). An application requests a connection from data source having a specified data source property. An application server searches a pool module for an available cached connection. If a cached connection is available, the cached connection is automatically selected as a returned connection. A connection reuse protocol and a statement reuse protocol is determined and invoked to reconfigure the cached connection for reuse as a connection between the application and a database server.

Heterogeneous architecture in pooling management

Systems and methods to implement optimistic locking in online and offline environments are provided. A particular method includes receiving from an application an application data request related to retrieving a data item from a data store. The method also includes sending an optimistic locking information request to the data store to retrieve optimistic locking information, such as an identifier, associated with the data item. Additionally, the method includes receiving a data item update statement from the application while a connection between the application and a database server coupled to the data store persists or after a connection between the application and the database server has terminated and reconnected. The data item update statement relates to storing an updated version of the data item at the data store. Further, the method includes synchronizing the data item with the updated version of the data item based on the optimistic locking information.

Optimistic locking in online and offline environments

A method of accessing layers in a multi-layer software architecture including a first layer, a second layer, and a third layer. The method includes: at the third layer, publishing an interface; and at the first layer, before execution of a first function, registering a callback routine with the third layer using the interface.

Cooperative unwrapping across intervening wrappers

A system and method for database security provides multiple choices of security mechanisms for enabling access to a database through a database driver. A security mechanism that is compatible with a database is selected and the security mechanisms between an application and a database server are automatically determined using the selected security mechanism.

Automatic and adjustable system and method for synchronizing security mechanisms in database drivers with database servers

A system and method for database security provides, a database security method that receives an encryption property from an application and receives information relating to a database server. The method then requests security access to a database server using the strongest encryption algorithm server may support. If this request gets turned down, then the method determines the strongest encryption algorithm the server actually supports using the information the database server sent back and calculates the encryption keys. The method then caches the encryption algorithm along with the encryption keys in a persistent storage. For subsequent connections, the method checks the persistent storage first and retrieves the encryption algorithm and encryption keys from the persistent storage if the cache values are available, and sends the cached value to database server. By doing this, the database driver doesn't need to synchronize the encryption algorithm with server and calculate the encryption keys again.

Unified and persistent system and method for automatic configuration of encryption

Growing community of inventors

Yakima, WA, United States of America

Paul Arnold Ostler