Physical Data Modeling Tutorial

Physical Data Modeling: Physical data model includes all required tables, columns, relationships, database properties for the physical implementation of databases. Database performance, indexing strategy, physical storage and de-normalization are important parameters of a physical model. Logical data model is approved by functional team and there-after development of physical data model work gets started. Once physical data…

Read More

Enterprise Data Modeling Tutorial

Enterprise Data Modeling: The development of a common consistent view and understanding of data elements and their relationships across the enterprise is referred to as Enterprise Data Modeling. This type of data modeling provides access to information scattered throughout an enterprise under the control of different divisions or departments with different databases and data models….

Read More

Conceptual Data Modeling Tutorial

Conceptual Data Modeling: Conceptual data model includes all major entities and relationships and does not contain much detailed level of information about attributes and is often used in the INITIAL PLANNING PHASE. Conceptual data model is created by gathering business requirements from various sources like business documents, discussion with functional teams, business analysts, smart management experts…

Read More

Data Model Repository

What is a Data Model Repository?  A data modeling repository is a storage area, where metadata of a data model is stored. The data stored is different from the software perspective, organization’s perspective and usage perspective. Repository can be stored any where; either in a data base or locally within any system. Example: ETL Repository…

Read More

Data Modeling Reports

From Data Modeling tools, reports can be easily generated for technical and business needs. The reports that have been generated from logical data model and physical data model are called as business reports and technical reports respectively. Most of the data modeling tools provide default reports like subject area reports, entity reports, attribute reports, table…

Read More
error: Content is protected !!