{"id":"https://openalex.org/W3008396642","doi":"https://doi.org/10.1109/bigdata47090.2019.9005486","title":"PsiDB: A Framework for Batched Query Processing and Optimization","display_name":"PsiDB: A Framework for Batched Query Processing and Optimization","publication_year":2019,"publication_date":"2019-12-01","ids":{"openalex":"https://openalex.org/W3008396642","doi":"https://doi.org/10.1109/bigdata47090.2019.9005486","mag":"3008396642"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata47090.2019.9005486","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata47090.2019.9005486","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-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/A5040638653","display_name":"Mehrad Eslami","orcid":"https://orcid.org/0000-0001-9415-0541"},"institutions":[{"id":"https://openalex.org/I2613432","display_name":"University of South Florida","ror":"https://ror.org/032db5x82","country_code":"US","type":"education","lineage":["https://openalex.org/I2613432"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Mehrad Eslami","raw_affiliation_strings":["Dept. of Computer Science, University of South Florida, Tampa, Florida, USA"],"affiliations":[{"raw_affiliation_string":"Dept. of Computer Science, University of South Florida, Tampa, Florida, USA","institution_ids":["https://openalex.org/I2613432"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032673243","display_name":"Yi-Cheng Tu","orcid":"https://orcid.org/0000-0002-4062-2694"},"institutions":[{"id":"https://openalex.org/I2613432","display_name":"University of South Florida","ror":"https://ror.org/032db5x82","country_code":"US","type":"education","lineage":["https://openalex.org/I2613432"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yicheng Tu","raw_affiliation_strings":["Dept. of Computer Science, University of South Florida, Tampa, Florida, USA"],"affiliations":[{"raw_affiliation_string":"Dept. of Computer Science, University of South Florida, Tampa, Florida, USA","institution_ids":["https://openalex.org/I2613432"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058603314","display_name":"Hadi Charkhgard","orcid":"https://orcid.org/0000-0001-5416-6960"},"institutions":[{"id":"https://openalex.org/I2613432","display_name":"University of South Florida","ror":"https://ror.org/032db5x82","country_code":"US","type":"education","lineage":["https://openalex.org/I2613432"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hadi Charkhgard","raw_affiliation_strings":["Dept. of Industiral Engineering, University of South Florida, Tampa, Florida, USA"],"affiliations":[{"raw_affiliation_string":"Dept. of Industiral Engineering, University of South Florida, Tampa, Florida, USA","institution_ids":["https://openalex.org/I2613432"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041407793","display_name":"Zichen Xu","orcid":"https://orcid.org/0000-0001-9293-8028"},"institutions":[{"id":"https://openalex.org/I141649914","display_name":"Nanchang University","ror":"https://ror.org/042v6xz23","country_code":"CN","type":"education","lineage":["https://openalex.org/I141649914"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zichen Xu","raw_affiliation_strings":["Dept. of Computer Science, Nanchang University, Nanchang, Jiangxi, China"],"affiliations":[{"raw_affiliation_string":"Dept. of Computer Science, Nanchang University, Nanchang, Jiangxi, China","institution_ids":["https://openalex.org/I141649914"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5114734470","display_name":"Jiacheng Liu","orcid":"https://orcid.org/0000-0003-0846-9148"},"institutions":[{"id":"https://openalex.org/I52357470","display_name":"The Ohio State University","ror":"https://ror.org/00rs6vg23","country_code":"US","type":"education","lineage":["https://openalex.org/I52357470"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jiacheng Liu","raw_affiliation_strings":["Dept. of Computer Science, Ohio State University, Columbus, Ohio, USA"],"affiliations":[{"raw_affiliation_string":"Dept. of Computer Science, Ohio State University, Columbus, Ohio, USA","institution_ids":["https://openalex.org/I52357470"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5040638653"],"corresponding_institution_ids":["https://openalex.org/I2613432"],"apc_list":null,"apc_paid":null,"fwci":1.114,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.8130297,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"9","issue":null,"first_page":"6046","last_page":"6048"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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":0.9998999834060669,"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.9998000264167786,"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.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.8149770498275757},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.8029798269271851},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.6582289338111877},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5816449522972107},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5673491358757019},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.5027034282684326},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.49703720211982727},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.4870179295539856},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.47922876477241516},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4313170313835144},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4292929172515869},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4239109456539154},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4197959303855896},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3202551007270813},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.30298709869384766},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2613477110862732},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2029428482055664},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.17847251892089844},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1106036901473999},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.09121066331863403}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8149770498275757},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8029798269271851},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6582289338111877},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5816449522972107},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5673491358757019},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5027034282684326},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.49703720211982727},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.4870179295539856},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.47922876477241516},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4313170313835144},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4292929172515869},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4239109456539154},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4197959303855896},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3202551007270813},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.30298709869384766},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2613477110862732},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2029428482055664},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.17847251892089844},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1106036901473999},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09121066331863403},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1109/bigdata47090.2019.9005486","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata47090.2019.9005486","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"},{"id":"pmh:oai:scholarcommons.usf.edu:etd-9895","is_oa":false,"landing_page_url":"https://scholarcommons.usf.edu/etd/8698","pdf_url":null,"source":{"id":"https://openalex.org/S4377196272","display_name":"Digital Commons - University of South Florida (University of South Florida)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2613432","host_organization_name":"University of South Florida","host_organization_lineage":["https://openalex.org/I2613432"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Graduate Theses and Dissertations","raw_type":"dissertation"},{"id":"pmh:oai:digitalcommons.usf.edu:etd-9895","is_oa":false,"landing_page_url":"https://digitalcommons.usf.edu/etd/8698","pdf_url":null,"source":{"id":"https://openalex.org/S4377196272","display_name":"Digital Commons - University of South Florida (University of South Florida)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2613432","host_organization_name":"University of South Florida","host_organization_lineage":["https://openalex.org/I2613432"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"USF Tampa Graduate Theses and Dissertations","raw_type":"dissertation"},{"id":"mag:3042335016","is_oa":false,"landing_page_url":"https://jglobal.jst.go.jp/en/detail?JGLOBAL_ID=202002236148111351","pdf_url":null,"source":{"id":"https://openalex.org/S4306512817","display_name":"IEEE Conference Proceedings","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"IEEE Conference Proceedings","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4099999964237213,"id":"https://metadata.un.org/sdg/17","display_name":"Partnerships for the goals"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1987163291","https://openalex.org/W2089347259","https://openalex.org/W2100099053","https://openalex.org/W2159094846","https://openalex.org/W2342193205","https://openalex.org/W2605843372","https://openalex.org/W2951529282"],"related_works":["https://openalex.org/W2889903446","https://openalex.org/W2150741898","https://openalex.org/W3125756434","https://openalex.org/W2406556739","https://openalex.org/W185198413","https://openalex.org/W4281289408","https://openalex.org/W2034583622","https://openalex.org/W2186703450","https://openalex.org/W1971797742","https://openalex.org/W4381740310"],"abstract_inverted_index":{"While":[0],"work":[1],"in":[2,51,91,106],"Techniques":[3],"based":[4],"on":[5,126],"sharing":[6],"data":[7,72],"and":[8,14,32],"computation":[9],"among":[10],"queries":[11,50,95,115],"developed":[12],"algorithms":[13],"systems":[15],"that":[16,64],"are":[17],"shown":[18],"to":[19,58,112],"be":[20],"effective,":[21],"there":[22],"is":[23,57],"a":[24,40,45,52,60,66,84,133,138],"lack":[25],"of":[26,48,83,86,119,130],"logical":[27],"foundation":[28],"for":[29,43,74],"query":[30,62,121],"processing":[31,44],"optimization.":[33],"In":[34],"this":[35],"paper,":[36],"we":[37,79],"present":[38],"PsiDB,":[39],"system":[41],"model":[42],"large":[46],"number":[47],"database":[49],"batch.":[53],"The":[54],"key":[55],"idea":[56],"generate":[59],"single":[61],"expression":[63],"returns":[65],"global":[67,98],"relation":[68],"containing":[69],"all":[70],"the":[71,81,93,97,102,117],"needed":[73],"individual":[75,94],"queries.":[76],"For":[77],"that,":[78],"propose":[80],"use":[82],"type":[85],"relational":[87],"operators":[88],"called":[89],"\u03c8-operators":[90],"combining":[92],"into":[96],"expression.":[99],"We":[100],"tackle":[101],"algebraic":[103],"optimization":[104,122],"problem":[105],"PsiDB":[107,131],"by":[108],"developing":[109],"equivalence":[110],"rules":[111],"transform":[113],"concurrent":[114],"with":[116],"purpose":[118],"revealing":[120],"opportunities.":[123],"Experiments":[124],"conducted":[125],"an":[127],"early":[128],"prototype":[129],"show":[132],"major":[134],"performance":[135],"improvement":[136],"over":[137],"mainstream":[139],"commercial":[140],"DBMS.":[141]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}