预购商品
书目分类
特别推荐
資料庫系統概念》是資料庫系統方面的經典教材之一，其內容由淺入深，既包含資料庫系統基本概念，又反映資料庫技術新進展。它被國際上許多著名大學所採用，包括斯坦福大學、耶魯大學、德克薩斯大學、康奈爾大學、伊利諾伊大學等。也有多所大學採用本書作為本科生和研究生資料庫課程的教材和主要教學參考書，收到了良好的效果。本書基於該書第7版進行改編，保留其中的基本內容，壓縮或刪除了一些高級內容，更加適合作為國內高校電腦及相關專業本科生資料庫雙語課程教材。 本書特色 內容簡練。保留了原書最基本的內容，講述資料庫系統的基本概念；對資料庫設計技術以及資料管理實現與應用的高級主題進行了有選擇性的介紹。 直觀易懂。採用直觀的方式描述概念，以結構清晰的圖示和示例代替形式化的證明。 實用性強。以大學資料庫實例生動地解釋重要概念，通俗易懂。 內容新穎。反映了資料庫在設計、管理和使用方式等方面的變化及資料庫概念方面的發展趨勢。
Chapter 1Introduction1 11 Database-System Applications1 12 Purpose of Database Systems5 13 View of Data8 131 Data Models8 132 Relational Data Model9 133 Data Abstraction9 134 Instances and Schemas12 14 Database Languages13 141 Data-Definition Language13 142 The SQL Data-Definition Language14 143 Data-Manipulation Language15 144 The SQL Data-Manipulation Language16 145 Database Access from Application Programs16 15 Database Design17 16 Database Engine18 161 Storage Manager19 162 The Query Processor20 163 Transaction Management20 17 Database and Application Architecture21 18 Database Users and Administrators23 181 Database Users and User Interfaces24 182 Database Administrator24 19 History of Database Systems25 110 Summary29 Review Terms30 Practice Exercises31 Exercises32 Tools33 Further Reading33 Bibliography33 PART 1RELATIONAL LANGUAGES Chapter 2Introduction to the Relational Model37 21 Structure of Relational Databases37 22 Database Schema41 23 Keys43 24 Schema Diagrams46 25 Relational Query Languages47 26 Summary48 Review Terms49 Practice Exercises49 Exercises50 Further Reading51 Bibliography51 Chapter 3Introduction to SQL53 31 Overview of the SQL Query Language53 32 SQL Data Definition54 321 Basic Types55 322 Basic Schema Definition56 33 Basic Structure of SQL Queries59 331 Queries on a Single Relation59 332 Queries on Multiple Relations62 34 Additional Basic Operations67 341 The Rename Operation67 342 String Operations70 343 Attribute Specification in the Select Clause71 344 Ordering the Display of Tuples71 345 Where-Clause Predicates72 35 Set Operations73 351 The Union Operation74 352 The Intersect Operation75 353 The Except Operation76 36 Null Values77 37 Aggregate Functions79 371 Basic Aggregation79 372 Aggregation with Grouping80 373 The Having Clause83 374 Aggregation with Null and Boolean Values84 38 Nested Subqueries86 381 Set Membership86 382 Set Comparison87 383 Test for Empty Relations89 384 Test for the Absence of Duplicate Tuples91 385 Subqueries in the From Clause92 386 The With Clause93 387 Scalar Subqueries94 388 Scalar Without a From Clause95 39 Modification of the Database96 391 Deletion96 392 Insertion98 393 Updates99 310 Summary102 Review Terms103 Practice Exercises103 Exercises107 Tools111 Further Reading112 Bibliography112 Chapter 4Intermediate SQL113 41 Join Expressions113 411 The Natural Join114 412 Join Conditions118 413 Outer Joins119 414 Join Types and Conditions124 42 Views125 421 View Definition126 422 Using Views in SQL Queries126 423 Materialized Views128 424 Update of a View128 43 Transactions131 44 Integrity Constraints133 441 Constraints on a Single Relation134 442 Not Null Constraint134 443 Unique Constraint135 444 The Check Clause135 445 Referential Integrity137 446 Assigning Names to Constraints139 447 Integrity Constraint Violation During a Transaction139 448 Complex Check Conditions and Assertions140 45 SQL Data Types and Schemas141 451 Date and Time Types in SQL142 452 Type Conversion and Formatting Functions143 453 Default Values144 454 Large-Object Types144 455 User-Defined Types146 456 Generating Unique Key Values148 457 Create Table Extensions150 458 Schemas, Catalogs, and Environments150 46 Index Definition in SQL152 47 Authorization153 471 Granting and Revoking of Privile
客服公告
热门活动
订阅电子报
.jpg)
![13.04.2025 平和歸零，從心開始：禪繞與零極限分享會 [第24場]_Side Banner](images/禪繞與零極限分享會-第24場-Side.jpg)
