Home » Developer & Programmer » Designer » Database Design
Database Design [message #102109] Fri, 15 February 2002 15:34 Go to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Hi all,
I have to find out and suggest about Databse design for a retail Chain.
Each store will have apprximately around 3 Gig data. If the Chain has 300 stores , the total databse size may be almost a terabyte. What is better in this case, a big centralized data or distributed databases(each store having its own databse) in a hosted environment?. Can anybody please throw some light? Also is there any scalability issues for an Oracle OLTP databse with Terabyte?
thanks
Mike
Re: Database Design [message #102125 is a reply to message #102109] Wed, 20 February 2002 11:32 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
"Oracle Design" by O'Reilly covers this. The book is Oracle 7.x era but still all very relevant. Concise chapters will give you the info you need. Price search on www.addall.com
Previous Topic: Entity Relationship Diagram
Next Topic: Cannot find template in designer
Goto Forum:
  


Current Time: Fri Mar 29 02:46:37 CDT 2024