CN106528786B - 快速迁移多源异构电网大数据到HBase的方法及系统 - Google Patents
快速迁移多源异构电网大数据到HBase的方法及系统 Download PDFInfo
- Publication number
- CN106528786B CN106528786B CN201610982635.5A CN201610982635A CN106528786B CN 106528786 B CN106528786 B CN 106528786B CN 201610982635 A CN201610982635 A CN 201610982635A CN 106528786 B CN106528786 B CN 106528786B
- Authority
- CN
- China
- Prior art keywords
- data
- data class
- mapping table
- class
- hbase
- 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
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000013507 mapping Methods 0.000 claims abstract description 142
- 238000003491 array Methods 0.000 claims abstract description 31
- 238000007906 compression Methods 0.000 claims abstract description 18
- 230000006835 compression Effects 0.000 claims abstract description 17
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 230000005540 biological transmission Effects 0.000 description 14
- 230000005012 migration Effects 0.000 description 14
- 238000013508 migration Methods 0.000 description 14
- 238000010276 construction Methods 0.000 description 5
- 238000012544 monitoring process Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 230000008676 import Effects 0.000 description 4
- 230000008901 benefit Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 3
- 230000001131 transforming effect Effects 0.000 description 3
- 238000013499 data model Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013144 data compression Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000010304 firing Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
- 230000006641 stabilisation Effects 0.000 description 1
- 238000011105 stabilization Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000009466 transformation 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/221—Column-oriented storage; Management thereof
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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)
- Computing Systems (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610982635.5A CN106528786B (zh) | 2016-11-08 | 2016-11-08 | 快速迁移多源异构电网大数据到HBase的方法及系统 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610982635.5A CN106528786B (zh) | 2016-11-08 | 2016-11-08 | 快速迁移多源异构电网大数据到HBase的方法及系统 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106528786A CN106528786A (zh) | 2017-03-22 |
CN106528786B true CN106528786B (zh) | 2019-07-12 |
Family
ID=58350965
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610982635.5A Active CN106528786B (zh) | 2016-11-08 | 2016-11-08 | 快速迁移多源异构电网大数据到HBase的方法及系统 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106528786B (zh) |
Families Citing this family (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107220332A (zh) * | 2017-05-24 | 2017-09-29 | 深圳怡化电脑股份有限公司 | 一种数据管理的方法及装置 |
CN107341198B (zh) * | 2017-06-16 | 2020-05-12 | 云南电网有限责任公司信息中心 | 一种基于主题实例的电力海量数据存储和查询方法 |
CN107832389B (zh) * | 2017-10-31 | 2020-12-25 | 新华三大数据技术有限公司 | 数据管理方法及装置 |
CN108959369B (zh) * | 2018-05-22 | 2021-11-30 | 国网浙江省电力有限公司电力科学研究院 | 一种海量数据平台与大数据平台融合方法 |
CN109299068A (zh) * | 2018-08-31 | 2019-02-01 | 安徽四创电子股份有限公司 | 从关系型数据库到HBase数据库的数据流迁移方法 |
CN109753812A (zh) * | 2019-01-07 | 2019-05-14 | 今天誉讯(北京)科技有限公司 | 多维异构大数据关系识别认证方法与系统 |
CN110489475B (zh) * | 2019-08-14 | 2021-01-26 | 广东电网有限责任公司 | 一种多源异构数据处理方法、系统及相关装置 |
CN111125070A (zh) * | 2019-11-19 | 2020-05-08 | 华迪计算机集团有限公司 | 一种数据交换方法及平台 |
CN112035432B (zh) * | 2020-07-22 | 2024-02-23 | 大箴(杭州)科技有限公司 | 数据的置换迁移方法、装置计算机设备 |
CN114024833B (zh) * | 2022-01-06 | 2022-04-01 | 深圳市聚能优电科技有限公司 | Ems的后端服务器切换方法、系统、设备及存储介质 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103116610A (zh) * | 2013-01-23 | 2013-05-22 | 浙江大学 | 基于HBase的矢量空间大数据存储方法 |
CN103631907A (zh) * | 2013-11-26 | 2014-03-12 | 中国科学院信息工程研究所 | 一种将关系型数据迁移至HBase的方法及系统 |
CN104915450A (zh) * | 2015-07-01 | 2015-09-16 | 武汉大学 | 一种基于HBase的大数据存储与检索方法及系统 |
CN104951462A (zh) * | 2014-03-27 | 2015-09-30 | 国际商业机器公司 | 用于管理数据库的方法和系统 |
-
2016
- 2016-11-08 CN CN201610982635.5A patent/CN106528786B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103116610A (zh) * | 2013-01-23 | 2013-05-22 | 浙江大学 | 基于HBase的矢量空间大数据存储方法 |
CN103631907A (zh) * | 2013-11-26 | 2014-03-12 | 中国科学院信息工程研究所 | 一种将关系型数据迁移至HBase的方法及系统 |
CN104951462A (zh) * | 2014-03-27 | 2015-09-30 | 国际商业机器公司 | 用于管理数据库的方法和系统 |
CN104915450A (zh) * | 2015-07-01 | 2015-09-16 | 武汉大学 | 一种基于HBase的大数据存储与检索方法及系统 |
Non-Patent Citations (2)
Title |
---|
SQL Server数据库到HBase数据库的模式转换和数据迁移研究;张华东 等;《智能计算机与应用》;20161031;第6卷(第5期);第24-30页 |
基于融合数据库的海量传感器信息存储架构;类兴邦 等;《计算机科学》;20160630;第43卷(第6期);第68-71页 |
Also Published As
Publication number | Publication date |
---|---|
CN106528786A (zh) | 2017-03-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106528786B (zh) | 快速迁移多源异构电网大数据到HBase的方法及系统 | |
CN108009979B (zh) | 基于时空数据融合的三维点云压缩存储方法及系统 | |
CN103631907B (zh) | 一种将关系型数据迁移至HBase的方法及系统 | |
CN103294710B (zh) | 一种数据存取方法和装置 | |
CN104462141B (zh) | 一种数据存储与查询的方法、系统及存储引擎装置 | |
CN105184482B (zh) | 一种变压器台账数据校验系统及其方法 | |
CN109213820B (zh) | 一种实现多种类型的数据库融合使用的方法 | |
CN104113390A (zh) | 一种移动网络数据序列化方法 | |
CN104504030B (zh) | 一种面向电力调度自动化海量报文的索引方法 | |
CN103853714A (zh) | 一种数据处理方法和装置 | |
CN104378117A (zh) | 数据压缩方法及装置、数据传输方法及系统 | |
CN105843955A (zh) | 一种数据迁移系统 | |
CN106547911A (zh) | 一种海量小文件的存取方法和系统 | |
CN109325089A (zh) | 一种非定点对象查询方法、装置、终端设备及存储介质 | |
CN103209119A (zh) | 一种低功耗嵌入式云智能网关 | |
US9602129B2 (en) | Compactly storing geodetic points | |
CN102567419B (zh) | 基于树结构的海量数据存储装置及方法 | |
CN112905642B (zh) | 基于csv映射文件将iec61850报告数据存入关系数据库的方法 | |
CN105279123A (zh) | 双冗余1553b总线的串口转换结构及转换方法 | |
CN103441988A (zh) | 跨gis平台数据迁移方法 | |
CN116628285B (zh) | 区块链交易数据查询方法及装置 | |
CN105468712A (zh) | 一种数据存储兼容方法 | |
CN101877005B (zh) | 一种基于文档模式的gml压缩方法 | |
WO2024082518A1 (zh) | 一种用于数字钢卷系统的数据存储方法及装置 | |
CN105631000B (zh) | 基于移动终端位置特征信息的终端缓存的数据压缩方法 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
CB03 | Change of inventor or designer information | ||
CB03 | Change of inventor or designer information |
Inventor after: Lin Ying Inventor after: Wu Guanbin Inventor after: Yang Dai Inventor after: Zhu Chengkai Inventor after: Liu Bin Inventor after: Wang Chang Inventor after: Ma Yan Inventor after: Li Chengqi Inventor after: Geng Yujie Inventor after: Bai Demeng Inventor after: Shi Xin Inventor after: Niu Jincang Inventor after: Su Jianjun Inventor after: Li Dong Inventor after: Guo Zhihong Inventor after: Chen Yufeng Inventor after: Zhu Yongxin Inventor after: Sheng Gehao Inventor after: Li Yong Inventor before: Lin Ying Inventor before: Wu Guanbin Inventor before: Yang Dai Inventor before: Zhu Chengkai Inventor before: Liu Bin Inventor before: Wang Chang Inventor before: Ma Yan Inventor before: Li Chengqi Inventor before: Geng Yujie Inventor before: Bai Demeng Inventor before: Shi Xin Inventor before: Zhang Fangzheng Inventor before: Zhang Lei Inventor before: Su Jianjun Inventor before: Li Dong Inventor before: Guo Zhihong Inventor before: Chen Yufeng Inventor before: Zhu Yongxin Inventor before: Sheng Gehao Inventor before: Li Yong |
|
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |