{"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":"codex-gemma-dda1882f352a","candidate_categories":["metaresearch","metaepi_narrow","scholarly_communication"],"consensus_categories":["scholarly_communication"],"category_scores_codex":[0.0008514217,0.0003399492,0.0007014759,0.0002772725,0.0002216346,0.00184857,0.004388153,0.0001915911,0.00002202674],"category_scores_gemma":[0.01295372,0.0002760394,0.0001579239,0.001474028,0.0008562485,0.03953198,0.002437373,0.000248296,0.00000577163],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0000472631,"about_ca_system_score_gemma":0.0007631745,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0007791262,"about_ca_topic_score_gemma":0.00001910451,"domain_scores_codex":[0.9972267,0.00001775603,0.001082259,0.0005568275,0.0005532937,0.0005631835],"domain_scores_gemma":[0.9215463,0.0003207869,0.00229919,0.0008807589,0.07476795,0.0001849645],"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.00006626696,0.0004112402,0.01568598,0.008243582,0.0001698055,2.577464e-7,0.02358305,0.00001367514,0.007768156,0.4268766,0.01471919,0.5024622],"study_design_scores_gemma":[0.0007722601,0.0004120762,0.009822848,0.001710619,0.0001637133,0.00004902535,0.003913892,0.01907027,0.02017032,0.0135217,0.9298183,0.0005750323],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.1814169,0.01257291,0.7544828,0.01648197,0.001242626,0.008092356,0.009401434,0.0001916723,0.01611727],"genre_scores_gemma":[0.9149864,0.0003282523,0.08154908,0.0001522607,0.0002177707,0.0002995948,0.00004406243,0.00003224993,0.002390286],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.9150991,"threshold_uncertainty_score":0.9999692,"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."}}