HTTPs data transport for remote SQL.

摘要

This project created a new database communication method for connecting traditional desktop applications to remote databases. This project addresses a need for local applications to communicate faster and more directly with large remote databases over the Internet than current connection methods. This new method enables local applications to use SQL commands to communicate directly with a remote database.;The programming technologies used in the creation of this connectivity client were Java and Perl. The connection is done by using a Java HTTP client communicating using SSL to a web server with Perl Scripts that provide the middleware connection to the server side database. The outcome was a successful implementation of a local Java application communicating with a remote MySQL database directly using SQL statements that outperformed traditional methods. This HTTPS connectivity method was most successful when used to return record sets of less than 100. When returning record sets of greater than 100, the performance declined rapidly. This study also compared and contrasted the differences in bandwidth required by the available methods and clearly documents the impact of latency on the JDBC/ODBC connectivity methods. While the technologies used aren't new, the minimalist concept of communication resulted in a high performance connectivity method that can be used effectively on modern high-speed connections or even on legacy dialup network connections.