[vikash]

Sathyabama Institute of Science and Technology BE CSE SCSA3008 Distributed database and Information Systems Syllabus

SATHYABAMA INSTITUTE OF SCIENCE AND TECHNOLOGY SCHOOL OF COMPUTING

SCSA3008
DISTRIBUTED DATABASE AND INFORMATION
SYSTEMS
L T P Credits Total Marks
3 0 0 3 100

UNIT 1 INTRODUCTORY CONCEPTS AND DESIGN OF (DDBMS) 9 Hrs.
Data Fragmentation - Replication and allocation techniques for DDBMS - Methods for designing and implementing
DDBMS - designing a distributed relational database - Architectures for DDBMS - Cluster federated - parallel databases
and client server architecture - Overview of query processing.

UNIT 2 DISTRIBUTED SECURITY AND DISTRIBUTED DATABASE APPLICATION TECHNOLOGIES 9 Hrs.
Overview of security techniques - Cryptographic algorithms - Digital signatures - Distributed Concurrency Control -
Serializability theory - Taxonomy of concurrency control mechanisms - Distributed deadlocks – Distributed Database
Recovery - Distributed Data Security - Web data management - Database Interoperability.

UNIT 3 ADVANCED IN DISTRIBUTED SYSTEMS 9 Hrs.
Authentication in distributed systems - Protocols based on symmetric cryptosystems - Protocols based on asymmetric
cryptosystems - Password-based authentication - Unstructured overlays - Chord distributed hash table - Content
addressable networks (CAN) - Tapestry - Some other challenges in P2P system design - Tradeoffs between table storage
and route lengths - Graph structures of complex networks - Internet graphs - Generalized random graph networks.

UNIT 4 FUNDAMENTALAS OF INFORMATION SYSTEMS 9 Hrs.
Defining information – Classification of information – Presentation of information systems – Basics of Information systems –
Functions of information systems – Components of Information systems- Limitations of Information systems – Information
System Design.

UNIT 5 ENTERPRISE COLLOBRATION SYSTEMS 9 Hrs.
Groupware – Types of groupware – Enterprise Communication tools – Enterprise Conferencing tools – Collaborative work
management tools – Information System for Business operations – transaction processing systems – functional Information
Systems – Decision Support systems – Executive Information systems – Online Analytical processing.
Max. 45 Hrs.

COURSE OUTCOMES
On completion of the course, student will be able to
CO1 - Identify the introductory distributed database concepts and its structures.
CO2 - Produce the transaction management and query processing techniques in DDBMS.
CO3 - Develop in-depth understanding of relational databases and skills to optimize database performance in practice.
CO4 - Critiques on each type of databases.
CO5 - Analyse, Design and present the information systems.
C06 - Designing of decision support system and tools for Business operations.

TEXT / REFERENCE BOOKS
1. George Coulouris, Jean Dollimore, Tim Kindberg, “Distributed Systems Concepts and Design”, 5th Edition, Pearson
Education Asia, 2012.
2. Ajay D. Kshemkalyani, MukeshSinghal, "Distributed Computing: Principles, Algorithms, and Systems", Cambridge
University Press, 2008.
3. Distributed Databases - Principles and Systems; Stefano Ceri; Guiseppe Pelagatti; Tata McGraw Hill; 2006.
4. Ralph Stair and George Reynolds. , “Principles of Information Systems” Course Technology, Inc.,2006.

END SEMESTER EXAMINATION QUESTION PAPER PATTERN
Max. Marks: 100 Exam Duration: 3 Hrs.
PART A: 10 Questions of 2 marks each-No choice 20 Marks
PART B: 2 Questions from each unit with internal choice, each carrying 16 marks 80 Marks