CN117875816B

CN117875816B - Cross-border E-business data statistical processing method and system

Info

Publication number: CN117875816B
Application number: CN202410028900.0A
Authority: CN
Inventors: 陈亚涛; 侯博伟
Original assignee: Shenzhen Hanli Technology Co ltd
Current assignee: Shenzhen Hanli Technology Co ltd
Priority date: 2024-01-05
Filing date: 2024-01-05
Publication date: 2024-10-11
Anticipated expiration: 2044-01-05
Also published as: CN117875816A

Abstract

The embodiment of the application provides a data statistics processing method and system of cross-border electronic commerce, wherein the method comprises the following steps: the cross-border e-commerce server receives cross-border logistics information sent by terminal equipment, wherein the cross-border logistics information comprises: order number, recipient, address and communication phone; the cross-border e-commerce server extracts a position coordinate corresponding to the terminal equipment, extracts a country corresponding to the terminal equipment according to the position coordinate, extracts a native language corresponding to the country, and extracts a translator corresponding to the native language and the storage language if the native language is inconsistent with the storage language of the database; and the cross-border e-commerce server calls the translator, performs operation on the address in the cross-border logistics information as input data of the translator to obtain the address translated by the address, wherein the translated address is the address recorded by the storage language, and stores the order number, the receiver, the translated address and the communication telephone in a database.

Description

Cross-border E-business data statistical processing method and system

Technical Field

The application belongs to the technical fields of communication and electronic commerce, and particularly relates to a data statistics processing method and system of cross-border electronic commerce.

Background

The cross-border e-commerce is referred to as a cross-border e-commerce, which refers to a transaction main body belonging to different environments (i.e. different countries or regions), achieves transaction and electronic payment settlement through an e-commerce platform, and achieves commodity through the cross-border e-commerce logistics and the different-place storage, thereby completing the international business activity of the transaction.

The existing cross-border electronic commerce cannot be commonly used for processing different logistics information, for example, different languages are available in different areas, unified processing of logistics data cannot be realized through the common language for tracking information of the logistics information, so that the cross-language processing of the logistics data cannot be realized, and the cost of data statistics is increased.

Disclosure of Invention

The application provides a data statistics processing method and system for cross-border electronic commerce, which can realize unified processing of different languages, thereby reducing the cost of data statistics.

In a first aspect, the present application provides a method for processing data statistics of cross-border electronic commerce, the method comprising the following steps:

the cross-border e-commerce server receives cross-border logistics information sent by terminal equipment, wherein the cross-border logistics information comprises: order number, recipient, address and communication phone;

The cross-border e-commerce server extracts a position coordinate corresponding to the terminal equipment, extracts a country corresponding to the terminal equipment according to the position coordinate, extracts a native language corresponding to the country, and extracts a translator corresponding to the native language and the storage language if the native language is inconsistent with the storage language of the database;

and the cross-border e-commerce server calls the translator, performs operation on the address in the cross-border logistics information as input data of the translator to obtain the address translated by the address, wherein the translated address is the address recorded by the storage language, and stores the order number, the receiver, the translated address and the communication telephone in a database.

In a second aspect, a data statistics processing system of a cross-border e-commerce is provided, the system is applied to a cross-border e-commerce server, and the system comprises:

The communication unit is used for receiving the cross-border logistics information sent by the terminal equipment, and the cross-border logistics information comprises: order number, recipient, address and communication phone;

The processing unit is used for extracting the position coordinates corresponding to the terminal equipment, extracting the country corresponding to the terminal equipment according to the position coordinates, extracting the mother language corresponding to the country, and extracting the translator corresponding to the mother language and the storage language if the mother language is inconsistent with the storage language of the database;

and the translation storage unit is used for calling the translator by the server, performing operation by taking the address in the cross-border logistics information as input data of the translator to obtain the address translated by the address, wherein the translated address is the address recorded by the storage language, and storing the order number, the receiver, the translated address and the communication telephone in the database.

In a third aspect, the present application provides a computer storage medium storing a computer program for electronic data exchange, wherein the computer program causes a computer to perform part or all of the steps described in the first aspect of the application.

The embodiment of the application has the following beneficial effects:

The technical scheme provided by the application is that the cross-border e-commerce server receives cross-border logistics information sent by terminal equipment, and the cross-border logistics information comprises: order number, recipient, address and communication phone; the cross-border e-commerce server extracts a position coordinate corresponding to the terminal equipment, extracts a country corresponding to the terminal equipment according to the position coordinate, extracts a native language corresponding to the country, and extracts a translator corresponding to the native language and the storage language if the native language is inconsistent with the storage language of the database; and the cross-border e-commerce server calls the translator, performs operation on the address in the cross-border logistics information as input data of the translator to obtain the address translated by the address, wherein the translated address is the address recorded by the storage language, and stores the order number, the receiver, the translated address and the communication telephone in a database. Only the address in the cross-border e-commerce logistics information is the information with the specific language, the receiver can directly use the corresponding native language mark, and the communication telephone and the order number belong to Arabic numerals, so that translation is not needed, only the address is needed to be translated, the information stored in the cross-border e-commerce server can be the information matched with the stored language, and the translator is automatically matched through the country of the identification terminal equipment, so that language identification is not needed for the address information, the calculation amount of language matching is reduced, unified processing of different languages is realized, and the cost of data storage is reduced.

Drawings

In order to more clearly illustrate the embodiments of the application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

Fig. 1 is a schematic structural diagram of a cross-border e-commerce system according to an embodiment of the present application;

Fig. 2 is a flow chart of a data statistics processing method of a cross-border electronic commerce provided by the embodiment of the application;

Fig. 3 is a block diagram of a data statistics processing system of a cross-border electronic commerce according to an embodiment of the present application.

Detailed Description

In order that those skilled in the art will better understand the present application, a technical solution in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

The terms first, second and the like in the description and in the claims and in the above-described figures are used for distinguishing between different objects and not necessarily for describing a sequential or chronological order. Furthermore, the terms "comprise" and "have," as well as any variations thereof, are intended to cover a non-exclusive inclusion. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those listed steps or elements but may include other steps or elements not listed or inherent to such process, method, system, article, or apparatus.

Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.

The following description will first be made of the relevant terms that the present application relates to.

Database: for storing computer data for querying and using by the code during execution.

Memory database: the database connected with the unit test is started when the unit test is started each time, and the unit test is ended when the unit test is ended.

Class: program code files.

The class method comprises the following steps: an entry in the program code file may be used to execute a particular piece of code logic by calling a class method.

SANDBOX: JAVAAGENT tools capable of executing specific commands when class methods are called.

SQL: a script is executed in a database through a JDBC interface, and can be used to add data, delete data, modify data and query data.

The following describes the system architecture of the cross-border electronic commerce according to the embodiment of the application.

The application also provides a system of the cross-border electronic commerce, which comprises: the cross-border e-commerce server 10 and the plurality of terminal devices 20 are as shown in fig. 1, the cross-border e-commerce server 10 is connected with the plurality of terminal devices 20 through a wireless network, and the cross-border e-commerce server 10 comprises at least one processor (processor) 11 and a memory (memory) 12, and can also comprise a communication interface (Communications Interface) 14, a display screen 16 and a bus 13. The processor 11, the memory 12, the display screen 16 and the communication interface 14 may communicate with each other via the bus 13. The communication interface 14 may transmit information, and the communication interface 14 may have a wireless communication function, and the wireless communication function may be a short-range wireless communication function or a long-range communication function (for example, LTE or NR system). The processor 11 may invoke logic instructions in the memory 12 to perform or support the method in embodiments of the present application.

Further, the logic instructions in the memory 12 described above may be implemented in the form of software functional units and stored in a computer readable storage medium when sold or used as a stand alone product.

The memory 12, as a computer readable storage medium, may be configured to store a software program, a computer executable program, such as program instructions or modules corresponding to the methods in the embodiments of the present disclosure. The processor 11 performs functional applications as well as data processing, i.e. implements or supports the methods of embodiments of the present application, by running software programs, instructions or modules stored in the memory 12.

The terminal device 20 may specifically be: the computer equipment and the mobile terminal equipment are terminal equipment with stronger data processing capability.

The above-mentioned cross-border e-commerce server 10 may be a single server device, and as shown in fig. 1, the cross-border e-commerce server is a single server device. Of course, in an optional application scenario, the cross-border e-commerce server 10 may be a server cluster, and the server cluster may be a distributed server or a cloud server, etc., which is not limited by the connection relationship or the division of functions between the servers.

The specific method is described in detail below.

Referring to fig. 2, the present application further provides a method for processing data statistics of a cross-border e-commerce, and fig. 2 is a flow chart of the method for processing data statistics of a cross-border e-commerce provided by the present application, where the method may be executed under a system architecture of a cross-border e-commerce as shown in fig. 1, specifically, the method as shown in fig. 2 may be executed by a cross-border e-commerce server and a terminal device of a system architecture of a cross-border e-commerce in cooperation, and the method as shown in fig. 2 includes the following steps:

Step 201, a cross-border e-commerce server receives cross-border logistics information sent by a terminal device, where the cross-border logistics information includes: order number, recipient, address and communication phone:

the communication telephone may be a telephone number that does not include an international area code, although in an alternative application scenario, the telephone number may be a telephone number that includes an international area code. For example, U.S. Pat. No. 001, japanese Pat. No. 081, and so forth.

Step S202, a cross-border e-commerce server extracts a position coordinate corresponding to the terminal equipment, extracts a country corresponding to the terminal equipment according to the position coordinate, extracts a native language corresponding to the country, and extracts a translator corresponding to the native language and a storage language of a database if the native language is inconsistent with the storage language;

For example, the method may further include:

and extracting the international area code of the communication telephone, extracting a first language corresponding to the international area code according to the mapping relation between the international area code and the language, and executing the follow-up steps if the first language is consistent with the native language.

Step S203, the cross-border e-commerce server calls the translator, and uses the address in the cross-border logistics information as input data of the translator to perform operation to obtain the address translated by the address, wherein the translated address is the address recorded by the storage language, and the order number, the receiver, the translated address and the communication telephone are stored in a database.

For example, the method may further include:

The cross-border e-commerce server periodically detects data in the database to determine abnormal data in the database, marks the abnormal data, acquires an operation program corresponding to the period detection of the last period, and performs fault location on the abnormal data to determine an abnormal operation program.

For example, the method may further include:

And constructing a test database by the cross-border E-commerce server, clearing all data in the test database when the fault positioning is executed, storing the first data of the previous period and the second data of the current period of the abnormal data in the test database, extracting the running program, executing the running program on the test database to obtain an execution result of each execution step, and determining that the script of the running program is wrong if the execution result is consistent with the second data.

For example, the database may be an SQL database, and the running program may be a delete, query, insert, or the like command.

For example, when the database is an SQL database, the method may further include:

When the cross-border e-commerce server executes the SQL script, the execution mirror process forms execution data of the SQL script, and after the SQL script is abnormal, the SQL fault test environment is simulated to execute the SQL script on the execution data to determine whether the SQL script is abnormal.

According to the technical scheme, the abnormality of the SQL script can be detected through the execution data obtained by the mirror system flow, and the stability of the SQL database is improved.

The above manner of how to simulate the SQL fault test environment can be to execute the SQL script by the execution data alone, and the specific execution manner can be see the specification of the SQL database, for example, DELETE, insert, query and the like commands of the SQL database can be called.

The executing data for forming the SQL script by executing the mirror process specifically may include:

The cross-border e-commerce server receives the SQL call class code, calls SANDBOX to execute an SQL script (such as query, delete and insert command), SANDBOX intercepts the SQL script, SANDBOX sends a reverse push SQL capture data request to the SQL database, SANDBOX receives first capture data returned by the SQL database, SANDBOX sends a record data request to an external receiving end, SANDBOX gives up intercepting the SQL script, sends a request for executing a real SQL script to the SQL database, SANDBOX receives data returned by the SQL database, returns an SQL script execution result, and stores the first capture data as execution data of the SQL script.

According to the technical scheme, when the SQL script is executed, interception of the SQL script is firstly carried out before the SQL script is executed, and data in the SQL database is original data at the moment, so that the SQL script is virtually executed once, the virtually executed grabbing data is returned, and then the actual processing result of the SQL script is returned when the SQL script is actually operated.

Referring to fig. 3, fig. 3 is a schematic structural diagram of a data statistics processing system of a cross-border e-commerce, where the system is applied to a cross-border e-commerce server, and the system includes:

the communication unit 301 is configured to receive cross-border logistics information sent by a terminal device, where the cross-border logistics information includes: order number, recipient, address and communication phone;

the processing unit 302 is configured to extract a location coordinate corresponding to the terminal device, extract a country corresponding to the terminal device according to the location coordinate, extract a native language corresponding to the country, and if the native language is inconsistent with a storage language of the database, extract a translator corresponding to the native language and the storage language;

And a translation storage unit 303, configured to call the translator, perform an operation with the address in the cross-border logistics information as input data of the translator to obtain a translated address of the address, where the translated address is an address entered by using the storage language, and store the order number, the recipient, the translated address, and the communication phone in a database.

By way of example only, the present invention is directed to a method of,

The communication telephone includes an international area code;

the processing unit is further configured to extract an international area code of the communication phone, extract a first language corresponding to the international area code according to a mapping relationship between the international area code and the language, and execute the step of determining whether the storage language of the native language and the database is consistent if the first language is consistent with the native language.

Illustratively, the system further comprises:

The detecting unit 304 is configured to periodically detect data in the database to determine abnormal data in the database, mark the abnormal data, obtain an operation program corresponding to the previous period detection, and perform fault location on the abnormal data to determine an abnormal operation program.

Illustratively, the system further comprises:

The positioning unit 305 is configured to construct a test database, clear all data in the test database when the fault positioning is performed, store the first data of the previous cycle and the second data of the current cycle of the abnormal data in the test database, extract the running program, perform the running program on the test database to obtain an execution result of each execution step, and determine that the script of the running program is wrong if the execution result is consistent with the second data.

By way of example only, the present invention is directed to a method of,

The database is an SQL database, and the running program is a deletion command, a query command and an insertion command.

The embodiment of the application can divide the functional units of the electronic device according to the method example, for example, each functional unit can be divided corresponding to each function, and two or more functions can be integrated in one processing unit. The integrated units may be implemented in hardware or in software functional units. It should be noted that, in the embodiment of the present application, the division of the units is schematic, which is merely a logic function division, and other division manners may be implemented in actual practice.

The above embodiments may be implemented in whole or in part by software, hardware, firmware, or any other combination. When implemented in software, the above-described embodiments may be implemented in whole or in part in the form of a computer program product. The computer program product comprises one or more computer instructions or computer programs. When the computer instructions or computer program are loaded or executed on a computer, the processes or functions described in accordance with embodiments of the present application are produced in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from one website site, computer, server, or data center to another website site, computer, server, or data center by wired or wireless means. The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains one or more sets of available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium. The semiconductor medium may be a solid state disk.

The embodiment of the application also provides a computer storage medium, wherein the computer storage medium stores a computer program for electronic data exchange, and the computer program makes a computer execute part or all of the steps of any one of the above method embodiments, and the computer includes an electronic device.

Embodiments of the present application also provide a computer program product comprising a non-transitory computer-readable storage medium storing a computer program operable to cause a computer to perform part or all of the steps of any one of the methods described in the method embodiments above. The computer program product may be a software installation package, said computer comprising an electronic device.

It should be understood that, in various embodiments of the present application, the sequence numbers of the foregoing processes do not mean the order of execution, and the order of execution of the processes should be determined by the functions and internal logic thereof, and should not constitute any limitation on the implementation process of the embodiments of the present application.

In the several embodiments provided in the present application, it should be understood that the disclosed method, apparatus and system may be implemented in other manners. For example, the device embodiments described above are merely illustrative; for example, the division of the units is only one logic function division, and other division modes can be adopted in actual implementation; for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.

The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may be physically included separately, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in hardware plus software functional units.

The integrated units implemented in the form of software functional units described above may be stored in a computer readable storage medium. The software functional unit is stored in a storage medium, and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: u disk, removable hard disk, magnetic disk, optical disk, volatile memory or nonvolatile memory. The nonvolatile memory may be a read-only memory (ROM), a Programmable ROM (PROM), an erasable programmable ROM (erasable PROM), an electrically erasable programmable EPROM (EEPROM), or a flash memory. The volatile memory may be random access memory (random access memory, RAM) which acts as external cache memory. By way of example, and not limitation, many forms of random access memory (random access memory, RAM) are available, such as static random access memory (STATIC RAM, SRAM), dynamic Random Access Memory (DRAM), synchronous Dynamic Random Access Memory (SDRAM), double data rate synchronous dynamic random access memory (double DATA RATE SDRAM, DDR SDRAM), enhanced synchronous dynamic random access memory (ENHANCED SDRAM, ESDRAM), synchronous link dynamic random access memory (SYNCHLINK DRAM, SLDRAM), and direct memory bus random access memory (direct rambus RAM, DR RAM). Etc. various media in which program code may be stored.

Although the present invention is disclosed above, the present invention is not limited thereto. Variations and modifications, including combinations of the different functions and implementation steps, as well as embodiments of the software and hardware, may be readily apparent to those skilled in the art without departing from the spirit and scope of the invention.

Claims

1. The data statistical processing method of the cross-border electronic commerce is characterized by comprising the following steps of:

The cross-border e-commerce server calls the translator, and uses the address in the cross-border logistics information as input data of the translator to execute operation to obtain the address translated by the address, wherein the translated address is the address recorded by the storage language, and the order number, the receiver, the translated address and the communication telephone are stored in a database;

The cross-border e-commerce server periodically detects data in the database to determine abnormal data in the database, marks the abnormal data, acquires an operation program corresponding to the period detection of the last period, and performs fault location on the abnormal data to determine an abnormal operation program;

the database is an SQL database, and the method further comprises:

When the cross-border e-commerce server executes the SQL script, executing the mirror process to form execution data of the SQL script, and after the SQL script is abnormal, simulating the SQL fault test environment to execute the SQL script on the execution data to determine whether the SQL script is abnormal;

the execution data for forming the SQL script by executing the mirror process specifically comprises:

The method comprises the steps that a cross-border e-commerce server receives SQL call class codes, calls SANDBOX to execute an SQL script, SANDBOX intercepts the SQL script, SANDBOX sends a reverse pushing SQL grabbing data request to an SQL database, SANDBOX receives first grabbing data returned by the SQL database, SANDBOX sends a recording data request to an external receiving end, SANDBOX gives up the interception of the SQL script, sends a real SQL script executing request to the SQL database, SANDBOX receives data returned by the SQL database, returns an SQL script executing result, and stores the first grabbing data as executing data of the SQL script;

The running program is a deletion command, a query command and an insertion command.

2. The method for processing data statistics of cross-border e-commerce according to claim 1, further comprising:

The communication telephone includes an international area code;

Extracting the international area code of the communication telephone, extracting a first language corresponding to the international area code according to the mapping relation between the international area code and the language, and executing the step of judging whether the storage languages of the native language and the database are consistent if the first language is consistent with the native language.

3. A data statistics processing system of a cross-border e-commerce, wherein the system is applied to a cross-border e-commerce server, the system comprising:

The translation storage unit is used for calling the translator by the server, performing operation on the address in the cross-border logistics information as input data of the translator to obtain a translated address of the address, wherein the translated address is an address recorded by adopting the storage language, and storing an order number, a receiver, the translated address and a communication telephone in a database;

The detection unit is used for periodically detecting the data in the database to determine abnormal data in the database, marking the abnormal data, acquiring an operation program corresponding to the period detection, and performing fault location on the abnormal data to determine an abnormal operation program;

The database is an SQL database,

The cross-border e-commerce server is also used for executing the mirror process to form execution data of the SQL script when the SQL script is executed, and simulating the SQL fault test environment to execute the SQL script on the execution data to determine whether the SQL script is abnormal after the SQL script is abnormal;

4. The data statistics processing system of the cross-border e-commerce of claim 3,

The communication telephone includes an international area code;