scieee AI-readable full text Open interactive document viewer

Building a shared Life Cycle Inventory database for energy and process systems

Welker, Fabian; Faruss, Tim

Abstract

Despite the increasing importance of FAIR data (Findable, Accessible, Interoperable, and Reusable) in academic research, structured data management remains an often-overlooked challenge in the life cycle assessment (LCA)-community. Most researchers work independently on separate projects and tools, which leads to isolated LCA models, and little exchange of reusable data. In our LCA-focused research group, this has resulted in and repeated modelling of similar processes with inhomogeneous data quality and unnecessary time investment. To address this issue, we are developing a shared library of Life Cycle Inventories for energy and process systems LCA processes based on Brightway. The goal is to collect and organize existing models from different projects, publications and literature in a central cloud database that is easy to use and accessibleintuitive, well-documented and accessible for to all group members of the research group. The workflow for building and using the database consists of the following steps: (1) Structured data submission: Researchers submit process data into a structured Excel template. (2) Automated data integration: This Submitted data is automatically processed and imported into a cloud-based Brightway database. (3) Metadata and documentation: Each entry is stored together with metadata and full documentation. (4) Search and export functionality: Users can search the database for specific processes and export them either as Brightway activities or in Excel format, ready to be used in new projects. Furthermore, our approach raises important discussion pointsKey points of discussion for this approach are in LCA collaboration such as how to reduce redundancy, ensure data quality in modelling, and how to enable more efficient collaboration. Special attention is given to academic needs: proper authorship attribution, data confidentiality for varying project types (research, teaching, industry), and accessibility for users without prior Brightway experience.Further features, which could be integrated in the future, include version control, variable parametrization, and the integration of automated standard analysis tools (e.g., contribution analysis or uncertainty calculationsanalysis). The setup of the database should also consider possible interfaces to external modelling software (e.g. chemical process models). We propose this contribution to share our approach, discuss practical challenges in academic data collaboration, and explore how the Brightway community can support research workflows beyond individual projects.

Full text

Building a shared Life Cycle Inventory database for energy and process systems Fabian Welkera, Tim Farussa, Karan Ananda, Jan Hartmanna, Niklas von der Assena Contact Fabian Welker, Tim Faruss RWTH Aachen University Insitute of Technical Thermodynamics Schinkelstr. 8, 52062 Aachen E-Mail: [email protected] [email protected] References [1] Wilkinson, Mark, et al. "The FAIR Guiding Principles for scientific data management and stewardship." Scientific data (2016) Acknowledgements We gratefully acknowledge the financial support from DFG within the project IRTG 2983 Hy-Potential and the German Federal Ministry of Research, Technology and Space (BMFTR) for funding the Graduate Cluster AUFBRUCH (grant number: 031B1170). Motivation Researchers model energy and process systems individually and with different methods Process data and life-cycle inventories are stored locally and not shared within the research group Lack of data accessibility, reusability, and reproducibility leads to redundant work, inconsistencies, and inefficiencies Requirements for Database Proposed Layout of LCI Database Parameter variation: centralized, easy adjustment of key parameters of each process by the individual users Parametric uncertainty: allow users to incorporate background and foreground uncertainty in their processes, and define parameter ranges and probability distributions Automated assessments: include standard assessments (e.g. contribution analysis) or graphical representation of process data into the user interface Can we use Brightway to make our LCA data FAIR [1] ? o o o Where can existing Brightway features be used to achieve our goal of a shared and easy-to-use LCI database? Which system architecture would you suggest for the database and the user interface? Which common LCA tasks or analyses would you prospectively integrate into the database (such as background system variations or prospective LCA with premise)? Abbreviations LCA, LCI: Life-cycle Assessment, Life-cycle Inventory LTT: Institute of Technical Thermodynamics, RWTH Aachen SQL: Structured Query Language db: database Backend Frontend User input/output Upload LCA process data as excel sheets Access process (meta) data Import process data in bw python script Interface to export data Get process Future Extensions Let‘s discuss… User accessibility: intuitive use of database and self-explanatory data structures, also for users without Brightway experience Structured data upand download: users can submit and export process data in desired format, according to one or more templates Concurrent access and version control: multiple users can read and edit the database simultaneously, and changes can be tracked Documentation and citation: processes in the database must be sufficiently documented with key parameters and assumptions, and author acknowledgement must fulfil academia standards 1. Validate Data Data migration 3. Submit structured data 2. Version Control Graphical User Interface LCA Database (e.g. Ecoinvent) Process Cloud Database (e.g. SQL Database) Build Process LTT LCI Database Track versions of process and database Intuitive usage to submit data via web interface Upload process data in defined format Direct and easy integration of process via bw import function Match process data with latest LCA db version Simultaneous usage with multiple users Check for accuracy of process data Export to desired LCA db version Affiliation a) Institute of Technical Thermodynamics, RWTH Aachen University, Aachen, Germany