Transcript Chapter 14

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