Understanding how Time Series datasets are stored in HydroShare

HydroShare stores all time series resources in SQLite files. Each Time Series resource has a single SQLite file. If you upload a CSV file to a time series resource, HydroShare will read your CSV file and transfer the data into a SQLite database. The CSV file will remain in your resource unless you remove it.

SQLite is a self-contained, relational database file. It is an efficient way to put a relational database into a single file that doesn’t require a server. SQLite files are also cross platform compatible and can be read using a variety of software and programming languages.

HydroShare uses SQLite to store time series because it is an efficient way to store one or more Time Series together in the same file. It also makes it easier to make sure the metadata for Time Series datasets can be stored and accessed consistently.

Time Series SQLite files in HydroShare use the ODM2 information model for their structure. You can read more about the ODM2 information model in the following locations:

The following are examples of software programs that can read and interact with SQLite database files: