Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

Introduction to Databases
  • Designing Databases 1Databases 
  • Handling Many-To-Many Relationships 9
  • Managing Complexity, Rule 1: Eliminate Repeating Fields 21Fields 
  • Managing Complexity, Rule 2: Eliminate Redundant Data 29Data 
  • Managing Complexity, Rule 3: Eliminate Columns That Don’t Belong 39Belong 
  • Managing Complexity, Rule 4: Isolate Independent Multiple Relationships 45Relationships 
  • Managing Complexity, Rule 5: Isolate Semantically Related Multiple Relationships 49Relationships 
  • Displaying Normalized Data 55Data 
  • Displaying Many-To-Many Relationships 67
  • True Confessions: A Tale of Two Users 85
Using Topspeed Files
  • Using Dynamic Indexes With TPS Files 91
  • Using The TPS ODBC Driver 97
  • Reading Tables With ADO 103
  • Accessing TPS Files Via ASP 109
  • Using Example Files With TPSFix 117
  • Topspeed Driver Error Codes 119
  • Troubleshooting TPS File Corruption 125
  • Resolving Network And Other File Problems 129
General SQL
  • An Introduction To SQL 141
  • Getting Into SQL On The Cheap 167
  • How To Convert Your Database To SQL 175
  • Converting TPS To MS-SQL 183
  • Avoid My SQL Mistakes! 197
  • SQL Data Types Comparison 201
  • The SQL Answer Cowboy 209
Open Source SQL
  • Using Clarion With MySQL 221
  • MySQL/MyODBC Notes 241
  • MySQL: InnoDB Tables And Transactions 247
  • Large Table Performance in MySQL 265
  • Getting Started With PostgreSQL 273
Oracle
  • Referential Integrity In Oracle 295
  • AutoNumbering In Oracle 299
  • Transactions In Oracle 305

MS SQL

  • Migrating The Inventory Application To SQL Server 317
  • Using SQL Server’s Data Transformation Services 341
  • Converting Data With Linked Servers 357
  • Converting The Inventory Example - Calling Stored Procedures 371
  • SQL Identity: Another Approach 399
  • Creating Utilities For MS SQL 2000 405
  • Generating MS SQL Server Side Triggers 415
  • Date Filtering with MS SQL 429
Book Reviews
  • Book Review: PostgreSQL Developer’s Handbook 435
  • Book Review: SQL Tuning 437
  • Book Review: SQL In A Nutshell 441
  • Book Review: Managing & Using MySQL 443
ABC Database Class Design Notes
  • Inside ABC: FieldPairsClass and BufferedPairsClass 447
  • Inside ABC: The FileManager 459
  • Inside ABC: The RelationManager 483
  • Inside ABC: The ViewManager 495
Database Tips & Techniques
  • Clarion File Access Basics 507
  • Managing Table Opens In ABC 517
  • Creating ODBC Data Sources At Runtime 527
  • Securing Remote Database Connections With SSH Tunneling 535
  • Using Client-Side Triggers In Clarion 6 543
  • Working With Control Files 547
  • Changing Dictionaries 563
  • Alias - Who Was That Masked File? 567
  • Propitious Memory Corruption 577
  • Detecting Duplicate Records 585
  • NAME() Comes Of Age 591
Appendices & Indexes
  • Appendix A: Getting Support 601
  • Appendix B: Related Articles 603
  • Author Index 605
  • Index 609