Abstract
Once you have designed your database, especially when supporting a web- or cloud-based solution, you need to be sure that it can grow if the business that the application supports is successful. Scalability is about ensuring that you can cope with many concurrent users, or huge amounts of data, or both. This is becoming ever more important in the era of Big Data. This chapter is in two main parts. We first examine strategies for coping with increases in the number of users of a system, and then look at the alternative approaches to handling the growth of data being stored and queried. As always there are balances to be found. Some scalability solutions can cause performance issues, and can be quite expensive, for example. We look at the difference between standalone, client/server, and distributed approaches to scalability, and explore the design constraints that each approach imposes upon database professionals. We also review the difference between horizontal and vertical scaling, and the Shared Nothing or Shared Everything approaches.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Dunmall J, Clarke K (2003) Real-world load testing tips to avoid bottlenecks when your web app goes live. http://msdn.microsoft.com/en-us/magazine/cc188783.aspx
Hill R, Hirsch L, Lake P, Moshiri S (2013) Guide to cloud computing: principles and practice. Springer, London
Hoskins J, Frank B (2002) Exploring IBM EServer ZSeries and S/390 servers: see why IBM’s redesigned mainframe computer family has become more popular than ever! Maximum Press, 464 pages
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag London
About this chapter
Cite this chapter
Lake, P., Crowther, P. (2013). Database Scalability. In: Concise Guide to Databases. Undergraduate Topics in Computer Science. Springer, London. https://doi.org/10.1007/978-1-4471-5601-7_9
Download citation
DOI: https://doi.org/10.1007/978-1-4471-5601-7_9
Publisher Name: Springer, London
Print ISBN: 978-1-4471-5600-0
Online ISBN: 978-1-4471-5601-7
eBook Packages: Computer ScienceComputer Science (R0)