permaculture playing cards*
The moose likes JDBC and the fly likes scalability in Database 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
Bookmark "scalability in Database " Watch "scalability in Database " New topic

scalability in Database

kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1371
What is scalability in Database ?
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336


n : the quality of being scalable.

How well a solution to some problem will work when the size of
the problem increases.

For example, a central server of some kind with ten
clients may perform adequately but with a thousand clients
it might fail to meet response time requirements. In this
case, the average response time probably scales linearly with
the number of clients, we say it has a complexity of O(N)
("order N") but there are problems with other complexities.
E.g. if we want N nodes in a network to be able to communicate
with each other, we could connect each one to a central
exchange, requiring O(N) wires or we could provide a direct
connection between each pair, requiring O(N^2) wires (the
exact number or formula is not usually so important as the
highest power of N involved).

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30130

Where did that definition come from?

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

I just lazily chucked the word in
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30130

Oh. (You may want to credit them next time)
Stefan Wagner
Ranch Hand

Joined: Jun 02, 2003
Posts: 1923

On a database, my first ideas are:
- number of rows in a table
- number of tables in the database
- number of simultanous users

An other question might be, whether a change in the hardware (bigger/ faster drives, faster network hardware, more and faster RAM, more and faster CPU(s) clustering, ...) will lead to nearly equivalent effects in the usability of the DB - faster responses, more data/ users might be managed accordingly, ...
I agree. Here's the link:
subject: scalability in Database
Similar Threads
Builing Scalable Database Applications
Maintaining scalability in servlets programming
Q on common architecture...
Question about shared DB connection
Horizontal Scaling