File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "scalability in Database " Watch "scalability in Database " New topic
Author

scalability in Database

kri shan
Ranch Hand

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

Joined: Apr 14, 2004
Posts: 10336


scalability

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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30917
    
158

Paul,
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
Bartender

Joined: Apr 14, 2004
Posts: 10336

I just lazily chucked the word in dictionary.com.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30917
    
158

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, ...


http://home.arcor.de/hirnstrom/bewerbung
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: scalability in Database