Data Warehouse
The core of any VISTA installation is the data warehouse. We use the relational database package PostgreSQL, combined with the PostGIS geo-spatial extension, to store all network data.
All network, control, and demand data is stored within the database. The outputs of some modules and reports are also stored in the database, making it possible for the user to construct a variety of queries to inspect or analyze the results directly.
Some assignment and simulation outputs are stored outside of the database for efficiency reasons. VISTA includes an extension to PostgreSQL which allows these outputs to be queried directly from the database. These data may be imported into the database for quicker analysis.