{"id":"W1983768816","doi":"10.1016/s0169-023x(02)00133-7","title":"Optimizing temporal queries: efficient handling of duplicates","year":2002,"lang":"en","type":"article","venue":"Data & Knowledge Engineering","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":5,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Waterloo","funders":"Natural Sciences and Engineering Research Council of Canada","keywords":"Computer science; SQL; Query language; Query optimization; Query by Example; Relational database; Temporal database; Semantics (computer science); Expressive power; Context (archaeology); Sargable; Information retrieval; Programming language; Database; Web search query; Search engine","routes":{"ca_aff":true,"ca_fund":true,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.005367592,0.00125525,0.002358575,0.001861517,0.001633156,0.003992253,0.00483478,0.001736515,0.003166741],"category_scores_gemma":[0.02073514,0.00119091,0.001203222,0.004802144,0.00131475,0.008217559,0.003467334,0.001524926,0.001405733],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001257911,"about_ca_system_score_gemma":0.003030796,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.005861953,"about_ca_topic_score_gemma":0.006236839,"domain_scores_codex":[0.991804,0.001788187,0.0009356915,0.001080777,0.003694429,0.0006969456],"domain_scores_gemma":[0.9838435,0.007553881,0.001046685,0.00454368,0.002654865,0.0003574191],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.003944359,0.000632574,0.006447101,0.001027676,0.0004068358,0.0009719688,0.001336788,0.07599457,0.04906671,0.04932555,0.06717879,0.7436671],"study_design_scores_gemma":[0.0006721465,0.000436923,0.001453861,0.00008640213,0.0004363192,0.001319298,0.0007997855,0.8034211,0.06544702,0.09697572,0.02879767,0.0001538307],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.1233564,0.003768716,0.8495,0.001305854,0.000471572,0.0002952661,0.001671631,0.01235684,0.007273614],"genre_scores_gemma":[0.4238589,0.001390549,0.5616745,0.0005689126,0.0004344936,0.0002147137,0.003538725,0.00203164,0.006287615],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.005861953,"threshold_uncertainty_score":0.02838689,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03893282992648182,"score_gpt":0.2496358099264162,"score_spread":0.2107029799999343,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}