02010_ch14 - Database Systems: Design, Implementation, and...

Info iconThis preview shows pages 1–13. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Systems: Design, Implementation, and Management Eighth Edition Chapter 14 Database Connectivity and Web Technologies
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 2 Objectives In this chapter, you will learn: Different database connectivity technologies How Web-to-database middleware is used to integrate databases with the Internet Web browser plug-ins and extensions Services provided by Web application servers What Extensible Markup Language (XML) is and why it is important for Web database development
Background image of page 2
th 3 Database Connectivity Mechanisms by which application programs connect and communicate with data sources Also known as database middleware Data repository: Also known as a data source Represents the data management application Used to store data generated by an application program ODBC, OLE-DB, ADO.NET: the backbone of MS Universal Data Access ( UDA ) architecture
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 4 Native SQL Connectivity Connection interface provided by database vendors Unique to each vendor Example: Oracle RDBMS Must install and configure Oracle’s SQL*Net interface in client computer Interfaces optimized for particular vendor’s DBMS Maintenance is a burden for the programmer
Background image of page 4
th 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 6 ODBC, DAO, and RDO Open Database Connectivity ( ODBC ) Microsoft’s implementation of a superset of SQL Access Group Call Level Interface ( CLI ) Widely supported database connectivity interface Any Windows application can access relational data sources Uses SQL via standard application programming interface ( API )
Background image of page 6
th 7 ODBC, DAO, and RDO (continued) Data Access Objects ( DAO ) Object-oriented API Accesses MS Access, MS FoxPro, and dBase databases from Visual Basic programs Provided an optimized interface that exposed functionality of Jet data engine to programmers DAO interface can also be used to access other relational style data sources
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 8 ODBC, DAO, and RDO (continued) Remote Data Objects ( RDO ) Higher-level object-oriented application interface used to access remote database servers Uses lower-level DAO and ODBC for direct access to databases Optimized to deal with server-based databases, such as MS SQL Server, Oracle, and DB2 Implemented as shared code dynamically linked to Windows via dynamic-link libraries
Background image of page 8
th 9
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 10 ODBC, DAO, and RDO (continued) Basic ODBC architecture has three main components: High-level ODBC API through which application programs access ODBC functionality Driver manager that is in charge of managing all database connections ODBC driver that communicates directly to DBMS
Background image of page 10
th 11
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
th 12
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.

Page1 / 50

02010_ch14 - Database Systems: Design, Implementation, and...

This preview shows document pages 1 - 13. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online