Learning Objectives (如何連結資料庫)
In this chapter, students will learn:
- About various database connectivity technologies
- How Web-to-database middleware is used to integrate databases with the Internet
- About Web browser plug-ins and extensions
- What services are provided by Web application servers
- What Extensible Markup Language (XML) is and why it is important for Web database development
- About cloud computing and how it enables the database-as-a-service model
Database Connectivity (連結後端的API界面)
- Database middleware: Provides an interface between the application program and the database
- Data repository - Data management application used to store data generated by an application program
- A standard database connectivity interface is necessary for enabling applications to connect to data repositories
- Universal Data Access (UDA): Collection of technologies used to access any type of data source and manage the data through a common interface
- ODBC, OLE-DB, ADO.NET form the backbone of MS UDA architecture
Native SQL Connectivity
- Connection interface provided by database vendors, which is unique to each vendor
- Interfaces are optimized for particular vendor’s DBMS
- Maintenance is a burden for the programmer
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 (大部分共同遵守的API interface準則)
- Widely supported database connectivity interface
- Allows Windows application to access relational data sources by using SQL via standard application programming interface (API)
- ODBC was the first widely adopted database middleware standard, and it enjoyed rapid adoption in Windows applications