Course

Unit 1

Introduction: Overview of DBMS, File vs DBMS, elements of DBMS. Database design: E-R model, Notations, constraints, cardinality and participation constraints

Unit 2

Relational Data Model: Introduction to relational model, Structure of relational mode, domain,keys, tuples to relational models, sql queries.Relational Database Design: Functional dependency, Normalization: 1NF,2NF,3NF,BCNF,table joins.

Unit 3

Introduction to Big Data: Types of Digital Data – Characteristics of Data – Evolution of Big Data – Definition of Big Data – Challenges with Big Data-3Vs of Big Data – Non Definitional traits of Big Data – Business Intelligence vs. Big Data – Data warehouse and Hadoop environment – Coexistence.

Unit 4

Big Data Analytics: Classification of analytics – Data Science – Terminologies in Big Data – CAP Theorem – BASE Concept. NoSQL: Types of Databases – Advantages – NewSQL – SQL vs. NOSQL vs NewSQL.

Unit 5

Introduction to Hadoop: Features – Advantages – Versions – Overview of Hadoop Eco systems
– Hadoop distributions – Hadoop vs. SQL – RDBMS vs. Hadoop – Hadoop Components – Architecture – HDFS – Map Reduce: Mapper – Reducer – Combiner – Partitioner – Searching – Sorting – Compression. Hadoop 2 (YARN): Architecture – Interacting with Hadoop Eco systems.

Course outcomes
CO 1: Understand the basic concepts of database and bigdata.
CO 2.: Understand the database models and its implementation techniques.
CO 3: Ability to learn big data implementation platforms
CO 4: Ability to learn data base technologies associated with big data.
CO 5: Ability to apply Data Intensive tasks using the Map Reduce Paradigm

Textbooks:

• Silberschatz A, Korth H F and Sudharshan S, “Database System Concepts”, Sixth Edition, Tata McGraw-Hill Publishing Company Limited, 2010.
• Seema Acharya, Subhashini Chellappan, “Big Data and Analytics”, Wiley Publication, 2015.

References:

1. Judith Hurwitz, Alan Nugent, Dr. Fern Halper, Marcia Kaufman, “Big Data for Dummies”,
2. John Wiley & Sons, Inc., 2013.
3. Tom White, “Hadoop: The Definitive Guide”, O’Reilly Publications, 2011.