Data warehousing for effective analysis of substance flows through the economy and the environment
(English)Manuscript (preprint) (Other academic)
Data on flows of materials and substances through the economy and the environment are collected by a large number of organizations and subsequently stored in different systems and formats. We advocate that data warehousing can increase the value of existing data. To create a seed for such a process, we analyze the informational requirements for effective assessment of material and substance flow data originating from disparate sources. In particular, we outline how flow data can be stored and analyzed along with information about the investigated systems. A list of entities that need to be created and stored in a relational database is established, and an entity relationship (ER) diagram is employed to describe how the entities are related to each other. We also outline how uncertainty measures of estimated flows can be stored as metadata in the data warehouse to support quality assessment of the results of physical flow studies. Moreover, we illustrate possible links to official statistics and other auxiliary data sources. Data cube representations connected with the proposed database can facilitate statistical analysis of collected data.
IdentifiersURN: urn:nbn:se:liu:diva-86476OAI: oai:DiVA.org:liu-86476DiVA: diva2:577843