WO2018165962A1 - E-commerce data migration system and method - Google Patents

Abstract

The present invention provides an e-commerce data migration system and method. The method comprises: searching the network for a corresponding number of terminals; combining all the discovered terminals into a cluster; notifying the first database server of sending the e-commerce data to be migrated, by means of the discovered terminals, to a second database server; and when a terminal of the cluster is in an idle state, notifying the terminal in an idle state of the cluster to actively acquire the e-commerce data to be migrated in the first database server and send same to the second database server. The present invention can utilize the network bandwidth used by the terminals, reducing e-commerce bandwidth costs, and can allow the state of the terminals to be dynamically viewed during data migration, thereby utilizing the terminals for data migration to the fullest extent.

Description

 E-commerce data migration system and method

 [0001] The present invention relates to the field of information technology, and in particular, to an e-commerce data 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, after the migration of existing e-commerce data, if the amount of data is large, the broadband cost will be greatly increased.

 technical problem

 [0004] The main object of the present invention is to provide an e-commerce data migration system and method, which aims to solve the technical problem of data migration based on an inconvenable terminal in an existing e-commerce system.

 Problem solution

 Technical solution

 [0005] In order to achieve the above object, the present invention provides an e-commerce data migration system, which is operated in a data migration device, and the data migration device 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 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 terminals in the network according to the size of the e-commerce data to be migrated;

[0009] a collection module, configured to group all the searched terminals into one cluster; [0010] a sending module, configured to send the data migration configuration file to each terminal in the cluster, so that each terminal in the cluster establishes a communication connection between the first database server and the second database server;

[0011] 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; and

 [0012] The notification module is further configured to notify the terminal in the idle state that the terminal in the cluster is in an idle state, and actively acquires the e-commerce data to be migrated in the first database server and occurs to the second. Database server.

 [0013] Another invention, the present invention further provides an e-commerce data migration method, which is applied to a data migration device, wherein the data migration device is communicably connected to the first database server and the second database server through a network. The network is connected to a plurality of terminals, and the method includes the following steps:

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

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

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

 [0017] transmitting 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;

[0018] 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

 [0019] The present invention uses multiple terminals to perform data migration on the e-commerce data, utilizes the network bandwidth used by the terminal, saves the bandwidth cost of the e-commerce, and can dynamically view the status of the terminal during the data migration process, and maximize the utilization. The terminal performs data migration.

 Brief description of the drawing

 DRAWINGS

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

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

3 is a flow chart of a preferred embodiment of the e-commerce data migration method of the present invention. BEST MODE FOR CARRYING OUT THE INVENTION

 BEST MODE FOR CARRYING OUT THE INVENTION

Referring to FIG. 1, FIG. 1 is a schematic diagram of an application environment of an e-commerce data migration system according to the present invention. The e-commerce data migration system 30 in the present invention operates on the data migration device 3. The data migration device 3 is communicatively coupled to the first database server 1 and the second database server 4 via the network 2. The data migration device 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 (e.g., user name, product text information, merchandise type information, courier information, warehousing information, merchandise pictures, shopping records, etc.).

 [0024] 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, and the first partition database C stores video data in the e-commerce data, the first partition. The database D stores web page data in the e-commerce data.

 [0025] 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.

 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, for example, 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, the second partition database C1 stores video data in the e-commerce data, and the second The partition database D1 stores web page data in the e-commerce data.

 [0027] 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.

[0028] It should be noted that the second database server 4 is an alternate service of the first database server 1. The e-commerce data in the first database server 1 can be migrated to the second database server 4 for backup.

 [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 WiMAM network, a TD-LTE network, an FDD-LTE network, and the like. .

 [0030] Further, the data migration device 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. Make a backup.

 [0031] 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 WiMAM network, a TD-LTE network, an FDD-LTE network, and the like.

 [0032] The data migration device 3 may be, but is 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.

 [0033] The terminal 5 may be, but 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.

 [0034] Referring to FIG. 2, it is a block diagram of a preferred embodiment of the e-commerce data migration system of the present invention. In the present embodiment, the e-commerce data migration system 30 is applied to the data migration device 3. The data migration device 3 includes, but is not limited to, an e-commerce data migration system 30, a storage unit 31, a processing unit 32, and a communication unit 33.

 [0035] The storage unit 31 may be a read only storage unit ROM, an electrically erasable storage unit EEPRO

M, flash memory unit FLASH or solid hard disk.

[0036] 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.

[0037] The communication unit 33 is a communication interface with a remote communication function, for example, supporting GSM, GPR.

Communication interfaces of wireless communication technologies such as S, WCDMA, CDMA, TD-SCDMA, WiMAM, TD-LTE, FDD-LTE, etc., support wired communication interfaces of USB and network cables. [0038] The e-commerce data migration system 30 includes, but is not limited to, a receiving module 311, an obtaining module 312, a searching module 313, a collecting module ₃₁₄ , a sending module 315, a notification module 316, and a determining module 317, which are claimed in the present invention. The module refers to a series of computer program instruction segments that can be executed by the processing unit 32 of the data migration device 3 and that are capable of performing a fixed function, which are stored in the storage unit 31 of the data migration device 3.

 [0039] 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 the second database server 4 The IP 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 device 3, and the data migration configuration file is periodically updated.

 [0040] 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.

[0041] 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. The unit data size (for example, 2GB), M is the number of terminals, and a is a positive integer constant. In addition, the search module 312 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 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 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 user, 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.

 [0042] The aggregation module 314 is configured to aggregate all the searched terminals 5 into a cluster. Specifically, the manner in which the aggregation module 314 aggregates all the searched terminals 5 into one cluster is as follows: (1) assigning an encoding to each of the searched terminals 5; (2) acquiring the IP of each searched terminal 5. Address: (3) Create a cluster configuration file and send it to each searched terminal 5 to complete the creation of the cluster. The cluster configuration file includes the IP address and code of each searched terminal 5. It should be noted that the two search terminals 5 in the cluster can communicate with each other (according to the IP address and encoding) and exchange data. When one terminal 5 in the cluster cannot directly transmit data to the second database server 4, The terminal 5 can transmit data to the second database server 4 via another terminal 5 in the cluster.

 [0043] The sending module 315 is configured to send the data migration configuration file to each terminal 5 in the cluster, so that each terminal 5 in the cluster establishes communication between the first database server 1 and the second database server 4. connection. After receiving the data migration configuration file, the terminal 5 in the cluster communicates with the first database server 1 according to the IP address of the first database server 1, and accesses according to the database configuration file of the first database server 1. The first partition database 100 is communicably connected to 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.

 [0044] The notification module 316 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 316 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 A1 for storage.

 [0045] The determining module 317 is configured to determine whether any of the terminals 5 in the cluster are in an idle state. Specifically, the determining module 317 detects each terminal 5 in the cluster, and determines whether the terminal 5 is transmitting e-commerce data (for example, by acquiring a related thread running in the terminal in the cluster), if the cluster has If the terminal 5 does not transmit the e-commerce data, the terminal 5 is in an idle state.

[0046] The notification module 316 is further configured to notify the terminal 5 in the idle state that the terminal 5 in the cluster is in an idle state to actively acquire the e-commerce data to be migrated in the first database server 1 concurrently. Born to the second database server 4.

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

[0048] 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 the second database server 4 The IP 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 device 3, and the data migration configuration file is periodically updated.

 [0049] 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.

[0050] 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. The unit data size (for example, 1GB), M is the number of terminals, and a is a positive integer constant. In addition, the search module 312 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 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 user, the e-commerce data of the first database server 1 is migrated, and is set at 12 in the evening. After the point, it will be between 4 am.

 [0051] Step S14: The aggregation module 314 aggregates all the searched terminals 5 into a cluster. Specifically, the manner in which the aggregation module 314 aggregates all the searched terminals 5 into one cluster is as follows: (1) assigning an encoding to each of the searched terminals 5; (2) acquiring the IP of each searched terminal 5. Address: (3) Create a cluster configuration file and send it to each searched terminal 5 to complete the creation of the cluster. The cluster configuration file includes the IP address and code of each searched terminal 5. It should be noted that the two search terminals 5 in the cluster can communicate with each other (according to the IP address and encoding) and exchange data. When one terminal 5 in the cluster cannot directly transmit data to the second database server 4, The terminal 5 can transmit data to the second database server 4 via another terminal 5 in the cluster.

 [0052] Step S15: The sending module 314 sends the data migration configuration file to each terminal 5 in the cluster, so that each terminal 5 in the cluster is established between the first database server 1 and the second database server 4. Communication connection. After receiving the data migration configuration file, the terminal 5 in the cluster communicates with the first database server 1 according to the IP address of the first database server 1, and accesses according to the database configuration file of the first database server 1. The first partition database 100 is communicably connected to 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.

 [0053] Step S16: The notification module 316 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 316 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 A1 for storage.

 [0054] Step S17: The determining module 317 determines whether any of the terminals 5 in the cluster are in an idle state. Specifically, the determining module 317 detects each terminal 5 in the cluster, and determines whether the terminal 5 is transmitting e-commerce data (for example, by acquiring a related thread running in the terminal in the cluster), if the cluster has If the terminal 5 does not transmit the e-commerce data, the terminal 5 is in an idle state. If all the terminals 5 in the cluster are idle, the flow proceeds to step S18. Otherwise, if no terminal 5 is idle in the cluster, repeat step S17.

[0055] Step S18: The notification module 316 notifies the terminal 5 in the idle state that the e-commerce data to be migrated in the first database server 1 is actively acquired and occurs to the second database server 4. Industrial applicability

 The invention adopts multiple terminals to perform data migration on the e-commerce data, utilizes the network bandwidth used by the terminal, saves the bandwidth cost of the e-commerce, and can dynamically view the state of the terminal during the data migration process, and utilize the terminal to perform data maximally. migrate.

Claims

Claim  [Claim 1] An e-commerce data migration system, running in a data migration device, wherein the data migration device is communicably connected to a first database server and a second database server via a network, and the communication connection on the network There are multiple terminals, and the system includes:  a receiving module, configured to receive a data migration configuration file of the first database server, and an acquiring 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;  a search module, configured to search a network for a corresponding number of terminals according to the size of the e-commerce data to be migrated;  a collection module, configured to aggregate all searched terminals into one cluster;  a sending module, configured to send the data migration configuration file to each terminal in the cluster, so that each terminal in the cluster establishes a communication connection between the first database server and the second database server;  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; and  The notification module is further configured to notify the terminal in the idle state that the terminal in the cluster is in an idle state to actively acquire the e-commerce data to be migrated in the first database server and generate the data to the second database server.  [Claim 2] The e-commerce data 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 The 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 unique partition. Code. [Claim 3] The e-commerce data migration system according to claim 2, wherein the data migration configuration file includes an IP address of the first database server, and each first partition database in the first database server Partition code, attribute information of e-commerce data to be migrated in the first database server, database configuration file of the first database server, IP address of the second database server, and second partition database in the second database server The partition code and the database configuration file of the second database server.  [Claim 4] The e-commerce data migration system according to claim 1, wherein the collection module aggregates all the searched terminals into one cluster as follows: assigning an encoding to each searched terminal; Obtaining the IP address of each searched terminal; creating a cluster configuration file and sending it to each searched terminal to complete the creation of the cluster, the cluster configuration file including the IP address and encoding of each searched terminal.  [Claim 5] An e-commerce data migration method is applied to a data migration device, wherein the data migration device is communicably connected to a first database server and a second database server through a network, and the communication connection on the network The method includes the following steps: receiving a data migration configuration file of the first database server, and 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, and collecting all the searched terminals into one cluster;  Sending the data migration configuration file to each terminal in the cluster, so that each terminal in the cluster establishes a communication connection between the first database server and the second database server to notify the first database server to move the to-be-migrated E-commerce data is sent to the second database server through the searched terminal; and  When a terminal in the cluster is in an idle state, the terminal in the cluster is notified that the terminal in the idle state actively acquires the e-commerce data to be migrated in the first database server and generates the data to the second database server. [Claim 6] The e-commerce data migration method according to claim 5, 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 The 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 unique partition. Code. [Claim 7] The e-commerce data migration method according to claim 5, wherein the data migration configuration file includes an IP address of the first database server, and each first partition database in the first database server Partition code, attribute information of e-commerce data to be migrated in the first database server, database configuration file of the first database server, IP address of the second database server, and second partition database in the second database server The partition code and the database configuration file of the second database server.  [Claim 8] The e-commerce data migration method according to claim 5, wherein the step of grouping all the searched terminals into one cluster comprises the following steps: assigning an encoding to each searched terminal; Obtaining the IP address of each searched terminal; creating a cluster configuration file and sending it to each searched terminal to complete the creation of the cluster, the cluster configuration file including the IP address and encoding of each searched terminal.