+
Solutions
Author : Raghu Ramakrishnan and
Johannes Gehrke
Edition : SECOND EDITION
Publisher : McGraw-Hill Education
ISBN - 10 Number : 0-07-232206-3
ISBN - 13 Number : 978-0072322064
BOOK Length : 931 pages
BOOK File Format : PDF
BOOK Language : English
Database Management Systems has quickly become one of the leading texts for database courses, known for its practical emphasis and comprehensive coverage. The third edition features new material on database application development, with a focus on Internet applications. The hands-on approach introduces students to current standards, including JDBC, XML, and 3-tier application architectures. A new, flexible organization allows instructors to teach either an applications-oriented course or an introductory systems-oriented course. The revised “part” organization with (new) Overview chapters makes it easy to select the chapters you need; in-depth chapters within each part can be optional.
This very current new edition also features pedagogical improvements (e.g., chapter objectives, review questions), and updated and extended discussions of data mining, database tuning wizards, decision support, information retrieval, Internet security, object-oriented databases, transaction processing, and XML data management. Throughout, the coverage has been revised and expanded to reflect the new SQL:1999 standard, including extensions that support multimedia data, object-relational databases, OLAP, recursive queries, spatial data, and SQL-J. The flexible organization and up-to-date discussion of advanced topics also makes the book ideal for use in a two-course sequence
Provides a hands-on approach to relational database systems, with an emphasis on practical topics such as indexing methods, SQL, and database design. DLC: Database management.
CONTENTS
PREFACE
Part I BASICS
1 INTRODUCTION TO DATABASE SYSTEMS
2 THE ENTITY-RELATIONSHIP MODEL
3 THE RELATIONAL MODEL
Part II RELATIONAL QUERIES
4 RELATIONAL ALGEBRA AND CALCULUS
5 SQL: QUERIES, PROGRAMMING, TRIGGERS
6 QUERY-BY-EXAMPLE (QBE)
Part III DATA STORAGE AND INDEXING
7 STORING DATA: DISKS AND FILES
8 FILE ORGANIZATIONS AND INDEXES
9 TREE-STRUCTURED INDEXING
10 HASH-BASED INDEXING
Part IV QUERY EVALUATION
11 EXTERNAL SORTING
12 EVALUATION OF RELATIONAL OPERATORS
13 INTRODUCTION TO QUERY OPTIMIZATION
14 A TYPICAL RELATIONAL QUERY OPTIMIZER
Part V DATABASE DESIGN
15 SCHEMA REFINEMENT AND NORMAL FORMS
16 PHYSICAL DATABASE DESIGN AND TUNING
17 SECURITY
Part VI TRANSACTION MANAGEMENT
18 TRANSACTION MANAGEMENT OVERVIEW
19 CONCURRENCY CONTROL
20 CRASH RECOVERY
Part VII ADVANCED TOPICS
21 PARALLEL AND DISTRIBUTED DATABASES
22 INTERNET DATABASES
23 DECISION SUPPORT
24 DATA MINING
25 OBJECT-DATABASE SYSTEMS
26 SPATIAL DATAMANAGEMENT
27 DEDUCTIVE DATABASES
28 ADDITIONAL TOPICS
A DATABASE DESIGN CASE STUDY: THE INTERNET SHOP
B THE MINIBASE SOFTWARE
REFERENCES
SUBJECT INDEX
AUTHOR INDEX
SIZE - 5 MB
+2012.png)
