{"id":"https://openalex.org/W2990124140","doi":"https://doi.org/10.3233/shti190814","title":"Spreadsheet Model Generator (SMOG): A Lightweight Tool for Object-Spreadsheet Mapping","display_name":"Spreadsheet Model Generator (SMOG): A Lightweight Tool for Object-Spreadsheet Mapping","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2990124140","doi":"https://doi.org/10.3233/shti190814","mag":"2990124140","pmid":"https://pubmed.ncbi.nlm.nih.gov/31483262"},"language":"en","primary_location":{"id":"doi:10.3233/shti190814","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti190814","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"type":"article","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.3233/shti190814","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5058571630","display_name":"Alexandr Uciteli","orcid":"https://orcid.org/0000-0001-9558-5352"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Uciteli Alexandr","raw_affiliation_strings":["Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University of Leipzig, Germany"],"affiliations":[{"raw_affiliation_string":"Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University of Leipzig, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016125618","display_name":"Christoph Beger","orcid":"https://orcid.org/0000-0002-1166-0368"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Beger Christoph","raw_affiliation_strings":["Growth Network CrescNet, University of Leipzig, Germany","Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University of Leipzig, Germany"],"affiliations":[{"raw_affiliation_string":"Growth Network CrescNet, University of Leipzig, Germany","institution_ids":[]},{"raw_affiliation_string":"Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University of Leipzig, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034903408","display_name":"Stefan Kropf","orcid":"https://orcid.org/0000-0003-1305-8108"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kropf Stefan","raw_affiliation_strings":["Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University of Leipzig, Germany"],"affiliations":[{"raw_affiliation_string":"Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University of Leipzig, Germany","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5020087024","display_name":"Heinrich Herre","orcid":"https://orcid.org/0000-0001-5343-9218"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Herre Heinrich","raw_affiliation_strings":["Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University of Leipzig, Germany"],"affiliations":[{"raw_affiliation_string":"Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University of Leipzig, Germany","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5058571630"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.24111675,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":"267","issue":null,"first_page":"110","last_page":"117"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9915000200271606,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9915000200271606,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11614","display_name":"Cloud Data Security Solutions","score":0.9093000292778015,"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.8507892489433289},{"id":"https://openalex.org/keywords/ontology","display_name":"Ontology","score":0.6955058574676514},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.542051374912262},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.5227711200714111},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.5223356485366821},{"id":"https://openalex.org/keywords/generator","display_name":"Generator (circuit theory)","score":0.4896088242530823},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.446153461933136},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.436839759349823},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.4196586608886719},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.4107869863510132},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.39128896594047546},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3905409872531891},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1570897400379181}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8507892489433289},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.6955058574676514},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.542051374912262},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.5227711200714111},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5223356485366821},{"id":"https://openalex.org/C2780992000","wikidata":"https://www.wikidata.org/wiki/Q17016113","display_name":"Generator (circuit theory)","level":3,"score":0.4896088242530823},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.446153461933136},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.436839759349823},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.4196586608886719},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4107869863510132},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.39128896594047546},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3905409872531891},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1570897400379181},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.0}],"mesh":[{"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}],"locations_count":2,"locations":[{"id":"doi:10.3233/shti190814","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti190814","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:31483262","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/31483262","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":"Studies in health technology and informatics","raw_type":null}],"best_oa_location":{"id":"doi:10.3233/shti190814","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti190814","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"sustainable_development_goals":[{"score":0.4399999976158142,"display_name":"Responsible consumption and production","id":"https://metadata.un.org/sdg/12"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2749690376","https://openalex.org/W2003333417","https://openalex.org/W2786317006","https://openalex.org/W4367724653","https://openalex.org/W2788563018","https://openalex.org/W4395962217","https://openalex.org/W2759030965","https://openalex.org/W4287064674","https://openalex.org/W3188573563","https://openalex.org/W3201246199"],"abstract_inverted_index":{"In":[0,105,135,151],"the":[1,89,100,113,118,126,133,180,196],"life":[2],"science":[3],"domain,":[4],"experts":[5],"are":[6],"usually":[7],"familiar":[8],"with":[9],"spreadsheet":[10,32,56,90,101,119,158,166,190,199],"software":[11,44,145],"and":[12,22,29,102,140,164,184,189,202],"often":[13,82],"use":[14,112],"it":[15,108],"in":[16,61,217],"their":[17],"daily":[18],"work":[19],"to":[20,64,74,98,111,161,177],"collect":[21],"structure":[23,87],"required":[24],"domain":[25],"knowledge.":[26],"The":[27,168,210],"processing":[28,159],"analysis":[30],"of":[31,55,88,143,148,198,207],"data":[33,57,120,128],"is":[34,50,109,147],"an":[35,53,62,138,204],"important":[36],"task":[37],"that":[38],"must":[39,121],"be":[40,122,130],"supported":[41],"by":[42],"efficient":[43,139,205],"solutions.":[45],"A":[46],"typical":[47],"application":[48],"scenario":[49],"for":[51],"example":[52],"integration":[54],"(specified":[58],"or":[59,67,92],"derived)":[60],"ontology":[63],"provide":[65],"reasoning":[66],"search.":[68],"Different":[69],"converter":[70,115],"tools":[71,80,116],"were":[72],"developed":[73],"support":[75],"a":[76,84,156,174],"spreadsheet-to-ontology":[77],"transformation.":[78],"Such":[79],"allow":[81],"only":[83],"relatively":[85],"simple":[86,175],"template":[91],"they":[93],"require":[94],"complex":[95],"mapping":[96],"processes":[97],"map":[99],"ontological":[103],"entities.":[104,191],"many":[106],"cases,":[107,137],"impossible":[110],"existing":[114],"because":[117],"processed":[123],"first":[124],"before":[125],"derived":[127],"can":[129],"integrated":[131],"into":[132],"ontology.":[134],"such":[136],"fast":[141],"development":[142,206],"customized":[144],"solutions":[146],"great":[149],"importance.":[150],"this":[152],"paper,":[153],"we":[154],"present":[155],"general":[157],"framework":[160],"efficiently":[162],"read":[163],"write":[165],"data.":[167],"Spreadsheet":[169],"Model":[170],"Generator":[171],"(SMOG)":[172],"provides":[173],"mechanism":[176],"automatically":[178],"generate":[179],"Java":[181],"object":[182,187],"model":[183],"mappings":[185],"between":[186],"code":[188],"Our":[192],"solution":[193],"greatly":[194],"simplifies":[195],"implementation":[197],"access":[200],"methods":[201],"enables":[203],"spreadsheet-based":[208],"applications.":[209],"SMOG":[211],"has":[212],"already":[213],"been":[214],"used":[215],"successfully":[216],"several":[218],"biomedical":[219],"projects":[220],"under":[221],"real":[222],"world":[223],"conditions.":[224]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-02-25T21:11:00.739837","created_date":"2025-10-10T00:00:00"}