============================================================================ USER COMMAND: SELECT pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename FROM (((cosara2_5.cos2_5_patient_admission AS pa INNER JOIN cosara2_5.cos2_5_patient AS p ON p.patientid = pa.patientid AND TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16) INNER JOIN cosara2_5.cos2_5_lab_order AS lo ON lo.patientid = pa.patientid) INNER JOIN cosara2_5.cos2_5_lab_sample AS ls ON ls.labordernumber = lo.labordernumber AND ls.orderinsertts = lo.inserttime AND ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') AND ls.sampletime <= pa.dischargetime AND ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)) LEFT OUTER JOIN cosara2_5.cos2_5_lab_culture AS lc ON lc.specimennumber = ls.specimennumber AND lc.sampleinsertts = ls.inserttime AND lc.culturename IS NOT NULL AND length(lc.culturename) > 1 AND lcase(lc.culturename) NOT LIKE '%volgt%' AND lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') ---------------------------------------------------------------------------- OPTIMIZE: SELECT pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename FROM (((cosara2_5.cos2_5_patient_admission AS pa INNER JOIN cosara2_5.cos2_5_patient AS p ON p.patientid = pa.patientid AND TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16) INNER JOIN cosara2_5.cos2_5_lab_order AS lo ON lo.patientid = pa.patientid) INNER JOIN cosara2_5.cos2_5_lab_sample AS ls ON ls.labordernumber = lo.labordernumber AND ls.orderinsertts = lo.inserttime AND ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') AND ls.sampletime <= pa.dischargetime AND ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)) LEFT OUTER JOIN cosara2_5.cos2_5_lab_culture AS lc ON lc.specimennumber = ls.specimennumber AND lc.sampleinsertts = ls.inserttime AND lc.culturename IS NOT NULL AND length(lc.culturename) > 1 AND lcase(lc.culturename) NOT LIKE '%volgt%' AND lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename FROM (((cosara2_5.cos2_5_patient_admission AS pa INNER JOIN cosara2_5.cos2_5_patient AS p ON p.patientid = pa.patientid AND TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16) INNER JOIN cosara2_5.cos2_5_lab_order AS lo ON lo.patientid = pa.patientid) INNER JOIN cosara2_5.cos2_5_lab_sample AS ls ON ls.labordernumber = lo.labordernumber AND ls.orderinsertts = lo.inserttime AND ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') AND ls.sampletime <= pa.dischargetime AND ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)) LEFT OUTER JOIN cosara2_5.cos2_5_lab_culture AS lc ON lc.specimennumber = ls.specimennumber AND lc.sampleinsertts = ls.inserttime AND lc.culturename IS NOT NULL AND length(lc.culturename) > 1 AND lcase(lc.culturename) NOT LIKE '%volgt%' AND lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') CANONICAL PLAN: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime, lc.culturename IS NOT NULL, length(lc.culturename) > 1, lcase(lc.culturename) NOT LIKE '%volgt%', lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16]}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime, lc.culturename IS NOT NULL, length(lc.culturename) > 1, lcase(lc.culturename) NOT LIKE '%volgt%', lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16]}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime, lc.culturename IS NOT NULL, length(lc.culturename) > 1, lcase(lc.culturename) NOT LIKE '%volgt%', lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=[ls.specimennumber, ls.inserttime, pa.admissionid, pa.admissiontime, ls.sampletime]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=[lo.labordernumber, lo.inserttime, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=[pa.patientid, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[pa.patientid, pa.admissiontime, pa.dischargetime, pa.admissionid]}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={OUTPUT_COLS=[pa.patientid, pa.admissiontime, pa.dischargetime, pa.admissionid]}) Access(groups=[cosara2_5.cos2_5_patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[p.patientid, p.birthdate]}) Source(groups=[cosara2_5.cos2_5_patient AS p], props={OUTPUT_COLS=[p.patientid, p.birthdate]}) Access(groups=[cosara2_5.cos2_5_lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[lo.patientid, lo.labordernumber, lo.inserttime]}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo], props={OUTPUT_COLS=[lo.patientid, lo.labordernumber, lo.inserttime]}) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime, lc.culturename IS NOT NULL, length(lc.culturename) > 1, lcase(lc.culturename) NOT LIKE '%volgt%', lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=[ls.specimennumber, ls.inserttime, pa.admissionid, pa.admissiontime, ls.sampletime]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=[lo.labordernumber, lo.inserttime, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=[pa.patientid, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=[ls.specimennumber, ls.inserttime, pa.admissionid, pa.admissiontime, ls.sampletime]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=[lo.labordernumber, lo.inserttime, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=[pa.patientid, pa.dischargetime, pa.admissiontime, pa.admissionid]}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob')}) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=lcase(lc.culturename) NOT LIKE '%volgt%'}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=length(lc.culturename) > 1}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=lc.culturename IS NOT NULL}) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=[ls.specimennumber, ls.inserttime, pa.admissionid, pa.admissiontime, ls.sampletime]}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob')}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.material, ls.sampletime, ls.specimennumber, ls.inserttime]}) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk'))}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename]}) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_patient AS p], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid], OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING CopyCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING CopyCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Access(groups=[cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime, ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lo.patientid = pa.patientid, p.patientid = lo.patientid], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = pa.patientid, TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_patient AS p], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_patient AS p], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_lab_order AS lo], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16}) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_patient AS p], props={OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime), lo.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={OUTPUT_COLS=null}) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo], props={OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true}) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16}) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Access(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed LOW [Relational Planner] TIMESTAMPDIFF function not supported by source cosara2_5 - TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) was not pushed AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=null}) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16}) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=null, IS_COPIED=true, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Source(groups=[cosara2_5.cos2_5_patient AS p]) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING ChooseDependent AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16, OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename]}) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], CONFORMED_SOURCES=null}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], IS_COPIED=true, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.specimennumber, ls.inserttime, p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime]}) Source(groups=[cosara2_5.cos2_5_patient AS p], props={OUTPUT_COLS=[p.patientid, p.birthdate]}) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime), lo.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[lo.patientid, pa.patientid, ls.specimennumber, ls.inserttime, pa.admissiontime, pa.admissionid, ls.sampletime]}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={OUTPUT_COLS=[pa.dischargetime, pa.admissiontime, pa.patientid, pa.admissionid]}) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.sampletime, lo.patientid, ls.specimennumber, ls.inserttime]}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo], props={OUTPUT_COLS=[lo.labordernumber, lo.inserttime, lo.patientid]}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={OUTPUT_COLS=[ls.material, ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime]}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename], IS_COPIED=true}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={OUTPUT_COLS=[lc.culturename, lc.specimennumber, lc.sampleinsertts]}) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], EST_CARDINALITY=12015.208, EST_COL_STATS={pa.admissionid=[1.0, 1.0, 1.0], pa.admissiontime=[1.0, 1.0, -1.0], ls.sampletime=[1.0, 1.0, -1.0], lc.culturename=[115.50686, 115.50686, -1.0]}}) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16, OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], EST_CARDINALITY=12015.208, EST_COL_STATS={pa.admissionid=[1.0, 1.0, 1.0], pa.admissiontime=[1.0, 1.0, -1.0], ls.sampletime=[1.0, 1.0, -1.0], lc.culturename=[115.50686, 115.50686, -1.0]}}) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], CONFORMED_SOURCES=null, EST_CARDINALITY=36045.625, EST_COL_STATS={p.birthdate=[1.0, 1.3367987, -1.0], pa.admissiontime=[1.0, 1.0, -1.0], pa.admissionid=[1.0, 1.0, 1.0], ls.sampletime=[1.0, 1.0, -1.0], ...}}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], IS_COPIED=true, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, EST_CARDINALITY=36045.625, EST_COL_STATS={p.birthdate=[1.0, 1.3367987, -1.0], pa.admissiontime=[1.0, 1.0, -1.0], pa.admissionid=[1.0, 1.0, 1.0], ls.sampletime=[1.0, 1.0, -1.0], ...}}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.specimennumber, ls.inserttime, p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime], EST_CARDINALITY=2459.8176, EST_COL_STATS={ls.specimennumber=[1.0, 1.0, -1.0], ls.inserttime=[1.0, 1.0, -1.0], p.birthdate=[18.59084, 1229.9088, -1.0], pa.admissiontime=[1.9473807, 141.64876, -1.0], ...}}) Source(groups=[cosara2_5.cos2_5_patient AS p], props={OUTPUT_COLS=[p.patientid, p.birthdate], EST_COL_STATS={p.patientid=[17730.0, 17730.0, 0.0], p.birthdate=[134.0, 8865.0, -1.0]}, EST_CARDINALITY=17730.0}) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime), lo.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[lo.patientid, pa.patientid, ls.specimennumber, ls.inserttime, pa.admissiontime, pa.admissionid, ls.sampletime], EST_CARDINALITY=2459.8176, EST_COL_STATS={lo.patientid=[15.017471, 15.017471, -1.0], pa.patientid=[2039.3998, 2039.3998, -1.0], ls.specimennumber=[1.0, 1.0, -1.0], ls.inserttime=[1.0, 1.0, -1.0], ...}}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={OUTPUT_COLS=[pa.dischargetime, pa.admissiontime, pa.patientid, pa.admissionid], EST_COL_STATS={pa.dischargetime=[147.0, 10692.5, -1.0], pa.admissiontime=[147.0, 10692.5, -1.0], pa.patientid=[17730.0, 17730.0, -1.0], pa.admissionid=[21385.0, 21385.0, 0.0]}, EST_CARDINALITY=21385.0}) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.sampletime, lo.patientid, ls.specimennumber, ls.inserttime], EST_CARDINALITY=9177.298, EST_COL_STATS={ls.sampletime=[1.0, 1.0, -1.0], lo.patientid=[516.00366, 516.00366, -1.0], ls.specimennumber=[1.0, 1.0, -1.0], ls.inserttime=[1.0, 1.0, -1.0]}}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo], props={OUTPUT_COLS=[lo.labordernumber, lo.inserttime, lo.patientid], EST_COL_STATS={lo.labordernumber=[562.0, 157667.0, -1.0], lo.inserttime=[562.0, 157667.0, -1.0], lo.patientid=[17730.0, 17730.0, -1.0]}, EST_CARDINALITY=315334.0}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], IS_COPIED=true, EST_CARDINALITY=474.29752, EST_COL_STATS={ls.labordernumber=[1.0, 237.14876, -1.0], ls.orderinsertts=[1.0, 237.14876, -1.0], ls.sampletime=[1.0, 237.14876, -1.0], ls.specimennumber=[1.0, 237.14876, -1.0], ...}}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={OUTPUT_COLS=[ls.material, ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], EST_COL_STATS={ls.material=[1331.0, 1331.0, -1.0], ls.labordernumber=[562.0, 157822.5, -1.0], ls.orderinsertts=[562.0, 157822.5, -1.0], ls.sampletime=[562.0, 157822.5, -1.0], ...}, EST_CARDINALITY=315645.0}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename], IS_COPIED=true, EST_CARDINALITY=26960.137, EST_COL_STATS={lc.specimennumber=[83.83143, 13480.067, -1.0], lc.sampleinsertts=[83.83143, 13480.067, -1.0], lc.culturename=[346.5206, 346.5206, -1.0]}}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={OUTPUT_COLS=[lc.culturename, lc.specimennumber, lc.sampleinsertts], EST_COL_STATS={lc.culturename=[1331.0, 1331.0, -1.0], lc.specimennumber=[322.0, 51777.5, -1.0], lc.sampleinsertts=[322.0, 51777.5, -1.0]}, EST_CARDINALITY=103555.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa], props={SELECT_CRITERIA=TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16, OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], EST_CARDINALITY=12015.208, EST_COL_STATS={pa.admissionid=[1.0, 1.0, 1.0], pa.admissiontime=[1.0, 1.0, -1.0], ls.sampletime=[1.0, 1.0, -1.0], lc.culturename=[115.50686, 115.50686, -1.0]}}) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], CONFORMED_SOURCES=null, EST_CARDINALITY=36045.625, EST_COL_STATS={p.birthdate=[1.0, 1.3367987, -1.0], pa.admissiontime=[1.0, 1.0, -1.0], pa.admissionid=[1.0, 1.0, 1.0], ls.sampletime=[1.0, 1.0, -1.0], ...}}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.specimennumber = ls.specimennumber, lc.sampleinsertts = ls.inserttime], OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], IS_COPIED=true, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, EST_CARDINALITY=36045.625, EST_COL_STATS={p.birthdate=[1.0, 1.3367987, -1.0], pa.admissiontime=[1.0, 1.0, -1.0], pa.admissionid=[1.0, 1.0, 1.0], ls.sampletime=[1.0, 1.0, -1.0], ...}}) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[p.patientid = lo.patientid, p.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.specimennumber, ls.inserttime, p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime], EST_CARDINALITY=2459.8176, EST_COL_STATS={ls.specimennumber=[1.0, 1.0, -1.0], ls.inserttime=[1.0, 1.0, -1.0], p.birthdate=[18.59084, 1229.9088, -1.0], pa.admissiontime=[1.9473807, 141.64876, -1.0], ...}}) Source(groups=[cosara2_5.cos2_5_patient AS p], props={OUTPUT_COLS=[p.patientid, p.birthdate], EST_COL_STATS={p.patientid=[17730.0, 17730.0, 0.0], p.birthdate=[134.0, 8865.0, -1.0]}, EST_CARDINALITY=17730.0}) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.sampletime <= pa.dischargetime, ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime), lo.patientid = pa.patientid], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[lo.patientid, pa.patientid, ls.specimennumber, ls.inserttime, pa.admissiontime, pa.admissionid, ls.sampletime], EST_CARDINALITY=2459.8176, EST_COL_STATS={lo.patientid=[15.017471, 15.017471, -1.0], pa.patientid=[2039.3998, 2039.3998, -1.0], ls.specimennumber=[1.0, 1.0, -1.0], ls.inserttime=[1.0, 1.0, -1.0], ...}}) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa], props={OUTPUT_COLS=[pa.dischargetime, pa.admissiontime, pa.patientid, pa.admissionid], EST_COL_STATS={pa.dischargetime=[147.0, 10692.5, -1.0], pa.admissiontime=[147.0, 10692.5, -1.0], pa.patientid=[17730.0, 17730.0, -1.0], pa.admissionid=[21385.0, 21385.0, 0.0]}, EST_CARDINALITY=21385.0}) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.labordernumber = lo.labordernumber, ls.orderinsertts = lo.inserttime], MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[ls.sampletime, lo.patientid, ls.specimennumber, ls.inserttime], EST_CARDINALITY=9177.298, EST_COL_STATS={ls.sampletime=[1.0, 1.0, -1.0], lo.patientid=[516.00366, 516.00366, -1.0], ls.specimennumber=[1.0, 1.0, -1.0], ls.inserttime=[1.0, 1.0, -1.0]}}) Source(groups=[cosara2_5.cos2_5_lab_order AS lo], props={OUTPUT_COLS=[lo.labordernumber, lo.inserttime, lo.patientid], EST_COL_STATS={lo.labordernumber=[562.0, 157667.0, -1.0], lo.inserttime=[562.0, 157667.0, -1.0], lo.patientid=[17730.0, 17730.0, -1.0]}, EST_CARDINALITY=315334.0}) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={SELECT_CRITERIA=ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob'), OUTPUT_COLS=[ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], IS_COPIED=true, EST_CARDINALITY=474.29752, EST_COL_STATS={ls.labordernumber=[1.0, 237.14876, -1.0], ls.orderinsertts=[1.0, 237.14876, -1.0], ls.sampletime=[1.0, 237.14876, -1.0], ls.specimennumber=[1.0, 237.14876, -1.0], ...}}) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls], props={OUTPUT_COLS=[ls.material, ls.labordernumber, ls.orderinsertts, ls.sampletime, ls.specimennumber, ls.inserttime], EST_COL_STATS={ls.material=[1331.0, 1331.0, -1.0], ls.labordernumber=[562.0, 157822.5, -1.0], ls.orderinsertts=[562.0, 157822.5, -1.0], ls.sampletime=[562.0, 157822.5, -1.0], ...}, EST_CARDINALITY=315645.0}) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={SELECT_CRITERIA=(lc.culturename IS NOT NULL) AND (length(lc.culturename) > 1) AND (lcase(lc.culturename) NOT LIKE '%volgt%') AND (lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk')), OUTPUT_COLS=[lc.specimennumber, lc.sampleinsertts, lc.culturename], IS_COPIED=true, EST_CARDINALITY=26960.137, EST_COL_STATS={lc.specimennumber=[83.83143, 13480.067, -1.0], lc.sampleinsertts=[83.83143, 13480.067, -1.0], lc.culturename=[346.5206, 346.5206, -1.0]}}) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc], props={OUTPUT_COLS=[lc.culturename, lc.specimennumber, lc.sampleinsertts], EST_COL_STATS={lc.culturename=[1331.0, 1331.0, -1.0], lc.specimennumber=[322.0, 51777.5, -1.0], lc.sampleinsertts=[322.0, 51777.5, -1.0]}, EST_CARDINALITY=103555.0}) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc]) Join(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient AS p]) Source(groups=[cosara2_5.cos2_5_patient AS p]) Join(groups=[cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_patient_admission AS pa]) Source(groups=[cosara2_5.cos2_5_patient_admission AS pa]) Join(groups=[cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_order AS lo]) Source(groups=[cosara2_5.cos2_5_lab_order AS lo]) Select(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Source(groups=[cosara2_5.cos2_5_lab_sample AS ls]) Select(groups=[cosara2_5.cos2_5_lab_culture AS lc]) Source(groups=[cosara2_5.cos2_5_lab_culture AS lc]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={PROJECT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], OUTPUT_COLS=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename], EST_CARDINALITY=12015.208, EST_COL_STATS={pa.admissionid=[1.0, 1.0, 1.0], pa.admissiontime=[1.0, 1.0, -1.0], ls.sampletime=[1.0, 1.0, -1.0], lc.culturename=[115.50686, 115.50686, -1.0]}}) Select(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa]) Access(groups=[cosara2_5.cos2_5_patient AS p, cosara2_5.cos2_5_patient_admission AS pa, cosara2_5.cos2_5_lab_order AS lo, cosara2_5.cos2_5_lab_sample AS ls, cosara2_5.cos2_5_lab_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2_5, nameInSource=null, uuid=mmuuid:a72b1c25-3088-47aa-a031-ea330bba094b, OUTPUT_COLS=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename], CONFORMED_SOURCES=null, EST_CARDINALITY=36045.625, EST_COL_STATS={p.birthdate=[1.0, 1.3367987, -1.0], pa.admissiontime=[1.0, 1.0, -1.0], pa.admissionid=[1.0, 1.0, 1.0], ls.sampletime=[1.0, 1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename FROM (cosara2_5.cos2_5_patient AS p INNER JOIN (cosara2_5.cos2_5_patient_admission AS pa INNER JOIN (cosara2_5.cos2_5_lab_order AS lo INNER JOIN cosara2_5.cos2_5_lab_sample AS ls ON ls.labordernumber = lo.labordernumber AND ls.orderinsertts = lo.inserttime) ON ls.sampletime <= pa.dischargetime AND ls.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, pa.admissiontime) AND lo.patientid = pa.patientid) ON p.patientid = pa.patientid) LEFT OUTER JOIN cosara2_5.cos2_5_lab_culture AS lc ON lc.specimennumber = ls.specimennumber AND lc.sampleinsertts = ls.inserttime AND lc.culturename IS NOT NULL AND length(lc.culturename) > 1 AND lcase(lc.culturename) NOT LIKE '%volgt%' AND lc.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') WHERE ls.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob')}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(0) output=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] [pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] SelectNode(1) output=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16 AccessNode(2) output=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename] SELECT g_0.birthdate, g_1.admissiontime, g_1.admissionid, g_3.sampletime, g_4.culturename FROM (cosara2_5.cos2_5_patient AS g_0 INNER JOIN (cosara2_5.cos2_5_patient_admission AS g_1 INNER JOIN (cosara2_5.cos2_5_lab_order AS g_2 INNER JOIN cosara2_5.cos2_5_lab_sample AS g_3 ON g_3.labordernumber = g_2.labordernumber AND g_3.orderinsertts = g_2.inserttime) ON g_3.sampletime <= g_1.dischargetime AND g_3.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, g_1.admissiontime) AND g_2.patientid = g_1.patientid) ON g_0.patientid = g_1.patientid) LEFT OUTER JOIN cosara2_5.cos2_5_lab_culture AS g_4 ON g_4.specimennumber = g_3.specimennumber AND g_4.sampleinsertts = g_3.inserttime AND g_4.culturename IS NOT NULL AND length(g_4.culturename) > 1 AND lcase(g_4.culturename) NOT LIKE '%volgt%' AND g_4.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') WHERE g_3.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(0) output=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] [pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] SelectNode(1) output=[pa.admissionid, pa.admissiontime, ls.sampletime, lc.culturename] TIMESTAMPDIFF(SQL_TSI_YEAR, p.birthdate, pa.admissiontime) >= 16 AccessNode(2) output=[p.birthdate, pa.admissiontime, pa.admissionid, ls.sampletime, lc.culturename] SELECT g_0.birthdate, g_1.admissiontime, g_1.admissionid, g_3.sampletime, g_4.culturename FROM (cosara2_5.cos2_5_patient AS g_0 INNER JOIN (cosara2_5.cos2_5_patient_admission AS g_1 INNER JOIN (cosara2_5.cos2_5_lab_order AS g_2 INNER JOIN cosara2_5.cos2_5_lab_sample AS g_3 ON g_3.labordernumber = g_2.labordernumber AND g_3.orderinsertts = g_2.inserttime) ON g_3.sampletime <= g_1.dischargetime AND g_3.sampletime >= TIMESTAMPADD(SQL_TSI_HOUR, -96, g_1.admissiontime) AND g_2.patientid = g_1.patientid) ON g_0.patientid = g_1.patientid) LEFT OUTER JOIN cosara2_5.cos2_5_lab_culture AS g_4 ON g_4.specimennumber = g_3.specimennumber AND g_4.sampleinsertts = g_3.inserttime AND g_4.culturename IS NOT NULL AND length(g_4.culturename) > 1 AND lcase(g_4.culturename) NOT LIKE '%volgt%' AND g_4.culturename NOT IN ('geen verdere uitwerking mogelijk (kiem afgestorven)', 'KIEM.', 'verdere identificatie technisch onmogelijk') WHERE g_3.material IN ('Hemokultuur aeroob', 'Hemokultuur anaeroob') ============================================================================