Text

Modern database management

---

Contents

Part I. The Context of Database Management
Chapter 1. The Database Environment
1.1. Learning Objectives
1.2. Data Matters!
1.3. Introduction
1.4. Basic Concepts and Definitions
1.5. Traditional File Processing Systems
1.6. The Database Approach
1.7. Components of the Database Environment
1.8. The Range of Database Applications
1.9. Evolution of Database Systems
1.10. Summary
1.11. Chapter Review
1.12. Key Terms
1.13. Review Questions
1.14. Problem and Exercises
1.15. Field Exercises
1.16. References
1.17. Further Reading
1.18. Web Resources

Chapter 2. The Database Development Process
2.1. Learning Objectives
2.2. Introduction
2.3. Database Development Within Information Systems Development
2.4. Database Development Process
2.5. Managing the People Involved in Database Development
2.6. Three-Schema Architecture for Database Development
2.7. Three-Tiered Database Location Architecture
2.8. Developing a Database Application for Pine Valley Furniture Company
2.9. Summary
2.10. Chapter Review
2.11. Key Terms
2.12. Review Questions
2.13. Problem and Exercises
2.14. Field Exercises
2.15. References
2.16. Further Reading
2.17. Web Resources

Part II: Database Analysis
Chapter 3. Modeling Data in the Organization
3.1. Learning Objectives
3.2. Introduction
3.3. Modeling the Rules of the Organization
3.4. The E-R Model: An Overview
3.5. Modeling Entities and Attributes
3.6. Modeling Relationships
3.7. E-R Modeling example: Pine Valley Furniture Company
3.8. Database Processing at Pine Valley Furniture
3.9. Summary
3.10. Chapter Review
3.11. Key Terms
3.12. Review Questions
3.13. Problem and Exercises
3.14. Field Exercises
3.15. References
3.16. Further Reading
3.17. Web Resources

Chapter 4. The Enhanced E-R Model and Business Rules
4.1. Learning Objectives
4.2. Introduction
4.3. Representing Supertypes and Subtypes
4.4. Specyfing Constraintsin Supertype/Subtype
4.5. EER Modeling Example: Pine Valley Furniture
4.6. Entity Clustering
4.7. Packaged Data Models
4.8. Business Rules Revisited
4.9. Summary
4.10. Chapter Review
4.11. Key Terms
4.12. Review Questions
4.13. Problem and Exercises
4.14. Field Exercises
4.15. References
4.16. Further Reading
4.17. Web Resources

Part III: Database Design
Chapter 5. Logical Database Design and the Relational Model
5.1. Learning Objectives
5.2. Introduction
5.3. The Relational Data Model
5.4. Integrity Constraints
5.5. Transforming EER Diagrams into Relations
5.6. Introduction to Normalization
5.7. Normalization Example: Pine Valley Furniture Company
5.8. Merging Relations
5.9. A Final Step for Defining Relational Keys
5.10. Summary
5.11. Chapter Review
5.12. Key Terms
5.13. Review Questions
5.14. Problem and Exercises
5.15. Field Exercises
5.16. References
5.17. Further Reading
5.18. Web Resources

Chapter 6. Physical Database Design and Performance
6.1. Learning Objectives
6.2. Introduction
6.3. Physical Database Design Process
6.4. Designing Field
6.5. Desinging Physical Record and Denormalization
6.6. Designing Physical Files
6.7. Using and Selecting Indexes
6.8. RAID: Improving File Access Performance by Parallel Processing
6.9. Designing Databases
6.10. Optimizing for Query Performance
6.11. Summary
6.12. Chapter Review
6.13. Key Terms
6.14. Review Questions
6.15. Problem and Exercises
6.16. Field Exercises
6.17. References
6.18. Further Reading
6.19. Web Resources

Part IV: Implementation
Chapter 7. Introduction to SQL
7.1. Learning Objectives
7.2. Introduction
7.3. History of the SQL Standard
7.4. The Role of SQL in Database Architecture
7.5. The SQL Environment
7.6. Defining a Database in SQL
7.7. Inserting, Updating, Deleting Data
7.8. Internal Schema DEfinition in RDBMSs
7.9. Processing Single Table
7.10. Summary
7.11. Chapter Review
7.12. Key Terms
7.13. Review Questions
7.14. Problem and Exercises
7.15. Field Exercises
7.16. References
7.17. Further Reading
7.18. Web Resources

Chapter 8. Advanced SQL
8.1. Learning Objectives
8.2. Introduction
8.3. Processing Multiple Tables
8.4. Ensuring Transaction Integrity
8.5. Data Dictionary Facilities
8.6. SQL: 200N Enhancement and Extensions to SQL
8.7. Triggers and Routines
8.8. Embedded SQL and Dynamic SQL
8.9. OLAP SQL
8.10. Summary
8.11. Chapter Review
8.12. Key Terms
8.13. Review Questions
8.14. Problem and Exercises
8.15. Field Exercises
8.16. References
8.17. Further Reading
8.18. Web Resources

Chapter 9. The Client/Server Database Environment
9.1. Learning Objectives
9.2. Introduction
9.3. Location, Location, Location!
9.4. Client/Server Architectures
9.5. Three-Tier Architectures
9.6. Partitioning an Application
9.7. Role of Mainframe
9.8. Using Middleware
9.9. Client/Server Issues
9.10. Using ODBC to Link External Tables Stored on a Database Server
9.11. Using JDBC to Link External Tables Stored on a Database Server
9.12. Looking Forward with Client/Server in Mind
9.13. Summary
9.14.. Chapter Review
9.15. Key Terms
9.16. Review Questions
9.17. Problem and Exercises
9.18. Field Exercises
9.19. References
9.20. Further Reading
9.21. Web Resources

Chapter 10. The Internet Database Environment
10.1. Learning Objectives
10.2. Introduction
10.3. The Internet and Database Connection
10.4. The Internet Environment
10.5. Common Internet Architecture Components
10.6. Web-to-Database Tools
10.7. Summary
10.8. Chapter Review
10.9. Key Terms
10.10. Review Questions
10.11. Problem and Exercises
10.12. Field Exercises
10.13. References
10.14. Further Reading
10.15. Web Resources

Chapter 11. Data Warehousing
11.1. Learning Objectives
11.2. Introduction
11.3. Basic Concepts of Data Warehousing
11.4. Data Warehouse Architectures
11.5. Some Characteristics of Data Warehouse Data
11.6. The Derived Data Layer
11.7. The User Interface
11.8. Summary
11.9. Chapter Review
11.10. Key Terms
11.11. Review Questions
11.12. Problem and Exercises
11.13. Field Exercises
11.14. References
11.15. Further Reading
11.16. Web Resources

Part V: Advanced Database Topics
Chapter 12. Data Quality and Integration
12.1. Learning Objects
12.2. Introduction
12.3. Managing Data Quality
12.4. Data Integration: An Overview
12.5. Data Integration for Data Warehousing: The Reconciled
12.6. Data Transformation
12.7. Summary
12.8. Chapter Review
12.9. Key Terms
12.10. Review Questions
12.11. Problem and Exercises
12.12. Field Exercises
12.13. References
12.14. Further Reading
12.15. Web Resources

Chapter 13. Data and Database Administration
13.1. Learning Objectives
13.2. Introduction
13.3. The Roles of Data and Database Administration
13.4. The Open-Source Movement
13.5. Modeling Enterprise Data
13.6. Managing Data Security
13.7. Database Backup and Recovery
13.8. Controlling Concurrent Access
13.9. Data Dictionaries and Repositories
13.10. Overview of Tuning the Database for Performance
13.11. Data Availibility
13.12. Summary
13.13. Chapter Review
13.14. Key Terms
13.15. Review Questions
13.16. Problem and Exercises
13.17. Field Exercises
13.18. References
13.19. Further Reading
13.20. Web Resources

Chapter 14. Overview: Distributed Databases
14.1. Learning Objectives
14.2. Overview
14.3. Chapter Review
14.4. References
14.5. Further Reading
14.6. Web Resources

Chapter 15. Overview: Object-Oriented Data Modeling
15.1. Learning Objectives
15.2. Overview
15.3. Chapter Review
15.4. References
15.5. Further Reading
15.6. Web Resources

Chapter 16. Overview: Using Relational Databases to Provide Object Persistance
16.1. Learning Objectives
16.2. Overview
16.3. Chapter Review
16.4. References
16.5. Further Reading
16.6. Web Resources

---

Availability

Detail Information

Series Title

-

Call Number

0005 HOF M

Publisher

New Jersey : Pearson Education., 2009

Collation

729 hal.; ilus.; 28 cm

Language

English

ISBN/ISSN

9780137130481

Classification

0005

Content Type

-

Media Type

-

Carrier Type

-

Edition

Ninth Edition

Subject(s)

-

Specific Detail Info

-

Statement of Responsibility

Jeffrey A. Hoffer

Other version/related

File Attachment

Comments

---

You must be logged in to post a comment