This vantage6 algorithm sends basic SQL queries to an OMOP database at the node(s). This algorithm can be used to test the infrastructure of your vantage6 network after setting up an OMOP database.
These queries are used to test the database connection from a vantage6 node to verify that the installation is correct and there is some data in the database.
The queries are:
- Count the number of persons in the database
- Return the table names in the database
You can run these queries using the OMOP SQL connection or using the OHDSI API.
This package has been developed in context of the BlueBerry and IDEA4RC projects.
This algorithm is designed to be run with the vantage6 infrastructure for distributed analysis and learning.
The base code for this algorithm has been created via the v6-algorithm-template template generator.
For the count query, the algorithm can be configured to only return the result if the number of records is above a certain threshold. This is done by setting the BOQ_MIN_RECORDS environment variable.
In case the number of records is below the threshold, the algorithm will return a range between 1 and the threshold. Or the range will be 0 to the threshold if the BOQ_ALLOW_ZERO environment variable is set.
Default value: 5
By default if the number of records is zero, the value zero is returned. This can be changed by setting the BOQ_ALLOW_ZERO environment variable.
In case there are zero records in the PERSON table, the algorithm will return a range between 1 and the threshold when BOQ_ALLOW_ZERO is set to false.
Default value: true
In order to build its best to use the makefile.
make image VANTAGE6_VERSION=4.5.3