# US 2015/0106353 A1 · Data Federation Query Suggestion

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

- Number: US 2015/0106353 A1
- Document ID: US20150106353A1
- Status: Published application
- Kind: A1
- Application number: 14/053,343
- Filed: 2013-10-14
- Published: 2015-04-16
- Earliest claimed: 2013-10-14
- Assignees: Red Hat, Inc.
- Applicants: Red Hat, Inc.
- Inventors: Filip Nguyen; Filip Elias
- Web page: https://patentgrep.com/patent/US20150106353A1

## CPC

- G06F 16/954: Navigation, e.g. using categorised browsing
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Systems and methods are provided for data federation query suggestion. An example system includes a query constraint database including at least one query constraint and a query constraint resolving module that receives from a user a query to search a federated database using a federated database search engine and determines if the query satisfies at least one query constraints. The system further includes a query suggestion module that determines a query suggestion if the query does not satisfy at least one query constraints.

## Claims

### Claim 1

A system for data federation query suggestions, the system comprising:
a query constraint database including at least one query constraint
a query constraint resolver that receives from a user a query to search a federated database using a federated database search engine and determines if the query satisfies at least one query constraints; and
a query suggestion module that determines a query suggestion if the query does not satisfy at least one query constraints.

### Claim 2 (depends on 1)

The system of claim 1, wherein each of the at least one query constraints include a set of column query patterns having a two component tuple.

### Claim 3 (depends on 2)

The system of claim 2, wherein the query satisfies the at least one query constraints when each of the set of column query patterns in the least one query constraint is satisfied.

### Claim 4 (depends on 2)

The system of claim 2, wherein the query suggestion includes a fix to the query corresponding to the at least one query constraints.

### Claim 5 (depends on 4)

The system of claim 4, wherein the fix includes each of the at least on column query patterns not satisfied by the query.

### Claim 6 (depends on 1)

The system of claim 1 wherein the query constraint resolver transmits the query to the federated database search engine if the query is compliant with the at least one query constraints.

### Claim 7 (depends on 1)

The system of claim 1, wherein query constraint resolver receives an updated query to search the federated database using the federated database search engine, wherein the updated query is compliant with the at least one query constraints.

### Claim 8 (depends on 1)

The system of claim 1, wherein the at least one query constraint is configured to prevent access to secure data in the federated database.

### Claim 9 (depends on 1)

The system of claim 1, wherein a data architect defines each of the at least one query constraints, and wherein the data architect further configures the federated database search engine.

### Claim 10 (depends on 1)

The system of claim 1, wherein the query is a structured query language (SQL) query.

### Claim 11

A method for data federation query suggestions, the method comprising:
receiving a query to search a federated database using a federated database search engine;
determining, using one or more hardware processor of a query constraint system, if the query satisfies at least one query constraints; and
determining a query suggestion if the query does not satisfy at least one query constraints.

### Claim 12 (depends on 11)

The method of claim 11, wherein each of the at least one query constraints include a set of column query patterns having a two component tuple.

### Claim 13 (depends on 12)

The method of claim 12, wherein the query satisfies the at least one query constraints when each of the set of column query patterns in the least one query constraint is satisfied.

### Claim 14 (depends on 12)

The method of claim 12, wherein the query suggestion includes a fix to the query corresponding to the at least one query constraints.

### Claim 15 (depends on 14)

The method of claim 14, wherein the fix includes each of the at least on column query patterns not satisfied by the query.

### Claim 16 (depends on 11)

The method of claim 11 further comprising:
transmitting the query to the federated database search engine if the query is compliant with the at least one query constraints.

### Claim 17 (depends on 11)

The method of claim 11 further comprising:
receiving an updated query to search the federated database using the federated database search engine, wherein the updated query is compliant with the at least one query constraints.

### Claim 18 (depends on 11)

The method of claim 11, wherein the at least one query constraint is configured to prevent access to secure data in the federated database.

### Claim 19 (depends on 11)

The method of claim 11, wherein the query is a structured query language (SQL) query.

### Claim 20

A non-transitory computer readable medium comprising a plurality of machine-readable instructions which when executed by one or more processors of a server are adapted to cause the server to perform a method comprising:
receiving a query to search a federated database using a federated database search engine;
determining if the query satisfies at least one query constraints, wherein each of the at least one query constraints include a set of column query patterns having a two component tuple, and wherein the query satisfies the at least one query constraints when each of the set of column query patterns in the least one query constraint is satisfied; and
determining a query suggestion if the query does not satisfy each of the set of column query patterns in the least one query constraint, wherein the query suggestion includes a fix to the query corresponding to the at least one query constraints, and wherein the fix includes each of the at least on column query patterns not satisfied by the query.
