{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.004820817,0.001062896,0.001835102,0.00243418,0.001974498,0.005993534,0.003934318,0.001164241,0.01035679],"category_scores_gemma":[0.01145635,0.0009203605,0.001121939,0.003128452,0.0006396542,0.006552477,0.005223725,0.002385,0.005831874],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0009930937,"about_ca_system_score_gemma":0.003077296,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001211888,"about_ca_topic_score_gemma":0.001588729,"domain_scores_codex":[0.9961523,0.0004767656,0.0004710682,0.0005962401,0.002039975,0.0002635235],"domain_scores_gemma":[0.9924064,0.001397761,0.0004411824,0.003071391,0.001948116,0.0007351911],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.002165738,0.0006721076,0.007821194,0.0007558986,0.0002943273,0.0005386073,0.0009207583,0.01330918,0.03929382,0.1385424,0.08106077,0.7146254],"study_design_scores_gemma":[0.000667378,0.001012039,0.002771806,0.0002240872,0.0003746982,0.001685847,0.0005454932,0.3865086,0.1272822,0.1068648,0.3717673,0.0002957959],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.01133149,0.001257706,0.9564987,0.000428214,0.0004159395,0.001008183,0.001401043,0.01559687,0.01206189],"genre_scores_gemma":[0.1199882,0.001135413,0.8568521,0.000384376,0.0003890638,0.000879036,0.00624671,0.001852584,0.0122727],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.01035679,"threshold_uncertainty_score":0.03464687,"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."}}