140 likes | 254 Views
Chapter 14. Database Connectivity and Web Development Database Systems: Design, Implementation, and Management, Seventh Edition, Rob and Coronel. The Web as a Stateless System.
E N D
Chapter 14 Database Connectivity and Web Development Database Systems: Design, Implementation, and Management, Seventh Edition, Rob and Coronel
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
Extensible Markup Language (XML) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel
Document Type Definitions (DTD) and XML Schemas Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel
Document Type Definitions (DTD) and XML Schemas (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel
Document Type Definitions (DTD) and XML Schemas (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel
Document Type Definitions (DTD) and XML Schemas (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel
XML Presentation Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel
XML Presentation (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel
XML Presentation (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel
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
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
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, 7th Edition, Rob & Coronel
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