+- studentsuvidha (https://studentsuvidha.com/forum)
+-- Forum: Student Stuffs (https://studentsuvidha.com/forum/Forum-Student-Stuffs)
+--- Forum: Indraprastha University IPU notes and papers (https://studentsuvidha.com/forum/Forum-Indraprastha-University-IPU-notes-and-papers)
+---- Forum: IPU B.tech/ B.E. papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-B-tech-B-E-papers-and-Notes-free-downloads)
+----- Forum: IPU B.tech/ B.E. C.Sc. papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-B-tech-B-E-C-Sc-papers-and-Notes-free-downloads)
+------ Forum: 7th semester IPU B.tech CSC papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-7th-semester-IPU-B-tech-CSC-papers-and-Notes-free-downloads)
+------ Thread: Advance DBMS IPU CSC notes and question paper free download (/Thread-Advance-DBMS-IPU-CSC-notes-and-question-paper-free-download)
Advance DBMS IPU CSC notes and question paper free download - Dipesh S - 05-03-2017
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.