Data Storage Architecture and Retrieval Based on Water Conservancy Data and Computer Technologies

Data Storage Architecture and Retrieval Based on Water Conservancy Data and Computer Technologies

Xishuang Yin (POWERCHINA Chengdu Engineering Corporation Limited, China) and Yi Feng (POWERCHINA Chengdu Engineering Corporation Limited, China)
DOI: 10.4018/IJAEIS.373123
Article PDF Download
Open access articles are freely available for download

Abstract

The reasonable storage and retrieval of spatial data in rivers and lakes can promote the development of river and lake management and protection projects. In order to efficiently store and retrieve river and lake spatial data, this study adopts river and lake data and computer technology to design a data storage architecture and retrieval method based on river and lake spatial data types. The design of the structured data storage architecture adopts relational databases and document databases with spatial indexing characteristics. Use a geospatial data abstraction library to read and write raster image data from unstructured data, and use Elasticsearch to retrieve metadata. The test results show that the minimum latency of this architecture is 13ms, the average response time is 78ms, the maximum throughput is 14000 req/s, and the average failure rate is 0.106%. The designed architecture and database performance are excellent, providing technical support for efficient storage and retrieval of river and lake spatial data.
Article Preview
Top

Literature Review

Common data storage methods include distributed file storage systems and non-relational databases (Anselin et al., 2022). The commonly used storage methods for spatial data include extensions based on relational databases and non-relational databases; these are based on big data and cloud computing technologies(Fateminasab et al., 2025). Conventional indexes mainly use two basic data structures, hash and decision tree. Abdelkader et al. (2024) developed a large DSRM, based on the relational database data-information-knowledge cognitive model; this addressed issues of high space occupancy and low retrieval security in traditional methods by transforming data patterns through the data-information-knowledge cognitive model. The space occupancy rate of this method was always less than 10%, and the safety factor of data retrieval was 0.95 (Feng et al., 2025). Aher & Chaudhari (2025) reviewed existing DSRMs for heterogeneous multi-cloud architectures, to address the vulnerability of multi-cloud environments to security attacks. This study analyzed and explained the purpose, basic techniques, implementation data, and evaluation parameters of these methods and elaborated on possible future research directions.

Complete Article List

Search this Journal:
Reset
Volume 16: 1 Issue (2025)
Volume 15: 1 Issue (2024)
Volume 14: 1 Issue (2023)
Volume 13: 2 Issues (2022): 1 Released, 1 Forthcoming
Volume 12: 4 Issues (2021)
Volume 11: 4 Issues (2020)
Volume 10: 4 Issues (2019)
Volume 9: 4 Issues (2018)
Volume 8: 4 Issues (2017)
Volume 7: 4 Issues (2016)
Volume 6: 4 Issues (2015)
Volume 5: 4 Issues (2014)
Volume 4: 4 Issues (2013)
Volume 3: 2 Issues (2012)
Volume 2: 2 Issues (2011)
Volume 1: 2 Issues (2010)
View Complete Journal Contents Listing