Course Archives Documentation Research and Training Centre Unit
Course: Information Storage, Retrieval and DBMS
Instructor: B S Dayasagar
Room: G21
Level: Postgraduate
Time: Currently offered
Syllabus
Past Exams


Syllabus: Different types of storage media, physical level of a DBMS use of B-trees, Trees. Overview of IR Systems, Historical Perspectives. Document Representation: Statistical Characteristics of Text, Basic Query Processing. Classic IR: basic concepts, Boolean model, vector model, probabilistic model. Alternative IR: set theoretic, algebraic models, and probabilistic models (Bayesian networks). Structured Text Retrieval Models: model based on non-overlapping lists and proximal nodes. Text Operations: document pre-processing (word stemming, stop words, thesauri), document clustering. IR Systems and the WWW, Heterogeneous Information Sources, Intelligent Web Agents. Evaluation of IR. Search methodology, algorithms. Cognitive IR modeling. Searching vs. browsing; dynamic query formulation and reformulation. Query: keyword based querying, pattern matching, structural queries, query protocols. Hybrid statistical and knowledge approaches: query expansion and refinement based on a similarity thesaurus and ontologies. Introduction to DBMS - File management vs. Database management, integrity and security issues. E-R Models, Enhanced E-R Models. Logical Database Design, Relational Database Model, Normalization. SQL, Implementation in MySql or PostgreSql. Concurrency in databases. Object-Oriented Models. Multimedia Databases. Database Security - models, security implementation, relationship to web databases

Reference Texts:

Evaluation:
Midterm Exam 40 marks
Assignment --- marks
Final Exam 60 marks
Total 100 marks


Top of the page

Past Exams
Midterm
17.pdf 18.pdf
Semestral
16.pdf 17.pdf
Supplementary and Back Paper

Top of the page

[Indian Statistical Institute]