{"id":"https://openalex.org/W2162238608","doi":"https://doi.org/10.1145/1989323.1989384","title":"Sharing work in keyword search over databases","display_name":"Sharing work in keyword search over databases","publication_year":2011,"publication_date":"2011-06-12","ids":{"openalex":"https://openalex.org/W2162238608","doi":"https://doi.org/10.1145/1989323.1989384","mag":"2162238608"},"language":"en","primary_location":{"id":"doi:10.1145/1989323.1989384","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989323.1989384","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://repository.upenn.edu/bitstreams/9f916803-e0e3-4e07-99af-3119fa4889a0/download","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086888117","display_name":"Marie Jacob","orcid":null},"institutions":[{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Marie Jacob","raw_affiliation_strings":["University Of Pennsylvania, Philadelphia, PA, USA"],"affiliations":[{"raw_affiliation_string":"University Of Pennsylvania, Philadelphia, PA, USA","institution_ids":["https://openalex.org/I79576946"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063822723","display_name":"Zachary G. Ives","orcid":"https://orcid.org/0000-0001-7527-2957"},"institutions":[{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zachary Ives","raw_affiliation_strings":["University Of Pennsylvania, Philadelphia, PA, USA"],"affiliations":[{"raw_affiliation_string":"University Of Pennsylvania, Philadelphia, PA, USA","institution_ids":["https://openalex.org/I79576946"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5086888117"],"corresponding_institution_ids":["https://openalex.org/I79576946"],"apc_list":null,"apc_paid":null,"fwci":2.1926,"has_fulltext":true,"cited_by_count":10,"citation_normalized_percentile":{"value":0.88918865,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"577","last_page":"588"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":1.0,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":1.0,"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/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.998199999332428,"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.873382568359375},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6161888837814331},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5935372710227966},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5431865453720093},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.5418627262115479},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.47701454162597656},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4589657783508301},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4493709206581116},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.4400344789028168},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.43307650089263916},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.43270143866539},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.4326848089694977},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.4259995222091675},{"id":"https://openalex.org/keywords/result-set","display_name":"Result set","score":0.4248633086681366},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3718988597393036},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.33827245235443115},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.26639360189437866}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.873382568359375},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6161888837814331},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5935372710227966},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5431865453720093},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.5418627262115479},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.47701454162597656},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4589657783508301},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4493709206581116},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.4400344789028168},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.43307650089263916},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.43270143866539},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.4326848089694977},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.4259995222091675},{"id":"https://openalex.org/C4969071","wikidata":"https://www.wikidata.org/wiki/Q7316353","display_name":"Result set","level":3,"score":0.4248633086681366},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3718988597393036},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.33827245235443115},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.26639360189437866},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","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/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"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":3,"locations":[{"id":"doi:10.1145/1989323.1989384","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989323.1989384","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:repository.upenn.edu:cis_papers-1657","is_oa":true,"landing_page_url":"https://repository.upenn.edu/cis_papers/619","pdf_url":"https://repository.upenn.edu/bitstreams/9f916803-e0e3-4e07-99af-3119fa4889a0/download","source":{"id":"https://openalex.org/S4306402083","display_name":"ScholarlyCommons (University of Pennsylvania)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I79576946","host_organization_name":"University of Pennsylvania","host_organization_lineage":["https://openalex.org/I79576946"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Departmental Papers (CIS)","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.221.5754","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.221.5754","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cis.upenn.edu/%7Ezives/research/atc.pdf","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:repository.upenn.edu:cis_papers-1657","is_oa":true,"landing_page_url":"https://repository.upenn.edu/cis_papers/619","pdf_url":"https://repository.upenn.edu/bitstreams/9f916803-e0e3-4e07-99af-3119fa4889a0/download","source":{"id":"https://openalex.org/S4306402083","display_name":"ScholarlyCommons (University of Pennsylvania)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I79576946","host_organization_name":"University of Pennsylvania","host_organization_lineage":["https://openalex.org/I79576946"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Departmental Papers (CIS)","raw_type":"text"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G21394388","display_name":"III: Distributed Stream Integration","funder_award_id":"0713267","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6489217689","display_name":"CAREER: Orchestra - Managing the Collaborative Sharing of Evolving Data","funder_award_id":"0447972","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7540637181","display_name":"III: EAGER: Data Integration as a Dialogue with the User","funder_award_id":"1050448","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2162238608.pdf","grobid_xml":"https://content.openalex.org/works/W2162238608.grobid-xml"},"referenced_works_count":36,"referenced_works":["https://openalex.org/W1981585544","https://openalex.org/W2038281398","https://openalex.org/W2058978608","https://openalex.org/W2084538728","https://openalex.org/W2098388305","https://openalex.org/W2098416578","https://openalex.org/W2099797738","https://openalex.org/W2100408869","https://openalex.org/W2103701698","https://openalex.org/W2105981469","https://openalex.org/W2106105896","https://openalex.org/W2106376606","https://openalex.org/W2116544254","https://openalex.org/W2116926680","https://openalex.org/W2116936708","https://openalex.org/W2118265701","https://openalex.org/W2121350579","https://openalex.org/W2122483056","https://openalex.org/W2132461362","https://openalex.org/W2133863472","https://openalex.org/W2134755874","https://openalex.org/W2136195851","https://openalex.org/W2143682328","https://openalex.org/W2148942721","https://openalex.org/W2152191782","https://openalex.org/W2155048531","https://openalex.org/W2156580346","https://openalex.org/W2162238608","https://openalex.org/W2169624745","https://openalex.org/W2171147420","https://openalex.org/W2171743956","https://openalex.org/W2171874178","https://openalex.org/W2666600683","https://openalex.org/W2766000922","https://openalex.org/W3005908620","https://openalex.org/W4251369550"],"related_works":["https://openalex.org/W2006459955","https://openalex.org/W203907944","https://openalex.org/W3125756434","https://openalex.org/W906795786","https://openalex.org/W2004087594","https://openalex.org/W4386051213","https://openalex.org/W185198413","https://openalex.org/W3049728138","https://openalex.org/W2547322140","https://openalex.org/W2395498354"],"abstract_inverted_index":{"An":[0],"important":[1],"means":[2],"of":[3,27,45,91,149,196,201,226,241],"allowing":[4],"non-expert":[5],"end-users":[6],"to":[7,52,96,109,117,155,186,208,220],"pose":[8],"ad":[9,119],"hoc":[10,120],"queries":[11,79,123,229,246],"whether":[12],"over":[13,124,247],"single":[14],"databases":[15,128],"or":[16,84,126],"data":[17,121,233,251],"integration":[18,122],"systems":[19],"is":[20,71,94],"through":[21],"keyword":[22,61,115,151],"search.":[23],"Given":[24],"a":[25,43,172,199],"set":[26,44],"keywords,":[28],"the":[29,54,89,130,180,194,205,210,222,239],"query":[30,70,164,168,174],"processor":[31],"finds":[32],"matches":[33],"across":[34,158],"different":[35,82,86],"tuples":[36,197],"and":[37,41,88,135,153,166,170,224,231,249],"tables.":[38],"It":[39],"computes":[40],"executes":[42],"relational":[46],"sub-queries":[47,101],"whose":[48],"results":[49],"are":[50,235],"combined":[51],"produce":[53],"k":[55],"highest":[56],"ranking":[57],"answers.":[58],"Work":[59],"on":[60,65,129,183],"search":[62,116],"primarily":[63],"focuses":[64],"single-database,":[66],"single-query":[67],"settings:":[68],"each":[69],"answered":[72],"in":[73,244],"isolation,":[74],"despite":[75],"possible":[76],"overlap":[77],"between":[78],"posed":[80],"by":[81],"users":[83],"at":[85],"times;":[87],"number":[90],"relevant":[92],"tables":[93],"assumed":[95],"be":[97,103],"small,":[98],"meaning":[99],"that":[100,145],"can":[102],"processed":[104],"without":[105],"using":[106],"cost-based":[107],"methods":[108],"combine":[110,136],"work.":[111],"As":[112],"we":[113,132,141,178],"apply":[114],"support":[118],"scientific":[125],"other":[127],"Web,":[131],"must":[133],"reuse":[134,156,225],"computation.":[137],"In":[138],"this":[139],"paper,":[140],"propose":[142],"an":[143,187],"architecture":[144],"continuously":[146],"receives":[147],"sets":[148],"ranked":[150],"queries,":[152],"seeks":[154],"work":[157,206],"these":[159],"queries.":[160,215],"We":[161,216,237],"extend":[162],"multiple":[163],"optimization":[165],"continuous":[167],"techniques,":[169],"develop":[171,218],"new":[173],"plan":[175],"scheduling":[176],"module":[177],"call":[179],"ATC":[181,192],"(based":[182],"its":[184],"analogy":[185],"air":[188],"traffic":[189],"controller).":[190],"The":[191],"manages":[193],"flow":[195],"among":[198],"multitude":[200],"pipelined":[202],"operators,":[203],"minimizing":[204],"needed":[207],"return":[209],"top-k":[211],"answers":[212],"for":[213],"all":[214],"also":[217],"techniques":[219,243],"manage":[221],"sharing":[223],"state":[227],"as":[228],"complete":[230],"input":[232],"streams":[234],"exhausted.":[236],"show":[238],"effectiveness":[240],"our":[242],"handling":[245],"real":[248],"synthetic":[250],"sets.":[252]},"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}