{"id":"W2588114856","doi":"10.29173/cais314","title":"Applications of SQL for Informetric Data Processing","year":2013,"lang":"fr","type":"article","venue":"Proceedings of the Annual Conference of CAIS / Actes du congrès annuel de l ACSI","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":7,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"","keywords":"SQL; Computer science; Relational database; Informetrics; Data definition language; Raw data; Database; Data mining; Programming language; Bibliometrics","routes":{"ca_aff":false,"ca_fund":false,"ca_venue":true,"about_ca":false,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":["bibliometrics"],"consensus_categories":[],"category_scores_codex":[0.009930317,0.001203126,0.0008176893,0.003234038,0.001026781,0.00643472,0.002659263,0.001260009,0.01302744],"category_scores_gemma":[0.02243442,0.001105318,0.001480737,0.004533204,0.001643984,0.006727213,0.004480893,0.002690665,0.01003546],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0009576346,"about_ca_system_score_gemma":0.002170588,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001481236,"about_ca_topic_score_gemma":0.0008054459,"domain_scores_codex":[0.987743,0.003967795,0.002528462,0.001096519,0.004276941,0.0003873448],"domain_scores_gemma":[0.9808828,0.01025352,0.0006960758,0.004316131,0.003335125,0.0005163033],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.000577572,0.0002546323,0.003413698,0.00151549,0.0001384838,0.001370697,0.003187249,0.004991512,0.01809817,0.328054,0.1112866,0.5271118],"study_design_scores_gemma":[0.0001558392,0.0001786422,0.00137046,0.0005103975,0.0000793425,0.002139118,0.0009178065,0.07325231,0.02997014,0.191245,0.7000197,0.0001613686],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.002622214,0.000944555,0.9439144,0.00178604,0.0003133008,0.0003943517,0.001568268,0.0299843,0.01847266],"genre_scores_gemma":[0.05858026,0.002455263,0.9136758,0.002097714,0.0006845533,0.000498398,0.006408645,0.005928716,0.009670515],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.996766,"threshold_uncertainty_score":0.05251712,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.05025230150364443,"score_gpt":0.2873013640178965,"score_spread":0.2370490625142521,"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."}}