UNITED STATES PATENT AND TRADEMARK OFFICE
`
`
`
`
`
`
`
`
`
`
`
`
`
`BEFORE THE PATENT TRIAL AND APPEAL BOARD
`
`
`
`SERVICENOW, INC.,
`Petitioner
`
`v.
`
`HEWLETT-PACKARD COMPANY,
`Patent Owner
`
`
`
`
`
`
`
`
`
`
`
`
`
`Case IPR2015-00523
`Patent 6,321,229
`
`
`
`
`
`
`
`
`PETITIONER’S MOTION TO SUBMIT SUPPLEMENTAL
`INFORMATION PURSUANT TO 37 C.F.R. § 42.123(a)
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`

`
`Petitioner’s Motion to Submit Supplemental
`Information Pursuant to 37 C.F.R. § 42.123(a)
`IPR2015-00523
`
`Pursuant to 37 C.F.R. § 42.123(a), Petitioner ServiceNow, Inc. hereby
`
`moves to submit proposed exhibits 1010-1027 as supplemental evidence in
`
`support of a determination that the Fox1 and Forta2 references relied upon by
`
`the Petitioner qualify as prior art to U.S. Patent No. 6,321,229 (“the ’229
`
`patent”). The patent owner does not oppose this motion.
`
`STATEMENT OF MATERIAL FACTS
`
`review of claims 8‐10, 13, 15, and 17‐20 of the ’229 patent. The petition
`
`1.
`
`On January 5, 2015, Petitioner filed a petition for IPR requesting
`
`relied on prior art that included Fox and Forta. On July 21, 2015, the Board
`
`granted the petition and instituted a trial on the challenged claims based on
`
`grounds of unpatentability that included Fox and Forta.
`
`2.
`
`The patent owner thereafter raised the issue of whether Fox and
`
`Forta had been shown to be prior art in Patent Owner’s Objections to
`
`Evidence Pursuant to 37 C.F.R. § 42.64 dated August 4, 2015 (“Objections”).
`
`During a conference call on August 18, 2015, the Petitioner requested
`
`authorization to file a motion to submit supplemental information under 37
`
`1 David Fox, Web Publisher’s Construction Kit with HTML 3.2 (Ex. 1004).
`
`2 Ben Forta and Steven D. Drucker, The Cold Fusion Web Database
`
`Construction Kit (Ex. 1005).
`
`
`
`1
`
`

`
`Petitioner’s Motion to Submit Supplemental
`Information Pursuant to 37 C.F.R. § 42.123(a)
`IPR2015-00523
`
`C.F.R. § 42.123(a). The Board authorized this motion during that call, and the
`
`patent owner stated that it would not oppose this motion. (IPR2015-00523,
`
`Paper 19 at 2-3.) Petitioner seeks to submit the following supplemental
`
`information, all of which are attached hereto for reference as Exhibit A:
`
`Proposed
`Exhibit
`
`Description of Document and
`Its Relevance
`
`1010
`
`1011
`
`1012
`
`1013
`
`1014
`
`1015
`
`1016
`
`1017
`
`Declaration of Andrew Mace Re: Proposed Exhibits 1011-1027
`
`Excerpts of Fox (cover, copyright page, table of contents)
`obtained from the Library of Congress, showing date stamp of
`August 30, 1996
`
`Print-out from Library of Congress online catalog website for
`Fox (Exhibit 1011)
`
`United States Copyright Office Form TX 4-305-885, copyright
`registration form for Fox, showing first publication date for Fox
`on August 19, 1996 and effective registration date of August 29,
`1996
`
`Excerpts of Fox (cover, copyright page, table of contents)
`obtained from the Capital University Library, showing date stamp
`of August 1997
`
`Print-out from Capital University Library online catalog website
`for Fox (Exhibit 1014)
`
`Usenet post, dated May 1, 1997, from “Deep Discount Computer
`Books,” showing offer to sell copy of Fox
`
`Excerpts from Gunnit S. Khurana et al., Web Database
`Construction Kit (1996), which lists Fox as another title in the
`Waite Group Press’s catalog and directs the reader to visit
`waite.com, the Waite Group Press’s website, to view and order
`
`
`
`2
`
`

`
`Petitioner’s Motion to Submit Supplemental
`Information Pursuant to 37 C.F.R. § 42.123(a)
`IPR2015-00523
`
`Proposed
`Exhibit
`
`Description of Document and
`Its Relevance
`titles. (See Ex. 1017 at 006-007, 030-031.)
`
`1018
`
`1019
`
`1020
`
`1021
`
`1022
`
`1023
`
`1024
`
`1025
`
`1026
`
`1027
`
`Amazon.com written customer reviews of Khurana (Ex. 1017),
`earliest review dated January 19, 1997
`
`Affidavit of Christopher Butler, Office Manager at the Internet
`Archive, attaching excerpts from Waite Group website showing
`ability to order Fox online, by February 3, 1998
`
`Excerpts of Forta (cover, copyright page, table of contents)
`obtained from the Library of Congress, showing date stamp of
`March 14, 1997
`
`Print-out from Library of Congress online catalog website for
`Forta (Exhibit 1020)
`
`United States Copyright Office Form TX 4-410-074, copyright
`registration form for Forta, showing first publication date for
`Forta on December 30, 1996 and effective registration date of
`February 10, 1997
`
`Excerpts of Forta (cover, copyright page, table of contents)
`obtained from the Brigham Young University Library, including
`“DUE DATE” card showing multiple check-outs beginning on
`February 27, 1998
`
`Print-out from Brigham Young University Library online catalog
`website for Forta (Exhibit 1023)
`
`Amazon.com written customer reviews of Forta, multiple
`reviews from 1997, earliest review dated March 7, 1997
`
`Usenet post, dated November 29, 1997 from Jim Land, discussing
`Forta
`
`Usenet post, dated February 8, 1997, from alt.books.reviews,
`providing book review of Forta
`
`
`
`3
`
`

`
`Petitioner’s Motion to Submit Supplemental
`Information Pursuant to 37 C.F.R. § 42.123(a)
`IPR2015-00523
`
`
`
`3.
`
`All of the evidence sought to be submitted by this motion was
`
`served on the patent owner on August 18, 2015 as supplemental evidence in
`
`response to the patent owner’s August 4, 2015 Objections.3
`
`ARGUMENT
`
`The evidence sought to be submitted by this motion is precisely the
`
`kind of supplemental information contemplated by the rule. By this motion
`
`the Petitioner properly seeks to supplement the record to provide additional
`
`proof that Fox and Forta qualify as prior art printed publications. The
`
`supplemental information does not raise any new ground of unpatentability.
`
`Under 37 C.F.R. § 42.123(a), a motion to submit supplemental
`
`information must show that (1) petitioner requested authorization to file the
`
`motion within one month from institution and (2) the supplemental
`
`information must be relevant to a claim for which the trial has been instituted.
`
`Both of these requirements are met. The Petitioner timely requested (and
`
`received) authorization to file this motion on August 18, 2015, less than one
`
`month after institution. The supplemental information shows that Fox and
`
`
`3 Proposed exhibit 1019 filed with this motion is a notarized version of the
`
`same affidavit served on the patent owner on August 18, 2015.
`
`
`
`4
`
`

`
`Petitioner’s Motion to Submit Supplemental
`Information Pursuant to 37 C.F.R. § 42.123(a)
`IPR2015-00523
`
`Forta are prior art printed publications, which is relevant to all grounds on
`
`which trial has been instituted.
`
`The Board has granted motions under Rule 42.123(a) under similar
`
`facts. See, e.g., Palo Alto Networks, Inc. v. Juniper Networks, Inc., IPR2013-
`
`00369, Paper 37 at 2 (PTAB Feb. 5, 2014); Valeo N. Am., Inc. v. Magna
`
`Elecs., Inc., IPR2014-01204, Paper 26 at 2-3 (PTAB Apr. 10, 2015). Here,
`
`the supplemental
`
`information similarly provides additional evidence
`
`confirming the public accessibility of non-patent prior art relied upon in the
`
`petition, on which trial has been instituted.
`
`CONCLUSION
`
`Petitioner respectfully requests that supplemental information found in
`
`proposed exhibits 1010-1027 be admitted into the record.
`
`
`
`Dated: August 21, 2015
`
`
`
`
`
`
`
`
`
`
`
`
`
`Respectfully submitted,
`
`
`
`
`
`
`
`
`
`/Heidi Keefe/
`Heidi Keefe
`Registration No. 40,673
`Counsel for Petitioner
`
`Cooley LLP
`ATTN: Patent Group
`1299 Pennsylvania Ave., NW, Suite 700
`Washington, DC 20004
`Tel: (650) 843-5001
`Fax: (650) 849-7400
`
`5
`
`

`
`Petitioner’s Motion to Submit Supplemental
`Information Pursuant to 37 C.F.R. § 42.123(a)
`IPR2015-00523
`
`CERTIFICATE OF SERVICE
`
`I hereby certify, pursuant to 37 C.F.R. § 42.6, that a copy of the
`attached PETITIONER’S MOTION TO SUBMIT SUPPLEMENTAL
`INFORMATION and exhibits are being electronically served on the 21st
`day of August 2015 upon counsel for the patent owner as follows:
`
`David L. Cavanaugh
`David.Cavanaugh@wilmerhale.com
`WHIPDocketStaff@wilmerhale.com
`
`Owen Allen
`Owen.Allen@wilmerhale.com
`WHIPDocketStaff@wilmerhale.com
`
`Joseph F. Haag
`Joseph.Haag@wilmerhale.com
`WHIPDocketStaff@wilmerhale.com
`
`Evelyn C. Mak
`Evelyn.Mak@wilmerhale.com
`WHIPDocketStaff@wilmerhale.com
`
`
`
`/ Heidi L. Keefe /
`Heidi L. Keefe
`Reg. No. 40,673
`
`
`
`COOLEY LLP
`ATTN: Heidi L. Keefe
`Patent Group
`1299 Pennsylvania Ave. NW, Suite 700
`Washington, D.C. 20004
`Tel: (650) 843-5001
`Fax: (650) 849-7400
`
`
`
`
`
`6
`
`

`
`EXHIBIT A
`
`
`
`Proposed Exhibits
`
`
`

`
`IPR2015-00523
`
`IPR2015-00523
`
`
`
`PROPOSED
`EXHIBIT 1010
`
`PROPOSED
`
`EXHIBIT 1010
`
`
`
`

`
`UNITED STATES PATENT AND TRADEMARK OFFICE
`
`
`
`
`
`
`
`
`
`
`
`
`
`BEFORE THE PATENT TRIAL AND APPEAL BOARD
`
`
`
`SERVICENOW, INC.,
`Petitioner
`
`v.
`
`HEWLETT-PACKARD COMPANY,
`Patent Owner
`
`
`
`
`
`
`
`
`
`
`
`
`
`Case IPR2015-00523
`Patent 6,321,229
`
`
`
`
`
`
`
`
`DECLARATION OF ANDREW MACE
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`ServiceNow's Exhibit No. 1010
`
`001
`
`

`
`Declaration of Andrew Mace
`IPR2015-00523
`
`I, Andrew Mace, declare as follows:
`
`1.
`
`I am an attorney with the law firm Cooley LLP. I am duly
`
`licensed to practice law in the State of California and State of New York and
`
`am back-up counsel in the above-captioned proceeding for Petitioner
`
`ServiceNow, Inc. This declaration is based on my own personal knowledge.
`
`If called upon to testify, I could and would testify competently thereto.
`
`2.
`
`Exhibit 1004 filed in this proceeding is a copy excerpts scanned
`
`from a copy of David Fox & Troy Downing, Web Publisher’s Construction
`
`Kit with HTML 3.2 (“Fox”). Exhibit 1005 filed in this proceeding is a copy
`
`excerpts scanned from a copy of Ben Forta et al., The Cold Fusion Web
`
`Database Construction Kit (“Forta”). The copies of Fox and Forta used to
`
`create Exhibits 1004 and 1005 were purchased through the website
`
`Amazon.com. I directed my assistant to scan excerpts from those copies of
`
`Fox and Forta to create Exhibits 1004 and 1005, and I reviewed the excerpts
`
`before they were filed in this proceeding.
`
`3.
`
`Exhibit 1011 filed in this proceeding is a copy of excerpts of
`
`Fox scanned from a copy obtained from the collection of the Library of
`
`Congress. Exhibit 1020 filed in this proceeding is a copy of excerpts of Forta
`
`scanned from a copy obtained from the collection of the Library of Congress.
`
`
`
`1
`
`ServiceNow's Exhibit No. 1010
`
`002
`
`

`
`The scanned excerpts of Exhibits 1011 and 1020 were obtained by a third-
`
`party document delivery service at the request of librarians at Cooley LLP,
`
`acting at my direction.
`
`4.
`
`Exhibit 1012 filed in this proceeding is a print-out of a web page
`
`from
`
`the Library of Congress website available at
`
`the URL
`
`<http://catalog.loc.gov/vwebv/search?searchCode=STNO&searchArg=
`
`96030564&searchType=1&recCount=10>. I located this web page and URL
`
`by using the Library of Congress website’s search feature to locate the catalog
`
`entry for the Fox reference. I created the print-out attached as Exhibit 1012
`
`by saving the web page as a PDF file using a web browser on August 13,
`
`2015.
`
`5.
`
`Exhibit 1021 filed in this proceeding is a print-out of a web page
`
`from
`
`the Library of Congress website available at
`
`the URL
`
`<http://catalog.loc.gov/vwebv/holdingsInfo?searchId=7236&recCount=10&
`
`recPointer=0&bibId=4947470>. I located this web page and URL by using
`
`the Library of Congress website’s search feature to locate the catalog entry
`
`for the Forta reference. I created the print-out attached as Exhibit 1021 by
`
`saving the web page as a PDF file using a web browser on August 13, 2015.
`
`
`
`2
`
`ServiceNow's Exhibit No. 1010
`
`003
`
`

`
`6.
`
`Exhibit 1013 and Exhibit 1022 filed in this proceeding are
`
`copies of the Form TX for Fox and Forta, respectively, filed with the United
`
`States Copyright Office. The copies were obtained by a third-party document
`
`delivery service at the request of librarians at Cooley LLP acting at my
`
`direction.
`
`7.
`
`Exhibit 1014 filed in this proceeding is a copy of excerpts
`
`scanned from a copy of Fox held in the collection of the library at the Capital
`
`University Law School. The copy of excerpts was created at my request and
`
`direction by a librarian at that library on August 13, 2015.
`
`8.
`
`Exhibit 1015 filed in this proceeding is a print-out of a web page
`
`from the Capital University Libraries website available at the URL
`
`<http://charli.capital.edu/record= b1177783~S3>. I located this web page and
`
`URL by using the Capital University Libraries website’s search feature to
`
`locate the catalog entry for the Fox reference. I created the print-out by
`
`visiting that URL and saving the web page as a PDF file using a web browser
`
`on August 13, 2015.
`
`9.
`
`Exhibit 1016 filed in this proceeding is a print-out of a
`
`document
`
`available
`
`at
`
`the URL <https://groups.google.com/forum/
`
`message/raw?msg=va.forsale/wvuom337r_E/ecspfXVV9kMJ>. I created the
`
`
`
`3
`
`ServiceNow's Exhibit No. 1010
`
`004
`
`

`
`print-out by visiting that URL and saving the document as a PDF file on
`
`August 12, 2015.
`
`10. Exhibit 1017 filed in this proceeding is a copy of excerpts from
`
`a copy of Gunnit S. Khurana and Balbir S. Khurana, Web Database
`
`Construction Kit (“Khurana”). I directed librarians at Cooley LLP to
`
`purchase the copy of Khurana that was used to create Exhibit 1017 through
`
`the website Amazon.com. I directed my assistant to scan excerpts from that
`
`copy of Khurana to create Exhibit 1017, and I reviewed the exhibit for
`
`accuracy before it was filed in this proceeding.
`
`11. Exhibit 1018 filed in this proceeding is a print-out of a web page
`
`from the website Amazon.com. I created the print-out by visiting the URL
`
`<http://www.amazon.com/Web-Database-Construction-Kit-Step-By-
`
`Step/product-reviews/1571690328/ref=cm_cr_pr_viewopt_srt?
`
`ie=UTF8&showViewpoints=1&sortBy=recent&reviewerType=all_reviews&f
`
`ormatType=all_formats&filterByStar=all_stars&pageNumber=1> and saving
`
`the web page as a PDF file using a web browser on August 13, 2015.
`
`12. Exhibit 1019 filed in this proceeding is a copy of an Affidavit of
`
`Christopher Butler, Office Manager at the Internet Archive.
`
`
`
`4
`
`ServiceNow's Exhibit No. 1010
`
`005
`
`

`
`13. Exhibit 1023 filed in this proceeding is a copy of excerpts
`
`scanned from a copy of Forta held in the collection of the Harold B. Lee
`
`Library at Brigham Young University. The copy of excerpts was created at
`
`my request and direction by a librarian at that library on August 13, 2015.
`
`14. Exhibit 1024 filed in this proceeding is a print-out of a web page
`
`from the website for the Harold B. Lee Library at Brigham Young University
`
`available
`
`at
`
`the
`
`URL
`
`<http://catalog.lib.byu.edu/uhtbin/
`
`cgisirsi/x/0/0/57/5/3?searchdata1=2271835%7bCKEY%7d&searchfield1=GE
`
`NERAL%5eSUBJECT%5eGENERAL%5e%5e&user_id=WEBSERVER>. I
`
`created the print-out by visiting that URL and saving the web page as a PDF
`
`file using a web browser on August 13, 2015.
`
`15. Exhibit 1025 filed in this proceeding is a print-out of a web page
`
`from the website Amazon.com. I created the print-out by visiting the URL
`
`<http://www.amazon.com/The-Cold-Fusion-Database-Construction/product-
`
`reviews/0789709708/ref=cm_cr_pr_btm_link_next_2?
`
`ie=UTF8&showViewpoints=1&sortBy=recent&reviewerType=all_reviews&f
`
`ormatType=all_formats&filterByStar=all_stars&pageNumber=2> and saving
`
`the web page as a PDF file using a web browser on August 10, 2015.
`
`
`
`5
`
`ServiceNow's Exhibit No. 1010
`
`006
`
`

`
`16. Exhibit 1026 filed in this proceeding is a print-out of a
`
`document available at the URL <https://groups.google.com/forum/message/
`
`raw?msg=comp.infosystems.www.authoring.html/Z-sK1PhLirU/we-
`
`msDrVHncJ>. I created the print-out by visiting that URL and saving the
`
`document as a PDF file using a web browser on August 12, 2015.
`
`17. Exhibit 1027 filed in this proceeding is a print-out of a
`
`document available at the URL <https://groups.google.com/forum/message/
`
`raw?msg=alt.books.reviews/6_tO8cnZymQ/mRiOyOkbVjgJ>. I created the
`
`print-out by visiting that URL and saving the document as a PDF file using a
`
`web browser on August 12, 2015.
`
`18. Exhibits 1011-1027 are true and correct copies of those
`
`documents to the best of my knowledge, information and belief.
`
`I declare under penalty of perjury that the foregoing is true and correct.
`
`Executed on August 19, 2015 in Palo Alto, California.
`
`
`/Andrew Mace/
`Andrew Mace
`
`
`
`
`
`6
`
`
`
`
`
`
`
`ServiceNow's Exhibit No. 1010
`
`007
`
`

`
`IPR2015-00523
`
`IPR2015-00523
`
`
`
`PROPOSED
`EXHIBIT 1011
`
`PROPOSED
`
`EXHIBIT 1011
`
`
`
`

`
`001
`
`ServiceNow's Exhibit No. 1011
`
`

`
`002
`
`ServiceNow's Exhibit No. 1011
`
`

`
`003
`
`ServiceNow's Exhibit No. 1011
`
`

`
`004
`
`ServiceNow's Exhibit No. 1011
`
`

`
`005
`
`ServiceNow's Exhibit No. 1011
`
`

`
`IPR2015-00523
`
`IPR2015-00523
`
`
`
`PROPOSED
`EXHIBIT 1012
`
`PROPOSED
`
`EXHIBIT 1012
`
`
`
`

`
`ServiceNow's Exhibit No. 1012
`
`001
`
`

`
`ServiceNow's Exhibit No. 1012
`
`002
`
`

`
`IPR2015-00523
`
`IPR2015-00523
`
`
`
`PROPOSED
`EXHIBIT 1013
`
`PROPOSED
`
`EXHIBIT 1013
`
`
`
`

`
`ServiceNow's Exhibit No. 1013
`
`001
`
`

`
`ServiceNow's Exhibit No. 1013
`
`002
`
`

`
`ServiceNow's Exhibit No. 1013
`
`003
`
`

`
`ServiceNow's Exhibit No. 1013
`
`004
`
`

`
`IPR2015-00523
`
`IPR2015-00523
`
`
`
`PROPOSED
`EXHIBIT 1014
`
`PROPOSED
`
`EXHIBIT 1014
`
`
`
`

`
`ServiceNow's Exhibit No. 1014
`
`001
`
`

`
`ServiceNow's Exhibit No. 1014
`
`002
`
`

`
`ServiceNow's Exhibit No. 1014
`
`003
`
`

`
`ServiceNow's Exhibit No. 1014
`
`004
`
`

`
`ServiceNow's Exhibit No. 1014
`
`005
`
`

`
`IPR2015-00523
`
`IPR2015-00523
`
`
`
`PROPOSED
`EXHIBIT 1015
`
`PROPOSED
`
`EXHIBIT 1015
`
`
`
`

`
`ServiceNow's Exhibit No. 1015
`
`001
`
`

`
`ServiceNow's Exhibit No. 1015
`
`002
`
`

`
`ServiceNow's Exhibit No. 1015
`
`003
`
`

`
`IPR2015-00523
`
`IPR2015-00523
`
`
`
`PROPOSED
`EXHIBIT 1016
`
`PROPOSED
`
`EXHIBIT 1016
`
`
`
`

`
`ServiceNow's Exhibit No. 1016
`
`001
`
`

`
`ServiceNow's Exhibit No. 1016
`
`002
`
`

`
`ServiceNow's Exhibit No. 1016
`
`003
`
`

`
`IPR2015-00523
`
`IPR2015-00523
`
`
`
`PROPOSED
`EXHIBIT 1017
`
`PROPOSED
`
`EXHIBIT 1017
`
`
`
`

`
`ServiceNow's Exhibit No. 1017
`
`001
`
`

`
`-...
`
`• I
`I
`
`..
`
`ServiceNow's Exhibit No. 1017
`
`002
`
`

`
`ServiceNow's Exhibit No. 1017
`
`003
`
`

`
`Publisher • Mitchell Waite
`Associate Publisher • Charles Drucker
`
`Acquisitions Manager • jill Pisani
`Acquisitions Editor • joanne Miller
`
`Editorial Director • john Crudo
`Project Editor • Laura E. Brown
`Content Editor • Scott Rhoades
`Technical Reviewer • Keith Allison
`Copy Editor • jan jue
`
`Production Director • julianne Ososke
`Production Manager • Cecile Kaufman
`Production Editor • Mark Nigara
`Senior Designer • Sestina Quarequio
`Designer • Karen johnston
`Cover Illustration • Rafael lopez
`Production • Carol Bowers, jeanne Clark, Cheryl Dietsch, Mike Henry, louisa Klucznik, Andrew Stone
`
`© 1996 by The Waite Group, Inc.®
`Published by Waite Group PressTM, 200 Tarnal Plaza, Corte Madera, CA 94925.
`
`:t:.
`
`Waite Group PressTM is a division of Sarns Publishing.
`All rights reserved. No part of this manual shall be reproduced, stored in a retrieval system, or transmitted by any
`means, ~leH~<?nic, mechanical, photocopying, desktop publishing, recording, or otherwise, without permission
`·frqm the pt!ffi\l.fit!tbt~l1fl.tent liability is assumed with respect to the use of the information contained herein.
`" ~ ..
`h:J t ~j;: .f,.. While e'(ery precautio~ hM' been taken in the preparation of this book, the publisher and author assume no
`•· · ·• ·~ , .~tesponsibility for .errors or omissions. Neither is any liability assumed for damages resulting from the use of the
`info'rmat4on tpntained herein.
`•
`'1•
`I
`All terms mentioned in tlui boo~ that are known to be registered trademarks, trademarks, or service marks are
`listed below. In addition, terms suspected of being trademarks, registered trademarks, or service marks have been
`appropriately capitalized. Waite Group Press cannot attest to the accuracy of this information. Use of a term in
`this book should not be regarded as affecting the validity of any registered trademark, trademark, or service mark.
`
`•
`
`I
`
`The Waite Group is a registered trademark of The Waite Group, Inc.
`Waite Group Press and The Waite Group logo are trademarks of The Waite Group, Inc.
`WebSite is a trademark of O'Reilly & Associates, Inc. Webforms and Web Mania are trademarks of Q&D Software
`Development. Visual Basic, Access. and Windows 95 are registered trademarks and Windows is a trademark of
`Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their
`respective owners.
`
`Printed in the United States of America
`96 97 98 99 • 10 9 8 7 6 5 4 3 2 1
`
`library of Congress Cataloging-in-Publication Data
`Khurana, Gunnit S., 1969-
`Web database construction kit I Gunnit S. Khurana, Balbir S. Khurana.
`p. em.
`Includes index.
`ISBN l-57169-032-8
`1. Database design. 2. Microsoft Access. 3. Microsoft Visual Basic.
`4. World Wide Web (Information retrieval system)
`I. Khurana, Balbir S.
`Il. Title.
`QA76.9.D26K48 1996
`005. 75'8--dc20
`
`96-31733
`C!P
`
`ServiceNow's Exhibit No. 1017
`
`004
`
`

`
`DEDICATION
`
`To Amit and Amrita, for their love and support.
`
`- Gunnit S. Khurana and Balbir S. Khurana
`
`ServiceNow's Exhibit No. 1017
`
`005
`
`

`
`Message from the
`Publisher
`
`WELCOME TO OUR NERVOUS SYSTEM
`Some people say that the World Wide Web is a graphical
`extension of the information superhighway, just a network
`of humans and machines sending each other long lists of the
`equivalent of digital junk mail.
`1 think it is much more than that. To me, the Web is nothing less than the nervous
`systf'm of the entire planet-not just a collection of computer brains connecLeu togeth(cid:173)
`er, but more like a billion silicon neurons entangled and recirculating electro-chemical
`signals of information and data, each contributing to the birth of another CPU and
`another Web site.
`Think of each person's hard disk connected at once to every other hard disk on earth,
`driven by human navigators searching like Columbus for the New World. Seen this way
`the Web is more of a super entity, a growing, living thing, controlled by the universal
`human \vill to expand, to be more. Yet, unlike a purposeful business plan with rigid
`rules, the Web expands in a nonlinear, unpredictable, creative way that echoes natural
`evolution.
`We created our Web site not just to extend the reach of our computer book products but
`to be part of this synaptic neural network, to experience, like a nerve in the body, the flow
`of idea~ and then to pass those ideas up the food chain of the mind. Your mind. Even more,
`we wanted to pump some of our own creative juices into this rich wine of technology.
`
`TASTE OUR DIGITAL WINE
`And so we ask you to taste our wine by visiting the body of our business. Begin by
`understanding the metaphor we have created for our Web site-a universal learning
`center, situated in outer space in the form of a space station. A place where you can jour(cid:173)
`ney to study any topic from the convenience of your own screen. Right now we are
`focusing on computer topics, but the stars are the limit on the Web.
`If you are interested in discussing this Web site or finding out more about the Waite
`Group, please send me e-mail with your comments, and l \vill be happy to respond. Being
`a programmer myself, I love to talk about technology
`and find out what our readers are looking for.
`
`Sincerely,
`
`~1J:li;Y
`
`Mitchell Waite, C.E.O. and Publisher
`
`ServiceNow's Exhibit No. 1017
`
`006
`
`

`
`Come Visit
`
`WAITE.COM
`
`Waite Group Press
`World Wide Web Site
`
`Now find all the latest information on Waite Group books at our new Web
`siLe, http://www.waite.com/waite. You'll find an online catalog where
`you can examine and order any title, review upcoming books, and send e(cid:173)
`mail to our authors and editors. Our FTP site has all you need to update your book:
`the latest program listings, errata sheets, most recent versions of Fractint, POV Ray,
`Polyray, DMorph, and all the programs featured in our books. So download, talk to
`us, ask questions, on http://www.waite.com/waite.
`r-------
`
`The New Arrivals Room has all our new books
`listed by month. Just click for a description,
`Index, Table of Contents, and links to authors.
`
`1
`J
`I
`I
`I
`
`The Backlist Room
`has oil our books listed
`alphabetically.
`
`,..(cid:173)
`
`I
`I
`I
`I
`I
`I
`-..1
`
`r--
`1
`I
`I
`I
`I
`-.J
`
`The People Room is where
`you'll interact with Waite
`Group employees.
`
`Links to C yberspoce get
`you in touch with other
`computer book publishers
`and other interesting
`Web sites.
`
`I
`I
`I
`
`L - The FTP site contains all
`program listings, errata
`sheets, etc.
`
`I
`I
`I
`I
`I
`I
`I
`L- -
`
`I
`I
`
`I L------------
`The Order Room is where
`you con order any of our
`books online.
`
`The Subject Room contains typical book
`pages which show description, Index, Tobie
`of Contents, and links to authors.
`
`ServiceNow's Exhibit No. 1017
`
`007
`
`

`
`About the Authors
`
`unnit S. Khurana has an M.S. in Computer Science from
`the University of Nebraska, Lincoln. He has been
`involved with publishing databases on the Web since
`the standardization of Common Gateway Interface (CGI).
`'
`He initially worked with World Wide Web servers and CGI
`programs in the UNIX environment but quickly realized
`that it was not the easiest way to develop database-oriented
`Web sites. Being an expert Microsoft Access programmer,
`he sees great benefits in Windows- and Windows NT(cid:173)
`based World Wide Web servers that support Windows
`CGI, and has employed that combination to rapidly develop
`various database publishing applications for the Web.
`
`Balbir S. Khurana is a professor in the School of
`
`Computer and System Sciences at Jawaharlal Nehru
`University, New Delhi. He received his B.S. from the
`University of Roorkee, his M.S. from the University of
`Rajasthan, and his Ph.D. from the University of Tokyo.
`During his twenty years of teaching, and ten years of indus(cid:173)
`trial experience, he has developed many teaching aids and
`construction kits to augment his lectures, mastered the
`intricacies of the most difficult technical concepts, and
`developed them in a clear and simple manner. He enjoys
`exploring the Web and imagining new and creative ways of
`utilizing this powerful technology.
`
`ServiceNow's Exhibit No. 1017
`
`008
`
`

`
`TABlE OF CONTENTS
`
`INTRODUCTION ......................................... . . . . . ... I
`I
`2 GETTING STARTED ....... . ................... . ...... . ............ 9
`3 DISSECTING A JOB LISTING SYSTEM . . . . ................. . .......... 51
`4 BUILDING A DATABASE WITH MICROSOFT ACCESS .................. 87
`5 BUILDING MICROSOFT ACCESS QUERIES .......................... I 17
`6 DESIGNING ADVANCED QUERIES ..................... . .... . ... . . 151
`7 ELEMENTS OF THE WORLD WIDE WEB .... . ..................... . . 191
`8 CREATING HTML FORMS ... . . . .. . ... . ..... . .... . ................ 225
`9 WINDOWS COMMON GATEWAY INTERFACE ...................... 261
`I 0 WINDOWS CGI OUTPUT STANDARD ............................. 289
`I I DESIGNING A WINDOWS CGI APPLICATION ..................... . . 303
`12 DESIGNING A WINDOWS CGI APPLICATION
`TO PROCESS FORM DATA .... . ........ . ... . . . .. . ...... . ........ . . 329
`13 UTILITIZING AN ACCESS DATABASE IN A CGI APPLICATION ......... 367
`14 PROCESSING TEMPLATE FILES WITH A CGI APPLICATION ........... .403
`15 DISPLAYING DATABASE RECORDS THROUGH TEMPLATE FILES ....... .433
`16 CREATING AN ON-LINE BOOKSTORE ... . ..... . . . . . .... . ... . .. . . . .465
`17 ENHANCING THE ON-LINE BOOKSTORE ........ . ................ .495
`18 SETTING UP AN ON-LINE ORDERING SYSTEM .... . ................. 537
`A ORGANIZATION OF FILES ON THE CD ............................ 581
`B SOURCE CODE OF THE UTILS.BAS LIBRARY ........................ 585
`C
`INTERNET EXPLORER 3.0: A FIELD GUIDE . ................ . ........ 625
`
`INDEX ........................ . ... . ......................... . . 639
`
`VII
`
`ServiceNow's Exhibit No. 1017
`
`009
`
`

`
`CONTENTS
`
`INTRODUCTION .... . ........ . . . .. .. ..... . .. . .... .. . . . .. ... I
`WHAT THIS BOOK IS ABOUT ....................................... . .......... .4
`WHO THIS BOOK IS FOR ............... . . . . . ...................... . .......... .5
`WHAT YOU GAIN FROM THIS BOOK ............................... . .......... .5
`HOW THIS BOOK IS ORGANIZED ................................... . ........... 6
`A FINAL NOTE ................................................................ 8
`2 GETTING STARTED ......... . ..... ... ... . ...... .. .. . .... . .. . 9
`FEATURES OF THE WEBSITE WWW SERVER ..................................... 12
`Easy To Configure ....................................................... I 3
`Running External Programs ................................................. I 3
`Mapping Support ......................................................... 13
`Multiple Web Identity Support .............................................. 14
`Access and Error Logs .................................................... 14
`Built-In lmagemap Processing ..... . ......................................... IS
`Automatic Directory Indexes ............................................... I 6
`Site Security ............................................................. 17
`Server-Side Includes .......................... . ........ . ... . . . ............ 18
`LESSON I: INSTALLING THE EVALUATION VERSION OF WEBSITE ................. 19
`STEP I : Complete the Prerequisites ......................................... 19
`STEP 2: Setting Up WebSite ...... . ... . ............... .. .......... . ...... . . 20
`STEP 3: Testing the WebSite Server ......................................... 23
`STEP 4: Demonstrating the Server Features ................................... 25
`LESSON 2: ADMINISTERING WEBSITE .......... . . . ............................. . 26
`General Section Parameters ................................................ 26
`Mapping Section Parameters ............................................... 28
`Document Mapping ..... . ..... . ...... ..... . . ............... . ......... . ... 29
`Redirect Mapping ....................................................... .3 1
`CGI Mapping ............................................................ 32
`Content Type Mapping ............. . ... . .............. . ........... ... .... . 33
`Logging Section Parameters ................................................ 36
`LESSON 3: INSTALLING THE SAMPLE APPLICATIONS ............................ .37
`The GuestBook Application ....... . ... .... ................................ .38
`The On-Line Questionnaire ............................................... .39
`LESSON 4: SIGNING THE GUEST BOOK ............. . .......................... .40
`LESSON 5: VIEWING THE GUEST BOOK ............. . . . ........................ .42
`LESSON 6: DISPLAYING RECENT ENTRIES OF THE GUEST BOOK ................... 43
`LESSON 7: DEMONSTRATING THE ON-LINE QUESTIONNAIRE APPLICATION ...... .45
`REVIEW QUESTIONS ......................................................... .49
`EXERCISES ...................... . ........................................... .50
`
`viii
`
`ServiceNow's Exhibit No. 1017
`
`010
`
`

`
`CONTENTS
`
`. ....................... . . 51
`3 DISSECTING A JOB LISTING SYSTEM
`LESSON I: ADDING A N EW COMPANY IN THE JOB LISTING SYSTEM ........... . . .54
`LESSON 2: ADDING JOBS IN THE JOB LISTING SYSTEM ...... , ...... .. ............ 57
`Listing the First Job .. . ............ ... . .. ... .. ........... . ................ . 58
`Listing the Second Job
`. ............... . ... . . ...... . ......... . .... . ........ 60
`Points to Note on Adding Jobs ............. .. .. . ........................... 61
`LESSON 3: FINDING JOBS USING KEYWORD SEARCH ................... .. ....... 62
`LESSON 4: FINDING JOBS USING DRILL-DOWN SEARCH ... . . . .......... . .... . ... 69
`LESSON 5: PERFORMING SQL-BASED SEARCHES ........... . . . .... . ..... ... .. .. . . 70
`DYNAMICS OF THE JOB LISTING SYSTEM ................. ... . . ....... . ... .. .. .. 72
`LESSON 6: UNDERSTANDING THE ROLE OF THE WEB BROWSER .. . .............. 72
`Passing User Requests ............... . . . .... . .......... . . .. . ............... 72
`Passing User Data ................... . ........... . ...... . ............. . .. .73
`Showing Server Response ................................. . . .. . ...... . .... 75
`LESSON 7: UNDERSTANDING THE ROLE OF THE WEB SERVER .... . ... . ........... 75
`Primary Function of A Web Server ......... . ................ . .. . . . . ......... 75
`