Hi @optimizer
I am part of a team at QuintilesIMS that builds the E360 ‘Cohort Builder’ which is capable of very quick, complex cohort definitions and queries. We currently have 700+ million patient lives loaded into the the tool, which is a growing number as we add further datasets from across the world. Hardware wise, we use MS SQLServer as our backend with a combination of Sharded Database servers and some very cool patented search algorithms!
A lot of our datasets are in the OMOP schema (which E360 talks to natively), and we have recently done work with the ATLAS team to allow patient cohorts generated from our tools to be passed to ATLAS for analysis.
If you would like more detailed info, just reach out