{"id":"https://openalex.org/W2031427342","doi":"https://doi.org/10.1145/2063576.2064009","title":"Data-thirsty business analysts need SODA","display_name":"Data-thirsty business analysts need SODA","publication_year":2011,"publication_date":"2011-10-24","ids":{"openalex":"https://openalex.org/W2031427342","doi":"https://doi.org/10.1145/2063576.2064009","mag":"2031427342"},"language":"en","primary_location":{"id":"doi:10.1145/2063576.2064009","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2063576.2064009","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 20th ACM international conference on Information and knowledge management","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/A5033740271","display_name":"Lukas Blunschi","orcid":null},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Lukas Blunschi","raw_affiliation_strings":["ETH Zurich, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"ETH Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I35440088"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068395225","display_name":"Claudio Jossen","orcid":null},"institutions":[{"id":"https://openalex.org/I80201079","display_name":"Credit Suisse (Switzerland)","ror":"https://ror.org/05h634p83","country_code":"CH","type":"company","lineage":["https://openalex.org/I80201079"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Claudio Jossen","raw_affiliation_strings":["Credit Suisse AG, Zurich, Switzerland",", Credit Suisse AG, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"Credit Suisse AG, Zurich, Switzerland","institution_ids":["https://openalex.org/I80201079"]},{"raw_affiliation_string":", Credit Suisse AG, Zurich, Switzerland","institution_ids":["https://openalex.org/I80201079"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111504785","display_name":"Donald Kossmann","orcid":null},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Donald Kossmann","raw_affiliation_strings":["ETH Zurich, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"ETH Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I35440088"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024373044","display_name":"Magdalini Mori","orcid":null},"institutions":[{"id":"https://openalex.org/I80201079","display_name":"Credit Suisse (Switzerland)","ror":"https://ror.org/05h634p83","country_code":"CH","type":"company","lineage":["https://openalex.org/I80201079"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Magdalini Mori","raw_affiliation_strings":["Credit Suisse AG, Zurich, Switzerland",", Credit Suisse AG, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"Credit Suisse AG, Zurich, Switzerland","institution_ids":["https://openalex.org/I80201079"]},{"raw_affiliation_string":", Credit Suisse AG, Zurich, Switzerland","institution_ids":["https://openalex.org/I80201079"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074825049","display_name":"Kurt Stockinger","orcid":"https://orcid.org/0000-0003-4034-4812"},"institutions":[{"id":"https://openalex.org/I80201079","display_name":"Credit Suisse (Switzerland)","ror":"https://ror.org/05h634p83","country_code":"CH","type":"company","lineage":["https://openalex.org/I80201079"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Kurt Stockinger","raw_affiliation_strings":["Credit Suisse AG, Zurich, Switzerland",", Credit Suisse AG, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"Credit Suisse AG, Zurich, Switzerland","institution_ids":["https://openalex.org/I80201079"]},{"raw_affiliation_string":", Credit Suisse AG, Zurich, Switzerland","institution_ids":["https://openalex.org/I80201079"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5033740271"],"corresponding_institution_ids":["https://openalex.org/I35440088"],"apc_list":null,"apc_paid":null,"fwci":2.1005,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.87365712,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"2525","last_page":"2528"},"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.9997000098228455,"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.9997000098228455,"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.9984999895095825,"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/T11719","display_name":"Data Quality and Management","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8530768156051636},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6975129246711731},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6432507038116455},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5342836380004883},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.48572593927383423},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4732261896133423},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4488789737224579},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3030116856098175}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8530768156051636},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6975129246711731},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6432507038116455},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5342836380004883},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.48572593927383423},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4732261896133423},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4488789737224579},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3030116856098175}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2063576.2064009","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2063576.2064009","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 20th ACM international conference on Information and knowledge management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.46000000834465027,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W1981585544","https://openalex.org/W1998052044","https://openalex.org/W2098388305","https://openalex.org/W2117461391","https://openalex.org/W2121350579","https://openalex.org/W2149531250","https://openalex.org/W2156580346","https://openalex.org/W2169624745"],"related_works":["https://openalex.org/W2392768766","https://openalex.org/W2058118494","https://openalex.org/W2095118173","https://openalex.org/W2382021449","https://openalex.org/W2104269053","https://openalex.org/W2106424170","https://openalex.org/W2501188010","https://openalex.org/W4299935056","https://openalex.org/W2768810474","https://openalex.org/W2522980826"],"abstract_inverted_index":{"Querying":[0],"large":[1],"data":[2,75,87,127],"warehouses":[3],"is":[4,26,109],"very":[5],"hard":[6],"for":[7],"non-tech":[8],"savvy":[9],"business":[10,40,62],"users.":[11],"Deep":[12],"technical":[13],"knowledge":[14],"of":[15,23,95,100,128],"both":[16],"SQL":[17,90,107],"as":[18,20,83,85],"well":[19,84],"the":[21,24,58,61,65,96,113,119],"schema":[22],"database":[25],"required":[27],"in":[28,73],"order":[29],"to":[30,35,88,91,111],"build":[31],"correct":[32],"queries":[33],"and":[34,64,106],"come":[36],"up":[37],"with":[38,115,125],"new":[39],"insights.":[41],"In":[42],"this":[43],"paper":[44],"we":[45],"introduce":[46],"a":[47,74,129],"novel":[48],"system":[49],"called":[50],"SODA":[51,77],"(Search":[52],"Over":[53],"DAta":[54],"Warehouse)":[55],"that":[56],"bridges":[57],"gap":[59],"between":[60],"world":[63,67],"IT":[66],"by":[68],"enabling":[69],"extended":[70],"keyword":[71],"search":[72],"warehouse.":[76],"uses":[78],"metadata":[79],"information,":[80],"DBpedia":[81],"entries":[82],"base":[86],"generate":[89],"allow":[92],"intuitive":[93],"exploration":[94],"data.":[97],"The":[98],"process":[99],"query":[101,103,120],"classification,":[102],"graph":[104],"generation":[105,108],"visualized":[110],"provide":[112],"analysts":[114],"information":[116],"on":[117],"how":[118],"results":[121],"are":[122],"produced.":[123],"Experiments":[124],"real":[126],"global":[130],"financial":[131],"institution":[132],"comprising":[133],"around":[134],"300":[135],"tables":[136],"showed":[137],"promising":[138],"results.":[139]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}