{"id":"https://openalex.org/W2062847767","doi":"https://doi.org/10.1145/2463664.2463670","title":"A dichotomy in the intensional expressive power of nested relational calculi augmented with aggregate functions and a powerset operator","display_name":"A dichotomy in the intensional expressive power of nested relational calculi augmented with aggregate functions and a powerset operator","publication_year":2013,"publication_date":"2013-06-22","ids":{"openalex":"https://openalex.org/W2062847767","doi":"https://doi.org/10.1145/2463664.2463670","mag":"2062847767"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463664.2463670","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://www.comp.nus.edu.sg/~wongls/psZ/pods47-wong.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5012381970","display_name":"Limsoon Wong","orcid":"https://orcid.org/0000-0003-1241-5441"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"funder","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Limsoon Wong","raw_affiliation_strings":[" National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":" National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5012381970"],"corresponding_institution_ids":["https://openalex.org/I165932596"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":2,"citation_normalized_percentile":{"value":0.369693,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":72,"max":76},"biblio":{"volume":null,"issue":null,"first_page":"285","last_page":"296"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9999,"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.9999,"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.9992,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.999,"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/transitive-closure","display_name":"Transitive closure","score":0.70232594},{"id":"https://openalex.org/keywords/expressive-power","display_name":"Expressive power","score":0.5436823}],"concepts":[{"id":"https://openalex.org/C128896722","wikidata":"https://www.wikidata.org/wiki/Q1501387","display_name":"Transitive closure","level":2,"score":0.70232594},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.64588153},{"id":"https://openalex.org/C195818886","wikidata":"https://www.wikidata.org/wiki/Q5421724","display_name":"Expressive power","level":2,"score":0.5436823},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.50943285},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.4946389},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.4710816},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4634573},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.4331992},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.43175194},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4235791},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.40994495},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3755235},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3345831},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.32391703},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.27157176},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.213777},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1727218},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"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/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463664.2463670","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},{"is_oa":true,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.310.496","pdf_url":"http://www.comp.nus.edu.sg/~wongls/psZ/pods47-wong.pdf","source":{"id":"https://openalex.org/S4306400349","display_name":"CiteSeer X (The Pennsylvania State University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":false,"host_organization":"https://openalex.org/I130769515","host_organization_name":"Pennsylvania State University","host_organization_lineage":["https://openalex.org/I130769515"],"host_organization_lineage_names":["Pennsylvania State University"],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false}],"best_oa_location":{"is_oa":true,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.310.496","pdf_url":"http://www.comp.nus.edu.sg/~wongls/psZ/pods47-wong.pdf","source":{"id":"https://openalex.org/S4306400349","display_name":"CiteSeer X (The Pennsylvania State University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":false,"host_organization":"https://openalex.org/I130769515","host_organization_name":"Pennsylvania State University","host_organization_lineage":["https://openalex.org/I130769515"],"host_organization_lineage_names":["Pennsylvania State University"],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false},"sustainable_development_goals":[{"display_name":"Quality education","id":"https://metadata.un.org/sdg/4","score":0.58}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":16,"referenced_works":["https://openalex.org/W1517150411","https://openalex.org/W1783911651","https://openalex.org/W1871862344","https://openalex.org/W1964950079","https://openalex.org/W1966181449","https://openalex.org/W1972514879","https://openalex.org/W1974959615","https://openalex.org/W1975126353","https://openalex.org/W1975880448","https://openalex.org/W2025969711","https://openalex.org/W2029138494","https://openalex.org/W2093009437","https://openalex.org/W2125327296","https://openalex.org/W2130872776","https://openalex.org/W2134752848","https://openalex.org/W2339920159"],"related_works":["https://openalex.org/W40097694","https://openalex.org/W2985952940","https://openalex.org/W2243465518","https://openalex.org/W2150575980","https://openalex.org/W2089781037","https://openalex.org/W2085988990","https://openalex.org/W2005835473","https://openalex.org/W1883829184","https://openalex.org/W1601244756","https://openalex.org/W1580881779"],"abstract_inverted_index":{"The":[0],"extensional":[1],"aspect":[2,34],"of":[3,16,19,26,35,56,127,136,148,172],"expressive":[4,36,54,155],"power---i.e.,":[5,37],"what":[6,38],"queries":[7,39,79,166],"can":[8,40],"or":[9,41,106],"cannot":[10,42],"be":[11,43],"expressed---has":[12],"been":[13,46],"the":[14,32,52,99,103,132,145],"subject":[15],"many":[17],"studies":[18],"query":[20,156,191],"languages.":[21],"Paradoxically,":[22],"although":[23],"efficiency":[24],"is":[25,184],"primary":[27],"concern":[28],"in":[29,98,116],"computer":[30],"science,":[31],"intensional":[33,53],"implemented":[44],"efficiently---has":[45],"much":[47],"neglected.":[48],"Here,":[49],"we":[50],"discuss":[51],"power":[55],"NRC(Q,":[57],"+,":[58],"\u00b7,":[59],"\u200f,":[60],"\u00f7,":[61],"\u03a3,":[62],"powerset),":[63],"a":[64,73,90,149,153,168,175,194,200],"nested":[65],"relational":[66],"calculus":[67,100],"augmented":[68],"with":[69],"aggregate":[70],"functions":[71],"and":[72,129,138,187,198],"powerset":[74,104],"operation.":[75],"We":[76],"show":[77],"that":[78,126,131,160],"on":[80,167],"structures":[81,173],"such":[82,124],"as":[83,125],"long":[84,150,176],"chains,":[85],"deep":[86],"trees,":[87],"etc.":[88],"have":[89],"dichotomous":[91],"behaviour:":[92],"Either":[93],"they":[94,107],"are":[95,178],"already":[96],"expressible":[97],"without":[101],"using":[102],"operation":[105],"require":[108],"at":[109],"least":[110],"exponential":[111,141],"space.":[112],"This":[113],"result":[114],"generalizes":[115],"three":[117],"significant":[118],"ways":[119],"several":[120],"old":[121],"dichotomy-like":[122],"results,":[123],"Suciu":[128],"Paredaens":[130],"complex":[133],"object":[134],"algebra":[135],"Abiteboul":[137],"Beeri":[139],"needs":[140],"space":[142],"to":[143],"implement":[144],"transitive":[146],"closure":[147],"chain.":[151],"Firstly,":[152],"more":[154,169,185],"language---in":[157],"particular,":[158],"one":[159],"captures":[161],"SQL---is":[162],"considered":[163,179],"here.":[164,180],"Secondly,":[165],"general":[170,186],"class":[171],"than":[174],"chain":[177],"Lastly,":[181],"our":[182],"proof":[183],"holds":[188],"for":[189],"all":[190],"languages":[192],"exhibiting":[193],"certain":[195],"normal":[196],"form":[197],"possessing":[199],"locality":[201],"property.":[202]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2062847767","counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":1}],"updated_date":"2025-03-16T09:44:05.314828","created_date":"2016-06-24"}