传统RDBMS向非关系型MongoDB数据模型转换与数据迁移方法研究
为解决关系型数据库在大数据处理中遇到的瓶颈问题，满足企业对大数据处理的需求，提出将关系型数据库迁移到NoSQL文档型数据库中。针对RDBMS中的关系模型向MongoDB中的集合模型转换方法进行了研究，提出了表示关系间参照完整性的有向图表示模型，以及基于关系型数据模型向MongoDB文档模型自动转换算法，实现了RDBMS中迁移数据到MongoDB的插入算法。针对上述方案和算法，结合典型开源RDBMS-MySQL实例，对上述关系有向图模型的生成、基于有向图模型的转换算法以及数据迁移算法应用进行验证，实验结果表明RDBMS可以按照一定的数据结构平滑地迁移到MongoDB中。...
Saved in:
| Published in | 计算机应用研究 Vol. 34; no. 11; pp. 3339 - 3344 |
|---|---|
| Main Author | |
| Format | Journal Article |
| Language | Chinese |
| Published |
西南交通大学信息科学与技术学院,成都,610031%四川宁江山川机械有限责任公司,成都,610106
2017
|
| Subjects | |
| Online Access | Get full text |
| ISSN | 1001-3695 |
| DOI | 10.3969/j.issn.1001-3695.2017.11.031 |
Cover
| Abstract | 为解决关系型数据库在大数据处理中遇到的瓶颈问题，满足企业对大数据处理的需求，提出将关系型数据库迁移到NoSQL文档型数据库中。针对RDBMS中的关系模型向MongoDB中的集合模型转换方法进行了研究，提出了表示关系间参照完整性的有向图表示模型，以及基于关系型数据模型向MongoDB文档模型自动转换算法，实现了RDBMS中迁移数据到MongoDB的插入算法。针对上述方案和算法，结合典型开源RDBMS-MySQL实例，对上述关系有向图模型的生成、基于有向图模型的转换算法以及数据迁移算法应用进行验证，实验结果表明RDBMS可以按照一定的数据结构平滑地迁移到MongoDB中。 |
|---|---|
| AbstractList | 为解决关系型数据库在大数据处理中遇到的瓶颈问题，满足企业对大数据处理的需求，提出将关系型数据库迁移到NoSQL文档型数据库中。针对RDBMS中的关系模型向MongoDB中的集合模型转换方法进行了研究，提出了表示关系间参照完整性的有向图表示模型，以及基于关系型数据模型向MongoDB文档模型自动转换算法，实现了RDBMS中迁移数据到MongoDB的插入算法。针对上述方案和算法，结合典型开源RDBMS-MySQL实例，对上述关系有向图模型的生成、基于有向图模型的转换算法以及数据迁移算法应用进行验证，实验结果表明RDBMS可以按照一定的数据结构平滑地迁移到MongoDB中。 TP311.13; 为解决关系型数据库在大数据处理中遇到的瓶颈问题,满足企业对大数据处理的需求,提出将关系型数据库迁移到NoSQL文档型数据库中.针对RDBMS中的关系模型向MongoDB中的集合模型转换方法进行了研究,提出了表示关系间参照完整性的有向图表示模型,以及基于关系型数据模型向MongoDB文档模型自动转换算法,实现了RDBMS中迁移数据到MongoDB的插入算法.针对上述方案和算法,结合典型开源RDBMS-MySQL实例,对上述关系有向图模型的生成、基于有向图模型的转换算法以及数据迁移算法应用进行验证,实验结果表明RDBMS可以按照一定的数据结构平滑地迁移到MongoDB中. |
| Abstract_FL | In order to solve the bottleneck problem encountered in the large data processing of relational database and satisfy the demand of large data processing for enterprises,this paper proposed a method that migrated the relational database to NoSQL document database.It studied the set model transformation method in MongoDB for the relational model in RDBMS,and proposed a directed graph representation model that expressed the referential integrity of the relationship,and automatically transformed the MongoDB document model based on the relational data model.It realized the insertion algorithm that the RDBMS migrated data into MongoDB's.Aiming at the above scheme and algorithm,combined with the typical open source RDBMS-MySQL example,this paper validated the generation of directed graph model,the transformation algorithm based on directed graph model and the application of data migration algorithm.The experimental results show that the RDBMS can be smoothly migrated to MongoDB according to a certain data structure. |
| Author | 曾海峰 王淑营 董钦钰 |
| AuthorAffiliation | 西南交通大学信息科学与技术学院,成都610031 四川宁江山川机械有限责任公司,成都610106 |
| AuthorAffiliation_xml | – name: 西南交通大学信息科学与技术学院,成都,610031%四川宁江山川机械有限责任公司,成都,610106 |
| Author_FL | Zeng Haifeng Dong Qinyu Wang Shuying |
| Author_FL_xml | – sequence: 1 fullname: Zeng Haifeng – sequence: 2 fullname: Wang Shuying – sequence: 3 fullname: Dong Qinyu |
| Author_xml | – sequence: 1 fullname: 曾海峰 王淑营 董钦钰 |
| BookMark | eNo9j01Lw0AQQPdQwbb6J8SDl8adTLJJjrb1C1oF7T0k6aY26EYbRHL04EkqCtabtXpRQUQoiFLFP9Mm9V-4UvE08HjMzMuRjAgFJ2QeqIIWsxYDpRlFQgFKoYDM0hWVgqEAKBQhQ7L_fJrkoiigVFPBolmyMfzopYObrXKxuj06v_i-7o5O-ml_MOqeVkPRCMvFpPOStJ-Th1uJxp9PSftu-HY2geOv4_R-kFy9J_1O2rtMH19nyJTv7EZ89m_mSW1luVZaK1Q2V9dLS5WCx-QfPkda55wjMywNdZNyAO5zB4C5HFXuU3C5DsxCj9O6SU2DUcMz0dXR003XwzxZmKw9coTviIYdhIctIQ_aQRTEcRz8xgPIdKnOTVRvR_YcNKW832ruOa3YZgZqyDRdxR9LTHdX |
| ClassificationCodes | TP311.13 |
| ContentType | Journal Article |
| Copyright | Copyright © Wanfang Data Co. Ltd. All Rights Reserved. |
| Copyright_xml | – notice: Copyright © Wanfang Data Co. Ltd. All Rights Reserved. |
| DBID | 2RA 92L CQIGP W92 ~WA 2B. 4A8 92I 93N PSX TCJ |
| DOI | 10.3969/j.issn.1001-3695.2017.11.031 |
| DatabaseName | 中文科技期刊数据库 中文科技期刊数据库-CALIS站点 中文科技期刊数据库-7.0平台 中文科技期刊数据库-工程技术 中文科技期刊数据库- 镜像站点 Wanfang Data Journals - Hong Kong WANFANG Data Centre Wanfang Data Journals 万方数据期刊 - 香港版 China Online Journals (COJ) China Online Journals (COJ) |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science |
| DocumentTitleAlternate | Research on data conversion and migration method from traditional RDBMS to NoSQL database MongoDB |
| DocumentTitle_FL | Research on data conversion and migration method from traditional RDBMS to NoSQL database MongoDB |
| EndPage | 3344 |
| ExternalDocumentID | jsjyyyj201711031 673436452 |
| GrantInformation_xml | – fundername: 国家科技支撑计划资助项目 funderid: (2015BAF19F02,2015BAF19F01) |
| GroupedDBID | -0Y 2B. 2C0 2RA 5XA 5XJ 92H 92I 92L ACGFS ALMA_UNASSIGNED_HOLDINGS CCEZO CQIGP CUBFJ CW9 TCJ TGT U1G U5S W92 ~WA 4A8 93N ABJNI PSX |
| ID | FETCH-LOGICAL-c601-fe30deee367943580e11efea116be32ef01be51693ce0d8087607c83b53c58bc3 |
| ISSN | 1001-3695 |
| IngestDate | Thu May 29 03:54:51 EDT 2025 Wed Feb 14 09:55:52 EST 2024 |
| IsPeerReviewed | false |
| IsScholarly | true |
| Issue | 11 |
| Keywords | NoSQL RDBMS 模型转换 model conversion MongoDB 数据迁移 data migration directed graph of relations 关系有向图 |
| Language | Chinese |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-c601-fe30deee367943580e11efea116be32ef01be51693ce0d8087607c83b53c58bc3 |
| Notes | 51-1196/TP Zeng Haifeng1 , Wang Shuying1, Dong Qinyu2 （1. School of Information Science ＆ Technology, Southwest Jiaotong University, Chengdu 610031, China; 2. Sichuan Ningjiang Shanchuan Machinery Co. , Ltd. , Chengdu 610106, China） In order to solve the bottleneck problem encountered in the large data processing of relational database and satisfy the demand of large data processing for enterprises, this paper proposed a method that migrated the relational database to NoSQL document database. It studied the set model transformation method in MongoDB for the relational model in RDBMS, and proposed a directed graph representation model that expressed the referential integrity of the relationship, and automatically transformed the MongoDB document model based on the relational data model. It realized the insertion algorithm that the RDBMS migrated data into MongoDB＇ s. Aiming at the above scheme and algorithm, combined with the typical open source RD- BMS-MySQL example, this paper validated the generation of direc |
| PageCount | 6 |
| ParticipantIDs | wanfang_journals_jsjyyyj201711031 chongqing_primary_673436452 |
| PublicationCentury | 2000 |
| PublicationDate | 2017 |
| PublicationDateYYYYMMDD | 2017-01-01 |
| PublicationDate_xml | – year: 2017 text: 2017 |
| PublicationDecade | 2010 |
| PublicationTitle | 计算机应用研究 |
| PublicationTitleAlternate | Application Research of Computers |
| PublicationTitle_FL | Application Research of Computers |
| PublicationYear | 2017 |
| Publisher | 西南交通大学信息科学与技术学院,成都,610031%四川宁江山川机械有限责任公司,成都,610106 |
| Publisher_xml | – name: 西南交通大学信息科学与技术学院,成都,610031%四川宁江山川机械有限责任公司,成都,610106 |
| SSID | ssj0042190 ssib001102940 ssib002263599 ssib023646305 ssib051375744 ssib025702191 |
| Score | 2.0608108 |
| Snippet | ... TP311.13;... |
| SourceID | wanfang chongqing |
| SourceType | Aggregation Database Publisher |
| StartPage | 3339 |
| SubjectTerms | MongoDB NoSQL RDBMS 关系有向图 数据迁移 模型转换 |
| Title | 传统RDBMS向非关系型MongoDB数据模型转换与数据迁移方法研究 |
| URI | http://lib.cqvip.com/qk/93231X/201711/673436452.html https://d.wanfangdata.com.cn/periodical/jsjyyyj201711031 |
| Volume | 34 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwnR1NaxQxNJQWxIvfYq1KheZUtk4mk0xynOzOUoT2oBV6Wzqz2ZY9bNW2h_bmwZNUFKw3a_WigohQEKWKf6bdrXd_gO9l0u0opaiX8CZ5eXnzXublTT5eCBlTuYR-kKuKFTqvRDpUlTlto0rUFBqXxeJc4AHnqWk5eSe6OStmBwZ-lnYtrSxnE_nakedK_kerkAd6xVOy_6DZPlHIABj0CyloGNK_0jFNI2qqNAloGlNjqK7fqpmp2zQVVAdUM5pqqmtUp5ijBDXcIXLERZyUKgMf9fxiDZ4l1YARIKBqNEkRSBRNWB-VpooaKKoe4ISOAUVVelR1QK6Do4pNJo49xJHUaASACcDHImA0coCmRpZ9ZaQAdJKCQkp17ChUqUmQJUiLipACn0eTgq7kKhlqHI8G6sWuNgghGEdkVbyaxAIUmULZJWLcQYwm3EkxpIn0gAnKUyXFmVBv13HnGJfFfZ4Hht_PovoOzkpmnPMiwpJ3CTgvYlT-OdxwLbUbbrCNiX4buGEwnsDYsH6A-z2gt4x5hIu_4DgMhXHMxCAZSkzN1A_dWPD6ymENQ4wYdPjbiDH_ZclO40WEMPD07bRgPBbuVoPCI4mgsIjK4Rk8QcY89zeO4x3DjSxAJ7wHTpQ709ZpzXXmS-7XzBlyyv83jSbFR3CWDKwtnCOnD-4kGfVD1Hkyvft1q7fz0n0He0-e_nixufdwu7e9s7f5yPf07sbH7vqH7ttXkLX_7X13_fXu58dF5v73B703O93nX7rbG72tZ713ny6QmXo6U52s-DtDKrmEV2hZHjSttVxi4EOhAsuYbdk5xmRmeWhbAcssLg3z3AZNhfEYgzhXPBM8FyrL-UUy2Fns2EtktClaMspYM2rqMMpjqVtCZJHSNsx0bGUwTEb60mncLULDNPq6HSbXvbwa3mAsNdpL7dXV1TZKmOHtKpePpTBCTiJmMd13hQwu31-xV8EBXs6u-f7yCwUUjSM |
| linkProvider | EBSCOhost |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=%E4%BC%A0%E7%BB%9FRDBMS%E5%90%91%E9%9D%9E%E5%85%B3%E7%B3%BB%E5%9E%8BMongoDB%E6%95%B0%E6%8D%AE%E6%A8%A1%E5%9E%8B%E8%BD%AC%E6%8D%A2%E4%B8%8E%E6%95%B0%E6%8D%AE%E8%BF%81%E7%A7%BB%E6%96%B9%E6%B3%95%E7%A0%94%E7%A9%B6&rft.jtitle=%E8%AE%A1%E7%AE%97%E6%9C%BA%E5%BA%94%E7%94%A8%E7%A0%94%E7%A9%B6&rft.au=%E6%9B%BE%E6%B5%B7%E5%B3%B0+%E7%8E%8B%E6%B7%91%E8%90%A5+%E8%91%A3%E9%92%A6%E9%92%B0&rft.date=2017&rft.issn=1001-3695&rft.volume=34&rft.issue=11&rft.spage=3339&rft.epage=3344&rft_id=info:doi/10.3969%2Fj.issn.1001-3695.2017.11.031&rft.externalDocID=673436452 |
| thumbnail_s | http://utb.summon.serialssolutions.com/2.0.0/image/custom?url=http%3A%2F%2Fimage.cqvip.com%2Fvip1000%2Fqk%2F93231X%2F93231X.jpg http://utb.summon.serialssolutions.com/2.0.0/image/custom?url=http%3A%2F%2Fwww.wanfangdata.com.cn%2Fimages%2FPeriodicalImages%2Fjsjyyyj%2Fjsjyyyj.jpg |