# US 2008/0189289 A1 · Generating logical fields for a data abstraction model

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

- Number: US 2008/0189289 A1
- Document ID: US20080189289A1
- Status: Published application
- Kind: A1
- Application number: 11/671,686
- Filed: 2007-02-06
- Published: 2008-08-07
- Earliest claimed: 2007-02-06
- Inventors: Richard D. Dettinger; Frederick A. Kulack
- Web page: https://patentgrep.com/patent/US20080189289A1

## CPC

- G06F 16/288: {Entity relationship models}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method, system and article of manufacture for generating logical fields for a data abstraction model that abstractly describes physical data in a database is disclosed. A data abstraction model may define one or more dynamic entities used to generate a plurality of logical fields. Each dynamic entity may identify a field template defining a pattern for a group of logical fields. When the dynamic entity is executed, logical fields may be generated by passing parameter values to the template. The definition of a dynamic entity may also include a data request, e.g., a database query, configured to retrieve sets of parameter values for the template. In one embodiment, a dynamic entity may be configured to determine whether a given logical field is already present in the data abstraction model, before attempting to generate that logical field from the template.

## Claims

### Claim 1

A computer-implemented method of generating logical fields for a data abstraction model, comprising:
retrieving, from the data abstraction model, a dynamic entity definition that identifies a logical field template used to generate a group logical fields;
retrieving one or more sets of parameter values, wherein each set of parameter values may be supplied to the template in order to create a logical field;
determining, for a first set of parameter values, whether a logical field to be generated from the logical field template and the first set of parameter values is present in the data abstraction model; and
upon determining that the logical field to be generated from the logical field and the first set of parameter values is not present in the data abstraction model,
generating the logical field from the logical field template and the first set of parameter values, and
adding the generated logical field to the data abstraction model.

### Claim 2 (depends on 1)

The method of claim 1, wherein retrieving one or more sets of parameter values, comprises:
retrieving a data request from the dynamic entity definition;
executing the data request to retrieve the one or more sets of parameter values; and
generating a temporary data structure to store the one or more sets of parameter values.

### Claim 3 (depends on 2)

The method of claim 2, wherein the temporary data structure is generated in tabular form having a multiplicity of rows, each containing one of the sets of parameters.

### Claim 4 (depends on 2)

The method of claim 2, wherein the data request comprises one or more SQL queries.

### Claim 5 (depends on 1)

The method of claim 1, wherein the data abstraction model stores logical fields in a plurality of logical field categories, and wherein determining, for a first set of parameter values, whether a logical field to be generated from the logical field template and the first set of parameter values is present in the data abstraction model comprises determining whether the logical field to be generated is present in a category specified for the logical field to be generated.

### Claim 6 (depends on 5)

The method of claim 5, wherein the plurality of logical field categories are organized using a hierarchical category structure.

### Claim 7 (depends on 1)

The method of claim 1, wherein the dynamic entity definition specifies a logical field category to be created in the data abstraction model, wherein at least one of the logical fields generated from the template are stored in the category to be created.

### Claim 8 (depends on 1)

The method of claim 1, wherein the data abstraction model includes a first dynamic entity that is associated with a first logical field template and a second dynamic entity that is associated with a second logical field template; and wherein retrieving the one or more parameters from the database comprises:
generating a first temporary data structure having sets of parameters values for the first dynamic entity; and
generating a second temporary data having sets of parameter values for the second dynamic entity.

### Claim 9

A computer-readable storage medium containing a program which, when executed by a processor, performs a process for generating logical fields for a data abstraction model, the process comprising;
retrieving, from the data abstraction model, a dynamic entity definition that identifies a logical field template used to generate a group logical fields;
retrieving one or more sets of parameter values, wherein each set of parameter values may be supplied to the template in order to create a logical field;
determining, for a first set of parameter values, whether a logical field to be generated from the logical field template and the first set of parameter values is present in the data abstraction model; and
upon determining that the logical field to be generated from the logical field and the first set of parameter values is not present in the data abstraction model,
generating the logical field from the logical field template and the first set of parameter values, and
adding the generated logical field to the data abstraction model.

### Claim 10 (depends on 8)

The computer-readable storage medium of claim 8, wherein retrieving one or more sets of parameter values, comprises:
retrieving a data request from the dynamic entity definition;
executing the data request to retrieve the one or more sets of parameter values; and
generating a temporary data structure to store the one or more sets of parameter values.

### Claim 11 (depends on 10)

The computer-readable storage medium of claim 10, wherein the temporary data structure is generated in tabular form having a multiplicity of rows, each containing one of the sets of parameters.

### Claim 12 (depends on 10)

The computer-readable storage medium of claim 10, wherein the data request comprises one or more SQL queries.

### Claim 13 (depends on 9)

The computer-readable storage medium of claim 9, wherein the data abstraction model stores logical fields in a plurality of logical field categories, and wherein determining, for a first set of parameter values, whether a logical field to be generated from the logical field template and the first set of parameter values is present in the data abstraction model comprises determining whether the logical field to be generated is present in a category specified for the logical field to be generated.

### Claim 14 (depends on 13)

The computer-readable storage medium of claim 13, wherein the plurality of logical field categories are hierarchical.

### Claim 15 (depends on 9)

The computer-readable storage medium of claim 9, wherein the dynamic entity definition specifies a logical field category to be created in the data abstraction model, wherein at least one of the logical fields generated from the template are included in the category to be created.

### Claim 16 (depends on 9)

The computer-readable storage medium of claim 9, wherein the data abstraction model includes a first dynamic entity that is associated with a first logical field template and a second dynamic entity that is associated with a second logical field template; and wherein retrieving the one or more parameters from the database comprises:
generating a first temporary data structure having sets of parameters values for the first dynamic entity; and
generating a second temporary data having sets of parameter values for the second dynamic entity.

### Claim 17

A system, comprising:
a processor; and
a memory containing a program which, when executed by the processor, is configured to:
retrieve, from the data abstraction model, a dynamic entity definition that identifies a logical field template used to generate a group logical fields;
retrieve one or more sets of parameter values, wherein each set of parameter values may be supplied to the template in order to create a logical field;
determine, for a first set of parameter values, whether a logical field to be generated from the logical field template and the first set of parameter values is present in the data abstraction model; and
upon determining that the logical field to be generated from the logical field and the first set of parameter values is not present in the data abstraction model,
generate the logical field from the logical field template and the first set of parameter values, and
add the generated logical field to the data abstraction model.

### Claim 18 (depends on 17)

The system of claim 17, wherein the program is configured to retrieve one or more sets of parameter values by:
retrieving a data request from the dynamic entity definition;
executing the data request to retrieve the one or more sets of parameter values; and
generating a temporary data structure to store the one or more sets of parameter values.

### Claim 19 (depends on 18)

The system of claim 18, wherein the data request comprises one or more SQL queries.

### Claim 20 (depends on 17)

The system of claim 17, wherein the data abstraction model stores logical fields in a plurality of logical field categories, and wherein the program is configured to determine, for a first set of parameter values, whether a logical field to be generated from the logical field template and the first set of parameter values is present in the data abstraction model by determining whether the logical field to be generated is present in a category specified for the logical field.

### Claim 21 (depends on 17)

The system of claim 17, wherein the dynamic entity definition specifies a logical field category to be created in the data abstraction model, wherein at least one of the logical fields generated from the template are included in the category to be created.

### Claim 22 (depends on 17)

The system of claim 17, wherein the data abstraction model includes a first dynamic entity that is associated with a first logical field template and a second dynamic entity that is associated with a second logical field template; and wherein the program is configured to retrieve one or more sets of parameter values by:
generating a first temporary data structure having sets of parameters values for the first dynamic entity; and
generating a second temporary data having sets of parameter values for the second dynamic entity.
