Hydrologic data management using RDBMS with Differential-Linear Data Storage

G. Tsakalias, and D. Koutsoyiannis, Hydrologic data management using RDBMS with Differential-Linear Data Storage, Hydraulic Engineering Software V: Proceedings of the 5th International Conference HYDROSOFT '94, edited by W. R. Blain and K. L. Katsifarakis, Sithonia, 2, 317–326, doi:10.13140/RG.2.1.2021.6565, Computational Mechanics Publications, Southampton, 1994.



Recently, Relational Data Base Management Systems (RDBMSs) have become popular for handling hydrologic time-series and running hydrologic applications. However, the standard data independence in such systems has many technical disadvantages in storing time-series data. An alternative technique, named Differential-Linear Data Storage (DLDS) technique, has been developed in the framework of the Hydroscope project (a Greek nation-wide database for hydrometeorological information). This technique establishes a standardised representation of hydrologic time-series in a relational database environment, also providing a notable reduction in storage space. Instead of the standard SQL queries (select, insert, delete and update), numerous composite procedures are implemented to facilitate time-series management.

PDF Full text (1088 KB)

PDF Additional material:

See also: http://dx.doi.org/10.13140/RG.2.1.2021.6565

Our works that reference this work:

1. S. Kozanis, A. Christofides, N. Mamassis, and D. Koutsoyiannis, openmeteo.org: a web service for the dissemination of free meteorological data, Advances in Meteorology, Climatology and Atmospheric Physics, edited by C.G. Helmis and P. Nastos, Athens, 203–208, doi:10.1007/978-3-642-29172-2_29, Springer, Athens, 2012.

Other works that reference this work (this list might be obsolete):

1. Sanopoulos, D., A. Kungolos, V. Keramaris and Z. Kiparissidi, Developing a database for Energy and Environment: The Hephaestos project, Fresenius Environmental Bulletin, 9(5-6), 281-286, 2000.
2. #Sidiropoulos, E., D. Tolikas, and P. Tolikas, The status of water resources monitoring in the Balkans, Greece, Transboundary Water Resources in the Balkans, J. Ganoulis, et al. (ed.). Kluwer, 125-135, 2000.
3. #Sanopoulos, D., M. Stavropoulos and A. Kungolos, Hephaestus: A database for environment and energy. Results, potential utilization and benefits, Proceedings of the International Conference "Protection and Restoration of the Environment VI", ed. by A.G. Kungolos, et al., Skiathos, July 1-5, 2002, 1745-1752, 2002.