Web Database Development for Windows Platforms

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.

1. Internet Databases: A Natural Evolution.


From the Desktop to the Webtop. The Rise of the Wintel Platform on the Web. Developmental Directions. Static Content Prevails. Technology Directions. Database Connectivity Standards. Java-Based Development. Scripting Language-Based Development. Back-end Relational Databases. The Standalone Web Database. Organization-Wide LAN/WAN. Interfacing to Legacy Hardware and Database Systems. Back-end Focus for This Book. Revamped Back-end Licensing Fees. Object and Object/Relational Databases. Intranets and Extranets. Databases: Basis for Web Commerce. Extraordinary Opportunity for Software Developers. Tools for Web Database Developers. Sample Database-Enabled Web Sites. Infinite Humanity. The Real Estate Book. UCLA Store Bookseller E-Commerce Site. Summary.



2. Web Database Technical Overview.


HyperText Transfer Protocol (HTTP). Common Gateway Interface. Generic Database Scenario. Visual Basic/CGI Interface. Database Design. Stored Procedures. HTML. Visual Basic CGI Application Code. CGI Database Scripting. HTML Forms. SQL. ODBC. Database Markup Language. Server API. Server API Overview. ISAPI. Internet Database Connector. Server Side Includes (SSI). Technical Components. Config Command. Include Command. Echo Command. Fsize Command. Flastmod Command. Exec Command. Database SSI Extensions. SQL SELECT. SQL INSERT. Java Database Connections. JDBC. DAO. Active Server. ActiveX Data Objects. Summary.



3. Hardware/Software Requirements.


Choosing a Hosting Solution. Hosted Web Site. Co-Located Web Servers. In-House Web Servers. Scalability. Web Server Hardware Platform. Intel Processor Based. High-Speed CPU Cache. Internal Cache. External Cache. Pipeline Burst Cache. Write-Back L1 and L2 Cache. Conventional RAM Requirements. Hard Disk. CD-ROM. Backup Methods. Power Considerations. Internet Connection and Communication Hardware. Point-to-Point. Frame Relay. ISDN. Dedicated SLIP/PPP. DSL. Router. CSU/DSU. Hub. Bandwidth Requirements Analysis. TCP/IP Intranet Test Case. Windows NT 4.0 Server. CPU Performance. Memory Tuning. Virtual Memory. Hard Disk Fragmentation. Monitoring Site Connections. Web Server Software. Microsoft Internet Information Server (IIS). SQL Server for NT. Database Capacity. Performance Tuning. RAM Considerations. Cache Memory. SQL Server Performance Monitor. SQL Trace. Stored Procedures. Temporary Database Size. Query Optimization Analysis. Web Application Analysis. Summary.



4. Building Webtop Databases.


Internet Database Connector (IDC). IDC Architecture. Creating ODBC DSNs. IDC Processing Walk-Through. Database Design. Choosing a Design Tool. Building Database Schemas. Creating an ODBC Data Source. Converting Access Objects. Getting the Most from Stored Procedures. Query Design. Designing Queries. Internet Database Connector (.idc) Files. Retrieving Result-Sets. HTML Extension (.htx) Files. Detail Sections. Conditional Logic. Built-In Variables. Parameters from IDC Files. HTTP Variables. IDC Development Techniques. Multiple Select List Box. Parameter Passing. Counting. Adding Records. Drill Down. Batch and Multiple Queries. IDC-to-ASP Converter. SQL Server Web Assistant. Build a Query from the Database Hierarchy. Enter a Query as Free-Form Text. Use a Query in a Stored Procedure. Scheduling Options. File Options. Formatting Options. Summary.



5. Database Connections with Visual J++.


Visual J++ Overview. WFC. DHTML. RAD Components. Target Audience. Windows Foundation Classes (WFC). WFW and COM. WFC Classes. GUI Classes. System Classes. Data Classes. DHTML Classes. Security. WFC Designer. Data Access. DataSource Control. DataBinder Control. DataNavigator Control. DataGrid Control. Universal Data Access. ADO for Java. Connection Object. Command Object. Parameter Object. Recordset Object. Field Object. Error Object. Collections. Parameters. Fields. Errors. Remoteable Recordsets. JADO Event Handling. Data Form Wizard. Data Form Wizard-Generated Code. Starting and Stopping an Application. Basic Application Structure. Handling Events. Visual Database Tools. Summary.



6. JDBC.


JDBC Fundamentals. General Design Goals. Distributed Models. The JDBC Vision. The ODBC Influence. JDBC Technical Goals. Primary JDBC Classes. DriverManager Class. Database URLs. Connection Class. Statement Class. PreparedStatement Class. CallableStatement Class. ResultSet Class. Using Database MetaData. ResultSetMetaData Class. DatabaseMetaData Class. Implementing a Driver. Security Model. Coding Examples. A SELECT Example. UPDATE Example. Summary.



7. Active Server and ADO.


ActiveX Scripting. Active Server Framework. ActiveX. Active Desktop. Active Server. Active Server Pages. Server-Side Includes. Active Server Objects. Application Object. Session Object. Request Object. Response Object. Server Object. Active Server Components. Advertisement Rotator Component. Browser Capabilities Component. Content Linking Component. Database Access Component. File Access Component. Text Stream Component. Creating Server Components with VB. Visual InterDev Data Form Wizard. TableNameAction.asp. TableNameForm.asp. TableNameList.asp. COM/DCOM. Introduction to OLE DB. Components of an OLE DB Application. ActiveX Data Objects (ADO). ADO Features. ADO Integration. ADO Objects. Connection Object. Methods. Properties. Recordset Object. Methods. Properties. Command Object. Methods. Properties. Field Object. Methods. Properties. Parameter Objects. Methods. Properties. ADO Error Handling. Errors Collection. Error Object. Connection Pooling with ADO. ADO Examples. Using Connection, Command, and Recordset Objects. Open a Recordset. Invoke a Stored Procedure. Perform a Batch Update. Summary.



8. Visual InterDev.


Basic Architecture. Web Projects. Creating and Editing a Web Project. HTML Files. Global File. Graphic Image and Multimedia Files. Active Server Pages. ActiveX Layout Files. Workspaces. Establishing Database Connectivity. Database Project. Database Wizards. Database Connection Wizard. New Database Wizard. Data Form Wizard. Data Range Builder Wizard. Inserting a New Database Item. Design-Time ActiveX Controls. Data Command Design-Time Control. Inserting a Data Command Control. Configuring a Data Command Control. Creating a Data Command Control Using Drag and Drop. Data Range Header and Footer Design-Time Controls. Visual Data Tools. Data View. Table Structure Maintenance. Table Properties Dialog. Table Properties. Relationship Properties. Index/Keys Properties. Views. Stored Procedures. Database Designer. Database Diagrams. Creating a Database Diagram. Table Structure Changes. Query Designer. Diagram Pane. Query Designer Toolbar. Grid Pane. SQL Pane. Executing the Query. Stored Procedures. Stored Procedure Editor. Executing Stored Procedures. ODBC Script Files. Scalability. Summary.



9. Publishing Desktop Databases.


Microsoft Access as an ODBC Data Source. Using an ODBC Data Source. Inefficiencies Using Desktop ODBC Data Sources. Microsoft Access 97 Upsizing Tools. Upsizing Wizard. Create New SQL Server Database. Selecting Tables and Upsizing Options. Completing the Upsizing Process. Special Considerations for Upsized Data. SQL Server Browser. Static Database Content Web Page Generation. Microsoft Access 97. General Web Facilities. Hyperlink Data Type. Publish to the Web Wizard. Designing Your Own Publish to the Web Wizard Templates. The WebBrowser Control. VBA Programming with Web-Enabled Macro Actions. Custom HTML Generation Using VBA for Access. A Static Database Content Desktop Implementation Case Study. Summary.



10. Web Database Case Study.


A CGI Scripting Solution with ODBC. Using the Chinese Yellow Pages. Browse Mode. Search Mode. Hardware Implementation. System Software Implementation. Application Software Implementation. Database Design. Cold Fusion Implementation. Browse Mode Implementation. Search Mode Implementation. Summary.



Index.