TY - CHAP A1 - Heinz, Florian A1 - Schildgen, Johannes T1 - A Data Model and Operations for Higher-Dimensional Moving Objects in Databases T2 - EMODE '23: Proceedings of the 1st ACM SIGSPATIAL International Workshop on Methods for Enriched Mobility Data: Emerging issues and Ethical perspectives 2023, Hamburg, 23 November 2023 N2 - Moving Object Databases are designed to store and process database objects with attributes that can change over time. Simple examples are moving points, that change position over time, a bit more complex are moving regions, that can also change shape. The spatial and spatiotemporal object types in current moving objects databases are limited to two dimensions. This work strives to extend the set of spatial moving object types into the third and even higher dimensions while preserving a consistent family of operations for it. A robust algorithm for the interpolation of two regions to a moving region of any dimensionality is developed, as well as the fundamental ideas for several other operations. KW - moving objects KW - spatiotemporal data KW - data models KW - moving regions Y1 - 2023 SN - 979-8-4007-0347-8 U6 - https://doi.org/10.1145/3615885.3628006 SP - 30 EP - 39 PB - ACM ER - TY - CHAP A1 - Schildgen, Johannes A1 - Heinz, Florian A1 - Olijnyk, Andreas A1 - Lindenau, Arvid T1 - Using SQL/MED to Query Heterogeneous Data Sources with Alexa Voice Commands T2 - Datenbanksysteme für Business, Technologie und Web (BTW2023), 06.-10. März 2023, Dresden N2 - Typical Alexa skills and other add-ons for voice assistants need to be custom developed for their one specific use case. This paper presents an approach to map arbitrary data sources (databases, APIs, services) to the relational model by using SQL/MED and to transform voice-based queries into SQL. The key challenges for such a universal skill are to correctly map the natural-language question into a SQL query on the correct source table in the federated database and to convert the result set back to a compact and well-understandable answer. KW - User interfaces for big data KW - Natural-Language Processing KW - SQL/MED KW - Voice Assistants Y1 - 2023 SN - 978-3-88579-725-8 U6 - https://doi.org/10.18420/BTW2023-53 SP - 821 EP - 828 PB - Gesellschaft für Informatik e.V. CY - Bonn ER - TY - BOOK A1 - Schildgen, Johannes T1 - MongoDB kompakt BT - Was Sie über die NoSQL-Dokumentendatenbank wissen müssen, unterstützte Lesegerätegruppen: PC/MAC/eReader/Tablet N2 - Die Dokumentendatenbank MongoDB ist das am weitesten verbreitete NoSQL-Datenbanksystem. Dieses kompakte Werk präsentiert MongoDB von der Installation bis zur Administrierung in großen Rechenclustern. Sie erfahren, wie Sie JSON-Dokumente in Kollektionen einfügen, suchen, ändern und löschen, wie man Replikation und Sharding effektiv einsetzt und wie Sie komplexe Analysen mithilfe der Aggregation-Pipeline durchführen können. Y1 - 2023 SN - 9783756891269 PB - Books on Demand GmbH CY - Norderstedt ER - TY - CHAP A1 - Schildgen, Johannes A1 - Heinz, Florian T1 - Interactive SQL Queries and Program Code in Presentations T2 - Datenbanksysteme für Business, Technologie und Web (BTW2023), 06.-10. März 2023, Dresden N2 - Nowadays, most database lectures are performed with an accompanying visual presentation that further illustrates the conveyed facts. Conventional presentation software allows dynamic elements up to a certain level, for example revealing or changing parts of the slide step by step, or even an interaction with the viewers by means of polls or similar mechanisms. Recently, HTML-and browser-based frameworks for presentations have emerged, which allow an even higher degree of flexibility due to the manifold possibilities of HTML5 and JavaScript. This paper presents an approach of how to interactively modify parts of a slide during the presentation, like SQL-based queries or program code snippets, and show the results pretty-printed on the corresponding slide in real-time. This enables the lecturer to easily show more examples, and answer and illustrate side questions, which they did not prepare in advance. KW - Lecture Slides KW - SQL Y1 - 2023 SN - 978-3-88579-725-8 U6 - https://doi.org/10.18420/BTW2023-39 SP - 687 EP - 693 PB - Gesellschaft für Informatik e.V. CY - Bonn ER -