Data interaction method and system for code scanning shopping

Abstract

The invention provides a data interaction method and a system for code scanning shopping, which is used for data interaction between a code scanning shopping system and a merchant terminal. The invention is characterized by in that a data interaction layer is used for communication between a server of the code scanning shopping system and a database of the merchant terminal. The communication between the data interaction layer and the server adopts an MQTT protocol in a publishing / subscribing mode; the communication between the data interaction layer and the database is directly accessed by adopting an SQL (Structured Query Language) method. According to the invention, the load of the server is effectively reduced, the server can be concentrated in order response and processing, the transaction speed is accelerated, the data used by the server in order amount calculation can be timely and automatically updated, the transaction accuracy is ensured, an identity verification mechanism is added in data access, and the data transaction safety is improved.

Description

technical field [0001] The present invention relates to the technical field of data interaction, and specifically refers to a data interaction method and system for shopping by scanning a code. Background technique [0002] In recent years, with the rapid development of the Internet of Things and the popularization of new mobile social software such as WeChat, the new shopping mode of self-service retail business has gradually emerged. Scanning code shopping is one of the core functions of self-service retail, and it is also the key technical support of "smart retail". The basic process is: users scan the barcodes of the products they want to buy with mobile devices such as mobile phones and tablets in merchants that support scanning code shopping, such as shopping centers and supermarkets, and then they can view product information, understand product recommendations, self-generate orders and checkout . At the same time, merchants can also push preferential information, p...

AI Technical Summary

Problems solved by technology

[0003] However, in the application process of the existing scanning code shopping system, there are some phenomena that affect the user's scanning code shopping experience, including the hardware configuration of the mobile device, 4G or Wi-Fi signal strength and bandwidth, and self-service within a certain period of time. External factors such as the number of shopping users, the core design of the system itself, such as figure 1 Shown is the communication process between the payment device and the system server in the existing system. The interactive operation design between the system server and the database is relatively simple, and there are the following shortcomings:

[0004] (1) Direct interaction between the system server and the database. Although this method is relatively easy to implement, it cannot separate the server from the low-speed and frequent database operations, which may cause the server to be overloaded and affect the efficiency of scanning code shopping

[0005] (2) Failure to consider the problem of timely and efficient update of server product information may cause the server to use expired and wrong data when calculating the order amount

[0006] (3) It does not take into account the fact that the server and the merchant terminal are deployed in different networks, and its practicability may be limited in some occasions

Shopping by scanning codes involves financial activities and has relatively high risks

Images