Examples in Five Safes TES

This site includes examples of how to use 5s-TES to carry out federated analytics

• Discovery using OMOP metadata: When using 5s-TES, the user does not have access to view data prior to analysis, which makes it considerably more difficult to analyse the data. How does a researcher know what analysis to perform, or even if the data is appropriate for their work? The answer is to use summary data of the data set, a process known as cohort discovery.
• SQL examples: One application of 5s-TES is to run queries that provide the right summary statistics for your analysis. These examples demonstrate the use of SQL to make requests to databases held in two, separate TREs.
  • Contingency tables: building a contingency table using SQL
  • Descriptive statistics: calculating the mean and variance of a continuous variable for a defined cohort