These articles have been peer-reviewed and accepted for publication but are pending final changes, are not yet published and may not appear here in their final order of publication until they are assigned to issues. Therefore, the content conforms to our standards but the presentation (e.g. typesetting and proof-reading) is not necessarily up to the Inderscience standard. Additionally, titles, authors, abstracts and keywords may change before publication. Articles will not be published until the final proofs are validated by their authors.
Forthcoming articles must be purchased for the purposes of research, teaching and private study only. These articles can be cited using the expression "in press". For example: Smith, J. (in press). Article Title. Journal Title.
Articles marked with this shopping trolley icon are available for purchase - click on the icon to send an email request to purchase.
International Journal of Big Data Management (1 paper in press)
A systematic approach to cleaning of drug name records data in the FAERS database: a case report by Michael A. Veronin, Robert P. Schumaker, Rohit R. Dixit, Pooja Dhake, Morgan Ogwo Abstract: Data cleaning, also known as data cleansing, or data curation is about identifying and rectifying errors in data. The objective of this report is to present a data cleaning and standardisation process for the drug name files in the U.S. Food and Drug Administration adverse event reporting system database, FAERS. Drug name data was cleaned and standardised using a combination of data cleaning tools and manual correction techniques. Data files were organised into frequency intervals and a strategy of cleaning using iteration and programming scripts in the MySQL Workbench was employed. The download of the FAERS quarterly reports for the time periods ranging from Q1 2004 to Q3 2016 resulted in 32,736,657 DRUG file records. Records contained a variety of errors, such as misspellings, abbreviations and non-descript or ambiguous names. Upon completion of the process, standardisation of greater than 95% of the drug name data in the FAERS database was achieved. With large datasets such as FAERS, a cleaning process is necessary to rectify data that may be incomplete or inaccurate due to input errors, in order to improve the quality and validity of information. Keywords: FAERS; U.S. Food and Drug Administration; FDA; adverse drug event; ADE; drug safety; data cleaning.