Logo des Repositoriums

Auflistung nach Autor:in "Aue, Alexander"

1 - 2 von 2
  • Konferenzbeitrag
    Converting data organised for visual perception into machine-readable formats
    (44. GIL - Jahrestagung, Biodiversität fördern durch digitale Landwirtschaft, 2024) Aue, Alexander; Ackermann, Andrea; Röder, Norbert
    Spreadsheets are used to store an extraordinary amount of important data. The fact that spreadsheets are both easy to use and allow users a great deal of flexibility in how they store their data is a significant reason why they are so popular. Users often use a variety of layout techniques to make the data easy for humans to understand. But this layout also creates problems for traditional Extract-Transform-Load (ETL) tools. We propose a program that allows users to easily extract data from Excel files by selecting the cells containing the data and metadata thereby determining the data hierarchy. We have used this program to extract data of the Agricultural Structure Survey on land use and livestock in Germany, which does not follow a nationwide standard, leading to large differences in the structuring of the data between the federal states, making it a good benchmark.
  • Konferenzbeitrag
    Innovative form generator for recording complex support programmes
    (44. GIL - Jahrestagung, Biodiversität fördern durch digitale Landwirtschaft, 2024) Aue, Alexander; Ackermann, Andrea; Röder, Norbert
    In an effort to incentivize environmental protection actions among farmers, different administrations offer various support programmes. These programmes differ between states, change over time and are published in non-machine-readable formats. Since the lack of a nationwide database hampers the comprehensive evaluation of these programmes, we propose a flexible form generator for standardizing the programme descriptions. Our tool meets the needs of researchers as it facilitates the transformation of text-based definitions to a well-structured relational database with its graphical questionnaire user interface. Redundancies in data input are avoided by allowing the collected data of a support program to be inherited by another and to extend it by additional properties or overwriting existing ones. Furthermore, it accommodates complex data collection needs, supporting limitless sub-questions and customized input fields. The resulting hierarchical data is automatically stored in a relational database, ensuring a user-friendly experience both for quantitative researchers and data analysts. This innovative approach enhances the evaluation of e.g. environmental protection programmes.