Database Connectivity and Web Development

1
Chapter 14

• Database Connectivity and Web Development
• Database Systems Design, Implementation, and
  Management, Seventh Edition, Rob and Coronel

2
The Web as a Stateless System

• Stateless system indicates that at any given
  time, Web server does not know status of any of
  clients communicating with it
• Client and server computers interact in very
  short conversations that follow request-reply
  model

3
Extensible Markup Language (XML)
4
Document Type Definitions (DTD) and XML Schemas
5
Document Type Definitions (DTD) and XML Schemas
(continued)
6
Document Type Definitions (DTD) and XML Schemas
(continued)
7
Document Type Definitions (DTD) and XML Schemas
(continued)
8
XML Presentation
9
XML Presentation (continued)
10
XML Presentation (continued)
11
XML Applications

• B2B exchanges
• Legacy systems integration
• Web page development
• Database support
• Database metadictionaries
• XML databases
• XML services

12
Summary

• Database connectivity refers to the mechanisms
  through which application programs connect and
  communicate with data repositories
• Microsoft database connectivity interfaces are
  dominant players in the market and enjoy the
  support of most database vendors
• Native database connectivity refers to the
  connection interface that is provided by the
  database vendor and is unique to that vendor

13
Summary (continued)

• Object Linking and Embedding for Database
  (OLE-DB) is a database middleware developed with
  the goal of adding object-oriented functionality
  for access to relational and nonrelational data
• Database access through the Web is achieved
  through database-to-middleware software

14
Summary (continued)

• ColdFusion is a Web application server that
  provides database access (among other services)
  to the Web
• Extensible Markup Language (XML) facilitates the
  exchange of B2B and other data over the Internet
• XML provides the semantics that facilitates the
  exchange, sharing, and manipulation of structured
  documents across organizational boundaries