CN106126543B - 一种关系型数据库到MongoDB的模型转换和数据迁移方法 - Google Patents
一种关系型数据库到MongoDB的模型转换和数据迁移方法 Download PDFInfo
- Publication number
- CN106126543B CN106126543B CN201610424619.4A CN201610424619A CN106126543B CN 106126543 B CN106126543 B CN 106126543B CN 201610424619 A CN201610424619 A CN 201610424619A CN 106126543 B CN106126543 B CN 106126543B
- Authority
- CN
- China
- Prior art keywords
- model
- label
- mongodb
- relational database
- entity
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000006243 chemical reaction Methods 0.000 title claims abstract description 44
- 238000000034 method Methods 0.000 title claims abstract description 32
- 238000013508 migration Methods 0.000 title claims abstract description 31
- 230000005012 migration Effects 0.000 title claims abstract description 31
- 238000013499 data model Methods 0.000 claims abstract description 14
- 238000003780 insertion Methods 0.000 claims description 7
- 230000037431 insertion Effects 0.000 claims description 7
- 238000012986 modification Methods 0.000 claims description 7
- 230000004048 modification Effects 0.000 claims description 7
- 238000012217 deletion Methods 0.000 claims description 2
- 230000037430 deletion Effects 0.000 claims description 2
- 238000012163 sequencing technique Methods 0.000 claims description 2
- 239000000284 extract Substances 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 9
- 238000002474 experimental method Methods 0.000 description 5
- 230000009466 transformation Effects 0.000 description 4
- 125000002015 acyclic group Chemical group 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
- 238000000844 transformation Methods 0.000 description 1
- 238000011426 transformation method Methods 0.000 description 1
- 230000001131 transforming effect Effects 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
关系型数据库 | MongoDB |
表(Table) | 集合(Collection) |
行(Row) | 文档(Document) |
列(Column) | 域(Field) |
数据类型(Data type) | 数据类型(Data type) |
关系(Relationship) | 引用(Reference)或嵌套(Embedding) |
Claims (4)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610424619.4A CN106126543B (zh) | 2016-06-15 | 2016-06-15 | 一种关系型数据库到MongoDB的模型转换和数据迁移方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610424619.4A CN106126543B (zh) | 2016-06-15 | 2016-06-15 | 一种关系型数据库到MongoDB的模型转换和数据迁移方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106126543A CN106126543A (zh) | 2016-11-16 |
CN106126543B true CN106126543B (zh) | 2019-09-03 |
Family
ID=57469586
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610424619.4A Active CN106126543B (zh) | 2016-06-15 | 2016-06-15 | 一种关系型数据库到MongoDB的模型转换和数据迁移方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106126543B (zh) |
Families Citing this family (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106951442A (zh) * | 2017-02-15 | 2017-07-14 | 中国保险信息技术管理有限责任公司 | 一种异构数据库间的数据交互方法及装置 |
CN107145601B (zh) * | 2017-06-02 | 2020-08-14 | 北京数语科技有限公司 | 一种高效的引用关系发现方法 |
CN108153911B (zh) * | 2018-01-24 | 2022-07-19 | 广西师范学院 | 数据的分布式云存储方法 |
CN108681240B (zh) * | 2018-03-09 | 2021-04-02 | 南京航空航天大学 | 基于未知输入观测器的无人机分布式编队的故障诊断方法 |
CN108763432B (zh) * | 2018-05-24 | 2021-05-25 | 思派(北京)网络科技有限公司 | 一种应用于互联网医疗的跨平台数据整合方法 |
CN111352918B (zh) * | 2018-12-21 | 2023-05-23 | 卓望数码技术(深圳)有限公司 | 一种终端数据库数据迁移方法及系统 |
CN110147353B (zh) * | 2019-04-24 | 2022-04-26 | 深圳先进技术研究院 | 基于日志分析的MongoDB数据迁移监控方法及装置 |
CN110851425B (zh) * | 2019-11-18 | 2023-05-26 | 上海新炬网络技术有限公司 | 基于Mongify迁移Oracle数据至Mongo DB数据库的方法 |
CN112487196B (zh) * | 2020-06-29 | 2024-07-16 | 孙炜 | 一种训练关系抽取模型并抽取嵌套命名实体关系的方法 |
CN112035566B (zh) * | 2020-11-04 | 2021-02-23 | 长沙树根互联技术有限公司 | 数据调用方法、装置、电子设备和存储介质 |
CN112765197B (zh) * | 2020-12-30 | 2024-04-30 | 金蝶软件(中国)有限公司 | 数据查询方法、装置、计算机设备和存储介质 |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101093493A (zh) * | 2006-06-23 | 2007-12-26 | 国际商业机器公司 | 数据库查询语言转换方法、转换装置、数据库查询系统 |
CN103246749A (zh) * | 2013-05-24 | 2013-08-14 | 北京立新盈企信息技术有限公司 | 面向分布式计算的矩阵数据库系统及其查询方法 |
CN103810275A (zh) * | 2014-02-13 | 2014-05-21 | 清华大学 | 用于非关系与关系型数据库间数据交互的方法和装置 |
CN104794244A (zh) * | 2015-05-13 | 2015-07-22 | 南京大学 | 一种基于MongoDB实现图转换的方法和装置 |
US9348880B1 (en) * | 2015-04-01 | 2016-05-24 | Palantir Technologies, Inc. | Federated search of multiple sources with conflict resolution |
-
2016
- 2016-06-15 CN CN201610424619.4A patent/CN106126543B/zh active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101093493A (zh) * | 2006-06-23 | 2007-12-26 | 国际商业机器公司 | 数据库查询语言转换方法、转换装置、数据库查询系统 |
CN103246749A (zh) * | 2013-05-24 | 2013-08-14 | 北京立新盈企信息技术有限公司 | 面向分布式计算的矩阵数据库系统及其查询方法 |
CN103810275A (zh) * | 2014-02-13 | 2014-05-21 | 清华大学 | 用于非关系与关系型数据库间数据交互的方法和装置 |
US9348880B1 (en) * | 2015-04-01 | 2016-05-24 | Palantir Technologies, Inc. | Federated search of multiple sources with conflict resolution |
CN104794244A (zh) * | 2015-05-13 | 2015-07-22 | 南京大学 | 一种基于MongoDB实现图转换的方法和装置 |
Also Published As
Publication number | Publication date |
---|---|
CN106126543A (zh) | 2016-11-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106126543B (zh) | 一种关系型数据库到MongoDB的模型转换和数据迁移方法 | |
CN104881424B (zh) | 一种基于正则表达式的电力大数据采集、存储及分析方法 | |
CN105574093B (zh) | 一种在基于HDFS的spark-sql大数据处理系统上建立索引的方法 | |
CN101127034B (zh) | 数据组织、查询、呈现、存档、恢复、删除、提炼方法及装置和系统 | |
Kenig et al. | MFIBlocks: An effective blocking algorithm for entity resolution | |
CN103631842B (zh) | 用于检测多列复合键列集合的方法和系统 | |
US20160055233A1 (en) | Pre-join tags for entity-relationship modeling of databases | |
US7487174B2 (en) | Method for storing text annotations with associated type information in a structured data store | |
KR101617696B1 (ko) | 데이터 정규표현식의 마이닝 방법 및 장치 | |
JP5959592B2 (ja) | データベース管理方法、プログラム及び該管理システム、並びにデータベースのツリー構造 | |
CN108681603B (zh) | 数据库中快速搜索树形结构数据的方法、存储介质 | |
Yafooz et al. | Managing unstructured data in relational databases | |
CN107958023A (zh) | 数据同步方法、数据同步装置和计算机可读存储介质 | |
Fu et al. | Automatic cleaning and linking of historical census data using household information | |
CN103440265A (zh) | 基于MapReduce的MYSQL数据库的变化数据捕获方法 | |
KR102345410B1 (ko) | 빅데이터 지능형 수집 방법 및 장치 | |
AL-Msie'deen et al. | Detecting commonality and variability in use-case diagram variants | |
JPWO2013111287A1 (ja) | Sparqlクエリ最適化方法 | |
Chu et al. | Automatic data extraction of websites using data path matching and alignment | |
US11520763B2 (en) | Automated optimization for in-memory data structures of column store databases | |
Manghi et al. | De-duplication of aggregation authority files | |
CN110489448A (zh) | 基于Hadoop的大数据关联规则的挖掘方法 | |
Isa et al. | Business Intelligence for Analyzing Department Unit Performance in eProcurement System | |
KR101679011B1 (ko) | 데이터베이스에서 데이터 이동을 처리하는 방법 및 장치 | |
Khurana | An introduction to temporal graph data management |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP03 | Change of name, title or address | ||
CP03 | Change of name, title or address |
Address after: 100084 Tsinghua University, Beijing, Haidian District Co-patentee after: Beijing August melon Intellectual Property Agency Co., Ltd. Patentee after: Tsinghua University Address before: 100083 Tsinghua University, Beijing, Haidian District Co-patentee before: BEIJING HENGGUAN NETWORK DATA TREATMENT CO., LTD. Patentee before: Tsinghua University |
|
CI03 | Correction of invention patent | ||
CI03 | Correction of invention patent |
Correction item: Patentee|Address|Patentee Correct: Tsinghua University|100083 Tsinghua University, Beijing, Haidian District|BEIJING HENGGUAN NETWORK DATA TREATMENT CO., LTD. False: Tsinghua University|100084 Tsinghua University, Beijing, Haidian District|Beijing August melon Intellectual Property Agency Co., Ltd. Number: 47-02 Volume: 35 |
|
CP01 | Change in the name or title of a patent holder | ||
CP01 | Change in the name or title of a patent holder |
Address after: 100084 Tsinghua University, Beijing, Haidian District Co-patentee after: Beijing August melon Technology Co., Ltd Patentee after: Tsinghua University Address before: 100084 Tsinghua University, Beijing, Haidian District Co-patentee before: BEIJING HENGGUAN NETWORK DATA TREATMENT CO., LTD. Patentee before: Tsinghua University |