Scenario

After a patient receives treatments from a health care provider, he/she is billed with the expenses incurred. As directed by the patient, the invoice can be directed to the appointed insurance company for medical expense claims. Assume that the insurance company has not deployed their XML solution, all data is stored in relational data format. This requires a data massaging process to convert XML data (from health care provider) into relational (for the insurance company).

Operation

Annotated schema decomposition makes this easy. The process shreds an XML document into relational data.

The following are the steps involved in annotated schema decompostion



Solution

The patient information after the complete treatment from the health care provider with address is sent to the insuranace company where it is shredded and dumped to the database of the insurance company in the relational format.

The result of the XML data shreded can be viewed in the result tab.





Best Practices