{"id":"https://openalex.org/W2111591568","doi":"https://doi.org/10.1093/bioinformatics/bth243","title":"YAdumper: extracting and translating large information volumes from relational databases to structured flat files","display_name":"YAdumper: extracting and translating large information volumes from relational databases to structured flat files","publication_year":2004,"publication_date":"2004-04-29","ids":{"openalex":"https://openalex.org/W2111591568","doi":"https://doi.org/10.1093/bioinformatics/bth243","mag":"2111591568","pmid":"https://pubmed.ncbi.nlm.nih.gov/15117748"},"language":"en","primary_location":{"id":"doi:10.1093/bioinformatics/bth243","is_oa":true,"landing_page_url":"https://doi.org/10.1093/bioinformatics/bth243","pdf_url":"https://academic.oup.com/bioinformatics/article-pdf/20/15/2455/48905992/bioinformatics_20_15_2455.pdf","source":{"id":"https://openalex.org/S52395412","display_name":"Bioinformatics","issn_l":"1367-4803","issn":["1367-4803","1367-4811"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Bioinformatics","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj","pubmed"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://academic.oup.com/bioinformatics/article-pdf/20/15/2455/48905992/bioinformatics_20_15_2455.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5078455671","display_name":"Jos\u00e9 M. Fern\u00e1ndez","orcid":"https://orcid.org/0000-0002-4806-5140"},"institutions":[{"id":"https://openalex.org/I4210104776","display_name":"Centro Nacional de Biotecnolog\u00eda","ror":"https://ror.org/015w4v032","country_code":"ES","type":"facility","lineage":["https://openalex.org/I134820265","https://openalex.org/I4210104776"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Jos\u00e9 M. Fern\u00e1ndez","raw_affiliation_strings":["Protein Design Group, National Center for Biotechnology, CNB-CSIC Cantoblanco, Madrid 28049, Spain"],"affiliations":[{"raw_affiliation_string":"Protein Design Group, National Center for Biotechnology, CNB-CSIC Cantoblanco, Madrid 28049, Spain","institution_ids":["https://openalex.org/I4210104776"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5015217651","display_name":"Alfonso Valencia","orcid":"https://orcid.org/0000-0002-8937-6789"},"institutions":[{"id":"https://openalex.org/I4210104776","display_name":"Centro Nacional de Biotecnolog\u00eda","ror":"https://ror.org/015w4v032","country_code":"ES","type":"facility","lineage":["https://openalex.org/I134820265","https://openalex.org/I4210104776"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Alfonso Valencia","raw_affiliation_strings":["Protein Design Group, National Center for Biotechnology, CNB-CSIC Cantoblanco, Madrid 28049, Spain"],"affiliations":[{"raw_affiliation_string":"Protein Design Group, National Center for Biotechnology, CNB-CSIC Cantoblanco, Madrid 28049, Spain","institution_ids":["https://openalex.org/I4210104776"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5078455671"],"corresponding_institution_ids":["https://openalex.org/I4210104776"],"apc_list":{"value":3618,"currency":"USD","value_usd":3618},"apc_paid":null,"fwci":0.2318,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.63999529,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"20","issue":"15","first_page":"2455","last_page":"2457"},"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.5630999803543091,"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.5630999803543091,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.5177000164985657,"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.6786529421806335},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6713308691978455},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6505092978477478},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5094133019447327},{"id":"https://openalex.org/keywords/semi-structured-data","display_name":"Semi-structured data","score":0.4436446726322174},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.34967392683029175}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6786529421806335},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6713308691978455},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6505092978477478},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5094133019447327},{"id":"https://openalex.org/C40077939","wikidata":"https://www.wikidata.org/wiki/Q2336004","display_name":"Semi-structured data","level":3,"score":0.4436446726322174},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34967392683029175}],"mesh":[{"descriptor_ui":"D000465","descriptor_name":"Algorithms","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000465","descriptor_name":"Algorithms","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000465","descriptor_name":"Algorithms","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D001330","descriptor_name":"Electronic Data Processing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D001330","descriptor_name":"Electronic Data Processing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D001330","descriptor_name":"Electronic Data Processing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D014584","descriptor_name":"User-Computer Interface","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D014584","descriptor_name":"User-Computer Interface","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D014584","descriptor_name":"User-Computer Interface","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D019295","descriptor_name":"Computational Biology","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D019295","descriptor_name":"Computational Biology","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D019295","descriptor_name":"Computational Biology","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D033181","descriptor_name":"Information Dissemination","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D033181","descriptor_name":"Information Dissemination","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D033181","descriptor_name":"Information Dissemination","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.1093/bioinformatics/bth243","is_oa":true,"landing_page_url":"https://doi.org/10.1093/bioinformatics/bth243","pdf_url":"https://academic.oup.com/bioinformatics/article-pdf/20/15/2455/48905992/bioinformatics_20_15_2455.pdf","source":{"id":"https://openalex.org/S52395412","display_name":"Bioinformatics","issn_l":"1367-4803","issn":["1367-4803","1367-4811"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Bioinformatics","raw_type":"journal-article"},{"id":"pmid:15117748","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/15117748","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":"Bioinformatics (Oxford, England)","raw_type":null}],"best_oa_location":{"id":"doi:10.1093/bioinformatics/bth243","is_oa":true,"landing_page_url":"https://doi.org/10.1093/bioinformatics/bth243","pdf_url":"https://academic.oup.com/bioinformatics/article-pdf/20/15/2455/48905992/bioinformatics_20_15_2455.pdf","source":{"id":"https://openalex.org/S52395412","display_name":"Bioinformatics","issn_l":"1367-4803","issn":["1367-4803","1367-4811"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Bioinformatics","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.8399999737739563}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2111591568.pdf","grobid_xml":"https://content.openalex.org/works/W2111591568.grobid-xml"},"referenced_works_count":1,"referenced_works":["https://openalex.org/W2109091729"],"related_works":["https://openalex.org/W2098516643","https://openalex.org/W2576225315","https://openalex.org/W2527777278","https://openalex.org/W60511584","https://openalex.org/W4303984359","https://openalex.org/W2894526135","https://openalex.org/W1705148896","https://openalex.org/W2525788546","https://openalex.org/W2054295791","https://openalex.org/W3153191738"],"abstract_inverted_index":{"Downloading":[0],"the":[1,43],"information":[2,23,46],"stored":[3],"in":[4,17],"relational":[5,49],"databases":[6],"into":[7],"XML":[8,62],"and":[9,29,81],"other":[10,73],"flat":[11],"formats":[12],"is":[13,52],"a":[14,37,53],"common":[15],"task":[16],"bioinformatics.":[18],"This":[19],"periodical":[20],"dumping":[21],"of":[22,48],"requires":[24],"considerable":[25],"CPU":[26],"time,":[27],"disk":[28],"memory":[30,79],"resources.":[31],"YAdumper":[32,51,76],"has":[33],"been":[34],"developed":[35],"as":[36],"purpose-specific":[38],"tool":[39],"to":[40],"deal":[41],"with":[42,72],"integral":[44],"structured":[45],"download":[47],"databases.":[50],"Java":[54],"application":[55],"that":[56],"organizes":[57],"database":[58],"extraction":[59],"following":[60],"an":[61,66],"template":[63],"based":[64],"on":[65],"external":[67],"Document":[68],"Type":[69],"Declaration.":[70],"Compared":[71],"non-native":[74],"alternatives,":[75],"substantially":[77],"reduces":[78],"requirements":[80],"considerably":[82],"improves":[83],"writing":[84],"performance.":[85]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}