Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Logical data model: "heterogeneous" and "homogeneous" subtypes
Previous Previous
 
Next Next
New Post 12/15/2011 11:43 AM
User is offline AdamITBSA
12 posts
10th Level Poster


Logical data model: "heterogeneous" and "homogeneous" subtypes 

I'm reviewing a very, very sexy data model... it's huge, it's convoluted, and it seems very well put together.

The original author of the logical model used a method of typing objects that I haven't seen before... objects were formally defined as "heterogeneous subtypes" or "homogeneous subtypes."

This methodology of subtyping makes great sense -- what interests me is the process behind coming up with this in the model.  I haven't done major data modelling, and haven't seen things specifically modelled as subtypes this way... but I'd like to learn more.

Could someone recommend a book or resource that might explain these sorts of concepts further?  Specifically with regards to best practices for creating large logical data models.

 
New Post 1/10/2012 1:16 PM
User is offline Tony Markos
493 posts
5th Level Poster


Re: Logical data model: "heterogeneous" and "homogeneous" subtypes 

Hi:

If the data model is truely logical, then it is without implementation considerations.  "Objects"   and "Subtypes" sound like  implementation considerations.   If, especially on larger scale data modeling efforts, one mixes in logic and implementation, the result is not very pretty.   For an understanding of what a true logical data model looks like, I suggest reviewing Entity Relationship Diagrams (ERD).

Tony

 

 
New Post 1/12/2012 12:16 PM
User is offline Sandy
74 posts
8th Level Poster




Re: Logical data model: "heterogeneous" and "homogeneous" subtypes 

The 'supertype' and 'subtype' concepts are standard patterns in logical data modeling (and these are definitely logical relationships, not physical - although there are lots of interesting discussions on how to implement these types of relationships when creating the physical model...).

A couple of introductory articles sites that you might find interesting to start are:

Basic explanation of types, supertypes, subtypes, and categories:  http://www.packtpub.com/article/type-subtype-category

A good introductory guide to data modeling:  http://www.liberty.edu/media/1414/[6330]ERDDataModeling.pdf

A comparison of different modeling techniques (which may be more detailed than you're looking for, but at the end there are some good practical tips for creating a data model that someone else can easily read & interpret...): http://essentialstrategies.com/documents/comparison.pdf

Sandy

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Logical data model: "heterogeneous" and "homogeneous" subtypes

Community Blog - Latest Posts

I have always loved cooking. I learned from my Grandma June and her kitchen was her sanctuary, a small, warm sunlit space filled with jars of spices, stacks of cookbooks, and the comforting smell of something always on the stove or baking in the oven. Grandma June was as great a cook as she was a teacher to me. She never followed a recipe “to...
Now, I know, I don’t know what kind of new intro BPO may require, but at least I can promise you upfront that I have something different to say about Business Process Outsourcing or simply BPO. What is it? This hasn't been a call center job or a sales job as we all think. It is a mammoth profile, and firms are grappling to ge...
Leveraging Blockchain Technology for Enhanced Data Security in Business Operations
In an age where data breaches and cyberattacks are becoming more frequent and sophisticated, businesses are searching for robust solutions to safeguard their data. Blockchain technology has emerged as a promising tool in this quest, offering a way to secure data with unparalleled reliability. Although initially known for powering cryptocurrencies l...

 






 

Copyright 2006-2025 by Modern Analyst Media LLC