Weiterentwicklung analytischer Datenbanksysteme

This thesis contributes to the state of the art in analytical database systems. First, we identify and explore extensions to better support analytics on event streams. Second, we propose a novel polygon index to enable efficient geospatial data processing in main memory. Third, we contribute a new deep learning approach to cardinality estimation, which is the core problem in cost-based query optimization.Diese Arbeit trägt zum aktuellen Forschungsstand von analytischen Datenbanksystemen bei. Wir identifizieren und explorieren Erweiterungen um Analysen auf Eventströmen besser zu unterstützen. Wir stellen eine neue Indexstruktur für Polygone vor, die eine effiziente Verarbeitung von Geodaten im Hauptspeicher ermöglicht. Zudem präsentieren wir einen neuen Ansatz für Kardinalitätsschätzungen mittels maschinellen Lernens

Participatory analytics for transport decision-making

This thesis investigates the design and evaluation of several software platforms that facilitate participatory outcomes in transport decision-making across operational, local and strategic scales. These platforms act as instruments to explore aspects of the research question: "How can urban dashboards be contextualised, designed & evaluated in a way that is sensitive to the changing role of digital democracy, immersive technologies and the increasingly collaborative nature of planning?". The concept of participatory urban dashboards is introduced, followed by process of participatory analytics. This process involves bringing more people on board with both using the dashboard (e.g., together or collaboratively) and allowing a more general audience of citizens or stakeholders to make sense and validate what is displayed. The research is applied to the city of Sydney, Australia. Sydney is a growing, global city with a wide variety of transport infrastructure ambitions and a strong, open-data ecosystem. Sydney’s transport system underpins the case studies of the operational, local and strategic digital artefacts assessed in this research. Participatory analytics outcomes as a result of interacting with these digital prototypes are evaluated. This will, in turn, help direct research and real-life applications and development of these tools. Further, it aims to build on research gap calling for further understanding of context-specific, user-centric design and evaluation of these participatory analytics tools