본문내용 바로가기
무료배송 소득공제

[Book] Database Systems

Hardcover
Database Systems

이 책의 다른 상품 정보

  • 정가 : 134,520원
    판매가 : 134,520 [0%↓ 0원 할인] 할인쿠폰 받기
  • 혜택 :
    [기본적립] 4040원 적립 [3% 적립] [추가적립] 5만원 이상 구매 시 2,000원 추가적립 안내 [회원혜택] 회원 등급 별, 3만원 이상 구매 시 2~4% 추가적립 안내 [리뷰적립] 리뷰 작성 시 e교환권 최대 300원 추가적립 안내
  • 추가혜택 : 포인트 안내 도서소득공제 안내 추가혜택 더보기
  • 배송비 : 무료 배송비 안내
  • 도서상태 : 품절

알립니다.

  • 외국도서의 경우 해외제공정보로만 서비스되어 미표기된 정보가 있을 수 있습니다. 필요한 정보가 있을경우 1:1 문의게시판 을 이용하여 주십시오.
상품상세정보
ISBN 9780130319951(0130319953)
쪽수 1152쪽
언어 English
크기 191(W) X 248(H) X 44(T) (mm)
제본형태 Hardcover
리딩지수 Level Scholarly/Undergraduate

책소개

이 책이 속한 분야

(NOTE: Each chapter concludes with Summary and References sections.) 1. The Worlds of Database Systems.The Evolution of Database Systems. Overview of a Database Management System. Outline of Database-System Studies.2. The Entity-Relationship Data Model.Elements of the E/R Model. Design Principles. The Modeling of Constraints. Weak Entity Sets.3. The Relational Data Model.Basics of the Relational Model. From E/R Diagrams to Relational Designs. Converting Subclass Structures to Relations. Functional Dependencies. Rules About Functional Dependencies. Design of Relational Database Schemas. Multivalued Dependencies.4. Other Data Models.Review of Object-Oriented Concepts. Introduction to ODL. Additional ODL Concepts. From ODL Designs to Relational Designs. The Object-Relational Model. Semistructured Data. XML and Its Data Model.5. Relational Algebra.An Example Database Schema. An Algebra of Relational Operations. Relational Operations on Bags. Extended Operators of Relational Algebra. Constraints on Relations.6. The Database Language SQL.Simple Queries in SQL. Queries Involving More Than One Relation. Subqueries. Full-Relation Operations. Database Modifications. Defining a Relation Schema in SQL. View Definitions.7. Constraints and Triggers.Keys and Foreign Keys. Constraints on Attributes and Tuples. Modification of Constraints. Schema-Level Constraints and Triggers.8. System Aspects of SQL.SQL in a Programming Environment. Procedures Stored in the Schema. The SQL Environment. Using a Call-Level Interface. Java Database Connectivity. Transactions in SQL. Security and User Authorization in SQL.9. Object-Orientation in Query Languages.Introduction to OQL. Additional Forms of OQL Expressions. Object Assignment and Creation in OQL. User-Defined Types in SQL. Operations on Object-Relational Data.10. Logical Query Languages.A Logic for Relations. From Relational Algebra to Datalog. Recursive Programming in Datalog. Recursion in SQL.11. Data Storage.The "Megatron 2002" Database System. The Memory Hierarchy. Disks. Using Secondary Storage Effectively. Accelerating Access to Secondary Storage. Disk Failures. Recovery from Disk Crashes.12. Representing Data Elements.Data Elements and Fields. Records. Representing Block and Record Addresses. Variable-Length Data and Records. Record Modifications.13. Index Structures.Indexes on Sequential Files. Secondary Indexes. B-Trees. Hash Tables.14. Multidimensional Indexes.Applications Needing Multiple Dimensions. Hash-Like Structures for Multidimensional Data. Tree-Like Structures for Multidimensional Data. Bitmap Indexes.15. Query Execution.Introduction to Physical-Query-Plan Operators. One-Pass Algorithms for Database Operations. Nested-Loop Joins. Two-Pass Algorithms Based on Sorting. Two-Pass Algorithms Based on Hashing. Index-Based Algorithms. Buffer Management. Algorithms Using More Than Two Passes. Parallel Algorithms for Relational Operations.16. The Query Compiler.Parsing. Algebraic Laws for Improving Query Plans. From Parse Trees to Logical Query Plans. Estimating the Cost of Operations. Introduction to Cost-Based Plan Selection. Choosing an Order for Joins. Completing the Physical-Query-Plan.17. Coping with System Failures.Issues and Models for Resilient Operation. Undo Logging. Redo Logging. Undo/Redo Logging. Protecting Against Media Failures.18. Concurrency Control.Serial and Serializable S

목차

The Worlds of Database Systems 1 (22)
The Evolution of Database Systems 2 (7)
Early Database Management Systems 2 (2)
Relational Database Systems 4 (1)
Smaller and Smaller Systems 5 (1)
Bigger and Bigger Systems 6 (1)
Client-Server and Multi-Tier Architectures 7 (1)
Multimedia Data 8 (1)
Information Integration 8 (1)
Overview of a Database Management System 9 (6)
Data-Definition Language Commands 10 (1)
Overview of Query Processing 10 (2)
Storage and Buffer Management 12 (1)
Transaction Processing 13 (1)
The Query Processor 14 (1)
Outline of Database-System Studies 15 (4)
Database Design 16 (1)
Database Programming 17 (1)
Database System Implementation 17 (2)
Information Integration Overview 19 (1)
Summary of Chapter 1 19 (1)
References for Chapter 1 20 (3)
The Entity-Relationship Data Model 23 (38)
Elements of the E/R Model 24 (15)
Entity Sets 24 (1)
Attributes 25 (1)
Relationships 25 (1)
Entity-Relationship Diagrams 25 (2)
Instances of an E/R Diagram 27 (1)
Multiplicity of Binary E/R Relationships 27 (1)
Multiway Relationships 28 (1)
Roles in Relationships 29 (2)
Attributes on Relationships 31 (1)
Converting Multiway Relationships to 32 (1)
Binary
Subclasses in the E/R Model 33 (3)
Exercises for Section 2.1 36 (3)
Design Principles 39 (8)
Faithfulness 39 (1)
Avoiding Redundancy 39 (1)
Simplicity Counts 40 (1)
Choosing the Right Relationships 40 (2)
Picking the Right Kind of Element 42 (2)
Exercises for Section 2.2 44 (3)
The Modeling of Constraints 47 (7)
Classification of Constraints 47 (1)
Key in the E/R Model 48 (2)
Representing Keys in the E/R Model 50 (1)
Single-Value Constraints 51 (1)
Referential Integrity 51 (1)
Referential Integrity in E/R Diagrams 52 (1)
Other Kinds of Constraints 53 (1)
Exercises for Section 2.3 53 (1)
Weak Entity Sets 54 (5)
Causes of Weak Entity Sets 54 (2)
Requirements for Weak Entity Sets 56 (1)
Weak Entity Set Notation 57 (1)
Exercises for Section 2.4 58 (1)
Summary of Chapter 2 59 (1)
References for Chapter 2 60 (1)
The Relational Data Model 61 (70)
Basics of the Relational Model 61 (4)
Attributes 62 (1)
Schemas 62 (1)
Tuples 62 (1)
Domains 63 (1)
Equivalent Representations of a Relation 63 (1)
Relation Instances 64 (1)
Exercises for Section 3.1 64 (1)
From E/R Diagrams to Relational Designs 65 (11)
From Entity Sets to Relations 66 (1)
From E/R Relationships to Relations 67 (3)
Combining Relations 70 (1)
Handling Weak Entity Sets 71 (4)
Exercises for Section 3.2 75 (1)
Converting Subclass Structures to Relations 76 (6)
E/R-Style Conversion 77 (1)
An Object-Oriented Approach 78 (1)
Using Null Values to Combine Relations 79 (1)
Comparison of Approaches 79 (1)
Exercises for Section 3.3 80 (2)
Functional Dependencies 82 (8)
Definition of Functional Dependency 83 (1)
Keys of Relations 84 (2)
Superkeys 86 (1)
Discovering Keys for Relations 87 (1)
Exercises for Section 3.4 88 (2)
Rules About Functional Dependencies 90 (12)
The Splitting/Combining Rule 90 (2)
Trivial Functional Dependencies 92 (1)
Computing the Closure of Attributes 92 (3)
Why the Closure Algorithm Works 95 (1)
The Transitive Rule 96 (2)
Closing Sets of Functional Dependencies 98 (1)
Projecting Functional Dependencies 98 (2)
Exercises for Section 3.5 100 (2)
Design of Relational Database Schemas 102 (16)
Anomalies 103 (1)
Decomposing Relations 103 (2)
Boyce-Codd Normal Form 105 (2)
Decomposition into BCNF 107 (5)
Recovering Information from a 112 (2)
Decomposition
Third Normal Form 114 (3)
Exercises for Section 3.6 117 (1)
Multivalued Dependencies 118 (9)
Attribute Independence and Its Consequent 118 (1)
Redundancy
Definition of Multivalued Dependencies 119 (1)
Reasoning About Multivalued Dependencies 120 (2)
Fourth Normal Form 122 (1)
Decomposition into Fourth Normal Form 123 (1)
Relationships Among Normal Forms 124 (2)
Exercises for Section 3.7 126 (1)
Summary of Chapter 3 127 (2)
References for Chapter 3 129 (2)
Other Data Models 131 (58)
Review of Object-Oriented Concepts 132 (3)
The Type System 132 (1)
Classes and Objects 133 (1)
Object Identity 133 (1)
Methods 133 (1)
Class Hierarchies 134 (1)
Introduction to ODL 135 (12)
Object-Oriented Design 135 (1)
Class Declarations 136 (1)
Attributes in ODL 136 (2)
Relationships in ODL 138 (1)
Inverse Relationships 139 (1)
Multiplicity of Relationships 140 (1)
Methods in ODL 141 (3)
Types in ODL 144 (2)
Exercises for Section 4.2 146 (1)
Additional ODL Concepts 147 (8)
Multiway Relationships in ODL 148 (1)
Subclasses in ODL 149 (1)
Multiple Inheritance in ODL 150 (1)
Extents 151 (1)
Declaring Keys in ODL 152 (3)
Exercises for Section 4.3 155 (1)
From ODL Designs to Relational Designs 155 (11)
From ODL Attributes to Relational 156 (1)
Attributes
Nonatomic Attributes in Classes 157 (1)
Representing Set-Valued Attributes 158 (2)
Representing Other Type Constructors 160 (2)
Representing ODL Relationships 162 (2)
What If There Is No Key? 164 (1)
Exercises for Section 4.4 164 (2)
The Object-Relational Model 166 (7)
From Relations to Object-Relations 166 (1)
Nested Relations 167 (2)
References 169 (1)
Object-Oriented Versus Object-Relational 170 (2)
From ODL Designs to Object-Relational 172 (1)
Designs
Exercises for Section 4.5 172 (1)
Semistructured Data 173 (5)
Motivation for the Semistructured-Data 173 (1)
Model
Semistructured Data Representation 174 (1)
Information Integration Via 175 (2)
Semistructured Data
Exercises for Section 4.6 177 (1)
XML and Its Data Model 178 (8)
Semantic Tags 178 (1)
Well-Formed XML 179 (1)
Document Type Definitions 180 (2)
Using a DTD 182 (1)
Attribute Lists 183 (2)
Exercises for Section 4.7 185 (1)
Summary of Chapter 4 186 (1)
References for Chapter 4 187 (2)
Relational Algebra 189 (50)
An Example Database Schema 190 (1)
An Algebra of Relational Operations 191 (23)
Basics of Relational Algebra 192 (1)
Set Operations on Relations 193 (2)
Projection 195 (1)
Selection 196 (1)
Cartesian Product 197 (1)
Natural Joins 198 (1)
Theta-Joins 199 (2)
Combining Operations to Form Queries 201 (2)
Renaming 203 (2)
Dependent and Independent Operations 205 (1)
A Linear Notation for Algebraic 206 (1)
Expressions
Exercises for Section 5.2 207 (7)
Relational Operations on Bags 214 (7)
Why Bags? 214 (1)
Union, Intersection, and Difference of 215 (1)
Bags
Projection of Bags 216 (1)
Selection on Bags 217 (1)
Product of Bags 218 (1)
Joins of Bags 219 (1)
Exercises for Section 5.3 220 (1)
Extended Operators of Relational Algebra 221 (10)
Duplicate Elimination 222 (1)
Aggregation Operators 222 (1)
Grouping 223 (1)
The Grouping Operator 224 (2)
Extending the Projection Operator 226 (1)
The Sorting Operator 227 (1)
Outerjoins 228 (2)
Exercises for Section 5.4 230 (1)
Constraints on Relations 231 (5)
Relational Algebra as a Constraint 231 (1)
Language
Referential Integrity Constraints 232 (1)
Additional Constraint Examples 233 (2)
Exercises for Section 5.5 235 (1)
Summary of Chapter 5 236 (1)
References for Chapter 5 237 (2)
The Database Language SQL 239 (76)
Simple Queries in SQL 240 (14)
Projection in SQL 242 (1)
Selection in SQL 243 (2)
Comparison of Strings 245 (2)
Dates and Times 247 (1)
Null Values and Comparisons Involving NULL 248 (1)
The Truth-Value Unknown 249 (2)
Ordering the Output 251 (1)
Exercises for Section 6.1 252 (2)
Queries Involving More Than One Relation 254 (10)
Products and Joins in SQL 254 (1)
Disambiguating Attributes 255 (1)
Tuple Variables 256 (2)
Interpreting Multirelation Queries 258 (2)
Union, Intersection, and Difference of 260 (2)
Queries
Exercises for Section 6.2 262 (2)
Subqueries 264 (13)
Subqueries that Produce Scalar Values 264 (2)
Conditions Involving Relations 266 (1)
Conditions Involving Tuples 266 (2)
Correlated Subqueries 268 (2)
Subqueries in From Clauses 270 (1)
SQL Join Expressions 270 (2)
Natural Joins 272 (1)
Outerjoins 272 (2)
Exercises for Section 6.3 274 (3)
Full-Relation Operations 277 (9)
Eliminating Duplicates 277 (1)
Duplicates in Unions, Intersections, and 278 (1)
Differences
Grouping and Aggregation in SQL 279 (1)
Aggregation Operators 279 (1)
Grouping 280 (2)
Having Clauses 282 (2)
Exercises for Section 6.4 284 (2)
Database Modifications 286 (6)
Insertion 286 (2)
Deletion 288 (1)
Updates 289 (1)
Exercises for Section 6.5 290 (2)
Defining a Relation Schema in SQL 292 (9)
Data Types

Klover 리뷰 (0)

북로그 리뷰 (0) 쓰러가기

북로그 리뷰는 본인 인증 후 작성 가능합니다.
책이나 타인에 대해 근거 없이 비방을 하거나 타인의 명예를 훼손할 수 있는 내용은 비공개 처리 될 수 있습니다.
※ 북로그 리뷰 리워드 제공 2021. 4. 1 종료

문장수집 (0) 문장수집 쓰기 나의 독서기록 보기
※구매 후 문장수집 작성 시, 리워드를 제공합니다. 안내

교환/반품/품절안내

※ 상품 설명에 반품/교환 관련한 안내가 있는 경우 그 내용을 우선으로 합니다. (업체 사정에 따라 달라질 수 있습니다.)

교환/반품/품절안내
반품/교환방법 마이룸 > 주문관리 > 주문/배송내역 > 주문조회 > 반품/교환신청 ,
[1:1상담>반품/교환/환불] 또는 고객센터 (1544-1900)

※ 오픈마켓, 해외배송주문, 기프트 주문시 [1:1상담>반품/교환/환불]
    또는 고객센터 (1544-1900)
반품/교환가능 기간 변심반품의 경우 수령 후 7일 이내,
상품의 결함 및 계약내용과 다를 경우 문제점 발견 후 30일 이내
반품/교환비용 변심 혹은 구매착오로 인한 반품/교환은 반송료 고객 부담
반품/교환 불가 사유
  • 소비자의 책임 있는 사유로 상품 등이 손실 또는 훼손된 경우
    (단지 확인을 위한 포장 훼손은 제외)
  • 소비자의 사용, 포장 개봉에 의해 상품 등의 가치가 현저히 감소한 경우
    예) 화장품, 식품, 가전제품(악세서리 포함) 등
  • 복제가 가능한 상품 등의 포장을 훼손한 경우
    예) 음반/DVD/비디오, 소프트웨어, 만화책, 잡지, 영상 화보집
  • 소비자의 요청에 따라 개별적으로 주문 제작되는 상품의 경우 ((1)해외주문도서)
  • 디지털 컨텐츠인 eBook, 오디오북 등을 1회 이상 다운로드를 받았을 경우
  • 시간의 경과에 의해 재판매가 곤란한 정도로 가치가 현저히 감소한 경우
  • 전자상거래 등에서의 소비자보호에 관한 법률이 정하는 소비자 청약철회 제한 내용에
    해당되는 경우
(1) 해외주문도서 : 이용자의 요청에 의한 개인주문상품으로 단순변심 및 착오로 인한 취소/교환/반품 시 ‘해외주문 반품/취소 수수료’ 고객 부담 (해외주문 반품/취소 수수료 : ①서양도서-판매정가의 12%, ②일본도서-판매정가의 7%를 적용)
상품 품절 공급사(출판사) 재고 사정에 의해 품절/지연될 수 있으며, 품절 시 관련 사항에 대해서는
이메일과 문자로 안내드리겠습니다.
소비자 피해보상
환불지연에 따른 배상
  • 상품의 불량에 의한 교환, A/S, 환불, 품질보증 및 피해보상 등에 관한 사항은
    소비자분쟁해결 기준 (공정거래위원회 고시)에 준하여 처리됨
  • 대금 환불 및 환불지연에 따른 배상금 지급 조건, 절차 등은 전자상거래 등에서의
    소비자 보호에 관한 법률에 따라 처리함

이 분야의 베스트

더보기+
바로가기
  • 우측 확장형 배너 2
  • 우측 확장형 배너 2
최근 본 상품