Database system concepts / (Record no. 175)
[ view plain ]
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/> |
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 |