title: Design and debugging databases for statistical analysis.
abstract: Any form of data analysis requires the prior creation of a database to house the study information collected in one format or other (questionnaire, clinical history, etc.). The design of such databases should be optimised to allow adequate statistical analysis without the drawing of wrong conclusions. In addition, prior to analysis, debugging or filtering of the variables is required in order to avoid doubling the effort made in extracting the results. The present study offers a series of suggestions for database design and debugging, to ensure that the later statistical analyses are based on the revised data.
authors.affiliation: Servicio de Medicina Preventiva y Salud Pública, Hospital Virgen de las Nieves, Granada, Spain. mmar.rodriguez.sspa@juntadeandalucia.es
authors.forename: M M
authors.initials: MM
authors.lastname: Rodríguez del Aguila
authors.forename: P
authors.initials: P
authors.lastname: Garrido-Fernández
mesh_terms: D000465:Algorithms; D003627:Data Interpretation, Statistical; D003628:Database Management Systems / Q000592:standards*; D019992:Databases as Topic / Q000592:standards*; D017408:Guidelines as Topic; D012985:Software Design