Research And Implementation Of Filtration Systems Based On SQL Semamtics

With the development of computer networks, database security issues become increasingly important. In order to increase database security of inter-network access, the security filter system which is based on RMIJDBC and proxy technology has been realized in the paper. This system can realize the filter based on IP, port, MAC, protocol and SQL semantic,and support common database products. It has a good general.In this paper, the SQL parser program has been implemented on the research of syntax analysis tools Flex and analysis tools Bison. SQL statement is analyzed through the parser program, and then forming a QueryTree containing the full semantic information of the SQL statement. Then the SQL security filtering program is designed. Finally, the SQL security filtering based on IP, port, MAC, protocol and SQL semantic is realized. In order to increase security of inter-network access to the database application system,the Security Filtration Systems is proposed.In order to increase security of inter-network access to the database application system,the security filtration systems is proposed. In the paper the module design of the security filter system is described. The function and characters of the security filter system are narrated.Which is emphasized in the paper is the implementation of SQL security filter in the security filtration system.In this paper, the electricity market operation system is used as an example for the use of the security filtration systems. the security filtration systems implements isolation both inside and outside the network in electricity market operation system,and effectively protects the intranet database security in aspects of address information security filtering and SQL security filter.The tests of state departments have proved:security filtering system based in SQL semantics can fliter SQL statement based on content, raised the security of inter-network database application system access...