Sensor Data Management
Niveau
Beginner
Lernergebnisse der Lehrveranstaltungen/des Moduls
Upon completing this course, students will be able to:
- Implement and Manage Data Storage Solutions: Identify the most suitable data storage solutions for drone data, considering data volume, security, accessibility, and cost for on-premises and cloud-based storage options.
- Explain Database System Purposes and Functions: Describe the purposes of database systems and how they function.
- Utilize and Compare Database Systems: Use different database systems and compare their features and performance.
- Understand Relational Database Systems: Demonstrate a detailed understanding of relational database systems.
- Develop and Implement Data Structures: Create and implement data structures to solve specific problems.
- Represent Real-World Situations as Data Models: Independently represent real-world situations as a data model.
- Translate Data Models into Relational Data Structures: Convert data models into relational data structures.
- Interact with Database Systems: Operate and manage interactions with various database systems.
- Perform Basic NoSQL Database Management: Conduct basic database management activities in NoSQL systems.
- Apply Specialized Database Systems: Apply other database systems practically, such as those for time series data.
Voraussetzungen der Lehrveranstaltung
None
Lehrinhalte
- Fundamentals of Database Systems and Data Management: Core principles of database systems and data management.
- Data Modeling: Developing data models including single entities, attributes, cardinality, conditionality, and relationship types.
- Normalization and Keys: Identifying candidate keys, superkeys, and primary keys; normalizing data structures to at least 1NF, 2NF, and 3NF.
- SQL Interaction: Using SQL for data definition language (DDL), data manipulation language (DML), and data query language (DQL).
- NoSQL Database Management: Basic management activities on advanced database concepts within the NoSQL domain.
- Time Series and Unstructured Data Management: Managing time series data sets and unstructured data (e.g., images).
Empfohlene Fachliteratur
- Elmasri, R., & Navathe, S. B. (2021). Fundamentals of Database Systems (7th ed.). Pearson. ISBN: 978-0137502523.
- Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill Education. ISBN: 978-1260084504.
- Pivert, O. (2018). NoSQL Data Models: Trends and Challenges, Wiley-ISTE, ISBN: 978-1786303646
- Dunning, T., & Friedman, E. (2014). Time Series Databases: New Ways to Store and Access Data. O'Reilly Media. ISBN: 978-1491914724.
Bewertungsmethoden und -Kriterien
Exam
Unterrichtssprache
Englisch
Anzahl der zugewiesenen ECTS-Credits
5
E-Learning Anteil in %
15
Semesterwochenstunden (SWS)
2.5
Geplante Lehr- und Lernmethode
Presentation, group work, discussion, exercises
Semester/Trisemester, In dem die Lehrveranstaltung/Das Modul Angeboten wird
2
Name des/der Vortragenden
Studienjahr
Kennzahl der Lehrveranstaltung/des Moduls
2_7
Art der Lehrveranstaltung/des Moduls
Integrierte Lehrveranstaltung
Art der Lehrveranstaltung
Pflichtfach