DATABASE MANAGEMENT SYSTEMS 3판 솔루션

DATABASE MANAGEMENT SYSTEMS SOLUTIONS MANUAL THIRD EDITION

Raghu Ramakrishnan University of Wisconsin
Madison, WI, USA

Johannes Gehrke Cornell University
Ithaca, NY, USA

Je? Derstadt, Scott Seliko?, and Lin Zhu Cornell University
Ithaca, NY, USA

CONTENTS

PREFACE 1 2 3 4 5 6 7 8 9 INTRODUCTION TO DATABASE SYSTEMS INTRODUCTION TO DATABASE DESIGN THE RELATIONAL MODEL RELATIONAL ALGEBRA AND CALCULUS SQL: QUERIES, CONSTRAINTS, TRIGGERS DATABASE APPLICATION DEVELOPMENT INTERNET APPLICATIONS OVERVIEW OF STORAGE AND INDEXING STORING DATA: DISKS AND FILES

iii 1 7 22 42 59 90 94 102 113 122 141 166 175 181

10 TREE-STRUCTURED INDEXING 11 HASH-BASED INDEXING 12 OVERVIEW OF QUERY EVALUATION 13 EXTERNAL SORTING 14 EVALUATION OF RELATIONAL OPERATORS

i

iiDatabase Management Systems Solutions Manual Third Edition 15 A TYPICAL QUERY OPTIMIZER 16 OVERVIEW OF TRANSACTION MANAGEMENT 17 CONCURRENCY CONTROL 18 CRASH RECOVERY 19 SCHEMA REFINEMENT AND NORMAL FORMS 20 PHYSICAL DATA…(생략)