X
X
X

X
Swayam Central

Database and Content Organisation

By Dr. V. V. Subrahmanyam   |   Indira Gandhi National Open University

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.



SUMMARY

Course Status : Upcoming
Course Type : Core
Duration : 15 weeks
Start Date :
End Date :
Exam Date :
Category :
Level : Undergraduate

COURSE LAYOUT

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

BOOKS AND REFERENCES

Will be added along with the eContent

INSTRUCTOR BIO

                                                                                            
Dr. V. V. Subrahmanyam is Director and Associate Professor, School of Computer and Information Sciences (SOCIS), IGNOU, New Delhi. He has over 20+ years of research and teaching experience.

He has 45 publications in International Journals, proceedings of International / National conferences and Chapters in Books. He was conferred with the prestigious IRDP Award 2018 – “Teaching and Research Excellence” for the outstanding excellence and remarkable achievements in the field of Teaching, Research and Publications. He was resource person for many Refresher programmes, Workshops and FDPs. Also, he was resource person to many Interactive Radio Sessions (IRC) and Teleconferencing sessions of IGNOU. He was offering a Database and Content Organisation MOOC on SWAYAM platform from past 3 sessions which was attracting greater audience. He was peer reviewer for well reputed journals. He was Co-PI for for the Education Resource Planning (EdRP) project’s ePortfolio and Website Hosting Management System (WHMS) of the NMEICT project, MHRD, GoI. He is a LIFE MEMBER of ISTE, ICEIT and Computer Society of India (CSI).

COURSE CERTIFICATE

DOWNLOAD APP

FOLLOW US