SQL Server Performance Forum – Threads Archive

data

what is the difference between a logical data model and a logical database design?

also, is this the normal flow? Data Modeler creates:
Conceptual Data Model
Logical Data Model
Physical Data Model DBA creates:
Conceptual Database Design
Logical Database Design
Physical Database Design if so, is there a good document that describes how to go through each step(high level) and the transitions between each step?

Try This. http://www.utexas.edu/its/windows/database/datamodeling/ Thanks,
Sandy

Logical data model represents all the business entities involved in the scope of your application. Logical database design includes physical data model that should be created after the logical model has been reviewed and discussed thoroughly with business owners and analysts. The physical model includes the primary and foreign keys, triggers, other ways of enforcing referential integrity, datatypes, indexes, database files and filegroups, and more. http://www.sql-server-performance.com/pro_sql_server_2000_database_design_review.asp &http://www.sqlteam.com/item.asp?ItemID=122 about data modelling. And also search MS Press for suitable books information.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

To add to the confusion [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />], you might want to have a look at http://www.inconcept.com/JCM/index.html</a> or search the archives of comp.databases.theory ———————– –Frank http://www.insidesql.de</a> ———————–

"The physical model includes the primary and foreign keys, triggers, other ways of enforcing referential integrity, datatypes, indexes, database files and filegroups, and more" – to me this describes the physical database "design". Please correct me if I am wrong. I am getting the idea that these terms are used loosely in this business.
I have yet to find a document that explains the difference between the below.
Can anyone here do that w/o giving a link to another document, please.
Conceptual Data Model
Logical Data Model
Physical Data Model
Conceptual Database Design
Logical Database Design
Physical Database Design

One of this Texas Uni has got information you’re looking:
http://www.utexas.edu/its/windows/database/datamodeling/dm/overview.html HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

excellent document. thx. but it does not answer one important question. A data modeler (usually) creates the conceptual, logical & physical data models. The physical data model is the one used by the DBA to design the database schema. At this point this is the logical(?) database design. Which turns into the physical database design eventually(when indexes, triggers, etc. are added).
would this be a 100% correct?

Partially correct, the physical database desing will depends upon the logical design in turn as a physical data model. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>