14

1

Chapter 14

Database Connectivity and Web Development

Database Systems: Design, Implementation, and Management, Seventh

Edition, Rob and Coronel

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

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

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

3

Extensible Markup Language (XML)

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

4

Document Type Definitions (DTD) and XML Schemas

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

5

Document Type Definitions (DTD) and XML Schemas (continued)

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

6

Document Type Definitions (DTD) and XML Schemas (continued)

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

7

Document Type Definitions (DTD) and XML Schemas (continued)

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

8

XML Presentation

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

9

XML Presentation (continued)

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

10

XML Presentation (continued)

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

11

XML Applications

• B2B exchanges

• Legacy systems integration

• Web page development

• Database support

• Database metadictionaries

• XML databases

• XML services

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

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

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

14

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

Database Systems: Design, Implementation, & Management, 7 th Edition, Rob & Coronel

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 boundaries