CN117875816A - Cross-border E-business data statistical processing method and system - Google Patents
Cross-border E-business data statistical processing method and system Download PDFInfo
- Publication number
- CN117875816A CN117875816A CN202410028900.0A CN202410028900A CN117875816A CN 117875816 A CN117875816 A CN 117875816A CN 202410028900 A CN202410028900 A CN 202410028900A CN 117875816 A CN117875816 A CN 117875816A
- Authority
- CN
- China
- Prior art keywords
- cross
- border
- data
- language
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 7
- 238000004891 communication Methods 0.000 claims abstract description 43
- 238000000034 method Methods 0.000 claims abstract description 43
- 239000000284 extract Substances 0.000 claims abstract description 30
- 238000012545 processing Methods 0.000 claims description 31
- 230000002159 abnormal effect Effects 0.000 claims description 22
- 238000012360 testing method Methods 0.000 claims description 22
- 238000001514 detection method Methods 0.000 claims description 5
- 238000013519 translation Methods 0.000 claims description 5
- 238000013507 mapping Methods 0.000 claims description 4
- 238000012217 deletion Methods 0.000 claims description 3
- 230000037430 deletion Effects 0.000 claims description 3
- 238000003780 insertion Methods 0.000 claims description 3
- 230000037431 insertion Effects 0.000 claims description 3
- 230000006870 function Effects 0.000 description 12
- 238000004590 computer program Methods 0.000 description 11
- 244000035744 Hura crepitans Species 0.000 description 6
- 230000001360 synchronised effect Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000013500 data storage Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
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
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 data statistics processing method and system for the cross-border electronic commerce can achieve unified processing of different languages, and therefore cost of data statistics is reduced.
In a first aspect, the present application provides a method for processing data statistics of a cross-border e-commerce, where the method includes 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 some or all of the steps as described in the first aspect of the present application.
The embodiment of the application has the following beneficial effects:
according to the technical scheme, 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 present 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 below, it being obvious that the drawings in the following description are only some embodiments of the present 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 provided in 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 in an embodiment of the present 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 to make the present application solution better understood by those skilled in the art, the following description will clearly and completely describe the technical solution in the embodiments of the present application with reference to the accompanying drawings in the embodiments of the present application, and 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 one of ordinary skill in the art based on the embodiments herein without making any inventive effort, are intended to be within the scope of the present application.
The terms first, second and the like in the description and in the claims of the present application and in the above-described figures, are used for distinguishing between different objects and not for describing a particular sequential 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 present 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 are referred to in this application.
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: a java agent tool 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 e-commerce according to the embodiments of the present 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 methods of 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 executes functional applications and data processing, i.e. implements or supports the methods of the 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 above-mentioned cross-border e-commerce server 10 may be a server cluster, and the above-mentioned server cluster may be a distributed server or a cloud server, etc., where the connection relationship or the division of functions between the servers is not limited in this application.
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 in 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.
According to the technical scheme, 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.
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 method comprises the steps that a cross-border e-commerce server receives SQL call class codes, calls SANDBOX to execute an SQL script (such as inquiring, deleting and inserting commands), the SANDBOX intercepts the SQL script, sends a reverse pushing SQL grabbing data request to an SQL database, the SANDBOX receives first grabbing data returned by the SQL database, sends a recording data request to an external receiving end, the SANDBOX gives up intercepting the SQL script, sends a real SQL script executing request to the SQL database, the 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.
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 may divide the functional units of the electronic device according to the above method example, for example, each functional unit may be divided corresponding to each function, or two or more functions may 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 the embodiments of the present application are all or partially produced. 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, where the computer storage medium stores a computer program for electronic data exchange, where the computer program causes a computer to execute part or all of the steps of any one of the methods described in the embodiments of the method, where 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 some 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 PROM (EPROM), an electrically Erasable EPROM (EEPROM), or a flash memory. The volatile memory may be random access memory (random access memory, RAM) which acts as an external cache. By way of example but not limitation, many forms of random access memory (random access memory, RAM) are available, such as Static RAM (SRAM), dynamic Random Access Memory (DRAM), synchronous Dynamic Random Access Memory (SDRAM), double data rate synchronous dynamic random access memory (DDR SDRAM), enhanced Synchronous Dynamic Random Access Memory (ESDRAM), synchronous Link DRAM (SLDRAM), and direct memory bus 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 (10)
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 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.
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. The method for processing data statistics of cross-border e-commerce according to claim 1, further comprising:
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.
4. The method for data statistics processing of a cross-border e-commerce according to claim 3, wherein,
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.
5. The method for data statistics processing of a cross-border e-commerce according to claim 4, wherein,
the database is an SQL database, and the running program is a deletion command, a query command and an insertion command.
6. 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 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.
7. The system for data statistics processing for a cross-border e-commerce of claim 6,
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.
8. The cross-border e-commerce data statistics processing system of claim 6, further comprising:
the detection unit is used for periodically detecting the data in the database to determine the abnormal data in the database, marking the abnormal data, acquiring the running program corresponding to the period detection of the previous period, and performing fault location on the abnormal data to determine the abnormal running program.
9. The cross-border e-commerce data statistics processing system of claim 8, further comprising:
and the positioning unit is used for constructing a test database, 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.
10. The system for data statistics processing for a cross-border e-commerce according to claim 9,
the database is an SQL database, and the running program is a deletion command, a query command and an insertion command.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410028900.0A CN117875816A (en) | 2024-01-05 | 2024-01-05 | Cross-border E-business data statistical processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410028900.0A CN117875816A (en) | 2024-01-05 | 2024-01-05 | Cross-border E-business data statistical processing method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117875816A true CN117875816A (en) | 2024-04-12 |
Family
ID=90596528
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410028900.0A Pending CN117875816A (en) | 2024-01-05 | 2024-01-05 | Cross-border E-business data statistical processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117875816A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002003241A1 (en) * | 2000-07-05 | 2002-01-10 | Iis Inc. | Method for performing multilingual translation through a communication network and a communication system and information recording medium for the same method |
| WO2002033607A1 (en) * | 2000-10-16 | 2002-04-25 | Iis Inc. | Method for offering multilingual information translated in many languages through a communication network |
| US20140372099A1 (en) * | 2013-06-17 | 2014-12-18 | Ilya Ronin | Cross-lingual e-commerce |
| CN106202061A (en) * | 2016-06-28 | 2016-12-07 | 大连民族大学 | Chinese-English illiteracy towards cross-border e-commerce platform is hidden and is tieed up multi-lingual machine translation system and method |
| CN106250178A (en) * | 2016-07-26 | 2016-12-21 | 北京北森云计算股份有限公司 | The method that system dynamics function intercepts extension online is realized by the compiling of multilingual cloud |
| CN106557905A (en) * | 2016-11-25 | 2017-04-05 | 王四春 | A kind of international logistics electric business marketing platform |
| CN106557904A (en) * | 2016-11-10 | 2017-04-05 | 夏飞 | A kind of cross-border electric business grid warehouse logistics system |
| CN208752671U (en) * | 2018-11-06 | 2019-04-16 | 唐红祥 | A kind of cross-border electric business logistic optmum platform |
-
2024
- 2024-01-05 CN CN202410028900.0A patent/CN117875816A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002003241A1 (en) * | 2000-07-05 | 2002-01-10 | Iis Inc. | Method for performing multilingual translation through a communication network and a communication system and information recording medium for the same method |
| WO2002033607A1 (en) * | 2000-10-16 | 2002-04-25 | Iis Inc. | Method for offering multilingual information translated in many languages through a communication network |
| US20140372099A1 (en) * | 2013-06-17 | 2014-12-18 | Ilya Ronin | Cross-lingual e-commerce |
| CN106202061A (en) * | 2016-06-28 | 2016-12-07 | 大连民族大学 | Chinese-English illiteracy towards cross-border e-commerce platform is hidden and is tieed up multi-lingual machine translation system and method |
| CN106250178A (en) * | 2016-07-26 | 2016-12-21 | 北京北森云计算股份有限公司 | The method that system dynamics function intercepts extension online is realized by the compiling of multilingual cloud |
| CN106557904A (en) * | 2016-11-10 | 2017-04-05 | 夏飞 | A kind of cross-border electric business grid warehouse logistics system |
| CN106557905A (en) * | 2016-11-25 | 2017-04-05 | 王四春 | A kind of international logistics electric business marketing platform |
| CN208752671U (en) * | 2018-11-06 | 2019-04-16 | 唐红祥 | A kind of cross-border electric business logistic optmum platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109446063A (en) | Interface test method, device, computer equipment and storage medium | |
| KR102024694B1 (en) | Decentralized service platform using multiple service nodes based on block chain | |
| CN111125175B (en) | Service data query method and device, storage medium and electronic device | |
| CN112954043B (en) | Method for identifying user based on website access log and computer equipment | |
| CN110245505A (en) | Tables of data access method, device, computer equipment and storage medium | |
| CN111597110A (en) | Page testing method and device, electronic equipment and storage medium | |
| CN113726770A (en) | Data interception method and device, computer equipment and storage medium | |
| CN112699034B (en) | Virtual login user construction method, device, equipment and storage medium | |
| CN107908565B (en) | Test method and test equipment | |
| CN112115041B (en) | Dynamic point embedding method and device for application program, storage medium and computer equipment | |
| CN111026613B (en) | Log processing method and device | |
| CN101577713A (en) | Realization method, device and testing system for virtual user identification module | |
| CN113626449A (en) | Data storage method, data query method and related equipment | |
| CN112650689A (en) | Test method, test device, electronic equipment and storage medium | |
| CN117875816A (en) | Cross-border E-business data statistical processing method and system | |
| CN108647139B (en) | System test method, device, storage medium and electronic device | |
| CN109995931B (en) | Method and device for realizing automatic calling | |
| CN115408481A (en) | Multi-dimensional address processing method and device, computer equipment and storage medium | |
| CN109254858A (en) | Data sharing method, device, equipment and the storage medium of active window | |
| CN109348053B (en) | Telephone number mark processing method, server, terminal device and computer readable storage medium | |
| CN109656805B (en) | Method and device for generating code link for business analysis and business server | |
| CN111143644B (en) | Identification method and device of Internet of things equipment | |
| CN110750511A (en) | Operation history restoration method and device, computer equipment and storage medium | |
| CN111538651A (en) | Interface testing method, device, server and storage medium | |
| CN111339390A (en) | Method, computing device and storage medium for crawling information based on fixed-line telephone |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |