Today's advanced Windows and Java-based database technologies give developers unprecedented flexibility and performance. In this book, one of the world's leading "gurus" on the subject shows developers how to leverage those technologies to build state-of-the-art multi-tier and Web applications -- and provides extensive source code to streamline the development process. Learn how to make the most of ActiveX and SQL; Active Server Pages, Visual Studio, ODBC, JDBC, DCOM, OLE DB and ActiveX data objects. You'll find detailed source code -- in Java, C++ and VB -- plus proven SQL scripts for Microsoft SQL Server, Oracle, Sybase, Informix, Access and IBM DB2. If you're facing unprecedented challenges of performance and scalabiilty, let Ken North show you how to use advanced Windows and Java database technologies to develop state-of-the-art solutions.
Book Description
Editorial Reviews
Amazon.com Review
Database Magic with Ken North is an insider's guide to the best of server-side design that will be almost indispensable to any database programmer or manager.
The first part of the book outlines the evolution of database technology over the last four decades, from mainframes to today's distributed computing. Ken North's impressive experience provides an invaluable perspective, as new systems are likely to leverage legacy mainframe data over the Internet. In this section, North also looks at a data-modeling tool, Visio's InfoModeler, which lets developers model database entities using natural language rules.
The main argument of this book is that server-side databases offer a better way to implement business rules and logic, with such features as triggers, stored procedures, and business objects written with SQL (or even Java). The author's tour of database servers covers Sybase, Informix, IBM DB2, and Microsoft SQL Server in excellent detail. (Oracle is also discussed, though not extensively.) North uses a phonetic text-retrieval system as an example to show how to use server-side processing within each product. Variants in SQL for each language-and other unique capabilities--are presented for each vendor's product.
Later sections of this book look at Open Database Connectivity (ODBC) in detail and include some invaluable administration tips for Windows. Material on Microsoft database technologies such as ADO (ActiveX Data Object standard) and OLE-DB (Object Linking and Embedding Database) rounds out the tour. --Richard Dragan
From the Inside Flap
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 Hall ftp 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.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
3 of 3 people found the following review helpful:
4.0 out of 5 stars
Ken's Onchoir Hits the Mark!,
By
This review is from: Database Magic With Ken North (Paperback)
In the successor to his excellent book, "WindowsMulti-DBMSProgramming", Ken North Introduces us to time-honored concepts ofwriting database applications in a fearless manner. Ken North, a seasoned veteran, has the guts to tackle all of these technologies in a single book: Data Modeling Tools, Database Server Features, Multi-tier c/s database applications using Java, and database app particulars for these databases: Sybase, Informix, DB2, MS SQL Server. He also brings clarity to the use of popular database APIs: ODBC and JDBC. Finally, he covers Interoperable SQL and the Component Access with OLE DB. If Ken's book could be faulted, it is because he didn't cover a great deal of specifics on Oracle or on ADO and ASP. And yet, he covers enough timeless aspects of building database applications in a client/server environment that no serious database application developer (at any level) should be without this book. It should noted that Ken North is ever active and moving ahead with technology almost as quickly as technology itself is improving. To this very day, he participates in and chairs technology panels at major computer industry conferences on such timely and important topics as JDBC and XML. In addition, he writes a monthly column in Web Techniques Magazine. In other words, Ken's contributions back to his chosen discipline are manifold and excellent as well. You might as well know that if Ken North said it, it is something that you can rely upon.
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
