Scribd
Upload
18 views2 pages

Advances in Database

Uploaded by

jon higk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
18 views2 pages

Advances in Database

Uploaded by

jon higk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

IT5007 ADVANCES IN DATABASES LTPC

3 00 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 – Distributed Data Storage – Distributed Transactions – Commit
Protocols – Concurrency Control – Distributed Query Processing.

Suggested Activities:
• Practical - Design of distributed database with fragmentation using any
DBMS.
• Flipped classroom on distributed transaction protocols.
• Writing distributed queries and optimizing the queries.

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, CURD Operations,
CQL Types – HIVE: Data types, Database Operations, Partitioning – HiveQL –
OrientDB Graph database – OrientDB Features.

Suggested Activities:
• Exploring MongoDB using JAVA/Python/Ruby/PHP.
• Perform Database Operations using MongoDB/Cassandra/HIVE.
• Scenario based query development for database applications.

UNIT III ADVANCED DATABASE SYSTEMS 9


Spatial Databases: Spatial Data Types, Spatial Relationships, Spatial Data
Structures, Spatial Access Methods – Temporal Databases: Overview – Active
Databases – Deductive Databases – Recursive Queries in SQL – Mobile
Databases: Location and Handoff Management, Mobile Transaction Models,
Concurrency – Transaction Commit Protocols – Multimedia Databases.

Suggested Activities:
• Individual/group activities for application specific data handling.
• Discussion about advantages and drawbacks of transaction models for
different applications involving spatial-temporal data.
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 Snowflake Schema – Architecture – OLAP Operations
and Queries.

Suggested Student Activities:


• Flipped classroom on demonstrate the operations on XML data and data
warehouse.
• Practical - Use tools to solve data access scenarios.

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 – Current
trends.

Suggested Student Activities:


• Flipped classroom on queries in IR.
• Practical - Install any IR framework such as SOLR, and experiment with
it.

You might also like