{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0002660633,0.0001836021,0.0002645848,0.0001307764,0.00008080752,0.00004390996,0.001033045,0.00004202917,0.0000166002],"category_scores_gemma":[0.0001443416,0.0001757584,0.00003817474,0.0004162647,0.00003344591,0.0007169941,0.001071763,0.0001246381,0.00004993962],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002723926,"about_ca_system_score_gemma":0.00001628066,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000195476,"about_ca_topic_score_gemma":0.000006012369,"domain_scores_codex":[0.9987204,0.00001520971,0.0003580078,0.0004596657,0.0001454366,0.0003012916],"domain_scores_gemma":[0.9981726,0.0001163973,0.00009292264,0.001461944,0.00006450477,0.00009163408],"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.00002195106,0.001195354,0.0009548934,0.003318026,0.000416584,0.000148188,0.02617279,0.1643027,0.07423481,0.4081236,0.01206393,0.3090472],"study_design_scores_gemma":[0.000135521,0.00001562768,0.00001851232,0.0001452838,0.000004142773,0.00001045516,0.00004492821,0.9173548,0.003190517,0.000002220177,0.07889098,0.0001870289],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.002597634,0.004951668,0.9910554,0.00003048332,0.0004519214,0.0001146523,0.0001172826,0.0002551437,0.000425828],"genre_scores_gemma":[0.2470167,0.00007795201,0.7524112,0.000006976171,0.0001842217,0.00001954131,0.0001205465,0.00003151137,0.0001313435],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.7530521,"threshold_uncertainty_score":0.7167221,"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."}}