Automated interactive visual mapping utility and method for validation and storage of XML data
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.
1. A method for automatic validation of Extensible Markup Language (XML) data through interactive visual mapping comprising:
a user interacting with a graphic user interface (GUI) to validate a plurality of XML document fragments before storing validated XML data corresponding with the plurality of XML document fragments during an update or insert operation into any of a plurality of target destinations, wherein
the plurality of target destinations comprise at least a plurality of XML columns of a plurality of database tables residing in a plurality of databases of a heterogeneous relational database management system, wherein
user interactions are performed on a client, wherein
the GUI is configured to allow the user to select any of the plurality of XML document fragments and any of the plurality of target destinations, wherein
the XML document fragments comprise a plurality of lines of XML code, wherein
the XML document fragment is selected by drawing a box around the plurality of lines of XML code, wherein
the GUI automatically calculates an end tag and XPath of the selected XML document fragment, wherein
the GUI concurrently displays the selected XML document fragment with validation information corresponding with the selected XML document fragment and the selected target destination, wherein
the selected target destination is a data store, wherein
the selected target destination is not previously connected with the selected XML document fragment, wherein
the validated XML data includes a database object declared as XML format type, wherein
the GUI is further configured to obtain a mapping of the selected XML document fragment and the selected target destination through at least one XML validation schema selected by the user, the at least one XML validation schema registered with the target destination, and to perform automatic XML data validations of the selected XML document fragment, and wherein
the user interactions with the GUI automatically generate a user generated XML validation mapping definition document, the XML mapping definition document containing a user's validation mapping specifications and a validation code for commanding the automatic XML data validations, such that the selected XML document fragment is mapped to the selected target destination.
2. The method according to claim 1 , wherein the XML validation schema is represented with its namespace.
3. The method according to claim 1 , wherein the GUI is menu-driven.
4. The method according to claim 3 , wherein the GUI displays a window with the XML data in native format and a selection of the XML validation schemas.
5. The method according to claim 1 , wherein the generated XML validation mapping definition document comprises a programming language of the validation code, a type and name of the XML document fragment and locations of the one or more user selected target destinations and the XML validation schema.
6. The method according to claim 5 , wherein the validation code programming language is selected from the group consisting of a Structured Query Language (SQL) script, C# code, Java code, Virtual Basic code, Hypertext Preprocessor code, and C++ code.
7. The method according to claim 1 , wherein:
the validated XML data is stored in the one or more user selected target destinations selected from the group consisting of an XML column of a database table, a web service call, a standalone application call, a function's input parameter of XML type, a stored procedure's input or input/output parameter of XML type, and a heterogeneous Relational Database Management System (RDBMS) environment.
8. A system of computer hardware that uses a computer hardware enabled network for automatic validation of Extensible Markup Language (XML) data through interactive visual mapping-comprising:
a processor;
a user interactive validation utility having a graphic user interface (GU) the user interactive validation utility configured to validate a plurality of XML document fragments before storing validated XML data stored in the plurality of XML document fragments during an update or insert operation into one or more user selected target destinations, wherein
the plurality of target destinations comprise at least a plurality of XML columns of a plurality of database tables residing in a plurality of databases of a heterogeneous relational database management system, wherein
the user interactive validation utility resides on a client, wherein
user interactions are performed on the client, wherein
the GUI is configured to allow the user to select any of the plurality of XML document fragments and the one or more user selected target destinations, wherein
the XML document fragments comprise a plurality of lines of XML code, wherein
the XML document fragment is selected by drawing a box around the plurality of lines of XML code, wherein
the GUI automatically calculates an end tag and XPath of the selected XML document fragment, wherein
the GUI concurrently displays the selected XML document fragment with validation information corresponding with the selected XML document fragment and the selected target destination, wherein
the one or more user selected target destinations are data stores, wherein
the target destination is not previously connected with the selected XML document fragment, wherein
the validated XML data includes a database object declared as XML format type, wherein
the GUI is further configured to obtain a mapping the selected XML document fragment and the one or more user selected target destinations through at least one XML validation schema, selected by the user, the at least one XML validation schema registered with the one or more user selected target destinations, and to perform automatic XML data validations of the selected XML document fragment such that the selected XML document fragment is mapped to each of the one or more user selected target destinations, wherein
the user interactions with the GUI automatically generate a user generated XML validation mapping definition document, the XML mapping definition document containing a user's validation mapping specifications, and a validation code for commanding the automatic XML data validations such that the selected XML document fragment is mapped to the selected target destination.
9. The system according to claim 8 , wherein the XML validation schema is represented with its namespace.
10. The system according to claim 8 , wherein the GUI is menu-driven.
11. The system according to claim 10 , wherein the GUI displays a window with the XML data in native format and a selection of the XML validation schemas.
12. The system according to claim 8 , wherein the generated XML validation mapping definition document comprises a programming language of the validation code, a type and name of the XML document fragment and locations of the one or more user selected target destinations and the XML validation schema.
13. The system according to claim 12 , wherein the validation code programming language is selected from the group consisting of a Structured Query Language (SQL) script, C# code, Java code, Virtual Basic code, Hypertext Preprocessor code, and C++ code.
14. The system according to claim 8 , wherein:
the validated XML data is stored in the one or more user selected target destinations selected from the group consisting of an XML column of a database table, a web service call, a standalone application call, a function's input parameter of XML type, a stored procedure's input or input/output parameter of XML type, and a heterogeneous Relational Database Management System (RDBMS) environment.
15. A computer program product for automatic validation of Extensible Markup Language (XML) data through interactive visual mapping using a computer, the computer program product comprising:
a non-transitory tangible computer usable medium tangibly storing programmatic instructions, wherein the programmatic instructions comprise:
first programmatic instructions for obtaining a mapping of a plurality of XML document fragments and one or more user selected target destinations through at least one XML validation schema selected by a user and to perform automatic XML data validations of the plurality of XML document fragments during an update or insert operation into any of a plurality of target destinations, wherein
the one or more user selected target destinations comprise at least a plurality of XML columns of a plurality of database tabes residing in a plurality of databases of a heterogeneous relational database management system, wherein
the target destination is not previously connected with the selected XML document fragment, wherein
the validated XML data includes a database object declared as XML format type, wherein
the at least one XML validation schema is registered with the one or more user selected target destinations,
according to a user's interactions with a graphic user interface (GUI) before storing validated XML data to the one or more user selected target destinations, wherein
user interactions with the GUI are performed on a client, wherein
the XML document fragments comprise a plurality of lines of XML code, wherein
the XML document fragment is selected by drawing a box around the plurality of lines of XML code, wherein
the GUI automatically calculates an end tag and XPath of the selected XML document fragment, wherein
the GUI concurrently displays the selected XML document fragment with validation information corresponding with the selected XML document fragment and the selected target destination, and wherein
the user interactions with the GUI automatically generates a user generated XML validation mapping definition document, the XML mapping definition document containing a user's validation mapping specifications, and a validation code for commanding the automatic XML data validations such that the selected XML documents fragment is mapped to each of the one or more user selected target destinations.
16. The computer program product according to claim 15 , wherein the XML validation schema is represented with its namespace.
17. The computer program product according to claim 15 , wherein the GUI is menu-driven.
18. The computer program product according to claim 17 , wherein the GUI displays a window with the XML data in native format and a selection of the XML validation schemas.
19. The computer program product according to claim 15 , wherein the generated XML validation mapping definition document comprises a programming language of the validation code, a type and name of the XML document fragment and locations of the one or more user selected target destinations and the XML validation schema.
20. The computer program product according to claim 19 , wherein the validation code programming language is selected from the group consisting of a Structured Query Language (SQL) script, C# code, Java code, Virtual Basic code, Hypertext Preprocessor code, and C++ code.
21. The computer program product according to claim 15 , wherein:
the validated XML data is stored in the one or more user selected target destinations selected from the group consisting of an XML column of a database table, a web service call, a standalone application call, a function's input parameter of XML type, a stored procedure's input or input/output parameter of XML type, and a heterogeneous Relational Database Management System (RDBMS) environment.