Table 2.

Query performance result of the computer-aided CT recruitment system.

CT Recruitment rules in different complexity	Rule description	Rule validation	DSL translation	SQL query	Client processing	Total time
[BirthWeight] <= 1.0 && [GestationalAgeWeek] < 29	Find patients whose birth weight <= 1 kg and gestational age < 29 weeks	<1 ms	<1 ms	151 ms	285 ms	436 ms
[BirthWeight] <= 1.5 && [GestationalAgeWeek] <= 30 && [Birthday] >= 2014-01-01 && ([MostSevereDiagnosisOD] == %retin% || [MostSevereDiagnosisOS] == %retin% )	Find patients born after 2014 and whose birth weight <= 1.5 kg and gestational age <= 30 weeks and who have retina-related diseases	<1 ms	<1 ms	157 ms	289 ms	446 ms
[BirthWeight] <= 1.5 && [GestationalAgeWeek]<= 30 && [Birthday] >= 2014-01-01 && ( [NumberOfFetus] >= 2 || [Homozygotic] == true || [MotherAge] >= 35 || [OxygenMethod] == %oxygen% || [SystemicDiseaseHistory] == %Apnea% || ( [PregnancyStatus] == %HTN% || [PregnancyStatus] == %DM% || [PregnancyStatus] == %PIH%) || [PregnancyMedication] == %Corticosteroids% || ( [MostSevereDiagnosisOD] == %ROP% || [MostSevereDiagnosisOS] == %ROP% || [MostSevereDiagnosisOD] == %retin% || [MostSevereDiagnosisOS] == %retin% ) || ( [FamilyDiseaseHistory] == %retin% || [FamilyDiseaseHistory] == %fundus%) )	Find patients born after 2014 and whose birth weight <= 1.5 kg and gestational age <= 30 weeks and who meet one of the following conditions: homozygotic multiple birth, mother age >=35, oxygen therapy history, OSAS, having at least one of HTN, DM, or PIH during pregnancy, using corticosteroids during pregnancy, having retina-related diseases, or having family disease history of retina or fundus-related diseases	1 ms	<1 ms	159 ms	283 ms	443 ms

The results are averaged on 10 tests. Detailed result can be downloaded from http://ropd.brahma.pub/pages/20170130.xls.