Unix平台下的数据库查询开发工具（Web-DTools）的设计与实现
摘要
在企业级用户服务器操作系统中,如金融、电信、政府等部门,基于安全性、稳定性的Unix系统几乎一统天下。简洁、高效、安全是Unix的文化哲学,但同样,以命令行、字符界面为特征的操作方式,也提高了操作者的门槛。Web方式是基于超文本协议、CGI接口、图形化和易于导航的流行查询方式,客户容易接受。对服务器而言,数据查询是频繁而又重要的职能。所谓Web-DTools是指一个用于查询的界面函数库,只要写简单的几句话马上就可以生成对表数据的Web交互查询动态页面。
本文研究的目的就是设计一种工具软件,通过Web动态方式实现对架设在Unix平台上的数据库查询。本文研究的思路是通过表结构描述脚本,直接生成CGI (公共网关界面)的C语言源码,然后编译生成CGI,实现数据库的动态访问。本文着重从脚本翻译、Web界面、数据库接口等三个方面进行了分析与设计,并通过实例来说明具体实现方法。
The UNIX system that based on security and stability almost dominate the world in the enterprise server operating systems, such as finance, telecommunications, government and other departments. The culture of UNIX philosophy is Simple, efficient and safe, but also, the mode of operation which characterized by the command line and character interface increased the threshold for the operator. The client is easy to accept Web which based on hypertext protocol, CGI interface, graphical and easy way to navigate popular queries. For the server, the data query is frequent and important functions. The so-called Web-DTools is one interface function library for the query, with writing a few sentences, so immediately generate Web interactive query dynamic pages of table data.
The purpose of this study is to design a software tool to achieve database queries through the Web dynamically which set up in the UNIX platform. The idea of this paper is that through the table schema describe script, then directly generate CGI (Common Gateway Interface) of the C language source code, and then compiled CGI, to achieve dynamic access of database. This article focuses on the three aspects which include script translation, Web interface, and database interface to analysis and design, and uses example to illustrate the specific implementation.
本文研究的目的就是设计一种工具软件,通过Web动态方式实现对架设在Unix平台上的数据库查询。本文研究的思路是通过表结构描述脚本,直接生成CGI (公共网关界面)的C语言源码,然后编译生成CGI,实现数据库的动态访问。本文着重从脚本翻译、Web界面、数据库接口等三个方面进行了分析与设计,并通过实例来说明具体实现方法。
The UNIX system that based on security and stability almost dominate the world in the enterprise server operating systems, such as finance, telecommunications, government and other departments. The culture of UNIX philosophy is Simple, efficient and safe, but also, the mode of operation which characterized by the command line and character interface increased the threshold for the operator. The client is easy to accept Web which based on hypertext protocol, CGI interface, graphical and easy way to navigate popular queries. For the server, the data query is frequent and important functions. The so-called Web-DTools is one interface function library for the query, with writing a few sentences, so immediately generate Web interactive query dynamic pages of table data.
The purpose of this study is to design a software tool to achieve database queries through the Web dynamically which set up in the UNIX platform. The idea of this paper is that through the table schema describe script, then directly generate CGI (Common Gateway Interface) of the C language source code, and then compiled CGI, to achieve dynamic access of database. This article focuses on the three aspects which include script translation, Web interface, and database interface to analysis and design, and uses example to illustrate the specific implementation.
引文
[1]吴迪文, WWW数据库系统信息集成技术,微机发展,No.1,1999.
[2]刘军等,基于Web的交互式数据库查询技术,微机发展,No.4,1999.
[3]王佑中著,Web动态技术入门,机械工业出版社,1997.1
[4] (美)Don Gaspar著,杨晓云,王建桥译,用C++开发Web商用程序,机械工业出版社,1998.6.
[5] Alberto Mendelzon and Tova Milo,Formal Models of the Web,in Proceedings of the Sixteenth ACM Symposium on Principles of Databasse System,May 1997
[6] Alberto Mendelzon,George Mihaila,Tova Milo,Querying the World Wide Web,Journal of Digital Libraries1(1),1997:68-88
[7] Daniela Florescu,Alon Levy and Alberto Mendelzon, Database Techniques for the World Wide Web:A Survey,ACM SIGMOD Record 27:3,1998,9:59-74
[8] Alberto Mendelzon,The Web is not a database,slides from a presentation at the Workshop on internet Data Management,Washington,1998,11
[9] roman b.melnyk,paul c.zikopoulos(著),袁勤勇何欣贾颖(译),《DB2技术参考大全》,清华大学出版社
[10]刘树春徐延明于德海著,《用Apache建立Web站点》作者:等,电子工业出版
[11]徐捷,《Informix系统应用指南》,电子工业出版社,2000
[12] Marc J.Rochkind,《Unix环境高级编程》,人民邮电出版社,2006
[13]东方龙马版,《informix Esql/c开发手册》,2001
[14]《CGI开发使用手册》机械工业出版社,2005
[15]东方龙马版,《informix sql开发手册》,2001
[16] David Tansley著徐焱张春萌等译,《LINUX和UNIX SHELL编程指南》,机械工业出版社,2000.6
[2]刘军等,基于Web的交互式数据库查询技术,微机发展,No.4,1999.
[3]王佑中著,Web动态技术入门,机械工业出版社,1997.1
[4] (美)Don Gaspar著,杨晓云,王建桥译,用C++开发Web商用程序,机械工业出版社,1998.6.
[5] Alberto Mendelzon and Tova Milo,Formal Models of the Web,in Proceedings of the Sixteenth ACM Symposium on Principles of Databasse System,May 1997
[6] Alberto Mendelzon,George Mihaila,Tova Milo,Querying the World Wide Web,Journal of Digital Libraries1(1),1997:68-88
[7] Daniela Florescu,Alon Levy and Alberto Mendelzon, Database Techniques for the World Wide Web:A Survey,ACM SIGMOD Record 27:3,1998,9:59-74
[8] Alberto Mendelzon,The Web is not a database,slides from a presentation at the Workshop on internet Data Management,Washington,1998,11
[9] roman b.melnyk,paul c.zikopoulos(著),袁勤勇何欣贾颖(译),《DB2技术参考大全》,清华大学出版社
[10]刘树春徐延明于德海著,《用Apache建立Web站点》作者:等,电子工业出版
[11]徐捷,《Informix系统应用指南》,电子工业出版社,2000
[12] Marc J.Rochkind,《Unix环境高级编程》,人民邮电出版社,2006
[13]东方龙马版,《informix Esql/c开发手册》,2001
[14]《CGI开发使用手册》机械工业出版社,2005
[15]东方龙马版,《informix sql开发手册》,2001
[16] David Tansley著徐焱张春萌等译,《LINUX和UNIX SHELL编程指南》,机械工业出版社,2000.6