{"id":"https://openalex.org/W2002171029","doi":"https://doi.org/10.1145/76902.76906","title":"Query processing techniques in the summary-table-by-example database query language","display_name":"Query processing techniques in the summary-table-by-example database query language","alternate_titles":[],"publication_year":1989,"publication_date":"1989-12-01","ids":{"openalex":"https://openalex.org/W2002171029","doi":"https://doi.org/10.1145/76902.76906","mag":"2002171029"},"language":"en","primary_location":{"id":"doi:10.1145/76902.76906","doi":"https://doi.org/10.1145/76902.76906","is_oa":true,"landing_page_url":"https://doi.org/10.1145/76902.76906","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/76902.76906","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2002171029"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/76902.76906","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5016412404","display_name":"G\u00fcltekin \u00d6zsoyo\u011flu","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I58956616","display_name":"Case Western Reserve University","ror":"https://ror.org/051fd9666","country_code":"US","type":"education","lineage":["https://openalex.org/I58956616"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gultekin \u00d6zsoyo\u011flu","raw_affiliation_strings":["Case Western Reserve Univ., Cleveland, OH","Case Western Reserve University, Cleveland,OH"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Case Western Reserve Univ., Cleveland, OH","institution_ids":["https://openalex.org/I58956616"]},{"raw_affiliation_string":"Case Western Reserve University, Cleveland,OH","institution_ids":["https://openalex.org/I58956616"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108430476","display_name":"Victor Matos","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I58956616","display_name":"Case Western Reserve University","ror":"https://ror.org/051fd9666","country_code":"US","type":"education","lineage":["https://openalex.org/I58956616"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Victor Matos","raw_affiliation_strings":["Case Western Reserve Univ., Cleveland, OH","Case Western Reserve University, Cleveland,OH"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Case Western Reserve Univ., Cleveland, OH","institution_ids":["https://openalex.org/I58956616"]},{"raw_affiliation_string":"Case Western Reserve University, Cleveland,OH","institution_ids":["https://openalex.org/I58956616"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5091049090","display_name":"Meral \u00d6zsoyo\u011flu","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I58956616","display_name":"Case Western Reserve University","ror":"https://ror.org/051fd9666","country_code":"US","type":"education","lineage":["https://openalex.org/I58956616"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Meral \u00d6zsoyo\u011flu","raw_affiliation_strings":["Case Western Reserve Univ., Cleveland, OH","Case Western Reserve University, Cleveland,OH"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Case Western Reserve Univ., Cleveland, OH","institution_ids":["https://openalex.org/I58956616"]},{"raw_affiliation_string":"Case Western Reserve University, Cleveland,OH","institution_ids":["https://openalex.org/I58956616"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I58956616"],"apc_list":null,"apc_paid":null,"fwci":5.4025,"has_fulltext":true,"cited_by_count":56,"citation_normalized_percentile":{"value":0.95247881,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":"14","issue":"4","first_page":"526","last_page":"573"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"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/T11106","display_name":"Data Management and Algorithms","score":9.999999747378752e-05,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/query-processing","display_name":"query processing","score":0.7080000042915344},{"id":"https://openalex.org/keywords/statistical-databases","display_name":"statistical databases","score":0.7450000047683716},{"id":"https://openalex.org/keywords/extended-relational-algebra","display_name":"extended relational algebra","score":0.8479999899864197},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.925000011920929},{"id":"https://openalex.org/keywords/outer-join","display_name":"outer join","score":0.8149999976158142},{"id":"https://openalex.org/keywords/graphical-query-language","display_name":"graphical query language","score":0.6169999837875366},{"id":"https://openalex.org/keywords/set-valued-attributes","display_name":"set-valued attributes","score":0.7540000081062317}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8754458427429199},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7407258749008179},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6446175575256348},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6132087111473083},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5905153751373291},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.5607074499130249},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5558729767799377},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5475181937217712},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5322815179824829},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.48091909289360046},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4738517105579376},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4677655100822449},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4559195637702942},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.44586315751075745},{"id":"https://openalex.org/C18912844","wikidata":"https://www.wikidata.org/wiki/Q4724001","display_name":"Algebraic expression","level":3,"score":0.4130743145942688},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40440914034843445},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.36252281069755554},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3530395030975342},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.34309667348861694},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3300284445285797},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.30477994680404663},{"id":"https://openalex.org/C9376300","wikidata":"https://www.wikidata.org/wiki/Q168817","display_name":"Algebraic number","level":2,"score":0.19080913066864014},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09347456693649292},{"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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/76902.76906","doi":"https://doi.org/10.1145/76902.76906","is_oa":true,"landing_page_url":"https://doi.org/10.1145/76902.76906","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/76902.76906","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/76902.76906","doi":"https://doi.org/10.1145/76902.76906","is_oa":true,"landing_page_url":"https://doi.org/10.1145/76902.76906","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/76902.76906","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G4590103389","display_name":"A Statistical Database Management System: Design,           Implementation and Experiments (Computer Research)","funder_award_id":"8306616","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6879650538","display_name":"Research in Databases with Nested Relations","funder_award_id":"8605554","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"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2002171029.pdf","grobid_xml":"https://content.openalex.org/works/W2002171029.grobid-xml"},"referenced_works_count":30,"referenced_works":["https://openalex.org/W49926830","https://openalex.org/W98593284","https://openalex.org/W116339858","https://openalex.org/W131984587","https://openalex.org/W136908855","https://openalex.org/W1481270797","https://openalex.org/W1492819930","https://openalex.org/W1505238579","https://openalex.org/W1548843970","https://openalex.org/W1561348834","https://openalex.org/W1655990431","https://openalex.org/W1902140340","https://openalex.org/W1986832527","https://openalex.org/W2005471433","https://openalex.org/W2008116177","https://openalex.org/W2027639996","https://openalex.org/W2053428424","https://openalex.org/W2054870222","https://openalex.org/W2072191579","https://openalex.org/W2072799435","https://openalex.org/W2083028719","https://openalex.org/W2095263945","https://openalex.org/W2113904485","https://openalex.org/W2120936914","https://openalex.org/W2122789628","https://openalex.org/W2140921033","https://openalex.org/W2153329411","https://openalex.org/W2168247528","https://openalex.org/W2489748212","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2065626942","https://openalex.org/W1505238579","https://openalex.org/W1585325021","https://openalex.org/W1561348834","https://openalex.org/W2157094140","https://openalex.org/W1563275127","https://openalex.org/W1541774359","https://openalex.org/W1604481126","https://openalex.org/W1491374186","https://openalex.org/W4256228983"],"abstract_inverted_index":{"Summary-Table-by-Example":[0],"(STBE)":[1],"is":[2,97,113,145],"a":[3,14,35,140,148],"graphical":[4],"language":[5],"suitable":[6],"for":[7],"statistical":[8,150],"database":[9,151],"applications.":[10],"STBE":[11,31,73,144],"queries":[12,32],"have":[13],"hierarchical":[15,28,89],"subquery":[16,37],"structure":[17],"and":[18,22],"manipulate":[19],"summary":[20],"tables":[21],"relations":[23],"with":[24],"set-valued":[25],"attributes.":[26],"The":[27],"arrangement":[29,90],"of":[30,91,105,120,136,139,159],"naturally":[33],"implies":[34],"tuple-by-tuple":[36],"evaluation":[38],"strategy":[39],"(similar":[40],"to":[41,86,124],"the":[42,52,62,88,101,117,121,134,156,160],"nested":[43],"loops":[44],"join":[45,110],"implementation":[46],"technique)":[47],"which":[48],"may":[49],"not":[50],"be":[51],"best":[53],"query":[54,63,74,95],"processing":[55,64],"strategy.":[56],"In":[57],"this":[58],"paper":[59],"we":[60,131],"discuss":[61,133,155],"techniques":[65],"used":[66],"in":[67,147],"STBE.":[68],"We":[69,115,154],"first":[70],"convert":[71],"an":[72,76,126],"into":[75],"\u201cextended\u201d":[77],"relational":[78],"algebra":[79],"(ERA)":[80],"expression.":[81,129,143],"Two":[82],"transformations":[83],"are":[84],"introduced":[85],"remove":[87],"subqueries":[92],"so":[93],"that":[94],"optimization":[96],"possible.":[98],"To":[99],"solve":[100],"\u201cempty":[102],"partition\u201d":[103],"problem":[104],"aggregate":[106],"function":[107],"evaluation,":[108],"directional":[109],"(one-sided":[111],"outer-join)":[112],"utilized.":[114],"give":[116],"algebraic":[118],"properties":[119],"ERA":[122,128,142],"operators":[123],"obtain":[125],"\u201cimproved\u201d":[127],"Finally":[130],"briefly":[132],"generation":[135],"alternative":[137],"implementations":[138],"given":[141],"implemented":[146,161],"prototype":[149],"management":[152],"system.":[153,162],"STBE-related":[157],"features":[158]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2002171029","counts_by_year":[{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
