All Forums Data Modeling
kannan.muthu 1 post Joined 11/13
05 Nov 2013
Understanding on Data modeling concepts

Being a beinner, wanted to learn on Data Modeling w.r.t Teradata. 
what are the appropriate materials?
Thanks
-Kannan.M

Raja_KT 1246 posts Joined 07/09
07 Nov 2013

I do care very much for novice. For modeling, you can start with why,what,when,how, which and all possible questions to yourself because we leave out what we require always :)? Usually it is business drivers, goals and strategies in the beginning. You can read books also on DWH/BI.

 

Data modeling is how you represent data to meet business requirements.It comes with experience. I feel

you may need to have work experience and get the feel of data usage, manipulation so that you can get the thick of the thing. You need to bridge the gap bettwen business, function and tehnology.

 

Teradata has many models for various industries like FSLDM, uLDM,CLDM, HCLDM etc.

 

Know how it trasnforms from Contextual, conceptual, logical, structural, physical and implementation phases in the context of business transaction, decision and business analytics.

 

Few things like entities,relationships, 1:1, 1:m, m:m,3 NF, dimensional modeling,subtype, supertype,snowflake,fact, dimensions etc you may like to read in the beginning maybe. Later I can add more for advanced knowledge.

 

This is from my side.

 

Cheers,

Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Adeel Chaudhry 773 posts Joined 04/08
24 Feb 2014

Also note .... Logical DM is database independent, hence can be learned irrespective of which database is present underlying.
 
For Physical DM, yes you need to have a good understanding of underlying RDBMS [data-types, constraints, etc.]
 
HTH!

-- If you are stuck at something .... consider it an opportunity to think anew.

rohan008 3 posts Joined 07/11
26 Mar 2014

Hi,
Please can anyone share more light on CLDM. I know that it has subject area, facets and entities but wanted to know more in depth on it.
 

Adeel Chaudhry 773 posts Joined 04/08
09 Apr 2014

You can check the details at following link:

http://www.teradata.com/logical-data-models/communications/
 
And you can surely use the 'Contact Us' feature. Am not very sure if in-depth knowledge will be available publically as you need to buy cLDM to be able to use it.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.