Klientu atbalsts: 27018494

Grāmatu iegāde | Jauns profils | Ienākt

Modern Database Management 11th edition [Hardback]

3.46/5 (295 ratings by Goodreads)

Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi

Formāts: Hardback, 624 pages, height x width: 276x216 mm, weight: 1352 g
Izdošanas datums: 01-Oct-2012
Izdevniecība: Pearson
ISBN-10: 0132662256
ISBN-13: 9780132662253

Citas grāmatas par šo tēmu:

Hardback
Cena: 195,59 €*
* Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena
Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena.
Daudzums:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Ielikt grozā
Pievienot vēlmju sarakstam

Formāts: Hardback, 624 pages, height x width: 276x216 mm, weight: 1352 g
Izdošanas datums: 01-Oct-2012
Izdevniecība: Pearson
ISBN-10: 0132662256
ISBN-13: 9780132662253

Citas grāmatas par šo tēmu:

Permanent link: https://www.kriso.lv/db/9780132662253.html

Keywords:

Database management

Focusing on what leading database practitioners say are the most important aspects to database development, Modern Database Management presents sound pedagogy and includes topics that are critical for the practical success of database professionals.

Preface

xxiii

Part I The Context of Database Management

(52)

An Overview of Part One

(1)

Chapter 1 The Database Environment and Development Process

(51)

Learning Objectives

(1)

Data Matter!

(1)

Introduction

(2)

Basic Concepts and Definitions

(1)

Data

(1)

Data Versus Information

(1)

Metadata

(1)

Traditional File Processing Systems

(1)

File Processing Systems at Pine Valley Furniture Company

(1)

Disadvantages of File Processing Systems

(1)

Program-Data Dependence

(1)

Duplication of Data

(1)

Limited Data Sharing

(1)

Lengthy Development Times

(1)

Excessive Program Maintenance

(1)

The Database Approach

(1)

Data Models

(1)

Entities

(1)

Relationships

(1)

Relational Databases

(1)

Database Management Systems

(1)

Advantages of the Database Approach

(1)

Program-Data Independence

(1)

Planned Data Redundancy

(1)

Improved Data Consistency

(1)

Improved Data Sharing

(1)

Increased Productivity of Application Development

(1)

Enforcement of Standards

(1)

Improved Data Quality

(1)

Improved Data Accessibility and Responsiveness

(1)

Reduced Program Maintenance

(1)

Improved Decision Support

(1)

Cautions About Database Benefits

(1)

Costs and Risks of the Database Approach

(1)

New, Specialized Personnel

(1)

Installation and Management Cost and Complexity

(1)

Conversion Costs

(1)

Need for Explicit Backup and Recovery

(1)

Organizational Conflict

(1)

Components of the Database Environment

(1)

The Database Development Process

(1)

Systems Development Life Cycle

(1)

Planning---Enterprise Modeling

(1)

Planning---Conceptual Data Modeling

(1)

Analysis---Conceptual Data Modeling

(1)

Design---Logical Database Design

(1)

Design---Physical Database Design and Definition

(1)

Implementation---Database Implementation

(1)

Maintenance---Database Maintenance

(1)

Alternative Information Systems (IS) Development Approaches

(2)

Three-Schema Architecture for Database Development

(1)

Managing the People Involved in Database Development

(2)

Evolution of Database Systems

(1)

1960s

(2)

1970s

(1)

1980s

(1)

1990s

(1)

2000 and Beyond

(1)

The Range of Database Applications

(1)

Personal Databases

(1)

Two-Tier Client/Server Databases

(1)

Multitier Client/Server Databases

(1)

Enterprise Applications

(1)

Developing a Database Application for Pine Valley Furniture Company

(2)

Database Evolution at Pine Valley Furniture Company

(1)

Project Planning

(1)

Analyzing Database Requirements

(2)

Designing the Database

(3)

Using the Database

(2)

Administering the Database

(1)

Future of Databases at Pine Valley

(12)

Summary

(1)

Key Terms

(1)

Review Questions

(1)

Problems and Exercises

(1)

Field Exercises

(1)

References

(1)

Further Reading

(1)

Web Resources

(1)

Case: Mountain View Community Hospital

(5)

Part II Database Analysis

(98)

An Overview of Part Two

(2)

Chapter 2 Modeling Data in the Organization

(57)

Learning Objectives

(1)

Introduction

(2)

The E-R Model: An Overview

(1)

Sample E-R Diagram

(2)

E-R Model Notation

(1)

Modeling the Rules of the Organization

(1)

Overview of Business Rules

(1)

The Business Rules Paradigm

(1)

Scope of Business Rules

(1)

Good Business Rules

(1)

Gathering Business Rules

(1)

Data Names and Definitions

(1)

Data Names

(1)

Data Definitions

(1)

Good Data Definitions

(2)

Modeling Entities and Attributes

(1)

Entities

(1)

Entity Type Versus Entity Instance

(1)

Entity Type Versus System Input, Output, or User

(1)

Strong Versus Weak Entity Types

(1)

Naming and Defining Entity Types

(2)

Attributes

(1)

Required Versus Optional Attributes

(1)

Simple Versus Composite Attributes

(1)

Single-Valued Versus Multivalued Attributes

(1)

Stored Versus Derived Attributes

(1)

Identifier Attribute

(1)

Naming and Defining Attributes

(2)

Modeling Relationships

(1)

Basic Concepts and Definitions in Relationships

(1)

Attributes on Relationships

(1)

Associative Entities

(2)

Degree of a Relationship

(1)

Unary Relationship

(2)

Binary Relationship

(1)

Ternary Relationship

(1)

Attributes or Entity?

(2)

Cardinality Constraints

(1)

Minimum Cardinality

(1)

Maximum Cardinality

(1)

Some Examples of Relationships and Their Cardinalities

(1)

A Ternary Relationship

(1)

Modeling Time-Dependent Data

(3)

Modeling Multiple Relationships Between Entity Types

(2)

Naming and Defining Relationships

(1)

E-R Modeling Example: Pine Valley Furniture Company

(3)

Database Processing at Pine Valley Furniture

(1)

Showing Product Information

(1)

Showing Product Line Information

(1)

Showing Customer Order Status

(1)

Showing Product Sales

(14)

Summary

(1)

Key Terms

100

(1)

Review Questions

100

(1)

Problems and Exercises

101

(7)

Field Exercises

108

(1)

References

109

(1)

Further Reading

109

(1)

Web Resources

109

(1)

Case: Mountain View Community Hospital

110

(2)

Chapter 3 The Enhanced E-R Model

112

(39)

Learning Objectives

112

(1)

Introduction

112

(1)

Representing Supertypes and Subtypes

113

(1)

Basic Concepts and Notation

114

(1)

An Example of a Supertype/Subtype Relationship

115

(1)

Attribute Inheritance

116

(1)

When to Use Supertype/Subtype Relationships

116

(1)

Representing Specialization and Generalization

117

(1)

Generalization

117

(2)

Specialization

119

(1)

Combining Specialization and Generalization

120

(1)

Specifying Constraints in Supertype/Subtype Relationships

120

(1)

Specifying Completeness Constraints

120

(1)

Total Specialization Rule

120

(1)

Partial Specialization Rule

121

(1)

Specifying Disjointness Constraints

121

(1)

Disjoint Rule

121

(1)

Overlap Rule

122

(1)

Defining Subtype Discriminators

122

(1)

Disjoint Subtypes

123

(1)

Overlapping Subtypes

123

(1)

Defining Supertype/Subtype Hierarchies

124

(1)

An Example of a Supertype/Subtype Hierarchy

124

(1)

Summary of Supertype/Subtype Hierarchies

125

(1)

EER Modeling Example: Pine Valley Furniture Company

126

(3)

Entity Clustering

129

(3)

Packaged Data Models

132

(2)

A Revised Data Modeling Process with Packaged Data Models

134

(2)

Packaged Data Model Examples

136

(15)

Summary

141

(1)

Key Terms

142

(1)

Review Questions

142

(1)

Problems and Exercises

143

(3)

Field Exercises

146

(1)

References

146

(1)

Further Reading

146

(1)

Web Resources

147

(1)

Case: Mountain View Community Hospital

148

(3)

Part III Database Design

151

(90)

An Overview of Part Three

151

(2)

Chapter 4 Logical Database Design and the Relational Model

153

(53)

Learning Objectives

153

(1)

Introduction

153

(1)

The Relational Data Model

154

(1)

Basic Definitions

154

(1)

Relational Data Structure

155

(1)

Relational Keys

155

(1)

Properties of Relations

156

(1)

Removing Multivalued Attributes from Tables

156

(1)

Sample Database

156

(2)

Integrity Constraints

158

(1)

Domain Constraints

158

(1)

Entity Integrity

158

(2)

Referential Integrity

160

(1)

Creating Relational Tables

161

(1)

Well-Structured Relations

162

(1)

Transforming EER Diagrams into Relations

163

(1)

Step 1: Map Regular Entities

164

(1)

Composite Attributes

164

(1)

Multivalued Attributes

165

(1)

Step 2: Map Weak Entities

165

(1)

When to Create a Surrogate Key

166

(1)

Step 3: Map Binary Relationships

167

(1)

Map Binary One-to-Many Relationships

167

(1)

Map Binary Many-to-Many Relationships

167

(1)

Map Binary One-to-One Relationships

168

(1)

Step 4: Map Associative Entities

169

(1)

Identifier not Assigned

169

(1)

Identifier Assigned

170

(1)

Step 5: Map Unary Relationships

171

(1)

Unary One-to-Many Relationships

171

(1)

Unary Many-to-Many Relationships

171

(2)

Step 6: Map Ternary (and n-ary) Relationships

173

(1)

Step 7: Map Supertype/Subtype Relationships

173

(2)

Summary of EER-to-Relational Transformations

175

(1)

Introduction to Normalization

176

(1)

Steps in Normalization

177

(1)

Functional Dependencies and Keys

178

(1)

Determinants

178

(1)

Candidate Keys

178

(2)

Normalization Example: Pine Valley Furniture Company

180

(1)

Step 0: Represent the View in Tabular Form

180

(1)

Step 1: Convert to First Normal Form

181

(1)

Remove Repeating Groups

181

(1)

Select the Primary Key

181

(1)

Anomalies in 1NF

182

(1)

Step 2: Convert to Second Normal Form

182

(1)

Step 3: Convert to Third Normal Form

183

(1)

Removing Transitive Dependencies

184

(1)

Determinants and Normalization

185

(1)

Step 4: Further Normalization

185

(1)

Merging Relations

185

(1)

An Example

186

(1)

View Integration Problems

186

(1)

Synonyms

186

(1)

Homonyms

187

(1)

Transitive Dependencies

187

(1)

Supertype/Subtype Relationships

188

(1)

A Final Step for Defining Relational Keys

188

(18)

Summary

190

(2)

Key Terms

192

(1)

Review Questions

192

(1)

Problems and Exercises

193

(7)

Field Exercises

200

(1)

References

200

(1)

Further Reading

201

(1)

Web Resources

201

(1)

Case: Mountain View Community Hospital

202

(4)

Chapter 5 Physical Database Design and Performance

206

(35)

Learning Objectives

206

(1)

Introduction

206

(1)

The Physical Database Design Process

207

(1)

Physical Database Design as a Basis for Regulatory Compliance

208

(1)

Data Volume and Usage Analysis

209

(1)

Designing Fields

210

(1)

Choosing Data Types

211

(1)

Coding Techniques

212

(1)

Handling Missing Data

213

(1)

Denormalizing and Partitioning Data

213

(1)

Denormalization

213

(1)

Opportunities for and Types of Denormalization

214

(2)

Denormalize With Caution

216

(1)

Partitioning

217

(2)

Designing Physical Database Files

219

(1)

File Organizations

220

(1)

Sequential File Organizations

221

(1)

Indexed File Organizations

221

(3)

Hashed File Organizations

224

(2)

Clustering Files

226

(1)

Designing Controls for Files

227

(1)

Using and Selecting Indexes

228

(1)

Creating a Unique Key Index

228

(1)

Creating a Secondary (Nonunique) Key Index

228

(1)

When to Use Indexes

229

(1)

Designing a Database for Optimal Query Performance

230

(1)

Parallel Query Processing

230

(1)

Overriding Automatic Query Optimization

231

(10)

Summary

232

(1)

Key Terms

233

(1)

Review Questions

233

(1)

Problems and Exercises

233

(3)

Field Exercises

236

(1)

References

236

(1)

Further Reading

237

(1)

Web Resources

237

(1)

Case: Mountain View Community Hospital

238

(3)

Part IV Implementation

241

(192)

An Overview of Part Four

241

(2)

Chapter 6 Introduction to SQL

243

(46)

Learning Objectives

243

(1)

Introduction

243

(2)

Origins of the SQL Standard

245

(1)

The SQL Environment

246

(5)

Defining a Database in SQL

251

(1)

Generating SQL Database Definitions

252

(1)

Creating Tables

252

(3)

Creating Data Integrity Controls

255

(1)

Changing Table Definitions

256

(1)

Removing Tables

257

(1)

Inserting, Updating, and Deleting Data

257

(1)

Batch Input

258

(1)

Deleting Database Contents

259

(1)

Updating Database Contents

259

(1)

Internal Schema Definition in RDBMSs

260

(1)

Creating Indexes

260

(1)

Processing Single Tables

261

(1)

Clauses of the Select Statement

261

(2)

Using Expressions

263

(1)

Using Functions

264

(3)

Using Wildcards

267

(1)

Using Comparison Operators

267

(1)

Using Null Values

268

(1)

Using Boolean Operators

268

(2)

Using Ranges for Qualification

270

(1)

Using Distinct Values

271

(2)

Using In and Not In with Lists

273

(1)

Sorting Results: The Order By Clause

273

(1)

Categorizing Results: The Group By Clause

274

(1)

Qualifying Results by Categories: The Having Clause

275

(2)

Using and Defining Views

277

(4)

Materialized Views

281

(8)

Summary

281

(1)

Key Terms

282

(1)

Review Questions

282

(1)

Problems and Exercises

283

(3)

Field Exercises

286

(1)

References

286

(1)

Further Reading

287

(1)

Web Resources

287

(1)

Case: Mountain View Community Hospital

288

(1)

Chapter 7 Advanced SQL

289

(47)

Learning Objectives

289

(1)

Introduction

289

(1)

Processing Multiple Tables

290

(1)

Equi-join

291

(1)

Natural Join

292

(1)

Outer Join

293

(2)

Sample Join Involving Four Tables

295

(2)

Self-Join

297

(1)

Subqueries

298

(5)

Correlated Subqueries

303

(2)

Using Derived Tables

305

(1)

Combining Queries

306

(2)

Conditional Expressions

308

(1)

More Complicated SQL Queries

308

(2)

Tips for Developing Queries

310

(2)

Guidelines for Better Query Design

312

(2)

Ensuring Transaction Integrity

314

(1)

Data Dictionary Facilities

315

(2)

SQL:2008 Enhancements and Extensions to SQL

317

(1)

Analytical and OLAP Functions

317

(2)

New Data Types

319

(1)

Other Enhancements

319

(1)

Programming Extensions

320

(1)

Triggers and Routines

321

(1)

Triggers

322

(2)

Routines

324

(1)

Example Routine in Oracle's PL/SQL

325

(2)

Embedded SQL and Dynamic SQL

327

(9)

Summary

329

(1)

Key Terms

330

(1)

Review Questions

330

(1)

Problems and Exercises

331

(3)

Field Exercises

334

(1)

References

334

(1)

Further Reading

334

(1)

Web Resources

334

(1)

Case: Mountain View Community Hospital

335

(1)

Chapter 8 Database Application Development

336

(39)

Learning Objectives

336

(1)

Location, Location, Location!

336

(1)

Introduction

337

(1)

Client/Server Architectures

337

(2)

Databases in a Two-Tier Architecture

339

(2)

A VB.NET Example

341

(2)

A Java Example

343

(1)

Three-Tier Architectures

344

(2)

Web Application Components

346

(2)

Databases in Three-Tier Applications

348

(1)

A JSP Web Application

348

(4)

A PHP Example

352

(1)

An ASP.NET Example

352

(2)

Key Considerations in Three-Tier Applications

354

(1)

Stored Procedures

355

(1)

Transactions

356

(2)

Database Connections

358

(1)

Key Benefits of Three-Tier Applications

358

(1)

Cloud Computing and Three-Tier Applications

359

(1)

Extensible Markup Language (XML)

360

(2)

Storing XML Documents

362

(1)

Retrieving XML Documents

362

(3)

Displaying XML Data

365

(1)

XML and Web Services

365

(10)

Summary

369

(1)

Key Terms

369

(1)

Review Questions

370

(1)

Problems and Exercises

370

(1)

Field Exercises

371

(1)

References

371

(1)

Further Reading

371

(1)

Web Resources

371

(2)

Case: Mountain View Community Hospital

373

(2)

Chapter 9 Data Warehousing

375

(58)

Learning Objectives

375

(1)

Introduction

375

(2)

Basic Concepts of Data Warehousing

377

(1)

A Brief History of Data Warehousing

377

(1)

The Need for Data Warehousing

377

(1)

Need For a Company-Wide View

378

(3)

Need to Separate Operational and Informational Systems

381

(1)

Data Warehouse Architectures

381

(1)

Independent Data Mart Data Warehousing Environment

381

(2)

Dependent Data Mart and Operational Data Store Architecture: A Three-Level Approach

383

(2)

Logical Data Mart and Real-Time Data Warehouse Architecture

385

(3)

Three-Layer Data Architecture

388

(1)

Role of the Enterprise Data Model

389

(1)

Role of Metadata

389

(1)

Some Characteristics of Data Warehouse Data

389

(1)

Status Versus Event Data

389

(1)

Transient Versus Periodic Data

390

(1)

An Example of Transient and Periodic Data

390

(1)

Transient Data

390

(2)

Periodic Data

392

(1)

Other Data Warehouse Changes

392

(1)

The Derived Data Layer

393

(1)

Characteristics of Derived Data

393

(1)

The Star Schema

394

(1)

Fact Tables and Dimension Tables

394

(1)

Example Star Schema

395

(2)

Surrogate Key

397

(1)

Grain of the Fact Table

397

(1)

Duration of the Database

398

(1)

Size of the Fact Table

398

(1)

Modeling Date and Time

399

(1)

Variations of the Star Schema

400

(1)

Multiple Fact Tables

400

(1)

Factless Fact Tables

401

(1)

Normalizing Dimension Tables

401

(1)

Multivalued Dimensions

402

(1)

Hierarchies

403

(2)

Slowly Changing Dimensions

405

(3)

Determining Dimensions and Facts

408

(1)

Big Data and Colunnar Databases

408

(3)

If You Knew SQL Like 1 NoSQL

411

(1)

The User Interface

412

(1)

Role of Metadata

412

(1)

SQL OLAP Querying

413

(2)

Online Analytical Processing (OLAP) Tools

415

(1)

Slicing a Cube

416

(1)

Drill-Down

416

(1)

Summarizing More than Three Dimensions

417

(1)

Data Visualization

417

(1)

Business Performance Management and Dashboards

418

(1)

Data-Mining Tools

419

(1)

Data-Mining Techniques

419

(1)

Data-Mining Applications

420

(13)

Summary

421

(1)

Key Terms

421

(1)

Review Questions

422

(1)

Problems and Exercises

422

(4)

Field Exercises

426

(1)

References

427

(1)

Further Reading

427

(1)

Web Resources

427

(2)

Case: Mountain View Community Hospital

429

(4)

Part V Advanced Database Topics

433

(133)

An Overview of Part Five

433

(2)

Chapter 10 Data Quality and Integration

435

(28)

Learning Objectives

435

(1)

Introduction

435

(1)

Data Governance

436

(1)

Managing Data Quality

437

(1)

Characteristics of Quality Data

438

(1)

External Data Sources

439

(1)

Redundant Data Storage and Inconsistent Metadata

440

(1)

Data Entry Problems

440

(1)

Lack of Organizational Commitment

440

(1)

Data Quality Improvement

440

(1)

Get the Business Buy-In

440

(1)

Conduct a Data Quality Audit

441

(1)

Establish a Data Stewardship Program

442

(1)

Improve Data Capture Processes

442

(1)

Apply Modern Data Management Principles and Technology

443

(1)

Apply TQM Principles and Practices

443

(1)

Summary of Data Quality

443

(1)

Master Data Management

444

(1)

Data Integration: An Overview

445

(1)

General Approaches to Data Integration

445

(1)

Data Federation

446

(1)

Data Propagation

447

(1)

Data Integration for Data Warehousing: The Reconciled Data Layer

447

(1)

Characteristics of Data After ETL

447

(1)

The ETL Process

448

(1)

Mapping and Metadata Management

448

(1)

Extract

449

(1)

Cleanse

450

(2)

Load and Index

452

(1)

Data Transformation

453

(1)

Data Transformation Functions

454

(1)

Record-Level Functions

454

(1)

Field-Level Functions

455

(8)

Summary

457

(1)

Key Terms

457

(1)

Review Questions

457

(1)

Problems and Exercises

458

(1)

Field Exercises

459

(1)

References

459

(1)

Further Reading

460

(1)

Web Resources

460

(1)

Case: Mountain View Community Hospital

461

(2)

Chapter 11 Data and Database Administration

463

(50)

Learning Objectives

463

(1)

Introduction

463

(1)

The Roles of Data and Database Administrators

464

(1)

Traditional Data Administration

465

(1)

Traditional Database Administration

466

(3)

Trends in Database Administration

469

(1)

Data Warehouse Administration

470

(1)

Summary of Evolving Data Administration Roles

470

(1)

The Open Source Movement and Database Management

471

(1)

Managing Data Security

472

(1)

Threats to Data Security

473

(1)

Establishing Client/Server Security

474

(1)

Server Security

474

(1)

Network Security

475

(1)

Application Security Issues in Three-Tier Client/Server Environments

475

(1)

Data Privacy

476

(1)

Database Software Data Security Features

477

(1)

Views

478

(1)

Integrity Controls

479

(1)

Authorization Rules

480

(2)

User-Defined Procedures

482

(1)

Encryption

482

(1)

Authentication Schemes

483

(1)

Passwords

483

(1)

Strong Authentication

483

(1)

Sarbanes-Oxley (SOX) and Databases

484

(1)

IT Change Management

484

(1)

Logical Access to Data

484

(1)

Personnel Controls

485

(1)

Physical Access Controls

485

(1)

IT Operations

485

(1)

Database Backup and Recovery

486

(1)

Basic Recovery Facilities

486

(1)

Backup Facilities

486

(1)

Journalizing Facilities

487

(1)

Checkpoint Facility

487

(1)

Recovery Manager

488

(1)

Recovery and Restart Procedures

488

(1)

Disk Mirroring

488

(1)

Restore/Rerun

488

(1)

Maintaining Transaction Integrity

488

(2)

Backward Recovery

490

(1)

Forward Recovery

490

(1)

Types of Database Failure

491

(1)

Aborted Transactions

492

(1)

Incorrect Data

492

(1)

System Failure

492

(1)

Database Destruction

492

(1)

Disaster Recovery

493

(1)

Controlling Concurrent Access

493

(1)

The Problem of Lost Updates

493

(1)

Serializability

494

(1)

Locking Mechanisms

494

(1)

Locking Level

495

(1)

Types of Locks

496

(1)

Deadlock

496

(1)

Managing Deadlock

497

(1)

Versioning

498

(1)

Data Dictionaries and Repositories

499

(1)

Data Dictionary

499

(1)

Repositories

499

(2)

Overview of Tuning the Database for Performance

501

(1)

Installation of the DBMS

501

(1)

Memory and Storage Space Usage

502

(1)

Input/Output (I/O) Contention

502

(1)

CPU Usage

503

(1)

Application Tuning

503

(1)

Data Availability

504

(1)

Costs of Downtime

504

(1)

Measures to Ensure Availability

505

(1)

Hardware Failures

505

(1)

Loss or Corruption of Data

505

(1)

Human Error

505

(1)

Maintenance Downtime

505

(1)

Network-Related Problems

506

(7)

Summary

506

(1)

Key Terms

507

(1)

Review Questions

507

(1)

Problems and Exercises

508

(2)

Field Exercises

510

(1)

References

511

(1)

Further Reading

511

(1)

Web Resources

511

(1)

Case: Mountain View Community Hospital

512

(1)

Chapter 12 Overview: Distributed Databases

513

(5)

Learning Objectives

513

(1)

Overview

513

(1)

Objectives and Trade-offs

514

(1)

Options for Distributing a Database

514

(1)

Distributed DBMS

515

(1)

Query Optimization

515

(2)

Summary

516

(1)

Chapter Review

517

(1)

References

517

(1)

Further Reading

517

(1)

Web Resources

517

(1)

Chapter 13 Overview: Object-Oriented Data Modeling

518

(10)

Learning Objectives

518

(1)

Overview

518

(1)

Unified Modeling Language

519

(1)

Object-Oriented Data Modeling

519

(6)

Representing Aggregation

525

(1)

Summary

525

(1)

Chapter Review

526

(2)

References

526

(1)

Further Reading

527

(1)

Web Resources

527

(1)

Chapter 14 Overview: Using Relational Databases to Provide Object Persistence

528

(38)

Learning Objectives

528

(1)

Overview

528

(1)

Providing Persistence for Objects Using Relational Databases

529

(1)

Call-Level Application Programming Interfaces

529

(1)

SQL Query Mapping Frameworks

530

(1)

Object-Relational Mapping Frameworks

530

(1)

Proprietary Approaches

530

(1)

Selecting the Right Approach

530

(1)

Object-Relational Mapping Example

531

(1)

Mapping Files

532

(3)

Responsibilities of Object-Relational Mapping Frameworks

535

(1)

Summary

536

(1)

Chapter Review

536

(2)

References

536

(1)

Further Reading

537

(1)

Web Resources

537

(1)

Appendix A Data Modeling Tools and Notation

538

(1)

Comparing E-R Modeling Conventions

538

(1)

Visio Professional 2010 Notation

538

(4)

Entities

542

(1)

Relationships

542

(1)

CA ERwin Data Modeler r8 Notation

542

(1)

Entities

542

(1)

Relationships

542

(2)

Sybase PowerDesigner 16 Notation

544

(1)

Entities

545

(1)

Relationships

545

(1)

Oracle Designer Notation

545

(1)

Entities

545

(1)

Relationships

545

(1)

Comparison of Tool Interfaces and E-R Diagrams

545

(3)

Appendix B Advanced Normal Forms

548

(1)

Boyce-Codd Normal Form

548

(1)

Anomalies in Student Advisor

548

(1)

Definition of Boyce-Codd Normal Form (BCNF)

549

(1)

Converting a Relation to BCNF

549

(1)

Fourth Normal Form

550

(2)

Multivalued Dependencies

552

(1)

Higher Normal Forms

552

(2)

Key Terms

553

(1)

References

553

(1)

Web Resources

553

(1)

Appendix C Data Structures

554

(1)

Pointers

554

(1)

Data Structure Building Blocks

555

(2)

Linear Data Structures

557

(1)

Stacks

558

(1)

Queues

558

(1)

Sorted Lists

559

(2)

Multilists

561

(1)

Hazards of Chain Structures

561

(1)

Trees

562

(1)

Balanced Trees

562

(3)

Reference

565

(1)

Glossary of Acronyms

566

(2)

Glossary of Terms

568

(8)

Index

576

Modern Database Management 11th edition [Hardback]

Konts un iestatījumi

Meklēšana

Meklēt datubāzē

Refine By

Tēmas Grāmatas angļu valodā

Izvēlieties iepirkumu grozu