Introduction to Datawarehousing. Multidimensional Model/ Data Modelling, Hierarchy of Data, Multidimensional Schema , Star Schema, Snowflake Schema, Fact Constellation. Introduction to Data Mining Data Mining, Classification, Clustering, Association Rules, Sequential Pattern Discovery, Regression and Deviation.
Introduction, Datewarehousing: Properties, Datawarehousing: Applications, Multidimensional Model/ Data Modelling in DW, Hierarchy of Data, Operations in Multidimensional Model, Multidimensional Schema , Star Schema, Snowflake Schema, Fact Constellation, and other topics.
Overview, Measures of query cost, Selection and join operations, Evaluation of Expressions, Introduction to Query Optimization, Estimation,Transformation of Relational Expressions
Introduction, Query Processing Process, Measures of Query Cost, Disk Access Costs, Selection: Algorithms, Complex Selections: Algorithms, and other topics.
Introduction to parallel databases, Parallel : Query Evaluation, Parallelizing, individual operations; sorting, joins, etc.
Distributed databases, concepts, data fragmentation, Replication and allocation techniques for distributed database design. Query Processing in distributed databases, concurrency control and recovery in distributed databases
Distributed Computing System, Distributed DB, Distributed Database, Advantages of DDBMS, Special Functions of DDBMS, Fragmentation, Horizontal, Vertical, Mixed/ Hybrid Fragmentation, Fragmentation Schema, Allocation, Allocation Schema, and other topics.
Purpose of Normalization, Data Redundancy and Update Anomalies, Functional Dependencies: Basic concepts, closure of set of functional dependencies, closure of attribute set, canonical cover, Decomposition: lossless join decomposition and dependency preservation, The Process of Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF
Introduction, Normalization, Purpose of Normalization, Updation Anomalies, Deletion Aomalies, NULL values, Lossy Decompostion, and other topics.
Need of OODBMS, Storing Objects in Relational Database, Introduction to OO Data Models, Persistent Programming Languages, Pointer Swizzling Techniques
Object Relational DBs, SQL 3/ SQL 1999, Nested Relational Model
Object Oriented DBs, Features, OIDs, Complex Objects, Type Constructors, Unstructured Complex Objects, Structured Complex Objects, and other topics.
Structured unstructured and semi structured data. XML hierarchical Data Model, XML Document, DTD and XML Schema
XML Documents & databases, XML Query
Introduction, Unstructured/ Semi Structured/ Structured Data, XML hierarchical Model, Types of XML Docs, Well Formed Vs Valid, DTD, and other topics.