Pharmacovigilance is the activity related to the collection, analysis, and prevention of adverse reactions induced by drugs. The spontaneous reporting of adverse drug reactions is a system for identifying and sending reports about unexpected reactions to the regulatory authority. In Italy the information needed for properly carrying out the pharmacovigilance activities is scattered in different databases, which often contain the same information but encoded in different and temporally evolving ways. The data contained in the mentioned archives need to be integrated with information contained in other databases. In this paper we de- scribe the construction of a data warehousing system, called VigiSegn, for the national center of pharmacovigilance; in particular, we focus on the data sources analysis and the design of the reconciled database. The (temporal) schema of reconciled data has been designed by using the TimeER conceptual data model.

Designing the reconciled schema for a pharmacovigilance data warehouse through a temporally-enhanced ER model

LORA, Riccardo;SABAINI, Alberto;COMBI, Carlo;MORETTI, Ugo
2012

Abstract

Pharmacovigilance is the activity related to the collection, analysis, and prevention of adverse reactions induced by drugs. The spontaneous reporting of adverse drug reactions is a system for identifying and sending reports about unexpected reactions to the regulatory authority. In Italy the information needed for properly carrying out the pharmacovigilance activities is scattered in different databases, which often contain the same information but encoded in different and temporally evolving ways. The data contained in the mentioned archives need to be integrated with information contained in other databases. In this paper we de- scribe the construction of a data warehousing system, called VigiSegn, for the national center of pharmacovigilance; in particular, we focus on the data sources analysis and the design of the reconciled database. The (temporal) schema of reconciled data has been designed by using the TimeER conceptual data model.
data warehouse; pharmacovigilance; reconcilied schema; time er
File in questo prodotto:
Non ci sono file associati a questo prodotto.

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: http://hdl.handle.net/11562/502753
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 8
  • ???jsp.display-item.citation.isi??? 4
social impact