Database Systems Concepts

ISBN-10: 0072958863
ISBN-13: 9780072958867
Edition: 5th 2006 (Revised)
List price: $144.38
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: Database System Concepts, 5/e, is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate, level. In addition to basic material for a first course, the text contains advanced material that can be used  More...

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $144.38
Edition: 5th
Copyright year: 2006
Publisher: McGraw-Hill Higher Education
Publication date: 5/17/2005
Binding: Hardcover
Pages: 1168
Size: 7.75" wide x 9.50" long x 2.00" tall
Weight: 4.158
Language: English

Database System Concepts, 5/e, is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate, level. In addition to basic material for a first course, the text contains advanced material that can be used for course supplements, or as introductory material for an advanced course. The authors assume only a familiarity with basic data structures, computer organization, and a high-level programming language such as Java, C, or Pascal. Concepts are presented as intuitive descriptions, and many are based on the running example of a bank enterprise. Important theoretical results are covered, but formal proofs are omitted. In place of proofs, figures and examples are used to suggest why a result is true. The fundamental concepts and algorithms covered in the book are often based on those used in existing commercial or experimental database systems. The aim is to present these concepts and algorithms in a general setting that is not tied to one particular database system. Details of particular commercial database systems are discussed in the case studies which constitute Part 8 of the book. The fifth edition of Database System Concepts retains the overall style of prior editions while evolving the content and organization to reflect the changes that are occurring in the way databases are designed, managed, and used. Key Handles: - Early coverage of SQL in two chapters - Think of SQL as doing or creating Queries - Silberschatz uses a bank analogy throughout his text with Running Examples - Case studies areincorporated that represent a different database, this is in the last Part of the text - Focuses on cutting edge material, such as xml, web based database systems

Prefacep. xvii
Introduction
Database-System Applicationsp. 1
Purpose of Database Systemsp. 3
View of Datap. 5
Database Languagesp. 9
Relational Databasesp. 11
Database Designp. 14
Object-Based and Semistructured Databasesp. 19
Data Storage and Queryingp. 20
Transaction Managementp. 22
Data Mining and Analysisp. 23
Database Architecturep. 24
Database Users and Administratorsp. 26
History of Database Systemsp. 28
Summaryp. 30
Exercisesp. 31
Bibliographical Notesp. 32
Relational Databases
Relational Model
Structure of Relational Databasesp. 37
Fundamental Relational-Algebra Operationsp. 46
Additional Relational-Algebra Operationsp. 55
Extended Relational-Algebra Operationsp. 60
Null Valuesp. 66
Modification of the Databasep. 68
Summaryp. 70
Exercisesp. 71
Bibliographical Notesp. 73
SQL
Backgroundp. 75
Data Definitionp. 77
Basic Structure of SQL Queriesp. 80
Set Operationsp. 87
Aggregate Functionsp. 89
Null Valuesp. 91
Nested Subqueriesp. 93
Complex Queriesp. 97
Viewsp. 99
Modification of the Databasep. 103
Joined Relationsp. 110
Summaryp. 115
Exercisesp. 116
Bibliographical Notesp. 120
Advanced SQL
SQL Data Types and Schemasp. 121
Integrity Constraintsp. 126
Authorizationp. 133
Embedded SQLp. 134
Dynamic SQLp. 137
Functions and Procedural Constructsp. 145
Recursive Queriesp. 151
Advanced SQL Featuresp. 155
Summaryp. 158
Exercisesp. 159
Bibliographical Notesp. 162
Other Relational Languages
The Tuple Relational Calculusp. 163
The Domain Relational Calculusp. 168
Query-by-Examplep. 171
Datalogp. 180
Summaryp. 194
Exercisesp. 195
Bibliographical Notesp. 198
Database Design
Database Design and the E-R Model
Overview of the Design Processp. 201
The Entity-Relationship Modelp. 204
Constraintsp. 210
Entity-Relationship Diagramsp. 214
Entity-Relationship Design Issuesp. 220
Weak Entity Setsp. 225
Extended E-R Featuresp. 227
Database Design for Banking Enterprisep. 236
Reduction to Relational Schemasp. 241
Other Aspects of Database Designp. 248
The Unified Modeling Language UMLp. 251
Summaryp. 254
Exercisesp. 256
Bibliographical Notesp. 261
Relational Database Design
Features of Good Relational Designsp. 263
Atomic Domains and First Normal Formp. 268
Decomposition Using Functional Dependenciesp. 270
Functional-Dependency Theoryp. 278
Decomposition Using Functional Dependenciesp. 288
Decomposition Using Multivalued Dependenciesp. 293
More Normal Formsp. 298
Database-Design Processp. 299
Modeling Temporal Datap. 302
Summaryp. 304
Exercisesp. 306
Bibliographical Notesp. 310
Application Design and Development
User Interfaces and Toolsp. 311
Web Interfaces to Databasesp. 314
Web Fundamentalsp. 315
Servlets and JSPp. 321
Building Large Web Applicationsp. 326
Triggersp. 329
Authorization in SQLp. 335
Application Securityp. 343
Summaryp. 350
Exercisesp. 352
Bibliographical Notesp. 357
Object-Based Databases and XML
Object-Based Databases
Overviewp. 361
Complex Data Typesp. 362
Structured Types and Inheritance in SQLp. 365
Table Inheritancep. 369
Array and Multiset Types in SQLp. 371
Object-Identity and Reference Types in SQLp. 376
Implementing O-R Featuresp. 378
Persistent Programming Languagesp. 379
Object-Oriented versus Object-Relationalp. 387
Summaryp. 388
Exercisesp. 389
Bibliographical Notesp. 393
XML
Motivationp. 395
Structure of XML Datap. 399
XML Document Schemap. 402
Querying and Transformationp. 408
Application Program Interfaces to XMLp. 420
Storage of XML Datap. 421
XML Applicationsp. 428
Summaryp. 431
Exercisesp. 433
Bibliographical Notesp. 436
Data Storage and Querying
Storage and File Structure
Overview of Physical Storage Mediap. 441
Magnetic Disksp. 444
RAIDp. 450
Tertiary Storagep. 458
Storage Accessp. 460
File Organizationp. 464
Organization of Records in Filesp. 468
Data-Dictionary Storagep. 472
Summaryp. 474
Exercisesp. 476
Bibliographical Notesp. 478
Indexing and Hashing
Basic Conceptsp. 481
Ordered Indicesp. 482
B[superscript +]-Tree Index Filesp. 489
B-Tree Index Filesp. 501
Multiple-Key Accessp. 502
Static Hashingp. 506
Dynamic Hashingp. 511
Comparison of Ordered Indexing and Hashingp. 518
Bitmap Indicesp. 520
Index Definition in SQLp. 523
Summaryp. 524
Exercisesp. 526
Bibliographical Notesp. 529
Query Processing
Overviewp. 531
Measures of Query Costp. 533
Selection Operationp. 534
Sortingp. 539
Join Operationp. 542
Other Operationsp. 555
Evaluation of Expressionsp. 559
Summaryp. 563
Exercisesp. 566
Bibliographical Notesp. 568
Query Optimization
Overviewp. 569
Transformation of Relational Expressionsp. 571
Estimating Statistics of Expression Resultsp. 578
Choice of Evaluation Plansp. 584
Materialized Viewsp. 593
Summaryp. 598
Exercisesp. 599
Bibliographical Notesp. 602
Transaction Management
Transactions
Transaction Conceptp. 609
Transaction Statep. 612
Implementation of Atomicity and Durabilityp. 615
Concurrent Executionsp. 617
Serializabilityp. 620
Recoverabilityp. 626
Implementation of Isolationp. 627
Testing for Serializabilityp. 628
Summaryp. 630
Exercisesp. 632
Bibliographical Notesp. 633
Concurrency Control
Lock-Based Protocolsp. 635
Timestamp-Based Protocolsp. 648
Validation-Based Protocolsp. 651
Multiple Granularityp. 653
Multiversion Schemesp. 656
Deadlock Handlingp. 659
Insert and Delete Operationsp. 664
Weak Levels of Consistencyp. 667
Concurrency in Index Structuresp. 669
Summaryp. 673
Exercisesp. 676
Bibliographical Notesp. 680
Recovery System
Failure Classificationp. 683
Storage Structurep. 684
Recovery and Atomicityp. 688
Log-Based Recoveryp. 689
Recovery with Concurrent Transactionsp. 697
Buffer Managementp. 699
Failure with Loss of Nonvolatile Storagep. 702
Advanced Recovery Techniquesp. 703
Remote Backup Systemsp. 711
Summaryp. 713
Exercisesp. 716
Bibliographical Notesp. 718
Data Mining and Information Retrieval
Data Analysis and Mining
Decision-Support Systemsp. 723
Data Analysis and OLAPp. 725
Data Warehousingp. 736
Data Miningp. 739
Summaryp. 752
Exercisesp. 754
Bibliographical Notesp. 756
Information Retrieval
Overviewp. 759
Relevance Ranking Using Termsp. 761
Relevance Using Hyperlinksp. 763
Synonyms, Homonyms and Ontologiesp. 768
Indexing of Documentsp. 769
Measuring Retrieval Effectivenessp. 770
Web Search Enginesp. 771
Information Retrieval and Structured Datap. 772
Directoriesp. 773
Summaryp. 776
Exercisesp. 777
Bibliographical Notesp. 779
System Architecture
Database-System Architectures
Centralized and Client-Server Architecturesp. 783
Server System Architecturesp. 786
Parallel Systemsp. 790
Distributed Systemsp. 797
Network Typesp. 801
Summaryp. 803
Exercisesp. 805
Bibliographical Notesp. 807
Parallel Databases
Introductionp. 809
I/O Parallelismp. 810
Interquery Parallelismp. 814
Intraquery Parallelismp. 815
Intraoperation Parallelismp. 816
Interoperation Parallelismp. 824
Design of Parallel Systemsp. 826
Summaryp. 827
Exercisesp. 829
Bibliographical Notesp. 831
Distributed Databases
Homogeneous and Heterogeneous Databasesp. 833
Distributed Data Storagep. 834
Distributed Transactionsp. 837
Commit Protocolsp. 840
Concurrency Control in Distributed Databasesp. 846
Availabilityp. 854
Distributed Query Processingp. 859
Heterogeneous Distributed Databasesp. 862
Directory Systemsp. 865
Summaryp. 870
Exercisesp. 873
Bibliographical Notesp. 876
Other Topics
Advanced Application Development
Performance Tuningp. 881
Performance Benchmarksp. 891
Standardizationp. 895
Application Migrationp. 899
Summaryp. 900
Exercisesp. 902
Bibliographical Notesp. 903
Advanced Data Types and New Applications
Motivationp. 905
Time in Databasesp. 906
Spatial and Geographic Datap. 908
Multimedia Databasesp. 919
Mobility and Personal Databasesp. 922
Summaryp. 927
Exercisesp. 929
Bibliographical Notesp. 931
Advanced Transaction Processing
Transaction-Processing Monitorsp. 933
Transactional Workflowsp. 938
E-Commercep. 944
Main-Memory Databasesp. 947
Real-Time Transaction Systemsp. 949
Long-Duration Transactionsp. 950
Transaction Management in Multidatabasesp. 956
Summaryp. 959
Exercisesp. 962
Bibliographical Notesp. 964
Case Studies
PostgreSQL
Introductionp. 967
User Interfacesp. 968
SQL Variations and Extensionsp. 971
Transaction Management in PostgreSQLp. 979
Storage and Indexingp. 988
Query Processing and Optimizationp. 991
System Architecturep. 994
Bibliographical Notesp. 995
Oracle
Database Design and Querying Toolsp. 997
SQL Variations and Extensionsp. 999
Storage and Indexingp. 1001
Query Processing and Optimizationp. 1010
Concurrency Control and Recoveryp. 1017
System Architecturep. 1019
Replication, Distribution, and External Datap. 1022
Database Administration Toolsp. 1024
Data Miningp. 1025
Bibliographical Notesp. 1026
IBM DB2 Universal Database
Overviewp. 1027
Database-Design Toolsp. 1029
SQL Variations and Extensionsp. 1029
Storage and Indexingp. 1034
Multidimensionsal Clusteringp. 1037
Query Processing and Optimizationp. 1040
Materialized Query Tablesp. 1045
Autonomic Features in DB2p. 1047
Tools and Utilititesp. 1048
Concurrency Control and Recoveryp. 1050
System Architecturep. 1052
Replication, Distribution and External Datap. 1053
Business Intelligence Featuresp. 1054
Bibliographical Notesp. 1055
Microsoft SQL Server
Management, Design, and Querying Toolsp. 1057
SQL Variations and Extensionsp. 1062
Storage and Indexingp. 1066
Query Processing and Optimizationp. 1069
Concurrency and Recoveryp. 1074
System Architecturep. 1078
Data Accessp. 1080
Distributed Heterogeneous Query Processingp. 1081
Replicationp. 1082
Server Programming in .NETp. 1084
XML Support in SQL Server 2005p. 1089
SQL Server Service Brokerp. 1094
Data Warehouse and Business Intelligencep. 1096
Bibliographical Notesp. 1100
Appendices
Network Model (contents online)
Basic Conceptsp. A1
Data-Structure Diagramsp. A2
The DBTG CODASYL Modelp. A7
DBTG Data-Retrieval Facilityp. A13
DBTG Update Facilityp. A20
DBTG Set-Processing Facilityp. A22
Mapping of Networks to Filesp. A27
Summaryp. A31
Exercisesp. A32
Bibliographical Notesp. A35
Hierarchical Model (contents online)
Basic Conceptsp. B1
Tree-Structure Diagramsp. B2
Data-Retrieval Facilityp. B13
Update Facilityp. B18
Virtual Recordsp. B21
Mapping of Hierarchies to Filesp. B22
The IMS Database Systemp. B24
Summaryp. B25
Exercisesp. B26
Bibliographical Notesp. B29
Advanced Relational Database Design (contents online)
Multivalued Dependenciesp. C1
Join Dependenciesp. C5
Domain-Key Normal Formp. C8
Summaryp. C10
Exercisesp. C10
Bibliographical Notesp. C11
Bibliographyp. 1101
Indexp. 1129
Table of Contents provided by Ingram. All Rights Reserved.

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×