Monday, 31 October 2022

What are the types of Data Model?

Conceptual Data Model: 

This Data Model defines WHAT the system contains. This model is typically created by Business stakeholders and Data Architects. The purpose is to organize, scope and define business concepts and rules.

Logical Data Model: 

Defines HOW the system should be implemented regardless of the DBMS. This model is typically created by Data Architects and Business Analysts. The purpose is to developed technical map of rules and data structures.

Physical Data Model: 

This Data Model describes HOW the system will be implemented using a specific DBMS system. This model is typically created by DBA and developers. The purpose is actual implementation of the database.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to perform regression testing in ETL?

Regression testing in ETL (Extract, Transform, Load) ensures that changes or updates to the ETL process do not negatively impact existing fu...

  • Explain incremental data loading?
    Incremental data loading is a technique used in ETL (Extract, Transform, Load) processes to load only the new or changed data since the last...
  • How to perform regression testing in ETL?
    Regression testing in ETL (Extract, Transform, Load) ensures that changes or updates to the ETL process do not negatively impact existing fu...
  • Dimensional Modeling?
      Dimensional modeling is a design technique used in data warehousing to structure data for efficient querying and reporting. It organizes d...