Geodesic
Development of a parallel Database Management System on the Basis of Open-Source POSTGRESQL DBMS
Vestnik Ûžno-Uralʹskogo gosudarstvennogo universiteta. Seriâ, Matematičeskoe modelirovanie i programmirovanie, no. 12 (2012), pp. 112-120 Cet article a éte moissonné depuis la source Math-Net.Ru

Voir la notice de l'article

The paper describes the architecture and implementation of PargreSQL parallel database management system (DBMS) for distributed memory multiprocessors. PargreSQL is based upon PostgreSQL open-source DBMS and exploits partitioned parallelism. The paper is devoted to development of a parallel database management system (DBMS) by means of embedding of the parallel query execution techniques based on partitioning parallelism concept into open-source PostgreSQL DBMS. The architecture and implementation principles of the parallel DBMS for cluster computing systems are described. PostgreSQL is a subsystem of PargreSQL. The necessary modifications of the PostgreSQL subsystems are described. These modifications suppose minimal changes in the source code. The changes in data structures and algorithms are encapsulated into separate source code files that are included into the original project file structure. The usage of PargreSQL is transparent for applications. It demands minimal modifications of an application's source code. PargreSQL running on one computing node works like PostgreSQL.
Keywords: parallel DBMS, partitioned parallelism, PostgreSQL. 
@article{VYURU_2012_12_a10,
     author = {C. S. Pan and M. L. Zymbler},
     title = {Development of a parallel {Database} {Management} {System} on the {Basis} of {Open-Source} {POSTGRESQL} {DBMS}},
     journal = {Vestnik \^U\v{z}no-Uralʹskogo gosudarstvennogo universiteta. Seri\^a, Matemati\v{c}eskoe modelirovanie i programmirovanie},
     pages = {112--120},
     year = {2012},
     number = {12},
     language = {ru},
     url = {http://geodesic.mathdoc.fr/item/VYURU_2012_12_a10/}
}
TY  - JOUR
AU  - C. S. Pan
AU  - M. L. Zymbler
TI  - Development of a parallel Database Management System on the Basis of Open-Source POSTGRESQL DBMS
JO  - Vestnik Ûžno-Uralʹskogo gosudarstvennogo universiteta. Seriâ, Matematičeskoe modelirovanie i programmirovanie
PY  - 2012
SP  - 112
EP  - 120
IS  - 12
UR  - http://geodesic.mathdoc.fr/item/VYURU_2012_12_a10/
LA  - ru
ID  - VYURU_2012_12_a10
ER  - 
%0 Journal Article
%A C. S. Pan
%A M. L. Zymbler
%T Development of a parallel Database Management System on the Basis of Open-Source POSTGRESQL DBMS
%J Vestnik Ûžno-Uralʹskogo gosudarstvennogo universiteta. Seriâ, Matematičeskoe modelirovanie i programmirovanie
%D 2012
%P 112-120
%N 12
%U http://geodesic.mathdoc.fr/item/VYURU_2012_12_a10/
%G ru
%F VYURU_2012_12_a10
C. S. Pan; M. L. Zymbler. Development of a parallel Database Management System on the Basis of Open-Source POSTGRESQL DBMS. Vestnik Ûžno-Uralʹskogo gosudarstvennogo universiteta. Seriâ, Matematičeskoe modelirovanie i programmirovanie, no. 12 (2012), pp. 112-120. http://geodesic.mathdoc.fr/item/VYURU_2012_12_a10/

[1] M. Stonebraker, G. Kemnitz, “The POSTGRES next-generation database management system”, Communications of the ACM, 34:10, Oct. (1991), 78–92 | DOI

[2] L. Sokolinsky, O. Axenov, S. Gutova, “Omega: The Highly Parallel Database System Project”, Proceedings of the First East-European Symposium on Advances in Database and Information Systems, ADBIS'97 (St.-Petersburg, September 2–5, 1997), v. 2, Nevsky Dialect, St.-Petersburg, 1997, 88–90

[3] Sokolinsky L. B., “Organization of Parallel Query Processing in Multiprocessor Database Machines with Hierarchical Architecture”, Programming and Computer Software, 27:6 (2001), 297–308 | DOI | Zbl

[4] N. Samokhvalov, “XML Support in PostgreSQL”, SYRCoDIS, CEUR Workshop Proceedings, 256, 2007, 1–6

[5] Y. Havinga, W. Dijkstra, A. de Keijzer, “Adding HL7 version 3 data types to PostgreSQL”, Computing Research Repository, 2010, arXiv: abs/1003.3370

[6] D. Guliato, E. V. de Melo, R. M. Rangayyan, R. C. Soares, “POSTGRESQL-IE: An Image-handling Extension for PostgreSQL”, J. of Digital Imaging, 22:2 (2009), 149–165 | DOI

[7] D. V. Levshin, A. S. Markov, “Algorithms for integrating PostgreSQL with the semantic web”, Programming and Computer Software, 35:3 (2009), 136–144 | DOI | MR

[8] R. Lee, M. Zhou, “Extending PostgreSQL to Support Distributed/Heterogeneous Query Processing”, Database Systems for Advanced Applications, Lecture Notes in Computer Science, 4443, Springer, 2007, 1086–1097 | DOI

[9] M. Paes, A. A. B. Lima, P. Valduriez, M. Mattoso, “High-Performance Query Processing of a Real-World OLAP Database with ParGRES”, VECPAR, Lecture Notes in Computer Science, 5336, Springer, 2008, 188–200 | DOI

[10] N. Kotowski, A. A. B Lima, E. Pacitti, P. Valduriez, M. Mattoso, “Parallel query processing for OLAP in grids”, Concurrency and Computation: Practice and Experience, 20:17 (2008), 2039–2048 | DOI

[11] D. J. DeWitt, J. Gray, “Parallel Database Systems: The Future of High Performance Database Systems”, Communications of the ACM, 35:6 (1992), 85–98 | DOI

[12] L. B. Sokolinsky, “Organization of Parallel Query Processing in Multiprocessor Database Machines with Hierarchical Architecture”, Programming and Computer Software, 27:6 (2001), 297–308 | DOI | Zbl

[13] A. V. Lepikhov, L. B. Sokolinsky, “Query processing in a DBMS for cluster systems”, Programming and Computer Software, 36:4 (2010), 205–215 | DOI | MR | Zbl