CN115544167A - Data transmission method, device, equipment and medium - Google Patents

Data transmission method, device, equipment and medium Download PDF

Info

Publication number
CN115544167A
CN115544167A CN202211265195.3A CN202211265195A CN115544167A CN 115544167 A CN115544167 A CN 115544167A CN 202211265195 A CN202211265195 A CN 202211265195A CN 115544167 A CN115544167 A CN 115544167A
Authority
CN
China
Prior art keywords
data
cloud platform
target cloud
temporary table
information
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.)
Pending
Application number
CN202211265195.3A
Other languages
Chinese (zh)
Inventor
吴海钢
蒋慧
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Industrial and Commercial Bank of China Ltd ICBC
Original Assignee
Industrial and Commercial Bank of China Ltd ICBC
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Industrial and Commercial Bank of China Ltd ICBC filed Critical Industrial and Commercial Bank of China Ltd ICBC
Priority to CN202211265195.3A priority Critical patent/CN115544167A/en
Publication of CN115544167A publication Critical patent/CN115544167A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Computing Systems (AREA)
  • Economics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application provides a data transmission method, a device, equipment and a medium, which relate to the technical field of big data, and the method comprises the following steps: acquiring configuration information from a database in a first target cloud platform, and establishing a first temporary table on a second target cloud platform according to the configuration information; the configuration information represents attribute information of a data table in a database; determining a second temporary table on a second target cloud platform according to the first temporary table; the second temporary table is obtained by writing original data information in the second target cloud platform into the first temporary table; and transferring the second temporary table to the first target cloud platform. By adopting the technical scheme, the data sharing from the head office big data platform to the branch local application system can be efficiently and conveniently realized, and the data fusion of special data in the branch local application system and the head office big data platform can be met.

Description

Data transmission method, device, equipment and medium
Technical Field
The present application relates to the field of big data technologies, and in particular, to a data transfer method, apparatus, device, and medium.
Background
With the advent and development of digital economy, banks as a financial technology industry have accumulated a large amount of user data, transaction data, and external data in the process of providing financial services. The huge data scale and the abundant data types enable bank data to have great value, in order to fully exert the value of the data, each bank establishes a big data platform, data of each application system in the bank is pasted to the source and enters the lake, and the unification and sharing of all basic data are realized.
At present, the construction of a bank big data platform is generally carried out by leading and managing by a head office organization. Data is a high-value and high-sensitive asset, sharing and use of the data are strictly controlled, so that even each branch in a bank cannot be entitled to directly use the data in the data lake. In the flow, the branch lines need to apply and give rights to multiple layers of data authorities to convey data to a branch line local system for secondary processing and use, and a large amount of time cost and technical cost need to be paid by the branch lines, so that the branch lines are more prone to acquiring the data by directly applying for a file to be transmitted back to an upstream application system. Therefore, in order to better promote the data sharing service of the bank big data platform and perfect the function of the bank big data platform, the advantages and the value of the big data platform are fully exerted.
Therefore, a data transmission method is urgently needed, which can efficiently and conveniently realize data sharing from the head office big data platform to the branch office local application system, and can meet the requirement of data fusion between special data in the branch office local application system and the head office big data platform.
Disclosure of Invention
The application provides a data transmission method, a data transmission device, data transmission equipment and a data transmission medium, which can efficiently and conveniently realize data sharing from a head office big data platform to a branch office local application system, and can meet the requirement of data fusion of special data in the branch office local application system and the head office big data platform.
In a first aspect, the present application provides a data transfer method, including:
acquiring configuration information from a database in a first target cloud platform, and establishing a first temporary table on a second target cloud platform according to the configuration information; the configuration information represents attribute information of a data table in a database;
determining a second temporary table on the second target cloud platform according to the first temporary table; the second temporary table is obtained by writing original data information in the second target cloud platform into the first temporary table;
transferring the second temporary table to the first target cloud platform.
In one example, said communicating said second temporary table to said first target cloud platform comprises:
acquiring the second temporary table from the second target cloud platform;
receiving a data request message of the first target cloud platform;
and transmitting the second temporary table to the first target cloud platform according to the data request message.
In one example, after the transferring the second temporary table to the first target cloud platform according to the data request message, further includes:
acquiring a first data table from the first target cloud platform; the first data table is obtained by updating the second temporary table on the first target cloud platform through the first target cloud platform;
establishing a second data table on the second target cloud platform according to the configuration information;
and updating the data information in the second data table according to the data information in the first data table.
In one example, the establishing a second data table on the second target cloud platform according to the configuration information includes:
acquiring data table field information in the configuration information;
and establishing a second data table on the second target cloud platform according to the data table field information.
In one example, the second data table supports calls by the first local data system.
In one example, the method further comprises:
the data information of the database in the first target cloud platform is acquired from a second local data system; the database in the first target cloud platform and the second local data system have a mapping relation; wherein the number of the second local data systems is at least one.
In one example, the first target cloud platform and the second target cloud platform collectively comprise a data cloud platform.
In a second aspect, the present application provides a data transfer device, the device comprising:
the system comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for acquiring configuration information from a database in a first target cloud platform and establishing a first temporary table on a second target cloud platform according to the configuration information; the configuration information represents attribute information of a data table in a database;
a writing unit, configured to determine a second temporary table on the second target cloud platform according to the first temporary table; the second temporary table is obtained by writing original data information in the second target cloud platform into the first temporary table;
a transferring unit, configured to transfer the second temporary table to the first target cloud platform.
In one example, a transfer unit, comprising:
the acquisition module is used for acquiring the second temporary table from the second target cloud platform;
the receiving module is used for receiving a data request message of the first target cloud platform;
and the transmitting module is used for transmitting the second temporary table to the first target cloud platform according to the data request message.
In one example, the apparatus further comprises:
the second acquisition unit is used for acquiring a first data table from the first target cloud platform; the first data table is obtained by updating the second temporary table on the first target cloud platform through the first target cloud platform;
the establishing unit is used for establishing a second data table on the second target cloud platform according to the configuration information;
and the updating unit is used for updating the data information in the second data table according to the data information in the first data table.
In one example, a setup unit includes:
the acquisition module is used for acquiring the data table field information in the configuration information;
and the establishing module is used for establishing a second data table on the second target cloud platform according to the data table field information.
In one example, the second data table supports calls by the first local data system.
In one example, the apparatus further comprises: the data information of the database in the first target cloud platform is acquired from a second local data system; the database in the first target cloud platform and the second local data system have a mapping relation; wherein the number of the second local data systems is at least one.
In one example, the first target cloud platform and the second target cloud platform collectively comprise a data cloud platform.
In a third aspect, the present application provides an electronic device, comprising: a processor, and a memory communicatively coupled to the processor;
the memory stores computer-executable instructions;
the processor executes computer-executable instructions stored by the memory to implement the method of the first aspect.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon computer-executable instructions for implementing the method according to the first aspect when executed by a processor.
In a fifth aspect, the present application provides a computer program product comprising a computer program which, when executed by a processor, implements the method according to the first aspect.
According to the data transmission method, the data transmission device, the data transmission equipment and the data transmission medium, configuration information is obtained from a database in a first target cloud platform, and a first temporary table is established on a second target cloud platform according to the configuration information; the configuration information represents attribute information of a data table in a database; determining a second temporary table at the second target cloud platform according to the first temporary table; the second temporary table is obtained by writing original data information in the second target cloud platform into the first temporary table; transferring the second temporary table to the first target cloud platform. The first target cloud platform is a branch cloud platform, each branch cloud platform can be used as a cloud end for storing a branch local application system, and the second target cloud platform can be a big data platform of a head office application system and used for storing a database of the head office application system. By adopting the technical scheme, the data sharing from the head office big data platform to the branch local application system can be efficiently and conveniently realized, and the data fusion of the special data in the branch local application system and the head office big data platform can be met.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application.
Fig. 1 is a schematic flowchart of a data transmission method according to an embodiment of the present application;
fig. 2 is a schematic flowchart of a data transmission method according to a second embodiment of the present application;
FIG. 3 is an interaction diagram of data transfer according to the second embodiment of the present application;
fig. 4 is a schematic diagram of a data transmission apparatus according to a third embodiment of the present application;
fig. 5 is a schematic diagram of a data transfer device according to a fourth embodiment of the present application;
FIG. 6 is a block diagram illustrating an electronic device in accordance with an example embodiment.
With the above figures, there are shown specific embodiments of the present application, which will be described in more detail below. These drawings and written description are not intended to limit the scope of the inventive concepts in any manner, but rather to illustrate the inventive concepts to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.
The data transmission method provided by the application aims to solve the technical problems in the prior art.
The following describes the technical solution of the present application and how to solve the above technical problems in detail by specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
At present, the problem of data sharing from a bank data cloud platform to branch organizations such as branch local application systems is solved, and data interconnection and intercommunication among heterogeneous clusters are generally realized through a data synchronization technology. The method comprises the steps that a client is installed on one server, wherein the client is used for analyzing rule information of migration data, a local application system in a branch line submits the migration data to a migration scheduling server through the client, the migration scheduling server obtains the migration data and then puts the migration data into a queue, the migration data are distributed, then filtering conditions are pushed to a source cluster where the migration data are located to be fetched, and finally the data are transported to a target cluster.
However, the target cluster is generally a tenant space allocated to the local branch application system by the cluster of the head office application system on the data cloud platform, and the data is not in the database of the local branch application system.
Although the above solution can implement relocation of required data from the data cloud platform to the designated cluster, as described in the above solution, the cluster is generally a tenant space allocated to the local application systems of the branches by the cluster where the head office application system is located on the data cloud platform. Therefore, at this time, the data is still migrated in the cluster provided by the head office application system, the local branch application system can only perform data processing in the tenant space, and if the local branch application system has a demand for using the data in the local application system, the data needs to be exported to the local branch application system, so that the subsequent docking operation between the application system and the migrated data can be performed.
In addition, the branch local application system has more and more data scenes to use a data analysis tool provided by the head office application system to perform data processing work, and the back of the branch local application system needs to interface with branch tenants in the scheme. If the characteristic data of the local application system of the branch department needs to be processed by the head office tool, the local application system of the branch department is required to export the data of the local system, and the data is uploaded to the tenants of the data cloud platform of the head office application system through the interconnection tool.
Therefore, the two data relocation synchronization scenes have complicated steps and high technical cost, so that the technical cost of the local application system of the branch is high, and the data timeliness is poor.
Fig. 1 is a schematic flowchart of a data transmission method according to an embodiment of the present application. The first embodiment comprises the following steps:
s101, acquiring configuration information from a database in a first target cloud platform, and establishing a first temporary table on a second target cloud platform according to the configuration information; the configuration information characterizes attribute information of data tables in the database.
In one example, the first target cloud platform is a cloud platform that can host a Mysql database, and the number of first target cloud platforms may be more than one. In this embodiment, the first target cloud platform may be a branch cloud platform, and each branch cloud platform may serve as a cloud for storing a branch local application system.
The configuration information is a configuration file of a data table in a database in the first target cloud platform, where the configuration information may include a database name of the source database, a table name of the data table in the source database, a database name of the target database, a table name of the data table in the target database, and the like.
In this embodiment, the second target cloud platform is a computing platform carrying a Hadoop cluster, and may store and analyze the data table on the second target cloud platform. The Hadoop cluster can fully utilize the cluster to carry out high-speed operation and storage. Further, the second target cloud platform may be a big data platform of a head office.
In this embodiment, the execution agent is a synchronization tool in the server, and the tool is a plug-in for storing and executing the move script, and receiving the imported and exported data and the like. Further, the synchronization tool can invoke the data tables in the first target cloud platform and the second target cloud platform. The second target cloud platform comprises a source cluster and a plurality of target clusters, a first temporary table is established from a determined part of target clusters, and original data information in the second target cloud platform is stored in the source cluster. Further, if the name of the original data table in the original data information is a, the name of the first temporary table established in the target cluster may be an a-TMP table. The original data table and the first temporary table are in one-to-one correspondence.
S102, determining a second temporary table on a second target cloud platform according to the first temporary table; and the second temporary table is obtained by writing the original data information in the second target cloud platform into the first temporary table.
In one example, on a second target cloud platform, according to a data interaction relationship and a mapping relationship between a source cluster and a target cluster, original data information in the source cluster is written into a first temporary table in the target cluster, so as to obtain a second temporary table filled with data information. Further, if the name of the first temporary table is an a-TMP table, the name of the second temporary table may be an a-TMP-1 table, and specifically, the original data information in the source cluster may be written into the first temporary table a-TMP table to obtain the second temporary table a-TMP-1 table.
S103, transmitting the second temporary table to the first target cloud platform.
In this embodiment, the second temporary table is transferred to the first target cloud platform by the synchronization tool, and is stored on the first target cloud platform in the same naming manner. For example, the name of the second temporary table in the second target cloud platform is a-TMP-1 table, and the name of the second temporary table after being transferred to the first target cloud platform is also a-TMP-1 table.
According to the data transmission method, the data transmission device, the data transmission equipment and the data transmission medium, configuration information is obtained from a database in a first target cloud platform, and a first temporary table is established on a second target cloud platform according to the configuration information; the configuration information represents attribute information of a data table in a database; determining a second temporary table on a second target cloud platform according to the first temporary table; the second temporary table is obtained by writing original data information in the second target cloud platform into the first temporary table; and transferring the second temporary table to the first target cloud platform. By adopting the technical scheme, the data sharing from the head office big data platform to the branch local application system can be efficiently and conveniently realized, and the data fusion of the special data in the branch local application system and the head office big data platform can be met.
Fig. 2 is a schematic flowchart of a data transfer method according to a second embodiment of the present application. The second embodiment comprises the following steps:
s201, obtaining configuration information from a database in a first target cloud platform, and establishing a first temporary table on a second target cloud platform according to the configuration information; the configuration information characterizes attribute information of data tables in the database.
In one example, data information of a database in a first target cloud platform is acquired from a second local data system; the database in the first target cloud platform and the second local data system have a mapping relation; wherein the number of the second local data systems is at least one. In this embodiment, the second local data system may be a branch local application system, different branch application systems have different databases in the first target cloud platform, and the first target cloud platform migrates the database on the second local data system.
In one example, the first target cloud platform and the second target cloud platform collectively comprise a data cloud platform.
In this embodiment, the first target cloud platform and the second target cloud platform both belong to data cloud platforms, and thus the configuration has the advantages that the database of the head office application system and the database of the branch local application system are on the same data cloud platform, so that the database of the head office application system and the database of the branch local application system can be fused, different branch local databases can be accessed with each other, and the branch local application systems can quickly access the database of the head office application system due to being on the same data cloud platform.
S202, according to the first temporary table, determining a second temporary table on a second target cloud platform; and the second temporary table is obtained by writing the original data information in the second target cloud platform into the first temporary table.
For example, this step may refer to step S102 described above, and is not described again.
S203, acquiring a second temporary table from the second target cloud platform.
In this embodiment, the second temporary table is acquired from the second target cloud platform through a command message hadoops fs-get in the server, and then is stored in the server.
S204, receiving a data request message of the first target cloud platform.
In this embodiment, the first target cloud platform sends a data request message to the server at regular time, so as to obtain the second temporary table from the server. Wherein the timed time may be 24 hours.
S205, transmitting the second temporary table to the first target cloud platform according to the data request message.
In this embodiment, the second temporary table is loaded into the first target cloud platform through the plug-in tool mysqlimport client in the first target cloud platform. Specifically, the command message mysqlimport-P-h-u may be used.
S206, acquiring a first data table from the first target cloud platform; and updating the second temporary table on the first target cloud platform by the first target cloud platform to obtain the first data table.
In this embodiment, the second temporary table and the data in the first target cloud platform are merged on the first target cloud platform to obtain the first data table. The data information in the first data table may be newly added to the data information in the second temporary table, or the data information in the second temporary table may be updated. Further, if the name of the second temporary table is an A-TMP-1 table, the name of the first data table may be an A-NEW table. Specifically, the command to obtain the first data table from the first target cloud platform may be Mysql-u-h-p-e "select from Mysql table" > data file.
And S207, establishing a second data table on the second target cloud platform according to the configuration information.
In this embodiment, the data information in the second data table is the same as the data information in the first data table, and the name of the second data table is the same as the name of the first data table, except that the second data table is stored in the second target cloud platform.
In one example, establishing a second data table on a second target cloud platform according to the configuration information includes:
acquiring data table field information in the configuration information; and establishing a second data table on the second target cloud platform according to the field information of the data table.
In this embodiment, field information of the first data table in the configuration information is acquired, and a second data table is established on the second target cloud platform according to the field information. Specifically, a second data table is established in a target cluster of a second target cloud platform, wherein a command for establishing the second data table is baseline-e "create table a _ NEW", and further the second data table is a hive table.
And S208, updating the data information in the second data table according to the data information in the first data table.
In this embodiment, the data information in the first data table is data information obtained by merging the data information in the local application system in the branch line and the application system in the head line, and the data information in the first data table is filled into the second data table according to the data information in the first data table, so that the data information in the second data table is updated. Specifically, the command message may be hadoop fs-moveFromLocal and bean-e "load data in path.
In one example, the second data table supports calls by the first local data system.
In one example, the first local data system is a head office application system, and the head office application system can call the second data table from the second target cloud platform, since the data information in the second data table is the fusion of the data information in the branch local application system and the data information in the head office application system. Therefore, the first local data system can simultaneously use the data information in the branch local application system and the data information in the head office application system.
In this embodiment, to better explain the data transfer process, refer to an interaction diagram of data transfer shown in fig. 3. As can be seen from fig. 3, the data cloud platform includes a second target cloud platform, a server, and a first target cloud platform. The second target cloud platform comprises a source cluster and a target cluster, original data information is stored in the source cluster, and a first temporary table, a second temporary table and a second data table are stored in the target cluster. The server comprises configuration information called from a database of the first target cloud platform and a synchronization tool in the server. The first target cloud platform comprises a database, wherein the database comprises a second temporary table and a first data table, and the second local data system can call the first data table in the database.
According to the data transmission method, configuration information is obtained from a database in a first target cloud platform, and a first temporary table is established on a second target cloud platform according to the configuration information; the configuration information represents attribute information of data tables in a database, a second temporary table is determined on a second target cloud platform according to a first temporary table, the second temporary table is obtained from the second target cloud platform, a data request message of the first target cloud platform is received, the second temporary table is transmitted to the first target cloud platform according to the data request message, the first data table is obtained from the first target cloud platform, a second data table is established on the second target cloud platform according to the configuration information, and data information in the second data table is updated according to the data information in the first data table. By adopting the technical scheme, the problems of complexity and low efficiency when the data of the local application systems of the branch lines and the data of the local application systems of the branch lines are synchronized are solved, the data of the local application systems of the branch lines and the data of the local application systems of the branch lines can be stored in the data cloud platform, and the unified management of the data of the local application systems of the branch lines and the data of the local application systems of the branch lines is facilitated.
Fig. 4 is a schematic diagram of a data transmission apparatus according to a third embodiment of the present application. The apparatus 40 in the third embodiment includes:
a first obtaining unit 401, configured to obtain configuration information from a database in a first target cloud platform, and establish a first temporary table on a second target cloud platform according to the configuration information; the configuration information characterizes attribute information of data tables in the database.
A writing unit 402, configured to determine a second temporary table on a second target cloud platform according to the first temporary table; and the second temporary table is obtained by writing the original data information in the second target cloud platform into the first temporary table.
A transferring unit 403, configured to transfer the second temporary table to the first target cloud platform.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the above-described apparatus may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.
Fig. 5 is a schematic diagram of a data transmission apparatus according to a fourth embodiment of the present application. The apparatus 50 according to the fourth embodiment includes:
a first obtaining unit 501, configured to obtain configuration information from a database in a first target cloud platform, and establish a first temporary table on a second target cloud platform according to the configuration information; the configuration information characterizes attribute information of data tables in the database.
A writing unit 502, configured to determine a second temporary table on the second target cloud platform according to the first temporary table; and the second temporary table is obtained by writing the original data information in the second target cloud platform into the first temporary table.
A transferring unit 503, configured to transfer the second temporary table to the first target cloud platform.
In one example, the transferring unit 503 includes:
an obtaining module 5031, configured to obtain the second temporary table from the second target cloud platform.
The receiving module 5032 is configured to receive a data request message of the first target cloud platform.
A delivering module 5033, configured to deliver the second temporary table to the first target cloud platform according to the data request message.
In one example, the apparatus further comprises:
a second obtaining unit 504, configured to obtain a first data table from the first target cloud platform; and updating the second temporary table on the first target cloud platform by the first target cloud platform to obtain the first data table.
An establishing unit 505 is configured to establish a second data table on the second target cloud platform according to the configuration information.
An updating unit 506, configured to update the data information in the second data table according to the data information in the first data table.
In one example, the establishing unit 505 includes:
an obtaining module 5051 is configured to obtain the data table field information in the configuration information.
The establishing module 5052 is configured to establish a second data table on the second target cloud platform according to the data table field information.
In one example, the second data table supports calls by the first local data system.
In one example, the apparatus further comprises: the data information of the database in the first target cloud platform is acquired from the second local data system; the database in the first target cloud platform and the second local data system have a mapping relation; wherein the number of the second local data systems is at least one.
In one example, the first target cloud platform and the second target cloud platform collectively comprise a data cloud platform.
It can be clearly understood by those skilled in the art that, for convenience and simplicity of description, the specific working process of the above-described device may refer to the corresponding process in the foregoing method embodiment, and details are not described herein again.
FIG. 6 is a block diagram illustrating an electronic device, which may be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a game console, a tablet device, a medical device, an exercise device, a personal digital assistant, and the like, in accordance with an exemplary embodiment.
The apparatus 600 may include one or more of the following components: a processing component 602, a memory 604, a power component 606, a multimedia component 608, an audio component 610, an input/output (I/O) interface 612, a sensor component 614, and a communication component 616.
The processing component 602 generally controls overall operation of the device 600, such as operations associated with display, telephone calls, data communications, camera operations, and recording operations. The processing component 602 may include one or more processors 620 to execute instructions to perform all or a portion of the steps of the methods described above. Further, the processing component 602 can include one or more modules that facilitate interaction between the processing component 602 and other components. For example, the processing component 602 can include a multimedia module to facilitate interaction between the multimedia component 608 and the processing component 602.
The memory 604 is configured to store various types of data to support operations at the apparatus 600. Examples of such data include instructions for any application or method operating on device 600, contact data, phonebook data, messages, pictures, videos, and so forth. The memory 604 may be implemented by any type or combination of volatile and non-volatile storage devices such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks.
Power supply component 606 provides power to the various components of device 600. The power components 606 may include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power for the apparatus 600.
The multimedia component 608 includes a screen that provides an output interface between the device 600 and the user. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive an input signal from a user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundary of a touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 608 includes a front facing camera and/or a rear facing camera. The front camera and/or the rear camera may receive external multimedia data when the device 600 is in an operating mode, such as a shooting mode or a video mode. Each front camera and rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.
The audio component 610 is configured to output and/or input audio signals. For example, audio component 610 includes a Microphone (MIC) configured to receive external audio signals when apparatus 600 is in an operational mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signal may further be stored in the memory 604 or transmitted via the communication component 616. In some embodiments, audio component 610 further includes a speaker for outputting audio signals.
The I/O interface 612 provides an interface between the processing component 602 and peripheral interface modules, which may be keyboards, click wheels, buttons, etc. These buttons may include, but are not limited to: a home button, a volume button, a start button, and a lock button.
The sensor component 614 includes one or more sensors for providing status assessment of various aspects of the apparatus 600. For example, the sensor component 614 may detect an open/closed state of the device 600, the relative positioning of components, such as a display and keypad of the device 600, the sensor component 614 may also detect a change in position of the device 600 or a component of the device 600, the presence or absence of user contact with the device 600, orientation or acceleration/deceleration of the device 600, and a change in temperature of the device 600. The sensor assembly 614 may include a proximity sensor configured to detect the presence of a nearby object without any physical contact. The sensor assembly 614 may also include a light sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 614 may also include an acceleration sensor, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.
The communication component 616 is configured to facilitate communications between the apparatus 600 and other devices in a wired or wireless manner. The apparatus 600 may access a wireless network based on a communication standard, such as WiFi,2G or 3G, or a combination thereof. In an exemplary embodiment, the communication component 616 receives broadcast signals or broadcast related information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 616 further includes a Near Field Communication (NFC) module to facilitate short-range communications. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, ultra Wideband (UWB) technology, bluetooth (BT) technology, and other technologies.
In an exemplary embodiment, the apparatus 600 may be implemented by one or more Application Specific Integrated Circuits (ASICs), digital Signal Processors (DSPs), digital Signal Processing Devices (DSPDs), programmable Logic Devices (PLDs), field Programmable Gate Arrays (FPGAs), controllers, micro-controllers, microprocessors or other electronic components for performing the above-described methods.
In an exemplary embodiment, a non-transitory computer readable storage medium comprising instructions, such as the memory 604 comprising instructions, executable by the processor 620 of the apparatus 600 to perform the above-described method is also provided. For example, the non-transitory computer readable storage medium may be a ROM, a Random Access Memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.
A non-transitory computer readable storage medium, instructions in which, when executed by a processor of an electronic device, enable the electronic device to perform a data transfer method of the electronic device.
The application also discloses a computer program product comprising a computer program which, when executed by a processor, implements the method as described in the embodiments.
Various implementations of the systems and techniques described here above may be realized in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
Program code for implementing the methods of the present application may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the program codes, when executed by the processor or controller, cause the functions/operations specified in the flowchart and/or block diagram to be performed. The program code may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or electronic device.
In the context of this application, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data electronic device), or that includes a middleware component (e.g., an application electronic device), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), and the Internet.
The computer system may include a client and an electronic device. The client and the electronic device are generally remote from each other and typically interact through a communication network. The relationship of client and electronic device arises by virtue of computer programs running on the respective computers and having a client-electronic device relationship to each other. The electronic device may be a cloud electronic device, which is also called a cloud computing electronic device or a cloud host, and is a host product in a cloud computing service system, so as to solve the defects of high management difficulty and low service extensibility in a conventional physical host and VPS service ("Virtual Private Server", or "VPS" for short). The electronic device may also be a distributed system of electronic devices or an electronic device incorporating a blockchain. It should be understood that various forms of the flows shown above, reordering, adding or deleting steps, may be used. For example, the steps described in the present application may be executed in parallel, sequentially, or in different orders, as long as the desired results of the technical solutions disclosed in the present application can be achieved, and the present invention is not limited herein.
Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.
It will be understood that the present application is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the application is limited only by the appended claims.

Claims (11)

1. A method of data transfer, the method comprising:
acquiring configuration information from a database in a first target cloud platform, and establishing a first temporary table on a second target cloud platform according to the configuration information; the configuration information represents attribute information of a data table in a database;
determining a second temporary table at the second target cloud platform according to the first temporary table; the second temporary table is obtained by writing original data information in the second target cloud platform into the first temporary table;
transferring the second temporary table to the first target cloud platform.
2. The method of claim 1, wherein said communicating the second temporary table to the first target cloud platform comprises:
acquiring the second temporary table from the second target cloud platform;
receiving a data request message of the first target cloud platform;
and transmitting the second temporary table to the first target cloud platform according to the data request message.
3. The method of claim 2, further comprising, after said passing the second temporary table to the first target cloud platform according to the data request message:
acquiring a first data table from the first target cloud platform; the first data table is obtained by updating the second temporary table on the first target cloud platform through the first target cloud platform;
establishing a second data table on the second target cloud platform according to the configuration information;
and updating the data information in the second data table according to the data information in the first data table.
4. The method of claim 3, wherein the establishing a second data table on the second target cloud platform according to the configuration information comprises:
acquiring data table field information in the configuration information;
and establishing a second data table on the second target cloud platform according to the data table field information.
5. The method of claim 4, wherein the second data table supports calls by the first local data system.
6. The method of claim 1, further comprising:
the data information of the database in the first target cloud platform is acquired from a second local data system; the database in the first target cloud platform and the second local data system have a mapping relation; wherein the number of the second local data systems is at least one.
7. The method of any one of claims 1-6, wherein the first target cloud platform and the second target cloud platform together comprise a data cloud platform.
8. A data transfer apparatus, the apparatus comprising:
the system comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for acquiring configuration information from a database in a first target cloud platform and establishing a first temporary table on a second target cloud platform according to the configuration information; the configuration information represents attribute information of a data table in a database;
a writing unit, configured to determine, according to the first temporary table, a second temporary table in the second target cloud platform; the second temporary table is obtained by writing original data information in the second target cloud platform into the first temporary table;
a transferring unit, configured to transfer the second temporary table to the first target cloud platform.
9. An electronic device, comprising: a processor, and a memory communicatively coupled to the processor;
the memory stores computer-executable instructions;
the processor executes computer-executable instructions stored by the memory to implement the method of any of claims 1-7.
10. A computer-readable storage medium having computer-executable instructions stored therein, which when executed by a processor, are configured to implement the method of any one of claims 1-7.
11. A computer program product, comprising a computer program which, when executed by a processor, implements the method of any one of claims 1-7.
CN202211265195.3A 2022-10-17 2022-10-17 Data transmission method, device, equipment and medium Pending CN115544167A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211265195.3A CN115544167A (en) 2022-10-17 2022-10-17 Data transmission method, device, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211265195.3A CN115544167A (en) 2022-10-17 2022-10-17 Data transmission method, device, equipment and medium

Publications (1)

Publication Number Publication Date
CN115544167A true CN115544167A (en) 2022-12-30

Family

ID=84736255

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211265195.3A Pending CN115544167A (en) 2022-10-17 2022-10-17 Data transmission method, device, equipment and medium

Country Status (1)

Country Link
CN (1) CN115544167A (en)

Similar Documents

Publication Publication Date Title
CN111596991A (en) Interactive operation execution method and device and electronic equipment
CN116822924A (en) Workflow configuration method, device, equipment and storage medium
CN112256372A (en) Information processing method and device and electronic equipment
CN112925584A (en) Scene-based file configuration method, device, storage medium, and program product
US9544264B1 (en) Augmenting location of social media posts based on proximity of other posts
CN115687303A (en) Data information migration method, device, equipment and storage medium
EP4274237A1 (en) Information display method and apparatus, and device and medium
CN115544167A (en) Data transmission method, device, equipment and medium
CN115834483A (en) Flow control method, device and equipment based on cluster and storage medium
CN115422203A (en) Data management method, device, equipment and medium for block chain distributed system
US20210144048A1 (en) Method and apparatus for outputting information
CN113836455A (en) Special effect rendering method, device, equipment, storage medium and computer program product
CN114827060A (en) Interaction method and device and electronic equipment
CN117391038B (en) Metal stack space information dividing method of chip layout and chip
CN114116590B (en) Data acquisition method, device, vehicle, storage medium and electronic equipment
CN115794771A (en) Document information generation method, device, equipment and storage medium
CN116302196A (en) Application running method and device based on dependency package, electronic equipment and storage medium
CN117453342A (en) Virtual product configuration method, device, equipment and storage medium
CN117522662A (en) Video frame data processing method and device, electronic equipment and storage medium
CN118283203A (en) Video data complement method and device, electronic equipment and storage medium
CN114240393A (en) Data processing method, device and equipment based on management system and storage medium
CN115509580A (en) Data request access method, device, equipment and storage medium
CN116680274A (en) Method and device for associating business database table and attachment information table
CN116431673A (en) Data information query method, device, equipment and storage medium
CN117472931A (en) Method, device, equipment and storage medium for calling database execution statement

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination