liu.seSearch for publications in DiVA
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • oxford
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Data warehousing for effective analysis of substance flows through the economy and the environment
Linköping University, Department of Mathematics, Statistics. Linköping University, Faculty of Arts and Sciences.
Linköping University, Department of Mathematics, Statistics. Linköping University, Faculty of Arts and Sciences.
Statistics Sweden, Stockholm, Sweden.
(English)Manuscript (preprint) (Other academic)
Abstract [en]

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.

National Category
Natural Sciences
Identifiers
URN: urn:nbn:se:liu:diva-86476OAI: oai:DiVA.org:liu-86476DiVA: diva2:577843
Available from: 2012-12-17 Created: 2012-12-17 Last updated: 2012-12-17
In thesis
1. Organizing physical flow data: from input-output tables to data warehouses
Open this publication in new window or tab >>Organizing physical flow data: from input-output tables to data warehouses
2005 (English)Doctoral thesis, comprehensive summary (Other academic)
Abstract [en]

Data on flows of materials and substances through the economy and the environment are collected by many different organizations and play a key role in the science of industrial ecology. In this thesis, a framework is suggested for structuring and organizing such data. First, the investigation focuses on the quantities of primary interest in material flow studies and how they can be stored and organized in a data warehouse. This process is shown to provide easy access to data, well-structured data management, a basis for knowledge discovery, and effective analysis of collected data. Secondly, a theoretical framework is proposed for handling and structuring multidimensional flow data, and for facilitating mathematics-assisted modeling in industrial ecology. In particular, it is shown how mathematical operations can be used to merge and compare flow data originating from different studies. Finally, it is illustrated how bootstrap analysis, Bayesian models and balancing procedures can be employed to systematize the quality and uncertainty assessment of physical flow data. Together, these three different aspects of handling physical flow data constitute a new framework that offers better knowledge, quality, and consistency of the data used in industrial ecology.

Place, publisher, year, edition, pages
Linköping: Linköpings universitet, 2005. 42 p.
Series
Linköping Studies in Statistics, ISSN 1651-1700 ; 5
National Category
Mathematics
Identifiers
urn:nbn:se:liu:diva-30083 (URN)15549 (Local ID)91-85297-55-0 (ISBN)15549 (Archive number)15549 (OAI)
Public defence
2005-09-30, Glashuset, B-huset, Campus Valla, Linköping, 10:15 (Swedish)
Available from: 2009-10-09 Created: 2009-10-09 Last updated: 2012-12-17

Open Access in DiVA

No full text

Authority records BETA

Löfving, ErikGrimvall, Anders

Search in DiVA

By author/editor
Löfving, ErikGrimvall, Anders
By organisation
StatisticsFaculty of Arts and Sciences
Natural Sciences

Search outside of DiVA

GoogleGoogle Scholar

urn-nbn

Altmetric score

urn-nbn
Total: 58 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • oxford
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf