Wiorkowski Db2: Design

ISBN 13: 9780201507355

Db2: Design

0 avg rating
( 0 ratings by Goodreads )
 
9780201507355: Db2: Design

This book is a revision of the successful guide to DB2. It presents proven techniques required to produce DB2 applications with high performance characteristics. It has been updated to cover the new Release 2.3 of DB2 and the depth of coverage has been expanded throughout the seventeen chapters of the book. It also contains new and unique coverage of programming for performance, optimization, and the EXPLAIN command. Highlights: *Provides indepth and expanded coverage of performance. *Provides hints, tips, and guidelines for the design and development of application systems. *Conveys and understanding of SQL processing to maximize the performance so that the guidelines can be applied to your specific application system. *Incorporates new features of Release 2.3 throughout the book. *Contains a new chapter on program preparation and execution detailing how to use packages and plans, including fall back procedures. This book is an excellent resource for professional database designers and developers. It is concise and easy to read--making it an understandable guide for beginners as well. 0201580497B04062001

"synopsis" may belong to another edition of this title.

From the Inside Flap:

The first edition of this book was written in 1984 during the early support program and before DB2 was generally available as a database management product. It was the first practical guide to design and development of application systems published in book form. The book is based on over 1400 pages of seminar material developed and presented by Gabrielle Wiorkowski to over 5000 students in 23 countries on 6 continents. The material is constantly updated for each release/version (plus current PTFs) of DB2. Experience, gained through application design and development, of new features and the input of over 5000 seminar attendees have been incorporated into the book. The professionals attending the seminars have requested repeatedly that the book contain more indepth coverage as do the seminars. This current third edition of the book is an attempt to satisfy those requests within the bounds of a single volume.

A DB2 professional stated in a presentation at Guide that DB2 is easy to use but easier to abuse. This edition of the book continues to cover the ease of use but has expanded coverage on performance issues in each chapter to avoid abuses. This indepth coverage of DB2 is for the experienced DB2 designers and developers as well as for the reader new to DB2. Because the features of DB2 are tightly interwoven, it is not possible to discuss a feature thoroughly without referring to related features that are discussed in other chapters. Therefore there are frequent references to the related features. Some chapters can be skipped by experienced DB2 professionals but are essential for the understanding of subsequent chapters for those new to DB2. For example, the chapters on concepts and components, normalization, and SQL data manipulation can be skipped by the experienced DB2 professional but are necessary for the new DB2 reader before reading the chapters on programming for performance, optimization, and explaining the access path chosen by the optimizer.

Numerous hints, tips, and guidelines on the design and development of high performing application systems are given throughout the book based on the authors' experience and the input of professional seminar attendees. In order to apply the proven techniques, it is necessary to understand DB2 processing to maximize performance so that the guidelines can be applied to your specific application system. There are several techniques that can be used to accomplish an objective depending on the characteristics of the data and how the data will be processed. These techniques are discussed along with their advantages and disadvantages to allow the reader to choose or tailor a technique to satisfy their specific requirements. Acknowledgments

We have been very fortunate to have leading DB2 experts as reviewers of the book. Marilyn Bohl, a leading authority on DB2 and relational database management systems, and Barbara von Halle, the co-author of the widely read Handbook of Relational Database Design, have taken the time from their busy schedules to review all three editions of the book. William Favero, Dale Hoyt, Sheryl Larsen, Chris Loosley, and Colin White have applied their indepth understanding of DB2 to the review process. Their many comments and suggestions have contributed significantly to the content of the book. We are very grateful for their valuable assistance and hours of work in assuring the accuracy and readability of the book. Thanks also to John Wiorkowski, who was particularly helpful in reviewing and helping to shape some of the book's more mathematically intense portions. We are also indebted to Chris Date for sharing his Suppliers, Parts, and Jobs tables, which are used in most of the book's examples, and for his advice and support during the project. Without Dr. E. F. Codd and Sharon Weinberg, this book--and for that matter DB2--would not exist. Dr. Codd is a grand person and has provided the theoretical foundation on which all relational database management systems are built. And finally, many thanks to the fine editorial and support staff at Addison-Wesley for their assistance in preparing this significantly revised and expanded third edition. Gabrielle Wiorkowski
David Kull
0201580497P04062001

From the Back Cover:

Highlights:


* Provides indepth and expanded coverage of performance.
* Provides hints, tips, and guidelines for the design and development of application systems.
* Conveys and understanding of SQL processing to maximize the performance so that the guidelines can be applied to your specific application system.
* Incorporates new features of Release 2.3 throughout the book.
* Contains a new chapter on program preparation and execution detailing how to use packages and plans, including fall back procedures.

This book is an excellent resource for professional database designers and developers. It is concise and easy to read--making it an understandable guide for beginners as well. 0201580497B04062001

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Gabrielle Wiorkowski
Published by Addison-Wesley Longman, Incorporated
ISBN 10: 0201507358 ISBN 13: 9780201507355
Used Paperback Quantity Available: 1
Seller:
ThriftBooks - Free State
(Halethorpe, MD, U.S.A.)
Rating
[?]

Book Description Addison-Wesley Longman, Incorporated. Paperback. Book Condition: Good. Book shows minor use. Cover and Binding have minimal wear, and the pages have only minimal creases. Bookseller Inventory # G0201507358I3N00

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 5.47
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Wiorkowski
Published by Longman Higher Education (1990)
ISBN 10: 0201507358 ISBN 13: 9780201507355
Used Quantity Available: 1
Seller:
Better World Books Ltd
(Dunfermline, United Kingdom)
Rating
[?]

Book Description Longman Higher Education, 1990. Book Condition: Very Good. 2nd. Ships from the UK. Former Library book. Great condition for a used book! Minimal wear. Bookseller Inventory # GRP91904830

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 1.00
Convert Currency

Add to Basket

Shipping: US$ 4.48
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

Wiorkowski
Published by Longman Higher Education (1990)
ISBN 10: 0201507358 ISBN 13: 9780201507355
Used Hardcover Quantity Available: 1
Seller:
Anybook Ltd.
(Lincoln, United Kingdom)
Rating
[?]

Book Description Longman Higher Education, 1990. Book Condition: Good. This is an ex-library book and may have the usual library/used-book markings inside.This book has hardback covers. In good all round condition. Dust Jacket in good condition. Bookseller Inventory # 4676670

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 1.00
Convert Currency

Add to Basket

Shipping: US$ 8.12
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Wiorkowski, Gabrielle; Kull, David
Published by Addison-Wesley (1990)
ISBN 10: 0201507358 ISBN 13: 9780201507355
Used Hardcover Quantity Available: 1
Seller:
George Cross Books
(Lexington, MA, U.S.A.)
Rating
[?]

Book Description Addison-Wesley, 1990. Hardcover. Second ition edition. Good/No Jacket (32666) . Hardcover, good condition, w. ltly rubbed brds, sme lt marks and spots. Sm scrape on r. Smwht slanted, ltly compressed sp. Ltly bumped bottom corners, v. ltly bumped top corners. Smwht tanned p. edges. Top corners cut from ffep, title p. A few ltly tanned p. edges. Clean, tight, unmarked. 461. Bookseller Inventory # 32666

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 13.00
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

5.

Wiorkowski, Gabrielle and David Kull
Published by Reading, MA addison-Wesley Publishing 1988. (1988)
ISBN 10: 0201507358 ISBN 13: 9780201507355
Used Hardcover Quantity Available: 1
Seller:
Joslu Enterprises
(Cypress, CA, U.S.A.)
Rating
[?]

Book Description Reading, MA addison-Wesley Publishing 1988., 1988. slight cover soiling, extremity wear, some underline/highlightng. hardback; ink notation ffep. Illustrated by figures. reprint edition. Bookseller Inventory # 005103

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 15.00
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

6.

Wiorkowski
Published by Longman Higher Education, US (1990)
ISBN 10: 0201507358 ISBN 13: 9780201507355
Used Hardcover Quantity Available: 1
Seller:
Robinson Street Books, IOBA
(Binghamton, NY, U.S.A.)
Rating
[?]

Book Description Longman Higher Education, US, 1990. Hardcover. Book Condition: Good. 0201507358 Good in very good little edge-nicked sunned dust jacket. Writing in ink and stamp on front free end paper. Second edition, later printing * Quality, Value, Experience. Media Shipped in New Boxes. Bookseller Inventory # WARE75KK4689

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 15.00
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

7.

Wiorkowski
Published by Longman Higher Education (1990)
ISBN 10: 0201507358 ISBN 13: 9780201507355
Used Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Longman Higher Education, 1990. Paperback. Book Condition: Used: Good. Bookseller Inventory # SONG0201507358

More Information About This Seller | Ask Bookseller a Question

Buy Used
US$ 25.71
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds