经典原版书库 数据库系统导论 英文版·第7版【2025|PDF下载-Epub版本|mobi电子书|kindle百度云盘下载】

经典原版书库 数据库系统导论 英文版·第7版PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

PARTⅠ PRELIMINARIES1

CHAPTER1 An Overview of Database Management2

1.1 Introduction2

1.2 What is a database system?5

1.3 What is a database?9

1.4 Why database?15

1.5 Data independence19

1.6 Relational systems and others25

1.7 Summary27

Exercises28

References and bibliography30

Answers to selected exercises30

CHAPTER2 Database System Architecture33

2.1 Introduction33

2.2 The three levels of the architectuer33

2.3 The external level37

2.4 The conceptual level39

2.5 The internal level40

2.6 Mappings40

2.7 The database administrator41

2.8 The database management system43

2.9 The data communications manager47

2.10 Client/server architecture48

2.11 Utilities50

2.12 Distributed processing50

2.13 Summary54

Exercises55

References and bibliography56

3.2 An informal look at the relational model58

3.1 Introduction58

CHAPTER3 An Introduction to Relational Databases58

3.3 Relations and relvars63

3.4 What relations mean65

3.5 Optimization67

3.6 The Catalog69

3.7 Base relvars and views71

3.8 Transactions75

3.9 The suppliers and parts database76

3.10 Summary78

Exercises80

References and bibliography81

Answers to selected exercises82

CHAPTER4 An Introduction to SQL83

4.1 Introduction83

4.2 Overview84

4.3 The catalog87

4.4 Views88

4.5 Transactions89

4.6 Embedded SQL89

4.8 Summary98

4.7 SQL is not perfect98

Exercises99

References and bibliography101

Answers to selected exercises106

PART1Ⅱ THE RELATIONAL MODEL109

CHAPTER5 Domains,Relations,and Base Relvars111

5.1 Introduction111

5.2 Domains112

5.3 Relation values123

5.4 Relation variables129

5.5 SQL facilities134

5.6 Summary137

Exercises139

References and bibliography141

Answers to selectde exercises144

CHAPTER6 Relational Algebra150

6.1 Introduction150

6.2 Closure revisited152

6.3 Syntax154

6.4 Semantics156

6.5 Examples167

6.6 What is the algebra for?169

6.7 Additional operators171

6.8 Grouping and ungrouping179

6.9 Relational comparisons182

6.10 Summary184

Exercises184

References and bibliography187

Answers to selected exercises190

7.1 Introduction198

CHAPTER7 Relational Calculus198

7.2 Tuple calculus200

7.3 Examples208

7.4 Calculus vs.algebra210

7.5 Computational capabilities215

7.6 Domain calculus216

7.7 SQL facilities218

7.8 Summary228

Exercises229

References and bibliography231

Answers to selected exercises233

CHAPTER8 Integrity249

8.1 Introduction249

8.2 Type constraints251

8.3 Attribute constraints252

8.4 Relvar constraints253

8.5 Database constraints254

8.6 The Golden Rule254

8.7 State vs.transition constraints256

8.8 Keys258

8.9 SQL facilities267

8.10 Summary271

Exercises272

References and bibliography274

Answers to selected exercises280

CHAPTER9 Views289

9.1 Introduction289

9.2 What are views for?292

9.3 View retrievals295

9.4 View updates297

9.5 Snapshots(a digression)313

9.6 SQL facilities314

9.7 Summary316

Exercises317

References and bibliography319

Anewers to selected exercises321

PARTⅢ DATABASE DESIGN327

CHAPTER10 Functional Dependencies330

10.1 Introduction330

10.2 Basic definitions331

10.4 Closure of a set of dependencies334

10.3 Trivial and nontrivial dependencies334

10.5 Closure of a set of attributes336

10.6 Irreducible sets of dependencies337

10.7 Summary340

Exercises341

References and bibliography342

Answers to selected exercises344

CHAPTER11 Further Normalization Ⅰ:1NF,2NF,3NF,BCNF348

11.1 Introduction348

11.2 Nonloss decomposition and functional dependencies352

11.3 First,second,and third normal forms356

11.4 Dependency preservation363

11.5 Boyce/Codd normal form366

11.6 A note on relation-valued attributes372

11.7 Summary374

Exercises375

References and bibliography377

Answers to selected exercises379

12.1 Introduction389

12.2 Multi-valued dependencies and fourth normal form389

CHAPTER12 Further Normalization Ⅱ:Higher Normal Forms389

12.3 Join dependencies and fifth normal form394

12.4 The normalization procedure summarized399

12.5 A note on denormalization401

12.6 Orthogonal design(a digression)404

12.7 Other normal forms407

12.8 Summary408

Exercises409

References and bibliography410

Answers to selected exercises416

CHAPTER13 Semantic Modeling419

13.1 Introduction419

13.2 The overall approach421

13.3 The E/R model424

13.4 E/R diagrams427

13.5 Database design with the E/R model430

13.6 A brief analysis434

13.7 Summary437

Exercises439

References and bibliography440

PARTⅣ TRANSACTION MANAGEMENT453

CHAPTER14 Recovery454

14.1 Introduction454

14.2 Transactions455

14.3 Transaction recovery457

14.4 System recovery460

14.5 Media recovery462

14.6 Two-phase commit462

14.7 SQL facilities464

14.8 Summary465

Exercises466

References and bibliography466

Answers to selected exercises471

CHAPTER15 Concurrency473

15.1 Introduction473

15.2 Three concurrency problems474

15.3 Locking477

15.4 The three concurrency problems revisited478

15.5 Deadlock481

15.6 Serializability482

15.7 Isolation levels484

15.8 Intent locking486

15.9 SQL facilities488

15.10 Summary490

Exercises491

References and bibliography493

Answers to selected exercises499

PARTⅤ FURTHER TOPICS503

16.1 Introduction504

CHAPTER16 Security504

16.2 Discretionary access control506

16.3 Mandatory access control512

16.4 Statistical databases515

16.5 Data encryption520

16.6 SQL facilities525

16.7 Summary528

Exercises529

References and bibliography530

Answers to selected exercises532

17.1 Introduction537

CHAPTER17 Optimization537

17.2 A motivating example539

17.3 An overview of query processing540

17.4 Expression transformation544

17.5 Database statistics550

17.6 A divide and conquer strategy551

17.7 Implementing the relational operators554

17.8 Summary560

Exercises561

References and bibliography564

Answers to selected exercises582

CHAPIER18 Missing Information584

18.1 Introduction584

18.2 An overview of the 3VL approach585

18.3 Some consequences of the foregoing scheme591

18.4 Nulls and keys595

18.5 Outer join(a digression)597

18.6 Special values600

18.7 SQL facilities601

18.8 Summary604

Exercises606

References and bibliography608

Answers to selected exercises611

CHAPTER19 Type Inheritance613

19.1 Introduction613

19.2 Type hierarchies617

19.3 Polymorphism and substitutability620

19.4 Variables and assignments624

19.5 Specialization by constraint628

19.6 Comparisons630

19.7 Operators,versions,and signatures635

19.8 Is a circle an ellipse?639

19.9 Specialization by constraint revisited643

19.10 Summary645

Exercises646

References and bibliography648

Answers to selected exercises649

CHAPTER20 Distributed Databases651

20.1 Introduction651

20.2 Some preliminaries651

20.3 The twelve objectives656

20.4 Problems of distributed systems664

20.5 Client/server systems675

20.6 DBMS independence678

20.7 SQL facilities683

20.8 Summary684

Exercises685

References and bibliography686

CHAPTER21 Decision Support694

21.1 Introduction694

21.2 Aspects of decision support695

21.3 Database design for decision support697

21.4 Data preparation706

21.5 Data warehouses and data marts709

21.6 Online analytical processing715

21.7 Data mining722

21.8 Summary724

Exercises725

References and bibliography726

Answers to selected exercises729

22.1 Introduction730

CHAPTER22 Temporal Databases730

22.2 Temporal data731

22.3 What is the problem?736

22.4 Intervals742

22.5 Interval types744

22.6 Scalar operators on intervals746

22.7 Aggregate operators on intervals747

22.8 Relational operators involving intervals748

22.9 Constraints involving intervals754

22.10 Update operators involving intervals757

22.11 Database design considerations759

22.12 Summary762

Exercises763

References and bibliography764

Answers to selected exercises766

CHAPTER23 Logic-Based Databases769

23.1 Introduction769

23.2 Overview769

23.3 Propositional calculus772

23.4 Predicate calculus777

23.5 A proof-theoretic view of databases784

23.6 Deductive database systems787

23.7 Recursive query processing793

23.8 Summary798

Exercises801

References and bibliography802

Answers to selected exercises808

PARTⅥ OBJECT AND OBJECT/RELATIONAL DATABASES811

CHAPTER 24 Object Databases812

24.1 Introduction812

24.2 Objects,classes,methods,and messages816

24.3 A closer look821

24.4 A cradle-to-grave example829

24.5 Miscellaneous issues839

24.6 Summary847

Exercises850

References and bibliography851

Answers to selected exercises859

CHAPTER25 Object/Relational Databases862

25.1 Introduction862

25.2 The First Great Blunder865

25.3 The Second Great Blunder872

25.4 Implementation issues875

25.5 Benefits of true rapprochement877

25.6 Summary879

References and bibliography880

APPENDIXES887

APPENDIX A SQL Expressions888

A.1 Introduction888

A.2 Table expressions888

A.3 Conditional expressions894

A.4 Scalar expressions898

APPENDIX B An Overview of SQL3900

B.1 Introduction900

B.2 New data types901

B.3 Type inheritance906

B.4 Reference types907

B.5 Subtables and supertables910

B.6 Other features912

APPENDIX C Abbreviations,Acronyms,and Symbols916

Index923