Download - Database & content organisation course intro
DATABASE AND
CONTENT ORGANISATIONDR. V.V. SUBRAHMANYAMASSOCIATE PROFESSOR,
SCHOOL OF COMPUTER & INFORMATION SCIENCESIGNOU, NEW DELHI
COURSE INTRODUCTION This course provides instruction on the
database concepts, elements of DBMS, Database models, 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 OBJECTIVESAfter going through this course , students will be able to
:
Understand the Database concepts, elements of DBMS and Database Models
Review and articulate database functions and data modeling in LIS environment
Describe various File Organisation Techniques and Search Strategies
Understand the Relational Model and able to create conceptual design diagrams using Entity Relationship Modeling
Identify the concerns of Indexing
Use Structured Query Language to retrieve and manage information
Work with MySQL – RDBMS, executing all of its SQL commands
Identify basic concerns regarding Database Recovery, Transaction Management, Concurrency control and Deadlocks.
Access and use WINISISUnderstand the emerging trends namely Open
Access Database Services, Text Retrieval Engines, Multilingual Text Retrieval, Data Mashup and Linked Open Data for Libraries.
Course Duration: 12 weeksTarget Audience: Library and
Information Science Professionals, Students and Faculty
Eligibility for Enrolment: Passed 10 + 2 with Library & Information Science qualification atleast at Certificate level.
Course Pre-requisite: Basic knowledge of Library functions and services.
LEARNING OUTCOMES
After going through this course the learner will get a thorough understanding of use of databases in libraries, Types of databases and Data Models, RDBMS, MySQL commands, Database Recovery, Transaction Management, Concurrency Control, Deadlocks, CDS/ISIS, WINISIS package and some emerging trends.
SYLLABUSDBMS –Introductory ConceptsElements of DBMSTypes of Databases and Data ModelsRelational Databases and Overview of DB
DesignVarious Key Constraints in RDBMSAnomalies and NormalizationFile Organization Search Strategy Content Organisation and Formats
Indexing and Indexing ToolsTypes of SQL Commands and Introduction to
MySQLMySQL Commands Database RecoveryTransaction Management, Concurrency Control and
DeadlockTextual DBMS Major featuresCDS/ISIS for Windows An IntroductionUse of Content Designators in WINISISCommon Communication Format (CCF) in WINISIS
Steps in Developing Databases in WINISIS Steps in WINISIS: FDT and Worksheet Steps in WINISIS: Pickup Lists in Worksheet Steps in WINISIS: Basic Formatting LanguageSteps in WINISIS: Advanced Formatting LanguageSteps in WINISIS: Field Selection Table (FST)Data Entry and Data Export/Import in WINISISSearching and Browsing in WINISIS
Utilities in WINISISCDS/ISIS Software FamilyTextual Databases Evolution and
EvaluationIntroduction to Open Access Database
ServicesText Retrieval EnginesMultilingual Text RetrievalData MashupLinked Open Data for Libraries
COURSE DELIVERY THROUGH 4 QUADRANT APPROACH
eTutorialeContentWeb ResourcesSelf Assessment
SUBJECT MATTER EXPERTSDr. V.V. SubrahmanyamSchool of Computer & Information SciencesIndira Gandhi National Open University (IGNOU)New Delhi
Dr. Parthasarathi MukhopadhyayDept. of Library & Information ScienceUniversity of KalyaniKalyani, WB