Published in journal "Software systems and computational methods", 2014-1 in rubric "Software for innovative information technologies", pages 125-130.
Resume: 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
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)
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)
Dynamic Data Display [Elektronnyy resurs] URL: http://dynamicdatadisplay.codeplex.com/ (data obrashcheniya: 10.04.2013)
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)
Correct link to this article:
just copy this link to clipboard