Welcome to UE Central Library

Keep Smiling

Database system concepts / (Record no. 175)

MARC details
000 -LEADER
fixed length control field 07998cam a22002414a 4500
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20200630111235.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 050303s2006 maua b 001 0 eng
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 0072958863 (hard : alk. paper)
022 ## - INTERNATIONAL STANDARD SERIAL NUMBER
International Standard Serial Number 9780071244763 (pbk)
040 ## - CATALOGING SOURCE
Transcribing agency DLC
082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.74
Edition number 22
Item number Si326
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Silberschatz, Abraham.
245 10 - TITLE STATEMENT
Title Database system concepts /
Statement of responsibility, etc Abraham Silberschatz, Henry F. Korth, S. Sudarshan.
250 ## - EDITION STATEMENT
Edition statement 5th ed.
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Place of publication, distribution, etc Boston :
Name of publisher, distributor, etc McGraw-Hill Higher Education,
Date of publication, distribution, etc 2006
300 ## - PHYSICAL DESCRIPTION
Extent xxvi, 1142 p.
Other physical details ill. ;
Dimensions 24 cm.
500 ## - GENERAL NOTE
General note Includes bibliographical references and index.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Database management.
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Korth, Henry F.
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Sudarshan, S.
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Koha item type Books
505 0# - FORMATTED CONTENTS NOTE
Formatted contents note Contents<br/>Preface xv<br/>Chapter 1 Introduction<br/>1.1 Database System Applications 1<br/>1.2 Database Systems versus File Systems 3<br/>1.3 View of Data 5<br/>1.4 Data Models 7<br/>1.5 Database Languages 11<br/>1.6 Database Users and Administrators 13<br/>1.7 Transaction Management 15<br/>1.8 Database System Structure 16<br/>1.9 Application Architectures 18<br/>1.10 History of Database Systems 18<br/>1.11 Summary 21<br/>Exercises 23<br/>Bibliographical Notes 24<br/>PART 1 DATA MODELS<br/>Chapter 2 Entity-Relationship Model<br/>2.1 Basic Concepts 27<br/>2.2 Constraints 33<br/>2.3 Keys 35<br/>2.4 Design Issues 37<br/>2.5 Entity-Relationship Diagram 42<br/>2.6 Weak Entity Sets 47<br/>2.7 Extended E-R Features 49<br/>2.8 Design of an E-R Database Schema 56<br/>2.9 Reduction of an E-R Schema to Tables 62<br/>2.10 The Unified Modeling Language UML 68<br/>2.11 Summary 70<br/>Exercises 72<br/>Bibliographical Notes 77<br/>Chapter 3 Relational Model<br/>3.1 Structure of Relational Databases 79<br/>3.2 The Relational Algebra 89<br/>3.3 Extended Relational-Algebra Operations 103<br/>3.4 Modification of the Database 111<br/>3.5 Views 113<br/>3.6 The Tuple Relational Calculus 118<br/>3.7 The Domain Relational Calculus 122<br/>3.8 Summary 126<br/>Exercises 127<br/>Bibliographical Notes 131<br/>PART 2 RELATIONAL DATABASES<br/>Chapter 4 SQL<br/>4.1 Background 135<br/>4.2 Basic Structure 137<br/>4.3 Set Operations 144<br/>4.4 Aggregate Functions 146<br/>4.5 Null Values 148<br/>4.6 Nested Subqueries 149<br/>4.7 Views 154<br/>4.8 Complex Queries 155<br/>4.9 Modification of the Database 157<br/>4.10 Joined Relations 163<br/>4.11 Data-Definition Language 168<br/>4.12 Embedded SQL 172<br/>4.13 Dynamic SQL 175<br/>4.14 Other SQL Features 180<br/>4.15 Summary 182<br/>Exercises 183<br/>Bibliographical Notes 186<br/>Chapter 5 Other Relational Languages<br/>5.1 Query-by-Example 189<br/>5.2 Datalog 203<br/>5.3 User Interfaces and Tools 217<br/>5.4 Summary 219<br/>Exercises 220<br/>Bibliographical Notes 223<br/>Chapter 6 Integrity and Security<br/>6.1 Domain Constraints 225<br/>6.2 Referential Integrity 227<br/>6.3 Assertions 232<br/>6.4 Triggers 233<br/>6.5 Security and Authorization 238<br/>6.6 Authorization in SQL 244<br/>6.7 Encryption and Authentication 248<br/>6.8 Summary 250<br/>Exercises 252<br/>Bibliographical Notes 254<br/>Chapter 7 Relational-Database Design<br/>7.1 First Normal Form 257<br/>7.2 Pitfalls in Relational-Database Design 258<br/>7.3 Functional Dependencies 260<br/>7.4 Decomposition 271<br/>7.5 Desirable Properties of Decomposition 275<br/>7.6 Boyce-Codd Normal Form 279<br/>7.7 Third Normal Form 284<br/>7.8 Fourth Normal Form 289<br/>7.9 More Normal Forms 293<br/>7.10 Overall Database Design Process 293<br/>7.11 Summary 297<br/>Exercises 299<br/>Bibliographical Notes 303<br/>PART 3 OBJECT-BASED DATABASES AND XML<br/>Chapter 8 Object-Oriented Databases<br/>8.1 Need for Complex Data Types 307<br/>8.2 The Object-Oriented Data Model 308<br/>8.3 Object-Oriented Languages 318<br/>8.4 Persistent Programming Languages 318<br/>8.5 Persistent C++ Systems 322<br/>8.6 Persistent Java Systems 330<br/>8.7 Summary 331<br/>Exercises 332<br/>Bibliographical Notes 333<br/>Chapter 9 Object-Relational Databases<br/>9.1 Nested Relations 335<br/>9.2 Complex Types 337<br/>9.3 Inheritance 342<br/>9.4 Reference Types 346<br/>9.5 Querying with Complex Types 348<br/>9.6 Functions and Procedures 351<br/>9.7 Object-Oriented versus Object-Relational 356<br/>9.8 Summary 357<br/>Exercises 358<br/>Bibliographical Notes 360<br/>Chapter 10 XML<br/>10.1 Background 361<br/>10.2 Structure of XML Data 364<br/>10.3 XML Document Schema 367<br/>10.4 Querying and Transformation 372<br/>10.5 The Application Program Interface 380<br/>10.6 Storage of XML Data 381<br/>10.7 XML Applications 384<br/>10.8 Summary 386<br/>Exercises 388<br/>Bibliographical Notes 390<br/>PART 4 DATA STORAGE AND QUERYING<br/>Chapter 11 Storage and File Structure<br/>11.1 Overview of Physical Storage Media 393<br/>11.2 Magnetic Disks 396<br/>11.3 RAID 402<br/>11.4 Tertiary Storage 410<br/>11.5 Storage Access 412<br/>11.6 File Organization 415<br/>11.7 Organization of Records in Files 422<br/>11.8 Data-Dictionary Storage 426<br/>11.9 Storage for Object-Oriented Databases 428<br/>11.10 Summary 438<br/>Exercises 440<br/>Bibliographical Notes 443<br/>Chapter 12 Indexing and Hashing<br/>12.1 Basic Concepts 445<br/>12.2 Ordered Indices 446<br/>12.3 B+-Tree Index Files 453<br/>12.4 B-Tree Index Files 464<br/>12.5 Static Hashing 465<br/>12.6 Dynamic Hashing 471<br/>12.7 Comparison of Ordered Indexing and Hashing 477<br/>12.8 Index Definition in SQL 479<br/>12.9 Multiple-Key Access 480<br/>12.10 Summary 487<br/>Exercises 489<br/>Bibliographical Notes 491<br/>Chapter 13 Query Processing<br/>13.1 Overview 493<br/>13.2 Measures of Query Cost 495<br/>13.3 Selection Operation 496<br/>13.4 Sorting 501<br/>13.5 Join Operation 503<br/>13.6 Other Operations 514<br/>13.7 Evaluation of Expressions 518<br/>13.8 Summary 523<br/>Exercises 525<br/>Bibliographical Notes 526<br/>Chapter 14 Query Optimization<br/>14.1 Overview 529<br/>14.2 Estimating Statistics of Expression Results 531<br/>14.3 Transformation of Relational Expressions 537<br/>14.4 Choice of Evaluation Plans 544<br/>14.5 Materialized Views 553<br/>14.6 Summary 557<br/>Exercises 559<br/>Bibliographical Notes 561<br/>PART 5 TRANSACTIONMANAGEMENT<br/>Chapter 15 Transactions<br/>15.1 Transaction Concept 565<br/>15.2 Transaction State 568<br/>15.3 Implementation of Atomicity and Durability 571<br/>15.4 Concurrent Executions 573<br/>15.5 Serializability 576<br/>15.6 Recoverability 582<br/>15.7 Implementation of Isolation 583<br/>15.8 Transaction Definition in SQL 584<br/>15.9 Testing for Serializability 584<br/>15.10 Summary 586<br/>Exercises 588<br/>Bibliographical Notes 590<br/>Chapter 16 Concurrency Control<br/>16.1 Lock-Based Protocols 591<br/>16.2 Timestamp-Based Protocols 604<br/>16.3 Validation-Based Protocols 607<br/>16.4 Multiple Granularity 609<br/>16.5 Multiversion Schemes 612<br/>16.6 Deadlock Handling 615<br/>16.7 Insert and Delete Operations 620<br/>16.8 Weak Levels of Consistency 623<br/>16.9 Concurrency in Index Structures 625<br/>16.10 Summary 629<br/>Exercises 632<br/>Bibliographical Notes 636<br/>Chapter 17 Recovery System<br/>17.1 Failure Classification 639<br/>17.2 Storage Structure 640<br/>17.3 Recovery and Atomicity 644<br/>17.4 Log-Based Recovery 645<br/>17.5 Shadow Paging 653<br/>17.6 Recovery with Concurrent Transactions 657<br/>17.7 Buffer Management 660<br/>17.8 Failure with Loss of Nonvolatile Storage 663<br/>17.9 Advanced Recovery Techniques 664<br/>17.10 Remote Backup Systems 672<br/>17.11 Summary 674<br/>Exercises 677<br/>Bibliographical Notes 679<br/>PART 6 DATABASE SYSTEM ARCHITECTURE<br/>Chapter 18 Database System Architectures<br/>18.1 Centralized and Client-Server Architectures 683<br/>18.2 Server System Architectures 687<br/>18.3 Parallel Systems 691<br/>18.4 Distributed Systems 697<br/>18.5 Network Types 701<br/>18.6 Summary 703<br/>Exercises 705<br/>Bibliographical Notes 707<br/>Chapter 19 Distributed Databases<br/>19.1 Homogeneous and Heterogeneous Databases 709<br/>19.2 Distributed Data Storage 710<br/>19.3 Distributed Transactions 713<br/>19.4 Commit Protocols 716<br/>19.5 Concurrency Control in Distributed Databases 722<br/>19.6 Availability 730<br/>19.7 Distributed Query Processing 735<br/>19.8 Heterogeneous Distributed Databases 738<br/>19.9 Directory Systems 741<br/>19.10 Summary 746<br/>Exercises 749<br/>Bibliographical Notes 752<br/>Chapter 20 Parallel Databases<br/>20.1 Introduction 755<br/>20.2 I/O Parallelism 756<br/>20.3 Interquery Parallelism 760<br/>20.4 Intraquery Parallelism 761<br/>20.5 Intraoperation Parallelism 762<br/>20.6 Interoperation Parallelism 770<br/>20.7 Design of Parallel Systems 772<br/>20.8 Summary 773<br/>Exercises 775<br/>Bibliographical Notes 777<br/>PART 7 OTHER TOPICS<br/>Chapter 21 Application Development and Adminis<br/>
Holdings
Withdrawn status Damaged status Not for loan Home library Current library Date acquired Source of acquisition Full call number Barcode Date last seen Price effective from Koha item type
      UE-Central Library UE-Central Library 24.05.2018 U.E.16803 005.74 Si326 T1374 09.03.2020 24.05.2018 Books
Copyright © 2023, University of Education, Lahore. All Rights Reserved.
Email:centrallibrary@ue.edu.pk