wood burning stoves 2.0*
The moose likes JDBC and the fly likes Builing Scalable Database Applications Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

Builing Scalable Database Applications

Raja Pratap Syamala
Greenhorn

Joined: May 06, 2005
Posts: 2
Hi,
My name is Raja and I work in a telecommunications industry. We deal with lots of data everyday that represent customer phone calls. I have been writing applications using JSP, JAVA, Servlets and Postgresql database over years now to support this business. But we reached a stage where single database cannot do all the work. So I started to split the database into multiple ones so that reports are calculated on different servers and consolidated at one place at the end of the day. Howver, now even the reports data in the database because so huge that all queries are very slow no matter how well they are written and after applying all indexes. I would like to seek a solution where some information about customers is spread across other servers and some orders of customers is spread in othe database etc. Basically splitting one database into many to make sure that all queries are fast enough and serve from different servers. Is there any good book or real world examples out there that explains about this. I have read some books but all of them talk about distributing data but
doesn't give enough examples or hints. For example, Amazon and Ebay have millions of customers. How do they make sure that customers informaiton
is spread across multiple databases? We have multiple web servers for serving customers but in the end they deal with same database. How to scale applications so that we have no issues of this sort? Please help.

Is this the right forum?
Ilja Preuss
author
Sheriff

Joined: Jul 11, 2001
Posts: 14112
Please don't cross post. Continue discussion at http://www.coderanch.com/t/202401/Performance/java/Scalability-Database


The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Builing Scalable Database Applications
 
Similar Threads
Scalability of Database
Preventing agile project becoming demo-driven
Wanted Java J2EE Consultants in Dalton,Georgia
Synchronize cached data across EJB containers
What's the point of J2EE, JBOSS, WebLogic...?