– Part III
3
Chapter 29 Web Technology and DBMSs
Review Questions
29.1 Discuss each of the following terms:
(a) Internet, intranet, and extranet. See start of Section 29.1 and 29.1.1
29.2 What are Web services. Give some examples of Web services.
29.3 Discuss the advantages and disadvantages of the Web as a database platform.
4
29.4 Describe the Common Gateway Interface and server extensions, as approaches for integrating
databases onto the Web.
29.5 Describe how cookies can be used to store information about a user.
A cookie is a piece of information that the client stores on behalf of the server. The
onse
29.6 Discuss the following approaches to persistence:
(a) Container-Managed Persistence (CMP).
(b) Bean-Managed Persistence.
(c) JDBC.
JDBC is a low-level middleware tool that provides basic features to interface a Java
(d) SQLJ.
SQLJ is based on static embedded SQL while JDBC is based on dynamic SQL. Thus, SQLJ
– Part III
5
(e) JDO.
JDO is another Java-based persistence mechanism, derived from the ODMG Java binding.
The development of JDO had two major aims:
29.7 Discuss the differences between ASP and JSP.
Both technologies are not that dissimilar. Both are designed to enable developers to separate
page design from programming logic through the use of callable components, and both
provide an alternative to CGI programming that simplifies Web page development and
deployment. However, there are differences:
Platform and server independence
29.8 Discuss the differences between ADO and ADO.NET.
ADO is a programming extension to ASP supported by Microsoft IIS for database
connectivity, designed as an easy-to-use API to OLE DB.
ADO.NET is the next version of ADO with new classes that expose data access services to the
– Part III
29.9
Exercises
29.10 Examine the Web functionality provided by any DBMS that you currently use. Compare the
functionality of your system with the approaches discussed in Section 29.3 to 29.9.
29.11 Examine the security features provided by the Web interface to your DBMS. Compare these
features with the features discussed in Section 20.5.
29.12 Using an approach to Web-DBMS integration, create a series of forms that display the base
tables of the DreamHome case study.
29.13 Extend the implementation of Exercise 29.12 to allow the base tables to be updated from the
Web browser.
29.14 Create web pages to display the results of the queries given in Appendix A for DreamHome.
29.15 Repeat Exercises 29.12 and 29.14 for the Wellmeadows case study.
29.16 Create web pages to display the results of the queries given in Chapter 6 Exercise 6.7 6.28.
– Part III
7
29.17 Using any Web browser, look at some of the following Web sites and discover the wealth of
information held there.
29.18 You have been asked by the Managing Director of DreamHome to investigate and prepare a
report on the feasibility of making the DreamHome database accessible from the Internet. The
report should examine the technical issues, the technical solutions, address the advantages
and disadvantages of this proposal, and any perceived problem areas. The report should
contain a fully justified set of conclusions on the feasibility of this proposal for DreamHome.