Conceptual and Logical Data Models

View previous topic View next topic Go down

Conceptual and Logical Data Models

Post  Informer30 on Tue Jul 13, 2010 3:25 pm

Hi All,

I am new to Data Modelling....please can someone tell me the difference between a conceptual model and a logical model.

Many Thanks

Informer30

Posts : 8
Join date : 2010-07-05

View user profile

Back to top Go down

Re: Conceptual and Logical Data Models

Post  BoxesAndLines on Tue Jul 13, 2010 8:03 pm

Neither are a dimensional model which is what we focus on here. ;-) Unfortunately, there is no industry standard for model classifications. Many people have written extensively on the topic though. This is just as good as any, Wikipedia definition
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Conceptual and Logical Data Models

Post  ngalemmo on Wed Jul 14, 2010 3:40 pm

Probably the closest thing to a conceptual model in dimensional design would be the Bus Matrix.

The logical/physical model would be the Star Schema.

Beyond that, the various models and what they represent is a function of the methodology you are using. The Dimensional Design methodology is completely different than ER Design methodology. Different terminology, different modeling approaches and deliverables.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Conceptual and Logical Data Models

Post  Informer30 on Wed Jul 14, 2010 4:35 pm

Thanks again....I am currently reading 'The Data Warehouse Toolkit' 2nd edition RK....and yet to cover BUS matrix.

So I assume from this book and the way DM is describled in here I can refer to conceptual model to a BUS matrix.

Please correct me if I am wrong.

Once again many thanks.

Informer30

Posts : 8
Join date : 2010-07-05

View user profile

Back to top Go down

Re: Conceptual and Logical Data Models

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum