Patent ID: 8140558
Filing Date: 2012-03-20
Classification: G06F

Abstract:
1. A method, in a data processing system, for generating Structured Query Language/Extensible Markup Language (SQL/XML) statements, the method comprising: receiving, by an SQL/XML generation module, an SQL statement wherein the SQL statement is expressed in terms of logical data items that are exposed by exposing a set of mapping tables that list names of the logical data items together with information about the logical data items; parsing and analyzing, by the SQL/XML generation module, the SQL statement; generating, by the SQL/XML generation module, based on a main mapping table and a namespace mapping table, a set of XMLQUERY functions, a set of XMLTABLE functions, and a set of XMLEXISTS predicates to retrieve, filter, or update at least one of XML documents or relational data; generating, by the SQL/XML generation module, at least one SQL/XML statement from parts of the SQL statement and the generated set of XMLQUERY functions, the set of XMLTABLE functions, and the set of XMLEXISTS predicates, wherein the at least one SQL/XML statement is substantially equivalent in functionality to the SQL statement; and sending, by the SQL/XML generation module, the at least one SQL/XML statement to a database engine for execution.