Real estate business processing method, device, equipment, storage medium and program product

Abstract

The application relates to a real estate business processing method and device, computer equipment, a storage medium and a computer program product, and relates to the technical field of big data. The method comprises the following steps: receiving a real estate business processing request sent by each real estate system through a unified interface, the request carrying house information; performing a judgment step to query whether the house information is locked and whether the house information corresponds to an unprocessed successful business request through unified processing logic; if yes, marking the real estate business processing request as an unprocessed successful business request, setting a processing order of the unprocessed successful business request according to the order of the real estate business processing request; regularly acquiring the unprocessed successful business request, and continuing the above judgment step until the unprocessed successful business request is processed successfully; and if no, locking the house information and processing the business. The method can uniformly process business processing requests of each real estate system and ensure consistent data processing.

Description

Technical Field

[0001] This application relates to the field of big data technology, and in particular to a method, apparatus, computer equipment, storage medium and computer program product for processing real estate transactions. Background Technology

[0002] With the development of computer technology, fast and convenient business processing has become a popular trend in the real estate sector. Real estate transactions, as one of the most frequent business processes, involve multiple scenarios, including comprehensive building and housing inquiries, two-dimensional building list configuration management, building list registration status management, administrative restriction management, overdue restriction management, whitelist management, special housing registration status management, housing ownership supplementary registration management, property rights archiving management, real estate property rights information inquiry, and building push service management. These scenarios involve data processing from multiple systems, including the building list system, transaction system, and real estate registration system. The building list system manages building data, visually displaying building, floor, and housing information, categorizing housing as commercial housing, resettlement housing, existing housing, and parking spaces. The transaction system manages the entire housing transaction process, including housing price declaration, purchase intention management, drafting purchase contracts, and online housing registration. The real estate registration system registers real estate property rights; any changes to real estate-related information require registration and modification in the real estate registration system.

[0003] In traditional technology, for business documents pushed by the transaction system and the real estate registration system, the property listing system processes them based on the functional logic of the corresponding system. This requires the property listing system to set up a set of functional logic processing code for each system and process them. As a result, the property listing system calls the corresponding logic processing code of each system to process the business documents, which will lead to inconsistencies in business processing. For example, business documents that have been released from seizure may still not be able to be processed. Summary of the Invention

[0004] Therefore, it is necessary to provide a real estate business processing method, apparatus, computer equipment, computer-readable storage medium, and computer program product that can uniformly process business processing requests from various real estate systems and ensure consistent data processing, in order to address the aforementioned technical problems.

[0005] Firstly, this application provides a method for processing real estate transactions, the method comprising:

[0006] The system receives real estate business processing requests from various real estate systems through a unified interface. These requests carry housing information.

[0007] The unified processing logic is used to query whether the house information is locked and whether the house information corresponds to any unprocessed business requests.

[0008] When the property information is locked or there are unprocessed business requests corresponding to the property information, the property business processing request is marked as an unprocessed business request, and the processing order of the unprocessed business requests is set according to the order of the property business processing requests.

[0009] Periodically retrieve business requests marked as unsuccessfully processed, and continue to execute the steps of querying whether the house information is locked and whether the house information corresponds to an unsuccessfully processed business request based on the processing order of the unsuccessfully processed business requests, until the unsuccessfully processed business requests are successfully processed.

[0010] When the house information is not locked and there are no unprocessed business requests for the house information, the house information is locked and business processing is performed.

[0011] In one embodiment, before querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic, the method further includes:

[0012] The real estate business processing request is verified by calling a pre-set business type table through a unified processing logic.

[0013] When the real estate business processing request fails to verify, the corresponding real estate system is notified of the failure.

[0014] When the real estate business processing request is successfully verified, the process continues to execute the steps of querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic.

[0015] In one embodiment, the step of calling a pre-set business type table through unified processing logic to perform business verification on the real estate business processing request includes:

[0016] The unified processing logic determines whether the business type corresponding to the real estate business processing request exists in a pre-set business type table.

[0017] If the business type corresponding to the real estate business processing request exists in a pre-set business type table, determine whether the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type;

[0018] If the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type, then the business verification of the real estate business processing request is successful.

[0019] If the business type corresponding to the real estate business processing request does not exist in the pre-set business type table, or if the scope of data changes involved in the real estate business processing request is inconsistent with the scope of data changes corresponding to the business type, the business verification of the real estate business processing request will fail.

[0020] In one embodiment, receiving real estate business processing requests sent by various real estate systems through a unified interface includes:

[0021] Receive batch real estate business processing requests from various real estate systems through a unified interface;

[0022] After locking the house information and performing business processing, the process includes:

[0023] The batch of business processing results corresponding to the batch of real estate business processing requests will be submitted in batches.

[0024] In one embodiment, after locking the house information and performing business processing, the process includes:

[0025] Check if there is a business record in the business summary table that corresponds to the real estate business processing request; the business record in the business summary table includes personnel information.

[0026] If a business record corresponding to the real estate business processing request exists in the business summary table, update the business summary table;

[0027] If there is no business record corresponding to the real estate business processing request in the business summary table, add the business record to the business summary table.

[0028] Check if there is personnel information in the personnel information table that corresponds to the real estate business processing request; the personnel information table is used to store detailed personnel information.

[0029] If no personnel information corresponding to the real estate business processing request exists in the personnel information table, the personnel information is added to the personnel information table.

[0030] If the personnel information table contains personnel information corresponding to the real estate business processing request, no processing will be performed.

[0031] In one embodiment, the method further includes:

[0032] Receive business data query requests;

[0033] When the business data query request needs to query multiple real estate systems and this system, it is determined whether there is a logical dependency relationship between the business data query request and the queries in the multiple real estate systems and this system.

[0034] When the business data query request does not have a logical dependency relationship with the queries in the multiple real estate systems and this system, the business data query is performed in parallel in the multiple real estate systems and this system.

[0035] By combining the business data query results from the multiple real estate systems and this system, the query result corresponding to the business data query request is obtained.

[0036] In one embodiment, performing business data queries in this system includes:

[0037] When the business data query request in this system is a business query, the corresponding business information is obtained by querying the business summary table.

[0038] When the business data query request in this system is a personnel information query, the corresponding personnel information is obtained by querying the personnel information table.

[0039] When the business data query request in this system is to query business information through personnel information, the corresponding personnel information is obtained by querying the personnel information table, and the business information is obtained by querying the business summary table based on the personnel information.

[0040] In one embodiment, performing business data queries in this system includes:

[0041] Retrieve the query fields from the query conditions corresponding to the business data query request;

[0042] When the query field is an update field, adjust the query field to an index field;

[0043] Business data queries are performed based on the indexed fields.

[0044] In one embodiment, performing business data queries in this system includes:

[0045] When the query conditions corresponding to the business data query request contain a target field, a search engine is added for the fuzzy conditions of the target field;

[0046] The target business data is obtained by querying based on the target field using the added search.

[0047] Add an index to the sorting field;

[0048] Deep pagination is performed on the target business data based on the sorting field with added index.

[0049] Secondly, this application also provides a real estate transaction processing device, the device comprising:

[0050] The receiving module is used to receive real estate business processing requests sent by various real estate systems through a unified interface. The real estate business processing requests carry housing information.

[0051] The query module is used to query whether the house information is locked and whether the house information corresponds to any unprocessed business requests through a unified processing logic.

[0052] The marking module is used to mark the real estate business processing request as an unprocessed business request when the house information is locked or the house information corresponds to an unprocessed business request, and to set the processing order of the unprocessed business requests according to the order of the real estate business processing requests.

[0053] The first business processing module is used to periodically acquire business requests marked as unsuccessfully processed, and continue to execute the steps of querying whether the house information is locked and whether the house information corresponds to unsuccessfully processed business requests based on the processing order of the unsuccessfully processed business requests, until the unsuccessfully processed business requests are successfully processed.

[0054] The second business processing module is used to lock the house information and perform business processing when the house information is not locked and there are no unprocessed business requests for the house information.

[0055] Thirdly, this application also provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps of the method in any of the above embodiments.

[0056] Fourthly, this application also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the methods in any of the above embodiments.

[0057] Fifthly, this application also provides a computer program product, including a computer program that, when executed by a processor, implements the steps of the methods in any of the above embodiments.

[0058] The aforementioned real estate business processing method, apparatus, computer equipment, storage medium, and computer program product receive real estate business processing requests sent by various real estate systems through a unified interface. These requests carry property information. A unified processing logic queries whether the property information is locked and whether it corresponds to any unprocessed business requests. This unified processing logic places all related external processes on a single interface, handling common and critical business points from different external real estate systems together, balancing business needs while facilitating code maintenance. When property information is locked or corresponds to unprocessed business requests, the request is marked as unprocessed, and its processing order is set according to the order of the requests. Unprocessed requests are periodically retrieved, and the process continues based on their processing order, reiterating the steps of querying whether property information is locked and whether it corresponds to any unprocessed business requests, until the unprocessed requests are successfully processed. This ensures data consistency by processing business requests from different external real estate systems together and requiring subsequent processing to wait for previous processing to succeed. Attached Figure Description

[0059] To more clearly illustrate the technical solutions in the embodiments or related technologies of this application, the drawings used in the description of the embodiments or related technologies will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0060] Figure 1 This is an application environment diagram of a real estate business processing method in one embodiment;

[0061] Figure 2 This is a flowchart illustrating a real estate business processing method in one embodiment;

[0062] Figure 3 This is a flowchart illustrating the receipt of housing data from various housing systems in one embodiment.

[0063] Figure 4 This is a flowchart of the business processing for personnel information in one embodiment;

[0064] Figure 5 This is a structural block diagram of a real estate transaction processing device in one embodiment;

[0065] Figure 6 This is an internal structural diagram of a computer device in one embodiment. Detailed Implementation

[0066] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0067] The real estate business processing method provided in this application embodiment can be applied to, for example, Figure 1 The application environment is shown. Terminal 102 communicates with the backend 104 via a network. A data storage system stores the data that the backend 104 needs to process. The data storage system can be integrated into the backend 104 or placed on the cloud or other network servers. The backend 104 includes multiple real estate systems and a building information system. These multiple real estate systems may include a transaction system and a real estate registration system, etc., without specific limitations. The building information system manages building data, visually displaying building information, floor information, and housing information, including housing categories such as commercial housing, resettlement housing, existing housing, and parking spaces. The transaction system manages the entire housing transaction process, including housing price declaration, purchase intention management, drafting purchase contracts, and online housing registration. The real estate registration system registers real estate property rights; any changes to real estate-related information require registration and modification in the real estate registration system.

[0068] The property listing system receives property business processing requests from various property systems through a unified interface. These requests carry property information. The system uses unified processing logic to check if the property information is locked and if there are any unprocessed business requests associated with it. When a property is locked or has an unprocessed business request, the system marks the request as unprocessed and sets its processing order based on the order of the requests. It periodically retrieves marked unprocessed requests and continues executing the steps of checking if the property is locked and if there are any unprocessed business requests based on their processing order, until the unprocessed requests are successfully processed. When the property is not locked and there are no unprocessed business requests, the system locks the property and processes the request. This approach receives real estate business processing requests from various real estate systems via a unified interface. These requests carry property information. A unified processing logic checks whether the property information is locked and whether it corresponds to any unprocessed business requests. This unified interface handles all related processing logic, addressing common and critical business points from different external real estate systems together. This approach balances business logic while facilitating code maintenance. When property information is locked or corresponds to an unprocessed business request, the request is marked as unprocessed. The processing order of these unprocessed requests is then set according to their order of occurrence. Periodically, marked unprocessed requests are retrieved, and the process of checking for locked and unprocessed property information using the unified processing logic continues until the unprocessed requests are successfully processed. This approach ensures data consistency by processing requests from different external real estate systems together and waiting for previous requests to succeed before proceeding with subsequent processing.

[0069] Terminal 102 can be, but is not limited to, various personal computers, laptops, smartphones, tablets, IoT devices, and portable wearable devices. IoT devices can include smart speakers, smart TVs, smart air conditioners, smart in-vehicle devices, etc. Portable wearable devices can include smartwatches, smart bracelets, head-mounted devices, etc. The various real estate systems and building information systems in the backend 104 can be implemented using independent servers or server clusters composed of multiple servers.

[0070] In one exemplary embodiment, such as Figure 2 As shown, a method for processing real estate transactions is provided, which can be applied to... Figure 1Taking the building information system in China as an example, the following steps are included:

[0071] S202: Receive real estate business processing requests sent by various real estate systems through a unified interface. The real estate business processing requests carry housing information.

[0072] Specifically, the unified interface is the interface through which the building information system communicates with other real estate systems. Each real estate system communicates with the building information system through the unified interface.

[0073] A real estate business processing request is for processing housing information in the building information system. It may include adding data from other real estate systems, such as inserting new data into the building information system or updating the data in the building information system. This real estate business processing request carries housing information.

[0074] Optionally, the system receives real estate business processing requests from various real estate systems through a unified interface, including receiving batch real estate business processing requests from each real estate system through the unified interface. To avoid multiple read / write operations on the database and to process housing information in batches, the unified interface allows for receiving batch real estate business processing requests for housing information all at once. Subsequently, after processing the real estate business processing requests, the processed housing information is submitted all at once, for example, using the SqlSession BATCH method for batch processing.

[0075] S204: Use unified processing logic to query whether the house information is locked and whether there are any unprocessed business requests corresponding to the house information.

[0076] Specifically, the unified processing logic is the unified processing logic corresponding to real estate business processing requests from multiple real estate systems. It extracts the commonalities and key points of the business from different real estate systems and processes them together to obtain the unified processing logic. This takes into account the business and is also easy to maintain. By extracting the core processing logic and separating it from the business type, the code can be extended to add new business types in the future, thereby improving the scalability of the code and reducing the system maintenance cost.

[0077] Whether the property information is locked, or whether it is being processed, means that the property information needs to be locked before it can be processed to prevent other operations. Checking whether the property information corresponds to any unprocessed business requests is because the business processing of property information has a certain logic. For example, other business cannot be processed for property information that has not been released from seizure. Therefore, before processing other business, the seizure of the property information needs to be released first. Thus, the business processing requests for property information have a certain order, so it is also necessary to check whether there are any unprocessed business requests for that property information.

[0078] S206: When the housing information is locked or there are unprocessed business requests corresponding to the housing information, mark the real estate business processing request as an unprocessed business request, and set the processing order of the unprocessed business requests according to the order of the real estate business processing requests.

[0079] Specifically, when a property information is locked or there are unprocessed business requests associated with that property information, the current property business processing request cannot be processed. Therefore, the property listing system marks the property business processing request as an unprocessed business request and stores it. Since there is a sequence to the processing of each business, the processing order of unprocessed business requests is set according to the order in which the property business processing requests are processed. When processing the property business processing request again later, the system can determine whether there are any unprocessed business requests based on this sequence.

[0080] S208: Periodically retrieve business requests marked as unsuccessfully processed, and continue to execute the steps of querying whether the house information is locked and whether the house information corresponds to unsuccessfully processed business requests based on the processing order of the unsuccessfully processed business requests, until the unsuccessfully processed business requests are successfully processed.

[0081] Specifically, timing can be handled through scheduled tasks. When an unprocessed business request is stored, a scheduled task corresponding to that request is directly generated. This scheduled task can then be activated periodically to process the request. It's important to note that different scheduled tasks can be configured for different unprocessed business requests, and these tasks can be processed in parallel without interfering with each other. Each scheduled task can check whether the property information is locked and whether there are any corresponding unprocessed business requests. Checking for corresponding unprocessed business requests can be done by determining if there are any prior unprocessed requests. If so, the task waits for the next scheduled task to start; otherwise, if only subsequent unprocessed requests exist, or if no unprocessed requests exist, the task is responded to directly.

[0082] S210: When the housing information is not locked and there are no unprocessed business requests for the housing information, lock the housing information and perform business processing.

[0083] In this embodiment, the housing information is locked before processing, and then the business processing is carried out. This can ensure the order of processing of the business corresponding to the housing information and avoid data inconsistency.

[0084] Housing information is the smallest unit of granularity. Locking this smallest unit of granularity can prevent it from affecting the processing of other housing information.

[0085] Unprocessed business requests can be written to a log table and await processing by a scheduled task. If the number of scheduled tasks launched reaches a certain threshold and the business request has not yet been processed, an email will be sent to the operations and maintenance personnel. If the business request is successfully processed, the data in the log table will be deleted.

[0086] Optionally, after locking the property information and performing business processing, the process includes: batch submitting the business processing results corresponding to a batch of property business processing requests. The property information lock is only released after the batch submission is successful; if the batch submission fails, the transaction is rolled back and an exception is thrown.

[0087] The aforementioned real estate business processing method receives real estate business processing requests from various real estate systems through a unified interface. These requests carry property information. A unified processing logic is used to query whether the property information is locked and whether it corresponds to any unprocessed business requests. This unified processing logic places all related external processes on a single interface, handling common and critical business points from different external real estate systems together. This approach balances business needs while also facilitating code maintenance. When property information is locked or corresponds to an unprocessed business request, the request is marked as unprocessed. The processing order of these unprocessed requests is set according to their order. Unprocessed requests are periodically retrieved, and the process continues based on their processing order, reiterating the steps of querying whether the property information is locked and whether it corresponds to any unprocessed business requests, until the unprocessed requests are successfully processed. This approach ensures data consistency by processing requests from different external real estate systems together and requiring subsequent processing to wait for previous processing to succeed.

[0088] In one embodiment, before querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic, the method further includes: calling a pre-set business type table through unified processing logic to perform business verification on the real estate business processing request; when the business verification of the real estate business processing request fails, sending feedback on the business verification failure to the corresponding real estate system; when the business verification of the real estate business processing request succeeds, continuing to execute the steps of querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic.

[0089] In one embodiment, a pre-set business type table is invoked through unified processing logic to perform business verification on real estate business processing requests. This includes: determining whether the business type corresponding to the real estate business processing request exists in the pre-set business type table; if the business type corresponding to the real estate business processing request exists in the pre-set business type table, determining whether the data change range involved in the real estate business processing request is consistent with the data change range corresponding to the business type; if the data change range involved in the real estate business processing request is consistent with the data change range corresponding to the business type, the business verification of the real estate business processing request is successful; if the business type corresponding to the real estate business processing request does not exist in the pre-set business type table, or the data change range involved in the real estate business processing request is inconsistent with the data change range corresponding to the business type, the business verification of the real estate business processing request fails.

[0090] Specifically, in combination Figure 3 As shown, Figure 3 This is a flowchart illustrating the process of receiving housing data from various real estate systems in one embodiment. In this embodiment, the property listing system receives business processing requests from each real estate system. First, it uses a unified processing logic to call a pre-set business type table to verify the real estate business processing request. If the verification fails, an exception is thrown; if the verification succeeds, subsequent business processing proceeds. The business verification logic uses a newly added business type table, which includes all businesses from different channels. New businesses can be added to this table for rapid expansion. During verification, the unified processing logic only needs to call this business type table. For example, based on the real estate system's permitted business types, the unified processing logic checks if the business type corresponding to the real estate business processing request exists in the pre-set business type table. If it exists, it checks if the data change range involved in the real estate business processing request matches the data change range corresponding to the business type. Only real estate business processing requests where the business type exists in the business type table and the data change range matches can pass the verification. After passing the verification, the unified processing logic performs the business processing.

[0091] In the above embodiments, a new business type table is added. Business types not included in this table are not allowed to pass business verification. The business type table records the modifiable data points for this business transaction, controlling the scope of data changes and ensuring data security. Furthermore, common and key business points from different real estate systems are extracted and processed together, reducing code redundancy and simplifying maintenance. The internal processing logic ensures data consistency and security. Business logic processing begins by adding a business lock to the smallest granularity of house information. The lock is released upon successful or failed processing, but failed processing writes data to the log. After a scheduled task is started, successful processing deletes the log data and backs it up to the historical log table.

[0092] In one embodiment, after locking the housing information and performing business processing, the process includes: querying the business summary table to see if there is a business record corresponding to the real estate business processing request; the business records in the business summary table include personnel information; if there is a business record corresponding to the real estate business processing request in the business summary table, update the business summary table; if there is no business record corresponding to the real estate business processing request in the business summary table, add the business record to the business summary table; querying the personnel information table to see if there is personnel information corresponding to the real estate business processing request; the personnel information table is used to store detailed personnel information; if there is no personnel information corresponding to the real estate business processing request in the personnel information table, add the personnel information to the personnel information table; if there is personnel information corresponding to the real estate business processing request in the personnel information table, no processing is performed.

[0093] The business summary table records business information and includes redundant personnel information, which is uniquely derived from the personnel's name, ID number, and relationship identifier. The personnel information table records personnel information, uniquely derived from the three key personnel elements and phone number. This two-table storage approach, instead of a single table, avoids excessive data. The redundant personnel names and ID numbers in the business summary table eliminate the need to query the personnel information table, handling most scenarios. Furthermore, duplicate personnel information is not recorded multiple times. Separating personnel and business data keeps personnel data volume manageable and prevents unlimited growth.

[0094] Combination Figure 4 As shown, Figure 4This is a flowchart of the business processing for personnel information in one embodiment. In this embodiment, after business processing, business records are saved. First, a unique query is performed in the business summary table based on the business item number, household number, and business type to determine whether a corresponding business record exists in the business summary table. If it exists, the business summary table is updated; otherwise, a business record is added to the business summary table. Next, the personnel information table is queried to see if personnel information corresponding to the real estate business processing request exists. Specifically, this can be verified using the three elements of personnel, such as the person's name, ID number, and relationship identifier. If it does not exist, it is added to the personnel information table; otherwise, no processing is required.

[0095] In the above embodiments, personnel and business are separated, making the amount of personnel data controllable and preventing it from growing indefinitely.

[0096] In one embodiment, the above-mentioned real estate business processing method further includes: receiving a business data query request; when the business data query request needs to query multiple real estate systems and the current system, determining whether there is a logical dependency relationship between the business data query request and the queries in the multiple real estate systems and the current system; when there is no logical dependency relationship between the business data query request and the queries in the multiple real estate systems and the current system, performing business data queries in parallel in the multiple real estate systems and the current system; and combining the business data query results of the multiple real estate systems and the current system to obtain the query result corresponding to the business data query request.

[0097] Specifically, this embodiment mainly focuses on data querying. After receiving a data query request from the terminal, the backend determines whether the business data query request needs to be queried in multiple real estate systems and the current system. If so, it determines whether there is a logical dependency between the business data query request and the queries in multiple real estate systems and the current system. If not, the data can be processed in parallel, which can save processing time. Finally, it only needs to combine the business data query results from multiple real estate systems and the current system to obtain the query result corresponding to the business data query request.

[0098] In the above embodiments, parallel data queries are performed on data that have no logical dependencies in multiple real estate systems and in this system, saving processing time.

[0099] In one embodiment, performing business data query in this system includes: when the business data query request in this system is a business query, querying the business summary table to obtain the corresponding business information; when the business data query request in this system is a personnel information query, querying the personnel information table to obtain the corresponding personnel information; when the business data query request in this system is to query business information through personnel information, querying the personnel information table to obtain the corresponding personnel information, and querying the business summary table based on the personnel information to obtain the business information.

[0100] Specifically, because this system, namely the building information system, includes a business summary table and a personnel information table, a large amount of business data is stored in separate tables. This results in time-consuming queries in the personnel information table due to its massive data volume and significant amount of duplicate data. The business summary table, which redundantly contains personnel names and ID numbers, can handle most scenarios without needing to query the user business information table.

[0101] For scenarios requiring querying personnel information, redundant personnel relationship identifiers can be used in conjunction with the personnel information table (which contains significantly less data than the user business personnel information table) to perform queries via primary key associations, which can also greatly improve performance.

[0102] In addition, the query for houses by personnel information can be done in two steps: first, query the personnel information table to obtain the personnel identifier, and then query the business summary table. Both are single-table queries with indexes, so the response is very fast. After optimization, the response time has been reduced.

[0103] In the above embodiments, the separation of personnel and business relationships can prevent the data volume from growing indefinitely and improve query and storage performance. By using multi-table storage, the corresponding table can be queried based on the query information, which can improve query speed.

[0104] In one embodiment, performing business data query in this system includes: obtaining the query field in the query conditions corresponding to the business data query request; when the query field is an update field, adjusting the query field to an index field; and performing business data query based on the index field.

[0105] Specifically, since too many indexes can weaken the performance of insertion and update, this application collects query conditions for various scenarios in advance, adjusts some unreasonable query conditions, finds the most suitable index fields, these index fields are not update fields, have good stability, and establishes a correspondence between update fields and index fields.

[0106] Subsequently, upon receiving the query conditions, if the query field in the query conditions is an update field, the update field is modified to be the index field based on the relationship between the update field and the index field, thereby performing the query based on the index field, which improves stability.

[0107] In one embodiment, performing business data query in this system includes: when a target field exists in the query conditions corresponding to the business data query request, adding a search engine for the fuzzy conditions of the target field; obtaining the target business data by querying based on the target field using the added search; adding an index to the sorting field; and performing deep pagination on the target business data based on the indexed sorting field.

[0108] Specifically, the building information query and comprehensive housing query interfaces involve sorting the entire table of data and querying fuzzy location conditions, which takes a relatively long time. Therefore, in this embodiment, an index is added to the sorting field and a search engine is added for fuzzy location conditions to achieve a faster response.

[0109] When the target field is location, a search engine is added to query the target business data based on the target field, and then the target business data is indexed according to the sorting field and deeply paginated.

[0110] Deep pagination refers to storing all the data that meets the requirements in memory at once, and then querying memory when paginating.

[0111] In the above embodiments, the introduction of a search engine and deep pagination improves query speed for faster response.

[0112] It should be understood that although the steps in the flowcharts of the above embodiments are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the above embodiments may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.

[0113] Based on the same inventive concept, this application also provides a real estate business processing apparatus for implementing the aforementioned real estate business processing method. The solution provided by this apparatus is similar to the implementation scheme described in the above method; therefore, the specific limitations in one or more embodiments of the real estate business processing apparatus provided below can be found in the limitations of the real estate business processing method described above, and will not be repeated here.

[0114] In one exemplary embodiment, such as Figure 5 As shown, a real estate business processing device is provided, including: a receiving module 501, a query module 502, a marking module 503, a first business processing module 504, and a second business processing module 505, wherein:

[0115] The receiving module 501 is used to receive real estate business processing requests sent by various real estate systems through a unified interface, wherein the real estate business processing requests carry housing information.

[0116] The query module 502 is used to query whether the house information is locked and whether the house information corresponds to any unprocessed business requests through a unified processing logic.

[0117] The marking module 503 is used to mark the real estate business processing request as an unprocessed business request when the house information is locked or the house information corresponds to an unprocessed business request, and to set the processing order of the unprocessed business requests according to the order of the real estate business processing requests.

[0118] The first business processing module 504 is used to periodically acquire business requests marked as unsuccessfully processed, and continue to execute the steps of querying whether the house information is locked and whether the house information corresponds to an unsuccessfully processed business request based on the processing order of the unsuccessfully processed business requests, until the unsuccessfully processed business requests are successfully processed.

[0119] The second business processing module 505 is used to lock the house information and perform business processing when the house information is not locked and there are no unprocessed business requests in the house information.

[0120] In one embodiment, the aforementioned real estate business processing device further includes: a verification module, used to call a pre-set business type table through unified processing logic to perform business verification on real estate business processing requests; when the business verification of a real estate business processing request fails, to report the business verification failure information to the corresponding real estate system; when the business verification of a real estate business processing request succeeds, to continue executing the steps of querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic.

[0121] In one embodiment, the verification module is further configured to determine, through unified processing logic, whether the business type corresponding to the real estate business processing request exists in a pre-set business type table; if the business type corresponding to the real estate business processing request exists in the pre-set business type table, it determines whether the data change range involved in the real estate business processing request is consistent with the data change range corresponding to the business type; if the data change range involved in the real estate business processing request is consistent with the data change range corresponding to the business type, the business verification of the real estate business processing request is successful; if the business type corresponding to the real estate business processing request does not exist in the pre-set business type table, or the data change range involved in the real estate business processing request is inconsistent with the data change range corresponding to the business type, the business verification of the real estate business processing request fails.

[0122] In one embodiment, the receiving module 501 is further configured to receive batch real estate business processing requests sent by various real estate systems through a unified interface.

[0123] The second business processing module 505 mentioned above is also used to submit the business processing results corresponding to a batch of real estate business processing requests in batches.

[0124] In one embodiment, the aforementioned real estate business processing device further includes a business submission module, used to query whether a business record corresponding to a real estate business processing request exists in the business summary table; the business records in the business summary table include personnel information; when a business record corresponding to a real estate business processing request exists in the business summary table, the business summary table is updated; when no business record corresponding to a real estate business processing request exists in the business summary table, a business record is added to the business summary table, and the device queries the personnel information table to see if personnel information corresponding to a real estate business processing request exists; the personnel information table stores detailed personnel information; when no personnel information corresponding to a real estate business processing request exists in the personnel information table, personnel information is added to the personnel information table; when personnel information corresponding to a real estate business processing request exists in the personnel information table, no processing is performed.

[0125] In one embodiment, the above-mentioned real estate business processing device further includes: a business query module 502, used to receive a business data query request; when the business data query request needs to query multiple real estate systems and the current system, it determines whether there is a logical dependency relationship between the business data query request and the queries in multiple real estate systems and the current system; when there is no logical dependency relationship between the business data query request and the queries in multiple real estate systems and the current system, it performs business data queries in multiple real estate systems and the current system in parallel.

[0126] By combining the business data query results from multiple real estate systems and this system, the query results corresponding to the business data query request are obtained.

[0127] In one embodiment, the business query module 502 is further configured to: when the business data query request in the system is a business query, query the business summary table to obtain the corresponding business information; when the business data query request in the system is a personnel information query, query the personnel information table to obtain the corresponding personnel information; when the business data query request in the system is a query for business information through personnel information, query the personnel information table to obtain the corresponding personnel information, and query the business summary table based on the personnel information to obtain the business information.

[0128] In one embodiment, the business query module 502 is further configured to obtain the query field in the query conditions corresponding to the business data query request; when the query field is an update field, adjust the query field to an index field; and perform business data query based on the index field.

[0129] In one embodiment, the business query module 502 is further configured to add a search engine to the fuzzy conditions of the target field when the query conditions corresponding to the business data query request contain a target field; obtain the target business data by querying based on the target field through the added search; add an index to the sorting field; and perform deep pagination on the target business data based on the indexed sorting field.

[0130] Each module in the aforementioned real estate transaction processing device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in a computer device, or stored in the memory of a computer device as software, so that the processor can call and execute the corresponding operations of each module.

[0131] In one exemplary embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 6 As shown, this computer device includes a processor, memory, input / output interfaces (I / O), and a communication interface. The processor, memory, and I / O interfaces are connected via a system bus, and the communication interface is also connected to the system bus via the I / O interfaces. The processor provides computational and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides the environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The database stores business summary tables and personnel information tables. The I / O interfaces are used for exchanging information between the processor and external devices. The communication interface is used for communicating with external terminals via a network connection. When the computer program is executed by the processor, it implements a real estate business processing method.

[0132] Those skilled in the art will understand that Figure 6 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0133] In an exemplary embodiment, a computer device is provided, including a memory and a processor. The memory stores a computer program, and the processor executes the computer program to perform the following steps: receiving real estate business processing requests sent by various real estate systems through a unified interface, the real estate business processing requests carrying housing information; querying whether the housing information is locked and whether the housing information corresponds to any unprocessed business requests through unified processing logic; when the housing information is locked or the housing information corresponds to any unprocessed business requests, marking the real estate business processing request as an unprocessed business request, and setting the processing order of the unprocessed business requests according to the order of the real estate business processing requests; periodically acquiring the marked unprocessed business requests, and continuing to execute the steps of querying whether the housing information is locked and whether the housing information corresponds to any unprocessed business requests based on the processing order of the unprocessed business requests, until the unprocessed business requests are successfully processed; when the housing information is not locked and there are no unprocessed business requests for the housing information, locking the housing information and performing business processing.

[0134] In one embodiment, before the processor executes the computer program to query whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic, the process further includes: calling a pre-set business type table through unified processing logic to perform business verification on the real estate business processing request; when the business verification of the real estate business processing request fails, sending feedback on the business verification failure to the corresponding real estate system; when the business verification of the real estate business processing request succeeds, continuing to execute the steps of querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic.

[0135] In one embodiment, when the processor executes a computer program, it implements a unified processing logic to call a pre-set business type table to perform business verification on a real estate business processing request. This includes: determining, through the unified processing logic, whether the business type corresponding to the real estate business processing request exists in the pre-set business type table; if the business type corresponding to the real estate business processing request exists in the pre-set business type table, determining whether the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type; if the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type, the business verification of the real estate business processing request is successful; if the business type corresponding to the real estate business processing request does not exist in the pre-set business type table, or if the scope of data changes involved in the real estate business processing request is inconsistent with the scope of data changes corresponding to the business type, the business verification of the real estate business processing request fails.

[0136] In one embodiment, the processor, when executing a computer program, receives real estate business processing requests sent by various real estate systems through a unified interface, including: receiving batches of real estate business processing requests sent by various real estate systems through a unified interface; locking the housing information and performing business processing, and then: submitting the business processing results corresponding to the batches of real estate business processing requests in batches.

[0137] In one embodiment, after the processor executes the computer program to lock the housing information and perform business processing, the process includes: querying the business summary table to see if there is a business record corresponding to the real estate business processing request; the business records in the business summary table include personnel information; if there is a business record corresponding to the real estate business processing request in the business summary table, updating the business summary table; if there is no business record corresponding to the real estate business processing request in the business summary table, adding the business record to the business summary table, and querying the personnel information table to see if there is personnel information corresponding to the real estate business processing request; the personnel information table is used to store detailed personnel information; if there is no personnel information corresponding to the real estate business processing request in the personnel information table, adding the personnel information to the personnel information table; if there is personnel information corresponding to the real estate business processing request in the personnel information table, no processing is performed.

[0138] In one embodiment, when the processor executes the computer program, it further implements the following steps: receiving a business data query request; when the business data query request needs to query multiple real estate systems and the current system, determining whether there is a logical dependency between the queries of the business data query request in the multiple real estate systems and the current system; when there is no logical dependency between the queries of the business data query request in the multiple real estate systems and the current system, performing business data queries in parallel in the multiple real estate systems and the current system; and combining the business data query results of the multiple real estate systems and the current system to obtain the query result corresponding to the business data query request.

[0139] In one embodiment, the business data query implemented by the processor when executing the computer program includes: when the business data query request in the system is a business query, querying the business summary table to obtain the corresponding business information; when the business data query request in the system is a personnel information query, querying the personnel information table to obtain the corresponding personnel information; when the business data query request in the system is to query business information through personnel information, querying the personnel information table to obtain the corresponding personnel information, and querying the business summary table based on the personnel information to obtain the business information.

[0140] In one embodiment, the business data query implemented by the processor when executing a computer program includes: obtaining the query field in the query conditions corresponding to the business data query request; adjusting the query field to an index field when the query field is an update field; and performing business data query based on the index field.

[0141] In one embodiment, the business data query implemented by the processor when executing the computer program includes: when a target field exists in the query conditions corresponding to the business data query request, adding a search engine for the fuzzy conditions of the target field; obtaining the target business data by querying based on the target field through the added search; adding an index to the sorting field; and performing deep pagination on the target business data based on the indexed sorting field.

[0142] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When executed by a processor, the computer program performs the following steps: receiving real estate business processing requests sent by various real estate systems through a unified interface, wherein the real estate business processing requests carry housing information; querying, through unified processing logic, whether the housing information is locked and whether the housing information corresponds to any unprocessed business requests; when the housing information is locked or the housing information corresponds to any unprocessed business requests, marking the real estate business processing requests as unprocessed business requests, and setting the processing order of the unprocessed business requests according to the order of the real estate business processing requests; periodically acquiring the marked unprocessed business requests, and continuing to execute the steps of querying, through unified processing logic, whether the housing information is locked and whether the housing information corresponds to any unprocessed business requests based on the processing order of the unprocessed business requests, until the unprocessed business requests are successfully processed; when the housing information is not locked and the housing information does not have any unprocessed business requests, locking the housing information and performing business processing.

[0143] In one embodiment, before the computer program, when executed by the processor, queries whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic, the method further includes: calling a pre-set business type table through unified processing logic to perform business verification on the real estate business processing request; when the business verification of the real estate business processing request fails, sending feedback on the business verification failure to the corresponding real estate system; when the business verification of the real estate business processing request succeeds, continuing to execute the steps of querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic.

[0144] In one embodiment, when a computer program is executed by a processor, it performs business verification on a real estate business processing request by calling a pre-set business type table through unified processing logic. This includes: determining whether the business type corresponding to the real estate business processing request exists in the pre-set business type table through unified processing logic; if the business type corresponding to the real estate business processing request exists in the pre-set business type table, determining whether the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type; if the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type, the business verification of the real estate business processing request is successful; if the business type corresponding to the real estate business processing request does not exist in the pre-set business type table, or the scope of data changes involved in the real estate business processing request is inconsistent with the scope of data changes corresponding to the business type, the business verification of the real estate business processing request fails.

[0145] In one embodiment, the computer program, when executed by a processor, receives real estate business processing requests sent by various real estate systems through a unified interface, including: receiving batches of real estate business processing requests sent by various real estate systems through the unified interface; locking the housing information and performing business processing, and then: submitting the business processing results corresponding to the batches of real estate business processing requests in batches.

[0146] In one embodiment, after the computer program is executed by the processor to lock the housing information and perform business processing, the process includes: querying the business summary table to see if there is a business record corresponding to the real estate business processing request; the business records in the business summary table include personnel information; if there is a business record corresponding to the real estate business processing request in the business summary table, updating the business summary table; if there is no business record corresponding to the real estate business processing request in the business summary table, adding the business record to the business summary table, and querying the personnel information table to see if there is personnel information corresponding to the real estate business processing request; the personnel information table is used to store detailed personnel information; if there is no personnel information corresponding to the real estate business processing request in the personnel information table, adding the personnel information to the personnel information table; if there is personnel information corresponding to the real estate business processing request in the personnel information table, no processing is performed.

[0147] In one embodiment, when the computer program is executed by the processor, it further implements the following steps: receiving a business data query request; when the business data query request needs to query multiple real estate systems and the current system, determining whether there is a logical dependency between the queries of the business data query request in the multiple real estate systems and the current system; when there is no logical dependency between the queries of the business data query request in the multiple real estate systems and the current system, performing business data queries in parallel in the multiple real estate systems and the current system; and combining the business data query results of the multiple real estate systems and the current system to obtain the query result corresponding to the business data query request.

[0148] In one embodiment, the business data query implemented by the computer program when executed by the processor includes: when the business data query request in the system is a business query, querying the business summary table to obtain the corresponding business information; when the business data query request in the system is a personnel information query, querying the personnel information table to obtain the corresponding personnel information; when the business data query request in the system is to query business information through personnel information, querying the personnel information table to obtain the corresponding personnel information, and querying the business summary table based on the personnel information to obtain the business information.

[0149] In one embodiment, the computer program, when executed by a processor, performs business data querying within the system, including: obtaining the query field from the query conditions corresponding to the business data query request; adjusting the query field to an index field when the query field is an update field; and performing business data querying based on the index field.

[0150] In one embodiment, the business data query implemented by the computer program when executed by the processor includes: when a target field exists in the query conditions corresponding to the business data query request, adding a search engine for the fuzzy conditions of the target field; obtaining the target business data by querying based on the target field through the added search; adding an index to the sorting field; and performing deep pagination on the target business data based on the indexed sorting field.

[0151] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, performs the following steps: receiving real estate business processing requests sent by various real estate systems through a unified interface, the real estate business processing requests carrying housing information; querying, through unified processing logic, whether the housing information is locked and whether the housing information corresponds to any unprocessed business requests; when the housing information is locked or the housing information corresponds to any unprocessed business requests, marking the real estate business processing requests as unprocessed business requests, and setting the processing order of the unprocessed business requests according to their order; periodically acquiring the marked unprocessed business requests, and continuing to execute the steps of querying, through unified processing logic, whether the housing information is locked and whether the housing information corresponds to any unprocessed business requests based on the processing order of the unprocessed business requests, until the unprocessed business requests are successfully processed; when the housing information is not locked and the housing information does not have any unprocessed business requests, locking the housing information and performing business processing.

[0152] In one embodiment, before the computer program, when executed by the processor, queries whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic, the method further includes: calling a pre-set business type table through unified processing logic to perform business verification on the real estate business processing request; when the business verification of the real estate business processing request fails, sending feedback on the business verification failure to the corresponding real estate system; when the business verification of the real estate business processing request succeeds, continuing to execute the steps of querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic.

[0153] In one embodiment, when a computer program is executed by a processor, it performs business verification on a real estate business processing request by calling a pre-set business type table through unified processing logic. This includes: determining whether the business type corresponding to the real estate business processing request exists in the pre-set business type table through unified processing logic; if the business type corresponding to the real estate business processing request exists in the pre-set business type table, determining whether the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type; if the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type, the business verification of the real estate business processing request is successful; if the business type corresponding to the real estate business processing request does not exist in the pre-set business type table, or the scope of data changes involved in the real estate business processing request is inconsistent with the scope of data changes corresponding to the business type, the business verification of the real estate business processing request fails.

[0154] In one embodiment, the computer program, when executed by a processor, receives real estate business processing requests sent by various real estate systems through a unified interface, including: receiving batches of real estate business processing requests sent by various real estate systems through the unified interface; locking the housing information and performing business processing, and then: submitting the business processing results corresponding to the batches of real estate business processing requests in batches.

[0155] In one embodiment, after the computer program is executed by the processor to lock the housing information and perform business processing, the process includes: querying the business summary table to see if there is a business record corresponding to the real estate business processing request; the business records in the business summary table include personnel information; if there is a business record corresponding to the real estate business processing request in the business summary table, updating the business summary table; if there is no business record corresponding to the real estate business processing request in the business summary table, adding the business record to the business summary table, and querying the personnel information table to see if there is personnel information corresponding to the real estate business processing request; the personnel information table is used to store detailed personnel information; if there is no personnel information corresponding to the real estate business processing request in the personnel information table, adding the personnel information to the personnel information table; if there is personnel information corresponding to the real estate business processing request in the personnel information table, no processing is performed.

[0156] In one embodiment, when the computer program is executed by the processor, it further implements the following steps: receiving a business data query request; when the business data query request needs to query multiple real estate systems and the current system, determining whether there is a logical dependency between the queries of the business data query request in the multiple real estate systems and the current system; when there is no logical dependency between the queries of the business data query request in the multiple real estate systems and the current system, performing business data queries in parallel in the multiple real estate systems and the current system; and combining the business data query results of the multiple real estate systems and the current system to obtain the query result corresponding to the business data query request.

[0157] In one embodiment, the business data query implemented by the computer program when executed by the processor includes: when the business data query request in the system is a business query, querying the business summary table to obtain the corresponding business information; when the business data query request in the system is a personnel information query, querying the personnel information table to obtain the corresponding personnel information; when the business data query request in the system is to query business information through personnel information, querying the personnel information table to obtain the corresponding personnel information, and querying the business summary table based on the personnel information to obtain the business information.

[0158] In one embodiment, the computer program, when executed by a processor, performs business data querying within the system, including: obtaining the query field from the query conditions corresponding to the business data query request; adjusting the query field to an index field when the query field is an update field; and performing business data querying based on the index field.

[0159] In one embodiment, the business data query implemented by the computer program when executed by the processor includes: when a target field exists in the query conditions corresponding to the business data query request, adding a search engine for the fuzzy conditions of the target field; obtaining the target business data by querying based on the target field through the added search; adding an index to the sorting field; and performing deep pagination on the target business data based on the indexed sorting field.

[0160] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, data stored, data displayed, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of the relevant data must comply with relevant regulations.

[0161] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

[0162] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0163] The embodiments described above are merely illustrative of several implementation methods of this application, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.

Claims

1. A method for processing real estate transactions, characterized in that, The method includes: The system receives real estate business processing requests from various real estate systems through a unified interface. These requests carry housing information. The unified processing logic queries whether the house information is locked and whether the house information corresponds to any unprocessed business requests. The unified processing logic is obtained by extracting the common and key points of the business of different real estate systems and processing them together. When the property information is locked or there are unprocessed business requests corresponding to the property information, the property business processing request is marked as an unprocessed business request, and the processing order of the unprocessed business requests is set according to the order of the property business processing requests. Periodically retrieve business requests marked as unprocessed, and based on the processing order of the unprocessed business requests, continue to execute the steps of querying whether the house information is locked and whether the house information corresponds to an unprocessed business request through unified processing logic. If there is a prior unprocessed business request, wait for the next start of the scheduled task; otherwise, directly respond to the retrieved business requests marked as unprocessed until the unprocessed business requests are successfully processed. When the house information is not locked and there are no unprocessed business requests for the house information, the house information is locked and business processing is performed. The process of receiving real estate business processing requests from various real estate systems through a unified interface includes: Receive batch real estate business processing requests from various real estate systems through a unified interface; After locking the house information and performing business processing, the process includes: The batch submission of the business processing results corresponding to the batch of real estate business processing requests includes submitting the processed house information all at once.

2. The method according to claim 1, characterized in that, Before querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic, the process also includes: The real estate business processing request is verified by calling a pre-set business type table through a unified processing logic. When the real estate business processing request fails to verify, the corresponding real estate system is notified of the failure. When the real estate business processing request is successfully verified, the process continues to execute the steps of querying whether the house information is locked and whether the house information corresponds to any unprocessed business requests through unified processing logic.

3. The method according to claim 2, characterized in that, The process of calling a pre-set business type table through unified processing logic to perform business verification on the real estate business processing request includes: The unified processing logic determines whether the business type corresponding to the real estate business processing request exists in a pre-set business type table. If the business type corresponding to the real estate business processing request exists in a pre-set business type table, determine whether the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type; If the scope of data changes involved in the real estate business processing request is consistent with the scope of data changes corresponding to the business type, then the business verification of the real estate business processing request is successful. If the business type corresponding to the real estate business processing request does not exist in the pre-set business type table, or if the scope of data changes involved in the real estate business processing request is inconsistent with the scope of data changes corresponding to the business type, the business verification of the real estate business processing request will fail.

4. The method according to any one of claims 1 to 3, characterized in that, After locking the house information and performing business processing, the process includes: Check if there is a business record in the business summary table that corresponds to the real estate business processing request; the business record in the business summary table includes personnel information. If a business record corresponding to the real estate business processing request exists in the business summary table, update the business summary table; If there is no business record corresponding to the real estate business processing request in the business summary table, add the business record to the business summary table. Check if there is personnel information in the personnel information table that corresponds to the real estate business processing request; the personnel information table is used to store detailed personnel information. If no personnel information corresponding to the real estate business processing request exists in the personnel information table, the personnel information is added to the personnel information table. If the personnel information table contains personnel information corresponding to the real estate business processing request, no processing will be performed.

5. The method according to claim 4, characterized in that, The method further includes: Receive business data query requests; When the business data query request needs to query multiple real estate systems and this system, it is determined whether there is a logical dependency relationship between the business data query request and the queries in the multiple real estate systems and this system. When the business data query request does not have a logical dependency relationship with the queries in the multiple real estate systems and this system, the business data query is performed in parallel in the multiple real estate systems and this system. By combining the business data query results from the multiple real estate systems and this system, the query result corresponding to the business data query request is obtained.

6. The method according to claim 5, characterized in that, This system allows for business data queries, including: When the business data query request in this system is a business query, the corresponding business information is obtained by querying the business summary table. When the business data query request in this system is a personnel information query, the corresponding personnel information is obtained by querying the personnel information table. When the business data query request in this system is to query business information through personnel information, the corresponding personnel information is obtained by querying the personnel information table, and the business information is obtained by querying the business summary table based on the personnel information.

7. The method according to claim 5, characterized in that, This system allows for business data queries, including: Retrieve the query fields from the query conditions corresponding to the business data query request; When the query field is an update field, adjust the query field to an index field; Business data queries are performed based on the indexed fields.

8. The method according to claim 5, characterized in that, This system allows for business data queries, including: When the query conditions corresponding to the business data query request contain a target field, a search engine is added for the fuzzy conditions of the target field; The target business data is obtained by querying based on the target field using the added search. Add an index to the sorting field; Deep pagination is performed on the target business data based on the sorting field with added index.

9. A real estate transaction processing device, characterized in that, The device includes: The receiving module is used to receive real estate business processing requests sent by various real estate systems through a unified interface, including: receiving a batch of real estate business processing requests sent by various real estate systems through a unified interface, wherein the real estate business processing requests carry housing information; The query module is used to query whether the house information is locked and whether the house information corresponds to any unprocessed business requests through a unified processing logic. The unified processing logic is obtained by extracting the commonalities and key points of different real estate systems and processing them together. The marking module is used to mark the real estate business processing request as an unprocessed business request when the house information is locked or the house information corresponds to an unprocessed business request, and to set the processing order of the unprocessed business requests according to the order of the real estate business processing requests. The first business processing module is used to periodically acquire business requests marked as unsuccessful, and continue to execute the steps of querying whether the house information is locked and whether the house information corresponds to unsuccessful business requests based on the processing order of the unsuccessful business requests. If there is a prior unsuccessful business request, it waits for the next start of the timed task; otherwise, it directly responds to the acquired business requests marked as unsuccessful until the unsuccessful business requests are successfully processed. The second business processing module is used to lock the house information and perform business processing when the house information is not locked and there are no unprocessed business requests for the house information. The module then submits the business processing results corresponding to the batch of real estate business processing requests in batches, including submitting the processed house information all at once.

10. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 8.

11. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 8.

12. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 8.

Images