| January 14th, 2021 11:10 AM | |
| vikash | Sathyabama Institute of Science and Technology BE CSE SCSA3008 Distributed database and Information Systems Syllabus 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 |
