DI04000031 · Semester 4 · 5G scheme
Introduction to NoSQL
Notes and solutions following the Gujarat Technological University (GTU) syllabus for DI04000031. Independent material — not issued by the university.
Computer EngineeringComputer Science & Engineering
Materials
Syllabus units
Unit 1: Introduction to NoSQL
- Concepts: Why NoSQL? Limitations of RDBMS for modern applications.
- The CAP Theorem (only basics with analogy)
- Overview of NoSQL types: Document, Key-Value, Wide-Column, Graph.
- AI-focused use cases for different NoSQL databases
Unit 2: Document Databases: MongoDB
- Introduction & Core Concepts (Documents, Collections, BSON)
- MongoDB Architecture, Installing MongoDB and using mongosh
- Basics and CRUD Operations: Creating databases and collections, Data types in MongoDB (ObjectId, String, Array, Embedded Document), Insert, Find, Update, Delete operations, Query operators and filters ($gt, $lt, $in, $and, $or) Sorting, limiting results, and projections
- Data Modeling in MongoDB: Embedded vs. Referenced documents
- Indexing and Query Optimization (basic examples)
- Aggregation Framework: $match, $group, $sum, $avg
- Conceptual overview of replication and sharding (no configuration required)
Unit 3: Wide-Column Databases: Cassandra
- Introduction to Cassandra & its uses.
- Installing Cassandra and connecting with cqlsh (basic demo).
- Data Model: Keyspaces, Tables, Columns, Partitions
- Primary keys: Partition keys and clustering columns
- Cassandra Query Language (CQL): Create, Alter, Drop Keyspaces & Tables, Data types (int, text, timestamp, etc.)
- CRUD Operations with CQL: Insert, Update, Delete, Select with filters
- Simple queries: WHERE, ORDER BY, LIMIT
- Conceptual overview of cluster health and nodetool (awareness level only).
Unit 4: Graph Databases: Neo4j
- Basics of graph databases & theory (conceptual; focus on applications, not mathematical graph proofs), Installing Neo4j
- Cypher Query Language Basics, Graph operations & queries
- Graph algorithms (only examples, not implementation): recommender systems, fraud detection
- Real-world AI use cases (LinkedIn, Netflix, Banking)
Unit 5: Key-Value Databases: Redis
- Overview of Redis and its data structures (Strings, List, Sets, Hashes)
- AI-focused use cases of Redis.
- Basic Commands and Operations
- Redis Transactions and Caching Strategies
- Using Redis in Real-World Scenarios
- Integration with Other Technologies (Simplified)
About this course
Study materials, question papers, and solutions for Introduction to NoSQL (DI04000031) - Computer Engineering / Computer Science and Engineering, Semester 4