TEXT BOOK OF RDBMS (RELATIONAL DATABASE MANAGEMENT SYSTEMS)

TEXT BOOK OF RDBMS (RELATIONAL DATABASE MANAGEMENT SYSTEMS)
TEXT BOOK OF RDBMS (RELATIONAL DATABASE MANAGEMENT SYSTEMS)

Author :MRS. VIDYA H. BANKAR, MRS. DEEPASHREE K. MEHENDALE, MRS. SUJATA P. PATIL

Edition :

ISBN :

Price :Rs.160.00

About The Book

THIS BOOK IS WRITTEN ACCORDING TO THE REVISED SYLLABUS OF “RELATIONAL DATABASE MANAGEMENT SYSTEM” FOR SYBCA COURSE OF UNIVERSITY OF PUNE. BOOK IS MEANT FOR VARIOUS READERS FROM COLLEGE, UNIVERSITY STUDENTS WHO WISH TO LEARN BASIC AS WELL AS ADVANCED CONCEPTS IN RDBMS. IT GIVES EXPLANATION OF ALL RELATIONAL DATABASE MANAGEMENT CONCEPTS IN EASY-TO-UNDERSTAND MANNER FOR STUDENTS OF ALL STREMS. TRANSACTION MANAGEMENT CONCEPTS, CONCURRENCY CONTROL SCHEMES AND RECOVERY PROCEDURES ARE DESCRIBED IN COMPREHENSIVE MANNER TO KNOW INTERNAL WORKING OF RDBMS IN DEPTH. IT IS ALSO USEFUL FOR THE PROGRAMMERS WHO ARE BEGINNERS IN PROGRAMMING BASED ON THE ORACLE APPLICATIONS USING FULLY STRUCTURED PROGRAMMING LANGUAGE PL/SQL.

SALLIENT FEATURES:
• INTRODUCES RDBMS, ITS POPULAR PRODUCTS AND THEIR FEATURES.
• COVERS USE OF PL/SQL IN APPLICATION DEVELOPMENT, BANDING OF FUNCTION, PROCEDURE, CURSOR, TRIGGER, PACKAGE AND EXCEPTION BANDING.
• DETAILED DESCRIPTION OF VARIOUS TRANSACTION MANAGEMENT TOPICS SUCH AS TRANSCTION PROPERTIES, STATES, CONCURRENT EXECUTION AND SERIALIZABILITY.
• FOCUS ON CONCURRENCY CONTROL MECHANISM INCLUDING LOCK BASED, TIME-STAMP BASED AND VALIDATION BASED PROTOCOLS AND CONCEPT OF DEAD LOCK BANDING.
• DISCUSSES DIFFERENT TYPES OF FAILURES AND DATABASE RECOVERY SCHEME AGAINST THESE FAILURES.
• VARIETY OF SOLVED EXAMPLES ON TRANSACTION, CONCURRENCY AND RECOVERY SCHME.
• EACH CHAPTER ENDS WITH QUESTIONS THAT MAY BE EXPECTED IN FUTURE EXAMS AND ALSO QUESTIONS FROM PREVIOUSLY HELD UNIVERSITY EXAMS.