Book Description

This book is useful for IGNOU MCA students.A perusal of past questions papers gives an idea of the type of questions asked, the paper pattern and so on, it is for this benefit, we provide these IGNOU MCS-043: Advance Database Management System Notes.Students are advised to refer these solutions in conjunction with their reference books. It will help you to improve your exam preparations. This book contains Object-based Databases: Object-Oriented Databases: Object-oriented data model, Object, Oriented Languages, Persistent Programming Languages. Object-Relational Databases: Nested Relations, Complex Types. Inheritance, Reference Types, Querying with Complex Types, Functions and Procedures Storage for Object Databases. Distributed Databases : Distributed Data Storage, Distributed Transactions, Commit protocol, Concurrency Control in Distributed Databases, Availability, Distributed Query Processing. Parallel Databases: I/O Parallelism, Interquery Parallelism, Intraquery Parallelism, Intraoperation Parallelism, Interoperation Parallelism, Design of Parallel Systems. Deductive Databases: Introduction to Recursive Queries, Theoretical Foundations, Recursive Queries with Negation, From Datalog to SQL, Evaluating Recursive Queries. PL/SQL basics, blocks, architecture, variables an constants, attributes, character set, PL/SQL sentence structure, data types, precompiler, conditional and sequential control statements, control structures, conditional control, sequential control, cursors, exceptions, triggers, procedures and packages. Published by MeetCoogle