{"id":"W4378782364","doi":"10.2196/44567","title":"Migrating a Well-Established Longitudinal Cohort Database From Oracle SQL to Research Electronic Data Entry (REDCap): Data Management Research and Design Study","year":2023,"lang":"en","type":"article","venue":"JMIR Formative Research","topic":"Data Quality and Management","field":"Decision Sciences","cited_by":3,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"Schweizerischer Nationalfonds zur Förderung der Wissenschaftlichen Forschung; National Science Foundation","keywords":"Electronic data capture; Computer science; Data quality; Database; Data management; Electronic data; SQL; Information retrieval; Data collection; Data mining; Metric (unit); Engineering; Statistics","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","sts","scholarly_communication","open_science","research_integrity","insufficient_payload"],"consensus_categories":["metaresearch","open_science","insufficient_payload"],"category_scores_codex":[0.2481366,0.0003969518,0.000694721,0.00481932,0.003064079,0.004907969,0.01651113,0.0001277674,0.000973666],"category_scores_gemma":[0.01143789,0.0003246498,0.00004054949,0.01677958,0.0009773123,0.006733782,0.06904036,0.002883151,0.008732522],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0004967987,"about_ca_system_score_gemma":0.0005623385,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00540543,"about_ca_topic_score_gemma":0.004706711,"domain_scores_codex":[0.9549807,0.01488994,0.001760678,0.004527987,0.01979944,0.004041228],"domain_scores_gemma":[0.9651117,0.01806834,0.0001876036,0.01344516,0.002336537,0.0008506417],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"not_applicable","study_design_gemma":"not_applicable","study_design_scores_codex":[0.0007968618,0.001399234,0.007731598,0.0000985278,0.0003190421,0.0003686462,0.00850148,0.00001749756,0.00007894857,0.003810874,0.9468501,0.03002722],"study_design_scores_gemma":[0.003121758,0.003460468,0.1329654,0.0004138916,0.00004985702,0.000007947308,0.3748679,0.04063523,0.0002191796,0.03508473,0.4082595,0.00091422],"study_design_candidate":"not_applicable","study_design_consensus":"not_applicable","genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.9284973,0.0007575607,0.01576901,0.01014641,0.0004821965,0.02178962,0.009402269,0.0003821148,0.01277358],"genre_scores_gemma":[0.9800348,0.00110609,0.002666684,0.00007851396,0.0002883286,0.001635689,0.00690519,0.00007701878,0.00720773],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.5385906,"threshold_uncertainty_score":0.9999396,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.6685705021262548,"score_gpt":0.6015098240105905,"score_spread":0.0670606781156643,"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."}}