Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Data source categories and DS 2
| Source                        | Destination               |   Weight |
|:------------------------------|:--------------------------|---------:|
| Clinical narratives           | Comparative drug analysis |        0 |
| Manually annotated corpora    | Comparative drug analysis |        0 |
| mHealth apps                  | Comparative drug analysis |        0 |
| PHRs                          | Comparative drug analysis |        0 |
| Social media                  | Comparative drug analysis |        0 |
| Drug regulation documentation | Comparative drug analysis |        0 |
| Clinical trials               | Drug interactions         |        0 |
| HL7 messages                  | Drug interactions         |        0 |
| mHealth apps                  | Drug interactions         |        0 |
| Patient summaries             | Drug interactions         |        0 |


Table: Data source categories and DS
| Data source categories and DS special topics   |   ADE databases |   Bibliographic databases |   Genetics and biochemical databases |   Clinical narratives |   Clinical trials |   Drug information databases |   HL7 messages |   Manually annotated corpora |   mHealth apps |   Patient summaries |   PHRs |   Social media |   SRSs |   EHRs |   SPLs |
|:-----------------------------------------------|----------------:|--------------------------:|-------------------------------------:|----------------------:|------------------:|-----------------------------:|---------------:|-----------------------------:|---------------:|--------------------:|-------:|---------------:|-------:|-------:|-------:|
| Comparative drug analysis                      |               4 |                         4 |                                    5 |                     0 |                 2 |                            5 |              1 |                            0 |              0 |                   1 |      0 |              0 |      5 |      2 |      5 |
| Drug interactions                              |               7 |                         3 |                                    8 |                     2 |                 0 |                           11 |              0 |                            3 |              0 |                   0 |      1 |              0 |      8 |      4 |      1 |
| MoA identification/analysis                    |               9 |                         8 |                                   12 |                     1 |                 1 |                           10 |              0 |                            0 |              0 |                   0 |      0 |              0 |      8 |      6 |      3 |
| Personalized drug safety                       |               3 |                         3 |                                    4 |                     0 |                 0 |                            0 |              0 |                            0 |              0 |                   0 |      1 |              0 |      0 |      4 |      2 |
| Signal detection                               |              19 |                        13 |                                   16 |                     7 |                 3 |                           14 |              2 |                            1 |              1 |                   2 |      0 |             12 |     19 |      7 |      6 |
| Specific (class of) disease                    |               2 |                         0 |                                    1 |                     1 |                 1 |                            2 |              0 |                            0 |              0 |                   0 |      0 |              0 |      3 |      2 |      1 |
| Specific (class of) drug(s)                    |               1 |                         0 |                                    0 |                     0 |                 0 |                            0 |              0 |                            0 |              0 |                   0 |      0 |              1 |      3 |      0 |      0 |
| Specific adverse effect                        |               1 |                         2 |                                    2 |                     0 |                 0 |                            1 |              0 |                            0 |              0 |                   0 |      0 |              0 |      0 |      0 |      1 |
| Vaccine safety                                 |               0 |                         2 |                                    1 |                     0 |                 0 |                            0 |              0 |                            0 |              0 |                   0 |      0 |              0 |      6 |      0 |      1 |


Table: Data source categories and KE 2
| Source                             | Destination             |   Weight |
|:-----------------------------------|:------------------------|---------:|
| ADE databases                      | Knowledge dissemination |        1 |
| Bibliographic databases            | Knowledge dissemination |        1 |
| Genetics and biochemical databases | Knowledge dissemination |        1 |
| Clinical narratives                | Knowledge dissemination |        0 |
| Clinical trials                    | Knowledge dissemination |        1 |
| Drug information databases         | Knowledge dissemination |        2 |
| HL7 messages                       | Knowledge dissemination |        0 |
| Manually annotated corpora         | Knowledge dissemination |        0 |
| mHealth apps                       | Knowledge dissemination |        0 |
| Patient summaries                  | Knowledge dissemination |        0 |


Table: Data source categories and KE
| Data source categories and KE core activities   |   ADE databases |   Bibliographic databases |   Genetics and biochemical databases |   Clinical narratives |   Clinical trials |   Drug information databases |   HL7 messages |   Manually annotated corpora |   mHealth apps |   Patient summaries |   PHRs |   Social media |   SRSs |   EHRs |   SPLs |
|:------------------------------------------------|----------------:|--------------------------:|-------------------------------------:|----------------------:|------------------:|-----------------------------:|---------------:|-----------------------------:|---------------:|--------------------:|-------:|---------------:|-------:|-------:|-------:|
| Knowledge dissemination                         |               1 |                         1 |                                    1 |                     0 |                 1 |                            2 |              0 |                            0 |              0 |                   0 |      0 |              0 |      0 |      0 |      2 |
| Knowledge elicitation                           |              10 |                         6 |                                    9 |                     2 |                 1 |                            9 |              2 |                            1 |              0 |                   1 |      1 |              0 |      9 |      6 |      1 |
| Knowledge extraction                            |              11 |                        14 |                                    8 |                     6 |                 1 |                           11 |              0 |                            4 |              0 |                   0 |      0 |             10 |     12 |      3 |      8 |
| Knowledge integration                           |              15 |                         7 |                                   16 |                     2 |                 4 |                           13 |              1 |                            0 |              1 |                   1 |      0 |              2 |     10 |      7 |      8 |
| Knowledge representation                        |              11 |                         9 |                                   11 |                     1 |                 2 |                            9 |              2 |                            1 |              1 |                   2 |      0 |              2 |     11 |      7 |      8 |


Table: Data sources and categories
| Category                | Number of papers   | Data source              |   Normalized number of papers |
|:------------------------|:-------------------|:-------------------------|------------------------------:|
| ADE databases           | 25                 | SIDER                    |                            23 |
| ADE databases           |                    | …                        |                             2 |
| Bibliographic databases | 22                 | PubMed                   |                            14 |
| Bibliographic databases |                    | SemMedDB                 |                             8 |
| Clinical narratives     | 7                  | Local (proprietary) EHRs |                             3 |
| Clinical narratives     |                    | …                        |                             4 |
| Clinical trials         | 5                  | ClinicalTrials.gov       |                             5 |
| Drug databases          | 22                 | DrugBank                 |                            18 |
| Drug databases          |                    | NDF-RT                   |                             4 |
| EHRs                    | 13                 | Local (proprietary) EHRs |                            11 |


Table: Disrtibution per DS topic
| Drug safety special topics   |   Number of papers |
|:-----------------------------|-------------------:|
| Comparative drug analysis    |                 15 |
| Drug interactions            |                 19 |
| MoA identification/analysis  |                 28 |
| Personalized drug safety     |                 10 |
| Signal detection             |                 46 |
| Specific (class of) disease  |                  7 |
| Specific (class of) drug(s)  |                  5 |
| Specific adverse effect      |                  3 |
| Vaccine safety               |                 10 |


Table: Distibution per DS activity
| Drug safety core activities   |   Number of papers |
|:------------------------------|-------------------:|
| ADE information collection    |                 25 |
| ADE detection                 |                 39 |
| ADE assessment                |                 30 |
| ADE monitoring                |                  2 |
| ADE prevention                |                  9 |
| ADE reporting                 |                  5 |


Table: Distribution per challenge
| Challenges                                                   |   Number of papers |
|:-------------------------------------------------------------|-------------------:|
| Commercial tools                                             |                  3 |
| Competing interests                                          |                 24 |
| Evaluation against small dataset                             |                  9 |
| Evaluation restricted on a narrow scope                      |                 17 |
| Evaluation with simulated data                               |                  2 |
| Knowledge model not available                                |                 22 |
| Knowledge model not validated for completeness               |                 26 |
| No evaluation regarding knowledge modelling quality criteria |                 32 |
| No statement regarding competing interests                   |                 16 |
| No systematic evaluation                                     |                 12 |


Table: Distribution per computational
| Computational methods                  |   Number of papers |
|:---------------------------------------|-------------------:|
| Data mining                            |                  4 |
| Disproportionality analysis            |                 11 |
| Graph-based inferencing                |                 15 |
| Information extraction                 |                 39 |
| Ontology reasoning                     |                 26 |
| Rule-based inferencing                 |                 17 |
| Simulation                             |                  1 |
| Terminological reasoning               |                 32 |
| Vector-based similarity identification |                 22 |


Table: Distribution per country
| Countries   |   Number of papers |
|:------------|-------------------:|
| Australia   |                  1 |
| Belgium     |                  2 |
| Canada      |                  3 |
| China       |                 12 |
| Denmark     |                  1 |
| France      |                 12 |
| Germany     |                  2 |
| Greece      |                  3 |
| India       |                  1 |
| Ireland     |                  1 |


Table: Distribution per org type
| Type              |   Number of papers |   Percentage |
|:------------------|-------------------:|-------------:|
| Academia/Research |                 77 |    0.950617  |
| Healthcare        |                 12 |    0.148148  |
| Industry          |                 17 |    0.209877  |
| PV Monitoring     |                  4 |    0.0493827 |


Table: Distribution per reference term
| Reference Terminologies                           |   Number of papers |
|:--------------------------------------------------|-------------------:|
| AEO                                               |                  1 |
| AERO                                              |                  1 |
| ATC                                               |                 18 |
| BFO                                               |                  8 |
| BNF Dictionary                                    |                  1 |
| Canada Drug Adverse Reaction Database (MedEffect) |                  1 |
| ChEBI                                             |                  5 |
| CHV                                               |                  6 |
| C-NPU/IUPAC                                       |                  1 |
| CNTRO                                             |                  1 |


Table: Distribution per source categor
| Data source categories             |   Number of papers |
|:-----------------------------------|-------------------:|
| ADE databases                      |                 27 |
| Bibliographic databases            |                 20 |
| Genetics and biochemical databases |                 23 |
| Clinical narratives                |                  7 |
| Clinical trials                    |                  5 |
| Drug information databases         |                 22 |
| HL7 messages                       |                  2 |
| Manually annotated corpora         |                  5 |
| mHealth apps                       |                  1 |
| Patient summaries                  |                  2 |


Table: Distribution per source
| Data source(s)              |   Number of papers |
|:----------------------------|-------------------:|
| ADME-AP                     |                  1 |
| ADRMine Corpus              |                  1 |
| AEOLUS                      |                  1 |
| AERS-DM                     |                  1 |
| AFSSAPS Spontaneous Reports |                  1 |
| allodocteurs.fr             |                  1 |
| atoute.org                  |                  1 |
| baclofene.com               |                  1 |
| baclofene.fr                |                  1 |
| Bio2RDF                     |                  1 |


Table: Distribution per year
|   Publication year |   Number of papers |
|-------------------:|-------------------:|
|               2006 |                  1 |
|               2007 |                  0 |
|               2008 |                  1 |
|               2009 |                  0 |
|               2010 |                  2 |
|               2011 |                  4 |
|               2012 |                  7 |
|               2013 |                  8 |
|               2014 |                 12 |
|               2015 |                 10 |


Table: DS and KE core activities (2)
| Source                     | Destination             |   Weight |
|:---------------------------|:------------------------|---------:|
| ADE information collection | Knowledge dissemination |        0 |
| ADE detection              | Knowledge dissemination |        0 |
| ADE assessment             | Knowledge dissemination |        0 |
| ADE monitoring             | Knowledge dissemination |        0 |
| ADE prevention             | Knowledge dissemination |        1 |
| ADE reporting              | Knowledge dissemination |        2 |
| ADE information collection | Knowledge elicitation   |        6 |
| ADE detection              | Knowledge elicitation   |       16 |
| ADE assessment             | Knowledge elicitation   |       15 |
| ADE monitoring             | Knowledge elicitation   |        1 |


Table: DS and KE core activities
| DS and KE core activities   |   Knowledge dissemination |   Knowledge elicitation |   Knowledge extraction |   Knowledge integration |   Knowledge representation |
|:----------------------------|--------------------------:|------------------------:|-----------------------:|------------------------:|---------------------------:|
| ADE information collection  |                         0 |                       6 |                     21 |                       3 |                          4 |
| ADE detection               |                         0 |                      16 |                     20 |                      18 |                         15 |
| ADE assessment              |                         0 |                      15 |                     11 |                      12 |                         17 |
| ADE monitoring              |                         0 |                       1 |                      0 |                       0 |                          2 |
| ADE prevention              |                         1 |                       3 |                      2 |                       3 |                          5 |
| ADE reporting               |                         2 |                       0 |                      2 |                       3 |                          4 |


Table: Sankey
| Source                      | Destination                        |   Weight |
|:----------------------------|:-----------------------------------|---------:|
| Vaccine safety              | ADE databases                      |        0 |
| Specific (class of) disease | Bibliographic databases            |        0 |
| Specific (class of) drug(s) | Bibliographic databases            |        0 |
| Specific (class of) disease | Genetics and biochemical databases |        0 |
| Specific (class of) drug(s) | Genetics and biochemical databases |        0 |
| Comparative drug analysis   | Clinical narratives                |        0 |
| Personalized drug safety    | Clinical narratives                |        0 |
| Specific (class of) drug(s) | Clinical narratives                |        0 |
| Specific adverse effect     | Clinical narratives                |        0 |
| Vaccine safety              | Clinical narratives                |        0 |

 


tables: name: Data source categories and DS 2
data: Data source categories and DS 2.csv
name: Data source categories and DS
data: Data source categories and DS.csv
name: Data source categories and KE 2
data: Data source categories and KE 2.csv
name: Data source categories and KE
data: Data source categories and KE.csv
name: Data sources and categories
data: Data sources and categories.csv
name: Disrtibution per DS topic
data: Disrtibution per DS topic.csv
name: Distibution per DS activity
data: Distibution per DS activity.csv
name: Distribution per challenge
data: Distribution per challenge.csv
name: Distribution per computational
data: Distribution per computational.csv
name: Distribution per country
data: Distribution per country.csv
name: Distribution per org type
data: Distribution per org type.csv
name: Distribution per reference term
data: Distribution per reference term.csv
name: Distribution per source categor
data: Distribution per source categor.csv
name: Distribution per source
data: Distribution per source.csv
name: Distribution per year
data: Distribution per year.csv
name: DS and KE core activities (2)
data: DS and KE core activities (2).csv
name: DS and KE core activities
data: DS and KE core activities.csv
name: Sankey
data: Sankey.csv
label: Distribution per org type
Number of papers
Distribution per computational
Number of papers
Distribution per source categor
Number of papers
Distribution per computational
Number of papers
Distibution per DS activity
Number of papers
Distribution per challenge
Number of papers
Disrtibution per DS topic
Number of papers
Distribution per challenge
Number of papers
Distribution per country
Number of papers
Distribution per computational
Number of papers
Data sources and categories
Data source
Distribution per source
Data source(s)
output: {
    "joins": [
        {
            "from_table": "Distribution per org type",
            "from_column": "Number of papers",
            "to_table": "Distribution per computational",
            "to_column": "Number of papers"
        },
        {
            "from_table": "Distribution per source categor",
            "from_column": "Number of papers",
            "to_table": "Distribution per computational",
            "to_column": "Number of papers"
        },
        {
            "from_table": "Distibution per DS activity",
            "from_column": "Number of papers",
            "to_table": "Distribution per challenge",
            "to_column": "Number of papers"
        },
        {
            "from_table": "Disrtibution per DS topic",
            "from_column": "Number of papers",
            "to_table": "Distribution per challenge",
            "to_column": "Number of papers"
        },
        {
            "from_table": "Distribution per country",
            "from_column": "Number of papers",
            "to_table": "Distribution per computational",
            "to_column": "Number of papers"
        },
        {
            "from_table": "Data sources and categories",
            "from_column": "Data source",
            "to_table": "Distribution per source",
            "to_column": "Data source(s)"
        }
    ]
}