MENGOPTIMALKAN ORACLE SPASIAL UNTUK ANALISIS KEDEKATAN GEOGRAFIS

Hendro Nindito(1*),

(1) Sistem Informasi, Universias Bina Nusantara Jakarta
(*) Corresponding Author

Abstract


The study explores the utilization of Oracle Spatial in the determination of the shortest path between locations. This is very important for the analysis and management of geographic information. Its ability to handle multiple attributes, rasters, and vectors, is greatly enhanced by its support for data management. The objective of the study is to find the closest locations of Binus BB S and Binus Square to investigate the use of Oracle's Geospatial technology. The research entails populating a table with geometry clusters, performing spatial queries, and capturing data. The study utilized SDO_GEOMETERY and SDO_NN to find the Binus Square and BBS campuses' closest locations. The findings reinforced Oracle Spatial's practicality and accuracy for proximity analysis, emphasizing the significance of maintaining and managing such databases. The study also identified an issue which suggests that the product could be improved in the future. The integration of its features with other Oracle applications can provide more effective management and visualization of spatial data. The study highlighted Oracle Spatial's potential to support complex spatial analyses and improve the operations of spatial databases.

 

ABSTRAK

Penelitian ini mengeksplorasi pemanfaatan Oracle Spatial dalam penentuan jalur terpendek antar lokasi. Hal ini sangat penting untuk analisis dan pengelolaan informasi geografis. Kemampuannya untuk menangani banyak atribut, raster, dan vektor, sangat ditingkatkan dengan dukungannya terhadap manajemen data. Tujuan penelitian adalah mencari lokasi terdekat Binus BBS dan Binus Square untuk mengetahui penggunaan teknologi Geospasial Oracle. Penelitian ini memerlukan pengisian tabel dengan cluster geometri, melakukan kueri spasial, dan menangkap data. Penelitian ini memanfaatkan SDO_GEOMETERY dan SDO_NN untuk mencari lokasi terdekat kampus Binus Square dan BBS. Temuan ini memperkuat kepraktisan dan akurasi Oracle Spatial untuk analisis kedekatan, menekankan pentingnya memelihara dan mengelola database tersebut. Studi ini juga mengidentifikasi masalah yang menunjukkan bahwa produk tersebut dapat ditingkatkan di masa depan. Integrasi fitur-fiturnya dengan aplikasi Oracle lainnya dapat memberikan pengelolaan dan visualisasi data spasial yang lebih efektif. Studi ini menyoroti potensi Oracle Spatial untuk mendukung analisis spasial yang kompleks dan meningkatkan pengoperasian database spasial


Keywords


Oracle Spatial, Geographc Information Systems (GIS), Proximity Analysis

Full Text:

PDF

References


Academy, O. (2022). Applied Database System. Oracle Academy.

Díaz-Cuevas, P., Camarillo-Naranjo, J. M., & Pérez-Alcántara, J. P. (2018). Relational spatial database and multi-criteria decision methods for selecting optimum locations for photovoltaic power plants in the province of Seville (southern Spain). Clean Technologies and Environmental Policy, 20, 1889–1902. Retrieved from https://api.semanticscholar.org/CorpusID:105945904

Esikova, V., Soloviev, I., & Zolnikova, J. F. (2023). Regional features of youth migration in Russia. InterCarto. InterGIS. Retrieved from https://api.semanticscholar.org/CorpusID:265338715

Fikejz, J., & Merta, J. (2015). Utilization of computer simulation for the localization of rolling stock with utilization technology oracle spatial and dynamic database views. Retrieved from https://api.semanticscholar.org/CorpusID:145899329

Harris, N. L., Goldman, E. D., & Gibbes, S. (2019). Spatial Database of Planted Trees (SDPT Version 1.0). Retrieved from https://api.semanticscholar.org/CorpusID:215971873

Kanth, K. V. R., Ravada, S., & Abugov, D. (2002). Quadtree and R-tree indexes in oracle spatial: a comparison using GIS data. In ACM SIGMOD Conference. Retrieved from https://api.semanticscholar.org/CorpusID:12580162

Laborte, A. G., Gutierrez, M. A., Balanza, J. G., Saito, K., Zwart, S. J., Boschetti, M., … Nelson, A. (2017). RiceAtlas, a spatial database of global rice calendars and production. Scientific Data, 4, 1–10. https://doi.org/10.1038/sdata.2017.74

Maina, J., Ouma, P. O., Macharia, P. M., Alegana, V. A., Mitto, B., Fall, I. S., … Okiro, E. A. (2019). A spatial database of health facilities managed by the public health sector in sub Saharan Africa. Scientific Data, 6(1), 1–8. https://doi.org/10.1038/s41597-019-0142-2

Manthe, C., Clemen, C., & Gründig, L. (2009). How to Define a Regional Arbitrary Geodetic Datum in Oracle Spatial. Retrieved from https://api.semanticscholar.org/CorpusID:130792827

Ming, L. (2008). Extending of Spatial Data Types and Spatial Functions in Oracle. Journal of Geomatics Science and Technology. Retrieved from https://api.semanticscholar.org/CorpusID:58605191

Mr, R. R., Mr, S. R. S., & Mr, B. S. (2021). Spatial Data Mining Methods Databases and Statistics Point of Views. Innovations in Information and Communication Technology Series. Retrieved from https://api.semanticscholar.org/CorpusID:233273532

Müller, W., Femel, J., Neil, E., Park, D., Hennessey, R. C., DiBiasio, E. C., … Bosio, A. (2024). Abstract 4953: A proposal to extend standardized organ mapping antibody panels (OMAPs) to integrate protein and RNA analysis in spatial biology. Cancer Research. Retrieved from https://api.semanticscholar.org/CorpusID:268651145

Nindito, H. (2024). Pegolahan Data Spasial. Jakarta.

Philbin, J., Chum, O., Isard, M., Sivic, J., & Zisserman, A. (2008). Lost in quantization: Improving particular object retrieval in large scale image databases. 2008 IEEE Conference on Computer Vision and Pattern Recognition, 1–8. Retrieved from https://api.semanticscholar.org/CorpusID:6875974

Zhandong, Y. (2010). Spatial Metadata Store Technology Based on Oracle XML DB. Geospatial Information. Retrieved from https://api.semanticscholar.org/CorpusID:63428689

Zhengming, D. (2015). Development and application of software for expanding map symbol database in oracle spatial Dong Zhengming. Retrieved from https://api.semanticscholar.org/CorpusID:173988794




DOI: https://doi.org/10.37365/jti.v10i2.318

Refbacks

  • There are currently no refbacks.


Slot Gacor

mahjong ways scatter hitam

slot thailand