{"id":"https://openalex.org/W2036385401","doi":"https://doi.org/10.1145/1247480.1247549","title":"Towards keyword-driven analytical processing","display_name":"Towards keyword-driven analytical processing","publication_year":2007,"publication_date":"2007-06-11","ids":{"openalex":"https://openalex.org/W2036385401","doi":"https://doi.org/10.1145/1247480.1247549","mag":"2036385401"},"language":"en","primary_location":{"id":"doi:10.1145/1247480.1247549","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247549","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 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/A5109264385","display_name":"Ping Wu","orcid":"https://orcid.org/0009-0007-4622-1449"},"institutions":[{"id":"https://openalex.org/I154570441","display_name":"University of California, Santa Barbara","ror":"https://ror.org/02t274463","country_code":"US","type":"education","lineage":["https://openalex.org/I154570441"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ping Wu","raw_affiliation_strings":["University of California, Santa Barbara, CA","University of California, Santa Barbara, Ca#TAB#"],"affiliations":[{"raw_affiliation_string":"University of California, Santa Barbara, CA","institution_ids":["https://openalex.org/I154570441"]},{"raw_affiliation_string":"University of California, Santa Barbara, Ca#TAB#","institution_ids":["https://openalex.org/I154570441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048704801","display_name":"Yannis Sismanis","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yannis Sismanis","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA","IBM Almaden Research Center San Jose , CA"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center San Jose , CA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036119025","display_name":"Berthold Reinwald","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Berthold Reinwald","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA","IBM Almaden Research Center San Jose , CA"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center San Jose , CA","institution_ids":["https://openalex.org/I4210085935"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5109264385"],"corresponding_institution_ids":["https://openalex.org/I154570441"],"apc_list":null,"apc_paid":null,"fwci":11.5514,"has_fulltext":false,"cited_by_count":78,"citation_normalized_percentile":{"value":0.98637059,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"617","last_page":"628"},"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.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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","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"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.9976999759674072,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.8776727914810181},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.861119270324707},{"id":"https://openalex.org/keywords/generality","display_name":"Generality","score":0.7101167440414429},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6563997268676758},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.584485650062561},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.5382840633392334},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.5243732929229736},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.5042606592178345},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.49279406666755676},{"id":"https://openalex.org/keywords/categorical-variable","display_name":"Categorical variable","score":0.4898917078971863},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.48147597908973694},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.39998695254325867},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3954417109489441},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35798147320747375},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.29574352502822876}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8776727914810181},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.861119270324707},{"id":"https://openalex.org/C2780767217","wikidata":"https://www.wikidata.org/wiki/Q5532421","display_name":"Generality","level":2,"score":0.7101167440414429},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6563997268676758},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.584485650062561},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5382840633392334},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.5243732929229736},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.5042606592178345},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.49279406666755676},{"id":"https://openalex.org/C5274069","wikidata":"https://www.wikidata.org/wiki/Q2285707","display_name":"Categorical variable","level":2,"score":0.4898917078971863},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.48147597908973694},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.39998695254325867},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3954417109489441},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35798147320747375},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.29574352502822876},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"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/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C542102704","wikidata":"https://www.wikidata.org/wiki/Q183257","display_name":"Psychotherapist","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},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1247480.1247549","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247549","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.550000011920929}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W159817958","https://openalex.org/W346507350","https://openalex.org/W1565838812","https://openalex.org/W1973828215","https://openalex.org/W1989944922","https://openalex.org/W2053606794","https://openalex.org/W2072764742","https://openalex.org/W2074863013","https://openalex.org/W2096898303","https://openalex.org/W2098388305","https://openalex.org/W2105819430","https://openalex.org/W2112431793","https://openalex.org/W2118322263","https://openalex.org/W2121350579","https://openalex.org/W2124278683","https://openalex.org/W2148792468","https://openalex.org/W2148942721","https://openalex.org/W2151406030","https://openalex.org/W2169624745","https://openalex.org/W4285719527","https://openalex.org/W6682452324"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W2363019959","https://openalex.org/W6138692","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"Gaining":[0],"business":[1,74,117],"insights":[2],"from":[3,159],"data":[4,31,50,58,68,112,212,238],"has":[5],"recently":[6],"been":[7],"the":[8,42,45,53,67,80,97,111,116,161,168,175,180,219,237],"focus":[9],"of":[10,48,99,223,229],"research":[11],"and":[12,29,35,39,166,193,195,199,210,221,239],"product":[13],"development.":[14],"On":[15],"Line-Analytical":[16],"Processing":[17],"(OLAP)":[18],"tools":[19],"provide":[20,197],"elaborate":[21],"query":[22],"languages":[23],"that":[24,72,115,128,173,187],"allow":[25,174],"users":[26],"to":[27,65,105,136,164,177,225],"group":[28],"aggregate":[30],"in":[32,41,69,101,109,113,170,236],"various":[33,157,253],"ways,":[34],"explore":[36,178],"interesting":[37],"trends":[38],"patterns":[40],"data.":[43,81,257],"However,":[44],"dynamic":[46,171],"nature":[47],"today's":[49],"along":[51],"with":[52,96,249],"overwhelming":[54],"detail":[55],"at":[56],"which":[57,91,155],"is":[59,123],"provided,":[60],"make":[61],"it":[62,144],"nearly":[63],"impossible":[64],"organize":[66],"a":[70,73,125],"way":[71],"analyst":[75,118],"needs":[76],"for":[77],"thinking":[78],"about":[79],"In":[82],"this":[83],"paper,":[84],"we":[85,129,196,217],"introduce":[86],"\"Keyword-Driven":[87],"Analytical":[88],"Processing\"":[89],"(KDAP),":[90],"combines":[92],"intuitive":[93],"keyword-based":[94],"search":[95],"power":[98],"aggregation":[100,181],"OLAP":[102],"without":[103],"having":[104],"spend":[106],"considerable":[107],"effort":[108],"organizing":[110,165],"terms":[114,163],"understands.":[119],"Our":[120],"design":[121],"point":[122],"around":[124],"user":[126,176],"mentality":[127],"frequently":[130],"encounter:":[131],"\"users":[132],"don't":[133],"know":[134,143],"how":[135,204],"specify":[137],"what":[138],"they":[139,142,146],"want,":[140],"but":[141],"when":[145],"see":[147],"it\".":[148],"We":[149,183,202],"present":[150],"our":[151],"complete":[152],"solution":[153],"framework,":[154],"implements":[156],"phases":[158],"disambiguating":[160],"keyword":[162],"ranking":[167],"results":[169],"facets,":[172],"efficiently":[179],"space.":[182],"address":[184],"specific":[185],"issues":[186],"analysts":[188],"encounter,":[189],"like":[190],"joins,":[191],"groupings":[192],"aggregations,":[194],"efficient":[198],"scalable":[200],"solutions.":[201],"show,":[203],"KDAP":[205,224],"can":[206],"handle":[207],"both":[208],"categorical":[209],"numerical":[211],"equally":[213],"well":[214],"and,":[215],"finally,":[216],"demonstrate":[218],"generality":[220],"applicability":[222],"two":[226],"different":[227],"aspects":[228],"OLAP,":[230],"namely,":[231],"finding":[232,240],"exceptions":[233],"or":[234],"surprises":[235],"bellwether":[241],"regions":[242],"where":[243],"local":[244],"aggregates":[245],"are":[246],"highly":[247],"correlated":[248],"global":[250],"aggregates,":[251],"using":[252],"experiments":[254],"on":[255],"real":[256]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":6}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}