| |
| |
| |
| Planning | |
| |
| |
| |
| The Web Connection | |
| |
| |
| Internet Background | |
| |
| |
| A Chronological History of the Internet | |
| |
| |
| The Internet Today | |
| |
| |
| What Is the Web? What Are Intranets? What Is a Web Database and Why Have One? Intranet Database Application Benefits | |
| |
| |
| Advantages of Web Database Applications for the User | |
| |
| |
| Moving On | |
| |
| |
| |
| Web Commerce | |
| |
| |
| Today's Competitive Business Environment | |
| |
| |
| Why Do Business on the Web? The Role of Databases in Web Applications | |
| |
| |
| Moving On | |
| |
| |
| |
| Choosing a Programming Language | |
| |
| |
| Which Language to Use? Microsoft Access | |
| |
| |
| |
| Useful MS Access URLs C | |
| |
| |
| Shell Script | |
| |
| |
| Visual Basic | |
| |
| |
| PowerBuilder | |
| |
| |
| Visual Basic Script | |
| |
| |
| COBOL | |
| |
| |
| Moving On | |
| |
| |
| |
| Overview of Java and JavaScript | |
| |
| |
| Introduction to Java | |
| |
| |
| Benefits of Java | |
| |
| |
| Java and Object-Orientation | |
| |
| |
| The Java/Web Concept | |
| |
| |
| Is It Java or Coffee? Who Owns Java? Introduction to JavaScript | |
| |
| |
| Strengths and Weaknesses of JavaScript | |
| |
| |
| Moving On | |
| |
| |
| |
| Application Development Suites | |
| |
| |
| 4W Publisher and 4W Publisher Pro | |
| |
| |
| A-XOrion Web Database Server | |
| |
| |
| Amazon | |
| |
| |
| Autobahn | |
| |
| |
| Centura Web Data Publisher | |
| |
| |
| DbWeb | |
| |
| |
| Delphi | |
| |
| |
| DynaWeb | |
| |
| |
| Edify Electronic Workforce | |
| |
| |
| FoxWeb | |
| |
| |
| HAHTsite IDE | |
| |
| |
| IQ/Live Web | |
| |
| |
| Krakatoa | |
| |
| |
| LivePAGE WebMaster | |
| |
| |
| LiveWire and LiveWire Pro | |
| |
| |
| Microsoft FrontPage | |
| |
| |
| |
| Personal Web Site (PWS) Toolbox | |
| |
| |
| PowerBuilder 5.0 | |
| |
| |
| Sapphire/Web | |
| |
| |
| SiteBase | |
| |
| |
| Software Engine | |
| |
| |
| Tango | |
| |
| |
| WebHub | |
| |
| |
| Webinator | |
| |
| |
| WebObjects | |
| |
| |
| Moving On | |
| |
| |
| |
| Overview of HTML | |
| |
| |
| Introduction to HTML | |
| |
| |
| Structure of HTML | |
| |
| |
| Advanced HTML Topics | |
| |
| |
| Good HTML Practices | |
| |
| |
| The Future of HTML | |
| |
| |
| Moving On | |
| |
| |
| |
| Overview of CGI | |
| |
| |
| CGI Introduction | |
| |
| |
| CGI Architecture | |
| |
| |
| CGI Generation of HTML | |
| |
| |
| CGI Programming Principles | |
| |
| |
| CGI Program Architectures | |
| |
| |
| Moving On | |
| |
| |
| |
| Internet Database Design | |
| |
| |
| |
| Web Application Design and Development | |
| |
| |
| Advantages of Deploying an Application on Your Chosen Platform | |
| |
| |
| The Design Process Described | |
| |
| |
| Web Database Application Components | |
| |
| |
| Web Application Design Primer | |
| |
| |
| Web Database Application Design | |
| |
| |
| Application Partitioning | |
| |
| |
| Application Partitioning Summary | |
| |
| |
| Moving On | |
| |
| |
| |
| Introduction to Access 97 | |
| |
| |
| What Is Access 97? What's New in Access 97? DDL, DML, and Access | |
| |
| |
| |
| Creating Databases and Database Objects | |
| |
| |
| Creating a Database | |
| |
| |
| Creating a Table | |
| |
| |
| Moving On | |
| |
| |
| |
| Access 97 Queries | |
| |
| |
| Introduction to Access 97 Queries | |
| |
| |
| Query Boundaries | |
| |
| |
| The QBE Grid | |
| |
| |
| Setting Query Properties | |
| |
| |
| Joining Tables in a Query | |
| |
| |
| Accessing External Data | |
| |
| |
| Moving On | |
| |
| |
| |
| Designing Advanced MS Access Queries | |
| |
| |
| SELECT Statement Clauses | |
| |
| |
| Parameter Queries | |
| |
| |
| Nested Queries | |
| |
| |
| Action Queries | |
| |
| |
| Optimizing Queries | |
| |
| |
| Analyzing Query Performance with Analyzer | |
| |
| |
| Moving On | |
| |
| |
| |
| Interfacing With The Internet User | |
| |
| |
| |
| HTML Forms and Database Access | |
| |
| |
| Objects | |
| |
| |
| Syntax of HTML Markups | |
| |
| |
| Overcoming Limitations of Placing Objects on HTML Forms | |
| |
| |
| Database Queries and HTML | |
| |
| |
| Database Updates and HTML | |
| |
| |
| Form Design Tips | |
| |
| |
| Moving On | |
| |
| |
| |
| Accessing Web Databases Using CGI Programs | |
| |
| |
| Basics of CGI Programs | |
| |
| |
| Reading User Data into CGI Programs | |
| |
| |
| Common Web Database Access Methods | |
| |
| |
| Why Use Custom CGI Programs for Database Access? Choosing a CGI Programming Language | |
| |
| |
| Accessing Web Databases Using CGI Programs | |
| |
| |
| Contents of the CGI Profile File | |
| |
| |
| Querying a Database | |
| |
| |
| Inserting Rows in a Database from a Web Application | |
| |
| |
| Deleting a Row from a Database Using a Web Application | |
| |
| |
| Updating a Database Row from a Web Application | |
| |
| |
| Providing Full Database Access from Your Web Application | |
| |
| |
| Moving On | |
| |
| |
| |
| MIME and Advanced Data Presentation | |
| |
| |
| What Is MIME? Uses for MIME on the Web | |
| |
| |
| MIME Types and Subtypes | |
| |
| |
| MIME Perspectives | |
| |
| |
| Moving On | |
| |
| |
| |
| Managing Web Database Access and the Application State | |
| |
| |
| What Is Application State? Using Forms to Maintain State | |
| |
| |
| Using Database Tables to Maintain State | |
| |
| |
| Using Persistent Cookies to Maintain State | |
| |
| |
| Moving On | |
| |
| |
| |
| Improving the Performance of Web Database Applications | |
| |
| |
| Application Optimization | |
| |
| |
| Access 97 Database Optimization | |
| |
| |
| Moving On | |
| |
| |
| |
| Advanced Topics In Internet Database Publishing | |
| |
| |
| |
| Migrating Data from Enterprise Data Stores to Server-Based Databases | |
| |
| |
| What to Migrate | |
| |
| |
| Replication | |
| |
| |
| Synchronization | |
| |
| |
| Backing Up a Web Database | |
| |
| |
| Restoring a Web Database | |
| |
| |
| Moving On | |
| |
| |
| |
| Using Firewalls and Security Components to Protect Your Data | |
| |
| |
| Access 97 Security | |
| |
| |
| Web Site Security The Problem | |
| |
| |
| Security of Your Web Server | |
| |
| |
| Secure Sockets Layer (SSL) | |
| |
| |
| CGI Security | |
| |
| |
| Firewalls | |
| |
| |
| Other Resources | |
| |
| |
| Moving On | |
| |
| |
| |
| Designing an Internet Course Delivery System | |
| |
| |
| Background | |
| |
| |
| XYZ's Existing Environment | |
| |
| |
| Project Analysis | |
| |
| |
| The Design Process Described | |
| |
| |
| The Development Process | |
| |
| |
| Implementation | |
| |
| |
| Post-Implementation Analysis | |
| |
| |
| Moving On | |
| |
| |
| |
| Building a Simple Class Registration System | |
| |
| |
| Application Configuration | |
| |
| |
| Web Database Internet Components in the Application | |
| |
| |
| Web Database Intranet Components in the Application | |
| |
| |
| Maintain Course Dates Page | |
| |
| |
| Moving On | |
| |
| |
| Appendices | |
| |
| |
| |
| CD-ROM Contents | |
| |
| |
| CD-ROM Contents | |
| |
| |
| Limits of Liability and Disclaimer of Warranty | |
| |
| |
| Technical Support | |
| |
| |
| |
| Frequently Asked Questions | |
| |
| |
| What Is the Internet? | |
| |
| |
| What Is the Web? | |
| |
| |
| What Are Intranets? | |
| |
| |
| What Is a Web Database and Why Have One? | |
| |
| |
| What Types of Databases Are Accessible in a Web Database Application? | |
| |
| |
| What Are the Advantages of Web Database Applications for the User? | |
| |
| |
| What Are the Advantages to a Company of Building a Web Database Application? | |
| |
| |
| What Is the Role of Databases in Web Applications? | |
| |
| |
| What Are the Components in a Web Database Application? | |
| |
| |
| What Should I Consider When Choosing a Programming Language? | |
| |
| |
| What Are Some of the Languages Available to Help Me Build a Web Database Application? | |
| |
| |
| What Are Web Database Application Development Suites? | |
| |
| |
| What Are Some of the Benefits and Limitations to HTML? | |
| |
| |
| What Is a CGI Program? | |
| |
| |
| How Does a CGI Program Fit in the Architecture of a Web Database Application? | |
| |
| |
| How Does Data Get Passed from an HTML Page to a CGI Program? | |
| |
| |
| Are There Any Programming Principles That I Should Be Aware of When Writing CGI Programs? | |
| |
| |
| Where Should Security Exist in a Web Database Application? | |
| |
| |
| What Are Some of the New Features in Access 97 That Are Specific to Web Database Applications? | |
| |
| |
| What Types of Join Relationships Are Recognized in Access 97? What Types of Objects Are Allowed on HTML Forms? | |
| |
| |
| How Can I Format and Submit a Database Query from within an HTML Page? | |
| |
| |
| Why Should You Use Custom CGI Programs for Database Access? | |
| |
| |
| What Is MIME? | |
| |
| |
| |
| WWW Database Development Resources | |
| |
| |
| Databases | |
| |
| |
| Other | |
| |
| |
| Programming Languages | |
| |
| |
| Reference Material | |
| |
| |
| Security | |
| |
| |
| Web Servers | |
| |
| |
| Index | |