ADBMS CHAPTER 5: DATABASE CONNECTIVITY AND WEB TECHNOLOGIES

Refers to the mechanisms through which application programs connect and communicate with data repositories.

• Database Connectivity

• Database Middleware

• Data Repository

• Universal Data Access

Provides an interface between the application program and the database.

• Database Connectivity

• Database Middleware

• Data Repository

• Universal Data Access

Data management application used to store data generated by an application program

• Database Connectivity

• Database Middleware

• Data Repository

• Universal Data Access

A collection of technologies used to access any type of data source and manage data through a common interface

• Database Connectivity

• Database Middleware

• Data Repository

• Universal Data Access

Database Internet Connectivity allows new innovative services that:

• Permit rapid response by bringing new services and products to market quickly.

• Increase customer satisfaction through the creation of web-based support services.

• Allows anywhere, anytime data access using mobile smart devices via the Internet.

• Yield fast and effective information dissemination through universal access.

Characteristics and Benefits of Internet Technologies

• Hardware and Software Independence

• Common and Simple User Interface

• Location Independence

• Rapid Development at Manageable Cost

• Near Infinite Resources for Infrastructure

Cloud computing-based data management service

• SQL Data Services

• Database Connectivity

• Web-to-Database Middleware

• Open Database Connectivity (ODBC)

The main hub through which Internet services are accessed.

• SQL Data Services

• Database Connectivity

• Web-to-Database Middleware

• Open Database Connectivity (ODBC)

Microsoft’s implementation of a superset of SQL Access Group.

• SQL Data Services

• Database Connectivity

• Server-side extension

• Open Database Connectivity (ODBC)

Program that interacts directly with the web server.

• SQL Data Services

• Database Connectivity

• Server-side extension

• Open Database Connectivity (ODBC)