Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Difference between Logical Data Modelling & ERD

4 posters

Go down

Difference between Logical Data Modelling & ERD Empty Difference between Logical Data Modelling & ERD

Post  sriramhariharan Sat Jan 15, 2011 11:38 pm

What is difference between Logical data Modelling (LDM) & ER ?

Whenever we ask LDM , the customer gives ER diagram.


sriramhariharan

Posts : 1
Join date : 2011-01-15

Back to top Go down

Difference between Logical Data Modelling & ERD Empty Re: Difference between Logical Data Modelling & ERD

Post  ngalemmo Sun Jan 16, 2011 2:08 am

The difference is between a logical model and a physical model. Both are presented as ER diagrams.

A logical model is slightly more abstract than a physical model. A physical model represents exactly what is implemented in a database... table and column names are as they exist in the schema, you define indexes, specify column datatypes and sizes, contraints, tablespaces, partitions and all the other requirements to actually define the database. A logical model shows entities, attributes, keys and relationships. Names are usually more free-form and descriptive.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Difference between Logical Data Modelling & ERD Empty Re: Difference between Logical Data Modelling & ERD

Post  BoxesAndLines Sun Jan 16, 2011 12:15 pm

When you ask for a LDM, what are you expecting?
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Difference between Logical Data Modelling & ERD Empty Re: Difference between Logical Data Modelling & ERD

Post  Jeff Smith Mon Jan 17, 2011 6:48 pm

Don't "conceptual models" sometimes get confused with "Logical Models".

A conceptual model might have a fact table with the dimension tables but without any column names. Some of the dimensions might later be split into 2 or combined. It's almost a graphic presentation of the BUS Architecture.

The logical model might have the column names in lay terms - "Group Identifier" instead of group_id. There may not be difference between a view and a table.

And the Physical Model is what the database physically looks like.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

Difference between Logical Data Modelling & ERD Empty Re: Difference between Logical Data Modelling & ERD

Post  ngalemmo Tue Jan 18, 2011 3:03 pm

Don't "conceptual models" sometimes get confused with "Logical Models".

Good point. Frankly, I'm confused most of the time. Maybe there needs to be a model model.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Difference between Logical Data Modelling & ERD Empty Re: Difference between Logical Data Modelling & ERD

Post  BoxesAndLines Tue Jan 18, 2011 5:19 pm

To me, there is no logical dimensional model. Conceptual and logical models are normalized data structures used to define data dependencies. Unfortunately, there is no consensus on what goes into a conceptual model other than it is less than the logical data model.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Difference between Logical Data Modelling & ERD Empty Re: Difference between Logical Data Modelling & ERD

Post  Jeff Smith Wed Jan 19, 2011 1:14 pm

How's this...

A Conceptual Model is what you on a scrap piece of paper.

A Logical Model is what you do in Excel.

And the Physical Model is what you get when you use Visio to reverse engineer the database.

Actually, a variation on the conceptual model comes in handy when setting up the reporting tools.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

Difference between Logical Data Modelling & ERD Empty Re: Difference between Logical Data Modelling & ERD

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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