This course introduces you to the concepts of Database, Content Organization and some emerging trends. In any Information Storage and Retrieval System (ISAR), databases occupy the central position. Creation of efficient databases leads to successful retrieval of information contained in that database. A database is an organized collection of related data. In modern library environment, electronic databases are used to support a wide-range of information management operations and services. Knowledge in database concepts and applications becomes essential for the success of information professionals in present society. This course provides instruction on the database concepts, elements of DBMS, Database models, and fundamentals of database design, database implementation with a focus on library and information science practice, use of WINISIS, MySQL and some emerging trends. Related and current database management technologies will be used to illustrate the hands-on experiences.
Overview
Syllabus
S.No
Title of the Session
Weeks
1
DBMS –Introductory Concepts
Week - 1
2
Elements of DBMS
3
Types of Databases and Data Models
Week - 2
4
Relational Databases and Overview of DB Design
5
Various Key Constraints in RDBMS
6
Anomalies and Normalization
Week – 3
7
File Organization - I
8
File Organization - II
9
Search Strategy - I
Week – 4
10
Search Strategy - II
11
Content Organization and Formats
Week – 5
12
Indexing and Indexing Tools
13
Types of SQL Commands and Introduction to MySQL
14
Introduction to MySQL Commands - I
Week- 6
15
Introduction to MySQL Commands – II
16
Introduction to MySQL Commands – III
17
Introduction to MySQL Commands – IV
Week – 7
18
Introduction to MySQL Commands - V
19
Database Recovery
20
Transaction Management, Concurrency Control and Deadlock
Week – 8
21
Textual DBMS Major features
22
CDS/ISIS for Windows An Introduction
23
Use of Content Designators in WINISIS
Week - 9
24
Common Communication Format (CCF)in WINISIS
25
Steps in Developing Databases in WINISIS
26
Steps in WINISIS: FDT and Worksheet
Week -10
27
Steps in WINISIS: Pickup Lists in Worksheet
28
Steps in WINISIS: Basic Formatting Language
29
Steps in WINISIS: Advanced Formatting Language
Week - 11
30
Steps in WINISIS: Field Selection Table
31
Data Entry and Data Export/Import in WINISIS
32
Searching and Browsing in WINISIS
Week – 12
33
Utilities in WINISIS
34
CDS/ISIS Software Family
Week – 13
35
Textual Databases Evolution and Evaluation
36
Introduction to Open Access Database Services
Week - 14
37
Text Retrieval Engines
38
Multilingual Text Retrieval
Week – 15
39
Data Mashup
40
Linked Open Data for Libraries
Taught by
Dr. V. V. Subrahmanyam
