# US 2010/0169351 A1 · Unifying hetrogenous data

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2010/0169351 A1
- Document ID: US20100169351A1
- Status: Published application
- Kind: A1
- Application number: 12/346,574
- Filed: 2008-12-30
- Published: 2010-07-01
- Earliest claimed: 2008-12-30
- Assignees: International Business Machines Corporation
- Inventors: Shrinivas Kulkarni; Karin Murthy; Raha Debarshi; Steffen Schaefer
- Web page: https://patentgrep.com/patent/US20100169351A1

## CPC

- G06F 16/248: Presentation of query results
- G06F 16/9554: {by using bar codes}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Techniques for unifying data are provided. The techniques include transforming a query into one or more sub-queries that can be answered by one or more types of data services, and wherein the query touches one or more joins across data residing in one or more enterprise systems, querying one or more target data services for each of the one or more sub-queries, aggregating one or more sets of results based on the one or more target data services, and unifying the one or more sets of aggregated results.

## Claims

### Claim 1

A method for unifying data, the method comprising:
transforming a query into one or more sub-queries that can be answered by one or more types of data services, and wherein the query correlates distributed data related to the query;
determining one or more data service dynamically based on the one or more sub-queries;
querying one or more target data services for each of the one or more sub-queries;
aggregating one or more sets of results based on the one or more target data services; and
unifying the one or more sets of aggregated results.

### Claim 2 (depends on 1)

The method of claim 1, wherein the one or more types of data services comprise one or more sets of information.

### Claim 3 (depends on 1)

The method of claim 1, wherein the one or more types of data services is located on one or more enterprise systems, the enterprise systems coupled over a network and distributed over one or more geographic boundaries and one or more organizational boundaries.

### Claim 4 (depends on 2)

The method of claim 2, wherein each of one or more types of data service has a unique query interface.

### Claim 5 (depends on 1)

The method of claim 1, wherein transforming a query into one or more sub-queries that can be answered by one or more types of data services comprises:
segmenting the query across the one or more types of data services into one or mere sub-queries;
identifying the one or more sub-queries that can be successfully queried against the type of data service; and
translating each of the one or more sub-queries into a query format of a target data service.

### Claim 6 (depends on 1)

The method of claim 1, wherein determining one or more data service end points dynamically based on each of the one or more sub-queries comprises:
extracting one or more search keys, wherein the search key forms part of the query;
transmitting the one or more search keys to a first service; and
generating a list of one or more data service from the one or more search keys from the first service, wherein each data service in the list of one or more data service configured to answer the one or more sub-queries.

### Claim 7 (depends on 6)

The method of claim 6, further comprising passing one or more security credentials to at least one of the data service and the query.

### Claim 8 (depends on 1)

The method of claim 1, wherein unifying the one or more sets of aggregated results comprises:
defining one or more views of remote data, wherein a view of remote data is defined for each of one or more types of entities and for each of one or more types of data services;
mapping the one or more sets of aggregated results to the one or more views of remote data to populate the one or more views of remote data; and
combining the one or more views of remote data.

### Claim 9 (depends on 8)

The method of claim 8, wherein the one or more view is a relational view.

### Claim 10 (depends on 1)

The method of claim 1, further comprising repeating the steps of determining one or more data service end points dynamically and querying one or more target data services for each of the one or more sub-queries to obtain one or more additional sets of aggregated results.

### Claim 11

A computer program product comprising a computer readable medium having computer readable program code for unifying data, said computer program product including:
computer readable program code for transforming a query into one or more sub-queries that can be answered by one or more types of data services, wherein the query correlated distributed data related to the;
computer readable program code for determining one or more data service dynamically based on the one or more sub-queries;
computer readable program code for querying one or more target data services for each of the one or more sub-queries;
computer readable program code for aggregating one or more sets of results based on the one or more target data services; and
computer readable program code for unifying the one or more sets of aggregated results.

### Claim 12 (depends on 11)

The computer program product of claim 11, wherein the computer readable program code for transforming a query into one or more sub-queries that can be answered by one or more types of data services:
computer readable code for segmenting the query across the one or more types of data services into one or more sub-queries:
computer readable code for identifying the one or more sub-queries can be successfully queried against the type of data service; and
computer readable code for translating each of the one or more sub-queries into a query format of a target data service.

### Claim 13 (depends on 11)

The computer program product of claim 11, wherein the computer readable code for determining one or more data service end points dynamically based on each of the one or more sub-queries is further configured to perform
extracting one or more search keys, wherein the search key forms part of the query:
transmitting the one or more search keys to a first service; and
generating a list of one or more data service from the one or more search keys from the first service, wherein each data service in the list of one or more data service configured to answer the one or more sub-queries.

### Claim 14 (depends on 11)

The compute program product of claim 11, wherein the computer readable code for unifying the one or more sets of aggregated results comprises:
computer readable program code for defining one or more views of remote data, wherein a view of remote data is defined for each of one or more types of entities and for each of one or more types of data services;
computer readable program code for mapping the one or more sets of aggregated results to the one or more views of remote data to populate the one or more views of remote data; and
computer readable program code for performing the query by executing a joins over the one or-more views of remote data.

### Claim 15 (depends on 11)

The computer program product of claim 11, wherein the view is a relational view.

### Claim 16

A system for unifying data, comprising:
a memory; and
at least one processor coupled to said memory and operative to:
transform a query into one or more sub-queries that can be answered by one or more types of data services, and wherein the query correlates distributed data that is related to the query:
dynamically determine one or more data service based on each of the one or more sub-queries:
query one or more target data services for each of the one or more sub-queries;
aggregate one or more sets of results based on the one or more target data services; and
unify the one or more sets of aggregated results.

### Claim 17 (depends on 16)

The system of claim 16, wherein in transforming a query into one or more sub-queries that can be answered by one or more types of data services, the at least one processor coupled to said memory is further operative to:
segment the query across the one or more types of data services into one or more sub-queries;
identify which of the one or more sub-queries can be successfully queried against which type of data service; and
translate each of the one or more sub-queries into a query format of a target data service.

### Claim 18 (depends on 16)

The system of claim 16, wherein in querying one or more target data services for each of the one or more sub-queries, the at least one processor coupled to said memory is further operative to use a framework component to query each of the one or more data service end points, wherein the framework component traverses through a list of one or more servers, queries each server with the same query and aggregates the query results from the one or mere servers.

### Claim 19 (depends on 16)

The system of claim 16, wherein in unifying the one or more sets of aggregated results, the at least one processor coupled to said memory is further operative to:
define one or more views of remote data, wherein a view of remote data is defined for each of one or more types of entities and for each of one or more types of data services;
map the one or more sets of aggregated results to the one or more relational views of remote data to populate the one or more views of remote data; and
perform the query by executing a joins over the one or more views of remote data.

### Claim 20 (depends on 19)

The system of claim 19, wherein the view is a relational view.
