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