Requirements for Web-DBMS Integration

While many DBMS vendors are working to provide proprietary database connectivity solutions for the Web, most organizations require a more general solution to prevent them from being tied into one technology. In this section, we briefly list some of the most important requirements for the integration of database application, with the web. These requirements are ideals and not fully achievable at the present time, and some may need to be traded-off against other. The requirements are as follows :

• The ability to access valuable corporate data in the secure manner.
• Data and vendor independent connectivity to allow freedom of choice in the selection of the DBMS now and in the future.
• The ability to interface to the database independent of any proprietary Web browser or Web server.
• A connectivity solution that takes advantage of all the features of an organization’s DBMS.
• An open-architecture approach to allow interoperability with a variety of system and technologies.
• A cost-effective solution that allows for scalability, growth, and changes in strategic directions, and helps reduce the costs of developing and maintaining applications.
• Support for transactions that span multiple HTTP requests.
• Support for session and application-based authentication.
• Acceptable performance.
• Minimal administration overhead.
• A set of high-level productivity tools to allow applications to be developed and deploy with relative case and speed.