DatabaseConnector - Connecting to Various Database Platforms

An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server', 'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', 'Snowflake', 'Spark', and 'SQLite'). Also includes support for fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or other 'DBI' drivers to connect to databases.

Last updated 3 months ago

hades

12.52 score 54 stars 8 packages 720 scripts 14k downloads

SqlRender - Rendering Parameterized SQL and Translation to Dialects

A rendering tool for parameterized SQL that also translates into different SQL dialects. These dialects include 'Microsoft SQL Server', 'Oracle', 'PostgreSql', 'Amazon RedShift', 'Apache Impala', 'IBM Netezza', 'Google BigQuery', 'Microsoft PDW', 'Snowflake', 'Azure Synapse Analytics Dedicated', 'Apache Spark', 'SQLite', and 'InterSystems IRIS'.

Last updated 2 months ago

hades

12.28 score 82 stars 9 packages 496 scripts 4.0k downloads

Andromeda - Asynchronous Disk-Based Representation of Massive Data

Storing very large data objects on a local drive, while still making it possible to manipulate the data in an efficient manner.

Last updated 3 months ago

hades

9.26 score 11 stars 6 packages 56 scripts 1.4k downloads

ParallelLogger - Support for Parallel Computation, Logging, and Function Automation

Support for parallel computation with progress bar, and option to stop or proceed on errors. Also provides logging to console and disk, and the logging persists in the parallel threads. Additional functions support function call automation with delayed execution (e.g. for executing functions in parallel).

Last updated 3 months ago

hades

9.18 score 12 stars 8 packages 88 scripts 2.4k downloads

EmpiricalCalibration - Routines for Performing Empirical Calibration of Observational Study Estimates

Routines for performing empirical calibration of observational study estimates. By using a set of negative control hypotheses we can estimate the empirical null distribution of a particular observational study setup. This empirical null distribution can be used to compute a calibrated p-value, which reflects the probability of observing an estimated effect size when the null hypothesis is true taking both random and systematic error into account. A similar approach can be used to calibrate confidence intervals, using both negative and positive controls. For more details, see Schuemie et al. (2013) <doi:10.1002/sim.5925> and Schuemie et al. (2018) <doi:10.1073/pnas.1708282114>.

Last updated 2 months ago

hades

8.28 score 10 stars 1 packages 142 scripts 920 downloads

EvidenceSynthesis - Synthesizing Causal Evidence in a Distributed Research Network

Routines for combining causal effect estimates and study diagnostics across multiple data sites in a distributed study, without sharing patient-level data. Allows for normal and non-normal approximations of the data-site likelihood of the effect parameter.

Last updated 3 months ago

hades

5.87 score 8 stars 31 scripts 428 downloads

DatabaseConnectorJars - JAR Dependencies for the 'DatabaseConnector' Package

Provides external JAR dependencies for the 'DatabaseConnector' package.

Last updated 2 years ago

hades

3.00 score 1 stars 204 downloads