SQL, SQL (Programming Language), Database Administration & Management

Database magic with Ken North

Name: Database magic with Ken North
Author: Ken North
ISBN: 9780136471998

by Ken North

Write a review

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!

Reviews

There are no reviews yet. Log in to write one.

Editorials

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.