Abstract: A method, apparatus and computer program product is provided for automatic validation of Extensible Markup Language (XML) data through interactive visual mapping, before storing the validated XML data into a target destination. The method allows a user to interact with a graphic user interface (GUI) to obtain mapping of an XML source document or its fragment and the target destination through at least one XML validation schema, and to automatically obtain XML data validations. The GUI is menu-driven and displays the XML data in the native format and a selection of the XML validation schemas. Interactions with the GUI automatically generate an XML validation mapping definition document and a validation code. The target destination can be one or more XML columns, a web service call, a standalone application call, a function's or stored procedure's input parameter of XML type and it may be located in a heterogeneous RDBMS environment.

Abstract: A method, apparatus and computer program product is provided for automatic mapping of Extensible Markup Language (XML) data through an interactive visual mapping tool before storing the XML data into a target destination. The method uses an interactive visual mapping tool having a graphic user interface (GUI) to obtain automatic mapping of an XML source document or its fragment and the target destination. The GUI is menu-driven, displays the XML data in the native format and has several editors. Interactions with the GUI automatically generate an XML mapping definition document and a mapping code. The target destination can be one or more XML columns, a web service call, a standalone application call, a function's or stored procedure's input parameter of XML type and it may be located in a heterogeneous RDBMS environment. Before storage the XML data may be transformed with an Extensible Stylesheet Language Transformation which may be debugged.

Abstract: A method, apparatus and computer program product is provided for automatic validation of Extensible Markup Language (XML) data through interactive visual mapping, before storing the validated XML data into a target destination. The method allows a user to interact with a graphic user interface (GUI) to obtain mapping of an XML source document or its fragment and the target destination through at least one XML validation schema, and to automatically obtain XML data validations. The GUI is menu-driven and displays the XML data in the native format and a selection of the XML validation schemas. Interactions with the GUI automatically generate an XML validation mapping definition document and a validation code. The target destination can be one or more XML columns, a web service call, a standalone application call, a function's or stored procedure's input parameter of XML type and it may be located in a heterogeneous RDBMS environment.