The Map gello looks similar to standard query with the result being Key Value pairs.
The keys are customisable.
The Maps are run on the whole population to produce a map cache. This example of the indications for endoscopy for a gastroenterology practice shows the map stage took about 20 minutes for 113000 nested and at times complex patient records as VMRs.
The Some Reduce gello is shown here (; again its a fairly simple worked example). The loop is just to help the output strings be unique and somewhat cleaned.:
The actual result for the combined MapReduce takes only seconds::
The result can be saved into various formats with a right click on the result element, in this case 'b':
A clinical use case is for audit and research. The auditable and researchable Map cache could be updated on a regular basis to surface population clinical data of interest and for bespoke Reduce gello queries.
In a gastroenterology practice doing colonoscopies, this includes the 'To caecum' rate ( an assessment of the quality of the scope procedure) and an Adenoma rate ( the number of adenomas on subsequent biopsy for biopsies performed with endoscopy). The example above is for upper endoscopies and different clincal . Different clinical queries would be desired.
...