{"id":"https://openalex.org/W2071543761","doi":"https://doi.org/10.1145/1066677.1066708","title":"A complex biological database querying method","display_name":"A complex biological database querying method","publication_year":2005,"publication_date":"2005-03-13","ids":{"openalex":"https://openalex.org/W2071543761","doi":"https://doi.org/10.1145/1066677.1066708","mag":"2071543761"},"language":"en","primary_location":{"id":"doi:10.1145/1066677.1066708","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1066677.1066708","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2005 ACM symposium on Applied computing","raw_type":"proceedings-article"},"type":"conference-paper","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/A5058469124","display_name":"Jake Y. Chen","orcid":"https://orcid.org/0000-0001-8829-7504"},"institutions":[{"id":"https://openalex.org/I135191193","display_name":"University of Indianapolis","ror":"https://ror.org/052133d12","country_code":"US","type":"education","lineage":["https://openalex.org/I135191193"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jake Yue Chen","raw_affiliation_strings":["University Indianapolis, Indianapolis, IN"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University Indianapolis, Indianapolis, IN","institution_ids":["https://openalex.org/I135191193"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017357094","display_name":"John V. Carlis","orcid":null},"institutions":[{"id":"https://openalex.org/I130238516","display_name":"University of Minnesota","ror":"https://ror.org/017zqws13","country_code":"US","type":"education","lineage":["https://openalex.org/I130238516"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"John V. Carlis","raw_affiliation_strings":["University of Minnesota, Minneapolis, MN","University of Minnesota , Minneapolis, Mn"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minnesota, Minneapolis, MN","institution_ids":["https://openalex.org/I130238516"]},{"raw_affiliation_string":"University of Minnesota , Minneapolis, Mn","institution_ids":["https://openalex.org/I130238516"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063465350","display_name":"Ning Gao","orcid":null},"institutions":[{"id":"https://openalex.org/I135191193","display_name":"University of Indianapolis","ror":"https://ror.org/052133d12","country_code":"US","type":"education","lineage":["https://openalex.org/I135191193"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ning Gao","raw_affiliation_strings":["University Indianapolis, Indianapolis, IN"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University Indianapolis, Indianapolis, IN","institution_ids":["https://openalex.org/I135191193"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"110","last_page":"114"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10015","display_name":"Genomics and Phylogenetic Studies","score":0.993399977684021,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T10015","display_name":"Genomics and Phylogenetic Studies","score":0.993399977684021,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10885","display_name":"Gene expression and cancer classification","score":0.991100013256073,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9878000020980835,"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/computer-science","display_name":"Computer science","score":0.8699870109558105},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.648551344871521},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.644968569278717},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6207154989242554},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.6149566769599915},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5296962857246399},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5226594805717468},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5202059149742126},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.511314868927002},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48462972044944763},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4839920997619629},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.4588736593723297},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.4365340769290924},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.37876492738723755},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3263043761253357},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.13929983973503113},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.13536536693572998}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8699870109558105},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.648551344871521},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.644968569278717},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6207154989242554},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6149566769599915},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5296962857246399},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5226594805717468},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5202059149742126},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.511314868927002},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48462972044944763},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4839920997619629},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.4588736593723297},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4365340769290924},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.37876492738723755},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3263043761253357},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.13929983973503113},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.13536536693572998}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1066677.1066708","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1066677.1066708","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2005 ACM symposium on Applied computing","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5400000214576721,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W65208115","https://openalex.org/W72158422","https://openalex.org/W1730348256","https://openalex.org/W1970156673","https://openalex.org/W1997533292","https://openalex.org/W2013623410","https://openalex.org/W2125014646","https://openalex.org/W2135952507","https://openalex.org/W2160948978","https://openalex.org/W2161109697"],"related_works":["https://openalex.org/W2955368753","https://openalex.org/W2374912898","https://openalex.org/W2978539281","https://openalex.org/W2554271401","https://openalex.org/W2375340541","https://openalex.org/W2406556739","https://openalex.org/W2150741898","https://openalex.org/W2889903446","https://openalex.org/W2385089576","https://openalex.org/W2588167896"],"abstract_inverted_index":{"Many":[0],"biological":[1,14,77],"information":[2],"systems":[3,9],"rely":[4],"on":[5],"relational":[6],"database":[7,102,162,193],"management":[8],"(RDBMS)":[10],"to":[11,69,144,157,185],"manage":[12],"high-throughput":[13],"data.":[15],"While":[16],"keeping":[17],"these":[18],"data":[19,165],"well":[20],"archived,":[21],"organized,":[22],"and":[23,39,105,120,148,170],"integrated":[24],"in":[25,45,76,166],"a":[26,31,64,129],"common":[27],"repository":[28],"is":[29,47,183],"still":[30],"challenging":[32],"task,":[33],"performing":[34],"complex":[35,74,192],"queries,":[36],"i.e.,":[37],"explorative":[38],"abstract":[40,147],"ad":[41],"hoc":[42],"user":[43,150],"questions":[44],"biology,":[46],"an":[48,145],"even":[49],"formidable":[50],"task":[51],"often":[52],"substituted":[53],"by":[54],"writing":[55],"complicated":[56],"software":[57],"programs.":[58],"In":[59],"this":[60],"work,":[61],"we":[62,116,132],"propose":[63],"\"complex":[65,179],"query":[66,99,103,107,121,135,151,180],"modeling\"":[67,181],"method":[68,182],"address":[70],"the":[71],"challenge":[72],"of":[73,82,88,91,95,140,161,168,173],"querying":[75],"domains.":[78],"Query":[79],"modeling":[80,122,136],"consists":[81],"four":[83],"distinct":[84],"but":[85],"interdependent":[86],"phases":[87],"activities:":[89],"representation":[90],"high-level":[92],"problems,":[93],"transformation":[94],"problems":[96],"into":[97,109],"connected":[98],"interfaces,":[100],"designing":[101],"structures,":[104],"translating":[106],"plans":[108],"high-performing":[110],"SQL":[111,142],"statements.":[112],"At":[113],"each":[114],"stage,":[115],"use":[117],"different":[118],"notations":[119],"practices.":[123],"Using":[124],"gene":[125],"indexing":[126],"project":[127],"as":[128],"case":[130],"study,":[131],"show":[133],"that":[134],"enables":[137],"prototypical":[138],"development":[139],"high-quality":[141],"solutions":[143],"inherently":[146],"vague":[149],"question,":[152],"which":[153],"requires":[154],"GeneChip":[155],"designers":[156],"sift":[158],"through":[159],"millions":[160],"records,":[163],"process":[164],"dozens":[167],"steps,":[169],"make":[171],"myriads":[172],"intermediate":[174],"decisions.":[175],"We":[176],"believe":[177],"our":[178],"applicable":[184],"other":[186],"bioinformatics":[187],"domains":[188],"with":[189],"needs":[190],"for":[191],"queries.":[194]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}