MC4211 Advanced Database Technology Laboratory Syllabus:

MC4211 Advanced Database Technology Laboratory Syllabus – Anna University PG Syllabus Regulation 2021

COURSE OBJECTIVES:

 To understand the process of distributing tables across multiple systems
 To understand the process of storing, retrieving spatial and temporal data
 To understand the process of storing, retrieving objects in a database
 To understand the process of storing and retrieving data from a XML Database
 To use the open source database for building a mobile application

LIST OF EXPERIMENTS:

1. NOSQL Exercises
a. MongoDB – CRUD operations, Indexing, Sharding
b. Cassandra: Table Operations, CRUD Operations, CQL Types
c. HIVE: Data types, Database Operations, Partitioning – HiveQL
d. OrientDB Graph database – OrientDB Features
2. MySQL Database Creation, Table Creation, Query
3. MySQL Replication – Distributed Databases
4. Spatial data storage and retrieval in MySQL
5. Temporal data storage and retrieval in MySQL
6. Object storage and retrieval in MySQL
7. XML Databases , XML table creation, XQuery FLWOR expression
8. Mobile Database Query Processing using open source DB (MongoDB/MySQL etc)

TOTAL: 60 PERIODS

SOFTWARE REQUIREMENTS

1. Java / Python / R / Scala
2. Oracle, MySQL, MongoDB, Casandra, Hive

COURSE OUTCOMES:

On completion of the course, the student will be able to:
CO1: Design and implement advanced databases.
CO2: Use big data frameworks and tools.
CO3: Formulate complex queries using SQL.
CO4: Create an XML document and perform Xquery.
CO5: Query processing in Mobile databases using open source tools.