P3对象关系数据向NoSQL文档型数据存储迁移过程

A. Aggoune, Mohamed Sofiane Namoune
{"title":"P3对象关系数据向NoSQL文档型数据存储迁移过程","authors":"A. Aggoune, Mohamed Sofiane Namoune","doi":"10.4018/ijssci.309994","DOIUrl":null,"url":null,"abstract":"The exponential growth of complex data in object-relational databases (ORDB) raises the need for efficient storage with scalability, consistency, and partition tolerance. The migration towards NoSQL (not only structured query language) datastores is the best fit for distributed complex data. Unfortunately, very few studies provide solutions for ORDB migration to NoSQL. This paper reports on how to achieve the migration of complex data from ORDB to a document-oriented NoSQL database. The proposed approach focused on the P3 process that involves three major stages: (P1) the preprocessing stage to access and extract the database features using SQL queries, (P2) the processing stage to provide the data mapping by using a list of mapping rules between the source and target models, and (P3) the post-processing stage to store and request the migrated data within the NoSQL context. A thorough experiments on two real-life databases veriðes the P3 process improves the performance of data migration with complex schema structures.","PeriodicalId":432255,"journal":{"name":"Int. J. Softw. Sci. Comput. Intell.","volume":"46 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"P3 Process for Object-Relational Data Migration to NoSQL Document-Oriented Datastore\",\"authors\":\"A. Aggoune, Mohamed Sofiane Namoune\",\"doi\":\"10.4018/ijssci.309994\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The exponential growth of complex data in object-relational databases (ORDB) raises the need for efficient storage with scalability, consistency, and partition tolerance. The migration towards NoSQL (not only structured query language) datastores is the best fit for distributed complex data. Unfortunately, very few studies provide solutions for ORDB migration to NoSQL. This paper reports on how to achieve the migration of complex data from ORDB to a document-oriented NoSQL database. The proposed approach focused on the P3 process that involves three major stages: (P1) the preprocessing stage to access and extract the database features using SQL queries, (P2) the processing stage to provide the data mapping by using a list of mapping rules between the source and target models, and (P3) the post-processing stage to store and request the migrated data within the NoSQL context. A thorough experiments on two real-life databases veriðes the P3 process improves the performance of data migration with complex schema structures.\",\"PeriodicalId\":432255,\"journal\":{\"name\":\"Int. J. Softw. Sci. Comput. Intell.\",\"volume\":\"46 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-01-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Int. J. Softw. Sci. Comput. Intell.\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.4018/ijssci.309994\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Int. J. Softw. Sci. Comput. Intell.","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.4018/ijssci.309994","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0

摘要

对象关系数据库(ORDB)中复杂数据的指数级增长提出了对具有可伸缩性、一致性和分区容忍度的高效存储的需求。迁移到NoSQL(不仅仅是结构化查询语言)数据存储是最适合分布式复杂数据的。不幸的是,很少有研究提供ORDB迁移到NoSQL的解决方案。本文介绍了如何实现复杂数据从ORDB到面向文档的NoSQL数据库的迁移。提出的方法侧重于P3过程,该过程包括三个主要阶段:(P1)预处理阶段,使用SQL查询访问和提取数据库特征;(P2)处理阶段,使用源模型和目标模型之间的映射规则列表提供数据映射;(P3)后处理阶段,在NoSQL上下文中存储和请求迁移后的数据。在两个实际数据库上进行的实验表明,P3过程提高了复杂模式结构下数据迁移的性能。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
P3 Process for Object-Relational Data Migration to NoSQL Document-Oriented Datastore
The exponential growth of complex data in object-relational databases (ORDB) raises the need for efficient storage with scalability, consistency, and partition tolerance. The migration towards NoSQL (not only structured query language) datastores is the best fit for distributed complex data. Unfortunately, very few studies provide solutions for ORDB migration to NoSQL. This paper reports on how to achieve the migration of complex data from ORDB to a document-oriented NoSQL database. The proposed approach focused on the P3 process that involves three major stages: (P1) the preprocessing stage to access and extract the database features using SQL queries, (P2) the processing stage to provide the data mapping by using a list of mapping rules between the source and target models, and (P3) the post-processing stage to store and request the migrated data within the NoSQL context. A thorough experiments on two real-life databases veriðes the P3 process improves the performance of data migration with complex schema structures.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
自引率
0.00%
发文量
0
期刊最新文献
Knowledge Discovery of Hospital Medical Technology Based on Partial Ordered Structure Diagrams Artificial Intelligence Techniques to improve cognitive traits of Down Syndrome Individuals: An Analysis TA-WHI: Text Analysis of Web-Based Health Information Detection of Distributed Denial of Service (DDoS) Attacks Using Computational Intelligence and Majority Vote-Based Ensemble Approach Model-Based Method for Optimisation of an Adaptive System
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1