Earth and Space Science · 2017 · 70 citations · 32 references
ComputingComputer ScienceHydrologyData VisualizationDatabasesWater Resources EngineeringNetwork StructureQuery ProcessingRiver EngineeringStreamflow AnalysisAdjacency RelationsHydrological Data AnalysisNetwork Data ModelPath EnumerationRiver Network Structure
Abstract Web‐based systems allow users to filter data and resources using river network structure on interactive map environments that use server side processing. With the increasing resolution of river networks, optimized methods for storage of river network representation in databases and efficient queries on the river network structure become critical. This paper presents a detailed study of widely used methods for representing generic networks in relational databases and benchmarking common queries on river network data using these methods. The analysis has been applied to a data set consisting of the river network of Iowa, with over 620,000 individual subwatersheds/nodes in the network. For typical river network queries (path to the outlet; contributing watersheds), two of considered data models (Adjacency List and Nested Set) guarantee response times below 1 s. This will allow users to carry out large‐scale analysis and visualizations tasks on the web for hydrological data sets. A new data model, Stream Network, is proposed based on Path Enumeration, stores directly additional hydrological information, enabling, for example, retrieval of the main stream.
32
Why Most Published Research Findings Are False
John P. A. Ioannidis · PLoS Medicine · 2005 · 10.5K citations · Full text
Why Most Published Research Findings Are False
John P. A. Ioannidis · CHANCE · 2005 · 4.8K citations