{"id":"https://openalex.org/W2008552727","doi":"https://doi.org/10.14778/2078331.2078334","title":"PIQL","display_name":"PIQL","publication_year":2011,"publication_date":"2011-11-01","ids":{"openalex":"https://openalex.org/W2008552727","doi":"https://doi.org/10.14778/2078331.2078334","mag":"2008552727"},"language":"en","primary_location":{"id":"doi:10.14778/2078331.2078334","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2078331.2078334","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","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/A5073379366","display_name":"Michael Armbrust","orcid":null},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]},{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Michael Armbrust","raw_affiliation_strings":["EECS, UC Berkeley","[EECS, UC,Berkeley]"],"affiliations":[{"raw_affiliation_string":"EECS, UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]},{"raw_affiliation_string":"[EECS, UC,Berkeley]","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028875963","display_name":"Kristal Curtis","orcid":"https://orcid.org/0000-0003-3253-9257"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kristal Curtis","raw_affiliation_strings":["EECS, UC Berkeley","[EECS, UC,Berkeley]"],"affiliations":[{"raw_affiliation_string":"EECS, UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]},{"raw_affiliation_string":"[EECS, UC,Berkeley]","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tim Kraska","raw_affiliation_strings":["EECS, UC Berkeley","[EECS, UC,Berkeley]"],"affiliations":[{"raw_affiliation_string":"EECS, UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]},{"raw_affiliation_string":"[EECS, UC,Berkeley]","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088855767","display_name":"Armando Fox","orcid":"https://orcid.org/0000-0002-6096-4931"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]},{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Armando Fox","raw_affiliation_strings":["EECS, UC Berkeley","[EECS, UC,Berkeley]"],"affiliations":[{"raw_affiliation_string":"EECS, UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]},{"raw_affiliation_string":"[EECS, UC,Berkeley]","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102019638","display_name":"Michael J. Franklin","orcid":"https://orcid.org/0000-0003-3332-8574"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]},{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael J. Franklin","raw_affiliation_strings":["EECS, UC Berkeley","[EECS, UC,Berkeley]"],"affiliations":[{"raw_affiliation_string":"EECS, UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]},{"raw_affiliation_string":"[EECS, UC,Berkeley]","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077202069","display_name":"David A. Patterson","orcid":"https://orcid.org/0000-0003-0902-7093"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]},{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"David A. Patterson","raw_affiliation_strings":["EECS, UC Berkeley","[EECS, UC,Berkeley]"],"affiliations":[{"raw_affiliation_string":"EECS, UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]},{"raw_affiliation_string":"[EECS, UC,Berkeley]","institution_ids":["https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5073379366"],"corresponding_institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"],"apc_list":null,"apc_paid":null,"fwci":7.7618,"has_fulltext":false,"cited_by_count":57,"citation_normalized_percentile":{"value":0.97447521,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"5","issue":"3","first_page":"181","last_page":"192"},"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.9998000264167786,"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.9998000264167786,"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.9993000030517578,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9988999962806702,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8235476016998291},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.688187301158905},{"id":"https://openalex.org/keywords/independence","display_name":"Independence (probability theory)","score":0.5572773814201355},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.518098771572113},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.507072925567627},{"id":"https://openalex.org/keywords/agile-software-development","display_name":"Agile software development","score":0.473396897315979},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38281673192977905},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.21241113543510437},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.09936705231666565}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8235476016998291},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.688187301158905},{"id":"https://openalex.org/C35651441","wikidata":"https://www.wikidata.org/wiki/Q625303","display_name":"Independence (probability theory)","level":2,"score":0.5572773814201355},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.518098771572113},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.507072925567627},{"id":"https://openalex.org/C14185376","wikidata":"https://www.wikidata.org/wiki/Q30232","display_name":"Agile software development","level":2,"score":0.473396897315979},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38281673192977905},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.21241113543510437},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.09936705231666565},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2078331.2078334","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2078331.2078334","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Climate action","score":0.7799999713897705,"id":"https://metadata.un.org/sdg/13"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W166430344","https://openalex.org/W1770193154","https://openalex.org/W1988716698","https://openalex.org/W2009688537","https://openalex.org/W2016194249","https://openalex.org/W2046183884","https://openalex.org/W2081182443","https://openalex.org/W2091071112","https://openalex.org/W2100773341","https://openalex.org/W2126707271","https://openalex.org/W2129412326","https://openalex.org/W2130923111","https://openalex.org/W2132497824","https://openalex.org/W2134206624","https://openalex.org/W2143682328","https://openalex.org/W2148322068","https://openalex.org/W2150013559","https://openalex.org/W2153704625","https://openalex.org/W2158237121","https://openalex.org/W2171707251","https://openalex.org/W2207067200","https://openalex.org/W2624304035","https://openalex.org/W2963511602","https://openalex.org/W4206002161","https://openalex.org/W4242297404","https://openalex.org/W4249823756","https://openalex.org/W4250159534"],"related_works":["https://openalex.org/W2656997359","https://openalex.org/W2389214306","https://openalex.org/W2022021367","https://openalex.org/W1973385172","https://openalex.org/W4319430762","https://openalex.org/W3125750421","https://openalex.org/W2965083567","https://openalex.org/W4235240664","https://openalex.org/W2083510688","https://openalex.org/W2294820933"],"abstract_inverted_index":{"Newly-released":[0],"web":[1],"applications":[2,59,141],"often":[3],"succumb":[4],"to":[5,138],"a":[6,19,30,54,89,118],"\"Success":[7],"Disaster,\"":[8],"where":[9],"overloaded":[10],"database":[11,33,129],"machines":[12,173],"and":[13,126,165,178],"resulting":[14],"high":[15],"response":[16],"times":[17],"destroy":[18],"previously":[20],"good":[21],"user":[22],"experience.":[23],"Unfortunately,":[24],"the":[25,42,76,83,103,160],"data":[26,80],"independence":[27,81,96,169],"provided":[28],"by":[29,44,97],"traditional":[31],"relational":[32,63],"system,":[34],"while":[35,150],"useful":[36],"for":[37,113,136],"agile":[38],"development,":[39],"only":[40],"exacerbates":[41],"problem":[43],"hiding":[45],"potentially":[46],"expensive":[47],"queries":[48],"under":[49],"simple":[50],"declarative":[51,90],"expressions.":[52],"As":[53],"result,":[55],"developers":[56,137],"of":[57,67,79,105,148,172],"these":[58,131],"are":[60],"increasingly":[61],"abandoning":[62],"databases":[64],"in":[65,82],"favor":[66],"imperative":[68],"code":[69],"written":[70],"against":[71],"distributed":[72],"key/value":[73,106],"stores,":[74],"losing":[75],"many":[77],"benefits":[78],"process.":[84],"Instead,":[85],"we":[86,158],"propose":[87],"PIQL,":[88],"language":[91],"that":[92,109,142],"also":[93],"provides":[94],"scale":[95,168],"calculating":[98],"an":[99,144],"upper":[100],"bound":[101],"on":[102,170],"number":[104,147],"store":[107],"operations":[108],"will":[110],"be":[111],"performed":[112],"any":[114],"query.":[115],"Coupled":[116],"with":[117],"service":[119],"level":[120],"objective":[121],"(SLO)":[122],"compliance":[123],"prediction":[124],"model":[125],"PIQL's":[127],"scalable":[128],"architecture,":[130],"bounds":[132],"make":[133],"it":[134],"easy":[135],"write":[139],"success-tolerant":[140],"support":[143],"arbitrarily":[145],"large":[146],"users":[149],"still":[151],"providing":[152],"acceptable":[153],"performance.":[154],"In":[155],"this":[156],"paper,":[157],"present":[159],"PIQL":[161],"query":[162],"processing":[163],"system":[164],"evaluate":[166],"its":[167],"hundreds":[171],"using":[174],"two":[175],"benchmarks,":[176],"TPC-W":[177],"SCADr.":[179]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":8},{"year":2014,"cited_by_count":9},{"year":2013,"cited_by_count":7},{"year":2012,"cited_by_count":4}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2016-06-24T00:00:00"}