Modern database management

Başlık:

Yazar:

Hoffer, Jeffrey A.

ISBN:

9780132212113

Ek Yazar:

Hoffer, Jeffrey A.

Edition:

8. baskı.

Yayım Bilgisi:

Fiziksel Tanım:

xxxiv, 622 : resim ; 29 cm.

General Note:

ODL_2016/2017.

Contents:

Part I : The context of database management -- The database environment -- The database development process -- Part II : Database analysis -- Modeling data in the organization -- The enhances E-R model and business rules -- Part III : Database design -- Logical database design and the relational model -- Physical database design and performance -- Part IV : Implementation -- Introduction to SQL -- Advances SQL -- The client/server database environment -- The internet database environment -- Data warehousing -- Part V : Advanced database topics -- Data and database administration -- Overview : Distributed databases -- Overview : Object-oriented data modeling -- Overview : Object-oriented database development.

Abstract:

Reacting to the business environment, this work addresses issues such as Internet, data warehousing and object-orientation. The text instructs from a business perspective, allowing students to understand database management within a business.

Konu Terimleri:

Veritabanı yönetimi.

Database management.

Added Author:

Prescott, Mary B.

McFadden, Fred R., 1933-

Mevcut:*

Library	Materyal Türü	Barkod	Yer Numarası	Durum
Searching... Pamukkale Merkez Kütüphanesi	Kitap	0100670	QA76.9 .D3 M395 2007	Searching... Unknown

Bound With These Titles

On Order

Özet

Author Notes

Jeffrey A. Hoffer ( hoffer@udayton.edu ) is the Sherman Standard Register Professor of Data Management in the MIS, Operations Management, and Decision Sciences Department at the University of Dayton. He received a PhD from Cornell University in 1973 and was on the faculties of Case Western Reserve University and Indiana University before joining UD. He is a founder of the INFORMS College on Information Systems, the International Conference on Information Systems (and its conference chair in 1985), and the Association for Information Systems. He is author of many scholarly publications in the areas of database management, data warehousing, systems analysis, strategic systems planning, and human-computer interaction. He is co-author of several leading textbooks: Modern Database Management , Modern Systems Analysis and Design , Essentials of Systems Analysis and Design , Object-Oriented Systems Analysis and Design , and Managing Information Technology: What Managers Need to Know , all published by Prentice-Hall. Dr. Hoffer is also an Associate Director of the Teradata University Network, the leading web portal for faculty and students in the data management, data warehousing, decision support, and business intelligence areas.

Preface	p. xxiii
Part I The Context of Database Management
Part I Overview	p. 2
1 The Database Environment	p. 3
Learning Objectives	p. 3
Data Matters!	p. 3
Introduction	p. 4
Basic Concepts and Definitions	p. 6
Traditional File Processing Systems	p. 10
File Processing Systems at Pine Valley Furniture Company	p. 11
The Database Approach	p. 13
Advantages of The Database Approach	p. 14
Cautions About Database Benefits	p. 16
Costs and Risks of The Database Approach	p. 16
Components of the Database Environment	p. 17
The Range of Database Applications	p. 18
Evolution of Database Systems	p. 25
Summary	p. 28
Chapter Review	p. 29
Case: Mountain View Community Hospital	p. 33
2 The Database Development Process	p. 36
Learning Objectives	p. 36
Introduction	p. 36
Database Development Within Information Systems Development	p. 37
Database Development Process	p. 42
Managing the People Involved in Database Development	p. 50
Three-Schema Architecture for Database Development	p. 52
Three-Tiered Database Location Architecture	p. 56
Developing a Database Application for Pine Valley Furniture Company	p. 57
Summary	p. 70
Chapter Review	p. 71
Case: Mountain View Community Hospital	p. 76
Part II Database Analysis
Part II Overview	p. 84
3 Modeling Data in the Organization	p. 85
Learning Objectives	p. 85
Introduction	p. 85
Modeling the Rules of the Organization	p. 87
The E-R Model: An Overview	p. 93
Modeling Entities and Attributes	p. 96
Modeling Relationships	p. 106
E-R Modeling Example: Pine Valley Furniture Company	p. 123
Database Processing at Pine Valley Furniture	p. 125
Summary	p. 128
Chapter Review	p. 129
Case: Mountain View Community Hospital	p. 137
4 The Enhanced E-R Model and Business Rules	p. 139
Learning Objectives	p. 139
Introduction	p. 139
Representing Supertypes and Subtypes	p. 140
Specifying Constraints in Supertype/Subtype Relationships	p. 147
EER Modeling Example: Pine Valley Furniture	p. 153
Entity Clustering	p. 157
Packaged Data Models	p. 160
Business Rules Revisited	p. 166
Summary	p. 174
Chapter Review	p. 175
Case: Mountain View Community Hospital	p. 181
Part III Database Design
Part III Overview	p. 186
5 Logical Database Design and the Relational Model	p. 187
Learning Objectives	p. 187
Introduction	p. 187
The Relational Data Model	p. 188
Integrity Constraints	p. 193
Transforming EER Diagrams into Relations	p. 197
Introduction to Normalization	p. 211
Normalization Example: Pine Valley Furniture Company	p. 214
Merging Relations	p. 220
A Final Step for Defining Relational Keys	p. 223
Summary	p. 225
Chapter Review	p. 226
Case: Mountain View Community Hospital	p. 235
6 Physical Database Design and Performance	p. 240
Learning Objectives	p. 240
Introduction	p. 240
Physical Database Design Process	p. 241
Designing Fields	p. 244
Designing Physical Records and Denormalization	p. 248
Designing Physical Files	p. 254
Using and Selecting Indexes	p. 265
RAID: Improving File Access Performance by Parallel Processing	p. 267
Designing Databases	p. 270
Optimizing for Query Performance	p. 273
Summary	p. 278
Chapter Review	p. 279
Case: Mountain View Community Hospital	p. 284
Part IV Implementation
Part IV Overview	p. 288
7 Introduction to SQL	p. 289
Learning Objectives	p. 289
Introduction	p. 289
History of the SQL Standard	p. 291
The Role of SQL in a Database Architecture	p. 292
The SQL Environment	p. 293
Defining a Database in SQL	p. 298
Inserting, Updating, and Deleting Data	p. 304
Internal Schema Definition in RDBMSs	p. 307
Processing Single Tables	p. 308
Summary	p. 326
Chapter Review	p. 327
Case: Mountain View Community Hospital	p. 332
8 Advanced SQL	p. 333
Learning Objectives	p. 333
Introduction	p. 333
Processing Multiple Tables	p. 334
Ensuring Transaction Integrity	p. 349
Data Dictionary Facilities	p. 350
SQL:2003 Enhancements and Extensions to SQL	p. 352
Triggers and Routines	p. 356
Embedded SQL and Dynamic SQL	p. 360
Summary	p. 362
Chapter Review	p. 363
Case: Mountain View Community Hospital	p. 367
9 The Client/Server Database Environment	p. 368
Learning Objectives	p. 368
Location, Location, Location!	p. 368
Introduction	p. 369
Client/Server Architectures	p. 370
Three-Tier Architectures	p. 374
Partitioning an Application	p. 376
Role of the Mainframe	p. 378
Using Middleware	p. 379
Client/Server Issues	p. 382
Using ODBC to Link External Tables Stored on a Database Server	p. 383
Using JDBC to Link External Tables Stored on a Database Server	p. 385
Looking Forward with Client/Server in Mind	p. 386
Summary	p. 386
Chapter Review	p. 387
Case: Mountain View Community Hospital	p. 390
10 The Internet Database Environment	p. 392
Learning Objectives	p. 392
Introduction	p. 392
The Internet and Database Connection	p. 393
The Internet Environment	p. 394
Common Internet Architecture Components	p. 396
Web-to-Database Tools	p. 403
Summary	p. 414
Chapter Review	p. 415
Case: Mountain View Community Hospital	p. 418
11 Data Warehousing	p. 420
Learning Objectives	p. 420
Introduction	p. 420
Basic Concepts of Data Warehousing	p. 422
Data Warehouse Architectures	p. 428
Some Characteristics of Data Warehouse Data	p. 437
The Reconciled Data Layer	p. 441
Data Transformation	p. 447
The Derived Data Layer	p. 452
The User Interface	p. 465
Summary	p. 470
Chapter Review	p. 471
Case: Mountain View Community Hospital	p. 478
Part V Advanced Database Topics
Part V Overview	p. 482
12 Data and Database Administration	p. 483
Learning Objectives	p. 483
Introduction	p. 483
The Roles of Data and Database Administrators	p. 485
The Open-Source Movement	p. 492
Modeling Enterprise Data	p. 494
Managing Data Security	p. 495
Database Backup and Recovery	p. 510
Controlling Concurrent Access	p. 517
Managing Data Quality	p. 523
Data Dictionaries and Repositories	p. 527
Overview of Tuning the Database for Performance	p. 529
Data Availability	p. 533
Summary	p. 535
Chapter Review	p. 535
Case: Mountain View Community Hospital	p. 542
13 Overview: Distributed Databases	p. 544
Learning Objectives	p. 544
Overview	p. 544
Chapter Review	p. 547
14 Overview: Object-Oriented Data Modeling	p. 548
Learning Objectives	p. 548
Overview	p. 548
Chapter Review	p. 555
15 Overview: Object-Oriented Database Development	p. 556
Learning Objectives	p. 556
Overview	p. 556
Chapter Review	p. 561
Appendix A Data Modeling Tools and Notation	p. 562
Comparing E-R Modeling Conventions	p. 562
Visio Professional 2003 Notation	p. 562
AllFusion ERwin Data Modeler 4.1 SPI Notation	p. 565
Sybase Power Designer 11.1 Notation	p. 568
Oracle Designer Notation	p. 569
Comparison of Tool Interfaces and E-R Diagrams	p. 571
Appendix B Advanced Normal Forms	p. 572
Boyce-Codd Normal Form	p. 572
Anomalies in STUDENT_ADVISOR	p. 573
Definition of Boyce-Codd Normal Form (BCNF)	p. 573
Converting a Relation to BCNF	p. 573
Fourth Normal Form	p. 574
Multivalued Dependencies	p. 576
Higher Normal Forms	p. 576
Appendix Review	p. 577
Key Terms	p. 577
References	p. 577
Web Resources	p. 577
Appendix C Data Structures	p. 578
Pointers	p. 578
Data Structure Building Blocks	p. 579
Linear Data Structures	p. 581
Stacks	p. 582
Queues	p. 583
Sorted Lists	p. 583
Multilists	p. 585
Hazards of Chain Structures	p. 586
Trees	p. 587
Balanced Trees	p. 587
References	p. 590
Appendix D Object-Relational Databases	p. 591
Basic Concepts and Definitions	p. 591
Features of an ORDBMS	p. 592
Complex Data Types	p. 592
Enhanced SQL	p. 593
A Simple Example	p. 594
Content Addressing	p. 594
Advantages of the Object-Relational Approach	p. 595
ORDBMS Vendors and Products	p. 595
Appendix Review	p. 596
Key Terms	p. 596
References	p. 596
Web Resources	p. 596
Glossary of Acronyms	p. 597
Glossary of Terms	p. 600
Index	p. 609

Mevcut:*

Bound With These Titles

On Order

Özet

Özet

Author Notes

Table of Contents