This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
documentation:laertes_etl [2015/05/26 18:35] lee [“Terminology-mappings” directory] |
documentation:laertes_etl [2015/05/26 18:49] lee [EU SPC ADR data feed] |
||
---|---|---|---|
Line 195: | Line 195: | ||
* Load the RDF ntriple graph data into the Virtuoso database | * Load the RDF ntriple graph data into the Virtuoso database | ||
* Manually run Virtuoso SPARQL query to export the drug/hoi combinations along with the adverse event counts into an export file | * Manually run Virtuoso SPARQL query to export the drug/hoi combinations along with the adverse event counts into an export file | ||
+ | * Manually load the annotation URIs into the URL Shortener MySQL database using the MySQL command line client | ||
* Run Python script to load the export file into the PostgreSQL public schema database | * Run Python script to load the export file into the PostgreSQL public schema database | ||
Line 202: | Line 203: | ||
https://github.com/OHDSI/KnowledgeBase/tree/master/LAERTES/EuSPC | https://github.com/OHDSI/KnowledgeBase/tree/master/LAERTES/EuSPC | ||
- | ==== PUBMED/MEDLINE data feed ==== | + | ==== PUBMED / MEDLINE data feed ==== |
MEDLINE records for indexed literature reporting adverse drug events | MEDLINE records for indexed literature reporting adverse drug events | ||