Database view modeling using existing data model

• US 8,751,543 B2
• Filed: 07/13/2012
• Issued: 06/10/2014
• Est. Priority Date: 07/13/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kamenz, Torsten, Kemmler, Andreas
• Primary Examiner(s): Coby, Frantz
• Application Number:
  US13/548,759
• Publication Number:
  US 20140019473A1
• Time in Patent Office: 697 Days
• Field of Search: 707/790, 707803-804, 707808- 11, 707808-811, 705/348, 709/201, 709/203, 709/213, 709/217
• US Class Current: 707/803
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466

Abstract

A data model may be designed based views of a pre-existing data model. Metadata associated with the pre-existing data model may be presented to the user to support the user'"'"'s design effort. The metadata may inform and otherwise guide the user'"'"'s design choices to reduce the likelihood of inconsistencies between the new data model and the pre-existing data model. The metadata may also be used to identify and warn the user of potential inconsistencies between the new data model and the pre-existing data model.

Claims

1. A method for creating a data model comprising operating a computer system to perform steps of:

identifying at least one pre-existing data model; and

interacting with a user to define a new data model using information comprising the pre-existing data model, including;

presenting information to the user that is representative of data tables comprising the pre-existing data model;

accessing a metadata repository comprising metadata associated with the pre-existing data model;

presenting some of the metadata associated with the pre-existing data model to the user;

receiving input from the user which specifies portions of the new data model that are based at least on a query performed on one or more of the data tables comprising the pre-existing data model; and

using some of the metadata associated with the pre-existing data model to verify some of the input received from the user.

2. The method of claim 1 wherein input from the user includes a query on one or more of the data tables comprising the pre-existing data model.

3. The method of claim 1 wherein the metadata associated with the pre-existing data model comprises data that specifies relationships among data fields of one or more of the data tables which comprise the pre-existing data model.

4. The method of claim 1 wherein the metadata associated with the pre-existing data model comprises data that specifies characteristics of data stored in the data tables which comprise the pre-existing data model.

5. The method of claim 1 wherein presenting information to the user includes presenting one or more views of the data tables which comprise the pre-existing data model.

6. The method of claim 1 wherein presenting information to the user includes performing one or more database queries on one or more of the data tables which comprise the pre-existing data model.

7. The method of claim 1 further comprising operating the computer system to perform a step of identifying a second pre-existing data model, wherein defining a new data model includes using information comprising the second pre-existing data model.

8. A computer system comprising:

a data processor; and

a memory having stored thereon computer executable program code which, when executed, causes the data processor to;

identify at least one pre-existing data model; and

interact with a user to define a new data model using information comprising the pre-existing data model, wherein the data processor;

presents information to the user that is representative of data tables comprising the pre-existing data model;

accesses a metadata repository comprising metadata associated with the pre-existing data model;

presents some of the metadata associated with the pre-existing data model to the user;

receives input from the user which specifies portions of the new data model that are based at least on a query performed on one or more of the data tables comprising the pre-existing data model; and

uses some of the metadata associated with the pre-existing data model to verify some of the input received from the user.

9. The computer system of claim 8 wherein input from the user includes a query on one or more of the data tables comprising the pre-existing data model.

10. The computer system of claim 8 wherein the metadata associated with the pre-existing data model comprises data that specifies relationships among data fields of one or more of the data tables which comprise the pre-existing data model.

11. The computer system of claim 8 wherein the metadata associated with the pre-existing data model comprises data that specifies characteristics of data stored in the data tables which comprise the pre-existing data model.

12. The computer system of claim 8 wherein information that is representative of data tables which comprise the pre-existing data model includes one or more views of the data tables.

13. The computer system of claim 12 wherein the views are specified by the user.

14. The computer system of claim 12 wherein the views are pre-existing views of the pre-existing data model.

15. The computer system of claim 8 wherein the data processor further identifies a second pre-existing data model, wherein the new data model includes information comprising the second pre-existing data model.

16. A non-transitory computer readable storage medium having stored thereon executable program code which, when executed by a data processor, causes the data processor to perform steps of:

identifying at least one pre-existing data model; and

interacting with a user to define a new data model using information comprising the pre-existing data model, including;

presenting information to the user that is representative of data tables comprising the pre-existing data model;

accessing a metadata repository comprising metadata associated with the pre-existing data model;

presenting some of the metadata associated with the pre-existing data model to the user;

receiving input from the user which specifies portions of the new data model that are based at least on a query performed on one or more of the data tables comprising the pre-existing data model; and

using some of the metadata associated with the pre-existing data model to verify some of the input received from the user.

17. The non-transitory computer readable storage medium of claim 16 wherein the metadata associated with the pre-existing data model comprises data that specifies relationships among data fields of one or more of the data tables which comprise the pre-existing data model.

18. The non-transitory computer readable storage medium of claim 16 wherein the metadata associated with the pre-existing data model comprises data that specifies characteristics of data stored in the data tables which comprise the pre-existing data model.

19. The non-transitory computer readable storage medium of claim 16 wherein presenting information to the user includes presenting one or more views of the data tables which comprise the pre-existing data model.

20. The non-transitory computer readable storage medium of claim 16 wherein presenting information to the user includes performing one or more database queries on one or more of the data tables which comprise the pre-existing data model.