Chapter 14 Database Connectivity and Web Development Database Systems: Design, Implementation, and Management, Seventh Edition, Rob and Coronel 1

14

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, 7 th Edition, Rob & Coronel 2

Extensible Markup Language (XML)

14

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

Document Type Definitions (DTD) and XML Schemas

14

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

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

14

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

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

14

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

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

14

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

XML Presentation

14

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

XML Presentation (continued)

14

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

XML Presentation (continued)

14

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

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 11

14

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, 7 th Edition, Rob & Coronel 12

14

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 13

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

14

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