Database-independent query language based on XML statements

Abstract

The invention discloses a database-independent query language based on XML (Extensive Markup Language) statements. A middle-layer language of the XML statement-based database query comprises a FitchXML grammar definition device, a FitchXML analyzer, a FitchXML syntax analyzer, a FitchXML security filter, a converter from FitchXML to standard SQL, and a dialect translator. According to the XML statement-based database, the development cost can be greatly reduced, the language learning amount of developers can be reduced, meanwhile, the development system can natively adapt to various differentrelational databases, a client side can select and use one of a plurality of databases such as an SQL Server, an Oracle, a MySQL and a Postgresql to complete development tasks, the development systemcan shield the security risk in SQL language development and can completely eradicate the risk of SQL injection, a new query language developed on the basis of XML and SQL of the industry standard canreduce the learning cost of personnel, and the learning difficulty of the personnel can be greatly reduced compared with the Entity Framework and other development modes.

Description

technical field [0001] The invention belongs to the related technical field of NET database development, and in particular relates to a database-independent query language based on XML statements. Background technique [0002] The unified query language of the existing relational database is the international standard SQL language. This language was originally invented by IBM. There are standards such as SQL92 and SQL99. At the same time, many different manufacturers have implemented their own products for the standard SQL language, such as Microsoft. TSQL for the SQL Server database, PL / SQL for the Oracle database, MySQL database, PostgreSQL, etc. [0003] The existing native SQL method for development has the following problems: [0004] 1. If you want to develop and adapt to different database products, you often need to write different SQL according to the characteristics of each database (SQL Server, Oracle, MySQL), resulting in a large number of similar code problems ...

AI Technical Summary

Problems solved by technology

[0004] 1. If you want to develop and adapt to different database products, you often need to write different SQL according to the characteristics of each database (SQL Server, Oracle, MySQL), resulting in a large number of similar code problems in the same business logic

[0005] 2. If you develop for a single database system (such as MySQL), if the client wants to choose other different data, you need to spend a lot of development costs for migration and adaptation

[0006] 3. The .NET platform also has some other solutions to solve the adaptation problem of multiple databases, such as EntityFramework, etc., but this solution requires a higher version of .NET and requires a lot of modification of the existing code

[0007] 4. Directly using native SQL statements still has the security risk of SQL injection