FT/GN/68/01/23.01.16
SRI VENKATESWARA COLLEGE OF ENGINEERING COURSE DELIVERY PLAN - THEORY
Page 1 of 5 LP: IT6701
Department of Information Technology B.Tech
: Information Technology
PG Specialisation
: NA
Regulation: 2013
Rev. No: 00 Date: 01.07.2016
Sub. Code / Sub. Name : IT6701/ Information Management Unit
: I
Unit Syllabus: Database Modelling, Management and Development Database design and modelling - Business Rules and Relationship; Java database Connectivity (JDBC), Database connection Manager, Stored Procedures. Trends in Big Data systems including NoSQL - Hadoop HDFS, MapReduce, Hive, and enhancements. Objective: In this unit, the basic Database design concepts and the procedures for establishing the connectivity with a database will be discussed. The recent trends in Big Data systems and the tools that are developed will be discussed in detail. Session No *
Topics to be covered
Ref
Teaching Aids
1
Database design and modelling – Basic Database concepts, Database design methodologies, E-R Model, Relational Data Model
RB-1, CH-2 (55-70)
BB/PPT
2
Business Rules and Relationship – Constraints and its types, Derivation, Structural Assertion and Action Assertion
RB-1, CH-2 (72-94)
BB/PPT
3
Java database Connectivity (JDBC) – JDBC Architecture, JDBC Connectivity steps, Transactions and JDBC
RB-1, CH-8 (359-365)
BB/PPT
4
Database connection Manager – Driver Manager, Types of drivers and connection, Methods and implementation of connection manager
RB-1, CH-8 (335-344)
BB/PPT
5
Stored Procedures – Creating and dropping stored procedures, Examples
RB-1, CH-8 (355-357)
BB/PPT
6
Trends in Big Data systems including NoSQL – Big Data Introduction, NoSQL Database, Types of NoSQL Database, Data Model and Frameworks
R2
BB/PPT
7
Hadoop HDFS – Hadoop Introduction, Architecture, Basic Features, API
R3
BB/PPT
8
MapReduce – Need for MapReduce, Workflow and Implementation
R3
BB/PPT
9
Hive and enhancements – Architecture, Data Model and Workflow
R3
BB/PPT
Content beyond syllabus covered (if any): Application using Hadoop and HDFS. Applications of Hive.
* Session duration: 50 minutes
FT/GN/68/01/23.01.16
SRI VENKATESWARA COLLEGE OF ENGINEERING COURSE DELIVERY PLAN - THEORY
Page 2 of 5
Sub. Code / Sub. Name: IT6701/ Information Management Unit : II
Unit Syllabus : Data Security and Privacy
Program Security, Malicious code and controls against threats; OS level protection; Security – Firewalls, Network Security Intrusion detection systems. Data Privacy principles. Data Privacy Laws and compliance. Objective: In this unit, the general threats for the information management system and the basic features of program security and the principles used are discussed in detail. Session No *
Topics to be covered
Ref
Teaching Aids
10
Program Security – Bugs and flaws, Types of flaws, Security Implications
TB-2, CH-3 (117-121)
BB/PPT
11
Malicious code and Controls against threats – Virus and Malicious codes, Types of Viruses
TB-2, CH-3 (122-135)
BB/PPT
12
Malicious code and Controls against threats – Signature of virus, Salami attack and control over threats
TB-2, CH-3 (126-145)
BB/PPT
13
OS level protection – Assets and Vulnerability, Security design principles
TB-2, CH-4 (201-217)
BB/PPT
14
OS level protection – Unix/Linux security model, Window NT security model
TB-2, CH-4 (228-242)
BB/PPT
15
Firewalls – Need for Firewalls, Firewall Characteristics, Types of Firewalls
TB-2, CH-7 (486-495)
BB/PPT
16
Network Security Intrusion Detection Systems – Components of IDS, Types of IDS, IDS Data
TB-2, CH-7 (496-505)
BB/PPT
17
Data Privacy principles – What is privacy, Privacy and the law
TB-2, CH-10 (622-632)
BB/PPT
TB-2, CH-10 (635-646)
BB/PPT
Data Privacy Laws and Compliance – Privacy Failure consequences, Privacy Framework, Laws for data privacy Content beyond syllabus covered (if any): 18
* Session duration: 50 mins
FT/GN/68/01/23.01.16
SRI VENKATESWARA COLLEGE OF ENGINEERING COURSE DELIVERY PLAN - THEORY
Page 3 of 5
Sub. Code / Sub. Name: IT6701/ Information Management Unit : III
Unit Syllabus: Information Governance Master Data Management (MDM) – Overview, Need for MDM, Privacy, regulatory requirements and compliance. Data Governance – Synchronization and data quality management Objective: In this unit, the overview and the need for information management along with the mechanisms to govern the data are discussed in detail. Session No *
Topics to be covered
Ref
Teaching Aids
19
Master Data Management (MDM) – Defining Master Data, Challenges of creating and managing master data
TB-1, CH-1 (5-10)
BB/PPT
20
Master Data Management (MDM) –Defining Master Data Management, MDM Classification Dimensions
TB-1, CH-1 (12-20)
BB/PPT
21
Overview, Need for MDM – MDM Challenges
TB-1, CH-2 (25-43)
BB/PPT
22
Overview, Need for MDM – MDM Architecture, Need for MDM
TB-1, CH-4 (79-90)
BB/PPT
23
Privacy, regulatory requirements and compliance – Risk Taxanomy, Benefits and challenges of Risks
TB-1, CH-8 (195-210)
BB/PPT
24
Privacy, regulatory requirements and compliance – Overview of security technologies, Secured MDM
TB-1, CH-9 (225-240)
BB/PPT
25
Data Governance – Basics of Data Governance, Approaches in Data Governance
TB-1, CH-17 (411-422)
BB/PPT
26
Synchronization and Data Quality Management – Goals and Technology for Data Synchronization
TB-1, CH-16 (367-394)
BB/PPT
TB-1, CH-17 (404-409)
BB/PPT
Synchronization and Data Quality Management – Data Quality Management, Data Quality Process Content beyond syllabus covered (if any): 27
MDM Applications in various sectors
* Session duration: 50 mins
FT/GN/68/01/23.01.16
SRI VENKATESWARA COLLEGE OF ENGINEERING COURSE DELIVERY PLAN - THEORY
Page 4 of 5
Sub. Code / Sub. Name: IT6701/ Information Management Unit : IV
Unit Syllabus: Information Architecture Principles of Information architecture and framework, Organizing information, Navigation systems and Labelling systems, Conceptual design, Granularity of Content. Objective: In this unit, the description about frame work, organization, designing the system, navigation and granularity of the stored information is elaborated in detail. Session No *
Topics to be covered
Ref
Teaching Aids
28
Principles of Information architecture and framework – Defining Information Architecture, Practicing Information Architecture
TB-3, CH-1 (3-23)
BB/PPT
29
Principles of Information architecture and framework – Information Architecture Components, Visualizing Information Architecture
TB-3, CH-4 (41-49)
BB/PPT
30
Organizing information – Challenges of organizing the information, Organizing schemes, structures and social classification
TB-3, CH-5 (53-77)
BB/PPT
31
Navigation systems - Types of Navigation Systems, Gray Matters, Browser Features, Building Context
TB-3, CH-7 (115-119)
BB/PPT
32
Navigation systems - Improving Flexibility, Embedded Navigation Systems, Advanced Navigation Approaches
TB-3, CH-7 (120-142)
BB/PPT
33
Labelling systems – Need for labeling system, Varieties of Labels and Design of labels
TB-3, CH-6 (82-114)
BB/PPT
34
Conceptual design – Search system anatomy, Search algorithm, Query builders
TB-3, CH-8 (149-162)
BB/PPT
35
Granularity of Content – Metadata, Technical Lingo, Semantic Relationships
TB-3, CH-9 (194-216)
BB/PPT
36
Granularity of Content –Faceted Classification
TB-3, CH-9 (221-229)
BB/PPT
Content beyond syllabus covered (if any):
* Session duration: 50 mins
FT/GN/68/01/23.01.16
SRI VENKATESWARA COLLEGE OF ENGINEERING COURSE DELIVERY PLAN - THEORY
Page 5 of 5
Sub. Code / Sub. Name: IT6701/ Information Management Unit : V
Unit Syllabus: Information Lifecycle Management Data retention policies: Confidential and Sensitive data handling, lifecycle management costs. Archive data using Hadoop. Testing and delivering big data applications for performance and functionality; Challenges with data administration Objective: In this unit, the various policies that are used for data retention and the evaluation factors for performance and functionality are discussed. Session No *
Topics to be covered
Ref
Teaching Aids
37
Data retention policies: Confidential and Sensitive data handling – Sensitive Data, Confidential Data
TB-2, CH-6 (353-357)
BB/PPT
38
Lifecycle management costs – Steps in Information Lifecycle Management
R5
BB/PPT
39
Lifecycle management costs –Driving Cost for ILM
R5
BB/PPT
40
Archive data using Hadoop – Architecture and Steps
R3
BB/PPT
41
Testing big data applications for performance and functionality – Testing Basics, Types of Testing
R3
BB/PPT
R3
BB/PPT
R6
BB/PPT
43
Delivering big data applications for performance and functionality – Implementation and Maintenance, Cost Monitoring Challenges with data administration – Role of Data Admin, Levels of Administration
44
Challenges with data administration – Policy, procedure and standards, Threats to data
TB-2, CH-7 (342-359)
BB/PPT
45
Challenges with data administration - Methods to classify data
TB-2, CH-7 (363-369)
BB/PPT
42
Content beyond syllabus covered (if any):
* Session duration: 50 mins
