Method for Query Processing in a Geographic Information System
Article Sidebar
Main Article Content
Abstract
Much geospatial information is stored in relational databases. Relational databases provide a reliable method for managing large amounts of data while offering a combination of system performance and ease of implementation. Users interacting with these systems perform queries to them with the primary objective of retrieving information. These queries are nothing more than natural language questions about the world and how people relate to it. This article discusses the main topics related to Geographic Information Systems and their most popular tools worldwide. Relevant aspects about Database Management Systems are also explained and a comparison between Relational and NoSQL is established. In addition, the main types of queries are discussed, as well as the language in which they are made and some examples of them are shown.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
Those authors that have publications with this journal accept the following terms:
1. They will retain their copyright and guarantee the journal the right of first publication of their work, which will be simultaneously subject to the License Creative Commons Attribution-NonCommercial 4.0 International (CC BY-NC 4.0) that allows third parties to share the work whenever its author is indicated and its first publication this journal. Under this license the author will be free of:
• Share — copy and redistribute the material in any medium or format
• Adapt — remix, transform, and build upon the material
• The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
• Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
• NonCommercial — You may not use the material for commercial purposes.
• No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
2. The authors may adopt other non-exclusive license agreements to distribute the published version of the work (e.g., deposit it in an institutional telematics file or publish it in a monographic volume) whenever the initial publication is indicated in this journal.
3. The authors are allowed and recommended disseminating their work through the Internet (e.g. in institutional telematics archives or on their website) before and during the submission process, which can produce interesting exchanges and increase the citations of the published work. (See the Effect of open access).
References
BAIK, C.; JAGADISH, H.V.; LI, Y.: “Bridging the semantic gap with SQL query logs in natural language interfaces to databases”, En: 2019 IEEE 35th International Conference on Data Engineering (ICDE), Ed. IEEE, pp. 374-385, 2019, ISBN: 1-5386-7474-2.
BALAMAN, Ş.Y.: “Chapter 7 - Modeling and Optimization Approaches in Design and Management of Biomass-Based Production Chains”, [en línea], En: Balaman, Ş.Y. (ed.), Decision-Making for Biomass-Based Production Chains, Ed. Academic Press, pp. 185-236, 1 de enero de 2019, DOI: 10.1016/B978-0-12-814278-3.00007-8, ISBN: 978-0-12-814278-3, Disponible en:https://www.sciencedirect.com/science/article/pii/B9780128142783000078, [Consulta: 20 de agosto de 2022].
BARTEL, C.: “Computer Art, Technology, and the Medium”, En: Being and Value in Technology, Ed. Springer, pp. 141-161, 2022.
BELCIU, A.; DIACONITA, V.; LUNGU, I.; VIRGOLICI, A.-M.: “Development of Spatial Database for Regional Development in Romania”, Informatica Economica, 18(3): 55, 2014.
BENDUCH, P.: “Comparison of the results of spatial analyses performed in arcgis and qgis software”, Infrastruktura i Ekologia Terenów Wiejskich, 2017.
CAI, H.; VASILAKOS, A.V.: “Chapter 12 - Web of Things Data Storage”, [en línea], En: Sheng, Q.Z.; Qin, Y.; Yao, L. y Benatallah, B. (eds.), Managing the Web of Things, Ed. Morgan Kaufmann, Boston, pp. 325-354, 1 de enero de 2017, DOI: 10.1016/B978-0-12-809764-9.00015-9, ISBN: 978-0-12-809764-9, Disponible en:https://www.sciencedirect.com/science/article/pii/B9780128097649000159, [Consulta: 22 de agosto de 2022].
DAN, S.; KORDJAMSHIDI, P.; BONN, J.; BHATIA, A.; CAI, J.; PALMER, M.; ROTH, D.: “From spatial relations to spatial configurations”, arXiv preprint arXiv:2007.09557, 2020.
DEMPSEY, C.: “Types of GIS Data Explored: Vector and Raster”, GIS Lounge, 1 de julio de 2022, Disponible en:https://www.gislounge.com/geodatabases-explored-vector-and-raster-data/, [Consulta: 21 de agosto de 2022].
FLENNIKEN, J.M.; STUGLIK, S.; IANNONE, B.V.: “Quantum GIS (QGIS): An introduction to a free alternative to more costly GIS platforms: FOR359/FR428, 2/2020”, EDIS, 2020(2): 7-7, 2020.
GINESTÀ, M.G.; MORA, O.P.: “Bases de datos en PostgreSQL”, Sl]:[sn], 2012.
GOODCHILD, M.F.; KEMP, K.K.: NCGIA core curriculum: introduction to GIS, Ed. National Center for Geographic Information and Analysis, University of …, vol. 1, 1990.
GUILLOT JIMÉNEZ, J.; GARCÍA, L.: “Bases de datos NoSQL para la gestión de datos geoespaciales”, En: 16 de marzo de 2016, DOI: 10.13140/RG.2.1.3803.0481.
GUO, D.; ONSTEIN, E.: “State-of-the-art geospatial information processing in NoSQL databases”, ISPRS International Journal of Geo-Information, 9(5): 331, 2020.
HAMMERSLEY, B.: “SQL vs NoSQL: A Spatial Benchmark for Selected NoSQL and Relational Database Management Systems”, 2018.
HESS, P.T.: Building a Spatial Database for Agricultural Record Keeping and Management on a Regenerative Farm, University of Southern California, 2022.
HOWARI, F.M.; GHREFAT, H.: “Chapter 4 - Geographic information system: spatial data structures, models, and case studies”, [en línea], En: Mohamed, A.-M.O.; Paleologos, E.K. y Howari, F.M. (eds.), Pollution Assessment for Sustainable Practices in Applied Sciences and Engineering, Ed. Butterworth-Heinemann, pp. 165-198, 1 de enero de 2021, DOI: 10.1016/B978-0-12-809582-9.00004-9, ISBN: 978-0-12-809582-9, Disponible en:https://www.sciencedirect.com/science/article/pii/B9780128095829000049, [Consulta: 21 de agosto de 2022].
HSU, L.S.; OBE, R.: PostGIS in action, Ed. Simon and Schuster, 2021, ISBN: 1-61729-669-4.
ISMAIL HOSSAIN, M.; MAHMUD, S.; SANTA, T.D.: “Oracle, MySQL, PostgreSQL, SQLite, SQL Server: Performance based competitive analysis”, 2019.
JANIPELLA, R.; GUPTA, V.; MOHARIR, R.V.: “Chapter 8 - Application of Geographic Information System in Energy Utilization”, [en línea], En: Kumar, S.; Kumar, R. y Pandey, A. (eds.), Current Developments in Biotechnology and Bioengineering, Ed. Elsevier, pp. 143-161, 1 de enero de 2019, DOI: 10.1016/B978-0-444-64083-3.00008-7, ISBN: 978-0-444-64083-3, Disponible en:https://www.sciencedirect.com/science/article/pii/B9780444640833000087, [Consulta: 21 de agosto de 2022].
KHAN, S.; MOHIUDDIN, K.: “Evaluating the parameters of ArcGIS and QGIS for GIS”, Int. J. Adv. Res. Sci. Eng, 7: 582-594, 2018. Applications
KUL, G.; LUONG, D.T.A.; XIE, T.; CHANDOLA, V.; KENNEDY, O.; UPADHYAYA, S.: “Similarity metrics for SQL query clustering”, IEEE Transactions on Knowledge and Data Engineering, 30(12): 2408-2420, 2018.
LESLIE, M.; RAMSEY, P.: “Introduction to PostGIS”, 2022.
LITHMEE: “What is the Difference Between Attribute Data and Spatial Data”, [en línea], En: Pediaa.Com, 3 de marzo de 2019, Disponible en:https://pediaa.com/what-is-the-difference-between-attribute-data-and-spatial-data/, [Consulta: 20 de agosto de 2022].
MAINA, J.; OUMA, P.O.; MACHARIA, P.M.; ALEGANA, V.A.; MITTO, B.; FALL, I.S.; NOOR, A.M.; SNOW, R.W.; OKIRO, E.A.: “A spatial database of health facilities managed by the public health sector in sub Saharan Africa”, Scientific data, 6(1): 1-8, 2019.
MALIAKAL, G.: “Chapter Two - Database Management”, [en línea], En: Levin-Epstein, M. (ed.), Careers in Biomedical Engineering, Ed. Academic Press, pp. 19-36, 1 de enero de 2019, DOI: 10.1016/B978-0-12-814816-7.00002-9, ISBN: 978-0-12-814816-7, Disponible en:https://www.sciencedirect.com/science/article/pii/B9780128148167000029, [Consulta: 22 de agosto de 2022].
MARIANI, G.: “Los Sistemas de Información Geográfica (SIG) - Caja de herramientas para un Nuevo Urbanismo”, En: 14 de junio de 2012.
MAURYA, S.; OHRI, A.; MISHRA, S.: “Open Source GIS: A Review”, En: 9 de octubre de 2015.
NASUTION, M.: Relational Database Management Systems, 2 de marzo de 2021.
NAYAK, A.; PORIYA, A.; POOJARY, D.: “Type of NOSQL databases and its comparison with relational databases”, International Journal of Applied Information Systems, 5(4): 16-19, 2013.
NUR, W.H.; KUMORO, Y.; SUSILOWATI, Y.: “GIS and Geodatabase Disaster Risk for Spatial Planning”, IOP Conference Series: Earth and Environmental Science, 118: 012046, febrero de 2018, ISSN: 1755-1315, DOI: 10.1088/1755-1315/118/1/012046.
OLAYA, V.: Sistemas de información geográfica. Un libro libre de Víctor Olaya, Ed. Obtenido de: http://volaya.github.io/librosig/chapters …, 2014.
PILICITA GARRIDO, A.; BORJA LÓPEZ, Y.; GUTIÉRREZ CONSTANTE, G.: “Rendimiento de MariaDB y PostgreSQL”, 2021.
PINO, A.V.; PONCE, J.; MORETA, O.E.: “Análisis de la optimización de sentencias SQL del Lenguaje de Consulta Estructurado usando grandes volúmenes de datos”, Revista Publicando, 5(16 (1)): 70-79, 2018.
PRATT, M.: “Asking the Right Questions”, 2009.
R. ADAM DASTRUP, M.A.: “1.4 The Future of GIS”, [en línea], En: Introduction to Geographic Information Systems, 2020, Disponible en:https://gist.pressbooks.com/chapter/1-4/, [Consulta: 29 de julio de 2022].
RAWAT, B.; PURNAMA, S.: “MySQL Database Management System (DBMS) On FTP Site LAPAN Bandung”, International Journal of Cyber and IT Service Management, 1(2): 173-179, 2021.
RESTREPO, J.C.G.: “La cartografía en el ambito de las tecnologias de la informacion y la comunicación (TIC)”, DIM: Didáctica, Innovación y Multimedia, (31): 1-18, 2015, ISSN: 1699-3748.
SALLEH, S.; UJANG, U.; AZRI, S.: “3D TOPOLOGICAL SUPPORT IN SPATIAL DATABASES: AN OVERVIEW.”, International Archives of the Photogrammetry, Remote Sensing & Spatial Information Sciences, 46, 2021.
SHIN, M.E.; CAMPBELL, J.; BURKHART, N.: Essentials of Geographic Information Systems, Ed. FlatWorld, 2018, ISBN: 1-4533-9080-4.
SHNIZAI, Z.: Spatial and Attribute Querying, 12 de noviembre de 2011.
SINGH, S.: “DATABASE MANAGEMENT SYSTEM”, Journal of Management Research and Analysis, 2(1): 72-80, Company: IP Innovative Publication Pvt. Ltd.Distributor: IP Innovative Publication Pvt. Ltd.Institution: IP Innovative Publication Pvt. Ltd.Label: IP Innovative Publication Pvt. Ltd.number: 1publisher: Ip Innovative Publication Pvt. Ltd., 15 de abril de 2015, ISSN: 2394-2770.
TAIPALUS, T.; SIPONEN, M.; VARTIAINEN, T.: “Errors and complications in SQL query formulation”, ACM Transactions on Computing Education (TOCE), 18(3): 1-29, 2018.
TWUMASI, B.O.: “Modelling spatial object behaviours in object-relational geodatabase”, En: Ed. Citeseer, 2002.
UMA, M.; SNEHA, V.; SNEHA, G.; BHUVANA, J.; BHARATHI, B.: “Formation of SQL from natural language query using NLP”, En: 2019 International Conference on Computational Intelligence in Data Science (ICCIDS), Ed. IEEE, pp. 1-5, 2019, ISBN: 1-5386-9471-9.
WODYK, R.; SKUBLEWSKA-PASZKOWSKA, M.: “Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework”, Journal of Computer Sciences Institute, 17: 358-364, 2020.
YUE, P.; TAN, Z.: “GIS Databases and NoSQL Databases”, En: Reference Module in Earth Systems and Environmental Sciences, journalAbbreviation: Reference Module in Earth Systems and Environmental Sciences, 31 de diciembre de 2017, DOI: 10.1016/B978-0-12-409548-9.09596-8, ISBN: 978-0-12-409548-9.