Database view modeling using existing data model
AssigneeSap SE
InventorsTorsten Kamenz, Andreas Kemmler
Life of this patent
Estimating the term…
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.
Claims20
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.
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.
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.
Dependencies are inferred from the claim text.