{"id":"https://openalex.org/W2991266382","doi":"https://doi.org/10.3390/data4040148","title":"Transformation of Schema from Relational Database (RDB) to NoSQL Databases","display_name":"Transformation of Schema from Relational Database (RDB) to NoSQL Databases","publication_year":2019,"publication_date":"2019-11-27","ids":{"openalex":"https://openalex.org/W2991266382","doi":"https://doi.org/10.3390/data4040148","mag":"2991266382"},"language":"en","primary_location":{"id":"doi:10.3390/data4040148","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data4040148","pdf_url":"https://www.mdpi.com/2306-5729/4/4/148/pdf?version=1576650064","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2306-5729/4/4/148/pdf?version=1576650064","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086272542","display_name":"Obaid Alotaibi","orcid":"https://orcid.org/0000-0003-3235-3428"},"institutions":[{"id":"https://openalex.org/I206935292","display_name":"Shaqra University","ror":"https://ror.org/05hawb687","country_code":"SA","type":"education","lineage":["https://openalex.org/I206935292"]}],"countries":["SA"],"is_corresponding":false,"raw_author_name":"Obaid Alotaibi","raw_affiliation_strings":["Department of Computer Science, College of Science and Arts, Sajir Campus, Shaqra University, Sajir City 11951, Saudi Arabia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, College of Science and Arts, Sajir Campus, Shaqra University, Sajir City 11951, Saudi Arabia","institution_ids":["https://openalex.org/I206935292"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048148236","display_name":"Eric Pardede","orcid":"https://orcid.org/0000-0001-8218-2343"},"institutions":[{"id":"https://openalex.org/I196829312","display_name":"La Trobe University","ror":"https://ror.org/01rxfrp27","country_code":"AU","type":"education","lineage":["https://openalex.org/I196829312"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Eric Pardede","raw_affiliation_strings":["Department of Computer Science and Information Technology, School of Engineering and Mathematical Sciences, Melbourne Campus, La Trobe University, Victoria 3086, Australia"],"raw_orcid":"https://orcid.org/0000-0001-8218-2343","affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Technology, School of Engineering and Mathematical Sciences, Melbourne Campus, La Trobe University, Victoria 3086, Australia","institution_ids":["https://openalex.org/I196829312"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5048148236"],"corresponding_institution_ids":["https://openalex.org/I196829312"],"apc_list":{"value":1600,"currency":"CHF","value_usd":1732},"apc_paid":{"value":1600,"currency":"CHF","value_usd":1732},"fwci":1.8571,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":{"value":0.87388569,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":99},"biblio":{"volume":"4","issue":"4","first_page":"148","last_page":"148"},"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.9993000030517578,"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.9993000030517578,"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/T11106","display_name":"Data Management and Algorithms","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.9677493572235107},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.8061153888702393},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7495957612991333},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.621949315071106},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.610780656337738},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5624419450759888},{"id":"https://openalex.org/keywords/xml-database","display_name":"XML database","score":0.5588868856430054},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.5518515706062317},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.4480859339237213},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.42291027307510376},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.42257586121559143},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4164941608905792},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3735557496547699},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.1275404989719391},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.12352028489112854},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.11581218242645264},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.0939590334892273}],"concepts":[{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.9677493572235107},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.8061153888702393},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7495957612991333},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.621949315071106},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.610780656337738},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5624419450759888},{"id":"https://openalex.org/C183068750","wikidata":"https://www.wikidata.org/wiki/Q357393","display_name":"XML database","level":3,"score":0.5588868856430054},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.5518515706062317},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.4480859339237213},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.42291027307510376},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.42257586121559143},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4164941608905792},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3735557496547699},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.1275404989719391},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.12352028489112854},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.11581218242645264},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.0939590334892273}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/data4040148","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data4040148","pdf_url":"https://www.mdpi.com/2306-5729/4/4/148/pdf?version=1576650064","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:gam:jdataj:v:4:y:2019:i:4:p:148-:d:291547","is_oa":false,"landing_page_url":"https://www.mdpi.com/2306-5729/4/4/148/","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"pmh:oai:mdpi.com:/2306-5729/4/4/148/","is_oa":true,"landing_page_url":"http://dx.doi.org/10.3390/data4040148","pdf_url":null,"source":{"id":"https://openalex.org/S4306400947","display_name":"MDPI (MDPI AG)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210097602","host_organization_name":"Multidisciplinary Digital Publishing Institute (Switzerland)","host_organization_lineage":["https://openalex.org/I4210097602"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Data","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.3390/data4040148","is_oa":true,"landing_page_url":"https://doi.org/10.3390/data4040148","pdf_url":"https://www.mdpi.com/2306-5729/4/4/148/pdf?version=1576650064","source":{"id":"https://openalex.org/S4210226510","display_name":"Data","issn_l":"2306-5729","issn":["2306-5729"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2991266382.pdf","grobid_xml":"https://content.openalex.org/works/W2991266382.grobid-xml"},"referenced_works_count":17,"referenced_works":["https://openalex.org/W1488255798","https://openalex.org/W1677822096","https://openalex.org/W1996063819","https://openalex.org/W2041106018","https://openalex.org/W2047742073","https://openalex.org/W2118867530","https://openalex.org/W2122494833","https://openalex.org/W2168935341","https://openalex.org/W2294637194","https://openalex.org/W2373918503","https://openalex.org/W2482127814","https://openalex.org/W2523978769","https://openalex.org/W2538875704","https://openalex.org/W2556970231","https://openalex.org/W2593197694","https://openalex.org/W2625861715","https://openalex.org/W2783930173"],"related_works":["https://openalex.org/W3176711676","https://openalex.org/W3030748926","https://openalex.org/W1962922984","https://openalex.org/W3191947563","https://openalex.org/W2945730730","https://openalex.org/W2766650518","https://openalex.org/W3039327773","https://openalex.org/W2794627887","https://openalex.org/W4283580354","https://openalex.org/W2991266382"],"abstract_inverted_index":{"Relational":[0],"database":[1,6,71,82,112],"has":[2,17,83],"been":[3,18],"the":[4,13,34,47,126,145,171,174,179],"de-facto":[5],"choice":[7],"in":[8,46,69,133,166],"most":[9],"IT":[10],"applications.":[11],"In":[12,177],"last":[14],"decade":[15],"there":[16,36,56,88],"increasing":[19],"demand":[20],"for":[21],"applications":[22],"that":[23,130],"have":[24,61],"to":[25,41,60,65,73,80,102,109,169],"deal":[26],"with":[27,53],"massive":[28],"and":[29,117,158],"un-normalized":[30],"data.":[31],"To":[32],"satisfy":[33],"demand,":[35],"is":[37,57,89,101,164],"a":[38,58,62,136,139,148],"big":[39],"shift":[40],"use":[42],"more":[43,85],"relaxed":[44],"databases":[45,168],"form":[48],"of":[49,98,106,128,141,162,173,181],"NoSQL":[50,74,81,94,111,153],"databases.":[51,119],"Alongside":[52],"this":[54,99],"shift,":[55],"need":[59],"structured":[63],"methodology":[64],"transform":[66],"existing":[67,188],"data":[68,134],"relational":[70],"(RDB)":[72],"database.":[75,95,137],"The":[76,96,120],"transformation":[77,104,175,183],"from":[78],"RDB":[79,107],"become":[84],"challenging":[86],"because":[87],"no":[90],"current":[91],"standard":[92],"on":[93,125],"aim":[97],"paper":[100],"propose":[103],"rules":[105,121,146,184],"Schema":[108],"various":[110],"schema,":[113],"namely":[114,155],"document-based,":[115],"column-based":[116],"graph-based":[118],"are":[122,185],"applied":[123],"based":[124],"type":[127],"relationships":[129],"can":[131],"appear":[132],"within":[135],"As":[138],"proof":[140],"concept,":[142],"we":[143],"apply":[144],"into":[147],"case":[149],"study":[150],"using":[151],"three":[152],"databases,":[154],"MongoDB,":[156],"Cassandra,":[157],"Neo4j.":[159],"A":[160],"set":[161],"queries":[163],"run":[165],"these":[167],"demonstrate":[170],"correctness":[172],"results.":[176],"addition,":[178],"completeness":[180],"our":[182],"compared":[186],"against":[187],"work.":[189]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":10},{"year":2022,"cited_by_count":6},{"year":2020,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2019-12-05T00:00:00"}
