Commodity information update processing method and its device, equipment, medium, and product
By locking and updating the product information set version of the local database in the Internet e-commerce live broadcast room, the performance bottleneck problem of business servers identifying products under high concurrency is solved, real-time identification and rapid update are achieved, and shopping experience and system robustness are improved. sex.
Patent Information
- Application Number
- CN202111647312.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-30
- Publication Date
- 2024-12-06
- Estimated Expiration
- 2041-12-30
AI Technical Summary
In the live broadcast room of the Internet e-commerce, due to the high demand for concurrent chat text recognition, the business server has caused a bottleneck in database performance, making it difficult to identify the products pushed by buyers in real time, affecting the shopping experience.
By storing the product information set version identified by the live broadcast room in the local database, if the old version is locked, the local data lock is queried, and the latest version of the cache server is queried and the latest version is updated; if the cache database has no latest version, the cache data lock is locked, and the source data server is queried. The latest version and update to finally generate product orders in the local database.
It improves the efficiency of product identification business, prevents cache servers from crashing, ensures data consistency, and improves the update speed of product information and shopping experience in the live broadcast room.
Smart Images

Figure CN114328555B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of Internet e-commerce, and in particular to a method for updating and processing product information, and also to corresponding devices, equipment, non-volatile storage media and computer program products of the method. Background Art
[0002] In the Internet e-commerce platform, merchant users in the platform can sell goods in the live broadcast room by opening a live broadcast room; in the existing e-commerce live broadcast room, it is usually possible to identify the goods represented in the chat text pushed by the buyer user. The merchant user sets the goods he sells and the corresponding keywords of the goods in the live broadcast room. When the buyer user pushes the chat text, the chat text will be identified to determine the goods that the buyer user wants to buy in the current live broadcast room, and then a product order with the identified target goods will be generated for the buyer.
[0003] When the business server identifies the product represented by the chat text, it needs to obtain all the product information pre-configured by the merchant user to identify the product that matches the chat text. However, there are a large number of audience users in the live broadcast room, and the business server needs to identify the high-concurrency chat text. It needs to continuously query all the product information in the live broadcast room from the database for identification. Due to the performance bottleneck of the database, the product identification service may easily cause the system to crash, making the business server unable to identify the product represented by the user's chat text, affecting the online shopping experience of buyers on the platform.
[0004] In view of the above-mentioned problems, the applicant has made corresponding explorations out of consideration of this issue. Summary of the invention
[0005] The purpose of the present application is to meet the needs of the prior art or overcome at least some of the shortcomings of the prior art and to provide a product information update processing method and its corresponding device, electronic device, non-volatile storage medium and computer program product.
[0006] In order to achieve the purpose of this application, the following technical solutions are adopted:
[0007] A method for updating product information proposed for the purpose of this application includes the following steps:
[0008] In response to a product identification event of a chat text pushed by a viewer in the current live broadcast room, determine the live broadcast room identifier corresponding to the event, and check the version of the product information set corresponding to the live broadcast room identifier in the local database;
[0009] When the version of the product information set stored in the local database is an old version, a local data lock acting on the local database is triggered, and after the latest version of the product information set stored in the cache database of the cache server is queried and stored in the local database, the local data lock is released;
[0010] When the latest version of the product information set does not exist in the cache database, the cache server is driven to trigger a cache data lock acting on the cache database, and after the latest version of the product information set in the source database of the source data server is queried and stored in the cache database and the local database, the cache data lock and the local data lock are released;
[0011] According to the multiple product feature information contained in the product information set of the latest version of the current live broadcast room in the local database, the target product feature information corresponding to the chat text is identified, and product order information containing the target product feature information is generated.
[0012] In a further embodiment, the step of responding to a commodity identification event of a chat text pushed by a viewer in the current live broadcast room, determining the live broadcast room identifier corresponding to the event, and checking the version of the commodity information set corresponding to the live broadcast room identifier in the local database includes the following steps performed by the business server:
[0013] In response to the product identification event, determine the live broadcast room identifier corresponding to the product identification event;
[0014] Querying the local database whether there is a product information set corresponding to the live broadcast room identifier, and if not, triggering a local data lock acting on the local database;
[0015] The latest version of the product information set corresponding to the live broadcast room identifier is queried from the cache database of the cache server and stored in the local database, thereby releasing the local data lock.
[0016] In a further embodiment, the step of responding to a commodity identification event of a chat text pushed by a viewer in the current live broadcast room, determining the live broadcast room identifier corresponding to the event, and checking the version of the commodity information set corresponding to the live broadcast room identifier in the local database includes the following steps performed by the business server:
[0017] In response to the product identification event, determine the live broadcast room identifier corresponding to the product identification event;
[0018] Querying the local database whether there is a product information set corresponding to the live broadcast room identifier, and if so, pushing a version verification instruction acting on the product information set to the cache server;
[0019] Receive the version verification result pushed by the cache server in response to the version detection verification instruction, and when the version verification result indicates that the product information set is the latest version, identify the product feature information corresponding to the chat text and the product information set to generate product order information containing the product feature information.
[0020] In a further embodiment, when the version of the product information set stored in the local database is an old version, triggering a local data lock acting on the local database, querying the latest version of the product information set stored in the cache database of the cache server and storing it in the local database, the step of releasing the local data lock includes the following steps performed by the business server:
[0021] Deleting the old version of the product information set stored in the local database, triggering a local data lock acting on the local database;
[0022] Generate an information acquisition instruction for acquiring the latest version of the commodity information set corresponding to the live broadcast room identification lock and push it to the cache server;
[0023] The latest version of the product information set in the cache database pushed by the cache server in response to the acquisition instruction is stored in the local database, the local data lock is released, and the product identification of the chat text is performed.
[0024] In a further embodiment, the step of driving the cache server to trigger the cache data lock acting on the cache database, querying the source database of the source data server to store the latest version of the product information set in the cache database and the local database, and then releasing the cache data lock and the local data lock includes the following steps performed by the cache server:
[0025] triggering a cache data lock acting on the cache database, and pushing a source information acquisition instruction for acquiring the commodity information set to the source data server;
[0026] storing the latest version of the product information set in the source database pushed by the source data server in response to the source information acquisition instruction into the cache database, and releasing the cache data lock;
[0027] The commodity information set is pushed to the business server, and the business server is driven to store the commodity information set in a local database to release the local data lock.
[0028] In a further embodiment, the step of identifying the target product feature information corresponding to the chat text based on the multiple product feature information contained in the product information set of the latest version of the current live broadcast room in the local database, and generating product order information containing the target product feature information includes the following steps performed by the business server:
[0029] Performing word segmentation processing on the chat text, and extracting a plurality of commodity words contained in the chat text;
[0030] According to the commodity keywords respectively included in the plurality of commodity feature information included in the commodity information set in the local database, respectively determining the target commodity keywords that match the respective commodity words among the commodity keywords;
[0031] Generate product order information including product feature information corresponding to the target product keyword.
[0032] A commodity information update processing device proposed for the purpose of this application includes:
[0033] An information set version detection module is used to respond to a commodity identification event of a chat text pushed by a viewer in the current live broadcast room, determine the live broadcast room identifier corresponding to the event, and check the version of the commodity information set corresponding to the live broadcast room identifier in the local database;
[0034] A cache information set acquisition module, used for triggering a local data lock acting on the local database when the version of the product information set stored in the local database is an old version, querying the latest version of the product information set stored in the cache database of the cache server and storing it in the local database, and then releasing the local data lock;
[0035] A source information set acquisition module, used to drive the cache server to trigger a cache data lock acting on the cache database when the latest version of the product information set does not exist in the cache database, query the source database of the source data server to store the latest version of the product information set in the cache database and the local database, and then release the cache data lock and the local data lock;
[0036] The product order generation module is used to identify the target product feature information corresponding to the chat text based on the multiple product feature information contained in the latest version of the product information set of the current live broadcast room in the local database, and generate product order information containing the target product feature information.
[0037] In a further embodiment, the information set version detection module includes:
[0038] A live broadcast room identification determination submodule, used to respond to the commodity identification event and determine the live broadcast room identification corresponding to the commodity identification event;
[0039] A local data lock triggering submodule is used to query whether the commodity information set corresponding to the live broadcast room identifier exists in the local database, and if not, trigger a local data lock acting on the local database;
[0040] The local data lock release submodule is used to query the latest version of the product information set corresponding to the live broadcast room identifier from the cache database of the cache server, store it in the local database, and release the local data lock.
[0041] In a preferred embodiment, the information set version detection module further includes:
[0042] A live broadcast room identification determination submodule, used to respond to the commodity identification event and determine the live broadcast room identification corresponding to the commodity identification event;
[0043] An information set version verification submodule is used to query whether the product information set corresponding to the live broadcast room identifier exists in the local database, and if so, push a version verification instruction acting on the product information set to the cache server;
[0044] The product order generation submodule is used to receive the version verification result pushed by the cache server in response to the version detection verification instruction. When the version verification result indicates that the product information set is the latest version, the product feature information corresponding to the chat text and the product information set is identified to generate product order information containing the product feature information.
[0045] In a further embodiment, the cache information set acquisition module includes:
[0046] An old information set deletion submodule is used to delete the old version of the commodity information set stored in the local database, triggering a local data lock acting on the local database;
[0047] An acquisition instruction push submodule is used to generate an information acquisition instruction for acquiring the latest version of the commodity information set corresponding to the live broadcast room identification lock and push it to the cache server;
[0048] The information set acquisition submodule is used to store the latest version of the product information set in the cache database pushed by the cache server in response to the acquisition instruction into the local database, release the local data lock, and perform product identification in the chat text.
[0049] In a further embodiment, the source information set acquisition module includes:
[0050] An information acquisition instruction push submodule, used for triggering a cache data lock acting on the cache database, and pushing a source information acquisition instruction for acquiring the commodity information set to the source data server;
[0051] A data lock release submodule, used to store the latest version of the product information set in the source database pushed by the source data server in response to the source information acquisition instruction into the cache database, and release the cache data lock;
[0052] The information set push submodule is used to push the commodity information set to the business server, and drive the business server to store the commodity information set in the local database to release the local data lock.
[0053] In a further embodiment, the commodity order generation module includes:
[0054] A commodity word extraction submodule, used for performing word segmentation processing on the chat text and extracting a plurality of commodity words contained in the chat text;
[0055] A keyword matching submodule, for determining target product keywords that match each of the product terms among the product keywords according to the product keywords respectively contained in the plurality of product feature information contained in the product information set in the local database;
[0056] The commodity order generation submodule is used to generate commodity order information including commodity feature information corresponding to the target commodity keyword.
[0057] An electronic device proposed to meet the purpose of the present application includes a central processing unit and a memory, wherein the central processing unit is used to call and run a computer program stored in the memory to execute the steps of the product information update processing method.
[0058] A non-volatile storage medium is proposed to meet the purpose of the present application, which stores a computer program implemented according to the product information update processing method. When the computer program is called and executed by a computer, the steps included in the corresponding method are executed.
[0059] In order to solve the above technical problems, an embodiment of the present application also provides a computer program product, including a computer program and computer instructions. When the computer program and computer instructions are executed by a processor, the processor executes the steps of the above-mentioned live broadcast data stratification prediction method or product information update processing method.
[0060] Compared with the prior art, the advantages of this application are as follows:
[0061] This application improves the efficiency of the business server in obtaining the latest version of product feature information for product identification by storing the latest version of the product information set belonging to the live broadcast room in the cache server, and at the same time stores the product feature information locally through the business server to prevent the cache server from crashing due to high-concurrency data acquisition requests, making it impossible for the business server to identify products in the chat text, affecting the online shopping experience of buyers who need to purchase products in the live broadcast room.
[0062] In addition, the product information set of the present application has its corresponding live broadcast room identification, and the product information set is updated by the live broadcast room as a unit. The product information of the live broadcast room can be updated by simple overwriting, which significantly improves the update speed of the product information set.
[0063] Furthermore, when any end of this method updates the product information set, it will trigger the data lock acting on its own data, and only open the permission to update the product information set to one thread, thereby ensuring the data consistency of the product information set stored by itself and improving the robustness of the chat text product recognition system.
[0064] Additional aspects and advantages of the present application will be partially given in the following description, which will become apparent from the following description, or will be understood through the practice of the present application. BRIEF DESCRIPTION OF THE DRAWINGS
[0065] The above and / or additional aspects and advantages of the present application will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:
[0066] Figure 1 A schematic diagram of a typical network deployment architecture related to implementing the technical solution of this application;
[0067] Figure 2 This is a flowchart of a typical embodiment of the product information update processing method of the present application;
[0068] Figure 3 A schematic diagram of a live broadcast room graphical user interface of a user terminal in the current live broadcast room of the present application;
[0069] Figure 4 A flowchart diagram of the specific implementation steps of the product information set corresponding to the live broadcast room identifier that does not exist in the local database in this application;
[0070] Figure 5 A flowchart diagram of the specific implementation steps for verifying the version of the product information set corresponding to the live broadcast room identifier in the local database in this application;
[0071] Figure 6A flowchart of the specific implementation steps for the business server to obtain the latest version of the product information set in this application;
[0072] Figure 7 A flowchart diagram of the specific implementation steps of the cache server obtaining the product information set corresponding to the live broadcast room identifier from the source data server in this application;
[0073] Figure 8 A flowchart of the specific implementation steps for identifying target commodities represented in chat texts according to the latest version of the commodity information set in this application;
[0074] Fig. 9 This is a principle block diagram of a typical embodiment of a commodity information update processing device of the present application;
[0075] Fig.10 This is a basic structural block diagram of a computer device according to an embodiment of the present application. DETAILED DESCRIPTION
[0076] The embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present application, and cannot be interpreted as limiting the present application.
[0077] It will be understood by those skilled in the art that, unless expressly stated, the singular forms "one", "said", and "the" used herein may also include plural forms. It should be further understood that the term "comprising" used in the specification of the present application refers to the presence of the features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or groups thereof. It should be understood that when we refer to an element as being "connected" or "coupled" to another element, it may be directly connected or coupled to the other element, or there may be an intermediate element. In addition, the "connection" or "coupling" used herein may include wireless connection or wireless coupling. The term "and / or" used herein includes all or any unit and all combinations of one or more associated listed items.
[0078] It will be understood by those skilled in the art that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as those generally understood by those skilled in the art to which this application belongs. It should also be understood that terms such as those defined in general dictionaries should be understood to have meanings consistent with those in the context of the prior art, and will not be interpreted with idealized or overly formal meanings unless specifically defined as here.
[0079] It will be understood by those skilled in the art that the "client", "terminal" and "terminal device" used herein include both devices with wireless signal receivers, which are devices with only wireless signal receivers without transmission capabilities, and devices with receiving and transmitting hardware, which are devices with receiving and transmitting hardware capable of two-way communication on a two-way communication link. Such devices may include: cellular or other communication devices such as personal computers, tablet computers, which have single-line displays or multi-line displays or cellular or other communication devices without multi-line displays; PCS (Personal Communications Service, personal communication system), which can combine voice, data processing, fax and / or data communication capabilities; PDA (Personal Digital Assistant, personal digital assistant), which may include a radio frequency receiver, pager, Internet / intranet access, web browser, notepad, calendar and / or GPS (Global Positioning System, global positioning system) receiver; conventional laptop and / or palmtop computers or other devices, which have and / or include a conventional laptop and / or palmtop computer or other device with and / or including a radio frequency receiver. The "client", "terminal" and "terminal device" used herein may be portable, transportable, installed in a vehicle (air, sea and / or land), or suitable for and / or configured to run locally, and / or in a distributed form, at any other location on the earth and / or in space. The "client", "terminal" and "terminal device" used herein may also be a communication terminal, an Internet terminal, a music / video playing terminal, for example, a PDA, a MID (Mobile Internet Device) and / or a mobile phone with a music / video playing function, or a smart TV, a set-top box and other devices.
[0080] The hardware referred to by the names such as "server", "client", and "service node" in this application is essentially an electronic device with the equivalent capabilities of a personal computer. It is a hardware device with the necessary components revealed by the von Neumann principle, such as a central processing unit (including an arithmetic unit and a controller), a memory, an input device, and an output device. The computer program is stored in its memory, and the central processing unit calls the program stored in the external memory into the internal memory for execution, executes the instructions in the program, and interacts with the input and output devices to complete specific functions.
[0081] It should be pointed out that the concept of "server" referred to in this application can also be extended to the case of server clusters. According to the network deployment principle understood by those skilled in the art, the servers should be logically divided. In physical space, these servers can be independent of each other but can be called through interfaces, or integrated into a physical computer or a set of computer clusters. Those skilled in the art should understand this flexibility, and should not use it to restrict the implementation of the network deployment method of this application.
[0082] See also Figure 1 , the hardware foundation required for the implementation of the relevant technical solutions of this application can be deployed according to the architecture shown in the figure. The server 80 referred to in this application is deployed in the cloud. As a business server, it can be responsible for further connecting relevant data servers and other servers that provide relevant support, etc., to form a logically related service cluster to provide services for related terminal devices such as the smartphone 81 and personal computer 82 shown in the figure or a third-party server (not shown). The smartphone and personal computer can access the Internet through a well-known network access method and establish a data communication link with the server 80 in the cloud to run terminal applications related to the services provided by the server.
[0083] For the server, the application is usually constructed as a service process, opening the corresponding program interface for remote calls by applications running on various terminal devices. The relevant technical solutions suitable for running on the server in this application can be implemented in the server in this way.
[0084] The application described herein refers to an application running on a server or terminal device. This application implements the relevant technical solutions of the present application in a programming manner. Its program code can be stored in a non-volatile storage medium recognizable by a computer in the form of computer executable instructions, and can be loaded into the memory by the central processing unit for execution. The relevant device of the present application is constructed by the operation of the application on the computer.
[0085] For the server, the application is usually constructed as a service process, opening the corresponding program interface for remote calls by applications running on various terminal devices. The relevant technical solutions suitable for running on the server in this application can be implemented in the server in this way.
[0086] The technical solution in this application suitable for implementation in terminal devices can also be programmed and built into an application that provides live broadcasting as part of its extended functions. The live broadcasting refers to a live broadcast room network service implemented based on the aforementioned network deployment architecture.
[0087] The live broadcast room referred to in this application refers to a video chat room implemented by Internet technology, which usually has audio and video broadcast control functions, including anchor users and audience users. Audience users can include registered users who have registered on the platform, or unregistered visitor users; they can be registered users who follow anchor users, or registered or unregistered users who do not follow anchor users. The anchor user and the audience user can interact through well-known online interactive methods such as voice, video, and text. Generally, the anchor user performs programs for the audience users in the form of audio and video streams, and economic transactions can also be generated during the interaction. Of course, the application form of the live broadcast room is not limited to online entertainment, but can also be extended to other related scenarios, such as education and training scenarios, video conferencing scenarios, product promotion and sales scenarios, and any other scenarios that require similar interactions.
[0088] Those skilled in the art should be aware that, although the various methods of the present application are described based on the same concept and thus present commonality to each other, unless otherwise specified, these methods can be independently executed. Similarly, for each embodiment disclosed in the present application, they are all proposed based on the same inventive concept, therefore, concepts with the same expression, and concepts that are appropriately changed for convenience despite different expressions, should be understood as equivalent.
[0089] Unless the mutually exclusive relationship between the embodiments to be disclosed in this application is explicitly stated, the relevant technical features involved in each embodiment can be cross-combined to flexibly construct a new embodiment, as long as such combination does not deviate from the creative spirit of this application and can meet the needs of the prior art or solve certain deficiencies in the prior art. Those skilled in the art should be aware of this flexibility.
[0090] See also Figure 2 , a product information update processing method of the present application, in its typical embodiment, comprises the following steps:
[0091] Step S11, responding to the commodity identification event of the chat text pushed by the audience terminal in the current live broadcast room, determining the live broadcast room identifier corresponding to the event, and checking the version of the commodity information set corresponding to the live broadcast room identifier in the local database:
[0092] The business server collects the chat text pushed by any audience in the current live broadcast room, responds to the product recognition event for product keyword recognition of the chat text, and then determines the live broadcast room identifier of the current live broadcast room to verify whether the version of the product information set corresponding to the live broadcast room identifier stored in the local database is the latest version.
[0093] The chat text generally refers to the text sent by the audience in the current live broadcast room to the public screen chat area in its graphical user interface. For details, please refer to Figure 3 The audience terminal sends the chat text to the public screen chat area 301 to indicate the goods that the anchor user in the current live broadcast room needs to purchase, thereby driving the business server to generate product order information for the audience terminal based on the chat text pushed by the audience terminal, which contains the product feature information of the goods indicated in the chat text.
[0094] The product identification event refers to the business server identifying the product feature information corresponding to the chat text. The business server matches the chat text with the corresponding product feature information in the product information set through the product information set corresponding to the live broadcast room identifier corresponding to the current live broadcast room. The specific implementation method is described in the subsequent steps and will not be repeated in this step.
[0095] The local database is deployed in the business server, and the local database stores the product information sets from multiple products with corresponding live broadcast room identifiers. The product information set contains product feature information corresponding to multiple products contained in the live broadcast room corresponding to the live broadcast room identifier. The product feature information contains product keywords, product images, product prices, product names and other information, so that the subsequent business server can judge whether the product matches the chat text based on the product keywords contained in the product feature information, and when the product order information is subsequently generated, the product attributes are represented by the product images, product prices and product names contained in the product feature information.
[0096] In addition to the corresponding live broadcast room identifier, each of the product information sets also includes a version identifier used to characterize its version, so that the business server can determine the version corresponding to the product information set based on the version identifier of each of the product information sets.
[0097] After the business server determines the live broadcast room identifier corresponding to the product identification event, it will query the product information set corresponding to the live broadcast room identifier from the local database, and then compare the version identifiers of the product information set and the product information set corresponding to the live broadcast room identifier in the cache database of the cache server to see if they are the same. If they are the same, the chat text is identified as a product based on the product information set. If they are not the same, the local data lock acting on the local database is triggered to ensure the consistency of the product information set in the local database, and then the latest version of the product information set is obtained and stored in the local database, and then the local data lock is released, so that the chat text is identified as a product based on the latest version of the product information set.
[0098] Step S12: When the version of the product information set stored in the local database is an old version, a local data lock acting on the local database is triggered, and after the latest version of the product information set stored in the cache database of the cache server is queried and stored in the local database, the local data lock is released:
[0099] When the business server detects that the version of the product information set corresponding to the live broadcast room identifier of the current live broadcast room stored in the local database is an old version, the local data lock acting on the local database will be triggered, and the latest version of the product information set will be queried from the cache database of the cache server. After obtaining the product information set and storing it in the local database, the local data lock will be released.
[0100] The local data lock is used to prevent the commodity information set stored in the local database from being modified, so that the local database can only be modified and updated by the current thread to ensure the data consistency of the commodity information set stored in the local database.
[0101] The cache server is used to cache the source product information set in the source data server. The cache server is generally built based on Redis (remote dictionary service), and the storage medium performance of the cache server is generally better than that of the source data server. Therefore, the source data server caches the latest version of the product information set corresponding to each of the live broadcast rooms into the cache server to improve the data acquisition speed of the business server to obtain the latest version of the product information set for product identification, and through the distributed deployment of multiple cache servers, the high concurrency requirements of each business server to obtain the latest version of the product information set are met.
[0102] The cache database of the cache server stores the latest version of the product information set corresponding to each of these live broadcast rooms. The business server pushes an information acquisition instruction containing the live broadcast room identifier of the current live broadcast room to the cache server, so that the cache server responds to the information acquisition instruction and queries whether the cache database has the latest version of the product information set with the live broadcast room identifier. If so, the latest version of the product information set is pushed to the business server, so that the business server obtains the product set and stores it in the local database and releases the local data lock, and then identifies the products contained in the chat text according to the latest version of the product information set.
[0103] Step S13, when the latest version of the product information set does not exist in the cache database, the cache server is driven to trigger the cache data lock acting on the cache database, and after the latest version of the product information set in the source database of the source data server is queried and stored in the cache database and the local database, the cache data lock and the local data lock are released:
[0104] When the commodity information set corresponding to the live broadcast room identifier does not exist in the cache database of the cache server, the business server will drive the cache server to obtain the latest version of the commodity information set corresponding to the live broadcast room identifier from the source data server.
[0105] When the cache server queries the cache database and finds that the product information set corresponding to the live broadcast room identifier does not exist, the cache data lock acting on the cache database will be triggered, and a source information acquisition instruction containing the live broadcast room identifier will be pushed to the source data server, so that the source data server responds to the acquisition instruction, queries the product information set with the live broadcast room identifier from the source database, pushes the product information set to the cache server, so that the cache server stores the product information set in the cache database and releases the cache data lock, and pushes the product information set to the business server, so that the business server stores the product information set in the local database and releases the local data lock, so as to identify the product feature information contained in the chat text according to the product information set.
[0106] The cache data lock has the same function as the local data lock, which is used to prevent the product information set stored in the cache database from being modified, so that the cache database can only be modified and updated by the current thread to ensure the data consistency of the product information set stored in the cache database.
[0107] The source data server stores the product feature information existing in the online shop of the live broadcast room set defined by the anchor user in the current platform, so that the source data server encapsulates the product feature information and the live broadcast room identifier corresponding to the live broadcast room of the anchor user into a product information set, and stores the product information set in the source database.
[0108] The source data server can receive product feature information updated by the anchor user of any live broadcast room, so as to correspondingly update the product information set with the live broadcast room logo of the live broadcast room, and when the source data server completes the update of the product information set, it will push the updated product information set to the cache server with the product information set, so that the cache server can replace the product information set with the live broadcast room logo in its cache database with the updated product information set.
[0109] Step S14, identifying the target product feature information corresponding to the chat text according to the multiple product feature information contained in the latest version of the product information set of the current live broadcast room in the local database, and generating product order information containing the target product feature information:
[0110] When the latest version of the product information set corresponding to the live broadcast room identifier exists in the local database of the business server, the business server will identify the target product feature information corresponding to the chat text based on the multiple product feature information contained in the latest version of the product information set, and generate the product order information containing the target product feature information.
[0111] Specifically, the business server performs word segmentation processing on the chat text, extracts the product words contained in the chat text, and extracts the feature vectors corresponding to the product words, and simultaneously obtains the product keywords contained in multiple product feature information contained in the latest version of the product information set, and extracts the feature vectors corresponding to each of these product keywords, so as to determine the target product keyword whose feature vectors are most similar to the feature vectors of the product words, so as to generate the product order information containing the target product feature information to which the target product keyword belongs.
[0112] After the business server completes the product order information, it pushes the product order information to the audience user terminal corresponding to the chat text and the anchor user terminal corresponding to the current live broadcast room, so that the audience user terminal can define the delivery information specified in the product order information, and the anchor user terminal can define the freight information in the product order information, thereby completing the product order information.
[0113] It can be seen from this typical embodiment that this method improves the speed at which the business server obtains the latest version of product feature information by storing the latest version of the product information set belonging to the live broadcast room in the cache server, and at the same time stores the product feature information locally through the business server to prevent the cache server from crashing due to high-concurrency data acquisition requests, which makes the business server unable to identify the products in the chat text, affecting the shopping experience of the audience users who need to purchase products in the live broadcast room; in addition, this method updates its product information set based on the live broadcast room, thereby improving the update speed of the product information set; furthermore, when any end of this method updates the product information set, it will trigger the data lock acting on its own data, and only open the authority to update the product information set to one thread, thereby ensuring the data consistency of its own stored product information set and improving the robustness of the chat text product recognition system.
[0114] The above typical embodiments and their variations fully disclose the implementation scheme of the product information update processing method of the present application. However, various variations of the method can still be derived by changing and amplifying some technical means. Other embodiments are briefly described as follows:
[0115] In one embodiment, please refer to Figure 4The step of responding to the commodity identification event of the chat text pushed by the audience terminal in the current live broadcast room, determining the live broadcast room identifier corresponding to the event, and checking the version of the commodity information set corresponding to the live broadcast room identifier in the local database includes the following steps executed by the business server:
[0116] Step S111, responding to the product identification event, determining the live broadcast room identifier corresponding to the product identification event:
[0117] The business server responds to the commodity identification event acting on the chat text pushed by the audience terminal in the current live broadcast room, and determines the live broadcast room identifier corresponding to the current live broadcast room.
[0118] Step S112, querying whether the local database contains the product information set corresponding to the live broadcast room identifier, and if not, triggering a local data lock acting on the local database:
[0119] After the business server determines the live broadcast room identifier corresponding to the current live broadcast room, it queries the list database to see whether the product information set corresponding to the live broadcast room identifier exists. If not, the local data lock acting on the local database is triggered to ensure that the product information set stored in the local database is only allowed to be modified and updated by the current thread.
[0120] Step S113, querying the latest version of the product information set corresponding to the live broadcast room identifier from the cache database of the cache server, storing it in the local database, and releasing the local data lock:
[0121] The business server queries the cache database for the latest version of the product information set corresponding to the live broadcast room identifier, stores the product information set in the local database, and then releases the local data lock.
[0122] In this embodiment, when the product information set belonging to the live broadcast room currently being identified does not exist locally, the product information set will be obtained from the cache server, and the local data lock will be activated in the process of obtaining the product information set to ensure the consistency of local data.
[0123] In one embodiment, please refer to Figure 5 The step of responding to the commodity identification event of the chat text pushed by the audience terminal in the current live broadcast room, determining the live broadcast room identifier corresponding to the event, and checking the version of the commodity information set corresponding to the live broadcast room identifier in the local database includes the following steps executed by the business server:
[0124] Step S111', responding to the product identification event, determining the live broadcast room identifier corresponding to the product identification event:
[0125] The business server responds to the commodity identification event acting on the chat text pushed by the audience terminal in the current live broadcast room, and determines the live broadcast room identifier corresponding to the current live broadcast room.
[0126] Step S112', querying the local database whether there is a product information set corresponding to the live broadcast room identifier, and if so, pushing a version verification instruction acting on the product information set to the cache server:
[0127] After the business server determines the live broadcast room identifier corresponding to the current live broadcast room, it queries the list database to see whether there is a product information set corresponding to the live broadcast room identifier. If so, it generates the version verification instruction acting on the product information set and pushes it to the cache server.
[0128] Step S113', receiving the version verification result pushed by the cache server in response to the version detection verification instruction, and when the version verification result indicates that the product information set is the latest version, identifying the product feature information corresponding to the chat text and the product information set to generate product order information containing the product feature information:
[0129] The business server receives the version detection result pushed by the cache server in response to the version detection instruction feedback. When the version verification result indicates that the product information set is the latest version, it will identify the target product feature information corresponding to the chat text based on the multiple product feature information contained in the product information set, and generate the product order information containing the target product feature information.
[0130] In this embodiment, the version verification result of the currently stored product information set is requested from the cache server to ensure that the latest version of the product information set is used to identify the product in the chat text.
[0131] In one embodiment, please refer to Figure 6 , when the version of the product information set stored in the local database is an old version, triggering a local data lock acting on the local database, querying the latest version of the product information set stored in the cache database of the cache server and storing it in the local database, and then releasing the local data lock, the steps include the following steps performed by the business server:
[0132] Step S121, deleting the old version of the product information set stored in the local database, triggering a local data lock acting on the local database:
[0133] When the business server verifies that the product information set with the live broadcast room identifier stored in the local database is an old version, the business server will delete the product information set and trigger a local data lock acting on the local database.
[0134] Step S122, generating an information acquisition instruction for acquiring the latest version of the product information set corresponding to the live broadcast room identification lock and pushing it to the cache server:
[0135] After deleting the old version of the product information set, the business server generates the information acquisition instruction for acquiring the latest version of the product information set corresponding to the live broadcast room identifier, and pushes the instruction to the cache server.
[0136] Step S123, storing the latest version of the product information set in the cache database pushed by the cache server in response to the acquisition instruction into the local database, releasing the local data lock, and performing product identification of the chat text:
[0137] After the cache server responds to the acquisition instruction, it will query the product information set with the live broadcast room identifier from the cache database according to the live broadcast room identifier contained in the instruction, and push the product information set to the business server so that the business server can obtain the latest version of the product information set. After storing the product information set in the local database, the local data lock is released, and then the target product feature information corresponding to the chat text is identified according to the multiple product feature information contained in the product information set, and the product order information containing the target product feature information is generated.
[0138] In this embodiment, when the version of the product information set belonging to the live broadcast room currently being identified is an old version, a request will be made to the cache server to obtain the latest version of the product information set for product identification, and the local data lock will be activated in the process of obtaining the latest version of the product information set to ensure the consistency of local data.
[0139] In one embodiment, please refer to Figure 7 The step of driving the cache server to trigger the cache data lock acting on the cache database, querying the source database of the source data server to store the latest version of the product information set in the cache database and the local database, and then releasing the cache data lock and the local data lock includes the following steps performed by the cache server:
[0140] Step S131, triggering the cache data lock acting on the cache database, and pushing a source information acquisition instruction for acquiring the product information set to the source data server:
[0141] When the cache server queries its cache database and finds that the product information set corresponding to the live broadcast room identifier does not exist, the cache data lock acting on the cache database will be triggered, and a source information acquisition instruction for acquiring the product information set will be pushed to the source data server.
[0142] Step S132, storing the latest version of the product information set in the source database pushed by the source data server in response to the source information acquisition instruction into the cache database, and releasing the cache data lock:
[0143] After the source data server responds to the acquisition instruction, it will query the product information set with the live broadcast room identifier from the source database according to the live broadcast room identifier contained in the instruction, and push the product information set to the cache server so that the cache server can obtain the latest version of the product information set. After storing the product information set in the cache database, the cache data lock is released.
[0144] Step S133: Push the product information set to the business server, drive the business server to store the product information set in the local database to release the local data lock:
[0145] After the cache server stores the product information set corresponding to the live broadcast room identifier in the cache database, it will push the product information set to the business server so that the business server can store the product information set in the local database and release the local data lock acting on the local database.
[0146] In this embodiment, the cache server pre-stores product information sets of some live broadcast rooms to save storage space of high-performance storage media in the cache server. When the cache server needs to push product information sets that are not stored in the cache database to the business server, the cache server will obtain the product information set from the source data server for reprinting to ensure that the business server can execute the product identification service.
[0147] In one embodiment, please refer to Figure 8 The step of identifying the target product feature information corresponding to the chat text according to the multiple product feature information contained in the product information set of the latest version of the current live broadcast room in the local database, and generating product order information containing the target product feature information includes the following steps performed by the business server:
[0148] Step S141, performing word segmentation processing on the chat text, and extracting multiple product words contained in the chat text:
[0149] When the local database of the business server has the latest version of the product information set of the live broadcast room identifier corresponding to the current live broadcast room, the business server will perform word segmentation processing on the chat text pushed by the audience in the current live broadcast room, and extract multiple product words contained in the chat text.
[0150] Step S142, according to the product keywords respectively included in the plurality of product feature information included in the product information set in the local database, respectively determine the target product keywords that match the product terms among the product keywords:
[0151] After the business server extracts the multiple product words contained in the chat text, it will extract the text feature vectors corresponding to each of the product words, and extract the text feature vectors corresponding to the product keywords contained in each of the multiple product feature information contained in the latest version of the product information set, so as to calculate the similarity of the text feature vectors and take one or more product keywords with the highest similarity as the target product keywords that match the chat text.
[0152] Step S143, generating product order information including product feature information corresponding to the target product keyword:
[0153] After the business server identifies the target product keyword that matches the chat text, it will generate the product order information containing the product feature information to which the target product keyword belongs. The product order information represents the product attributes through the product image, product price and product name contained in the product feature information.
[0154] In this embodiment, the latest version of the product information set of the live broadcast room is used to identify products in the chat text pushed to the audience, determine the products pre-purchased by the audience, and generate a product order containing the identified products to promote online product transactions in the live broadcast room.
[0155] Furthermore, by functionalizing each step in the method disclosed in the above embodiments, a product information update processing device of the present application can be constructed. According to this idea, please refer to Fig. 9In a typical embodiment, the device includes: an information set version detection module 11, which is used to respond to a commodity identification event of a chat text pushed by a viewer terminal in a current live broadcast room, determine the live broadcast room identifier corresponding to the event, and check the version of the commodity information set corresponding to the live broadcast room identifier in a local database; a cache information set acquisition module 12, which is used to trigger a local data lock acting on the local database when the version of the commodity information set stored in the local database is an old version, query the latest version of the commodity information set stored in the cache database of the cache server, store it in the local database, and release the local data lock; The source information set acquisition module 13 is used to drive the cache server to trigger the cache data lock acting on the cache database when the latest version of the product information set does not exist in the cache database, and after querying the latest version of the product information set in the source database of the source data server and storing it in the cache database and the local database, release the cache data lock and the local data lock; the product order generation module 14 is used to identify the target product feature information corresponding to the chat text based on multiple product feature information contained in the latest version of the product information set of the current live broadcast room in the local database, and generate product order information containing the target product feature information.
[0156] In one embodiment, the information set version detection module 11 includes: a live broadcast room identifier determination submodule, which is used to respond to the product identification event and determine the live broadcast room identifier corresponding to the product identification event; a local data lock triggering submodule, which is used to query whether the product information set corresponding to the live broadcast room identifier exists in the local database. If not, triggering the local data lock acting on the local database; a local data lock releasing submodule, which is used to query the latest version of the product information set corresponding to the live broadcast room identifier from the cache database of the cache server and store it in the local database, thereby releasing the local data lock.
[0157] In another embodiment, the information set version detection module 11 also includes: a live broadcast room identifier determination submodule, which is used to respond to the product identification event and determine the live broadcast room identifier corresponding to the product identification event; an information set version verification submodule, which is used to query whether the product information set corresponding to the live broadcast room identifier exists in the local database, and if so, push a version verification instruction acting on the product information set to the cache server; a product order generation submodule, which is used to receive the version verification result pushed by the cache server in response to the version detection verification instruction, and when the version verification result indicates that the product information set is the latest version, identify the product feature information corresponding to the chat text and the product information set to generate product order information containing the product feature information.
[0158] In one embodiment, the cache information set acquisition module 12 includes: an old information set deletion submodule, which is used to delete the old version of the product information set stored in the local database, triggering a local data lock acting on the local database; an acquisition instruction push submodule, which is used to generate an information acquisition instruction for acquiring the latest version of the product information set corresponding to the live broadcast room identification lock and push it to the cache server; an information set acquisition submodule, which is used to store the latest version of the product information set in the cache database pushed by the cache server in response to the acquisition instruction into the local database, release the local data lock, and perform product identification in the chat text.
[0159] In one embodiment, the source information set acquisition module 13 includes: an information acquisition instruction push submodule, which is used to trigger the cache data lock acting on the cache database, and push the source information acquisition instruction for acquiring the product information set to the source data server; a data lock release submodule, which is used to store the latest version of the product information set in the source database pushed by the source data server in response to the source information acquisition instruction into the cache database, and release the cache data lock; an information set push submodule, which is used to push the product information set to the business server, and drive the business server to store the product information set in the local database to release the local data lock.
[0160] In a further embodiment, the product order generation module 14 includes: a product word extraction submodule, which is used to perform word segmentation processing on the chat text and extract multiple product words contained in the chat text; a keyword matching submodule, which is used to determine the target product keywords that match each of the product words in the product keywords according to the product keywords contained in the multiple product feature information contained in the product information set in the local database; and a product order generation submodule, which is used to generate product order information containing the product feature information corresponding to the target product keyword.
[0161] In order to solve the above technical problems, the embodiment of the present application also provides a computer device for running a computer program implemented according to the product information update processing method. Fig.10 , Fig.10 This is a basic structural block diagram of the computer device in this embodiment.
[0162] like Fig.10As shown, a schematic diagram of the internal structure of a computer device. The computer device includes a processor, a non-volatile storage medium, a memory, and a network interface connected via a system bus. Among them, the non-volatile storage medium of the computer device stores an operating system, a database, and computer-readable instructions. The database may store a control information sequence. When the computer-readable instructions are executed by the processor, the processor can implement a method for updating product information. The processor of the computer device is used to provide computing and control capabilities to support the operation of the entire computer device. The memory of the computer device may store computer-readable instructions. When the computer-readable instructions are executed by the processor, the processor can execute a method for updating product information. The network interface of the computer device is used to connect and communicate with a terminal. Those skilled in the art can understand that Fig.10 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0163] In this embodiment, the processor is used to execute the specific functions of each module / submodule in the commodity information update processing device of the present invention, and the memory stores the program code and various data required to execute the above modules. The network interface is used to transmit data between user terminals or servers. The memory in this embodiment stores the program code and data required to execute all modules / submodules in the commodity information update processing device, and the server can call the server's program code and data to execute the functions of all submodules.
[0164] The present application also provides a non-volatile storage medium, wherein the product information update processing method is written into a computer program and stored in the storage medium in the form of computer-readable instructions. When the computer-readable instructions are executed by one or more processors, it means that the program is run in the computer, thereby enabling one or more processors to execute the steps of the product information update processing method of any of the above-mentioned embodiments.
[0165] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program, and the computer program can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, the aforementioned storage medium can be a non-volatile storage medium such as a disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).
[0166] To summarize, this application stores the latest version of the product information set belonging to the live broadcast room in the cache server to improve the efficiency of the business server in obtaining the latest version of product feature information for product identification business, and updates the product information set by the live broadcast room as a unit, thereby improving the update speed of the product information set. In addition, this application only opens the permission to update the product information set to one thread to ensure the data consistency of the product information set stored by itself.
[0167] It should be understood that, although the steps in the flowchart of the accompanying drawings are displayed in sequence as indicated by the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least a part of the steps in the flowchart of the accompanying drawings may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be executed in turn or alternately with other steps or at least a part of the sub-steps or stages of other steps.
[0168] Those skilled in the art will appreciate that the various operations, methods, steps, measures, and schemes in the processes discussed in this application may be alternated, altered, combined, or deleted. Further, other steps, measures, and schemes in the various operations, methods, and processes discussed in this application may also be alternated, altered, rearranged, decomposed, combined, or deleted. Further, the steps, measures, and schemes in the prior art that are similar to those disclosed in this application may also be alternated, altered, rearranged, decomposed, combined, or deleted.
[0169] The above description is only a partial implementation method of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.
Claims
1. A method for updating product information, characterized in that: The steps include: In response to a product identification event of a chat text pushed by a viewer in the current live broadcast room, determine the live broadcast room identifier corresponding to the event, and check the version of the product information set corresponding to the live broadcast room identifier in the local database; When the version of the product information set stored in the local database is an old version, a local data lock acting on the local database is triggered, and after the latest version of the product information set stored in the cache database of the cache server is queried and stored in the local database, the local data lock is released; When the latest version of the product information set does not exist in the cache database, the cache server is driven to trigger a cache data lock acting on the cache database, and after the latest version of the product information set in the source database of the source data server is queried and stored in the cache database and the local database, the cache data lock and the local data lock are released; According to the multiple product feature information contained in the product information set of the latest version of the current live broadcast room in the local database, the target product feature information corresponding to the chat text is identified, and product order information containing the target product feature information is generated.
2. The method according to claim 1, characterized in that The step of responding to a commodity identification event of a chat text pushed by a viewer in the current live broadcast room, determining a live broadcast room identifier corresponding to the event, and checking a version of a commodity information set corresponding to the live broadcast room identifier in a local database includes the following steps performed by the business server: In response to the product identification event, determine the live broadcast room identifier corresponding to the product identification event; Querying the local database whether there is a product information set corresponding to the live broadcast room identifier, and if not, triggering a local data lock acting on the local database; The latest version of the product information set corresponding to the live broadcast room identifier is queried from the cache database of the cache server and stored in the local database, thereby releasing the local data lock.
3. The method according to claim 1, characterized in that The step of responding to a commodity identification event of a chat text pushed by a viewer in the current live broadcast room, determining a live broadcast room identifier corresponding to the event, and checking a version of a commodity information set corresponding to the live broadcast room identifier in a local database includes the following steps performed by the business server: In response to the product identification event, determine the live broadcast room identifier corresponding to the product identification event; Querying the local database whether there is a product information set corresponding to the live broadcast room identifier, and if so, pushing a version verification instruction acting on the product information set to the cache server; Receive the version verification result pushed by the cache server in response to the version detection verification instruction, and when the version verification result indicates that the product information set is the latest version, identify the product feature information corresponding to the chat text and the product information set to generate product order information containing the product feature information.
4. The method according to claim 1, characterized in that When the version of the product information set stored in the local database is an old version, triggering a local data lock acting on the local database, querying the latest version of the product information set stored in the cache database of the cache server and storing it in the local database, the step of releasing the local data lock includes the following steps performed by the business server: Deleting the old version of the product information set stored in the local database, triggering a local data lock acting on the local database; Generate an information acquisition instruction for acquiring the latest version of the commodity information set corresponding to the live broadcast room identification lock and push it to the cache server; The latest version of the product information set in the cache database pushed by the cache server in response to the acquisition instruction is stored in the local database, the local data lock is released, and the product identification of the chat text is performed.
5. The method according to claim 1, characterized in that The step of driving the cache server to trigger the cache data lock acting on the cache database, querying the source database of the source data server to store the latest version of the product information set in the cache database and the local database, and then releasing the cache data lock and the local data lock includes the following steps performed by the cache server: triggering a cache data lock acting on the cache database, and pushing a source information acquisition instruction for acquiring the commodity information set to the source data server; storing the latest version of the product information set in the source database pushed by the source data server in response to the source information acquisition instruction into the cache database, and releasing the cache data lock; The commodity information set is pushed to the business server, and the business server is driven to store the commodity information set in a local database to release the local data lock.
6. The method according to claim 1, characterized in that The step of identifying the target product feature information corresponding to the chat text based on the multiple product feature information contained in the product information set of the latest version of the current live broadcast room in the local database, and generating product order information containing the target product feature information includes the following steps performed by the business server: Performing word segmentation processing on the chat text, and extracting a plurality of commodity words contained in the chat text; According to the commodity keywords respectively included in the plurality of commodity feature information included in the commodity information set in the local database, respectively determining the target commodity keywords that match the respective commodity words among the commodity keywords; Generate product order information including product feature information corresponding to the target product keyword.
7. A commodity information update processing device, characterized in that: It includes: An information set version detection module is used to respond to a commodity identification event of a chat text pushed by a viewer in the current live broadcast room, determine the live broadcast room identifier corresponding to the event, and check the version of the commodity information set corresponding to the live broadcast room identifier in the local database; A cache information set acquisition module, used for triggering a local data lock acting on the local database when the version of the product information set stored in the local database is an old version, querying the latest version of the product information set stored in the cache database of the cache server and storing it in the local database, and then releasing the local data lock; A source information set acquisition module, used to drive the cache server to trigger a cache data lock acting on the cache database when the latest version of the product information set does not exist in the cache database, query the source database of the source data server to store the latest version of the product information set in the cache database and the local database, and then release the cache data lock and the local data lock; The product order generation module is used to identify the target product feature information corresponding to the chat text based on the multiple product feature information contained in the latest version of the product information set of the current live broadcast room in the local database, and generate product order information containing the target product feature information.
8. An electronic device, comprising a central processing unit and a memory, characterized in that: The central processing unit is used to call and run a computer program stored in the memory to execute the steps of the method according to any one of claims 1 to 6.
9. A non-volatile storage medium, characterized in that: It stores a computer program implemented according to the method described in any one of claims 1 to 6 in the form of computer-readable instructions, and when the computer program is called and executed by a computer, the steps included in the method are executed.
10. A computer program product comprising a computer program / instructions, characterized in that When the computer program / instructions are executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.
