Sensor Data Management

Beginner

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.

None

- 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).

- 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.

Exam

Englisch

5

15

2.5

Presentation, group work, discussion, exercises

2

2_7

Integrierte Lehrveranstaltung

Pflichtfach