Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » ERD or STAR SCHEMA
ERD or STAR SCHEMA [message #139514] Wed, 28 September 2005 07:39 Go to next message
singhsanjay
Messages: 2
Registered: September 2005
Location: london
Junior Member
hello ,
i am designing a decision support system for the retail store, for that i need a database that will cantain all the information about the products ,sales etc.
as a usuall practice of designing a database is based on the ERD
i.e. we follows the ERD for creating the tables , but if u see the all the queries need to be answered are answered by the star schemma that means your tables would be different from the ones that were used in ERD . so
can anyone please help me out from this confussion which one should i follow for creating the datbase ERD or STAR SCHEMA.

regards
sanjay

Report message to a moderator

Re: ERD or STAR SCHEMA [message #168745 is a reply to message #139514] Fri, 21 April 2006 23:56 Go to previous message
dave33john
Messages: 3
Registered: April 2006
Junior Member
Sanjay,
You create ER models for Transaction based apps and Star Schema for Data marts or DSS apps.
For more details on thses topics, you can read this book on Star Schema design:

http://www.redbooks.ibm.com/abstracts/sg247138.html?Open



Dave

Report message to a moderator

Previous Topic: ORA-12154 (SQL+ works, web page doesn't)
Next Topic: External Web Server for OAS 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 17 23:59:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.