Product Description
The days of billboard/brochure Web sites are ending. Web developers today are on a mission to deliver sites with content and value. The primary means to accomplish this is by hooking up a back-end database which can deliver all sorts of valuable information to the end user, such as searching for a book on a bookstore's site. This volume concentrates in integrating Oracle databases. The CD-ROM contains a software toolkit for integrating an Oracle8 database and Web site. .
From the Inside Flap
Introduction
If you are reading this Introduction while browsing in a bookstore, go ahead and buy the book. You won't be disappointed. If you are reading this after purchasing the book, good for you. I'll tell you why, and the reason may surprise you. Does it intrigue you that one of the reasons is not to add $1.45 to my semi-annual royalty statement from the publisher?
This book will show you the skills and describe the techniques you need to know to become successful designing, developing, and implementing production Web applications that use Oracle 8 databases.
I trust you're not surprised to learn that you are not alone in the migration of developers to building Web database applications. Your ability to be successful in large part is determined by your skillset and how you apply those skills to solve business computing problems. Learn what is in these pages and you will have the basis to be successful. How you apply those skills is up to you.
The book assumes you have at least a beginner's understanding of the Oracle 8 database engine. It is designed to introduce you to the process of designing, developing, and implementing an Internet database application using the Oracle 8 database design. Key topics are the planning, design, and implementation of enterprise-quality Internet/intranet applications that include database connectivity to Oracle Corporation's Oracle 8 databases with production-level security and performance. All technical terms used in the book are defined and there are abundant screen images, tips, and callouts. Also included in this book are abundant examples of Web page construction and program code with database access.
The layout of this book is designed to be informative and valuable if you like to read a book from the front cover to the back. If you are the type of person that likes to read only those topics that interest you, then you will be pleased to learn that with 21 chapters in this book, plus three appendices, you can pick and choose which chapters to read without missing anything. The following is a brief description of each of the chapters in this book:
Section 1: Planning
Chapter 1: The Web Connection. Before you plunge into the issues specific to the design, development, and implementation of Web database applications, it is valuable that you understand a few things about the origins of the Web. That's what this chapter is about. With this as a foundation, hopefully you can make better sense out of all the Web-hype that so pervades the computer industry.
Chapter 2: Web Commerce. This chapter introduces you to some of the reasons why companies are turning to the Web as the production platform for database applications. You will learn the role that the database plays in these applications. Following this is a list of some of the things you should consider, outside of the technical issues that you'll learn about in the remainder of this book, when doing business on the Web.
Chapter 3: Choosing a CGI Programming Language. Choosing a CGI programming language to use to develop a Web database application is becoming increasingly more difficult. Now, you have a myriad of languages, derivatives of languages, dialects of languages, development suites, programming suites, and various iterations of each of these to choose from. To attempt to write about each of the current products would be futile. New languages and tools pop up all the time. This chapter focuses on the most popular languages available to build Web database applications.
Chapter 4: Overview of Java and JavaScript. The release of Java from Sun Microsystems preceded slightly the release of JavaScript. Partly because of this, some people view these two languages as being an either/or decision. This is not the case. They do share similar syntax and use objects similarly, but the languages were developed to solve different sets of problems. The two languages are not very much related to each other and their intended use is quite a bit different, as you will learn in this chapter.
Chapter 5: Application Development Suites. This chapter presents information on a number of application development suites. The major features of the products are described along with contact information. I have reviewed only a subset of these products, so it would be unfair (and therefore I won't do it) to recommend one product over the other. Most vendors will supply you with evaluation copies of the their products, and in many cases, you can download these evaluation copies directly from the Web. Most of the products described here are also included on the companion CD-ROM.
Chapter 6: Overview of HTML. If you are new to the Web, this chapter gives you a good introduction to HyperText Markup Language (HTML), how to read it, write it, and how to use it. If you are an experienced Web developer or user, you too will find useful information in this chapter on topics such as the structure of HTML, advanced HTML topics, good HTML coding practices, and the future of HTML.
Chapter 7: Overview of CGI. In this chapter, you'll learn about the Common Gateway Interface (CGI) and the role it has in Web database application development. Being one of the most important links that connect Web pages to databases, CGI plays a critical role in Web database design and use. You'll learn about the CGI standard as it applies to UNIX and Windows operating systems. Simple programs are used to communicate and demonstrate CGI capabilities.
Section 2: Internet Database Design
Chapter 8: Web Application Design and Development. This chapter takes the fundamental concepts of Client Server database application development and applies them to the unique attributes of the Web. We begin by discussing what those concepts are, progress through describing the architectural components of the Web, and end with the application of those concepts to the Web architecture.
Chapter 9: New Features and Creating Database Objects in Oracle. Beginning with this chapter and continuing into chapters 10, 11, and 12, you are introduced to Oracle Corporations Oracle 8 product. This chapter provides an overview of the product and some of the features (most of which are new) specific to Web database application development. It continues on with specific information on DDL, SQL, and the facilities in Oracle 8 to define databases and database objects.
Chapter 10: Oracle 8 Queries. You will learn how to build and execute simple queries in Oracle 8. You will also learn how to use an external data source, including Open DataBase Connectivity (ODBC), in your Oracle 8 tables and queries. This information will assist you if you are using a development tool besides Oracle 8 to build your front-end Web database application.
Chapter 11: Designing Advanced Oracle 8 Queries. In this chapter you will go deeper into the facilities in Oracle 8 to create advanced queries. This includes using multiple aggregate functions, applying criteria in the query, parameter queries, nested queries, and optimizing performance of queries. The information discussed in this chapter is valuable to any developer using Oracle 8 as their back-end RDBMS, regardless of what front-end design and HTML tool is being used.
Chapter 12: Exploiting Oracles Stored Code and Object-Oriented Features. The information discussed in this chapter is valuable to any developer using Oracle as their back-end RDBMS, regardless of the front-end design and HTML tool being used. Two additional SQL topics, dates and views, are discussed. PL/SQL, Oracle's procedural language is described, as well as the ability to store code within the database. Oracle transactional logic and locking are explained. Finally, performance and tuning of SQL statements are covered.
Section 3: Interfacing with the Internet User
Chapter 13: HTML Forms and Database Access. This chapter gives you a thorough introduction into the markups (controls) available to construct and transmit an HTML form. These markups, and the actions and attributes you code to the controls on the form, are the input mechanism into your Web database application.
Chapter 14: Accessing Oracle Databases Using CGI Programs. This chapter begins with a review of CGI basics you learned in previous chapters in this book. You will learn about CGI input and output processing, and some of the different ways that exist in which a client can make a request to the server when an HTML form is submitted. Then, you will see how CGI programs can be used to generate HTML. Later in this chapter you will learn among other things, how to write a CGI program to perform whatever type of database access required by your Web database application.
Chapter 15: MIME and Advanced Data Presentation. The earlier chapters in this book present material on the tools available for Web database application development, Oracle Corporation's Oracle 8 product, using the Oracle 8 product to build database components, Web database application architecture, and HTML and CGI program
If you are reading this Introduction while browsing in a bookstore, go ahead and buy the book. You won't be disappointed. If you are reading this after purchasing the book, good for you. I'll tell you why, and the reason may surprise you. Does it intrigue you that one of the reasons is not to add $1.45 to my semi-annual royalty statement from the publisher?
This book will show you the skills and describe the techniques you need to know to become successful designing, developing, and implementing production Web applications that use Oracle 8 databases.
I trust you're not surprised to learn that you are not alone in the migration of developers to building Web database applications. Your ability to be successful in large part is determined by your skillset and how you apply those skills to solve business computing problems. Learn what is in these pages and you will have the basis to be successful. How you apply those skills is up to you.
The book assumes you have at least a beginner's understanding of the Oracle 8 database engine. It is designed to introduce you to the process of designing, developing, and implementing an Internet database application using the Oracle 8 database design. Key topics are the planning, design, and implementation of enterprise-quality Internet/intranet applications that include database connectivity to Oracle Corporation's Oracle 8 databases with production-level security and performance. All technical terms used in the book are defined and there are abundant screen images, tips, and callouts. Also included in this book are abundant examples of Web page construction and program code with database access.
The layout of this book is designed to be informative and valuable if you like to read a book from the front cover to the back. If you are the type of person that likes to read only those topics that interest you, then you will be pleased to learn that with 21 chapters in this book, plus three appendices, you can pick and choose which chapters to read without missing anything. The following is a brief description of each of the chapters in this book:
Section 1: Planning
Chapter 1: The Web Connection. Before you plunge into the issues specific to the design, development, and implementation of Web database applications, it is valuable that you understand a few things about the origins of the Web. That's what this chapter is about. With this as a foundation, hopefully you can make better sense out of all the Web-hype that so pervades the computer industry.
Chapter 2: Web Commerce. This chapter introduces you to some of the reasons why companies are turning to the Web as the production platform for database applications. You will learn the role that the database plays in these applications. Following this is a list of some of the things you should consider, outside of the technical issues that you'll learn about in the remainder of this book, when doing business on the Web.
Chapter 3: Choosing a CGI Programming Language. Choosing a CGI programming language to use to develop a Web database application is becoming increasingly more difficult. Now, you have a myriad of languages, derivatives of languages, dialects of languages, development suites, programming suites, and various iterations of each of these to choose from. To attempt to write about each of the current products would be futile. New languages and tools pop up all the time. This chapter focuses on the most popular languages available to build Web database applications.
Chapter 4: Overview of Java and JavaScript. The release of Java from Sun Microsystems preceded slightly the release of JavaScript. Partly because of this, some people view these two languages as being an either/or decision. This is not the case. They do share similar syntax and use objects similarly, but the languages were developed to solve different sets of problems. The two languages are not very much related to each other and their intended use is quite a bit different, as you will learn in this chapter.
Chapter 5: Application Development Suites. This chapter presents information on a number of application development suites. The major features of the products are described along with contact information. I have reviewed only a subset of these products, so it would be unfair (and therefore I won't do it) to recommend one product over the other. Most vendors will supply you with evaluation copies of the their products, and in many cases, you can download these evaluation copies directly from the Web. Most of the products described here are also included on the companion CD-ROM.
Chapter 6: Overview of HTML. If you are new to the Web, this chapter gives you a good introduction to HyperText Markup Language (HTML), how to read it, write it, and how to use it. If you are an experienced Web developer or user, you too will find useful information in this chapter on topics such as the structure of HTML, advanced HTML topics, good HTML coding practices, and the future of HTML.
Chapter 7: Overview of CGI. In this chapter, you'll learn about the Common Gateway Interface (CGI) and the role it has in Web database application development. Being one of the most important links that connect Web pages to databases, CGI plays a critical role in Web database design and use. You'll learn about the CGI standard as it applies to UNIX and Windows operating systems. Simple programs are used to communicate and demonstrate CGI capabilities.
Section 2: Internet Database Design
Chapter 8: Web Application Design and Development. This chapter takes the fundamental concepts of Client Server database application development and applies them to the unique attributes of the Web. We begin by discussing what those concepts are, progress through describing the architectural components of the Web, and end with the application of those concepts to the Web architecture.
Chapter 9: New Features and Creating Database Objects in Oracle. Beginning with this chapter and continuing into chapters 10, 11, and 12, you are introduced to Oracle Corporations Oracle 8 product. This chapter provides an overview of the product and some of the features (most of which are new) specific to Web database application development. It continues on with specific information on DDL, SQL, and the facilities in Oracle 8 to define databases and database objects.
Chapter 10: Oracle 8 Queries. You will learn how to build and execute simple queries in Oracle 8. You will also learn how to use an external data source, including Open DataBase Connectivity (ODBC), in your Oracle 8 tables and queries. This information will assist you if you are using a development tool besides Oracle 8 to build your front-end Web database application.
Chapter 11: Designing Advanced Oracle 8 Queries. In this chapter you will go deeper into the facilities in Oracle 8 to create advanced queries. This includes using multiple aggregate functions, applying criteria in the query, parameter queries, nested queries, and optimizing performance of queries. The information discussed in this chapter is valuable to any developer using Oracle 8 as their back-end RDBMS, regardless of what front-end design and HTML tool is being used.
Chapter 12: Exploiting Oracles Stored Code and Object-Oriented Features. The information discussed in this chapter is valuable to any developer using Oracle as their back-end RDBMS, regardless of the front-end design and HTML tool being used. Two additional SQL topics, dates and views, are discussed. PL/SQL, Oracle's procedural language is described, as well as the ability to store code within the database. Oracle transactional logic and locking are explained. Finally, performance and tuning of SQL statements are covered.
Section 3: Interfacing with the Internet User
Chapter 13: HTML Forms and Database Access. This chapter gives you a thorough introduction into the markups (controls) available to construct and transmit an HTML form. These markups, and the actions and attributes you code to the controls on the form, are the input mechanism into your Web database application.
Chapter 14: Accessing Oracle Databases Using CGI Programs. This chapter begins with a review of CGI basics you learned in previous chapters in this book. You will learn about CGI input and output processing, and some of the different ways that exist in which a client can make a request to the server when an HTML form is submitted. Then, you will see how CGI programs can be used to generate HTML. Later in this chapter you will learn among other things, how to write a CGI program to perform whatever type of database access required by your Web database application.
Chapter 15: MIME and Advanced Data Presentation. The earlier chapters in this book present material on the tools available for Web database application development, Oracle Corporation's Oracle 8 product, using the Oracle 8 product to build database components, Web database application architecture, and HTML and CGI program
