#Testing: Verify SQL Linkage against our current version of the RDB

[J-glove]

Our plan is to move to neo4j Knowledge Graph to house the exposome data. In the meantime, we may still want to make our data available to Mayo - we could distribute the RDB we currently have to allow them to do linkage on more datasets.

[chengrong-us]

Updates[2025-02-04]:

1. db_linkage_ucr.py works well against UCR from current .db (/data/exposome_db/zip9_exposomes.db) on exposome server.
2. Made some revisions for db_linkage_ucr.py to run well.
3. The results (Figure 1) are all zero, which seems like that there are some issues. However, there are no problems when testing against full UCR dataset rather than current .db (Figure 2).

Figure 1:

Figure 2:

[J-glove]

Please verify against the other datasets uploaded to the db.

[chengrong-us]

Updates[2025-02-11]:

1. 'UCR', 'CBP', and 'USDA_FARA' were verified.
2. There are incomplete 'CBP', 'UCR', 'USDA_FARA' tables in current .db on exposome server as below.
   • UCR: 10000 rows; 1989-2020.
   • CBP: 500 rows; 2005.
   • USDA_FARA: 10000 rows; 2015, 2019.