DaMeng Database Management System Web Service Research

As web service technology developed, integrating database management system with web service can use database's data storage and management ability to provide its data to other web applications in the form of web service, or consume other web service. In order to catch up with the development of database technology, we need extend the functions of DM in web service to improve its competitiveness.DM database web service is divided into to two parts: one is database providing web service, the other is database consuming web service. Database providing web service lets user can provide web service with SQL statement or stored procedure, so that other applications can invoke this web service to use the data. On the other side, DM database consumes web service lets user can invoke other application's web service with SQL statement.DM database providing web service refers DB2 database providing web service's structure. The kernel of DM database providing web service is DM database web service engine. It implements resolving user's web service request, and mapping SQL statement and stored procedure to web services, so that DM database can provide it's SQL and stored procedure as web service. We also implement a set of management tools, user can use these tools create, drop or deploy their web services.DM database providing web service extends DM database's kernel engine. We add new data dictionary and new SQL statements. The core of the system is constructing the message of invoking web service and binding it with HTTP request. After receiving the web service's return message, parsing the data and construct as result set. In order to improve the efficiency of invoking web service, we use connection pool to store the connection to web service providers.