WO2018165965A1

WO2018165965A1 - System and method for dynamic migration of intensive e-commerce data

Info

Publication number: WO2018165965A1
Application number: PCT/CN2017/077012
Authority: WO
Inventors: 李楚斌
Original assignee: 深圳市秀趣品牌文化传播有限公司
Priority date: 2017-03-17
Filing date: 2017-03-17
Publication date: 2018-09-20

Abstract

The present invention provides a system and a method for the dynamic migration of intensive e-commerce data. The method comprises: receiving a data migration configuration file of a first database server; acquiring, from the data migration configuration file, the magnitude of the e-commerce data to be migrated out of the first database server; according to the magnitude of the e-commerce data to be migrated, searching a network for a corresponding number of terminals; sending the data migration configuration file to each discovered terminal, such that each discovered terminal establishes a communication connection between the first database server and a second database server; and notifying the first database server of sending the e-commerce data to be migrated to the second database server by means of the discovered terminal. The present invention can utilize the network bandwidth used by a terminal for data migration, reducing the bandwidth costs of medical institutions.

Description

Intensive e-commerce data dynamic migration system and method

[0001] The present invention relates to the field of information technology, and in particular, to an intensive e-commerce data dynamic migration system and method.

Background technique

[0002] With the rapid development of electronic commerce, people are increasingly accustomed to using e-commerce websites to purchase goods.

However, sellers who are making profits through online channels cannot use the existing Internet information to predict the hot products afterwards, in order to achieve more profit.

[0003] Further, with the development of mobile e-commerce, more and more consumers are now using terminals (for example, terminals of touch screens such as mobile phones and tablet computers) to view online shopping. To ensure the stability of the e-commerce system (or website), the e-commerce system (or website) needs to periodically migrate e-commerce data for backup to prevent data corruption. However, the existing e-commerce data migration does not adopt the clustering method, but uses a single device for data migration. If the device fails to cause data migration failure, and the e-commerce data is huge, the e-commerce service provider is also increased. Broadband cost.

technical problem

[0004] The main object of the present invention is to provide an intensive e-commerce data dynamic migration system and method, which aims to solve the technical problem of data migration that cannot be called by a terminal in an existing medical information system.

Problem solution

Technical solution

[0005] In order to achieve the above object, the present invention provides an intensive e-commerce data dynamic migration system, which is operated in a data migration terminal, and the data migration terminal is communicably connected to a first database server and a second database server through a network. The network is connected to a plurality of terminals, and the system includes:

[0006] a receiving module, configured to receive a data migration configuration file of the first database server;

[0007] an obtaining module, configured to acquire, from the data migration configuration file, a size of the e-commerce data to be migrated in the first database server;

[0008] a search module, configured to search for a corresponding number of final mountains in the network according to the size of the e-commerce data to be migrated [0009] a sending module, configured to send the data migration configuration file to each searched terminal, so that each of the searched terminals establishes a communication connection between the first database server and the second database server; [0010] And a module, configured to notify the first database server to send the e-commerce data to be migrated to the second database server by using the searched terminal.

[0011] Another invention, the present invention further provides an intensive e-commerce data dynamic migration method, which is applied to a data migration terminal, wherein the data migration terminal communicates with the first database server and the second database server through a network. The communication connection on the network has multiple terminals, and the method includes the following steps:

[0012] receiving a data migration configuration file of the first database server;

[0013] obtaining, from the data migration configuration file, a size of the e-commerce data to be migrated in the first database server;

[0014] searching for a corresponding number of terminals in the network according to the size of the e-commerce data to be migrated;

[0015] sending the data migration configuration file to each of the searched terminals, so that each of the searched terminals establishes a communication connection between the first database server and the second database server;

[0016] notifying the first database server to send the e-commerce data to be migrated to the second database server through the searched terminal.

Advantageous effects of the invention

Beneficial effect

[0017] The present invention uses multiple terminals to perform data migration on e-commerce data, and utilizes the network bandwidth used by the terminal to save the bandwidth cost of the medical institution.

Brief description of the drawing

DRAWINGS

1 is a schematic diagram of an application environment of an intensive e-commerce data dynamic migration system according to the present invention;

2 is a block diagram showing a preferred embodiment of an intensive e-commerce data dynamic migration system according to the present invention;

3 is a flow chart of a preferred embodiment of the intensive e-commerce data dynamic migration method of the present invention.

BEST MODE FOR CARRYING OUT THE INVENTION

[0021] Referring to FIG. 1, FIG. 1 is a schematic diagram of an application environment of an intensive e-commerce data dynamic migration system according to the present invention. The intensive e-commerce data dynamic migration system 30 in the present invention runs on the data migration terminal 3. The data migration terminal 3 is communicatively coupled to the first database server 1 and the second database server 4 via the network 2. The data migration terminal 3 can access the first database server 1 (or the second database server 4) through the network 2, and acquire various types of electricity from the first database server 1 (or the second database server 4). Business data. The e-commerce data data includes, for example, a user name, product text information, merchandise type information, courier information, warehousing information, merchandise pictures, shopping records, and the like.

[0022] The first database server 1 is installed with a first database 10, wherein the database 10 is divided into a plurality of first partition databases 100, for example, N first partition databases 100, and each first partition database 10 0 A unique partition code is assigned, and a first partition database 100 stores one type of e-commerce data. For example, the first partition database A stores text data in the e-commerce data, the first partition database B stores image data in the e-commerce data, the first partition database C stores video data in the e-commerce data, and the first partition database D stores Web page data in e-commerce data.

[0023] The first database server 1 provides a data import interface (for example, an application program interface, an API), and a device or system that accesses the data import interface can be from the first database server 1. The first partition database 100 acquires e-commerce data.

[0024] The second database server 4 is installed with a second database 40, wherein the database 40 is divided into a plurality of second partition databases 400, such as N second partition databases 400, and each second partition database 40 0 A unique partition code is assigned, and a second partition database 400 stores one type of e-commerce data. For example, the second partition database A1 stores text data in the e-commerce data, the second partition database B1 stores image data in the e-commerce data, and the second partition database C1 stores video data in the e-commerce data, the second partition database D1. Store web page data in e-commerce data.

[0025] Specifically, the second database server 4 provides a data import interface (for example, an application interface

(Application Program Interface, API), the device or system accessing the data import interface can obtain the e-commerce data from the second database server 4.

[0026] It should be noted that the second database server 4 is a backup server of the first database server 1, and the e-commerce data in the first database server 1 can be migrated to the second database server 4 for backup. .

[0027] In this embodiment, the network 2 may be a wired communication network or a wireless communication network. The network is excellent Selected as a wireless communication network, including but not limited to, GSM network, GPRS network, CDMA network, TD-S CDMA network, WiMAX network, TD-LTE network, FDD-LTE network and other wireless transmission networks. . Further, the data migration terminal 3 is communicatively connected to the plurality of terminals 5 through the network 2, and is configured to migrate the e-commerce data in the first database server 1 to the second database server 4 through the terminal 5 for preparation.

[0029] In this embodiment, the network 2 may be a wired communication network or a wireless communication network. The network is preferably a wireless communication network, including but not limited to a GSM network, a GPRS network, a CDMA network, a TD-S CDMA network, a WiMAX network, a TD-LTE network, an FDD-LTE network, and the like.

[0030] The data migration terminal 3 may be, but not limited to, a smartphone, a tablet, a personal digital assistant.

(Personal Digital Assistant, PDA), personal computer, electronic signage, and any other suitable terminal equipment.

[0031] The terminal 5 may be, but is not limited to, any other suitable portable touch screen electronic device such as a smart phone, a tablet computer, a personal digital assistant (PDA), a personal computer, an electronic signboard, and the like.

[0032] Referring to Figure 2, there is shown a block diagram of a preferred embodiment of the intensive e-commerce data dynamic migration system of the present invention. In the present embodiment, the intensive e-commerce data dynamic migration system 30 is applied to the data migration terminal 3. The data migration terminal 3 includes, but is not limited to, an intensive e-commerce data dynamic migration system 30, a storage unit 31, a processing unit 32, and a communication unit 33.

[0033] The storage unit 31 may be a read only storage unit ROM, an electrically erasable storage unit EEPRO M, a flash storage unit FLASH or a solid hard disk.

[0034] The processing unit 32 may be a central processing unit (CPU), a microcontroller (MCU), a data processing chip, or an information processing unit having a data processing function.

[0035] The communication unit 33 is a communication interface with a remote communication function, for example, communication supporting wireless communication technologies such as GSM, GPR S, WCDMA, CDMA, TD-SCDMA, WiMAM, TD-LTE, FDD-LTE, and the like. Interface, support wired communication interface of USB and network cable.

[0036] The intensive e-commerce data dynamic migration system 30 includes, but is not limited to, a receiving module 311, an obtaining module 312, a searching module 313, a sending module 314, and a notification module 315. The module referred to in the present invention refers to a module. A system that can be executed by the processing unit 32 of the data migration terminal 3 and capable of performing a fixed function The column computer program instruction segment is stored in the storage unit 31 of the data migration terminal 3.

[0037] The receiving module 311 is configured to receive a data migration configuration file of the first database server 1. In this embodiment, the data migration configuration file includes, but is not limited to, an IP address of the first database server 1, a partition code of each first partition data 100 in the first database server 1, and a first database server. Attribute information (including data size, file directory, and the like) of the e-commerce data to be migrated in 1 , a database configuration file (for example, database connection configuration information, etc.) of the first database server 1 , and an IP of the second database server 4 The address, the partition code of each second partition data 400 in the second database server 4, the database configuration file of the second database server 4 (for example, database connection configuration information, etc.). It should be noted that the data migration configuration file may be pre-stored in the data migration terminal 3, and the data migration configuration file may be periodically updated.

[0038] The obtaining module 312 is configured to obtain, from the data migration configuration file, a size of the e-commerce data to be migrated in the first database server 1.

[0039] The search module 313 is configured to search the network 2 for a corresponding number of terminals 5 according to the size of the e-commerce data to be migrated. The relationship between the size of the e-commerce data to be migrated and the corresponding number of terminals 5 is: M = a * N / N0, where N is the size of the e-commerce data to be migrated, and NO is set. Unit data size (for example, 1GB), M is the number of terminals, and a is a positive integer constant. In addition, the search module 313 sends a network broadcast to the network 2, and if the terminal 5 connected to the network 2 receives the network broadcast and agrees to be an intermediate device for data migration, the terminal 5 is a searched terminal. For example, if the terminal 5 receives the network broadcast, the terminal 5 pops up a query dialog box, which includes a confirmation button and a cancel button. When the user using the terminal 5 clicks the OK button, the terminal 5 is authorized to be the first. The intermediate device of the database server 1 migrating data, if the user using the terminal 5 clicks the cancel button, it indicates that the terminal 5 rejects the intermediate device that migrates data for the first database server 1. In order to avoid the excessive rejection rate of the terminal 5, the reward information may be embedded in the network broadcast. For example, if the terminal 5 agrees to be an intermediate device for migrating data, an electronic money (for example, 1 yuan of electronic money) may be sent to the terminal. Terminal 5. In addition, the user's terminal can also be used as an intermediate device for migrating data. In order to avoid affecting the work and life of the staff, the e-commerce data of the first database server 1 is migrated, and the setting is made between 12 o'clock in the evening and 4 o'clock in the morning.

[0040] The sending module 314 is configured to send the data migration configuration file to each searched terminal 5, so that Each of the searched terminals 5 establishes a communication connection between the first database server 1 and the second database server 4. After receiving the data migration configuration file, the searched terminal 5 communicates with the first database server 1 according to the IP address of the first database server 1, and accesses the database according to the database configuration file of the first database server 1. The first partition database 100 is in communication with the second database server 4 according to the IP address of the second database server 4, and accesses the second partition database 400 according to the database configuration file of the second database server 4.

[0041] The notification module 315 is configured to notify the first database server 1 to send the e-commerce data to be migrated to the second database server 4 through the searched terminal 5. Specifically, the notification module 315 notifies the first database server 1 to transfer text data from the first partition database 100 through the searched terminal 5 to the second partition database 400 (e.g., the second partition database A1) for storage.

[0042] Referring to FIG. 3, it is a flow chart of a preferred embodiment of the intensive e-commerce data dynamic migration method of the present invention. In this embodiment, the intensive e-commerce data dynamic migration method is applied to the data migration terminal 3, and the method includes the following steps:

[0043] Step S11: The receiving module 311 receives the data migration configuration file of the first database server 1. In this embodiment, the data migration configuration file includes, but is not limited to, an IP address of the first database server 1, a partition code of each first partition data 100 in the first database server 1, and a first database server. Attribute information (including data size, file directory, and the like) of the e-commerce data to be migrated in 1 , a database configuration file (for example, database connection configuration information, etc.) of the first database server 1 , and an IP of the second database server 4 The address, the partition code of each second partition data 40 0 in the second database server 4, the database configuration file of the second database server 4 (for example, database connection configuration information, etc.). It should be noted that the data migration configuration file may be pre-stored in the data migration terminal 3, and the data migration configuration file may be periodically updated.

[0044] Step S12: The obtaining module 312 obtains, from the data migration configuration file, the size of the e-commerce data to be migrated in the first database server 1.

[0045] Step S13: The search module 313 searches the network 2 for the terminal 5 according to the size of the e-commerce data to be migrated. The relationship between the size of the e-commerce data to be migrated and the corresponding number of terminals 5 is: M=a* N/N0, where N is the size of the e-commerce data to be migrated, and NO is set. Unit data size (for example, 1GB), M is the number of terminals, and a is a positive integer constant. In addition, the search module 313 sends The network broadcasts into the network 2, and if the terminal 5 connected to the network 2 receives the network broadcast and agrees to be an intermediate device for data migration, the terminal 5 is a searched terminal. For example, if the terminal 5 receives the network broadcast, the terminal 5 pops up a query dialog box, which includes a confirmation button and a cancel button. When the user using the terminal 5 clicks the OK button, the terminal 5 is authorized to be the first. The intermediate device that the database server 1 migrates data, if the user using the terminal 5 clicks the cancel button, indicates that the terminal 5 rejects the intermediate device that migrates data for the first database server 1. In order to avoid the excessive rejection rate of the terminal 5, the reward information may be embedded in the network broadcast. For example, if the terminal 5 agrees to be an intermediate device for migrating data, an electronic money (for example, 1 yuan of electronic money) may be sent to the terminal. Terminal 5. In addition, the user's terminal can also be used as an intermediate device for migrating data. In order to avoid affecting the work and life of the staff, the e-commerce data of the first database server 1 is migrated, and the setting is made after 12 o'clock in the evening to 4 o'clock in the morning.

[0046] Step S14: The sending module 314 sends the data migration configuration file to each of the searched terminals 5, so that each of the searched terminals 5 is established between the first database server 1 and the second database server 4. Communication connection. After receiving the data migration configuration file, the searched terminal 5 communicates with the first database server 1 according to the IP address of the first database server 1, and accesses the database according to the database configuration file of the first database server 1. The first partition database 100 is in communication with the second database server 4 according to the IP address of the second database server 4, and accesses the second partition database 400 according to the database configuration file of the second database server 4.

[0047] Step S15: The notification module 315 notifies the first database server 1 to send the e-commerce data to be migrated to the second database server 4 through the searched terminal 5. Specifically, the notification module 315 notifies the first database server 1 to transfer the text data in the first partition database 100 from the searched terminal 5 to the second partition database 400 (e.g., the second partition database A1) for storage.

Industrial applicability

[0048] The present invention uses multiple terminals to perform data migration on e-commerce data, and utilizes the network bandwidth used by the terminal to save the bandwidth cost of the medical institution.

Claims

Claim

[Claim 1] An intensive e-commerce data dynamic migration system, running in a data migration terminal, wherein the data migration terminal is communicably connected to a first database server and a second database server through a network, the network The upper communication connection has a plurality of terminals, the system includes: a receiving module, configured to receive a data migration configuration file of the first database server, and an obtaining module, configured to acquire the first database server from the data migration configuration file The size of the e-commerce data to be migrated;

a search module, configured to search for a corresponding number of terminals in the network according to the size of the e-commerce data to be migrated;

a sending module, configured to send the data migration configuration file to each searched terminal, so that each of the searched terminals establishes a communication connection between the first database server and the second database server;

And a notification module, configured to notify the first database server to send the e-commerce data to be migrated to the second database server by using the searched terminal.

[Claim 2] The intensive e-commerce data dynamic migration system according to claim 1, wherein the first database server is installed with a first database, and the second database server is installed with a second database, wherein The first database is divided into a plurality of first partition databases, and the second database is divided into a plurality of second partition databases, each of the first partition databases is assigned a unique partition code, and each second partition database is assigned a The only partition code.

[Claim 3] The intensive e-commerce data dynamic migration system according to claim 2, wherein the data migration configuration file includes an IP address of the first database server, and each of the first database servers a partition code of a partition database, attribute information of e-commerce data to be migrated in the first database server, a database configuration file of the first database server, an IP address of the second database server, and a second second in the second database server The partition code of the partition database and the database configuration file of the second database server.

[Claim 4] The intensive e-commerce data dynamic migration system according to claim 3, wherein the searched terminal receives the data migration configuration file, according to the first database The IP address of the server is in communication with the first database server, accessing the first partition database according to a database configuration file of the first database server, and communicating with the second database server according to an IP address of the second database server Accessing the second partition database according to a database configuration file of the second database server.

[Claim 5] The intensive e-commerce data dynamic migration system according to claim 1, wherein the relationship between the size of the e-commerce data to be migrated and the corresponding number of terminals is: M=a* N/N0, where N is the size of the e-commerce data to be migrated, NO is the set unit data size, M is the number of terminals, and a is a positive integer constant.

[Claim 6] A method for dynamic migration of an intensive e-commerce data, which is applied to a data migration terminal, wherein the data migration terminal is communicably connected to a first database server and a second database server through a network, the network The upper communication connection has multiple terminals, and the method includes the following steps:

Receiving a data migration configuration file of the first database server; acquiring, from the data migration configuration file, a size of the e-commerce data to be migrated in the first database server;

Searching for a corresponding number of terminals in the network according to the size of the e-commerce data to be migrated; sending the data migration configuration file to each searched terminal, so that each of the searched terminals is in the first database server and the second Establish a communication connection between database servers; and

Notifying the first database server to send the e-commerce data to be migrated to the second database server through the searched terminal.

[Claim 7] The intensive e-commerce data dynamic migration method according to claim 6, wherein the first database server is installed with a first database, and the second database server is installed with a second database, wherein The first database is divided into a plurality of first partition databases, and the second database is divided into a plurality of second partition databases, each of the first partition databases is assigned a unique partition code, and each second partition database is assigned a The only partition code.

[Claim 8] The intensive e-commerce data dynamic migration method according to claim 7, wherein The data migration configuration file includes an IP address of the first database server, a partition code of each first partition database in the first database server, attribute information of the e-commerce data to be migrated in the first database server, and a first database server. a database configuration file, an IP address of the second database server, a partition code of each second partition database in the second database server, and a database configuration file of the second database server.

[Claim 9] The intensive e-commerce data dynamic migration method according to claim 8, wherein the searched terminal receives the data migration configuration file according to an IP address of the first database server Communicating with the first database server, accessing the first partition database according to a database configuration file of the first database server, and communicating with the second database server according to an IP address of the second database server, according to the second The database configuration file of the database server accesses the second partition database.

[Claim 10] The intensive e-commerce data dynamic migration method according to claim 6, wherein the relationship between the size of the e-commerce data to be migrated and the corresponding number of terminals is: M=a* N/N0, where N is the size of the e-commerce data to be migrated, NO is the set unit data size, M is the number of terminals, and a is a positive integer constant.