Database Magic with Ken North

Database Magic with Ken North

by Ken North
     
 

The complete, expert guide to database extensions and server-side development in a multitier database environment! In Database Magic with Ken North, a leading database consultant presents powerful techniques for maximizing the performance and scalability of today's distributed, multitier database applications. You'll learn the best ways to partition… See more details below

Overview

The complete, expert guide to database extensions and server-side development in a multitier database environment! In Database Magic with Ken North, a leading database consultant presents powerful techniques for maximizing the performance and scalability of today's distributed, multitier database applications. You'll learn the best ways to partition applications and distribute logic across client, middle and server tiers, and exploit the power of modern database servers. You will discover specific techniques for extending databases and programming servers for every leading database platform, including Oracle, Microsoft SQL Server, Sybase, Informix, and IBM DB2. Learn how to:

  • Develop a distributed computing strategy and roadmap.
  • Use stored procedures, triggers, constraints, and Java-enabled databases.
  • Leverage Windows and Java data to access today's Windows and Java technologies, including ODBCADO, OLE DB, and JDBC.
  • Use logic in the database and develop database extensions.
  • Model data with Object-Role Modeling (ORM).
  • Use stored procedure programming, triggers, and constraints.
  • Write code and SQL that is portable and interoperable across DBMS back-ends.
Ken North, the database columnist at contributing editor at Web Techniques and Dr. Dobb's Sourcebook Internet Magazines, introduces you to today's "new wave" of object-relational database servers from Informix, Oracle, and IBM. He covers database extenders such as Informix DataBlades and DB2 ExtendersOracle Data Cartridges - and demonstrates how to move logic into databases by using constraints, triggers, stored procedures and Java classes, as well as high-performance techniques for integrating da ta from multiple sources using Microsoft Universal Data Access or Sybase Adaptive Component Architecture. No explores data access and component integration technologies such as Microsoft Universal Data Access and Sybase Adaptive Component Architecture. No matter which platform you use, or what application you want to build, these technologies give you awesome power - and Ken North will help you use all of it. You get a CD-ROM packed with SQL scripts and example databases for Sybase, Informix, Microsoft SQL Server, and IBM DB2 Universal Database, plus a complete data model for Visio InfoModeler users, and every C, C++ and Java source code example in the book!

Read More

Editorial Reviews

Emily Kaplan
This highly readable book is "not a primer that teaches the fundamentals" but is intended for those who "have some experience with software and databases." However, North still takes the time to spell out every acronym, provides a decent glossary and includes URLs and contact information for every vendor listed in his appendixes.
— TechWeek
Michael Yocca
If you are involved in distributed technology project decision making, you will enjoy this book.
— The Data Administration Newsletter
Suzanne A. Smith
A good feature of the book is that it is not based on any individual platform or tool, so anyone working with databases will find the information useful....Database Magic with Ken North is a good book for developers whose job responsibilities are changing to include more database design work.
— San Diego Union-Tribune
Booknews
A database consultant presents powerful techniques for maximizing the performance and scalability of today's distributed, multitier database applications. He explains how to partition applications and distribute logic across client, middle, and server tiers, and how to exploit the power of modern database servers. He gives techniques for extending databases and programming servers for every leading database platform, including Microsoft SQL Server, Sybase, Informix, and IBM DB2. Assumes some experience with software and databases. Annotation c. by Book News, Inc., Portland, Or.

Product Details

ISBN-13:
9780136471998
Publisher:
Prentice Hall Professional Technical Reference
Publication date:
12/09/1998
Pages:
465
Product dimensions:
6.95(w) x 9.16(h) x 1.27(d)

Read an Excerpt

PREFACE: Development strategies continue to evolve away from monolithic architectures to software built with components. Today's database developer faces issues of performance and scalability that are putting a premium on partitioning applications and distributing logic across clients and servers. Component technologies and distributed computing are gaining mindshare, but the role of the database is not diminished. Active databases can store logic and enforce rules in order to maintain data integrity. The active database model has been used successfully for mainframe, PC, and client-server computing, and we can expect it to be successful with future computing paradigms.

There is a cornucopia of software solutions for developers who build databases and write database programs. Many of these solutions provide component-based development and are capable of crafting client-side or server-side software. Database developer tools typically recognize the power of modern databases and enable developers to exploit the database as an enforcer of data integrity. Because that is likely to be true in the future, it is to your advantage to understand how to use database technology when building future generations of software. This book focuses on the capabilities of active databases and SQL DBMS products. It discusses distributed processing techniques that rely on programmable servers and logic in the database.

Before delving into details about using SQL, multidatabase APIs, and specific DBMS products, this book explores conceptual and logical data modeling. To get you started in an exploration of servers from Informix, Sybase, Oracle, IBM, and Microsoft, the Prentice Hallftp site includes SQL scripts for each of the servers discussed here. The site also includes example programs and a data model for generating databases to use with the examples.

Who Should Read This Book?
Read this book if you:

  • Are putting databases on the Web or your organization's intranet or extranet
  • Are interested in client-server and multitier applications using SQL databases
  • Want to understand active databases and the database as a rules enforcer
  • Are interested in server programming and logic in the database
  • Want to learn more about data modeling for creating robust databases
  • Require more information about standards-based and component-based data access
  • Need solutions for making databases available to browsers and online users
  • Want to learn more about extending servers used by SQL and object-relational DBMS

* Note: Throughout this book, I assume you have some experience with software and databases. This book is not a primer that teaches the fundamentals of programming.

How This Book is Organized
This book starts with an introductory chapter. The following chapter explains data modeling and develops an example database used by subsequent chapters of the book. Following the discussion of data modeling, there are chapters that explore database application architecture and active database technology. Next, there are chapters that explore database development for specific database management systems (DBMS) from Sybase, Informix, Oracle, Microsoft, and IBM. After the chapters about database servers, there are chapters that explain multidatabase programming techniques and standard programming interfaces (ODBC and JDBC). The concluding chapters explain interoperable SQL and programming with components (OLE DB).

This book includes appendixes that provide vendor information about ODBC drivers, JDBC drivers, and OLE DB providers. Appendix D is a glossary of terms. The book concludes with an index.

Conventions Used in This Book
SQL keywords, and the text of programs and scripts, are printed in a code font.
Note: This is used for emphasis and providing supplemental information.
Tip: This is used to highlight tips.

Acknowledgments
The production of this book involved the cooperation of a number of individuals. My gratitude and best wishes go out to the many persons who assisted me in the completion of this book. Mark Taub and Ralph Moore were instrumental in the development of this book. Kyle Geiger was a major player in the development of standards and software technologies discussed in this book, and he generously provided a technical review. Many thanks also to technical reviewers Joe Celko and David Linthicum.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >