SEQUENCED MODIFICATION OF MULTIPLE ENTITIES BASED ON AN ABSTRACT DATA REPRESENTATION

• US 20080215611A1
• Filed: 05/16/2008
• Published: 09/04/2008
• Est. Priority Date: 02/26/2002
• Status: Active Grant

• Current Assignee: Jennifer L. Larocca, Richard D. Dettinger, Richard J. Stevens
• Original Assignee: Jennifer L. Larocca, Richard D. Dettinger, Richard J. Stevens
• Inventors: Stevens, Richard J., LaRocca, Jennifer L., DETTINGER, RICHARD D.
• Granted Patent: US 8,108,366 B2
• Time in Patent Office: Days
• US Class Current: 707/102
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

The present invention is generally directed to a system, method and article of manufacture for modifying data represented abstractly through an abstraction model. In one embodiment, a data repository abstraction layer provides a logical view of an underlying data repository that is independent of the particular manner of data representation. A query abstraction layer is also provided and is based on the data repository abstraction layer. A runtime component performs transformation of an abstract query into a form that can be used against a particular physical data representation. The transformation includes ordering physical modification operations according to a physical entity relationships specification to ensure that the physical modification operations are executed in an appropriate order.

Claims

1. A computer-readable medium containing a user interface program which, when executed by a processor, performs an operation for creating an abstract modification specification abstractly defining modification operations to modify physical data in a database containing a plurality of physical entities, comprising:

displaying a selection field;

populating the selection field with a plurality of logical fields from which a user selects two or more logical fields to be used as seed fields in determining related logical fields, wherein each logical field corresponds to a physical entity in the database;

receiving a selection of at two logical fields from the selection field, wherein each of the two logical fields corresponds to a separate physical entity in the database;

based on the selection of the at two logical fields, determining related logical fields for each of the at two logical fields; and

displaying input fields for each of the selected logical fields and the related logical fields, wherein the input fields include required fields necessary to perform the abstract modification specification.

2. The computer-readable medium of claim 1, the operation further comprising:

receiving values for at least the required fields;

generating the abstract modification specification;

transforming the abstract modification specification into at least two physical modification statements consistent with a particular physical data representation of the data according to mapping rules which map the logical fields corresponding to the physical entities, wherein each of the at least two physical modification statements modifies a different physical entity of the data;

ordering the at least two physical modification statements; and

executing the modification operations according to the physical modification statements, whereby the data is modified.

4. The method of claim 1, further comprising:

receiving values for at least the required fields;

generating the abstract modification specification;

transforming the abstract modification specification into at least two physical modification statements consistent with a particular physical data representation of the data according to mapping rules which map the logical fields corresponding to the physical entities, wherein each of the at least two physical modification statements modifies a different physical entity of the data;

ordering the at least two physical modification statements; and

executing the modification operations according to the physical modification statements, whereby the data is modified.

6. The computer of claim 1, the operation further comprising:

receiving values for at least the required fields;

generating the abstract modification specification;

transforming the abstract modification specification into at least two physical modification statements consistent with a particular physical data representation of the data according to mapping rules which map the logical fields corresponding to the physical entities, wherein each of the at least two physical modification statements modifies a different physical entity of the data;

ordering the at least two physical modification statements; and

executing the modification operations according to the physical modification statements, whereby the data is modified.

3. A computer-implemented method for creating an abstract modification specification abstractly defining modification operations to modify physical data in a database containing a plurality of physical entities, the method comprising:

displaying a selection field;

populating the selection field with a plurality of logical fields from which a user selects two or more logical fields to be used as seed fields in determining related logical fields, wherein each logical field corresponds to a physical entity in the database;

receiving a selection of at two logical fields from the selection field, wherein each of the two logical fields corresponds to a separate physical entity in the database;

based on the selection of the at two logical fields, determining related logical fields for each of the at two logical fields; and

displaying input fields for each of the selected logical fields and the related logical fields, wherein the input fields include required fields necessary to perform the abstract modification specification.

5. A computer, comprising:

a memory containing a program; and

at least one processor;

the program, which when executed on the processor, is configured to perform an operation to create an abstract modification specification abstractly defining modification operations to modify physical data in a database containing a plurality of physical entities, the operation comprising;

displaying a selection field;

populating the selection field with a plurality of logical fields from which a user selects two or more logical fields to be used as seed fields in determining related logical fields, wherein each logical field corresponds to a physical entity in the database;

receiving a selection of at two logical fields from the selection field, wherein each of the two logical fields corresponds to a separate physical entity in the database;

based on the selection of the at two logical fields, determining related logical fields for each of the at two logical fields; and

displaying input fields for each of the selected logical fields and the related logical fields, wherein the input fields include required fields necessary to perform the abstract modification specification.