Data management for extended multi-period analysis of water resources systems