| 000 -LEADER |
|---|
| fixed length control field |
nam a22 7a 4500 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
OSt |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20200309115201.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
190826b xxu||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9789350164891 |
| 040 ## - CATALOGING SOURCE |
|---|
| Transcribing agency |
AEF |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Edition number |
23rd ed. |
| Classification number |
658.403 |
| Item number |
BHA |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| 9 (RLIN) |
1051 |
| Personal name |
Bharti, R. |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Text book of relational database management system: |
| Remainder of title |
Computer science (CS-202): paper-II, Sem-II |
| Statement of responsibility, etc. |
According to new CBCS revised syllabus w.e.f. 2019-2020 |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
1st ed. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. |
|---|
| Place of publication, distribution, etc. |
Pune: |
| Name of publisher, distributor, etc. |
vision publication, |
| Date of publication, distribution, etc. |
2019. |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
210 p. : |
| Dimensions |
25 cm |
| 501 ## - WITH NOTE |
|---|
| With note |
Contents<br/><br/>1.Relational Database Design Using PLSQL <br/><br/>1. Introduction to PL/SQL <br/><br/>2. PL/PgSQL <br/><br/>3. Controlling the Program Flow, Conditional Statements, Loops <br/><br/>4. Stored Procedures<br/><br/>5. Stored Functions <br/><br/>6. Handling Errors and Exceptions <br/><br/>7. Cursors<br/><br/>8. Triggers <br/><br/>2. Transaction Concepts and Concurrency Control<br/><br/>1. Introduction<br/><br/>2. Describe a Transaction, Properties of Transaction, State of the Transaction <br/><br/>3. Executing Transactions Concurrently Associated Problem in Concurrent Execution <br/><br/>4. Schedules, Types of Schedules, Concept of Serializability, Precedence Graph of Serializability<br/><br/>5. Ensuring Serializability by Locks, Different Lock Modes,2PL and its Variations<br/><br/>6. Basic Timestamp Method for Concurrency, Thomas Write Rule <br/><br/>7. Locks with Multiple Granularity, Dynamic Database Concurrency (Phantom Problem) <br/><br/>8. Timestamps Versus Locking <br/><br/>9. Deadlock and Deadlock Handling-Deadlock Avoidance (wait-die, wound-wait)<br/><br/>10.Deadlock Avoidance (Wound-Wait, Wait-die) <br/><br/>11.Deadlock Detection and Recovery (Wait For Graph) <br/><br/> 3. Database Integrity and Security Concepts <br/><br/>1. Introduction<br/><br/>2. Domain Constraints 2<br/><br/>3. Referential Integrity <br/><br/>4. Introduction to Database Security Concepts <br/><br/>5. Methods of Database Security<br/><br/>6. Use of Views in Security Enforcement <br/><br/>7. Overview of Encryption Technique for Database <br/><br/>8. Statistical Database Security <br/><br/>4. Crash Recovery <br/><br/>1. Introduction 2<br/><br/>2. Failure Classification <br/><br/>3. Recovery Concepts<br/><br/>4. Log Based Recovery Techniques (Deferred and Immediate Update) <br/><br/>5. Checkpoints, Relationship between Database Manager and Buffer Cache. Aries recovery Algorithm <br/><br/>6. Recovery with Concurrent Transactions (Rollback, Checkpoints, Commit) <br/><br/>7. Database Backup and Recovery from Catastrophic Failures<br/><br/>5. Other Databases <br/><br/>1. Introduction to Parallel and Distributed Databases<br/><br/>2. Introduction to Object Based Databases <br/><br/>3. XML databases <br/><br/>4. NoSQL Databases <br/><br/>5. Multimedia Databases <br/><br/>6. Big Data Databases |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Relational databases |
| 9 (RLIN) |
1325 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Management information systems |
| 9 (RLIN) |
1326 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
File organization (Computer science) |
| 9 (RLIN) |
599 |
| 700 10 - ADDED ENTRY--PERSONAL NAME |
|---|
| Personal name |
Bhat, V. |
| 9 (RLIN) |
1124 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
|
| Koha item type |
|
