COMP5338: Advanced Data Models

University of Sydney• 2025 S2
In Progress
logo
NoSQL
DistributedSystems
DatabasePerformance

Covers advanced SQL and modern post-relational data models (NoSQL, graph, spatial, temporal, time-series), focusing on CRUD operations, indexing, query tuning, and distributed storage systems.

Learning Outcomes

  • NoSQL & advanced models: Understand document, key-value, **graph**, spatial and time-series data models, and when to use each.
  • CRUD & aggregation: Write CRUD operations and implement aggregations in MongoDB and Neo4j (Cypher)
  • Indexing mechanisms:: Explain and compare indexing strategies across systems and how they support different queries.
  • Performance analysis & tuning: Profile, analyse, and tune query performance for MongoDB and Neo4j (schemas, indexes, plans).
  • Distributed databases: Distributed databases:** Understand partitioning, replication, consistency, and fault tolerance in distributed storage.
  • Physical storage: Describe on-disk/ in-memory layouts and explain their impact on query performance.

Takeaways

Coming soon.