Research And Development Of Web Database Application System Based On WSGI Specification

Web database system is the production of the combination of web technology and database technology. It is widely used in various fields with its significant advantages, and plays an important role in enhancing the production efficiency of enterprise, improving the quality of people’s lives and changing people’s lifestyle. It is necessary to research and study the related technologies systematically for constructing a rational and efficient web database system.Based on the analysis of the web working mechanism, this paper firstly introduces and analyzes the web client technology and several commonly used web server technologies. WSGI (Web Server Gateway Interface) specification designed on the basis of CGI standard is also described in detail, including the WSGI application, server, middleware, some details of the specification and the frameworks that run on WSGI. Based on this, the paper presents and analyzes a lightweight WSGI framework for Python—Bottle. And then it gives an overview of the basic concepts for the database technology. The concept of table, index, stored procedure and trigger in the relational model are also analyzed in detail.After researching and analyzing the web and database technology systematically, this paper designs a fully functional measurement management system based on the business needs of some laboratory. It engages in research from the following several aspects:It implements the custom-built plugin named MySQLdbPlugin in the basis of the WSGI specification and Bottle framework.The plugin adds the common database initialization and business operation function to the scattered request URL decorator object.It gives modeling of the business process and the design of the system’s overall framework after analyzing the business process of measurement management.In order to guarantee information security for the system, it sufficiently analyzes the possible risks in the operation process of system and chooses the appropriate web development technology and database technology to implement the secure login to the system and the loading of working interface based on authority. It designs information recorded interface for the mailroom to record and manage the information of instruments. Simultaneously, it achieves the multi-dimensional information retrieval function, the users who have the authority of information retrieval can search the needed information or locate the target instruments according to the conditions.