A data interaction method and device

A data interaction and database technology, applied in the field of communication, can solve the problems of occupying RDBMS input/input resources and reducing RDBMS processing capacity, and achieve the effect of improving processing efficiency and resource utilization, reducing input/output operations, and ensuring business resources.

Active Publication Date: 2021-12-28
DATANG MOBILE COMM EQUIP CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present invention provide a data interaction method and device to solve the problem in the prior art that a large amount of input / input resources of the RDBMS are occupied during the data interaction process, resulting in a reduction in the processing capacity of the RDBMS

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A data interaction method and device
  • A data interaction method and device
  • A data interaction method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0070] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0071] refer to figure 2 , which shows a flow chart of a data interaction method according to an embodiment of the present invention, which may specifically include the following steps:

[0072] Step 201, if a data export instruction is received, search for a first internal file corresponding to a first external table in the relational database management system RDBMS in the target hard disk area by searching multiple mapping relationships recorded in the mapping list.

[0073] Specifically, in the embodiment of the present invention, the data exchange device receives an instruction, and the instruction includes a data export instruction and a data import instruction. The export means to export the data in the RDBMS to HDFS, and...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The embodiment of the present invention provides a data interaction method and device. The method includes: if a data export instruction is received, searching for the mapping relationship with the relational database management system RDBMS in the target hard disk area by retrieving multiple mapping relationships recorded in the mapping list. The first internal file corresponding to the first external table in ; export the first internal file to the distributed file system HDFS; if a data import instruction is received, then determine the target hard disk by retrieving multiple mapping relationships recorded in the mapping table Whether there is already a second internal file to be imported from HDFS in the area; if not, import the second internal file into the target hard disk area, and generate a second external table in the RDBMS; establish a second external table in the mapping list The mapping relationship between the table and the second internal file. The invention effectively reduces the input / output operation of the RDBMS on the disk where the database table is located, thereby effectively ensuring the original business resources of the RDBMS and improving the processing efficiency and resource utilization of the RDBMS.

Description

technical field [0001] The embodiments of the present invention relate to the communication field, and in particular, to a data interaction method and device. Background technique [0002] like figure 1 Shown is a schematic diagram of data interaction between RDBMS (Relational Database Management System, relational database management system) and HDFS (Hadoop Distributed File System, Hadoop distributed file system) in the prior art embodiment. [0003] Specifically, in the prior art embodiment, if the data in the RDBMS system needs to be exported to the HDFS system, it is necessary to access the RDBMS through third-party software or programming, thereby reading the database table from the hard disk area of ​​the database through the RDBMS, and then Export to HDFS. To import the data tables in HDFS into RDBMS, it is also necessary to write the database tables to the hard disk area of ​​the database through RDBMS. [0004] It can be seen that, in the prior art, any data imp...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/25G06F16/28G06F16/182
CPCG06F16/182G06F16/258G06F16/284
Inventor 陈怡赵晗
Owner DATANG MOBILE COMM EQUIP CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap