Evaluación del tiempo de respuesta de un geoservicio utilizando una base de datos híbrida y distribuida

Vista sencilla de ítem
dc.contributor.authorTreviño Villalobos, Marlen
dc.contributor.authorVíquez Acuña, Leonardo
dc.contributor.authorQuirós Oviedo, Rocío
dc.contributor.authorVíquez Acuña, Oscar
dc.contributor.orcidTreviño Villalobos, Marlen [0000-0002-1135-0650]
dc.contributor.orcidVíquez Acuña, Leonardo [0000-0002-0604-7219]
dc.contributor.orcidQuirós Oviedo, Rocío [0000-0003-1532-1512]
dc.contributor.orcidVíquez Acuña, Oscar [0000-0001-8896-4813]
dc.date.accessioned2024-09-13T22:00:05Z
dc.date.available2024-09-13T22:00:05Z
dc.date.issued2022-01-11
dc.description.abstractLos servicios de cartografía Web proporcionan información directamente, no sólo a los usuarios, sino también a otros programas de software que pueden consumir y producir información. Uno de los principales retos que presentan este tipo de servicios es mejorar su rendimiento. Por ello, en esta investigación se desarrolló un nuevo geoservicio integrado a GeoServer, denominado GeoToroTur con una implementación OWS de capas vectoriales que consume la información de una base de datos híbrida y distribuida que fue implementada con PostgreSQL y MongoDB haciendo uso de ToroDB para la replicación de documentos. Este geoservicio fue evaluado mediante la ejecución de consultas geográficas y de filtro de atributos descriptivos. Los resultados obtenidos permiten concluir que el geoservicio GeoToroTur tiene un menor tiempo de respuesta que Geoserver.spa
dc.description.abstractenglishWeb mapping services provide information directly to users and other software programs that can consume and produce information. One of the main challenges this type of service presents is improving its performance. Therefore, in this research, a new geoservice integrated into GeoServer was developed, called GeoToroTur, with an OWS implementation of vector layers that consumes the information from a hybrid and distributed database that was implemented with PostgreSQL and MongoDB, making use of ToroDB for document replication. This geoservice was evaluated by executing geographic and descriptive attribute filter queries. Based on the results, we can conclude that the response time for GeoToroTur is shorter than that for Geoserver.eng
dc.format.mimetypeapplication/pdfspa
dc.identifier.doihttps://doi.org/10.29375/25392115.4228
dc.identifier.instnameinstname:Universidad Autónoma de Bucaramanga UNABspa
dc.identifier.issnISSN: 1657-2831spa
dc.identifier.issne-ISSN: 2539-2115spa
dc.identifier.repourlrepourl:https://repository.unab.edu.cospa
dc.identifier.urihttp://hdl.handle.net/20.500.12749/26530
dc.language.isospaspa
dc.publisherUniversidad Autónoma de Bucaramanga UNABspa
dc.relationhttps://revistas.unab.edu.co/index.php/rcc/article/view/4228/3610spa
dc.relation.references8Kdata. (2016). ToroDB. https://www.torodb.com/
dc.relation.referencesAbdi, H., & Williams, L. J. (2010). Tukey’s honestly significant difference (HSD) test. Encyclopedia of Research Design, 3(1), 1–5.
dc.relation.referencesAgarwal, S., & Rajan, K. S. (2016). Performance analysis of MongoDB versus PostGIS/PostGreSQL databases for line intersection and point containment spatial queries. Spatial Information Research, 24(6), 671–677. https://doi.org/10.1007/s41324-016-0059-1
dc.relation.referencesAnderson, T. W., & Darling, D. A. (1952). Asymptotic Theory of Certain “Goodness of Fit” Criteria Based on Stochastic Processes. The Annals of Mathematical Statistics, 23(2), 193–212.
dc.relation.referencesAnderson, T. W., & Darling, D. A. (1954). A Test of Goodness of Fit. Journal of the American Statistical Association, 49(268).
dc.relation.referencesApache Software Foundation. (2022). Apache JMeterTM.
dc.relation.referencesApostolopoulos, K., Kakaletris, G., & Koltsida, P. (2019). Extending OGC Standards for Supporting Big-Earth Data Retrieval and Analytics. IGARSS 2019 - 2019 IEEE International Geoscience and Remote Sensing Symposium, 5559–5562. https://doi.org/10.1109/IGARSS.2019.8897888
dc.relation.referencesBai, J.-W., Wang, J.-Z., & Huang, J.-L. (2013). Spatial Query Processing on Distributed Databases. In Advances in Intelligent Systems and Applications (Vol. 1, pp. 251–260). https://doi.org/10.1007/978-3-642-35452-6_27
dc.relation.referencesChopade, Mrs. R. M., & Dhavase, N. S. (2017). Mongodb, couchbase: Performance comparison for image dataset. 2017 2nd International Conference for Convergence in Technology (I2CT), 255–258. https://doi.org/10.1109/I2CT.2017.8226131
dc.relation.referencesColorado Pérez, M. A. (2017). NoSQL: ¿es necesario ahora? . TIA, 5(2), 174–179.
dc.relation.referencesDíaz, A. (2009). Diseño estadístico de experimentos (Segunda). Universidad de Antioquia.
dc.relation.referencesDíaz, A., & Granados, A. (2018). Analizador sintáctico-semántico para la enseñanza de la programación de software. Revista Tecnocientífica URU, 14, 11–18.
dc.relation.referencesDíaz, F. J., Banchoff Tzancoff, C. M., Rodríguez, A. S., & Soria, V. (2008). Usando Jmeter para pruebas de rendimiento. XIV Congreso Argentino de Ciencias de La Computación.
dc.relation.referencesEuropean Parliament. (2007). Directive 2007/2/EC of the European Parliament and of the Council of 14 March 2007 establishing an Infrastructure for Spatial Information in the European Community (INSPIRE).
dc.relation.referencesGarcia, R., de Castro, J. P., Verd, E., Jess, M., & Mara, L. (2012). Web Map Tile Services for Spatial Data Infrastructures: Management and Optimization. In Cartography - A Tool for Spatial Analysis (pp. 26–48). InTech. https://doi.org/10.5772/46129
dc.relation.referencesGastwirth, J. L., Gel, Y. R., & Miao, W. (2009). The Impact of Levene’s Test of Equality of Variances on Statistical Theory and Practice. Statistical Science, 24(3), 343–360. https://doi.org/10.1214/09-STS301
dc.relation.referencesGoyal, S., Srivastava, P. P., & Kumar, A. (2015). An overview of hybrid databases. 2015 International Conference on Green Computing and Internet of Things (ICGCIoT), 285–288. https://doi.org/10.1109/ICGCIoT.2015.7380474
dc.relation.referencesGui, Z., Cao, J., Liu, X., Cheng, X., & Wu, H. (2016). Global-Scale Resource Survey and Performance Monitoring of Public OGC Web Map Services. ISPRS International Journal of Geo-Information, 5(6), 88. https://doi.org/10.3390/ijgi5060088
dc.relation.referencesGunawan, R., Rahmatulloh, A., & Darmawan, I. (2019). Performance Evaluation of Query Response Time in The Document Stored NoSQL Database. 2019 16th International Conference on Quality in Research (QIR): International Symposium on Electrical and Computer Engineering, 1–6. https://doi.org/10.1109/QIR.2019.8898035
dc.relation.referencesHerrera-Ramírez, J. A., Treviño-Villalobos, M., & Víquez-Acuña, L. (2021). Hybrid storage engine for geospatial data using NoSQL and SQL paradigms. Revista Tecnología En Marcha, 34(1), 40–54. https://doi.org/10.18845/tm.v34i1.4822
dc.relation.referencesHuang, C.-Y., & Chang, H. (2016). GeoWeb Crawler: An Extensible and Scalable Web Crawling Framework for Discovering Geospatial Web Resources. ISPRS International Journal of Geo-Information, 5(8), 136. https://doi.org/10.3390/ijgi5080136
dc.relation.referencesInstituto Tecnológico de Costa Rica. (2022). IDE Región Huetar Norte. https://www.tec.ac.cr/
dc.relation.referencesInternet Engineering Task Force. (2016). The GeoJSON Format. https://www.rfc-editor.org/rfc/rfc7946
dc.relation.referencesKepka, M., & Ježek, J. (2013). Web client for PostGIS—the concept and implementation. Geoinformatics FCE CTU, 11, 63–76. https://doi.org/10.14311/gi.11.5
dc.relation.referencesKumar, K. B. S., Srividya, & Mohanavalli, S. (2017). A performance comparison of document oriented NoSQL databases. 2017 International Conference on Computer, Communication and Signal Processing (ICCCSP), 1–6. https://doi.org/10.1109/ICCCSP.2017.7944071
dc.relation.referencesLoechel, A., & Schmid, S. (2013). Comparison of different caching techniques for high-performance web map services. International Journal of Spatial Data Infrastructures Research, 8, 43–73.
dc.relation.referencesMiao, L., Jing Guo, Wenchao Cheng, & Zhou, Y. (2016). A novel model to support OGC Web Services semantic search using OWL-S. 2016 24th International Conference on Geoinformatics, 1–4. https://doi.org/10.1109/GEOINFORMATICS.2016.7578973
dc.relation.referencesMongoDB. (2015). The MongoDB 3.4 Manual. https://www.mongodb.com/docs/v3.4/
dc.relation.referencesMoreno Jiménez, A. (2004). Nuevas tecnologías de la información y revalorización del conocimiento geográfico. Geo Crítica / Scripta Nova. Revista Electrónica de Geografía y Ciencias Sociales, VIII(170). http://www.ub.edu/geocrit/sn/sn-170-62.htm
dc.relation.referencesOASIS. (2005). Quality Model for Web Services.
dc.relation.referencesOpen Geospatial Consortium. (2000). OpenGIS® Web Map Server Interface Implementation Specification. Revision 1.0.0.
dc.relation.referencesOpen Source Geospatial Foundation. (2022). Geoserver. https://geoserver.org/
dc.relation.referencesPatel, B., Parikh, J., & Shah, R. (2014). A review paper on comparison of SQL performance analyzer tools: Apache JMeter and HP LoadRunner. International Journal of Current Engineering and Technology, 4(5), 3642–3645.
dc.relation.referencesPOSTGIS. (2022). About PostGIS. https://postgis.net/
dc.relation.referencesPramukantoro, E. S., Primanita Kartikasari, D., & Siregar, R. A. (2019). Performance Evaluation of MongoDB, Cassandra, and HBase for Heterogenous IoT Data Storage. 2019 2nd International Conference on Applied Information Technology and Innovation (ICAITI), 203–206. https://doi.org/10.1109/ICAITI48442.2019.8982159
dc.relation.referencesPuangsaijai, W., & Puntheeranurak, S. (2017). A comparative study of relational database and key-value database for big data applications. 2017 International Electrical Engineering Congress (IEECON), 1–4. https://doi.org/10.1109/IEECON.2017.8075813
dc.relation.referencesQGIS. (2022). Bienvenido Al Proyecto QGIS! https://www.qgis.org/es/site/
dc.relation.referencesRaymond, M., & Rousset, F. (1995). An exact test for population differentiation. Evolution, 49(6), 1280–1283. https://doi.org/10.1111/j.1558-5646.1995.tb04456.x
dc.relation.referencesRůžička, J. (2016). Comparing speed of Web Map Service with GeoServer on ESRI Shapefile and PostGIS. Geoinformatics FCE CTU, 15(1), 3–9. https://doi.org/10.14311/gi.15.1.1
dc.relation.referencesSani, A., & Rinner, C. (2011). A Scalable GeoWeb Tool for Argumentation Mapping. GEOMATICA, 65(2), 145–156. https://doi.org/10.5623/cig2011-023
dc.relation.referencesSchmid, S., Galicz, E., & Reinhardt, W. (2015). WMS performance of selected SQL and NoSQL databases. International Conference on Military Technologies (ICMT) 2015, 1–6. https://doi.org/10.1109/MILTECHS.2015.7153736
dc.relation.referencesSchmid, S., & Reinhardt, W. (2015). Towards a general evaluation procedure for Geo Web Services. Proceedings of the ICC 2015 International Cartographic Conference, 23–28.
dc.relation.referencesShen, L., Duan, W., Ren, Y., & Yang, C. (2010). Management Service on WMS/WFS services. 2010 18th International Conference on Geoinformatics, 1–5. https://doi.org/10.1109/GEOINFORMATICS.2010.5567481
dc.relation.referencesTerrádez, M., & Juan, A. A. (2003). Análisis de la varianza (ANOVA). http://www.uoc.edu/in3/emath/docs/ANOVA.Pdf
dc.relation.referencesThe PostgreSQL Global Development Group. (2022). PostgreSQL: The World’s Most Advanced Open Source Relational Database. https://www.postgresql.org/
dc.relation.referencesTreviño Villalobos, M., Víquez Acuña, L., & Quirós Oviedo, R. (2020). Comparison of the Response Times of MongoDB and PostgreSQL According to Type of Query in Geographical Databases. Computación y Sistemas, 24(4), 1461–1469. https://doi.org/10.13053/cys-24-4-3292
dc.relation.referencesTrevino Villalobos, M., Viquez Acuna, L., Quiros Oviedo, R., & Esquivel Vega, G. (2018). Una comparación de rendimiento entre MongoDB, ArangoDB y CouchBase para la operación lectura sobre bases de datos geográficas [Not available in English]. 2018 IEEE 38th Central America and Panama Convention (CONCAPAN XXXVIII), 1–6. https://doi.org/10.1109/CONCAPAN.2018.8596387
dc.relation.referencesTreviño-Villalobos, M., Víquez-Acuña, L., Quirós-Oviedo, R., & Esquivel-Vega, G. (2019). Una comparación de rendimiento entre bases de datos NoSQL: MongoDB y ArangoDB. Revista Tecnología En Marcha. https://doi.org/10.18845/tm.v32i6.4223
dc.relation.referencesVeenendaal, B., Brovelli, M. A., & Li, S. (2017). Review of Web Mapping: Eras, Trends and Directions. ISPRS International Journal of Geo-Information, 6(10), 317. https://doi.org/10.3390/ijgi6100317
dc.relation.referencesWenjue, J., Yumin, C., & Jianya, G. (2004). Implementation of OGC web map service based on web service. Geo-Spatial Information Science, 7(2), 148–152. https://doi.org/10.1007/BF02826653
dc.relation.referencesWu, C., Zhu, Q., Zhang, Y., Du, Z., Ye, X., Qin, H., & Zhou, Y. (2017). A NoSQL–SQL Hybrid Organization and Management Approach for Real-Time Geospatial Data: A Case Study of Public Security Video Surveillance. ISPRS International Journal of Geo-Information, 6(1), 21. https://doi.org/10.3390/ijgi6010021
dc.relation.referencesYang, P., Cao, Y., & Evans, J. (2007). Web Map Server Performance and Client Design Principles. GIScience & Remote Sensing, 44(4), 320–333. https://doi.org/10.2747/1548-1603.44.4.320
dc.relation.referencesYuan, J., Yue, P., & ong, J. (2009). Integration of geospatial Web services and Web portal technologies for geospatial Information sharing and processing. 2009 17th International Conference on Geoinformatics, 1–4. https://doi.org/10.1109/GEOINFORMATICS.2009.5293518
dc.relation.referencesZhang, X., Song, W., & Liu, L. (2014). An implementation approach to store GIS spatial data on NoSQL database. 2014 22nd International Conference on Geoinformatics, 1–5. https://doi.org/10.1109/GEOINFORMATICS.2014.6950846
dc.relation.referencesZhang, Y., Li, D., & Zhu, Z. (2008). A Server Side Caching System for Efficient Web Map Services. 2008 International Conference on Embedded Software and Systems Symposia, 32–37. https://doi.org/10.1109/ICESS.Symposia.2008.39
dc.relation.referencesZhao, F., Zhang, J., & Cao, D. (2006). Dynamic Web Map Service for Web Publishing System of Mass Remote Sensing Images. 2006 IEEE International Symposium on Geoscience and Remote Sensing, 858–860. https://doi.org/10.1109/IGARSS.2006.220
dc.relation.urihttps://revistas.unab.edu.co/index.php/rcc/issue/view/282spa
dc.rights.accessrightsinfo:eu-repo/semantics/openAccessspa
dc.sourceVol. 23 Núm. 1 (2022): Revista Colombiana de Computación (Enero-Junio); 34-43spa
dc.subjectBase de datosspa
dc.subjectGeoserviciospa
dc.subjectTiempo de respuestaspa
dc.subjectSQLspa
dc.subjectNoSQLspa
dc.subject.keywordsDatabaseeng
dc.subject.keywordsGeoserviceeng
dc.subject.keywordsResponse timeeng
dc.subject.keywordsSQLeng
dc.subject.keywordsNoSQLeng
dc.titleEvaluación del tiempo de respuesta de un geoservicio utilizando una base de datos híbrida y distribuidaspa
dc.title.translatedEvaluation of the response time of a geoservice using a hybrid and distributed databaseeng
dc.type.coarhttp://purl.org/coar/resource_type/c_2df8fbb1
dc.type.coarversionhttp://purl.org/coar/version/c_ab4af688f83e57aaspa
dc.type.driverinfo:eu-repo/semantics/article
dc.type.hasversioninfo:eu-repo/semantics/publishedVersion
dc.type.localArtículospa
dc.type.redcolhttp://purl.org/redcol/resource_type/ART

Archivos

Bloque original

Mostrando 1 - 1 de 1
Miniatura
Nombre:
Artículo.pdf
Tamaño:
595.57 KB
Formato:
Adobe Portable Document Format
Descripción:
Artículo
Descargar

Bloque de licencias

Mostrando 1 - 1 de 1
Miniatura
Nombre:
license.txt
Tamaño:
347 B
Formato:
Item-specific license agreed upon to submission
Descripción:
Descargar

Colecciones

Revista Colombiana de Computación