Transport and Spatial Data Warehouse Technical Design

Within HARMONY, multidisciplinary data are combined and integrated for land-use and transport modelling and planning. Data are managed in a Transport and Spatial Data Warehouse (TSDW) that stores secondary and primary data for analysis, feeds with data the HARMONY simulators and stores the data generated by them. This deliverable provides the technical design of the TSDW addressing requirements of the components of the HARMONY model suite. In this respect, the following design elements of the TSDW are considered in this deliverable: The specification of the required data schemas for storing raw and processed transport and spatial data. Starting from the conceptual architecture of the HARMONY Model Suite (MS) (deliverable D1.3) a thorough record of data produced, consumed and exchanged between the simulators has been compiled. This set of data has been analysed in order to derive a harmonized data model where the main data entities of the model suite have been defined together with their properties. The initial approach of the TSDW infrastructure which covers the following points: Processing and storage capacity. Based on the identified data structures and the expected volume and data processing functions, preliminary figures of the required processing and storage capacity have been identified. Communication protocols interacting with external data providers and consumers. Interfaces for read/write access and import/export of transport and spatial data from external sources and outputs of the HARMONY MS. Data processing and management pipeline including the selection of data storage and processing technologies