{"id":"https://openalex.org/W3191947563","doi":"https://doi.org/10.1109/idt52577.2021.9497629","title":"Mapping rules for schema transformation : SQL to NoSQL and back","display_name":"Mapping rules for schema transformation : SQL to NoSQL and back","publication_year":2021,"publication_date":"2021-06-22","ids":{"openalex":"https://openalex.org/W3191947563","doi":"https://doi.org/10.1109/idt52577.2021.9497629","mag":"3191947563"},"language":"en","primary_location":{"id":"doi:10.1109/idt52577.2021.9497629","is_oa":false,"landing_page_url":"https://doi.org/10.1109/idt52577.2021.9497629","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2021 International Conference on Information and Digital Technologies (IDT)","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"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/A5029670847","display_name":"Roman \u010cere\u0161\u0148\u00e1k","orcid":null},"institutions":[{"id":"https://openalex.org/I3122011922","display_name":"University of \u017dilina","ror":"https://ror.org/031wwwj55","country_code":"SK","type":"education","lineage":["https://openalex.org/I3122011922"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Roman Ceresnak","raw_affiliation_strings":["Faculty of Management and Informatics, University of \u017dilina, \u017dilina, Slovakia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Management and Informatics, University of \u017dilina, \u017dilina, Slovakia","institution_ids":["https://openalex.org/I3122011922"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012027728","display_name":"Adam Dud\u00e1\u0161","orcid":"https://orcid.org/0000-0001-5517-9464"},"institutions":[{"id":"https://openalex.org/I59655833","display_name":"Matej Bel University","ror":"https://ror.org/016e5hy63","country_code":"SK","type":"education","lineage":["https://openalex.org/I59655833"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Adam Dudas","raw_affiliation_strings":["Faculty of Natural Sciences, Matej Bel University, Bansk\u00e1 Bystrica, Slovakia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Natural Sciences, Matej Bel University, Bansk\u00e1 Bystrica, Slovakia","institution_ids":["https://openalex.org/I59655833"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016665318","display_name":"Karol Matia\u0161ko","orcid":"https://orcid.org/0000-0001-7173-2661"},"institutions":[{"id":"https://openalex.org/I3122011922","display_name":"University of \u017dilina","ror":"https://ror.org/031wwwj55","country_code":"SK","type":"education","lineage":["https://openalex.org/I3122011922"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Karol Matiasko","raw_affiliation_strings":["Faculty of Management and Informatics, University of \u017dilina, \u017dilina, Slovakia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Management and Informatics, University of \u017dilina, \u017dilina, Slovakia","institution_ids":["https://openalex.org/I3122011922"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5050102565","display_name":"Michal Kvet","orcid":"https://orcid.org/0000-0003-3937-7473"},"institutions":[{"id":"https://openalex.org/I3122011922","display_name":"University of \u017dilina","ror":"https://ror.org/031wwwj55","country_code":"SK","type":"education","lineage":["https://openalex.org/I3122011922"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Michal Kvet","raw_affiliation_strings":["Faculty of Management and Informatics, University of \u017dilina, \u017dilina, Slovakia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Management and Informatics, University of \u017dilina, \u017dilina, Slovakia","institution_ids":["https://openalex.org/I3122011922"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.6278,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.82598584,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"52","last_page":"58"},"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.9997000098228455,"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.9997000098228455,"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.9975000023841858,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9975000023841858,"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/nosql","display_name":"NoSQL","score":0.9357235431671143},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.8093971014022827},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.761691689491272},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7172186970710754},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6725635528564453},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.6393811702728271},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5759257674217224},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5758249163627625},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5725005865097046},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5471354126930237},{"id":"https://openalex.org/keywords/semi-structured-data","display_name":"Semi-structured data","score":0.4946887195110321},{"id":"https://openalex.org/keywords/data-migration","display_name":"Data migration","score":0.45863187313079834},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4190444350242615},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.41149580478668213},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.41122564673423767},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.346184641122818},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.31431853771209717}],"concepts":[{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.9357235431671143},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.8093971014022827},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.761691689491272},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7172186970710754},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6725635528564453},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.6393811702728271},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5759257674217224},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5758249163627625},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5725005865097046},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5471354126930237},{"id":"https://openalex.org/C40077939","wikidata":"https://www.wikidata.org/wiki/Q2336004","display_name":"Semi-structured data","level":3,"score":0.4946887195110321},{"id":"https://openalex.org/C146152329","wikidata":"https://www.wikidata.org/wiki/Q1932543","display_name":"Data migration","level":2,"score":0.45863187313079834},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4190444350242615},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.41149580478668213},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.41122564673423767},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.346184641122818},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.31431853771209717},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/idt52577.2021.9497629","is_oa":false,"landing_page_url":"https://doi.org/10.1109/idt52577.2021.9497629","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2021 International Conference on Information and Digital Technologies (IDT)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.550000011920929,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W1677822096","https://openalex.org/W1996063819","https://openalex.org/W2041106018","https://openalex.org/W2047742073","https://openalex.org/W2118867530","https://openalex.org/W2168935341","https://openalex.org/W2294637194","https://openalex.org/W2373918503","https://openalex.org/W2523978769","https://openalex.org/W2527777278","https://openalex.org/W2593197694","https://openalex.org/W2625861715","https://openalex.org/W2950183981"],"related_works":["https://openalex.org/W3097241194","https://openalex.org/W1978969411","https://openalex.org/W2007556552","https://openalex.org/W2460926837","https://openalex.org/W2029823850","https://openalex.org/W2356754926","https://openalex.org/W1019487387","https://openalex.org/W1599476819","https://openalex.org/W1601067216","https://openalex.org/W3191947563"],"abstract_inverted_index":{"Efficient":[0],"way":[1,96],"of":[2,27,43,69,74,97,102,140,191,202,215,230],"storing":[3],"data":[4,30,51,75,103,166],"has":[5],"always":[6],"been":[7,105],"a":[8,12,89,93,118,149,153,158,169,173,197],"key":[9],"requirement":[10],"for":[11,21,120,161,199],"properly":[13],"designed":[14],"database":[15,151,155,171,175,205,210,214,253],"system.":[16],"With":[17],"the":[18,24,38,49,83,184,203,208,216,228,235,246,250,255],"growing":[19],"demand":[20],"this":[22,41,54,144,192,239],"property,":[23],"first":[25],"concept":[26],"an":[28],"efficient":[29,95],"storage":[31,52],"called":[32,113],"relational":[33,60,121,128,150,170,236,256],"databases":[34,44,61,87,111,131],"was":[35],"developed":[36],"in":[37,234,245],"1960s":[39],"-":[40],"type":[42,229],"is":[45,138,179,194,224],"still":[46],"used":[47],"as":[48,177,220],"primary":[50],"to":[53,64,81,129,152,172,183,195,207,254],"day.":[55],"In":[56,79,107],"recent":[57],"years,":[58],"however,":[59],"have":[62,104,116],"failed":[63],"deal":[65],"with":[66,88,99,143],"two":[67],"aspects":[68],"modern":[70],"data:":[71],"large":[72,100],"volumes":[73,101],"and":[76,92,238],"unstructured":[77],"data.":[78,164],"order":[80],"solve":[82],"mentioned":[84],"problems":[85,141],"looser":[86],"flexible":[90],"structure":[91],"more":[94,180],"working":[98],"created.":[106],"many":[108],"cases,":[109],"non-relational":[110,130,154,174,251],"also":[112,242],"NoSQL":[114,209,213],"databases,":[115],"become":[117],"replacement":[119],"databases.":[122],"Several":[123],"applications":[124],"require":[125],"migration":[126],"from":[127,148,168,249],"based":[132,226],"on":[133,227],"suitable":[134],"properties":[135],"while":[136],"there":[137],"number":[139],"associated":[142],"migration.":[145],"Moving":[146],"records":[147],"requires":[156],"having":[157],"structured":[159],"methodology":[160],"transforming":[162],"existing":[163],"This":[165],"transformation":[167],"(such":[176],"MongoDB),":[178],"difficult":[181],"due":[182],"non-existent":[185],"transmission":[186],"standards.":[187],"The":[188,222],"main":[189],"objective":[190],"paper":[193],"present":[196],"proposal":[198],"mapping":[200,223],"rules":[201],"relation":[204],"schema":[206],"schema,":[211],"specifically":[212],"key-value":[217],"type,":[218],"such":[219],"MongoDB.":[221],"performed":[225],"relationship":[231],"that":[232],"occurs":[233],"database,":[237],"process":[240],"can":[241],"be":[243],"applied":[244],"opposite":[247],"direction,":[248],"MongoDB":[252],"database.":[257]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}