{"id":"https://openalex.org/W2155778674","doi":"https://doi.org/10.1145/1807167.1807320","title":"PIQL","display_name":"PIQL","publication_year":2010,"publication_date":"2010-06-06","ids":{"openalex":"https://openalex.org/W2155778674","doi":"https://doi.org/10.1145/1807167.1807320","mag":"2155778674"},"language":"en","primary_location":{"id":"doi:10.1145/1807167.1807320","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1807167.1807320","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2010 ACM SIGMOD International Conference on Management of 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/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"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Michael Armbrust","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA, USA","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047090527","display_name":"Stephen Tu","orcid":"https://orcid.org/0000-0001-5178-8326"},"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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Stephen Tu","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA, USA","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Armando Fox","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA, USA","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael J. Franklin","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA, USA","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"David A. Patterson","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA, USA","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001001422","display_name":"Nick Lanham","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nick Lanham","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA, USA","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074747066","display_name":"Beth Trushkowsky","orcid":"https://orcid.org/0000-0001-8181-4222"},"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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Beth Trushkowsky","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA, USA","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035873257","display_name":"Jesse Trutna","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jesse Trutna","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA, USA","institution_ids":["https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5073379366"],"corresponding_institution_ids":["https://openalex.org/I95457486"],"apc_list":null,"apc_paid":null,"fwci":2.0811,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.9138126,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1207","last_page":"1210"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11181","display_name":"Advanced Data Storage Technologies","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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8757419586181641},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.7099793553352356},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.5437402129173279},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38649386167526245},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.15769264101982117}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8757419586181641},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.7099793553352356},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.5437402129173279},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38649386167526245},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.15769264101982117},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1807167.1807320","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1807167.1807320","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2010 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1981420413","https://openalex.org/W1990080756","https://openalex.org/W2129412326","https://openalex.org/W2546940556","https://openalex.org/W2963511602"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052","https://openalex.org/W4402327032","https://openalex.org/W2382290278"],"abstract_inverted_index":{"Large-scale":[0],"websites":[1],"are":[2,58],"increasingly":[3],"moving":[4],"from":[5],"relational":[6],"databases":[7],"to":[8,30,42,90],"distributed":[9],"key-value":[10,27],"stores":[11],"for":[12,48,111],"high":[13],"request":[14],"rate,":[15],"low":[16],"latency":[17],"workloads.":[18],"Often":[19],"this":[20,52],"move":[21],"is":[22],"motivated":[23],"not":[24],"only":[25,59],"by":[26,33,39,61,76],"stores'":[28],"ability":[29],"scale":[31],"simply":[32],"adding":[34],"more":[35],"hardware,":[36],"but":[37],"also":[38],"the":[40,77,94,106],"easy":[41],"understand":[43],"predictable":[44],"performance":[45],"they":[46],"provide":[47],"all":[49],"operations.":[50],"While":[51],"data":[53,74],"model":[54],"works":[55],"well,":[56],"lookups":[57,75],"done":[60],"primary":[62],"key.":[63],"More":[64],"complex":[65],"queries":[66,95],"require":[67],"onerous,":[68],"explicit":[69],"index":[70],"management":[71],"and":[72],"imperative":[73],"developer.":[78],"We":[79],"demonstrate":[80],"PIQL,":[81],"a":[82],"Performance":[83],"Insightful":[84],"Query":[85],"Language":[86],"that":[87],"allows":[88],"developers":[89],"express":[91],"many":[92],"of":[93,108],"found":[96],"on":[97,105],"these":[98],"websites,":[99],"while":[100],"still":[101],"providing":[102],"strict":[103],"bounds":[104],"number":[107],"I/O":[109],"operations":[110],"any":[112],"query.":[113]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}