{"id":"W2294688766","doi":"10.5441/002/edbt.2014.81","title":"Business-Intelligence Queries with Order Dependencies in DB2","year":2014,"lang":"en","type":"article","venue":"Movebank","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":13,"is_retracted":false,"has_abstract":true,"ca_institutions":"York University; University of Toronto","funders":"","keywords":"Computer science; Functional dependency; Dependency (UML); Query optimization; Online analytical processing; Exploit; Data integrity; Theoretical computer science; Data mining; Relational database; Data warehouse; Database; Artificial intelligence","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.004531212,0.002300541,0.00147502,0.002106775,0.00183102,0.007261616,0.004534801,0.001578036,0.006351278],"category_scores_gemma":[0.01020593,0.002342365,0.002151047,0.005773745,0.002019888,0.01199666,0.004193677,0.003601641,0.002580388],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.003390123,"about_ca_system_score_gemma":0.004019684,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.03022858,"about_ca_topic_score_gemma":0.02671037,"domain_scores_codex":[0.9907545,0.001570518,0.001067859,0.001617768,0.004446959,0.0005423139],"domain_scores_gemma":[0.9945648,0.002138937,0.000359536,0.001849549,0.0008287856,0.0002584817],"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.004767509,0.00134366,0.0178757,0.002077942,0.0004725234,0.001783047,0.003486973,0.106819,0.04034226,0.2836576,0.2290952,0.3082786],"study_design_scores_gemma":[0.001038334,0.0002823838,0.004994334,0.0002400483,0.0002301891,0.001154026,0.0009530153,0.3962432,0.08544061,0.1671138,0.3419406,0.0003694838],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.07150158,0.00177514,0.7115963,0.002536674,0.0002412053,0.0007105739,0.02905408,0.1527145,0.02987009],"genre_scores_gemma":[0.2699172,0.001185005,0.6393968,0.00191892,0.0001561393,0.0008800323,0.06429668,0.01207593,0.01017332],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.03022858,"threshold_uncertainty_score":0.06010526,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.007416451325730401,"score_gpt":0.2079642064700216,"score_spread":0.2005477551442912,"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."}}