Friday, September 21, 2012

Part 2: Data Model



Advanced Data Modeling and Architecture --  Table of Content


Part 1: Data Modeling Overview



2.1 : Definition of a Data Model


Model
         Representation of a set of business requirements in a standard structured framework understood by the users

Data Model
 
A collection of concepts that can be used to describe the structure of a database
         Most data models include a set of basic operations for query and updates on the database
         It is becoming more common to include concepts in the data model to specify the dynamic aspect or behavior defined operations
Data Model Instances

   Conceptual Model

   Logical Model

   Physical Model


2.2 : Data Model Types

Database Model
  A database model is a theory or specification describing how a  database is structured and used. Several such models have been suggested. Common models include
–  Flat model
–  Hierarchical model
–  Network model
–  Relational model:
–  Object-relational model
–  Dimensional Model














2.3 Data Modeling Stages & Deliverables



2.4: Main Phases of Database Design





2.5: Data Modeling In DWH Environment


























2.6: Data Modeling Approaches





2.7: Data Modeling Life Cycle





2.8: Data Models & Zachman Framework





















11 Comments:

At 8/06/2019 , Blogger markson said...

In any case, there are a few organizations that are yet to give it a shot, and advantage from it. Maybe the accompanying focuses would help them in understanding the significance of DA, and beating their very own misgivings: data science course in pune

 
At 8/20/2019 , Blogger data science course in mumbai said...

I was blown out after viewing the article which you have shared over here. So I just wanted to express my opinion on Data Analytics, as this is best trending medium to promote or to circulate the updates, happenings, knowledge sharing.. Aspirants & professionals are keeping a close eye on Data analytics course in Mumbai to equip it as their primary skill.

 
At 8/21/2019 , Blogger ravali said...

Well, the most on top staying topic is Data Science. Data science is one of the most promising technique in the growing world. I would like to add Data science training to the preference list. Out of all, Data science course in Mumbai
is making a huge difference all across the country. Thank you so much for showing your work and thank you so much for this wonderful article.

 
At 8/23/2019 , Blogger ameer said...

Just saying thanks will not just be sufficient, for the fantastic lucidity in your writing. I will instantly grab your articles to get deeper into the topic. And as the same way ExcelR also helps organisations by providing
Data science course based on practical knowledge and theoretical concepts. It offers the best value in training services combined with the support of our creative staff to provide meaningful solution that suits your learning needs.

 
At 9/05/2019 , Blogger ExcelR Solutions said...

I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
pmp certification in bangalore


 
At 9/05/2019 , Blogger seoexpert said...

Nice Post...I have learn some new information.thanks for sharing.
ExcelR data analytics course in Pune | business analytics course | data scientist course in Pune

 
At 9/07/2019 , Blogger seoexpert said...

Such a very useful article. I have learn some new information.thanks for sharing.
data scientist course in mumbai

 
At 9/16/2019 , Blogger ravali said...

Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.

Data Analytics Course in Mumbai

 
At 9/18/2019 , Blogger ravali said...

Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
Data Analytics Course in Mumbai

 
At 9/26/2019 , Blogger Manikanta said...

Such a very useful Blog. Very interesting to read this article. I have learn some new information.thanks for sharing. know more about

 
At 10/21/2019 , Blogger ravali said...

Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
ExcelR Data Analytics courses

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home