Cover image for Web database development for Windows platforms
Title:
Web database development for Windows platforms
Author:
Gutierrez, Dan D.
Personal Author:
Publication Information:
Upper Saddle River, NJ : Prentice Hall, [2000]

©2000
Physical Description:
xx, 475 pages : illustrations ; 24 cm.
General Note:
Includes index.
Language:
English
ISBN:
9780130139856
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D26 G88 2000 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

* Planning for appropriate performance, scalability, and reliability * ADO, OLE DB, ODBC, JDBC, and ISAPI * Making the most of Active Server Pages * Detailed SQL Server and Microsoft Access coverage * Includes a complete Web database case study Building Web databases with Microsoft technologies - start to finish This is the first complete sourcebook for anyone who wants to deploy Web databases using Microsoft technologies Web Database Development for Windows Platforms introduces every important Microsoft technology associated with Web/intranet database development, helping you choose the right options, then walking you through deployment step by step. Youll learn how to plan your database for appropriate performance, scalability, and reliability; how to make the most of Active Server Pages and ActiveX(r) Data Objects; and more. The book contains detailed coverage of powerful shortcuts such as the Internet Database Connector, IDC-to-ASP Converter, SQL Server Web Publisher Wizard, and more. Discover the best ways to build database connections with Visual J++ and the Windows Foundation Classes; and how to make the most of JDBC. Theres also a full chapter on publishing databases wi


Author Notes

Dan Gutierrez is CEO of Amulet Development Corp., a Los Angeles-based Web software development firm specializing in database-enabled Web sites and E-commerce solutions. He teaches database and Internet courses for UCLA Extension, and is Technical Editor for E-Business Advisor Magazine.


Table of Contents

Prefacep. xviii
Why This Book?p. xviii
Who Should Read This Book?p. xviii
How to Read This Bookp. xix
How This Book Is Organizedp. xix
A Goal for the Readerp. xx
1 Internet Databases: A Natural Evolutionp. 1
From the Desktop to the Webtopp. 3
The Rise of the Wintel Platform on the Webp. 4
Developmental Directionsp. 5
Static Content Prevailsp. 5
Technology Directionsp. 6
Database Connectivity Standardsp. 8
Java-Based Developmentp. 9
Scripting Language-Based Developmentp. 10
Back-end Relational Databasesp. 10
The Standalone Web Databasep. 11
Organization-Wide LAN/WANp. 11
Interfacing to Legacy Hardware and Database Systemsp. 12
Back-end Focus for This Bookp. 12
Revamped Back-end Licensing Feesp. 13
Object and Object/Relational Databasesp. 13
Intranets and Extranetsp. 13
Databases: Basis for Web Commercep. 14
Extraordinary Opportunity for Software Developersp. 15
Tools for Web Database Developersp. 15
Sample Database-Enabled Web Sitesp. 16
Infinite Humanityp. 17
The Real Estate Bookp. 19
UCLA Store Bookseller E-Commerce Sitep. 22
Summaryp. 26
2 Web Database Technical Overviewp. 27
HyperText Transfer Protocol (HTTP)p. 28
Common Gateway Interfacep. 30
Generic Database Scenariop. 34
Visual Basic/CGI Interfacep. 35
Database Designp. 36
Stored Proceduresp. 37
HTMLp. 38
Visual Basic CGI Application Codep. 39
CGI Database Scriptingp. 48
HTML Formsp. 50
SQLp. 50
ODBCp. 51
Database Markup Languagep. 51
Server APIp. 51
Server API Overviewp. 52
ISAPIp. 53
Internet Database Connectorp. 55
Server Side Includes (SSI)p. 57
Technical Componentsp. 58
Config Commandp. 59
Include Commandp. 60
Echo Commandp. 60
Fsize Commandp. 60
Flastmod Commandp. 61
Exec Commandp. 61
Database SSI Extensionsp. 61
SQL Selectp. 62
SQL Insertp. 63
Java Database Connectionsp. 66
JDBCp. 67
DAOp. 67
Active Serverp. 68
ActiveX Data Objectsp. 69
Summaryp. 70
3 Hardware/Software Requirementsp. 71
Choosing a Hosting Solutionp. 72
Hosted Web Sitep. 72
Co-Located Web Serversp. 73
In-House Web Serversp. 74
Scalabilityp. 75
Web Server Hardware Platformp. 75
Intel Processor Basedp. 75
High-Speed CPU Cachep. 76
Internal Cachep. 77
External Cachep. 77
Pipeline Burst Cachep. 77
Write-Back L1 and L2 Cachep. 78
Conventional RAM Requirementsp. 78
Hard Diskp. 78
CD-ROMp. 79
Backup Methodsp. 79
Power Considerationsp. 80
Internet Connection and Communication Hardwarep. 80
Point-to-Pointp. 81
Frame Relayp. 81
ISDNp. 82
Dedicated SLIP/PPPp. 82
DSLp. 82
Routerp. 83
CSU/DSUp. 83
Hubp. 84
Bandwidth Requirements Analysisp. 85
TCP/IP Intranet Test Casep. 85
Windows NT 4.0 Serverp. 86
CPU Performancep. 87
Memory Tuningp. 89
Virtual Memoryp. 89
Hard Disk Fragmentationp. 91
Monitoring Site Connectionsp. 91
Web Server Softwarep. 91
Microsoft Internet Information Server (IIS)p. 92
SQL Server for NTp. 95
Database Capacityp. 96
Performance Tuningp. 96
RAM Considerationsp. 97
Cache Memoryp. 98
SQL Server Performance Monitorp. 99
SQL Tracep. 100
Stored Proceduresp. 100
Temporary Database Sizep. 101
Query Optimization Analysisp. 102
Web Application Analysisp. 104
Summaryp. 105
4 Building Webtop Databasesp. 107
Internet Database Connector (IDC)p. 108
IDC Architecturep. 109
Creating ODBC DSNsp. 111
IDC Processing Walk-Throughp. 111
Database Designp. 115
Choosing a Design Toolp. 115
Building Database Schemasp. 116
Creating an ODBC Data Sourcep. 117
Converting Access Objectsp. 117
Getting the Most from Stored Proceduresp. 122
Query Designp. 122
Designing Queriesp. 122
Internet Database Connector (.idc) Filesp. 124
Retrieving Result-Setsp. 126
HTML Extension (.htx) Filesp. 126
Detail Sectionsp. 126
Conditional Logicp. 126
Built-In Variablesp. 127
Parameters from IDC Filesp. 128
HTTP Variablesp. 128
IDC Development Techniquesp. 130
Multiple Select List Boxp. 130
Parameter Passingp. 131
Countingp. 135
Adding Recordsp. 137
Drill Downp. 139
Batch and Multiple Queriesp. 144
IDC-to-ASP Converterp. 144
SQL Server Web Assistantp. 145
Build a Query from the Database Hierarchyp. 145
Enter a Query as Free-Form Textp. 146
Use a Query in a Stored Procedurep. 146
Scheduling Optionsp. 148
File Optionsp. 149
Formatting Optionsp. 149
Summaryp. 151
5 Database Connections with Visual J++p. 153
Visual J++ Overviewp. 154
WFCp. 154
DHTMLp. 154
RAD Componentsp. 155
Target Audiencep. 155
Windows Foundation Classes (WFC)p. 156
WFW and COMp. 157
WFC Classesp. 157
GUI Classesp. 159
System Classesp. 159
Data Classesp. 159
DHTML Classesp. 159
Securityp. 162
WFC Designerp. 163
Data Accessp. 163
DataSource Controlp. 164
DataBinder Controlp. 165
DataNavigator Controlp. 168
DataGrid Controlp. 169
Universal Data Accessp. 170
ADO for Javap. 170
Connection Objectp. 172
Command Objectp. 174
Parameter Objectp. 176
Recordset Objectp. 178
Field Objectp. 182
Error Objectp. 183
Collectionsp. 184
Parametersp. 184
Fieldsp. 185
Errorsp. 185
Remoteable Recordsetsp. 185
JADO Event Handlingp. 186
Data Form Wizardp. 187
Data Form Wizard-Generated Codep. 196
Starting and Stopping an Applicationp. 206
Basic Application Structurep. 206
Handling Eventsp. 207
Visual Database Toolsp. 208
Summaryp. 209
6 JDBCp. 211
JDBC Fundamentalsp. 212
General Design Goalsp. 214
Distributed Modelsp. 215
The JDBC Visionp. 215
The ODBC Influencep. 217
JDBC Technical Goalsp. 218
Primary JDBC Classesp. 219
DriverManager Classp. 221
Database URLsp. 222
Connection Classp. 223
Statement Classp. 226
PreparedStatement Classp. 228
CallableStatement Classp. 230
ResultSet Classp. 233
Using Database MetaDatap. 237
ResultSetMetaData Classp. 237
DatabaseMetaData Classp. 239
Implementing a Driverp. 247
Security Modelp. 248
Coding Examplesp. 249
A Select Examplep. 249
Update Examplep. 251
Summaryp. 251
7 Active Server and ADOp. 253
ActiveX Scriptingp. 253
Active Server Frameworkp. 255
ActiveXp. 256
Active Desktopp. 256
Active Serverp. 256
Active Server Pagesp. 257
Server-Side Includesp. 258
Active Server Objectsp. 259
Application Objectp. 260
Session Objectp. 262
Request Objectp. 264
Response Objectp. 272
Server Objectp. 275
Active Server Componentsp. 276
Advertisement Rotator Componentp. 278
Browser Capabilities Componentp. 279
Content Linking Componentp. 280
Database Access Componentp. 281
File Access Componentp. 282
Text Stream Componentp. 283
Creating Server Components with VBp. 284
Visual InterDev Data Form Wizardp. 284
TableNameAction.aspp. 284
TableNameForm.aspp. 285
TableNameList.aspp. 285
COM/DCOMp. 285
Introduction to OLE DBp. 287
Components of an OLE DB Applicationp. 288
ActiveX Data Objects (ADO)p. 289
ADO Featuresp. 290
ADO Integrationp. 292
ADO Objectsp. 293
Connection Objectp. 296
Methodsp. 297
Propertiesp. 298
Recordset Objectp. 298
Methodsp. 301
Propertiesp. 302
Command Objectp. 302
Methodsp. 304
Propertiesp. 304
Field Objectp. 306
Methodsp. 306
Propertiesp. 306
Parameter Objectsp. 307
Methodsp. 308
Propertiesp. 308
ADO Error Handlingp. 309
Errors Collectionp. 310
Error Objectp. 310
Connection Pooling with ADOp. 311
ADO Examplesp. 312
Using Connection, Command, and Recordset Objectsp. 312
Open a Recordsetp. 313
Invoke a Stored Procedurep. 314
Perform a Batch Updatep. 316
Summaryp. 317
8 Visual InterDevp. 319
Basic Architecturep. 321
Web Projectsp. 321
Creating and Editing a Web Projectp. 321
HTML Filesp. 322
Global Filep. 322
Graphic Image and Multimedia Filesp. 322
Active Server Pagesp. 323
ActiveX Layout Filesp. 323
Workspacesp. 323
Establishing Database Connectivityp. 323
Database Projectp. 324
Database Wizardsp. 326
Database Connection Wizardp. 326
New Database Wizardp. 328
Data Form Wizardp. 328
Data Range Builder Wizardp. 334
Inserting a New Database Itemp. 336
Design-Time ActiveX Controlsp. 338
Data Command Design-Time Controlp. 339
Inserting a Data Command Controlp. 340
Configuring a Data Command Controlp. 341
Creating a Data Command Control Using Drag and Dropp. 345
Data Range Header and Footer Design-Time Controlsp. 345
Visual Data Toolsp. 355
Data Viewp. 356
Table Structure Maintenancep. 357
Table Properties Dialogp. 359
Table Propertiesp. 359
Relationship Propertiesp. 361
Index/Keys Propertiesp. 361
Viewsp. 363
Stored Proceduresp. 364
Database Designerp. 364
Database Diagramsp. 365
Creating a Database Diagramp. 366
Table Structure Changesp. 367
Query Designerp. 370
Diagram Panep. 372
Query Designer Toolbarp. 374
Grid Panep. 375
SQL Panep. 376
Executing the Queryp. 376
Stored Proceduresp. 376
Stored Procedure Editorp. 377
Executing Stored Proceduresp. 378
ODBC Script Filesp. 379
Scalabilityp. 380
Summaryp. 381
9 Publishing Desktop Databasesp. 383
Microsoft Access as an ODBC Data Sourcep. 384
Using an ODBC Data Sourcep. 389
Inefficiencies Using Desktop ODBC Data Sourcesp. 390
Microsoft Access 97 Upsizing Toolsp. 392
Upsizing Wizardp. 392
Create New SQL Server Databasep. 393
Selecting Tables and Upsizing Optionsp. 395
Completing the Upsizing Processp. 397
Special Considerations for Upsized Datap. 398
SQL Server Browserp. 399
Static Database Content Web Page Generationp. 400
Microsoft Access 97p. 401
General Web Facilitiesp. 402
Hyperlink Data Typep. 404
Publish to the Web Wizardp. 405
Designing Your Own Publish to the Web Wizard Templatesp. 433
The WebBrowser Controlp. 434
VBA Programming with Web-Enabled Macro Actionsp. 435
Custom HTML Generation Using VBA for Accessp. 436
A Static Database Content Desktop Implementation Case Studyp. 438
Summaryp. 441
10 Web Database Case Studyp. 443
A CGI Scripting Solution with ODBCp. 443
Using the Chinese Yellow Pagesp. 445
Browse Modep. 445
Search Modep. 448
Hardware Implementationp. 450
System Software Implementationp. 451
Application Software Implementationp. 451
Database Designp. 452
Cold Fusion Implementationp. 454
Browse Mode Implementationp. 457
Search Mode Implementationp. 465
Summaryp. 470
Indexp. 471

Google Preview