Modern Database Management / Edition 10

Modern Database Management / Edition 10

by Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
     
 

View All Available Formats & Editions

ISBN-10: 0136088392

ISBN-13: 9780136088394

Pub. Date: 07/29/2010

Publisher: Prentice Hall

Reacting to the current business environment, Modern Database Management, 6/e addresses current issues in the market, such as Internet, data warehousing and object-orientation. While sufficient technical explanations are given, the book instructs from a business perspective, allowing readers to understand the role of database management within a

Overview

Reacting to the current business environment, Modern Database Management, 6/e addresses current issues in the market, such as Internet, data warehousing and object-orientation. While sufficient technical explanations are given, the book instructs from a business perspective, allowing readers to understand the role of database management within a business. Chapter topics cover the database environment and development process, modeling data in the organization, advanced data modeling, logical database design and the relational model, physical database design and performance, SQL, advanced SQL, the client/server environment, the Internet environment, data warehousing, data and database administration, distributed databases, object-oriented data modeling, and object-oriented database development.

Product Details

ISBN-13:
9780136088394
Publisher:
Prentice Hall
Publication date:
07/29/2010
Series:
Pearson Custom Business Resources Series
Edition description:
Older Edition
Pages:
624
Product dimensions:
8.70(w) x 10.90(h) x 1.00(d)

Table of Contents

Prefacexxiii
Part IThe Context of Database Management
Part I Overview2
1The Database Environment3
Learning Objectives3
Data Matters!3
Introduction4
Basic Concepts and Definitions6
Traditional File Processing Systems10
File Processing Systems at Pine Valley Furniture Company11
The Database Approach13
Advantages of The Database Approach14
Cautions About Database Benefits16
Costs and Risks of The Database Approach16
Components of the Database Environment17
The Range of Database Applications18
Evolution of Database Systems25
Summary28
Chapter Review29
Case: Mountain View Community Hospital33
2The Database Development Process36
Learning Objectives36
Introduction36
Database Development Within Information Systems Development37
Database Development Process42
Managing the People Involved in Database Development50
Three-Schema Architecture for Database Development52
Three-Tiered Database Location Architecture56
Developing a Database Application for Pine Valley Furniture Company57
Summary70
Chapter Review71
Case: Mountain View Community Hospital76
Part IIDatabase Analysis
Part II Overview84
3Modeling Data in the Organization85
Learning Objectives85
Introduction85
Modeling the Rules of the Organization87
The E-R Model: An Overview93
Modeling Entities and Attributes96
Modeling Relationships106
E-R Modeling Example: Pine Valley Furniture Company123
Database Processing at Pine Valley Furniture125
Summary128
Chapter Review129
Case: Mountain View Community Hospital137
4The Enhanced E-R Model and Business Rules139
Learning Objectives139
Introduction139
Representing Supertypes and Subtypes140
Specifying Constraints in Supertype/Subtype Relationships147
EER Modeling Example: Pine Valley Furniture153
Entity Clustering157
Packaged Data Models160
Business Rules Revisited166
Summary174
Chapter Review175
Case: Mountain View Community Hospital181
Part IIIDatabase Design
Part III Overview186
5Logical Database Design and the Relational Model187
Learning Objectives187
Introduction187
The Relational Data Model188
Integrity Constraints193
Transforming EER Diagrams into Relations197
Introduction to Normalization211
Normalization Example: Pine Valley Furniture Company214
Merging Relations220
A Final Step for Defining Relational Keys223
Summary225
Chapter Review226
Case: Mountain View Community Hospital235
6Physical Database Design and Performance240
Learning Objectives240
Introduction240
Physical Database Design Process241
Designing Fields244
Designing Physical Records and Denormalization248
Designing Physical Files254
Using and Selecting Indexes265
RAID: Improving File Access Performance by Parallel Processing267
Designing Databases270
Optimizing for Query Performance273
Summary278
Chapter Review279
Case: Mountain View Community Hospital284
Part IVImplementation
Part IV Overview288
7Introduction to SQL289
Learning Objectives289
Introduction289
History of the SQL Standard291
The Role of SQL in a Database Architecture292
The SQL Environment293
Defining a Database in SQL298
Inserting, Updating, and Deleting Data304
Internal Schema Definition in RDBMSs307
Processing Single Tables308
Summary326
Chapter Review327
Case: Mountain View Community Hospital332
8Advanced SQL333
Learning Objectives333
Introduction333
Processing Multiple Tables334
Ensuring Transaction Integrity349
Data Dictionary Facilities350
SQL:2003 Enhancements and Extensions to SQL352
Triggers and Routines356
Embedded SQL and Dynamic SQL360
Summary362
Chapter Review363
Case: Mountain View Community Hospital367
9The Client/Server Database Environment368
Learning Objectives368
Location, Location, Location!368
Introduction369
Client/Server Architectures370
Three-Tier Architectures374
Partitioning an Application376
Role of the Mainframe378
Using Middleware379
Client/Server Issues382
Using ODBC to Link External Tables Stored on a Database Server383
Using JDBC to Link External Tables Stored on a Database Server385
Looking Forward with Client/Server in Mind386
Summary386
Chapter Review387
Case: Mountain View Community Hospital390
10The Internet Database Environment392
Learning Objectives392
Introduction392
The Internet and Database Connection393
The Internet Environment394
Common Internet Architecture Components396
Web-to-Database Tools403
Summary414
Chapter Review415
Case: Mountain View Community Hospital418
11Data Warehousing420
Learning Objectives420
Introduction420
Basic Concepts of Data Warehousing422
Data Warehouse Architectures428
Some Characteristics of Data Warehouse Data437
The Reconciled Data Layer441
Data Transformation447
The Derived Data Layer452
The User Interface465
Summary470
Chapter Review471
Case: Mountain View Community Hospital478
Part VAdvanced Database Topics
Part V Overview482
12Data and Database Administration483
Learning Objectives483
Introduction483
The Roles of Data and Database Administrators485
The Open-Source Movement492
Modeling Enterprise Data494
Managing Data Security495
Database Backup and Recovery510
Controlling Concurrent Access517
Managing Data Quality523
Data Dictionaries and Repositories527
Overview of Tuning the Database for Performance529
Data Availability533
Summary535
Chapter Review535
Case: Mountain View Community Hospital542
13Overview: Distributed Databases544
Learning Objectives544
Overview544
Chapter Review547
14Overview: Object-Oriented Data Modeling548
Learning Objectives548
Overview548
Chapter Review555
15Overview: Object-Oriented Database Development556
Learning Objectives556
Overview556
Chapter Review561
Appendix AData Modeling Tools and Notation562
Comparing E-R Modeling Conventions562
Visio Professional 2003 Notation562
AllFusion ERwin Data Modeler 4.1 SPI Notation565
Sybase Power Designer 11.1 Notation568
Oracle Designer Notation569
Comparison of Tool Interfaces and E-R Diagrams571
Appendix BAdvanced Normal Forms572
Boyce-Codd Normal Form572
Anomalies in STUDENT_ADVISOR573
Definition of Boyce-Codd Normal Form (BCNF)573
Converting a Relation to BCNF573
Fourth Normal Form574
Multivalued Dependencies576
Higher Normal Forms576
Appendix Review577
Key Terms577
References577
Web Resources577
Appendix CData Structures578
Pointers578
Data Structure Building Blocks579
Linear Data Structures581
Stacks582
Queues583
Sorted Lists583
Multilists585
Hazards of Chain Structures586
Trees587
Balanced Trees587
References590
Appendix DObject-Relational Databases591
Basic Concepts and Definitions591
Features of an ORDBMS592
Complex Data Types592
Enhanced SQL593
A Simple Example594
Content Addressing594
Advantages of the Object-Relational Approach595
ORDBMS Vendors and Products595
Appendix Review596
Key Terms596
References596
Web Resources596
Glossary of Acronyms597
Glossary of Terms600
Index609

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >