數(shù)據(jù)庫(kù)系統(tǒng)概念(英文精編版·原書(shū)第7版)
-
>
決戰(zhàn)行測(cè)5000題(言語(yǔ)理解與表達(dá))
-
>
軟件性能測(cè)試.分析與調(diào)優(yōu)實(shí)踐之路
-
>
第一行代碼Android
-
>
深度學(xué)習(xí)
-
>
Unreal Engine 4藍(lán)圖完全學(xué)習(xí)教程
-
>
深入理解計(jì)算機(jī)系統(tǒng)-原書(shū)第3版
-
>
Word/Excel PPT 2013辦公應(yīng)用從入門(mén)到精通-(附贈(zèng)1DVD.含語(yǔ)音視頻教學(xué)+辦公模板+PDF電子書(shū))
數(shù)據(jù)庫(kù)系統(tǒng)概念(英文精編版·原書(shū)第7版) 版權(quán)信息
- ISBN:9787111692218
- 條形碼:9787111692218 ; 978-7-111-69221-8
- 裝幀:一般膠版紙
- 冊(cè)數(shù):暫無(wú)
- 重量:暫無(wú)
- 所屬分類(lèi):>>
數(shù)據(jù)庫(kù)系統(tǒng)概念(英文精編版·原書(shū)第7版) 本書(shū)特色
數(shù)據(jù)庫(kù)領(lǐng)域的殿堂級(jí)作品。夯實(shí)數(shù)據(jù)庫(kù)理論基礎(chǔ),修煉數(shù)據(jù)庫(kù)技術(shù)內(nèi)功的**之選。
數(shù)據(jù)庫(kù)系統(tǒng)概念(英文精編版·原書(shū)第7版) 內(nèi)容簡(jiǎn)介
《數(shù)據(jù)庫(kù)系統(tǒng)概念》是數(shù)據(jù)庫(kù)系統(tǒng)方面的經(jīng)典教材之一,其內(nèi)容由淺入深,既包含數(shù)據(jù)庫(kù)系統(tǒng)基本概念,又反映數(shù)據(jù)庫(kù)技術(shù)新進(jìn)展。本書(shū)基于該書(shū)第7版進(jìn)行改編,保留其中的基本內(nèi)容,壓縮或刪除了一些不錯(cuò)內(nèi)容,更加適合作為國(guó)內(nèi)高校計(jì)算機(jī)及相關(guān)專(zhuān)業(yè)本科生數(shù)據(jù)庫(kù)雙語(yǔ)課程教材。
數(shù)據(jù)庫(kù)系統(tǒng)概念(英文精編版·原書(shū)第7版) 目錄
Chapter 1 Introduction 1
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 Languages 13
141 Data-Definition Language 13
142 The SQL Data-Definition Language 14
143 Data-Manipulation Language 15
144 The SQL Data-Manipulation Language 16
145 Database Access from Application Programs 16
15 Database Design 17
16 Database Engine 18
161 Storage Manager 19
162 The Query Processor 20
163 Transaction Management 20
17 Database and Application Architecture 21
18 Database Users and Administrators 23
181 Database Users and User Interfaces 24
182 Database Administrator 24
19 History of Database Systems 25
110 Summary 29
Review Terms 30
Practice Exercises 31
Exercises 32
Tools 33
Further Reading 33
Bibliography 33
PART 1 RELATIONAL LANGUAGES
Chapter 2 Introduction to the Relational Model 37
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 3 Introduction to SQL 53
31 Overview of the SQL Query Language53
32 SQL Data Definition54
321 Basic Types55
322 Basic Schema Definition 56
33 Basic Structure of SQL Queries 59
331 Queries on a Single Relation 59
332 Queries on Multiple Relations 62
34 Additional Basic Operations 67
341 The Rename Operation 67
342 String Operations 70
343 Attribute Specification in the Select Clause 71
344 Ordering the Display of Tuples 71
345 Where-Clause Predicates 72
35 Set Operations 73
351 The Union Operation 74
352 The Intersect Operation 75
353 The Except Operation 76
36 Null Values 77
37 Aggregate Functions 79
371 Basic Aggregation 79
372 Aggregation with Grouping 80
373 The Having Clause 83
374 Aggregation with Null and Boolean Values 84
38 Nested Subqueries 86
381 Set Membership 86
382 Set Comparison 87
383 Test for Empty Relations 89
384 Test for the Absence of Duplicate Tuples 91
385 Subqueries in the From Clause 92
386 The With Clause 93
387 Scalar Subqueries 94
388 Scalar Without a From Clause 95
39 Modification of the Database 96
391 Deletion 96
392 Insertion 98
393 Updates 99
310 Summary 102
Review Terms 103
Practice Exercises 103
Exercises 107
Tools 111
Further Reading 112
Bibliography 112
Chapter 4 Intermediate SQL 113
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 Assertions 140
45 SQL Data Types and Schemas 141
451 Date and Time Types in SQL 142
452 Type Conversion and Formatting Functions 143
453 Default Values 144
454 Large-Object Types 144
455 User-Defined Types 146
456 Generating Unique Key Values 148
457 Create Table Extensions 150
458 Schemas, Catalogs, and Environments 150
46 Index Definition in SQL 152
47 Authorization 153
471 Granting and Revoking of Privile
數(shù)據(jù)庫(kù)系統(tǒng)概念(英文精編版·原書(shū)第7版) 作者簡(jiǎn)介
亞伯拉罕·西爾伯沙茨(Abraham Silberschatz) 于紐約州立大學(xué)石溪分校獲得博士學(xué)位,現(xiàn)為耶魯大學(xué)計(jì)算機(jī)科學(xué)系Sidney J Weinberg教授,曾任貝爾實(shí)驗(yàn)室信息科學(xué)研究中心副主任。他是ACM會(huì)士、IEEE 會(huì)士以及康涅狄格科學(xué)與工程學(xué)會(huì)的成員,獲得了48項(xiàng)專(zhuān)利和24項(xiàng)授權(quán)。他還是教科書(shū)《操作系統(tǒng)概念》的作者。亨利·F 科思(Henry F Korth) 于普林斯頓大學(xué)獲得博士學(xué)位,現(xiàn)為理海大學(xué)計(jì)算機(jī)科學(xué)與工程系教授和計(jì)算機(jī)科學(xué)與商業(yè)項(xiàng)目聯(lián)合主任,曾任貝爾實(shí)驗(yàn)室數(shù)據(jù)庫(kù)原理研究中心主任、松下科技副總裁、得克薩斯大學(xué)奧斯汀分校副教授以及IBM研究中心研究人員。他是ACM會(huì)士、IEEE會(huì)士以及VLDB會(huì)議10年貢獻(xiàn)獎(jiǎng)的獲得者。他的研究涉及數(shù)據(jù)庫(kù)系統(tǒng)的方方面面,最近,他的研究致力于解決區(qū)塊鏈在企業(yè)數(shù)據(jù)庫(kù)中的應(yīng)用問(wèn)題。S 蘇達(dá)爾尚(S Sudarshan) 于威斯康星大學(xué)獲得博士學(xué)位,現(xiàn)為印度理工學(xué)院孟買(mǎi)校區(qū)Subrao M Nilekani講席教授,曾為貝爾實(shí)驗(yàn)室技術(shù)人員。他是ACM會(huì)士,發(fā)表了100余篇論文并獲得15項(xiàng)專(zhuān)利。他目前的研究領(lǐng)域包括SQL查詢(xún)的測(cè)試和分級(jí)、通過(guò)重寫(xiě)命令式代碼來(lái)優(yōu)化數(shù)據(jù)庫(kù)應(yīng)用程序,以及并行數(shù)據(jù)庫(kù)的查詢(xún)優(yōu)化。
- >
朝聞道
- >
經(jīng)典常談
- >
回憶愛(ài)瑪儂
- >
史學(xué)評(píng)論
- >
我從未如此眷戀人間
- >
苦雨齋序跋文-周作人自編集
- >
月亮與六便士
- >
月亮虎