Data standardization and modeling in a web based information system

This paper describes data handling within a web-based information system in terms of data standardization, data modeling and data ingestion. The information system developed under the premise to make all datasets generated within the WISDOM project available for regional decision makers is based on a PostgreSQL object-relational database. Data standardization in this context is implemented by project specific guidelines that follow international standards like IS019115/19139 or OGC compliant Styled Layer Descriptors (SLD). Data modeling on the other hand improves data retrieval and accessibility by adding contextual information to all datasets through the registration to spatial, thematic and temporal reference objects. Ingesting new datasets into the information system is done in an automatic way for spatial datasets using a Java application, while non-spatial datasets have to be ingested by SQL commands. Implementing web-based interfaces to enable registered users to upload new datasets is a future task.