Library
|
Your profile |
Software systems and computational methods
Reference:
Parfenov Yu.P., Devyaterikov D.A.
Scalable and fail-safe DBaaS storage of PostgreSQL product line
// Software systems and computational methods.
2014. № 1.
P. 125-130.
URL: https://en.nbpublish.com/library_read_article.php?id=64049
Parfenov Yu.P., Devyaterikov D.A. Scalable and fail-safe DBaaS storage of PostgreSQL product lineAbstract: 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) |