| PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8 | PO9 | PO10 | PO11 | PO12 | PSO1 | PSO2 | PSO3 | |
| CO1 | 3 | 2 | 2 | ||||||||||||
| CO2 | 3 | 2 | 2 | ||||||||||||
| CO3 | 3 | 2 | 2 | ||||||||||||
| CO4 | 3 | 2 | 2 | ||||||||||||
| CO5 | 3 | 2 | 2 | ||||||||||||
| Score | 15 | 10 | 10 | ||||||||||||
| Course Mapping | 3 | 2 | 2 |
{{{credits}}}
| L | T | P | C |
| 3 | 0 | 0 | 3 |
The student should be able to:
- To acquire knowledge on parallel and distributed databases and their applications
- To study the usage and applications of Object and Object Relational Databases
- To learn about XML Database
- To acquire Knowledge in Unstructured Databases
- To understand the concepts of HBase and HIVE.
{{{unit}}}
| UNIT I | PARALLEL AND DISTRIBUTED DATABASES | 9 |
Database System Architectures: Centralized and client-server architectures – Server system architectures – Parallel systems – Distributed systems; Parallel Databases: I/O parallelism – Inter and intra query parallelism – Inter and intra operation parallelism – Design of parallel systems – Distributed database concepts – Distributed data storage – Distributed transactions – Commit protocols – Concurrency control – Distributed query processing – Case studies.
{{{unit}}}
| UNIT II | OBJECT AND OBJECT RELATIONAL DATABASES | 9 |
Concepts for Object Databases: Object identity – Object structure – Type constructors – Encapsulation of operations – Methods – Persistence – Type and class hierarchies – Inheritance – Complex Objects – Object database standards; Languages and Design: ODMG model – ODL – OQL – Object relational and extended; Relational Systems: Object relational features in SQL/Oracle – Case studies.
{{{unit}}}
| UNIT III | XML DATABASES | 9 |
XML Databases: XML-related technologies – XMLSchema – XML Query Languages – Storing XML in databases – XML and SQL – Native XML databases – Web databases.
{{{unit}}}
| UNIT IV | NOSQL DATABASE | 9 |
Why NoSQL: Aggregate datamodels – The CAP theorem – Key-value databases – Document databases – Column-Family stores – Graph databases.
{{{unit}}}
| UNIT V | HBASE AND HIVE | 9 |
Introduction to Hadoop and MapReduce; HBase Basic Features: CRUD operations – Batch operations – Row Locks; Advanced Features: Filters – Counters – Htablepool; HiveQL: Data definition – Data manipulation – Queries.
\hfill Total Periods: 45
After the completion of this course, students will be able to:
- Design Parallel and Distributed Databases (K3)
- Understand Object and Object Relational Databases (K2)
- Design an application using XML Database (K3)
- Implement different NoSQL Databases (K3)
- Design an application using the concepts of HBase and HIVE (K3).
- Elmasri, Ramez, Shamkant Navathe, “Fundamentals of database systems”, Addison-Wesley Publishing Company, 2011 (Units I, II, III)
- Fowler, Martin, Pramod Sadalage, “NoSQL Distilled” Addison Wesely, 2013 (Unit IV).
- George, Lars, “HBase: The Definitive Guide: Random Access to Your Planet-Size Data”, O Reilly Media Inc, 2011 (Unit V).
- Capriolo, Edward, Dean Wampler, Jason Rutherglen. “Programming Hive: Data Warehouse and Query Language for Hadoop”, O’Reilly Media Inc, 2012.
- Henry F Korth, Abraham Silberschatz, S Sudharshan, “Database System Concepts”, 6th Edition, McGraw Hill, 2011.
- Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T Snodgrass, V S Subrahmanian, Roberto Zicari, “Advanced Database Systems”, Morgan Kaufmann publishers, 2006
- Membrey, Peter, Eelco Plugge, DUPTim Hawkins. “The Definitive Guide to MongoDB: The NoSQL Database for Cloud and Desktop Computing”, Apress, 2011.