. Data Architecture Archives - EWSOLUTIONS

Data Management University

Teaching Data Management Since 1998

Welcome to DMU!

Search DMU Library

20 Oct, 2016

The Power of Abstraction in Data Modeling

20 October, 2016
Steve Hoberman
Enterprise Data Modeling
New

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 as a squinted or twisted my head, I just

698 views

0 comments

20 Oct, 2016

Logical and Physical Data Modeling Overview

20 October, 2016
Anne Marie Smith, Ph.D.
Data Architecture

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 differe

1,216 views

0 comments

1 Apr, 2010

How Modeling adds Value to a Data Dictionary

01 April, 2010
David Dichmann
Best Practices

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 str

766 views

0 comments

20 Oct, 2015

Business Processes and Logical Process Modeling Overview

20 October, 2015
Anne Marie Smith, Ph.D.
Data Architecture

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 prep

375 views

0 comments

20 Mar, 2011

Enterprise Data Modeling

20 March, 2011
Anne Marie Smith, Ph.D.
Data Architecture

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 ent

506 views

0 comments

1 Oct, 2003

Data Architecture and Packaged Implementations Part Three

01 October, 2003
Daniel Roth
Best Practices

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 implementatio

241 views

0 comments

1 Jul, 2003

Data Architecture and Packaged Implementations Part Two

01 July, 2003
Daniel Roth
Best Practices

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.  Th

498 views

0 comments

1 Oct, 2002

Use of Metadata Entities in Abstraction

01 October, 2002
Steve Hoberman
Enterprise Data Modeling

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, I concluded that abstraction is a tool that lets an artis

235 views

0 comments

1 Oct, 2002

Data Architecture and Packaged Implementations Part One

01 October, 2002
Daniel Roth
Best Practices

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

272 views

0 comments

1 Jul, 2002

Physical Data Modeling

01 July, 2002
Daniel Roth
Logical & Physical Data Modeling

Physical data models should follow the logical data model as closely as possible, while adding the optimizing items to conform to a specific database and platform. Introduction Physical data modeling involves transforming the logical model from a purely business design to a design optimized to run in a particular environment.  Things that must be considered when doing physical modeling include th

212 views

0 comments

View all podcasts

View Our Podcasts

DMU provides regular podcasts of our best webinars, expert speaking events and our 3 minute Data Management Moment teaching videos.

The First Steps in Building a World Class Data Management Program

Date : 18 Jan 2018, Time : 1:00 PM, USA/Chicago
Presenter:David Marco
Registration Opens December 11, 2017.

During this webinar international speaker and bestselling author, David Marco will walk us through the key first steps needed in building a world-class data management program.

View Our Data Management Moments

Watch our 2 - 3 minute Data Management Moment teaching videos to learn the very finest data management best practices.

WordPress Image Lightbox