ADVANCED DATABASE TECHNOLOGY L T P C
3 0 0 3
OBJECTIVES:
To learn the fundamentals of data modeling and design in advanced databases.
To study the working principles of distributed databases.
To have an introductory knowledge about the query processing in object-based
databases and its usage.
To understand the basics of spatial, temporal and mobile databases and their
applications.
To learn emerging databases such as XML, Data warehouse and NoSQL.
UNIT I DISTRIBUTED DATABASES 9
Distributed Systems – Introduction – Architecture – Distributed Database Concepts –
DistributedData Storage – Distributed Transactions – Commit Protocols – Concurrency
Control – DistributedQuery Processing
UNIT II NOSQL DATABASES 9
NoSQL – CAP Theorem – Sharding - Document based – MongoDB Operation: Insert,
Update, Delete, Query, Indexing, Application, Replication, Sharding, Deployment – Using
MongoDB with PHP / JAVA – Advanced MongoDB Features – Cassandra: Data Model, Key
Space, Table Operations, CRUD Operations, CQL Types – HIVE: Data types, Database
Operations, Partitioning – HiveQL – OrientDB Graph database – OrientDB Features
UNIT III ADVANCED DATABASE SYSTEMS 9
Object Oriented Databases-Need for Complex Data Types - The Object-Oriented Data
Model-Object-Oriented Languages-Spatial Databases: Spatial Data Types, Spatial
Relationships, Spatial Data Structures, Spatial Access Methods – Temporal Databases:
Overview – Active Databases – Deductive Databases – RecursiveQueries in SQL – Mobile
Databases: Location and Handoff Management, Mobile TransactionModels, Concurrency –
Transaction Commit Protocols – Multimedia Databases.
UNIT IV XML AND DATAWAREHOUSE 9
XML Database: XML – XML Schema – XML DOM and SAX Parsers – XSL – XSLT – XPath
and XQuery – Data Warehouse: Introduction – Multidimensional Data Modeling – Star and
SnowflakeSchema – Architecture – OLAP Operations and Queries.
UNIT V INFORMATION RETRIEVAL AND WEB SEARCH 9
IR concepts – Retrieval Models – Queries in IR system – Text Preprocessing – Inverted
Indexing – Evaluation Measures – Web Search and Analytics – Ontology based Search -
Current trends.
TOTAL: 45 PERIODS
6
OUTCOMES:
On completion of the course, the student will be able to:
1. Design a distributed database system and execute distributed queries.
2. Use NoSQL database systems and manipulate the data associated with it.
3. Design a data warehouse system and apply OLAP operations.
4. Design XML database systems and validating with XML schema.
5. Apply knowledge of information retrieval concepts on web databases.
REFERENCES:
1. Henry F Korth, Abraham Silberschatz, S. Sudharshan, “Database System Concepts”, 6th
Edition, McGraw Hill, 2011.
2. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Seventh Edition,
Pearson Education/Addison Wesley, 2017.
3. C. J. Date, A. Kannan, S. Swamynathan, “An Introduction to Database Systems”, Eighth
Edition, Pearson Education, 2006.
4. Jiawei Han, MichelineKamber ,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. ShashankTiwari, “Professional NoSQL”, O’Reilly Media, First Edition, 2011.
7. Vijay Kumar, “Mobile Database Systems”, John Wiley & Sons, First Edition, 2006
