Sun, J.; Zhang, P.; Wang, Y.; Yang, D.; Huang, Z., and Zhang, Z., 2020. Cloud storage algorithm for spatial structure data of radar bathymetry based on SQLite. In: Liu, X. and Zhao, L. (eds.), Today's Modern Coastal Society: Technical and Sociological Aspects of Coastal Research. Journal of Coastal Research, Special Issue No. 111, pp. 84–88. Coconut Creek (Florida), ISSN 0749-0208.
To solve the problems of file overstocking and data processing delay in data storage, the spatial structure data cloud storage algorithm based on SQLite, a relational database management system, is studied. The principle of radar laser detection is analyzed. Based on the principle, multibeam sounding sonar and angle-of-arrival transient imaging technology are used to collect the spatial structure data of sounding points, and the spatial structure data of different formats are transformed into a standard format and stored in the SQLite database of each detection point. The data cloud storage architecture of ocean exploration spatial structure based on SQLite is constructed. The node ID forward algorithm is used to reduce the node storage partition, and the load transfer of multiple overload nodes is carried out simultaneously to reduce the storage load of nodes and thus realize the collaborative work among multiple SQLite data. The simulation results show that the algorithm can achieve the load balance of each node, which fully verifies the application value of the algorithm.