Database Magic with Ken North

Be the first to 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 ...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Hardcover)
  • All (7) from $15.59   
  • New (2) from $55.09   
  • Used (5) from $15.59   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$55.09
Books Revisited
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$65.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

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 Show Less

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.
Read More Show Less

Product Details

  • ISBN-13: 9780136471998
  • Publisher: Prentice Hall Professional Technical Reference
  • Publication date: 12/9/1998
  • Edition number: 1
  • 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 Show Less

Table of Contents

Preface
Ch. 1 In Search of Database Magic 1
Ch. 2 ORM, Data Models, and InfoModeler 25
Ch. 3 Using Servers: Rules and Logic in the Database 49
Ch. 4 Java in the Database? Objects in the Middle Tier? 85
Ch. 5 Using Sybase 115
Ch. 6 Using INFORMIX 155
Ch. 7 Using IBM DB2 197
Ch. 8 Using Microsoft SQL Server 257
Ch. 9 ODBC, JDBC, and the Quest for a Black Box 319
Ch. 10 Understanding and Using ODBC 331
Ch. 11 Using Interoperable SQL 375
Ch. 12 Component Data Access with OLE DB 397
App. A ODBC Drivers, Servers, and Vendors 413
App. B JDBC Drivers, Servers, and Vendors 427
App. C OLE DB Providers, Servers, and Vendors 433
App. D: Glossary 437
App. E: Bibliography 441
App. F Getting the Example Programs and Scripts 447
Index 449
Read More Show Less

Preface

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 PrenticeHallftp 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 Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)