MC4202 Advanced Database Technology Syllabus:
MC4202 Advanced Database Technology Syllabus – Anna University PG Syllabus Regulation 2021
COURSE OBJECTIVES:
To understand the working principles and query processing of distributed databases.
To understand the basics of spatial, temporal and mobile databases and their applications.
To distinguish the different types of NoSQL databases.
To understand the basics of XML and create well-formed and valid XML documents.
To gain knowledge about information retrieval and web search.
UNIT I DISTRIBUTED DATABASES
Distributed Systems – Introduction – Architecture – Distributed Database Concepts – Distributed Data Storage – Distributed Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing
UNIT II SPATIAL AND TEMPORAL DATABASES
Active Databases Model – Design and Implementation Issues – Temporal Databases – Temporal Querying – Spatial Databases: Spatial Data Types, Spatial Operators and Queries – Spatial Indexing and Mining – Applications -– Mobile Databases: Location and Handoff Management, Mobile Transaction Models – Deductive Databases – Multimedia Databases.
UNIT III NOSQL DATABASES
NoSQL – CAP Theorem – Sharding – Document based – MongoDB Operation: Insert, Update, Delete, Query, Indexing, Application, Replication, Sharding–Cassandra: Data Model, Key Space, Table Operations, CRUD Operations, CQL Types – HIVE: Data types, Database Operations, Partitioning – HiveQL – OrientDB Graph database – OrientDB Features
UNIT IV XML DATABASES
Structured, Semi structured, and Unstructured Data – XML Hierarchical Data Model – XML Documents – Document Type Definition – XML Schema – XML Documents and Databases – XML Querying – XPath – XQuery
UNIT V INFORMATION RETRIEVAL AND WEB SEARCH
IR concepts – Retrieval Models – Queries in IR system – Text Preprocessing – Inverted Indexing – Evaluation Measures – Web Search and Analytics – Current trends.
TOTAL: 45 PERIODS
Suggested Activities:
1. Create a distributed database for any application (ex. book store) and access it using PHP and Python
2. Create spatial database of any place and perform query operations
3. Creating Databases and writing simple queries using MongoDB, DynamoDB, Voldemort KeyValue Distributed Data Store Hbase and Neo4j.
4. Creating XML Documents, Document Type Definition and XML Schema for any e-commerce website and perform XML Querying
5. Perform sentiment analysis for any web document using text preprocessing techniques
COURSE OUTCOMES:
On completion of the course, the student will be able to:
CO1: Design a distributed database system and execute distributed queries.
CO2: Manage Spatial and Temporal Database systems and implement it in corresponding applications.
CO3: Use NoSQL database systems and manipulate the data associated with it.
CO4: Design XML database systems and validate with XML schema.
CO5: Apply knowledge of information retrieval concepts on web databases.
REFERENCES:
1. Abraham Silberschatz, Henry F Korth, S. Sudharshan, “Database System Concepts”, Seventh Edition, McGraw Hill, 2019.
2. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education/Addison Wesley, 2017.
3. Guy Harrison, “Next Generation Databases, NoSQL, NewSQL and Big Data”, First Edition, Apress publishers, 2015
4. Jiawei Han, Micheline Kamber, Jian Pei, “Data Mining: Concepts and Techniques”, Third Edition, Morgan Kaufmann, 2012.
5. Brad Dayley, “Teach Yourself NoSQL with MongoDB in 24 Hours”, Sams Publishing, First Edition, 2014.
6. C. J. Date, A. Kannan, S. Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006