Scenario

Any patient visiting a health care provider must register at the clinic. As soon as the patients personal information is provided, he moves on for consultation. Based on the consultation, the health care provider records the diagnostic details and disease description in a PMD document in XML form.

If the patient is already registered, the most recent PMD document is updated to include the diagnostic details and disease descriptions.

Due to the volume of data and nature of the business, the health care provider wants to perform data archival every quarter and keep only 9 months of data in the base table.

Operation

Solution

Three tables are created to hold details of the disease, patients personal details, and patients medical records.

Best Practices