Analyzing Performance of Geographic Databases to Enhance Social Analysis in Map Applications
Resumo
Context: Social mapping applications are essential tools for understanding regional needs. In addition to physical geography, these maps integrate data on infrastructure, activities, and social demands— visualizing regions, points of interest, and relevant layers. This approach provides a clear and comprehensive view to support business, government, and social decisions. Problem: Managing social mapping data presents challenges, especially when storing sets of coordinates. This limits specialized database functions, impacting application performance in advanced geospatial functions. In particular, it is difficult to define which technologies are most appropriate to handle such data. Solution: We propose to use geographic databases such as PostgreSQL and MySQL Spatial. To do this, we propose to identify which functionalities are facilitated by these two technologies and compare their performance in executing these functionalities. IS Theory: Guided by the sociotechnical theory of Innovations Theory, this study examines how IS technologies interact in social contexts. Method: This study used a qualitative survey of professionals to propose functionalities considered useful for social analysis and an empirical experiment on the performance of the functionalities using PostGIS and MySQL Spatial databases. Results: Using a geographic database improved data processing, especially for large data. PostGIS showed better scalability and faster response times than MySQL Spatial as data volumes increased. Contributions and Impact on the IS field: This research improves the handling of geospatial data in IS, offering a practical solution to optimize queries, benefiting academia and industry.
Referências
Natalia Andrienko, Gennady Andrienko, Hans Voss, Fatima Bernardo, Joana Hipolito, and Ursula Kretchmer. 2002. Testing the usability of interactive maps in CommonGIS. Cartography and Geographic Information Science 29, 4 (2002), 325–342.
Garrett Camp and Travis Kalanick. 2009. UBER. [link]. Accessed: 2024-06-08.
Oracle Corporation. 2024. MySQL 8.4 Documentation: Spatial Types. [link] Acesso em: 16 nov. 2024.
Autores da Pesquisa. 2025. Formulário da Pesquisa de Funcionalidades relevantes. [link].
R Elmasri, Shamkant B Navathe, R Elmasri, and SB Navathe. 2015. Fundamentals of Database Systems
Taylor Otwell et al. 2024. Laravel: The PHP Framework forWeb Artisans. Disponível em: [link]. Acesso em: 18 nov. 2024..
Django Software Foundation. 2024. Django: The Web Framework for Perfectionists with Deadlines. Disponível em: [link]. Acesso em: 18 nov. 2024..
Django Software Foundation. 2024. GeoDjango: GIS Extensions for Django. Disponível em: [link]. Acesso em: 18 nov. 2024..
Python Software Foundation. 2024. Python: Programming Language. Disponível em: [link]. Acesso em: 18 nov. 2024..
Konrad Fraczek and Malgorzata Plechawska-Wojcik. 2017. Comparative Analysis of Relational and Non-relational Databases in the Context of Performance in Web Applications. 153–164. DOI: 10.1007/978-3-319-58274-0_13
PostgreSQL Global Development Group. 1997. POSTGRESQL. [link]. Accessed: 2024-06-13.
PostgreSQL Global Development Group. 2024. PostGIS. [link]. Accessed: 2024-06-08.
The PHP Group. 2024. PHP: Hypertext Preprocessor. Disponível em: [link]. Acesso em: 18 nov. 2024..
Joao Victor Guinelli, André de Souza Rocha, Carlos Eduardo Pantoja, and Ricardo Choren. 2014. Uma metodologia para apoio ao projeto de banco de dados geográficos utilizando a mda. In Anais do X Simpósio Brasileiro de Sistemas de Informação. SBC, 161–171.
IETF GeoJSON Working Group. 2016. RFC 7946: The GeoJSON Format. [link] Accessed: 2024-11-16.
Kamil Kolonko. 2018. Performance comparison of the most popular relational and non-relational database management systems. [link]
Anderson Resende Lamas, Jugurta Lisboa Filho, Ronoel Botelho Júnior, and Alcione Oliveira. 2009. Ontologias e Web Services aplicados ao desenvolvimento de Sistemas de Informação Geográfica Móveis Sensíveis ao Contexto. In Anais do V Simpósio Brasileiro de Sistemas de Informação. SBC, 157–168.
John R Logan. 2012. Making a place for space: Spatial thinking in social science. Annual review of sociology 38 (2012).
Paul A. Longley, Michael F. Goodchild, David J. Maguire, and David W. Rhind. 2015. Geographic Information Science and Systems (4th ed.). Wiley, Hoboken, NJ.
Felipe Machado, Gabriel Hipólito, Fábio Borges, and Felipe Menezes. 2024. MEU LAR DE VOLTA. [link]. Accessed: 2024-06-08.
Enid Mumford. 2000. A Socio-Technical Approach to Systems Design. Requirements Engineering 5, 2 (2000), 125–133. DOI: 10.1007/PL00010345
AB MySQL. 2001. MySQL.
André Avelino Da Silva Neto, Paulo Alves De Melo, Estêvão Barbosa, and Marcelle Mota. 2023. Usability Considerations in Social Mobile Maps to Encourage Social Change. In Anais do XXII Simpósio Brasileiro sobre Fatores Humanos em Sistemas Computacionais. SBC.
Thanh Nguyen. 2009. Indexing PostGIS databases and spatial Query performance evaluations. International Journal of Geoinformatics 5 (09 2009), 1–9.
Thanh Thi Nguyen. 2009. Indexing PostGIS databases and spatial Query performance evaluations. International Journal of Geoinformatics 5, 3 (2009), 1.
João Gabriel Pozzobon dos Santos. 2023. FLUSS - Monitor de Enchentes. [link]. Accessed: 2024-06-08.
Nohemi Ramirez Aranda, Jeroen De Waegemaeker, Viktor Venhorst, Wim Leendertse, Eva Kerselaers, and Nico Van de Weghe. 2021. Point, polygon, or marker? In search of the best geographic entity for mapping cultural ecosystem services using the online public participation geographic information systems tool,“My Green Place”. Cartography and Geographic Information Science 48, 6 (2021), 491–511.
Philippe Rigaux, Michel Scholl, and Agnes Voisard. 2001. Spatial databases: with application to GIS. Elsevier.
Deepika Shukla, Chirag Shivnani, and Darshit Shah. 2016. Comparing Oracle Spatial and Postgres PostGIS. International Journal of Computer Science and Communication (IJCSC) 7, 2 (2016). [link]
Patrick Sigrist, Eduardo Baer, Victor Júnior, Felipe Fioravante, and Simone Alves de Carvalho. 2011. IFOOD. [link]. Accessed: 2024-06-08.
Brandon Oviedo Sánchez, Emmanuel Alfaro Brenes, Isaac Mena López, Adrián Amador Ávila, Diego Munguía Molina, and Jaime Gutiérrez Alfaro. 2019. Promoting community participation in thematic mapping processes by simplifying the free software tool OSMTracker for Android. In 2019 IV Jornadas Costarricenses de Investigación en Computación e Informática (JoCICI). 1–6. DOI: 10.1109/JoCICI48395.2019.9105207
Laura Vaughan. 2018. Mapping society: The spatial dimensions of social cartography. UCL Press.
