| |
| |
| |
| Planning | |
| |
| |
| |
| The Web Connection | |
| |
| |
| Internet Background | |
| |
| |
| A Chronological History of the Internet | |
| |
| |
| The Internet Today | |
| |
| |
| What Is the Web? Intranets | |
| |
| |
| What Is a Web Database and Why Have One? What Is a Web Database? Intranet Database Application Benefits to the Organization | |
| |
| |
| Advantages of Web Database Applications for the User | |
| |
| |
| Moving On | |
| |
| |
| |
| Web Commerce | |
| |
| |
| Today's Competitive Business Environment | |
| |
| |
| Why Do Business on the Web? What to Consider When Creating Your Web Site | |
| |
| |
| The Role of Databases in Web Applications | |
| |
| |
| Moving On | |
| |
| |
| |
| Choosing a CGI Programming Language | |
| |
| |
| Which Language To Use? PERL | |
| |
| |
| PL/SQL | |
| |
| |
| Shell Scripts | |
| |
| |
| 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? Oracle's View of Java | |
| |
| |
| Introduction to JavaScript | |
| |
| |
| Uses for JavaScript | |
| |
| |
| Strengths and Weaknesses of JavaScript | |
| |
| |
| Moving On | |
| |
| |
| |
| Application Development Suites | |
| |
| |
| Amazon | |
| |
| |
| Autobahn | |
| |
| |
| Centura Web Data Publisher | |
| |
| |
| DbWeb | |
| |
| |
| Delphi | |
| |
| |
| DynaWeb | |
| |
| |
| Edify Electronic Workforce | |
| |
| |
| HAHTSite IDE | |
| |
| |
| IQ Live Web | |
| |
| |
| Krakatoa | |
| |
| |
| LivePAGE WebMaster | |
| |
| |
| LiveWire and LiveWire Pro | |
| |
| |
| Microsoft FrontPage | |
| |
| |
| 97 Oracle's Tools | |
| |
| |
| Oracle Designer/2000 | |
| |
| |
| Oracle Developer/2000 | |
| |
| |
| Oracle Power Objects | |
| |
| |
| Oracle Intranet Solutions | |
| |
| |
| Personal Web Site (PWS) Toolbox | |
| |
| |
| PowerBuilder 5.0 | |
| |
| |
| Sapphire/Web | |
| |
| |
| SiteBase | |
| |
| |
| 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 | |
| |
| |
| |
| Common Gateway Interface (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 | |
| |
| |
| Characteristics of a Web Database Application | |
| |
| |
| Keys to Successfully Implementing a System | |
| |
| |
| The Process | |
| |
| |
| A Wish List for Development Tools | |
| |
| |
| The Design Process Described | |
| |
| |
| Web Database Application Components | |
| |
| |
| Web Application Design Primer | |
| |
| |
| Web Database Application Design | |
| |
| |
| Application Partitioning | |
| |
| |
| Moving On | |
| |
| |
| |
| Introduction to Oracle | |
| |
| |
| What Is Oracle? What Are the Flavors of Oracle? Useful Oracle URLs | |
| |
| |
| Oracle Enterprise Manager | |
| |
| |
| Moving On | |
| |
| |
| |
| Using SQL*Plus | |
| |
| |
| What Is SQL*Plus? Getting Started | |
| |
| |
| Some Startup Options | |
| |
| |
| Interacting with SQL*Plus | |
| |
| |
| Configuring the SQL*Plus Environment | |
| |
| |
| The SHOW Command | |
| |
| |
| Editing a File | |
| |
| |
| Creating Your First SQL Script | |
| |
| |
| Formatting Output | |
| |
| |
| Exiting SQL*Plus | |
| |
| |
| Configuring SQL*Plus | |
| |
| |
| Getting More Information | |
| |
| |
| Moving On | |
| |
| |
| |
| Designing Oracle SQL Statements | |
| |
| |
| SQL's Advantage | |
| |
| |
| SELECT Statement Clauses | |
| |
| |
| Aggregate Functions | |
| |
| |
| Single-Row SQL Functions | |
| |
| |
| Using Substitution Variables | |
| |
| |
| Using Subqueries | |
| |
| |
| DML Statements | |
| |
| |
| Create Table as Select | |
| |
| |
| Learning More | |
| |
| |
| Moving On | |
| |
| |
| |
| Learning More About Oracle | |
| |
| |
| Dates in Oracle | |
| |
| |
| Creating Views | |
| |
| |
| PL/SQL & Stored Code | |
| |
| |
| Transactions in Oracle | |
| |
| |
| Concurrency | |
| |
| |
| Tuning | |
| |
| |
| Optimizing Queries | |
| |
| |
| Moving On | |
| |
| |
| |
| Interfacing With The Internet User | |
| |
| |
| |
| HTML Forms and Database Access | |
| |
| |
| 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 Oracle Databases Using CGI Programs | |
| |
| |
| Basics Review | |
| |
| |
| What Is CGI? Summary of Common Web Database Access Methods | |
| |
| |
| Why Use Custom CGI Programs for Database Access | |
| |
| |
| Choosing a CGI Programming Language | |
| |
| |
| Accessing Web Database 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 | |
| |
| |
| Web Server Action on Receiving the Update Row Request | |
| |
| |
| 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 Performance of Web Database Applications | |
| |
| |
| Application Optimization | |
| |
| |
| Database Optimization | |
| |
| |
| Moving On | |
| |
| |
| |
| Advanced Topics In Internet Database Publishing | |
| |
| |
| |
| Migrating Data from Enterprise Data Stores to Server-Based Databases | |
| |
| |
| What to Migrate | |
| |
| |
| Replication | |
| |
| |
| Backup and Recovery | |
| |
| |
| Moving On | |
| |
| |
| |
| Using Firewalls and Security Components to Protect Your Data | |
| |
| |
| Oracle Security | |
| |
| |
| Using SQL to Administer Database 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 | |
| |
| |
| Moving On | |
| |
| |
| |
| Building a Simple Class Registration System | |
| |
| |
| Application Configuration | |
| |
| |
| Web Database Internet Components in the Application | |
| |
| |
| Web Database Intranet Components in the Application | |
| |
| |
| Moving On | |
| |
| |
| Appendices | |
| |
| |
| |
| CD-ROM Contents | |
| |
| |
| About the Companion CD-ROM | |
| |
| |
| Navigating the CD-ROM | |
| |
| |
| CD-ROM Contents | |
| |
| |
| Limits of Liability and Disclaimer of Warranty | |
| |
| |
| |
| Frequently Asked Questions | |
| |
| |
| What Are Web Applications? | |
| |
| |
| 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 from 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 a 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 Types of Join Relationships Are Recognized in Oracle 8? | |
| |
| |
| 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 | |