• Post Reply 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

scalability in Database

 
Ranch Hand
Posts: 1491
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is scalability in Database ?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


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

 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Paul,
Where did that definition come from?
 
Paul Sturrock
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I just lazily chucked the word in dictionary.com.
 
Jeanne Boyarsky
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oh. (You may want to credit them next time)
 
Ranch Hand
Posts: 1923
Scala Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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, ...
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic