Translate this page:
Please select your language to translate the article


You can just close the window to don't translate
Library
Your profile

Back to contents

Software systems and computational methods
Reference:

Parfenov Yu.P., Devyaterikov D.A. Scalable and fail-safe DBaaS storage of PostgreSQL product line

Abstract: the global trend in software development is focused on the cloud-based SaaSprojects. The traditional database servers are replaced by Database as a Service (DBaaS) in order to store the data in cloud-based application. The service of data storage provides transparent access to the database management system (DBMS) relieve the user from many tasks of data administration. The market offers many solutions for cloud file storage of corporate data. However, the relational databases are still in demand for solving the tasks of business automation and the use of SaaS-applications in small and medium business highlights the product’s cost lowering and leads to the choice in favor of open-source DBMS. Among such products the RDBMS PostgeSQL has enhanced functionality. This article is devoted to the ways of building a scalable and fail-safe DBaaS storage of PostgreSQL product line.


Keywords:

databases, file storage, corporate data, streaming database replication, operating data reserve, cluster, user, reliability, load testing, transaction


This article can be downloaded freely in PDF format for reading. Download article


References
1. The Transaction Processing Performance Council [Elektronnyy resurs] //TPC-B measures throughput in terms of how many transactions per second a system can perform. [sayt] URL: http://www.tpc.org/tpcb/default.asp (data obrashcheniya: 14.03.2013)
2. PostgreSQL: Documentation: Manuals: [Elektronnyy resurs] // Appendix F. Additional Supplied Modules F.26. pgbench [sayt] URL: http://www.postgresql.org/docs/devel/static/pgbench.html (data obrashcheniya: 9.04.2013)
3. Dynamic Data Display [Elektronnyy resurs] URL: http://dynamicdatadisplay.codeplex.com/ (data obrashcheniya: 10.04.2013)
4. Cornell University Operations Research and Industrial Engineering [Elektronnyy resurs] // Penalized regression splines URL: http://ecommons.library.cornell.edu/bitstream/1813/9131/1/TR001249.pdf (data obrashcheniya: 10.04.2013)