Database and Content Organisation By Dr. V. V. Subrahmanyam

get iti website @ 1800/-

 

 

Language: 
English
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.
 
 

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 e-Content
 
Summary
Course Status :    Upcoming
Course Type :    Core
Duration :    15 weeks
Start Date :    01 Sep 2021
End Date :    
Exam Date :    
Category :    
Library and Information Sciences
Credit Points :    4
Level :    Diploma
 
 
 
Knowledge Partner: 

ITI Student Resume Portal

रिज्यूम पोर्टल का मुख्य उद्देश्य योग्य छात्रों की जानकारी सार्वजनिक पटल पर लाने की है जिससे जिन्हें आवश्यकता हो वह अपने सुविधा अनुसार छात्रों का चयन कर सकते हैं

ITI Student Resume

Search engine adsence