Ashutosh Ramesh Patil

US Patent:

20050203887, Sep 15, 2005

Filed:

Mar 12, 2004

Appl. No.:

10/800376

Inventors:

Dinendra Joshi - Santa Clara CA, US
Padmaja Dasari - Santa Clara CA, US
Ashutosh Patil - Santa Clara CA, US

Assignee:

SOLIX TECHNOLOGIES, INC. - SANTA CLARA CA

International Classification:

G06F007/00

US Classification:

707003000

Abstract:

A system and method for providing simultaneous or independent access to disparate data sources in a single login session. A user logs into a front-end application session using a custom responsibility. The user submits a query for accessing data from backend enterprise databases, which store current and archived data separately. The data query is channeled to an interoperable layer. The query is modified to a union query at the interoperable layer, to facilitate simultaneous access to current and archived data. This is done by constructing similar queries for accessing data from each of the multiple data sources. The queries are subsequently combined. Next, the union query is routed to the backend database servers which process the query and retrieve data from current as well as archive databases, in response to the query. The retrieved data is then integrated and presented to the user as an exhaustive search result.