{"id":"https://openalex.org/W2121433213","doi":"https://doi.org/10.1145/1386118.1386119","title":"Probabilistic top- <i>k</i> and ranking-aggregate queries","display_name":"Probabilistic top- <i>k</i> and ranking-aggregate queries","publication_year":2008,"publication_date":"2008-08-01","ids":{"openalex":"https://openalex.org/W2121433213","doi":"https://doi.org/10.1145/1386118.1386119","mag":"2121433213"},"language":"en","primary_location":{"id":"doi:10.1145/1386118.1386119","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1386118.1386119","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5046525599","display_name":"Mohamed A. Soliman","orcid":"https://orcid.org/0000-0001-8916-9133"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mohamed A. Soliman","raw_affiliation_strings":["University of Waterloo, Ontario, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Waterloo, Ontario, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000141065","display_name":"Ihab F. Ilyas","orcid":"https://orcid.org/0000-0001-9052-9714"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ihab F. Ilyas","raw_affiliation_strings":["University of Waterloo, Ontario, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Waterloo, Ontario, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101880377","display_name":"Kevin Chen\u2013Chuan Chang","orcid":"https://orcid.org/0000-0003-0997-6803"},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kevin Chen--Chuan Chang","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, Urbana, IL","[University of Illinois at Urbana-Champaign,Urbana,IL]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, Urbana, IL","institution_ids":["https://openalex.org/I157725225"]},{"raw_affiliation_string":"[University of Illinois at Urbana-Champaign,Urbana,IL]","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":13.1672,"has_fulltext":false,"cited_by_count":87,"citation_normalized_percentile":{"value":0.99048249,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"33","issue":"3","first_page":"1","last_page":"54"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9962999820709229,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.872341513633728},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.7292349338531494},{"id":"https://openalex.org/keywords/probabilistic-logic","display_name":"Probabilistic logic","score":0.6506181359291077},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6386750936508179},{"id":"https://openalex.org/keywords/uncertain-data","display_name":"Uncertain data","score":0.5850485563278198},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5809425711631775},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5481621623039246},{"id":"https://openalex.org/keywords/probabilistic-database","display_name":"Probabilistic database","score":0.5443456172943115},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.49914121627807617},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.48638179898262024},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.4857542812824249},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4789201021194458},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.4650118947029114},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.45955976843833923},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3995327353477478},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.31256014108657837},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.2589806616306305},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.21374845504760742},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.17955344915390015},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13839101791381836},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.10892641544342041},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.08059075474739075},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.07810622453689575}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.872341513633728},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.7292349338531494},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.6506181359291077},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6386750936508179},{"id":"https://openalex.org/C2778865114","wikidata":"https://www.wikidata.org/wiki/Q7882489","display_name":"Uncertain data","level":2,"score":0.5850485563278198},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5809425711631775},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5481621623039246},{"id":"https://openalex.org/C174539288","wikidata":"https://www.wikidata.org/wiki/Q7246853","display_name":"Probabilistic database","level":4,"score":0.5443456172943115},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.49914121627807617},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.48638179898262024},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.4857542812824249},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4789201021194458},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.4650118947029114},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.45955976843833923},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3995327353477478},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.31256014108657837},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.2589806616306305},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.21374845504760742},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.17955344915390015},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13839101791381836},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.10892641544342041},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.08059075474739075},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.07810622453689575},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1386118.1386119","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1386118.1386119","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.6200000047683716,"display_name":"Peace, Justice and strong institutions"}],"awards":[{"id":"https://openalex.org/G5948100316","display_name":null,"funder_award_id":"311671-05","funder_id":"https://openalex.org/F4320334593","funder_display_name":"Natural Sciences and Engineering Research Council of Canada"}],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W1486776102","https://openalex.org/W1600580971","https://openalex.org/W1612155886","https://openalex.org/W1969483458","https://openalex.org/W1990391007","https://openalex.org/W1998792254","https://openalex.org/W2024400846","https://openalex.org/W2041882671","https://openalex.org/W2044494469","https://openalex.org/W2045630074","https://openalex.org/W2066406253","https://openalex.org/W2066720893","https://openalex.org/W2078686663","https://openalex.org/W2083613374","https://openalex.org/W2084538728","https://openalex.org/W2102869387","https://openalex.org/W2103201239","https://openalex.org/W2110993096","https://openalex.org/W2112130143","https://openalex.org/W2115826669","https://openalex.org/W2118966476","https://openalex.org/W2120825705","https://openalex.org/W2125402103","https://openalex.org/W2129035130","https://openalex.org/W2138271690","https://openalex.org/W2143682328","https://openalex.org/W2153259545","https://openalex.org/W2166855749","https://openalex.org/W2166916904","https://openalex.org/W2166994031","https://openalex.org/W2171492933","https://openalex.org/W2221389368","https://openalex.org/W2296677182","https://openalex.org/W2666600683","https://openalex.org/W3002980296","https://openalex.org/W3092497216"],"related_works":["https://openalex.org/W2113053869","https://openalex.org/W2118370002","https://openalex.org/W2147835952","https://openalex.org/W2799088404","https://openalex.org/W2595974764","https://openalex.org/W2068447118","https://openalex.org/W1594296362","https://openalex.org/W2556083537","https://openalex.org/W1581724699","https://openalex.org/W1972675523"],"abstract_inverted_index":{"Ranking":[0,39],"and":[1,12,22,40,51,85,122,127,140,157],"aggregation":[2,23],"queries":[3,87],"are":[4,93],"widely":[5],"used":[6],"in":[7,48,70,88,130],"data":[8,10,33,44,179],"exploration,":[9],"analysis,":[11],"decision-making":[13],"scenarios.":[14],"While":[15],"most":[16],"of":[17,97,109,154,160,174,183],"the":[18,71,107,152,158,172],"currently":[19],"proposed":[20,149],"ranking":[21,64],"techniques":[24,150,176],"focus":[25],"on":[26,95],"deterministic":[27],"data,":[28],"several":[29],"emerging":[30],"applications":[31],"involve":[32],"that":[34,66],"is":[35],"unclean":[36],"or":[37],"uncertain.":[38],"aggregating":[41],"uncertain":[42],"(probabilistic)":[43],"raises":[45],"new":[46,63,79],"challenges":[47],"query":[49,120,125,146,166],"semantics":[50,101],"processing,":[52],"making":[53],"conventional":[54],"methods":[55],"inapplicable.":[56],"Furthermore,":[57],"uncertainty":[58],"imposes":[59],"probability":[60],"as":[61],"a":[62,114,136],"dimension":[65],"does":[67],"not":[68],"exist":[69],"traditional":[72,98],"settings.":[73],"In":[74,106],"this":[75],"article":[76],"we":[77,112],"introduce":[78],"probabilistic":[80,89],"formulations":[81,92],"for":[82],"top-":[83,99],"k":[84,100],"ranking-aggregate":[86],"databases.":[90],"Our":[91,148,168],"based":[94],"marriage":[96],"with":[102,181],"possible":[103],"worlds":[104],"semantics.":[105],"light":[108],"these":[110],"formulations,":[111],"construct":[113],"generic":[115],"processing":[116,126],"framework":[117,134],"supporting":[118],"both":[119],"types,":[121],"leveraging":[123],"existing":[124],"indexing":[128],"capabilities":[129],"current":[131],"RDBMSs.":[132],"The":[133],"encapsulates":[135],"state":[137],"space":[138,163],"model":[139],"efficient":[141],"search":[142,162],"algorithms":[143],"to":[144,164],"compute":[145,165],"answers.":[147,167],"minimize":[151],"number":[153],"accessed":[155],"tuples":[156],"size":[159],"materialized":[161],"experimental":[169],"study":[170],"shows":[171],"efficiency":[173],"our":[175],"under":[177],"different":[178],"distributions":[180],"orders":[182],"magnitude":[184],"improvement":[185],"over":[186],"na\u00efve":[187],"methods.":[188]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":10}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}