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

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

अडाना | अभोगी कान्ह्डा | अल्हैया बिलावल | अल्हैयाबिलावल | अहीर भैरव | अहीरभैरव | आनंदभैरव | आसावरो | ककुभ | कलावती | काफ़ी | काफी | कामोद | कालिंगड़ा जोगिया | कीरवाणी | केदार | कोमल-रिषभ आसावरी | कौशिक कान्हड़ा | कौशिक ध्वनी (भिन्न-षड्ज) | कौसी  | कान्ह्डा | खंबावती | खमाज | खम्बावती | गारा | गुणकली | गुर्जरी तोडी | गोपिका बसन्त | गोरख कल्याण | गौड मल्हार | गौड सारंग | गौड़मल्लार | गौड़सारंग | गौरी | गौरी (भैरव अंग) |चन्द्रकान्त | चन्द्रकौन्स | चारुकेशी | छाया-नट | छायानट | जयजयवन्ती | जयतकल्याण | जलधर  | केदार | जेजैवंती | जेतश्री | जैत | जैनपुरी | जोग | जोगकौंस | जोगिया | जोगेश्वरी | जौनपुरी | झिंझोटी | टंकी | तिलंग | तिलंग बहार | तिलककामोद | तोडी | त्रिवेणी | दरबारी कान्हड़ा | दरबारी कान्हडा | दीपक | दुर्गा | दुर्गा द्वितीय | देव गन्धार | देवगंधार | देवगिरि बिलावल | देवगिरी | देवर्गाधार | देवश्री | देवसाख | देश | देशकार | देस | देसी | धनाश्री | धानी | नंद | नट भैरव | नट राग | नटबिलावल | नायकी कान्ह्डा | नायकी द्वितीय | नायकीकान्हड़ा | नारायणी | पंचम | पंचम जोगेश्वरी | पटदीप | पटदीपकी | पटमंजरी | परज | परमेश्वरी | पहाड़ी | पीलू | पूरिया | पूरिया कल्याण | पूरिया धनाश्री | पूर्याधनाश्री | पूर्वी | प्रभात | बंगालभैरव | बड़हंससारंग | बसन्त | बसन्त मुखारी | बहार | बागेश्री | बागेश्वरी | बिलावल शुद्ध | बिलासखानी तोडी | बिहाग | बैरागी | बैरागी तोडी | भंखार | भटियार | भीम | भीमपलासी | भूपाल तोडी | भूपाली | भैरव | भैरवी | मधमाद सारंग | मधुकौंस | मधुवन्ती | मध्यमादि सारंग | मलुहा | मल्हार | मांड | मारवा | मारू बिहाग | मालकौंस | मालकौन्स | मालगुंजी | मालश्री | मालीगौरा | मियाँ की मल्लार | मियाँ की सारंग | मुलतानी | मेघ | मेघ मल्हार | मेघरंजनी | मोहनकौन्स | यमन | यमनी | रागेश्री | रागेश्वरी | रामकली | रामदासी मल्हार | लंका-दहन सारंग | लच्छासाख |ललिट | ललित | वराटी | वसंत | वाचस्पती | विभाग | विभास | विलासखानी तोड़ी | विहाग | वृन्दावनी सारंग | शंकरा | शहाना | शहाना कान्ह्डा | शिवभैरव | शिवरंजनी | शुक्लबिलावल | शुद्ध कल्याण | शुद्ध मल्लार | शुद्ध सारंग | शोभावरी | श्याम | श्याम कल्याण | श्री | श्रीराग | षट्राग | सरपर्दा | सरस्वती | सरस्वती केदार | साजगिरी | सामंतसारंग | सारंग (बृंदावनी सारंग) | सिंदूरा | सिंधुभैरवी | सिन्धुरा | सुघराई | सुन्दरकली | सुन्दरकौन्स | सूरदासी मल्हार | सूरमल्लार | सूहा | सैंधवी | सोरठ | सोहनी | सौराष्ट्रटंक | हंसकंकणी | हंसकिंकिणी | हंसध्वनी | हमीर | हरिकौन्स | हामीर | हिंदोल | हिन्डोल | हेमंत |हेमकल्याण | हेमश्री |