This week's book giveaways are in the AI and JavaScript forums.
We're giving away four copies each of GANs in Action and WebAssembly in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of GANs in ActionE this week in the AI forum
or WebAssembly in Action in the JavaScript forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

Builing Scalable Database Applications

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Report post to moderator
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?
 
author
Posts: 14112
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please don't cross post. Continue discussion at https://coderanch.com/t/202401/Performance/java/Scalability-Database
 
For my next feat, I will require a volunteer from the audience! Perhaps this tiny ad?
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!