{"id":"https://openalex.org/W2095026299","doi":"https://doi.org/10.1145/1951365.1951440","title":"QueryViz","display_name":"QueryViz","publication_year":2011,"publication_date":"2011-03-21","ids":{"openalex":"https://openalex.org/W2095026299","doi":"https://doi.org/10.1145/1951365.1951440","mag":"2095026299"},"language":"en","primary_location":{"id":"doi:10.1145/1951365.1951440","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1951365.1951440","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 14th International Conference on Extending Database Technology","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/A5017492487","display_name":"Jonathan Danaparamita","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]},{"id":"https://openalex.org/I58610484","display_name":"Seattle University","ror":"https://ror.org/02jqc0m91","country_code":"US","type":"education","lineage":["https://openalex.org/I58610484"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Jonathan Danaparamita","raw_affiliation_strings":["University of Washington, Seattle","University of Washington , Seattle"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle","institution_ids":["https://openalex.org/I58610484","https://openalex.org/I201448701"]},{"raw_affiliation_string":"University of Washington , Seattle","institution_ids":["https://openalex.org/I58610484","https://openalex.org/I201448701"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5086781628","display_name":"Wolfgang Gatterbauer","orcid":"https://orcid.org/0000-0002-9614-0504"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]},{"id":"https://openalex.org/I58610484","display_name":"Seattle University","ror":"https://ror.org/02jqc0m91","country_code":"US","type":"education","lineage":["https://openalex.org/I58610484"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wolfgang Gatterbauer","raw_affiliation_strings":["University of Washington, Seattle","University of Washington , Seattle"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle","institution_ids":["https://openalex.org/I58610484","https://openalex.org/I201448701"]},{"raw_affiliation_string":"University of Washington , Seattle","institution_ids":["https://openalex.org/I58610484","https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5017492487"],"corresponding_institution_ids":["https://openalex.org/I201448701","https://openalex.org/I58610484"],"apc_list":null,"apc_paid":null,"fwci":3.8508,"has_fulltext":false,"cited_by_count":51,"citation_normalized_percentile":{"value":0.93538725,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"558","last_page":"561"},"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.9991999864578247,"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.9991999864578247,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9980999827384949,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9958000183105469,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8868040442466736},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7731624841690063},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5429409146308899},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.49111291766166687},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.48217862844467163},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.47745779156684875},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.47359851002693176},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.43768689036369324},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4282242953777313},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.34613996744155884},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.22132110595703125},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.18836045265197754},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.12334486842155457},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.08451151847839355}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8868040442466736},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7731624841690063},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5429409146308899},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.49111291766166687},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.48217862844467163},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.47745779156684875},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.47359851002693176},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.43768689036369324},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4282242953777313},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.34613996744155884},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.22132110595703125},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.18836045265197754},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.12334486842155457},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08451151847839355}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1951365.1951440","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1951365.1951440","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 14th International Conference on Extending Database Technology","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.75,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[{"id":"https://openalex.org/G983287310","display_name":null,"funder_award_id":"IIS-0915054","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"}],"funders":[{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W54124430","https://openalex.org/W1543128418","https://openalex.org/W1602649058","https://openalex.org/W1733489975","https://openalex.org/W1967806879","https://openalex.org/W1985393821","https://openalex.org/W2003251288","https://openalex.org/W2032133388","https://openalex.org/W2037828101","https://openalex.org/W2047705935","https://openalex.org/W2089438716","https://openalex.org/W2090253867","https://openalex.org/W2103219113","https://openalex.org/W2106371135","https://openalex.org/W2107180790","https://openalex.org/W2127018826","https://openalex.org/W2131439452","https://openalex.org/W2136530502","https://openalex.org/W2165511849","https://openalex.org/W2171844899","https://openalex.org/W2200545814","https://openalex.org/W2338905098","https://openalex.org/W2963459319","https://openalex.org/W4250587856","https://openalex.org/W6631763575","https://openalex.org/W6660221118"],"related_works":["https://openalex.org/W1980548249","https://openalex.org/W2348171219","https://openalex.org/W2614112517","https://openalex.org/W650213220","https://openalex.org/W1984237344","https://openalex.org/W2042813897","https://openalex.org/W4366683866","https://openalex.org/W2038123353","https://openalex.org/W4318225407","https://openalex.org/W4293218583"],"abstract_inverted_index":{"We":[0],"present":[1],"QueryViz,":[2],"a":[3,43],"novel":[4],"visualization":[5],"tool":[6],"for":[7],"SQL":[8,63,77],"queries":[9,35],"that":[10,51],"reduces":[11],"the":[12,31,57,72,76],"time":[13],"needed":[14],"to":[15,39,53,86],"read":[16],"and":[17,36,48,75,90],"understand":[18],"existing":[19,46,87],"queries.":[20,64],"It":[21,79],"targets":[22],"two":[23,70],"principal":[24],"audiences:":[25],"(i)":[26],"users":[27],"who":[28,37],"often":[29],"issue":[30],"same":[32],"or":[33],"similar":[34],"need":[38],"quickly":[40],"browse":[41],"through":[42],"repository":[44],"of":[45,62],"queries;":[47],"(ii)":[49],"novices":[50],"try":[52],"familiarize":[54],"themselves":[55],"with":[56],"logic":[58],"behind":[59],"alternative":[60],"patterns":[61],"QueryViz":[65],"uses":[66],"as":[67,83],"input":[68],"only":[69],"strings:":[71],"database":[73,88],"schema":[74],"query.":[78],"can":[80],"thus":[81],"serve":[82],"light-weight":[84],"add-on":[85],"systems":[89],"is":[91],"also":[92],"available":[93],"via":[94],"an":[95],"online":[96],"interface":[97],"at":[98],"http://queryviz.com.":[99]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":7},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}