Subscribe to DMU

Search DMU Library

Categories

Menu

Data Architecture

Type of data model

Data Models Ensure Successful Migrations

When migrating data across platforms, it is critically important to have three full data models to support the effort, with the relevant metadata.  Having these models will reduce time, costs, and effort needed to perform the migration successfully. Introduction Migrating data from one platform (e.g., legacy applications) to another (e.g., DW, ERP, MDM) is a difficult endeavor requiring understanding of

Read More

The Power of Abstraction in Data Modeling

Abstraction is a powerful design tactic for creating flexible, robust and scalable data warehouse data models Introduction I remember meandering through the large galleries of a modern art museum, and stopping in my tracks in front of a very large canvas painted completely red with a single white dot in the center. The title was “City Skyline”, and as hard

Read More

Logical and Physical Data Modeling Overview

Logical and physical data modeling are essential components of every organization’s enterprise data architecture, and should form the foundation of every database design.  Standard techniques for logical and physical data modeling enable consistent development and usability.  Even though the concept of data modeling has been around for a long time, in many organizations it is interpreted differently.  According to the

Read More

How Modeling adds Value to a Data Dictionary

A well-modeled data dictionary can provide lasting value and ensure consistency of use throughout an organization for all data elements. Introduction The primary purpose organizations create and maintain a data dictionary is to standardize data content , context, and definitions to achieve consistency, reusability, and quality of the data that drives or supports the organization’s tactical and strategic business initiatives.

Read More

Business Processes and Logical Process Modeling Overview

Business process modeling is an important component of business analysis, and enables organizations to understand the processes that manage the flow of data and information. Introduction To enable an information system to provide optimum benefits, the architect, designer and programmers must thoroughly understand the data and processes needed.  An excellent way to gain this understanding and prepare to implement software

Read More

Enterprise Data Modeling

Enteprise data modeling is an essential component of strong enterprise data architecture, with subject, conceptual and enterprise logical models based on business concepts and requirements Introduction   In many organizations, there is no way to understand the scope and variety of the data captured, stored and used by the applications and business activities that need information.  An enterprise data model

Read More

Data Architecture and Packaged Implementations Part Three

Challenges to implementing data architecture with packaged applications can be overcome by addressing issues and challenges during design Introduction In a previous article I discussed some issues that a client encountered when trying to implement a packaged application. They were convinced that the business would make the decisions and IT was not going to interfere in their packaged implementation.  There

Read More

Data Architecture and Packaged Implementations Part Two

Every organization should follow a set of guidelines for implementing packaged applications to ensure architectural harmony and avoid numerous problems. Previously I discussed some issues that a client encountered when trying to implement a packaged application.  They were convinced that the business would make the decisions and IT was not going to interfere in their packaged implementation.  There was a

Read More

Use of Metadata Entities in Abstraction

Metadata supports the conditions that uses of abstraction in data modeling, ensuring lasting and scalable data models When I write on abstraction, I like to remind the reader of a very abstract painting I observed in a museum, which consisted of a white dot on a red canvas that represented a city skyline. In my first article in this series,

Read More

Data Architecture and Packaged Implementations Part One

Using package applications without a defined data architecture strategy creates silos of data, making sharing data across applications extremely difficult. Introduction I once worked with a client where the business and IT did not have a peaceful history.  The business made a strategic decision to move to packaged applications.  They were convinced that the business would make the decisions and

Read More

Contact us

  • This field is for validation purposes and should be left unchanged.

Request a free consultation
with a DMU Expert

  • This field is for validation purposes and should be left unchanged.