Oracle America, Inc.

Sun Microsystems, Inc.

Amit Handa

Binod Pankajakshy Gangadharan

Servesh Pratap Singh

Lance J Andersen

Shreyas Kaushik

Sai Surya Kiran Evani

Shreyas S Kaushik

Techniques for integrating Information Systems with Application Servers are disclosed. The techniques can be used to implement a configurable connector interface that connects to existing interfaces used to access various Information Systems. The configurable connection interface can encapsulate these existing interfaces. Accordingly, the configurable connector interface can serve as a standard interface that can be used to connect an application server to various Information Systems. The configurable connection interface can be implemented as a 'Resource Adaptor' that can be modified to fit the requirements of a particular existing interface used to access a particular information system (e.g., a database driver developed for a particular relational database). A Graphical User Interface (GUI) can be used to conveniently modify and deploy the modified Resource Adaptor file. These operations can conveniently be performed by using a deployment tool through a Graphical User Interface (GUI).

Frameworks for integrating information systems

A method for accessing data from a network storage medium is disclosed. An application supplies a query interface to a software object. The software object then establishes a connection between the application and the network storage medium using database information supplied by the query interface. Next, an annotated method supplied by the query interface is executed using logic provided by the software object. After the transactions have ended, the annotated method closes the connection between the application and the network storage medium.

Automatic connection and query management

Computer systems often strive to retrieve and process data from multiple sources. Integration and processing of data from multiple data sources tends to increase processing demands and decrease throughput due to the additional deployment of computational resources for handling multiple sources. An executable entity, such as a bean, which accesses each data source by the location of the data objects, and retrieves data objects corresponding to rows of data, is operable to access a plurality of data sources independently of the storage medium (i.e. DBMS), or format, and aggregate multiple objects from each of the data sources into a set of compound objects, in which each compound object includes associated fields from the accessed objects of the individual data sources. The attributes of the rows (objects) from different data sources are matched according to a common attribute in each object, and the resulting compound object is aggregated into a compound object set, which represents each of objects from each of the data sources joined according to the common attribute.

System and methods for aggregating data from multiple sources

Growing community of inventors

Chandigarh, India

Amit Handa