1
Chapter 12
Database Connectivity and Web
Development
Database Systems:
Design, Implementation, and Management,
Seventh Edition, Rob and Coronel
2
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
3
Extensible Markup Language
(XML)
4
4
Document Type Definitions
(DTD) and XML Schemas
5
5
Document Type Definitions (DTD)
and XML Schemas (continued)
6
6
Document Type Definitions (DTD)
and XML Schemas (continued)
7
7
Document Type Definitions (DTD)
and XML Schemas (continued)
8
8
XML Presentation
9
9
XML Presentation (continued)
10
10
XML Presentation (continued)
11
11
XML Applications
• B2B exchanges
• Legacy systems integration
• Web page development
• Database support
• Database metadictionaries
• XML databases
• XML services
12
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
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
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