Database and Content Organisation

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.

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