05-03-2017, 03:29 AM
SYLLABUS:-
UNIT-I
Concept of advanced database techniques, Impact of emerging database standards, Study of DDBMS architecture, New developments in database technology, Introduction of PL/SQL, PL/SQL Database Objects , Procedures, Functions, Packages, Triggers, Programmatic SQL, Embedded SQL, Dynamic SQL, and ODBC Standard. Parallel Database Architecture, Data base System Structure, Storage Manager, Query Processor.
UNIT-II
Introduction to the Relational Model ,Advanced SQL programming, Advanced Transaction Processing, Relational model conformity and Integrity, Data Replication, Security considerations, Relational Model of Data and RDBMS Implementation Techniques , Query optimization, Integrity Constraint Over relations, Querying relational data and relational Algebra.
UNIT-III
Object Relational database concepts, Temporal database concepts, Mobile Databases, Object based databases Complex data types, structured types and inheritance in SQL, object identity and reference types in SQL, Structure of XML, Document Schema, Querying and Transformation, API in XML, XML applications.
UNIT-IV
Postgre SQL, Oracle, IBM DB2 Universal Database, SQL standards, SQL1999, SQL: 2003, Standards for interoperability and integration, XML related specifications, X-Query, X-Path, Web Services, SOAP.
UNIT-I
Concept of advanced database techniques, Impact of emerging database standards, Study of DDBMS architecture, New developments in database technology, Introduction of PL/SQL, PL/SQL Database Objects , Procedures, Functions, Packages, Triggers, Programmatic SQL, Embedded SQL, Dynamic SQL, and ODBC Standard. Parallel Database Architecture, Data base System Structure, Storage Manager, Query Processor.
UNIT-II
Introduction to the Relational Model ,Advanced SQL programming, Advanced Transaction Processing, Relational model conformity and Integrity, Data Replication, Security considerations, Relational Model of Data and RDBMS Implementation Techniques , Query optimization, Integrity Constraint Over relations, Querying relational data and relational Algebra.
UNIT-III
Object Relational database concepts, Temporal database concepts, Mobile Databases, Object based databases Complex data types, structured types and inheritance in SQL, object identity and reference types in SQL, Structure of XML, Document Schema, Querying and Transformation, API in XML, XML applications.
UNIT-IV
Postgre SQL, Oracle, IBM DB2 Universal Database, SQL standards, SQL1999, SQL: 2003, Standards for interoperability and integration, XML related specifications, X-Query, X-Path, Web Services, SOAP.