Abstract

MORENO ARBOLEDA, Francisco Javier; CASTRILLON CHARARI, Nataly  and  TABORDA ZULUAGA, Camilo. Parallel and distributed processing in two SGBDS: A case study. Tecnura [online]. 2017, vol.21, n.52, pp.111-129. ISSN 0123-921X.  https://doi.org/10.14483/udistrital.jour.tecnura.2017.2.a09.

Abstract Context: One of the strategies for managing large volumes of data is distributed and parallel computing. Among the tools that allow applying these characteristics are some Data Base Management Systems (DBMS), such as Oracle, DB2, and SQL Server. Method: In this paper we present a case study where we evaluate the performance of an SQL query in two of these DBMS. The evaluation is done through various forms of data distribution in a computer network with different degrees of parallelism. Results: The tests of the SQL query evidenced the performance differences between the two DBMS analyzed. However, more thorough testing and a wider variety of queries are needed. Conclusions: The differences in performance between the two DBMSs analyzed show that when evaluating this aspect, it is necessary to consider the particularities of each DBMS and the degree of parallelism of the queries.

Keywords : Databases; Parallelism; Distributed computing.

        · abstract in Spanish     · text in Spanish     · Spanish ( pdf )