{"id":"https://openalex.org/W3215998847","doi":"https://doi.org/10.1109/access.2021.3130172","title":"Semi-Automated Formalization and Representation of the Engineering Knowledge Extracted From Spreadsheet Data","display_name":"Semi-Automated Formalization and Representation of the Engineering Knowledge Extracted From Spreadsheet Data","publication_year":2021,"publication_date":"2021-01-01","ids":{"openalex":"https://openalex.org/W3215998847","doi":"https://doi.org/10.1109/access.2021.3130172","mag":"3215998847"},"language":"en","primary_location":{"id":"doi:10.1109/access.2021.3130172","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2021.3130172","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/6514899/09624965.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://ieeexplore.ieee.org/ielx7/6287639/6514899/09624965.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5066595033","display_name":"Aleksandr Yu. Yurin","orcid":"https://orcid.org/0000-0001-9089-5730"},"institutions":[{"id":"https://openalex.org/I4210127387","display_name":"Siberian Branch of the Russian Academy of Sciences","ror":"https://ror.org/02frkq021","country_code":"RU","type":"funder","lineage":["https://openalex.org/I1313323035","https://openalex.org/I4210127387"]},{"id":"https://openalex.org/I4210148533","display_name":"Institute for System Dynamics and Control Theory","ror":"https://ror.org/04wteqw51","country_code":"RU","type":"facility","lineage":["https://openalex.org/I1313323035","https://openalex.org/I1313323035","https://openalex.org/I4210127387","https://openalex.org/I4210148533","https://openalex.org/I4210164537"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Aleksandr Yu. Yurin","raw_affiliation_strings":["Matrosov Institute for System Dynamics and Control Theory, Siberian Branch of the Russian Academy of Sciences, 134 Lermontov St., Irkutsk, 664033, Russia. (e-mail: iskander@icc.ru)","Matrosov Institute for System Dynamics and Control Theory, Siberian Branch of the Russian Academy of Sciences, 134 Lermontov St., Irkutsk, 664033, Russia"],"raw_orcid":"https://orcid.org/0000-0001-9089-5730","affiliations":[{"raw_affiliation_string":"Matrosov Institute for System Dynamics and Control Theory, Siberian Branch of the Russian Academy of Sciences, 134 Lermontov St., Irkutsk, 664033, Russia. (e-mail: iskander@icc.ru)","institution_ids":["https://openalex.org/I4210148533"]},{"raw_affiliation_string":"Matrosov Institute for System Dynamics and Control Theory, Siberian Branch of the Russian Academy of Sciences, 134 Lermontov St., Irkutsk, 664033, Russia","institution_ids":["https://openalex.org/I4210127387","https://openalex.org/I4210148533"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022770117","display_name":"Nikita O. Dorodnykh","orcid":"https://orcid.org/0000-0001-7794-4462"},"institutions":[{"id":"https://openalex.org/I4210127387","display_name":"Siberian Branch of the Russian Academy of Sciences","ror":"https://ror.org/02frkq021","country_code":"RU","type":"funder","lineage":["https://openalex.org/I1313323035","https://openalex.org/I4210127387"]},{"id":"https://openalex.org/I4210148533","display_name":"Institute for System Dynamics and Control Theory","ror":"https://ror.org/04wteqw51","country_code":"RU","type":"facility","lineage":["https://openalex.org/I1313323035","https://openalex.org/I1313323035","https://openalex.org/I4210127387","https://openalex.org/I4210148533","https://openalex.org/I4210164537"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Nikita O. Dorodnykh","raw_affiliation_strings":["Matrosov Institute for System Dynamics and Control Theory, Siberian Branch of the Russian Academy of Sciences, 134 Lermontov St., Irkutsk, 664033, Russia"],"raw_orcid":"https://orcid.org/0000-0001-7794-4462","affiliations":[{"raw_affiliation_string":"Matrosov Institute for System Dynamics and Control Theory, Siberian Branch of the Russian Academy of Sciences, 134 Lermontov St., Irkutsk, 664033, Russia","institution_ids":["https://openalex.org/I4210127387","https://openalex.org/I4210148533"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041210817","display_name":"Alexey Shigarov","orcid":"https://orcid.org/0000-0001-5572-5349"},"institutions":[{"id":"https://openalex.org/I4210127387","display_name":"Siberian Branch of the Russian Academy of Sciences","ror":"https://ror.org/02frkq021","country_code":"RU","type":"funder","lineage":["https://openalex.org/I1313323035","https://openalex.org/I4210127387"]},{"id":"https://openalex.org/I4210148533","display_name":"Institute for System Dynamics and Control Theory","ror":"https://ror.org/04wteqw51","country_code":"RU","type":"facility","lineage":["https://openalex.org/I1313323035","https://openalex.org/I1313323035","https://openalex.org/I4210127387","https://openalex.org/I4210148533","https://openalex.org/I4210164537"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Alexey O. Shigarov","raw_affiliation_strings":["Matrosov Institute for System Dynamics and Control Theory, Siberian Branch of the Russian Academy of Sciences, 134 Lermontov St., Irkutsk, 664033, Russia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Matrosov Institute for System Dynamics and Control Theory, Siberian Branch of the Russian Academy of Sciences, 134 Lermontov St., Irkutsk, 664033, Russia","institution_ids":["https://openalex.org/I4210127387","https://openalex.org/I4210148533"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":1850,"currency":"USD","value_usd":1850},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850},"fwci":0.5197,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.68616455,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"9","issue":null,"first_page":"157468","last_page":"157481"},"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.9916999936103821,"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.9916999936103821,"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.9898999929428101,"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"}},{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9794999957084656,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8293843269348145},{"id":"https://openalex.org/keywords/knowledge-base","display_name":"Knowledge base","score":0.6477200984954834},{"id":"https://openalex.org/keywords/knowledge-extraction","display_name":"Knowledge extraction","score":0.6067653894424438},{"id":"https://openalex.org/keywords/knowledge-representation-and-reasoning","display_name":"Knowledge representation and reasoning","score":0.5852800607681274},{"id":"https://openalex.org/keywords/domain-knowledge","display_name":"Domain knowledge","score":0.5415748357772827},{"id":"https://openalex.org/keywords/open-knowledge-base-connectivity","display_name":"Open Knowledge Base Connectivity","score":0.5360757112503052},{"id":"https://openalex.org/keywords/knowledge-based-systems","display_name":"Knowledge-based systems","score":0.4993631839752197},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.4732901453971863},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.47184160351753235},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.4690958261489868},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.4451340138912201},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4084670841693878},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2818005681037903},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.17571011185646057}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8293843269348145},{"id":"https://openalex.org/C4554734","wikidata":"https://www.wikidata.org/wiki/Q593744","display_name":"Knowledge base","level":2,"score":0.6477200984954834},{"id":"https://openalex.org/C120567893","wikidata":"https://www.wikidata.org/wiki/Q1582085","display_name":"Knowledge extraction","level":2,"score":0.6067653894424438},{"id":"https://openalex.org/C161301231","wikidata":"https://www.wikidata.org/wiki/Q3478658","display_name":"Knowledge representation and reasoning","level":2,"score":0.5852800607681274},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.5415748357772827},{"id":"https://openalex.org/C29804473","wikidata":"https://www.wikidata.org/wiki/Q2025711","display_name":"Open Knowledge Base Connectivity","level":4,"score":0.5360757112503052},{"id":"https://openalex.org/C115925183","wikidata":"https://www.wikidata.org/wiki/Q1412694","display_name":"Knowledge-based systems","level":2,"score":0.4993631839752197},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.4732901453971863},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.47184160351753235},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4690958261489868},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.4451340138912201},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4084670841693878},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2818005681037903},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.17571011185646057},{"id":"https://openalex.org/C187572123","wikidata":"https://www.wikidata.org/wiki/Q2034224","display_name":"Personal knowledge management","level":3,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C169735623","wikidata":"https://www.wikidata.org/wiki/Q1430172","display_name":"Organizational learning","level":2,"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/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"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/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/access.2021.3130172","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2021.3130172","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/6514899/09624965.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:e886d4d1ce56412886aca8dc904d4297","is_oa":true,"landing_page_url":"https://doaj.org/article/e886d4d1ce56412886aca8dc904d4297","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"IEEE Access, Vol 9, Pp 157468-157481 (2021)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1109/access.2021.3130172","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2021.3130172","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/6514899/09624965.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.6899999976158142,"display_name":"Peace, Justice and strong institutions"}],"awards":[{"id":"https://openalex.org/G4781639747","display_name":null,"funder_award_id":"18-71-10001","funder_id":"https://openalex.org/F4320324099","funder_display_name":"Russian Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320324099","display_name":"Russian Science Foundation","ror":"https://ror.org/03y2gwe85"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3215998847.pdf","grobid_xml":"https://content.openalex.org/works/W3215998847.grobid-xml"},"referenced_works_count":43,"referenced_works":["https://openalex.org/W767479537","https://openalex.org/W1509330973","https://openalex.org/W1515921409","https://openalex.org/W1520065529","https://openalex.org/W1524150562","https://openalex.org/W1647671624","https://openalex.org/W1787267004","https://openalex.org/W1866311776","https://openalex.org/W1966175676","https://openalex.org/W1976081865","https://openalex.org/W1978492080","https://openalex.org/W1985496580","https://openalex.org/W1989140425","https://openalex.org/W2000117114","https://openalex.org/W2035270037","https://openalex.org/W2041878779","https://openalex.org/W2048513628","https://openalex.org/W2052198547","https://openalex.org/W2057181438","https://openalex.org/W2064673200","https://openalex.org/W2092590711","https://openalex.org/W2114215601","https://openalex.org/W2117565756","https://openalex.org/W2120357908","https://openalex.org/W2167110031","https://openalex.org/W2178219716","https://openalex.org/W2185907055","https://openalex.org/W2258041347","https://openalex.org/W2341748398","https://openalex.org/W2405999500","https://openalex.org/W2482029309","https://openalex.org/W2539977591","https://openalex.org/W2581101346","https://openalex.org/W2747850582","https://openalex.org/W2796082602","https://openalex.org/W2947403397","https://openalex.org/W2954832225","https://openalex.org/W2999986652","https://openalex.org/W3004911330","https://openalex.org/W6636915900","https://openalex.org/W6684580744","https://openalex.org/W6692483407","https://openalex.org/W6713723612"],"related_works":["https://openalex.org/W2075096090","https://openalex.org/W1966135007","https://openalex.org/W2136104224","https://openalex.org/W1520100787","https://openalex.org/W3045387744","https://openalex.org/W1838463810","https://openalex.org/W2126191795","https://openalex.org/W4386211463","https://openalex.org/W2294170235","https://openalex.org/W2187382322"],"abstract_inverted_index":{"The":[0,127],"development":[1,137],"of":[2,11,17,20,27,45,62,68,108,138,185],"new":[3],"methods":[4],"and":[5,9,39,60,71,101,106,120,155,169],"tools":[6],"for":[7,142,188],"formalization":[8,38,59,100],"representation":[10,40,61,102],"complex":[12],"knowledge":[13,37,64,72,99,118,167,190],"in":[14,24,47,65],"the":[15,18,25,36,57,66,104,136,143,177,183,186],"context":[16],"creation":[19],"intelligent":[21],"systems":[22],"remains":[23],"scope":[26],"scientific":[28],"research.":[29],"There":[30],"is":[31,129,151],"a":[32,53,91,124,139,165],"trend":[33],"to":[34,56,90,153,163],"automate":[35],"by":[41,131],"using":[42],"various":[43],"sources":[44],"information,":[46],"particular,":[48],"spreadsheets.":[49],"This":[50],"paper":[51],"proposes":[52],"novel":[54],"approach":[55,79,128,187],"semi-automatic":[58],"engineering":[63],"form":[67,94],"conceptual":[69,109,157],"models":[70,158],"base":[73,119,168],"codes":[74,122],"from":[75,112,123],"spreadsheet":[76,88,144],"data.":[77],"Our":[78,173],"contains":[80],"three":[81],"phases:":[82],"(I)":[83],"rule-driven":[84],"data":[85,145],"transformation":[86],"source":[87,121,171],"tables":[89],"specific":[92],"canonical":[93],"(data":[95],"preprocessing),":[96],"(II)":[97],"domain":[98,125],"via":[103],"extraction":[105],"aggregation":[107],"model":[110],"fragments":[111],"canonicalized":[113],"tables,":[114],"(III)":[115],"model-driven":[116],"synthesizing":[117],"model.":[126],"implemented":[130],"our":[132],"tools:":[133],"TABBYXL":[134],"provides":[135],"software":[140],"application":[141],"canonicalization;":[146],"Personal":[147],"Knowledge":[148],"Base":[149],"Designer":[150],"used":[152],"build":[154],"aggregate":[156],"fragments,":[159],"as":[160,162],"well":[161],"construct":[164],"target":[166],"generation":[170],"codes.":[172],"case":[174],"study":[175],"on":[176],"industrial":[178],"safety":[179],"inspection":[180],"(ISI)":[181],"demonstrates":[182],"applicability":[184],"prototyping":[189],"bases":[191],"containing":[192],"decision-making":[193],"rules.":[194]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}