{"id":"W2147734897","doi":"10.1109/ride.1997.583698","title":"Mediator join indices","year":2002,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Alberta","funders":"","keywords":"Joins; Computer science; Join (topology); Query optimization; Overhead (engineering); Context (archaeology); Database; Data mining; Materialized view; View; Distributed computing; Programming language; Database design; Mathematics","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.00006624501,0.00005193234,0.0000676528,0.00003422379,0.0000526777,0.0000251659,0.0002071225,0.00001614469,0.0003460779],"category_scores_gemma":[0.00002200886,0.00003812647,0.0000170373,0.0001333647,0.00001683007,0.0006388338,0.0001049309,0.0000338915,0.0006212565],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.000005831212,"about_ca_system_score_gemma":0.000003924285,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00001377891,"about_ca_topic_score_gemma":0.00001395931,"domain_scores_codex":[0.9994757,0.00001454908,0.0001044463,0.0001493759,0.0001332782,0.0001227101],"domain_scores_gemma":[0.9995658,0.00003257669,0.00003358984,0.0002981146,0.00001377456,0.00005610436],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"not_applicable","study_design_scores_codex":[2.800961e-7,0.00002654128,0.0007370943,0.00001016784,0.000005694968,0.00002068694,0.0007249859,0.000003514758,0.0003176879,0.9215381,0.04618229,0.03043301],"study_design_scores_gemma":[0.0001486089,0.00002873889,0.00047214,0.000009432571,8.622601e-7,0.00001855787,0.00008665634,0.01004447,0.003434094,0.0005480817,0.9850411,0.0001672888],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.003165893,0.0003531104,0.9628584,0.0009651718,0.0003178422,0.0000514391,0.000003267785,0.0002367886,0.03204804],"genre_scores_gemma":[0.3459406,0.00009829621,0.6389595,0.001773521,0.0003067063,0.00002556652,0.000003253613,0.00001070704,0.01288179],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.9388588,"threshold_uncertainty_score":0.7985203,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02059763017725208,"score_gpt":0.2174479506907152,"score_spread":0.1968503205134631,"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."}}