{"id":"W1966404343","doi":"10.4018/jdwm.2012100103","title":"Efficient and Effective Aggregate Keyword Search on Relational Databases","year":2012,"lang":"en","type":"article","venue":"International Journal of Data Warehousing and Mining","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":3,"is_retracted":false,"has_abstract":true,"ca_institutions":"Simon Fraser University; Coquitlam College","funders":"Natural Sciences and Engineering Research Council of Canada","keywords":"Computer science; Aggregate (composite); Ranking (information retrieval); Keyword search; Relational database; Information retrieval; Keyword density; Database; Data mining","routes":{"ca_aff":true,"ca_fund":true,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.001049157,0.00008578477,0.0001007028,0.0002293303,0.00009658498,0.0001974925,0.0006355681,0.00001306554,0.000004254005],"category_scores_gemma":[0.0001465453,0.00007111464,0.00001613813,0.00008502306,0.00004507848,0.001481353,0.001025431,0.0001355664,0.000003677254],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002685104,"about_ca_system_score_gemma":0.00002345189,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.000009398776,"about_ca_topic_score_gemma":5.853216e-7,"domain_scores_codex":[0.998915,0.00005749801,0.0002043336,0.000184528,0.0004883477,0.0001503507],"domain_scores_gemma":[0.999098,0.0003188789,0.0001613454,0.0002245676,0.0001064969,0.00009072537],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00005881592,0.0001521947,0.00814024,0.000009879204,0.0001834667,0.00008570134,0.001168181,0.0006706942,0.0001109906,0.008064856,0.002622346,0.9787326],"study_design_scores_gemma":[0.004773966,0.000598199,0.09746931,0.002368552,0.0001368323,0.002098068,0.001085624,0.6753384,0.0009964195,0.0002663951,0.213931,0.0009372411],"study_design_candidate":"design_other","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.6274195,0.001113869,0.3672913,0.001999619,0.001516346,0.00008560344,0.0001281237,0.00002566957,0.0004199384],"genre_scores_gemma":[0.8918532,0.0001170076,0.1071872,0.0003514596,0.0003908159,5.686234e-7,0.00006032186,0.000006759575,0.00003272498],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.9777954,"threshold_uncertainty_score":0.2899971,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.08742456037480173,"score_gpt":0.3419586676621541,"score_spread":0.2545341072873524,"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."}}