{"id":"https://openalex.org/W1972770757","doi":"https://doi.org/10.1021/ci050062e","title":"A Searching and Reporting System for Relational Databases Using a Graph-Based Metadata Representation","display_name":"A Searching and Reporting System for Relational Databases Using a Graph-Based Metadata Representation","publication_year":2005,"publication_date":"2005-05-19","ids":{"openalex":"https://openalex.org/W1972770757","doi":"https://doi.org/10.1021/ci050062e","mag":"1972770757","pmid":"https://pubmed.ncbi.nlm.nih.gov/16045279"},"language":"en","primary_location":{"id":"doi:10.1021/ci050062e","is_oa":false,"landing_page_url":"https://doi.org/10.1021/ci050062e","pdf_url":null,"source":{"id":"https://openalex.org/S167262187","display_name":"Journal of Chemical Information and Modeling","issn_l":"1549-9596","issn":["1549-9596","1549-960X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320006","host_organization_name":"American Chemical Society","host_organization_lineage":["https://openalex.org/P4310320006"],"host_organization_lineage_names":["American Chemical Society"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Chemical Information and Modeling","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","pubmed"],"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/A5069546751","display_name":"Robin Hewitt","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Robin Hewitt","raw_affiliation_strings":["Hewitt Consulting, San Diego, California 92103","Hewitt Consulting, San Diego, California 92103, USA. rhewitt@acm.org"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hewitt Consulting, San Diego, California 92103","institution_ids":[]},{"raw_affiliation_string":"Hewitt Consulting, San Diego, California 92103, USA. rhewitt@acm.org","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022225535","display_name":"Alberto Gobbi","orcid":"https://orcid.org/0000-0003-0434-9237"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Alberto Gobbi","raw_affiliation_strings":["Anadys Pharmaceuticals, Inc., 9050 Camino Santa Fe, San Diego, California 92121"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Anadys Pharmaceuticals, Inc., 9050 Camino Santa Fe, San Diego, California 92121","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5044000859","display_name":"Man\u2010Ling Lee","orcid":"https://orcid.org/0000-0002-1107-7818"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Man-Ling Lee","raw_affiliation_strings":["Anadys Pharmaceuticals, Inc., 9050 Camino Santa Fe, San Diego, California 92121"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Anadys Pharmaceuticals, Inc., 9050 Camino Santa Fe, San Diego, California 92121","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5069546751"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7585,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.68048208,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"45","issue":"4","first_page":"863","last_page":"869"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10887","display_name":"Bioinformatics and Genomic Networks","score":0.9871000051498413,"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/T10887","display_name":"Bioinformatics and Genomic Networks","score":0.9871000051498413,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9800999760627747,"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/T10932","display_name":"Microbial Metabolic Engineering and Bioproduction","score":0.9793999791145325,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8275279998779297},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.692625105381012},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.6831255555152893},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.6558351516723633},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6490079164505005},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5482436418533325},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5275102257728577},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5229400396347046},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5122138857841492},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5016756057739258},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.48680350184440613},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.4794017970561981},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4734075963497162},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.42930108308792114},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.42725202441215515},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.42110493779182434},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4187667965888977},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.413673996925354},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.23190730810165405},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.20590367913246155},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.1853298544883728},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.11147892475128174}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8275279998779297},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.692625105381012},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.6831255555152893},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.6558351516723633},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6490079164505005},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5482436418533325},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5275102257728577},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5229400396347046},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5122138857841492},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5016756057739258},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.48680350184440613},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.4794017970561981},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4734075963497162},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.42930108308792114},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.42725202441215515},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.42110493779182434},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4187667965888977},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.413673996925354},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.23190730810165405},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.20590367913246155},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.1853298544883728},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11147892475128174}],"mesh":[{"descriptor_ui":"D003198","descriptor_name":"Computer Simulation","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003198","descriptor_name":"Computer Simulation","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003198","descriptor_name":"Computer Simulation","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012107","descriptor_name":"Research Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012107","descriptor_name":"Research Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012107","descriptor_name":"Research Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012985","descriptor_name":"Software Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012985","descriptor_name":"Software Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012985","descriptor_name":"Software Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D015195","descriptor_name":"Drug Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D015195","descriptor_name":"Drug Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D015195","descriptor_name":"Drug Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.1021/ci050062e","is_oa":false,"landing_page_url":"https://doi.org/10.1021/ci050062e","pdf_url":null,"source":{"id":"https://openalex.org/S167262187","display_name":"Journal of Chemical Information and Modeling","issn_l":"1549-9596","issn":["1549-9596","1549-960X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320006","host_organization_name":"American Chemical Society","host_organization_lineage":["https://openalex.org/P4310320006"],"host_organization_lineage_names":["American Chemical Society"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Chemical Information and Modeling","raw_type":"journal-article"},{"id":"pmid:16045279","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/16045279","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of chemical information and modeling","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1501231951","https://openalex.org/W1540445047","https://openalex.org/W1574047582","https://openalex.org/W2062288740","https://openalex.org/W2088723818","https://openalex.org/W2146453000","https://openalex.org/W2209977941","https://openalex.org/W4236940322","https://openalex.org/W4248934611"],"related_works":["https://openalex.org/W279222092","https://openalex.org/W1502610062","https://openalex.org/W3015670717","https://openalex.org/W1977805686","https://openalex.org/W561919812","https://openalex.org/W1569405483","https://openalex.org/W1678936339","https://openalex.org/W1543230276","https://openalex.org/W1604501984","https://openalex.org/W2506898509"],"abstract_inverted_index":{"Relational":[0],"databases":[1],"are":[2,93],"the":[3,12,28,33,83,94],"current":[4],"standard":[5],"for":[6,45],"storing":[7],"and":[8,14,31,47,65,67,88],"retrieving":[9,18],"data":[10,19,49,73],"in":[11,50],"pharmaceutical":[13],"biotech":[15],"industries.":[16],"However,":[17],"from":[20],"a":[21,51],"relational":[22,52],"database":[23,29,53],"requires":[24],"specialized":[25],"knowledge":[26],"of":[27,32,96],"schema":[30],"SQL":[34,78],"query":[35],"language.":[36],"At":[37],"Anadys,":[38],"we":[39],"have":[40],"developed":[41],"an":[42],"easy-to-use":[43],"system":[44,62],"searching":[46],"reporting":[48],"to":[54,70,76],"support":[55],"our":[56],"drug":[57],"discovery":[58],"project":[59],"teams.":[60],"This":[61,80],"is":[63],"fast":[64],"flexible":[66],"allows":[68],"users":[69],"access":[71],"all":[72],"without":[74],"having":[75],"write":[77],"queries.":[79],"paper":[81],"presents":[82],"hierarchical,":[84],"graph-based":[85],"metadata":[86],"representation":[87],"SQL-construction":[89],"methods":[90],"that,":[91],"together,":[92],"basis":[95],"this":[97],"system's":[98],"capabilities.":[99]},"counts_by_year":[],"updated_date":"2026-06-16T07:32:37.131356","created_date":"2025-10-10T00:00:00"}