Xml datatype vs cdc
-
Hi, am designing a database that expedite collection of data from the insurance companies by insurance body. members are required to upload daily transaction in xml format.the insurance policy no is the primary key but other information can change. the data will be query by users. should i store the data as xml datatype or in split the column as use cdc to audit the canges or plit the column with history table . like below Field Name Data Type Policy No Var Office_Code Var Vehicle_Reg_Number Var Vehicle_Chas_Number var Vehicle_Eng_Number Var Date_Policy_Start_Date Date Date_Policy_End_Date Date Date_of_Cancellation Date or policyno var policydata xml
-
Hi, am designing a database that expedite collection of data from the insurance companies by insurance body. members are required to upload daily transaction in xml format.the insurance policy no is the primary key but other information can change. the data will be query by users. should i store the data as xml datatype or in split the column as use cdc to audit the canges or plit the column with history table . like below Field Name Data Type Policy No Var Office_Code Var Vehicle_Reg_Number Var Vehicle_Chas_Number var Vehicle_Eng_Number Var Date_Policy_Start_Date Date Date_Policy_End_Date Date Date_of_Cancellation Date or policyno var policydata xml
Do NOT store your data using the XML data type, do the job properly and split the info into columns. The benifits are innumerable but include indexing and search/query ease of use. I hate XML. Storing the history information is a business requirement, not a technical question.
Never underestimate the power of human stupidity RAH
-
Do NOT store your data using the XML data type, do the job properly and split the info into columns. The benifits are innumerable but include indexing and search/query ease of use. I hate XML. Storing the history information is a business requirement, not a technical question.
Never underestimate the power of human stupidity RAH