Browse Prior Art Database

METHOD AND SYSTEM FOR PROPAGATING CHANGES AND UPDATES IN BUSINESS CONCEPTUAL MODEL TO LOGICAL DATA WAREHOUSE MODEL

IP.com Disclosure Number: IPCOM000244075D
Publication Date: 2015-Nov-09
Document File: 2 page(s) / 43K

Publishing Venue

The IP.com Prior Art Database

Abstract

The Business Conceptual Model is a conceptual level model that specifies the third normal form data structures required to represent the concepts defined by the business. The Data Warehouse Model is a design level data model that represents the enterprise-wide repository of atomic data used for informational processing.The disclosure provides a method and system for identifying and propagating changes from Business conceptual model to data warehouse model.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 54% of the total text.

Page 01 of 2

METHOD AND SYSTEM FOR PROPAGATING CHANGES AND UPDATES IN BUSINESS CONCEPTUAL MODEL TO LOGICAL DATA WAREHOUSE MODEL

There is a requirement for the data warehouse modelling business to be more agile and adaptive in nature. The data modelling process for data warehouse models typically starts with a business conceptual model for modelling a business concept. This conceptual model is then propagated into a logical data warehouse model.

    The Business Conceptual Model is a conceptual level model that specifies the third normal form data structures required to represent the concepts defined by the business. It does not contain any technical information, such as Primary Keys, Foreign Keys, technical attributes for history support, and so on. The Business Conceptual Model provides an enterprise-wide, generic, and flexible data representation for design of Logical Data Warehouse Models. It is meant to serve as an overall reference point for business and IT.

    The Data Warehouse Model is a design level data model that represents the enterprise-wide repository of atomic data used for informational processing. This includes the historic changes to business information over time, and of which the business wants to keep track for analytical purposes. In addition to the business content, the Data Warehouse Model includes technical constructs, such as primary and foreign keys, history entities and data warehouse population information.Logical Data Warehouse model and business conceptual model usually have mapping between the models.

    The process of incrementally changing the business conceptual model and propagating the changes into logical data warehouse model is carried out by a data modeller. The decision making process involved in the propagation decisions requires a human input. The propagation process is time consuming and result in high development and management cost. The major problem in the propagation process is the way the changes are handled. The existing processes involve manual propagation of changes to Data warehouse model carried out by a data modeller

For example, when a new business concept in the conceptual model within

an existing business subject area is introduced it needs to be propagated to the logical data warehouse model. This propagation process requires the data modeller to analyse the existing business subject area in the data warehouse model, decide and then model entities, attributes and relationships. After modelling the data modeller has to review the new content added in logical data warehouse which should be based on content added in business conceptual model. In future if another requirement emerges for new content in the same subject...