{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.004974583,0.0008215343,0.001462666,0.001198018,0.0009727417,0.002970516,0.002900821,0.001011671,0.001849746],"category_scores_gemma":[0.01607891,0.0005892549,0.0008560234,0.003268807,0.001126007,0.005566696,0.00282507,0.000976083,0.0007390213],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0008014773,"about_ca_system_score_gemma":0.001870125,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002971858,"about_ca_topic_score_gemma":0.002491099,"domain_scores_codex":[0.9932224,0.00175793,0.0006687047,0.0006328622,0.003191572,0.000526514],"domain_scores_gemma":[0.9901459,0.004772764,0.0008758675,0.002431759,0.001592653,0.0001811448],"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.002389848,0.0005248868,0.00717218,0.0009348778,0.0002992915,0.001816897,0.002414829,0.1416468,0.08443981,0.08632936,0.03094491,0.6410862],"study_design_scores_gemma":[0.0002833564,0.0003301815,0.00178898,0.00006692816,0.0002417807,0.001639881,0.001099609,0.7609203,0.1030011,0.09951628,0.0309815,0.0001301224],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.1277673,0.001452469,0.8537872,0.0008083467,0.0001433836,0.0003245641,0.0006293204,0.007882968,0.007204488],"genre_scores_gemma":[0.521726,0.001061886,0.4653815,0.0004557439,0.0002489782,0.0002410647,0.001563471,0.001975772,0.007345565],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.004974583,"threshold_uncertainty_score":0.02630848,"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."}}