# US 2014/0207790 A1 · Mapping and boosting of terms in a format independent data retrieval query

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

- Number: US 2014/0207790 A1
- Document ID: US20140207790A1
- Status: Published application
- Kind: A1
- Application number: 13/746,440
- Filed: 2013-01-22
- Published: 2014-07-24
- Earliest claimed: 2013-01-22
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Judah M. Diament; Aliza R. Heching
- Web page: https://patentgrep.com/patent/US20140207790A1

## CPC

- G06F 16/90335: {Query processing}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Aspects of the present invention provide a tool for retrieving data in response to a query in any format. In an embodiment, each query term of the query is analyzed to determine whether it corresponds to either a domain keyword or a formula designator. If a formula designator is retrieved, each formula term associated with the formula designator is mapped to a domain keyword. Each of the domain keywords, the formula designators, and the mapped formula terms are boosted. A dataset is searched using a structured search query that includes all boosted terms, as well as any remaining query terms that do not correspond to one of the boosted terms.

## Claims

### Claim 1

A method for retrieving data, comprising:
analyzing each query term of a format-independent query for data retrieval to determine whether the query term corresponds to at least one of: a domain keyword or a formula designator;
mapping a domain keyword to a set of formula terms associated with a retrieved formula designator;
creating a unique weighted boosting for each of the domain keywords, the formula designator, and the mapped formula terms; and
searching a dataset using a structured search query that includes all boosted terms and any remaining query terms that do not correspond to one of the boosted terms.

### Claim 2 (depends on 1)

The method of claim 1, the mapping further comprising:
evaluating a formula definition associated with the retrieved formula designator to generate a set of formula terms;
evaluating domain keywords proximate to the formula designator to determine whether a proximate domain keyword corresponds to one of the set of formula terms;
mapping the query terms to each of the corresponding formula terms;
determining whether all of the set of formula terms have been mapped; and
based on a determination that all of the set of formula terms have not been mapped, inserting an unmapped formula term from the set of formula terms into the query.

### Claim 3 (depends on 1)

The method of claim 1, wherein the query is in a natural language format.

### Claim 4 (depends on 1)

The method of claim 1, the analyzing further comprising:
searching a business domain vocabulary to determine whether the query term corresponds to a domain keyword; and
searching at least one of the business domain vocabulary or a statistical vocabulary to determine whether the query term corresponds to a formula designator and returning a structural mapping that includes one or more constituent formula terms if a match is found.

### Claim 5 (depends on 1)

The method of claim 1, the searching further comprising:
accessing a dataset description of a plurality of datasets, the dataset description including data descriptors that describe a value set in the plurality of datasets; and
comparing the boosted terms and the remaining query items with the data descriptors;
evaluating value sets associated with domain keywords associated with a particular formula designator;
boosting a returned value set based on a designation type of the data descriptor corresponding to the returned value set, the boosting assigning a first boost value to any data descriptors having a preferred designation type that is greater than a second boost value assigned to data descriptors having an inferior designation type;
ranking a solution set based on the boosted terms and the boosted return value set; and
returning the ranked solution set.

### Claim 6 (depends on 5)

The method of claim 5, wherein the boosting determines which designation type of a set of designation types has a preferred designation type based on at least one of: a user identity, a user position, a user group, a software application used, or a point in time, wherein the set of designation types include: key name, column name, column description, value description, table name, and table description.

### Claim 7 (depends on 5)

The method of claim 5, further comprising:
linking a first returned value set having a particular data descriptor with a second returned value set having a corresponding data descriptor; and
returning the linking and the data descriptors with the ranked solution set.

### Claim 8 (depends on 5)

The method of claim 5, further comprising providing a graphical user interface that enables a user to add, delete, and modify data descriptors in the dataset description.

### Claim 9

A system for retrieving data, comprising at least one computer device that performs a method, comprising:
analyzing each query term of a format-independent query for data retrieval to determine whether the query term corresponds to at least one of: a domain keyword or a formula designator;
mapping a domain keyword to a set of formula terms associated with a retrieved formula designator;
creating a unique weighted boosting for each of the domain keywords, the formula designator, and the mapped formula terms; and
searching a dataset using a structured search query that includes all boosted terms and any remaining query terms that do not correspond to one of the boosted terms.

### Claim 10 (depends on 9)

The system of claim 9, the mapping further comprising:
evaluating a formula definition associated with the retrieved formula designator to generate a set of formula terms;
evaluating domain keywords proximate to the formula designator to determine whether a proximate domain keyword corresponds to one of the set of formula terms;
mapping the query terms to each of the corresponding formula terms;
determining whether all of the set of formula terms have been mapped; and
based on a determination that all of the set of formula terms have not been mapped, inserting an unmapped formula term from the set of formula terms into the query.

### Claim 11 (depends on 9)

The system of claim 9, wherein the query is in a natural language format.

### Claim 12 (depends on 9)

The system of claim 9, the analyzing further comprising:
searching a business domain vocabulary to determine whether the query term corresponds to a domain keyword; and
searching at least one of the business domain vocabulary or a statistical vocabulary to determine whether the query term corresponds to a formula designator and returning a structural mapping that includes one or more constituent formula terms if a match is found.

### Claim 13 (depends on 9)

The system of claim 9, the searching further comprising:
accessing a dataset description of a plurality of datasets, the dataset description including data descriptors that describe a value set in the plurality of datasets; and
comparing the boosted terms and the remaining query items with the data descriptors;
evaluating value sets associated with domain keywords associated with a particular formula designator;
boosting a returned value set based on a designation type of the data descriptor corresponding to the returned value set, the boosting assigning a first boost value to any data descriptors having a preferred designation type that is greater than a second boost value assigned to data descriptors having an inferior designation type;
ranking a solution set based on the boosted terms and the boosted return value set; and
returning the ranked solution set.

### Claim 14 (depends on 13)

The system of claim 13, wherein the boosting determines which designation type of a set of designation types has a preferred designation type based on at least one of: a user identity, a user position, a user group, a software application used, or a point in time, wherein the set of designation types include: key name, column name, column description, value description, table name, and table description.

### Claim 15 (depends on 13)

The system of claim 13, the method further comprising:
linking a first returned value set having a particular data descriptor with a second returned value set having a corresponding data descriptor; and
returning the linking and the data descriptors with the ranked solution set.

### Claim 16 (depends on 13)

The system of claim 13, the method further comprising providing a graphical user interface that enables a user to add, delete, and modify data descriptors in the dataset description.

### Claim 17

A computer program product stored on a computer readable storage medium, which, when executed performs a method for retrieving data, comprising:
analyzing each query term of a format-independent query for data retrieval to determine whether the query term corresponds to at least one of: a domain keyword or a formula designator;
mapping a domain keyword to a set of formula terms associated with a retrieved formula designator;
creating a unique weighted boosting for each of the domain keywords, the formula designator, and the mapped formula terms; and
searching a dataset using a structured search query that includes all boosted terms and any remaining query terms that do not correspond to one of the boosted terms.

### Claim 18 (depends on 17)

The program product of claim 17, the mapping further comprising:
evaluating a formula definition associated with the retrieved formula designator to generate a set of formula terms;
evaluating domain keywords proximate to the formula designator to determine whether a proximate domain keyword corresponds to one of the set of formula terms;
mapping the query terms to each of the corresponding formula terms;
determining whether all of the set of formula terms have been mapped; and
based on a determination that all of the set of formula terms have not been mapped, inserting an unmapped formula term from the set of formula terms into the query.

### Claim 19 (depends on 17)

The program product of claim 17, wherein the query is in a natural language format.

### Claim 20 (depends on 17)

The program product of claim 17, the analyzing further comprising:
searching a business domain vocabulary to determine whether the query term corresponds to a domain keyword; and
searching at least one of the business domain vocabulary or a statistical vocabulary to determine whether the query term corresponds to a formula designator and returning a structural mapping that includes one or more constituent formula terms if a match is found.

### Claim 21 (depends on 17)

The program product of claim 17, the searching further comprising:
accessing a dataset description of a plurality of datasets, the dataset description including data descriptors that describe a value set in the plurality of datasets; and
comparing the boosted terms and the remaining query items with the data descriptors;
evaluating value sets associated with domain keywords associated with a particular formula designator;
boosting a returned value set based on a designation type of the data descriptor corresponding to the returned value set, the boosting assigning a first boost value to any data descriptors having a preferred designation type that is greater than a second boost value assigned to data descriptors having an inferior designation type;
ranking a solution set based on the boosted terms and the boosted return value set; and
returning the ranked solution set.

### Claim 22 (depends on 21)

The program product of claim 21, wherein the boosting determines which designation type of a set of designation types has a preferred designation type based on at least one of: a user identity, a user position, a user group, a software application used, or a point in time, wherein the set of designation types include: key name, column name, column description, value description, table name, and table description.

### Claim 23 (depends on 21)

The program product of claim 21, the method further comprising:
linking a first returned value set having a particular data descriptor with a second returned value set having a corresponding data descriptor; and
returning the linking and the data descriptors with the ranked solution set.

### Claim 24 (depends on 21)

The program product of claim 21, the method further comprising providing a graphical user interface that enables a user to add, delete, and modify data descriptors in the dataset description.

### Claim 25

A method for deploying an application for retrieving data, comprising:
providing a computer infrastructure being configured to:
analyze each query term of a format-independent query for data retrieval to determine whether the query term corresponds to at least one of: a domain keyword or a formula designator;
map a domain keyword to a set of formula terms associated with a retrieved formula designator;
create a unique weighted boosting for each of the domain keywords, the formula designator, and the mapped formula terms; and
search a dataset using a structured search query that includes all boosted terms and any remaining query terms that do not correspond to one of the boosted terms.
