{"id":"W2107629627","doi":"10.1109/time.2001.930704","title":"Optimizing temporal queries: efficient handling of duplicates","year":2002,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Computer science; SQL; Query language; Query by Example; Query optimization; Relational database; Semantics (computer science); Temporal database; Context (archaeology); Expressive power; Sargable; Information retrieval; Programming language; Database; Web search query; Search engine","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0001208861,0.00009379078,0.0001617512,0.00005778952,0.0000846105,0.00002414142,0.0002507184,0.00002381179,0.0000637023],"category_scores_gemma":[0.00002750334,0.00007363698,0.00004513306,0.0002266043,0.0000534717,0.0002812745,0.0001797152,0.00004622539,0.00003256055],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001158749,"about_ca_system_score_gemma":0.000006866511,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00007812393,"about_ca_topic_score_gemma":0.000006933697,"domain_scores_codex":[0.9991612,0.00001580426,0.0002506991,0.0002375865,0.0001550397,0.0001796835],"domain_scores_gemma":[0.9992791,0.00005382516,0.00009683824,0.0004593515,0.00005749057,0.00005335738],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.000006099549,0.0001964209,0.000711005,0.0001255515,0.00003048167,0.00001931926,0.004787703,0.02882294,0.01059554,0.9337827,0.001466362,0.01945586],"study_design_scores_gemma":[0.00040319,0.0001042148,0.00007497446,0.0001158456,0.000003852672,0.00002518229,0.0004851971,0.8999829,0.04831273,0.0001487977,0.04998409,0.000359002],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.009075672,0.0005248761,0.985363,0.0001860284,0.0001279714,0.00008779591,0.000003684102,0.0001413798,0.004489593],"genre_scores_gemma":[0.5583397,0.00001369996,0.441103,0.00003952243,0.00002059025,0.000006972356,0.000001155134,0.000004516983,0.0004708433],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9336339,"threshold_uncertainty_score":0.3002829,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02283313393130066,"score_gpt":0.2316378681409068,"score_spread":0.2088047342096061,"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."}}