{"id":"https://openalex.org/W2027162181","doi":"https://doi.org/10.1021/ci8003013","title":"Chemical Substructure Search in SQL","display_name":"Chemical Substructure Search in SQL","publication_year":2008,"publication_date":"2008-12-15","ids":{"openalex":"https://openalex.org/W2027162181","doi":"https://doi.org/10.1021/ci8003013","mag":"2027162181","pmid":"https://pubmed.ncbi.nlm.nih.gov/19072559"},"language":"en","primary_location":{"id":"doi:10.1021/ci8003013","is_oa":false,"landing_page_url":"https://doi.org/10.1021/ci8003013","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/A5051143114","display_name":"Adel Golovin","orcid":null},"institutions":[{"id":"https://openalex.org/I1303153112","display_name":"European Bioinformatics Institute","ror":"https://ror.org/02catss52","country_code":"GB","type":"facility","lineage":["https://openalex.org/I1303153112","https://openalex.org/I4210138560"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Adel Golovin","raw_affiliation_strings":["EMBL-EBI Hinston Hall Genome Campus, Cambridge, U.K"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"EMBL-EBI Hinston Hall Genome Campus, Cambridge, U.K","institution_ids":["https://openalex.org/I1303153112"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5108447954","display_name":"Kim Henrick","orcid":null},"institutions":[{"id":"https://openalex.org/I1303153112","display_name":"European Bioinformatics Institute","ror":"https://ror.org/02catss52","country_code":"GB","type":"facility","lineage":["https://openalex.org/I1303153112","https://openalex.org/I4210138560"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Kim Henrick","raw_affiliation_strings":["EMBL-EBI Hinston Hall Genome Campus, Cambridge, U.K"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"EMBL-EBI Hinston Hall Genome Campus, Cambridge, U.K","institution_ids":["https://openalex.org/I1303153112"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5108447954"],"corresponding_institution_ids":["https://openalex.org/I1303153112"],"apc_list":null,"apc_paid":null,"fwci":4.9654,"has_fulltext":false,"cited_by_count":36,"citation_normalized_percentile":{"value":0.94979277,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"49","issue":"1","first_page":"22","last_page":"27"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10211","display_name":"Computational Drug Discovery Methods","score":0.9951000213623047,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T10211","display_name":"Computational Drug Discovery Methods","score":0.9951000213623047,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T10908","display_name":"Analytical Chemistry and Chromatography","score":0.9945999979972839,"subfield":{"id":"https://openalex.org/subfields/1607","display_name":"Spectroscopy"},"field":{"id":"https://openalex.org/fields/16","display_name":"Chemistry"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9717000126838684,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/subgraph-isomorphism-problem","display_name":"Subgraph isomorphism problem","score":0.798549234867096},{"id":"https://openalex.org/keywords/substructure","display_name":"Substructure","score":0.7529149055480957},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6579970121383667},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5963647365570068},{"id":"https://openalex.org/keywords/induced-subgraph-isomorphism-problem","display_name":"Induced subgraph isomorphism problem","score":0.567107081413269},{"id":"https://openalex.org/keywords/time-complexity","display_name":"Time complexity","score":0.49505749344825745},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.486331045627594},{"id":"https://openalex.org/keywords/isomorphism","display_name":"Isomorphism (crystallography)","score":0.4595223367214203},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.43666592240333557},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4147277772426605},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4041929841041565},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2924863398075104},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2842245101928711},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2404821813106537},{"id":"https://openalex.org/keywords/chemistry","display_name":"Chemistry","score":0.19605064392089844},{"id":"https://openalex.org/keywords/line-graph","display_name":"Line graph","score":0.07475748658180237}],"concepts":[{"id":"https://openalex.org/C131992880","wikidata":"https://www.wikidata.org/wiki/Q2528185","display_name":"Subgraph isomorphism problem","level":3,"score":0.798549234867096},{"id":"https://openalex.org/C99679407","wikidata":"https://www.wikidata.org/wiki/Q56761637","display_name":"Substructure","level":2,"score":0.7529149055480957},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6579970121383667},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5963647365570068},{"id":"https://openalex.org/C191241153","wikidata":"https://www.wikidata.org/wiki/Q6027240","display_name":"Induced subgraph isomorphism problem","level":5,"score":0.567107081413269},{"id":"https://openalex.org/C311688","wikidata":"https://www.wikidata.org/wiki/Q2393193","display_name":"Time complexity","level":2,"score":0.49505749344825745},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.486331045627594},{"id":"https://openalex.org/C203436722","wikidata":"https://www.wikidata.org/wiki/Q902950","display_name":"Isomorphism (crystallography)","level":3,"score":0.4595223367214203},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.43666592240333557},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4147277772426605},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4041929841041565},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2924863398075104},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2842245101928711},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2404821813106537},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.19605064392089844},{"id":"https://openalex.org/C203776342","wikidata":"https://www.wikidata.org/wiki/Q1378376","display_name":"Line graph","level":3,"score":0.07475748658180237},{"id":"https://openalex.org/C8010536","wikidata":"https://www.wikidata.org/wiki/Q160398","display_name":"Crystallography","level":1,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0},{"id":"https://openalex.org/C22149727","wikidata":"https://www.wikidata.org/wiki/Q7940747","display_name":"Voltage graph","level":4,"score":0.0},{"id":"https://openalex.org/C115624301","wikidata":"https://www.wikidata.org/wiki/Q895901","display_name":"Crystal structure","level":2,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[{"descriptor_ui":"D000465","descriptor_name":"Algorithms","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000465","descriptor_name":"Algorithms","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000465","descriptor_name":"Algorithms","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":false},{"descriptor_ui":"D003198","descriptor_name":"Computer Simulation","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003198","descriptor_name":"Computer Simulation","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008958","descriptor_name":"Models, Molecular","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008958","descriptor_name":"Models, Molecular","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008958","descriptor_name":"Models, Molecular","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D011506","descriptor_name":"Proteins","qualifier_ui":"Q000737","qualifier_name":"chemistry","is_major_topic":false},{"descriptor_ui":"D011506","descriptor_name":"Proteins","qualifier_ui":"Q000737","qualifier_name":"chemistry","is_major_topic":false},{"descriptor_ui":"D011506","descriptor_name":"Proteins","qualifier_ui":"Q000737","qualifier_name":"chemistry","is_major_topic":false},{"descriptor_ui":"D015394","descriptor_name":"Molecular Structure","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D015394","descriptor_name":"Molecular Structure","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D015394","descriptor_name":"Molecular Structure","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D030562","descriptor_name":"Databases, Protein","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D030562","descriptor_name":"Databases, Protein","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D030562","descriptor_name":"Databases, Protein","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D048088","descriptor_name":"Informatics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D048088","descriptor_name":"Informatics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D048088","descriptor_name":"Informatics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D055808","descriptor_name":"Drug Discovery","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D055808","descriptor_name":"Drug Discovery","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D055808","descriptor_name":"Drug Discovery","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true}],"locations_count":2,"locations":[{"id":"doi:10.1021/ci8003013","is_oa":false,"landing_page_url":"https://doi.org/10.1021/ci8003013","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:19072559","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/19072559","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":[{"id":"https://openalex.org/G5577438759","display_name":"European Macromolecular Structure Database.","funder_award_id":"075968","funder_id":"https://openalex.org/F4320311904","funder_display_name":"Wellcome Trust"}],"funders":[{"id":"https://openalex.org/F4320311904","display_name":"Wellcome Trust","ror":"https://ror.org/029chgv08"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W1504988257","https://openalex.org/W1567586152","https://openalex.org/W1976983561","https://openalex.org/W1977845138","https://openalex.org/W1978282744","https://openalex.org/W2000480344","https://openalex.org/W2003932708","https://openalex.org/W2008734993","https://openalex.org/W2025178182","https://openalex.org/W2046021036","https://openalex.org/W2070459622","https://openalex.org/W2072287929","https://openalex.org/W2080283791","https://openalex.org/W2098863153","https://openalex.org/W2106861048","https://openalex.org/W2120138074","https://openalex.org/W2129748900","https://openalex.org/W2130479394","https://openalex.org/W2141773967","https://openalex.org/W4240320014"],"related_works":["https://openalex.org/W2532922352","https://openalex.org/W231720905","https://openalex.org/W2604893261","https://openalex.org/W2915540008","https://openalex.org/W2361654510","https://openalex.org/W2128390795","https://openalex.org/W1482551403","https://openalex.org/W2604114816","https://openalex.org/W2954463587","https://openalex.org/W2393701947"],"abstract_inverted_index":{"We":[0],"present":[1],"a":[2,6,12,18,25,102],"novel":[3],"technique":[4,59],"for":[5],"fast":[7],"chemical":[8,54,119],"substructure":[9],"search":[10,40,55,120],"on":[11,38,82],"relational":[13],"database":[14],"by":[15],"use":[16],"of":[17,24,63,133],"standard":[19],"SQL":[20],"query.":[21],"The":[22,113,128],"symmetry":[23],"query":[26],"graph":[27],"is":[28,36,101,121,136],"analyzed":[29],"to":[30,52,60,73,84,115,130],"give":[31],"additional":[32],"constraints.":[33],"Our":[34],"method":[35],"based":[37],"breadth-first":[39],"(BFS)":[41],"algorithms":[42,92],"implementation":[43],"using":[44],"Relational":[45],"Database":[46],"Management":[47],"Systems":[48],"(RDBMS).":[49],"In":[50],"addition":[51],"the":[53,61,80,87,91,110,131],"we":[56],"apply":[57],"our":[58],"field":[62],"intermolecular":[64],"interactions":[65,135],"which":[66],"involves":[67],"nonplanar":[68],"graphs":[69],"and":[70,125],"describe":[71],"how":[72,83],"achieve":[74],"linear":[75,88],"time":[76,104],"performance":[77],"along":[78],"with":[79],"suggestion":[81],"sufficiently":[85],"reduce":[86],"coefficient.":[89],"From":[90],"theory":[93],"perspective":[94],"these":[95],"results":[96],"mean":[97],"that":[98],"subgraph":[99,116],"isomorphism":[100,117],"polynomial":[103],"problem,":[105],"hence":[106],"equal":[107],"problems":[108],"have":[109],"same":[111],"complexity.":[112],"application":[114,129],"in":[118],"available":[122,137],"at":[123,138],"http://www.ebi.ac.uk/msd-srv/chemsearch":[124],"http://www.ebi.ac.uk/msd-srv/msdmotif/chem":[126],".":[127,140],"network":[132],"molecule":[134],"http://www.ebi.ac.uk/msd-srv/msdmotif":[139]},"counts_by_year":[{"year":2021,"cited_by_count":3},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":4}],"updated_date":"2026-06-24T13:16:06.693445","created_date":"2025-10-10T00:00:00"}