Database

ObjectiveTo ensure that the application is robustagainst all forms of input data, whetherobtained from the user, infrastructure,external entities or database systems Definitions *Integrity checks Ensure that the data has not been tampered with and is the same asbefore *Validation Ensure that the data is strongly typed, correct syntax, within lengthboundaries, contains only permitted characters, or if numeric is correctlysigned and within range boundaries *Business rules Ensure that data is not only validated, but business rule correct. Forexample, interest rates fall within permitted boundaries.http://searchsoftwarequality.techtarget.com/news/1156594/Data-validation-Chapter-12-OWASP-Guide-to-Building-Secure-Web-Applications-and-Web-Services Why isData Validation Important? * Data validation is necessary to identifydata with errors, biases, and physically unrealistic values before they areused for identification of exceedances, for analysis, or for modeling.http://www.epa.gov/oar/oaqps/pams/analysis/validation/valid.html

你要先知何謂data validation, 才知為什麼重要!!!
data validation 唔單止係database重要, 對於電腦科黎講, 係基本野!!!