1
Chapter 12
Database Connectivity and Web
Development
Database Systems:
Design, Implementation, and Management,
Seventh Edition, Rob and Coronel
2
2
In this chapter, you will learn:
About the different database connectivity
technologies
How Web-to-database middleware is used to
integrate databases with the Internet
The first steps in building a Web-based
database front end using Macromedia
ColdFusion
What Extensible Markup Language (XML) is and
why it is important for Web database
development
3
3
Database Connectivity
Refers to mechanisms through which
application programs connect and
communicate with data repositories
Database connectivity software is also
known as database middleware
Data repository, also known as data
source, represents the data management
application that will be used to store data
generated by application program
4
4
Native SQL Connectivity
Refers to connection interface that is
provided by database vendor and is
unique to that vendor
Best example of that type of native
interface is Oracle RDBMS
To connect client application to Oracle
database, you must install and configure
Oracle’s SQL*Net interface in client computer
5
5
Native SQL Connectivity (continued)
6
6
ODBC, DAO, and RDO
Open Database Connectivity (ODBC)
Microsoft’s implementation of a superset of
SQL Access Group Call Level Interface (CLI)
standard for database access
Probably most widely supported database
connectivity interface
Allows any Windows application to access
relational data sources, using SQL via standard
application programming interface (API)
7
7
ODBC, DAO, and RDO (continued)
Data Access Objects (DAO)
Object-oriented API used to access 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
8
8
ODBC, DAO, and RDO (continued)
Remote Data Objects (RDO)
Higher-level object-oriented appl