A home furnishing commodity management method, device and electronic equipment

Abstract

This disclosure relates to the field of data processing technology, and in particular to a method, apparatus, and electronic device for managing home decoration products. The method includes: obtaining a target transaction identifier; performing a fast search based on the target transaction identifier to obtain a search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index; determining a historical version snapshot of the target home decoration product corresponding to the search index based on the search index; wherein, the historical version snapshot includes one or more of a product master table snapshot, an inventory table snapshot, a price table snapshot, and a request table snapshot; generating a prompt message based on the historical version snapshot; wherein, the prompt message is used to indicate the search results corresponding to the target transaction identifier.

Description

Technical Field

[0001] This disclosure relates to the field of data processing technology, and in particular to a method, apparatus and electronic device for managing home decoration products. Background Technology

[0002] Currently, the home decoration industry faces many challenges in product management due to the nature of its business, such as the wide variety of home decoration products, complex attribute information, and data being scattered across multiple databases, including the main product table, inventory table, and price table, making management difficult.

[0003] Therefore, how to manage the data information of home decoration products scattered across multiple databases has become an urgent problem to be solved. Summary of the Invention

[0004] To address the aforementioned technical problems, this disclosure provides a method, apparatus, and electronic device for managing home decoration products.

[0005] Firstly, this disclosure provides a method for managing home decoration products, comprising: obtaining a target transaction identifier; performing a fast search based on the target transaction identifier to obtain a search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index; determining a historical version snapshot of the target home decoration product corresponding to the search index based on the search index; wherein, the historical version snapshot includes one or more of the following: product master table snapshot, inventory table snapshot, price table snapshot, and request table snapshot; generating prompt information based on the historical version snapshot; wherein, the prompt information is used to indicate the search results corresponding to the target transaction identifier.

[0006] Secondly, this disclosure provides a management device for home decoration products, comprising: an acquisition module for acquiring a target transaction identifier; a processing module for performing a rapid retrieval based on the target transaction identifier acquired by the acquisition module to obtain a retrieval index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one retrieval index; the processing module is further configured to determine a historical version snapshot of the target home decoration product corresponding to the retrieval index based on the retrieval index; wherein, the historical version snapshot includes one or more of a product master table snapshot, an inventory table snapshot, a price table snapshot, and a request table snapshot; the processing module is further configured to generate prompt information based on the historical version snapshot; wherein, the prompt information is used to indicate the retrieval results corresponding to the target transaction identifier.

[0007] Thirdly, this disclosure provides an electronic device, including: a memory and a processor, wherein the memory is used to store a computer program; and the processor is used to cause the electronic device to implement the home furnishing product management method provided in any of the first aspects when executing the computer program.

[0008] Fourthly, this disclosure provides a computer-readable storage medium, comprising: storing a computer program on the computer-readable storage medium, the computer program being executed by a controller as a method for managing home furnishing goods as provided in any of the first aspects.

[0009] Fifthly, this disclosure provides a computer program product that, when run on a computer, causes the computer to execute a method for managing home improvement products as provided in any of the first aspects.

[0010] It should be noted that the aforementioned computer instructions may be stored, in whole or in part, on the first computer-readable storage medium. The first computer-readable storage medium may be packaged together with the controller of the home improvement product management device, or it may be packaged separately from the controller of the home improvement product management device; this disclosure does not limit this. The descriptions of the second, third, fourth, and fifth aspects in this disclosure can be referred to the detailed description of the first aspect; and the beneficial effects described in the second, third, fourth, and fifth aspects can be referred to the beneficial effect analysis of the first aspect, which will not be repeated here.

[0011] In this disclosure, the name of the aforementioned home decoration product management device does not limit the device or functional module itself. In actual implementation, these devices or functional modules may appear under other names. As long as the function of each device or functional module is similar to that of this disclosure, it falls within the scope of this disclosure and its equivalents.

[0012] These or other aspects of this disclosure will become more readily apparent in the following description.

[0013] The technical solution provided in this disclosure has the following advantages compared with the prior art: The home improvement product management method disclosed herein aggregates version data scattered across different tables by pre-storing historical version snapshots corresponding to target transaction identifiers and configuring a target transaction identifier for each target home improvement product. When managing a target home improvement product, the user can input the target transaction identifier on an electronic device, which then performs a quick search based on the identifier to obtain a search index. Each target transaction identifier corresponds to one search index. Based on the search index, the historical version snapshot of the target home improvement product corresponding to the search index is determined. This historical version snapshot includes one or more of the following: product master table snapshot, inventory table snapshot, price table snapshot, and request table snapshot. Based on the historical version snapshot, a prompt message is generated. Thus, users can retrieve search results for the target home improvement product corresponding to a historical transaction identifier simply by using the target transaction identifier, significantly improving search efficiency and meeting the real-time data analysis needs of enterprises. It offers significant advantages in data processing and search architecture, solving the problem of managing data information of home improvement products scattered across multiple databases. Attached Figure Description

[0014] The accompanying drawings, which are incorporated in and form a part of this specification, illustrate embodiments consistent with this disclosure and, together with the description, serve to explain the principles of this disclosure.

[0015] To more clearly illustrate the technical solutions in the embodiments of this disclosure or the prior art, the accompanying drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, for those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0016] Figure 1 This is one of the flowcharts illustrating the management method for home decoration products according to an embodiment of this disclosure; Figure 2 This is a second flowchart illustrating the management method for home decoration products according to an embodiment of this disclosure; Figure 3 This is the third flowchart illustrating the management method for home decoration products according to an embodiment of this disclosure; Figure 4 This is the fourth flowchart illustrating the management method for home decoration products according to an embodiment of this disclosure; Figure 5 This is the fifth flowchart illustrating the management method for home decoration products according to an embodiment of this disclosure; Figure 6 This is a schematic diagram of the structure of the home decoration product management device described in the embodiments of this disclosure; Figure 7 This is a schematic diagram of the structure of the electronic device described in an embodiment of this disclosure. Detailed Implementation

[0017] To better understand the above-mentioned objectives, features, and advantages of this disclosure, the solutions disclosed herein will be further described below. It should be noted that, unless otherwise specified, the embodiments and features described herein can be combined with each other.

[0018] Numerous specific details are set forth in the following description in order to provide a full understanding of this disclosure, but this disclosure may also be implemented in other ways different from those described herein; obviously, the embodiments in the specification are only some, and not all, of the embodiments of this disclosure.

[0019] It should be noted that, in this document, relational terms such as "first" and "second" are used merely to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.

[0020] In some examples, a transaction in this disclosure refers to a logical unit of execution consisting of a series of operations that access and update the database. Each transaction has a unique transaction ID, which is requested from the InnoDB transaction system at the start of the transaction and is strictly incremented in the order of request.

[0021] The MySQL used in this embodiment is an open-source relational database management system (RDBMS).

[0022] Example 1 Figure 1 The example illustrates a flowchart of a method for managing home furnishing products. The executing entity in this example can be an electronic device, such as... Figure 1 As shown, the method includes: S11. Obtain the target transaction identifier.

[0023] In some examples, the home decoration product management method provided in this disclosure uses MySQL transaction identifiers to link change data across multiple tables, such as the main product table and the inventory table, in home decoration product management. Therefore, users can query the corresponding historical version snapshot based on the target transaction identifier (such as a transaction ID) of the home decoration product they wish to monitor, facilitating user management of the home decoration product.

[0024] In some examples, different home improvement products correspond to different target transaction identifiers.

[0025] In some examples, the target transaction identifier is generated based on the date and product information of the home improvement product (such as name, model, size, brand, barcode, etc.).

[0026] In some examples, the target transaction identifier is specified by MySQL.

[0027] S12. Perform a fast search based on the target transaction identifier to obtain the search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index.

[0028] In some examples, the electronic device's memory pre-stores the correspondence between different target transaction identifiers and retrieval indexes, so that the electronic device can determine the retrieval index corresponding to the target transaction identifier by querying the correspondence.

[0029] S13. Based on the retrieval index, determine the historical version snapshot of the target home decoration product corresponding to the retrieval index; wherein, the historical version snapshot includes one or more of the following: product master table snapshot, inventory table snapshot, price table snapshot, and request table snapshot.

[0030] S14. Generate prompt information based on historical version snapshots; wherein, the prompt information is used to indicate the search results corresponding to the target transaction identifier.

[0031] In some examples, the home improvement product management method provided in this disclosure synchronizes data from a unified database table to Elasticsearch (ES) and builds a retrieval index in ES based on transaction IDs. When a user needs to query a historical version snapshot of a product, they only need to enter the transaction ID in the system, and the system can quickly retrieve the corresponding complete product information snapshot through ES and display it to the user. The entire query process is efficient and fast, meeting the real-time data analysis needs of home improvement companies.

[0032] As described above, the home decoration product management method provided in this embodiment of the present disclosure, by pre-storing historical version snapshots corresponding to target transaction identifiers and configuring a target transaction identifier for each target home decoration product, can aggregate version data scattered across different tables via transaction IDs. Therefore, when it is necessary to manage a target home decoration product, the user can input the target transaction identifier on an electronic device, which then performs a quick search based on the target transaction identifier to obtain the search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index; based on the search index, the historical version snapshot of the target home decoration product corresponding to the search index is determined; wherein, the historical version snapshot includes one or more of the product master table snapshot, inventory table snapshot, price table snapshot, and request table snapshot; based on the historical version snapshot, a prompt message is generated. In this way, users only need to use the target transaction identifier to query the search results of the target home decoration product corresponding to the historical transaction identifier, greatly improving search efficiency, meeting the real-time data analysis needs of enterprises, and having significant advantages in data processing and search architecture.

[0033] In some feasible examples, combining Figure 1 ,like Figure 2 As shown in the embodiments of this disclosure, the method for managing home decoration products further includes: S15-S17.

[0034] S15. In response to the product operation on the selected home decoration product, initiate a database transaction and generate a theoretical transaction identifier; wherein, the product operation includes any one of modifying the product price, modifying the product inventory, and adjusting the product attributes; In some examples, when an electronic device receives a user's operation on selected home improvement products in the home improvement product management system—such as modifying product prices and inventory during promotional activities, or adjusting product attributes in customized services—the home improvement product management system immediately initiates a MySQL database transaction and generates a unique transaction ID (e.g., TX20241201001). During the execution of the database transaction, the home improvement product management system simultaneously operates on multiple related tables, including the main product table (recording basic information such as product name and model), the inventory table (recording inventory quantity), and the price table (recording sales price). It records a snapshot of the current state of these tables and binds the snapshot data with the transaction ID for storage.

[0035] S16. During the execution of a database transaction, obtain a snapshot of the status of the associated tables of the selected home decoration products; wherein, the associated tables include one or more of the main product table, the inventory table, and the price table.

[0036] S17. Establish the binding relationship between the state snapshot and the theoretical transaction identifier.

[0037] As described above, the home decoration product management method provided in this embodiment, in response to a product operation on a selected home decoration product, initiates a database transaction and generates a theoretical transaction identifier; during the execution of the database transaction, it obtains a state snapshot of the associated table of the selected home decoration product; and establishes a binding relationship between the state snapshot and the theoretical transaction identifier. Therefore, when it is necessary to manage a target home decoration product, the user can input the target transaction identifier on an electronic device, which then performs a quick search based on the target transaction identifier to obtain the search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index; based on the search index, it determines the historical version snapshot of the target home decoration product corresponding to the search index; wherein, the historical version snapshot includes one or more of the following: product main table snapshot, inventory table snapshot, price table snapshot, and request table snapshot; based on the historical version snapshot, it generates a prompt message. Thus, users only need to use the target transaction identifier to query the search results of the target home decoration product corresponding to the historical transaction identifier, greatly improving search efficiency and meeting the real-time data analysis needs of enterprises, demonstrating significant advantages in data processing and search architecture.

[0038] In some feasible examples, combining Figure 1 ,like Figure 3 As shown in the embodiments of this disclosure, the method for managing home decoration products further includes: S18 and S19.

[0039] S18. In response to the operation on the selected home decoration product, obtain the request identifier corresponding to the product operation; wherein, one request identifier corresponds to one operator information; In some examples, the request identifier is generated based on the operator information corresponding to the user account logged in on the electronic device.

[0040] In some examples, the home decoration product management system generates a request identifier (such as a request ID (e.g., REQ20241201001)) and writes the mapping between the request ID and the transaction ID into the request table.

[0041] S19. Establish the correspondence between the request identifier and the theoretical transaction identifier of the selected home decoration product, and write the correspondence into the request table.

[0042] As described above, the home decoration product management method provided in this embodiment of the present disclosure, in response to a product operation on a selected home decoration product, obtains the request identifier corresponding to the product operation; establishes a correspondence between the request identifier and the theoretical transaction identifier of the selected home decoration product, and writes the correspondence into a request table. Thus, when it is necessary to manage a target home decoration product, the user can input the target transaction identifier on an electronic device, and the electronic device will then perform a quick search based on the target transaction identifier to obtain a search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index; based on the search index, a historical version snapshot of the target home decoration product corresponding to the search index is determined; wherein, the historical version snapshot includes one or more of the following: product master table snapshot, inventory table snapshot, price table snapshot, and request table snapshot; based on the historical version snapshot, a prompt message is generated. In this way, users only need to use the target transaction identifier to query the search results of the target home decoration product corresponding to the historical transaction identifier, greatly improving search efficiency, meeting the real-time data analysis needs of enterprises, and having significant advantages in data processing and search architecture.

[0043] In some feasible examples, combining Figure 1 ,like Figure 4 As shown in the embodiments of this disclosure, the method for managing home decoration products further includes: S20-S22.

[0044] S20. Obtain at least one related table.

[0045] S21. Monitor the first binary log of the associated table to determine the changed data; In some examples, the home decoration product management system continuously monitors the first binary logs (e.g., Binlog logs) of business tables such as the main product table, inventory table, and price table to obtain real-time change information of these tables during operations. For example, when adjusting the price of a sofa, the price table's Binlog log will record the price change from 5000 yuan to 5500 yuan, and the inventory table's Binlog log will record the change in inventory quantity from 10 units to 8 units.

[0046] S22. Modify the parameters corresponding to the changed data in the associated table and generate change information.

[0047] In some examples, the home decoration product management system continuously monitors the first binary logs (e.g., Binlog logs) of business tables such as the main product table, inventory table, and price table to obtain real-time changes to these tables during operations. For instance, when adjusting the price of a sofa, the price table's Binlog log will record the price change from 5000 yuan to 5500 yuan, and the inventory table's Binlog log will record the change in inventory quantity from 10 units to 8 units.

[0048] As described above, the home decoration product management method provided in this embodiment obtains at least one associated table; monitors the first binary log of the associated table to determine changed data; and modifies the parameters corresponding to the changed data in the associated table to generate change information. Therefore, when it is necessary to manage a target home decoration product, the user can input a target transaction identifier on an electronic device, which then performs a quick search based on the target transaction identifier to obtain a search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index; based on the search index, a historical version snapshot of the target home decoration product corresponding to the search index is determined; wherein, the historical version snapshot includes one or more of the following: product main table snapshot, inventory table snapshot, price table snapshot, and request table snapshot; and based on the historical version snapshot, a prompt message is generated. Thus, users only need to use the target transaction identifier to query the search results of the target home decoration product corresponding to the historical transaction identifier, greatly improving search efficiency and meeting the real-time data analysis needs of enterprises, demonstrating significant advantages in data processing and search architecture.

[0049] In some feasible examples, combining Figure 1 ,like Figure 5 As shown in the embodiments of this disclosure, the method for managing home decoration products further includes: S23-S27.

[0050] S23. Obtain at least one related table and at least one request table; S24. Monitor the first binary log of the associated table to determine the change information; S25. Monitor the second binary log of the request table to determine the operator information; In some examples, by listening to the second binary log of the request table (such as the Binlog log), the home improvement product management system can parse the operator information corresponding to each request ID. For example, in a batch price modification operation, parsing the Binlog log can determine that employee A from the operations department initiated the request.

[0051] S26. Aggregate the change information and operator information corresponding to the same theoretical transaction identifier to generate an operation record; S27. Store the operation record in the database.

[0052] In some examples, the home decoration product management system aggregates the operator information obtained from the Binlog log of the request table and the change data obtained from the Binlog log of the business table according to the transaction ID, forming a complete operation record, and storing it in a unified database table. For example, the operator (employee A) corresponding to transaction ID: TX20241201001, the price change (5000 yuan → 5500 yuan), and the inventory change (10 items → 8 items) are integrated and stored together.

[0053] As described above, the home decoration product management method provided in this embodiment obtains at least one association table and at least one request table; monitors the first binary log of the association table to determine change information; monitors the second binary log of the request table to determine operator information; aggregates the change information and operator information corresponding to the same theoretical transaction identifier to generate an operation record; and stores the operation record in a database. Therefore, when it is necessary to manage a target home decoration product, the user can input a target transaction identifier on an electronic device, which then performs a quick search based on the target transaction identifier to obtain a search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index; based on the search index, a historical version snapshot of the target home decoration product corresponding to the search index is determined; wherein, the historical version snapshot includes one or more of the product main table snapshot, inventory table snapshot, price table snapshot, and request table snapshot; and a prompt message is generated based on the historical version snapshot. Thus, users only need to use the target transaction identifier to query the search results of the target home decoration product corresponding to the historical transaction identifier, greatly improving search efficiency and meeting the real-time data analysis needs of enterprises, demonstrating significant advantages in data processing and search architecture.

[0054] Example 2 A schematic diagram of the structure of the home decoration product management device provided in Embodiment 2 of this application is shown below. Figure 6 The management device for the home decoration product shown includes: an acquisition module 201 and a processing module 202.

[0055] Module 201 is used to obtain the target transaction identifier; Processing module 202 is used to perform fast retrieval based on the target transaction identifier obtained by acquisition module 201 to obtain the retrieval index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one retrieval index; Processing module 202 is also used to determine the historical version snapshot of the target home decoration product corresponding to the search index based on the search index; wherein, the historical version snapshot includes one or more of the following: product master table snapshot, inventory table snapshot, price table snapshot and request table snapshot; The processing module 202 is also used to generate prompt information based on historical version snapshots; wherein the prompt information is used to indicate the search results corresponding to the target transaction identifier.

[0056] In some implementable examples, the processing module 202 is also configured to initiate a database transaction and generate a theoretical transaction identifier in response to a product operation on a selected home decoration product; wherein the product operation includes any one of modifying the product price, modifying the product inventory, and adjusting the product attributes; Processing module 202 is also used to obtain a snapshot of the status of the associated tables of the selected home decoration products during the execution of database transactions; wherein the associated tables include one or more of the main product table, inventory table, and price table; The processing module 202 is also used to establish the binding relationship between the state snapshot and the theoretical transaction identifier.

[0057] In some implementable examples, the processing module 202 is also configured to obtain a request identifier corresponding to the product operation in response to the product operation on the selected home decoration product; wherein, one request identifier corresponds to one operator information; The processing module 202 is also used to establish a correspondence between the request identifier and the theoretical transaction identifier of the selected home decoration product, and write the correspondence into the request table.

[0058] In some implementable examples, module 201 is also used to retrieve at least one associated table; The processing module 202 is also used to monitor the first binary log of the associated table obtained by the acquisition module 201 to determine the changed data; The processing module 202 is also used to change the parameters corresponding to the changed data in the associated table and generate change information.

[0059] In some implementable examples, the acquisition module 201 is also used to acquire at least one associated table and at least one request table; The processing module 202 is also used to monitor the first binary log of the associated table obtained by the acquisition module 201 to determine the change information; The processing module 202 is also used to listen to the second binary log of the request table obtained by the acquisition module 201 to determine the operator information; The processing module 202 is also used to aggregate the change information and operator information corresponding to the same theoretical transaction identifier to generate an operation record; The processing module 202 is also used to store the operation records to the database.

[0060] All relevant content of each step involved in the above method embodiments can be referenced from the functional description of the corresponding functional module, and their functions will not be repeated here.

[0061] Of course, the home decoration product management device provided in this embodiment includes, but is not limited to, the modules described above. For example, the home decoration product management device may also include a storage module 203. The storage module 203 may be used to store the program code of the home decoration product management device, and may also be used to store data generated by the home decoration product management device during operation, such as audio data.

[0062] This disclosure provides a schematic diagram of the structure of an electronic device, such as... Figure 7 The electronic device shown may include at least one processor 51, a memory 52, a communication interface 53, and a communication bus 54.

[0063] The following is a detailed introduction to the various components of the electronic device: The processor 51 is the control center of the electronic device and can be a single processor or a collective term for multiple processing elements. For example, the processor 51 can be a central processing unit (CPU), an application-specific integrated circuit (ASIC), or one or more integrated circuits configured to implement the embodiments of this disclosure, such as one or more DSPs, or one or more field-programmable gate arrays (FPGAs).

[0064] In a specific implementation, as one embodiment, processor 51 may include one or more CPUs, such as CPU0 and CPU1. Furthermore, as one embodiment, the electronic device may include multiple processors, such as processor 51 and processor 55. Each of these processors may be a single-core processor or a multi-core processor. Here, "processor" may refer to one or more devices, circuits, and / or processing cores for processing data (e.g., computer program instructions).

[0065] The memory 52 may be a read-only memory (ROM) or other type of static storage device capable of storing static information and instructions, random access memory (RAM) or other type of dynamic storage device capable of storing information and instructions, or electrically erasable programmable read-only memory (EEPROM), compact disc read-only memory (CD-ROM) or other optical disc storage, optical disc storage (including compressed optical discs, laser discs, optical discs, digital universal optical discs, Blu-ray discs, etc.), magnetic disk storage media or other magnetic storage devices, or any other medium capable of carrying or storing desired program code in the form of instructions or data structures and accessible by a computer, but not limited thereto. The memory 52 may exist independently and be connected to the processor 51 via the communication bus 54. The memory 52 may also be integrated with the processor 51.

[0066] In a specific implementation, memory 52 is used to store data disclosed herein and execute software programs disclosed herein. Processor 51 can perform various functions of the air conditioner by running or executing software programs stored in memory 52 and by calling data stored in memory 52.

[0067] Communication interface 53, using any transceiver-like device, is used to communicate with other devices or communication networks, such as Radio Access Network (RAN), Wireless Local Area Networks (WLAN), terminals, the cloud, etc. Communication interface 53 may include an acquisition module to implement acquisition functions.

[0068] The communication bus 54 can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. This bus can be divided into address bus, data bus, control bus, etc. For ease of representation, it is represented by only one thick line, but this does not indicate that there is only one bus or one type of bus.

[0069] As an example, combined Figure 6 ,like Figure 7As shown, the acquisition module 201 of the home decoration product management device performs the same function as the communication interface 53, the processing module 202 of the home decoration product management device performs the same function as the processor 51, and the storage module 203 of the home decoration product management device performs the same function as the memory 52.

[0070] This application also provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, are used to implement the method in any of the embodiments.

[0071] The above description is merely a specific embodiment of this disclosure, enabling those skilled in the art to understand or implement it. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of this disclosure. Therefore, this disclosure is not to be limited to the embodiments described herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for managing home decoration products, characterized in that, include: Obtain the target transaction identifier; A fast search is performed based on the target transaction identifier to obtain the search index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one search index; Based on the search index, determine the historical version snapshot of the target home decoration product corresponding to the search index; wherein, the historical version snapshot includes one or more of the following: product master table snapshot, inventory table snapshot, price table snapshot, and request table snapshot; Based on the historical version snapshot, a prompt message is generated; wherein, the prompt message is used to indicate the search results corresponding to the target transaction identifier.

2. The management method for home decoration products according to claim 1, characterized in that, Before obtaining the target transaction identifier, the method further includes: In response to a product operation on a selected home decoration product, a database transaction is initiated, and a theoretical transaction identifier is generated; wherein, the product operation includes any one of modifying the product price, modifying the product inventory, and adjusting the product attributes; During the execution of the database transaction, a snapshot of the status of the associated tables of the selected home decoration products is obtained; wherein, the associated tables include one or more of the main product table, the inventory table, and the price table; Establish a binding relationship between the state snapshot and the theoretical transaction identifier.

3. The management method for home decoration products according to claim 1, characterized in that, Before obtaining the target transaction identifier, the method further includes: In response to an operation on a selected home decoration product, a request identifier corresponding to the product operation is obtained; wherein, one request identifier corresponds to one operator information; Establish a correspondence between the request identifier and the theoretical transaction identifier of the selected home decoration product, and write the correspondence into the request table.

4. The management method for home decoration products according to claim 1, characterized in that, Before obtaining the target transaction identifier, the method further includes: Obtain at least one related table; Monitor the first binary log of the associated table to determine the changed data; The parameters corresponding to the changed data in the associated table are modified to generate change information.

5. The management method for home decoration products according to claim 1, characterized in that, Before obtaining the target transaction identifier, the method further includes: Retrieve at least one related table and at least one request table; Monitor the first binary log of the associated table to determine change information; Monitor the second binary log of the request table to determine the operator information; The change information and the operator information corresponding to the same theoretical transaction identifier are aggregated to generate an operation record; The operation records are stored in the database.

6. A management device for home decoration products, characterized in that, include: The acquisition module is used to obtain the target transaction identifier; The processing module is used to perform a fast retrieval based on the target transaction identifier obtained by the acquisition module to obtain a retrieval index corresponding to the target transaction identifier; wherein, one target transaction identifier corresponds to one retrieval index; The processing module is further configured to determine, based on the search index, a historical version snapshot of the target home decoration product corresponding to the search index; wherein, the historical version snapshot includes one or more of the following: product main table snapshot, inventory table snapshot, price table snapshot, and request table snapshot; The processing module is further configured to generate a prompt message based on the historical version snapshot; wherein the prompt message is used to indicate the search results corresponding to the target transaction identifier.

7. The home decoration product management device according to claim 6, characterized in that, The processing module is also used to initiate a database transaction and generate a theoretical transaction identifier in response to a product operation on a selected home decoration product; wherein, the product operation includes any one of modifying the product price, modifying the product inventory, and adjusting the product attributes; The processing module is further configured to obtain a snapshot of the status of the associated table of the selected home decoration product during the execution of the database transaction; wherein the associated table includes one or more of the main product table, inventory table, and price table; The processing module is also used to establish a binding relationship between the state snapshot and the theoretical transaction identifier.

8. The management device for home decoration products according to claim 6, characterized in that, The processing module is further configured to, in response to a product operation on a selected home decoration product, obtain a request identifier corresponding to the product operation; wherein, one request identifier corresponds to one operator information; The processing module is further configured to establish a correspondence between the request identifier and the theoretical transaction identifier of the selected home decoration product, and write the correspondence into the request table.

9. An electronic device, characterized in that, The electronic device includes: processor; A memory configured to store processor-executable instructions; The processor is configured to execute the instructions to implement the management method for home furnishing products as described in any one of claims 1-5.

10. A computer program product, comprising instructions, characterized in that, When the instructions are executed on an electronic device, the electronic device causes the electronic device to perform the management method for home furnishing products as described in any one of claims 1-5.

Images