Practical issues in Database Management

A Reference for the Thinking Professional

Fabian Pascal

288 pages, parution le 22/05/2000

Ajouter à une liste

Indisponible

Résumé

Three decades ago relational technology put the database field on a sound, scientific foundation for the first time. But the database industry--vendors, users, experts, and the trade press--has essentially
flouted its principles, focusing instead on a "cookbook," product-specific approach, devoid of conceptual understanding. The consequences have been costly: DBMS products, databases, development tools, and applications not only don't always perform up to expectation or potential, but they can encourage the wrong questions and provide the wrong answers.

Practical Issues in Database Management is an attempt to remedy this intractable and costly situation. Written for database designers, programmers, managers, and users, it addresses the core, commonly recurring issues and problems that practitioners--even the most experienced database professionals--seem to systematically misunderstand, namely:

Unstructured data and complex data types
Business rules and integrity enforcement
Keys
Duplicates
Normalization and denormalization
Entity subtypes and supertypes
Data hierarchies and recursive queries
Redundancy
Quota queries
Missing information

Table of contents

Foreword
Preface
Chapter 1: Careful What you Wish for: Data Types and Complexity
Chapter 2: The Rule of Rules: Integrity
Chapter 3: A Matter of Identity: Keys
Chapter 4: Don't Get Duped by Dupes: Duplicate Rows
Chapter 5: The Key, the Whole Key, and Nothing but hte Key
Chapter 6: Neither Distince nor the Same
Chapter 7: Climbing Trees in SQL
Chapter 8: Not Worh Repeating
Chapter 9: Will SQL Come to Order
Chapter 10: What You Don't Know
Index

L'auteur - Fabian Pascal

Fabian Pascal

is an independent industry analyst, consultant, author, and lecturer specializing in database management. He is the author of two previous books, Understanding Relational Databases and SQL and Relational Basics, and has contributed extensively to many industry publications.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Addison Wesley
Auteur(s)	Fabian Pascal
Parution	22/05/2000
Nb. de pages	288
EAN13	9780201485554

Avantages Eyrolles.com

Livraison à partir de 0,01 € en France métropolitaine

Paiement en ligne SÉCURISÉ

Livraison dans le monde

Retour sous 15 jours

+ d'un million et demi de livres disponibles

Practical issues in Database Management

Résumé

L'auteur - Fabian Pascal

Caractéristiques techniques

Consultez aussi