Code assigning system and code assigning method based on unified house building coding standard

Abstract

The invention discloses a code assigning system and a code assigning method based on a unified house building coding standard, and the method comprises the steps: S1, a calling party sends a code assigning request to the system, and calls a standardized code assigning engine module; s2, strictly verifying fields required to be filled of the incoming data by the system to ensure that the fields are complete and meet format requirements, and regenerating a shared code during calling each time; s3, querying whether the unique Hash value of the graphic information exists or not; s4, after the effective code value is obtained, a related data interface is called for processing according to the service logic, and if the processing is successful, success information is returned; and if the processing fails, recording an error and returning detailed failure information. According to the scheme, the problem of data management caused by inconsistent house building data codes is solved.

Description

Technical Field

[0001] The present invention relates to the technical field of building coding, and in particular to a coding system and a coding method based on a unified house building coding standard. Background Art

[0002] With the advancement of informatization, the standardization of data coding has become a key element in data governance. A unified housing construction data coding standard has been issued, requiring all regions and business departments to strictly abide by it during data processing. However, in actual applications, due to the differences between historical legacy systems and local self-developed systems, the problem of inconsistent coding still exists, hindering the centralized management and sharing and exchange of data. Summary of the invention

[0003] Based on the above technical problems, the present invention proposes a coding system and a coding method based on a unified housing construction coding standard. By building a province-wide unified coding system and comprehensively implementing the coding standard, it ensures that the data coding of all business systems is unified and standardized, thereby improving the data governance level and business collaboration efficiency, and solving the complexity problems caused by inconsistent coding in large-scale data management and business integration.

[0004] In the first aspect, a coding system based on a unified housing building coding standard comprises the following modules: Standardized coding engine module: Generates a unique identification code that complies with the specification based on unified standards and predefined rules, and stores the generated identification code and related information in a unified relational database; Storage and verification module: Store and quickly verify the generated identification code through a relational database; Process control module: performs logical judgment, verification and error handling in the coding process; Log and audit module: records the entire process of coding operations and supports system traceability and data auditing.

[0005] Specifically, the identification code and related information include: a generated identification code, service attributes and area information.

[0006] Specifically, the identification code quick verification includes: generating a unique Hash value according to the graphic information, and performing quick verification and retrieval based on the ElasticSearch search server.

[0007] On the other hand, a coding method based on the unified housing construction coding standard is implemented based on the coding system based on the unified housing construction coding standard, comprising the following steps: Step S1: The caller sends a coding request to the system and calls the standardized coding engine module; Step S2: The system strictly checks the mandatory fields of the incoming data to ensure that the fields are complete and meet the format requirements, and regenerates the shared code each time it is called; Step S3: Query whether the unique Hash value of the graphic information already exists; Step S4: After obtaining the valid code value, call the relevant data interface for processing according to the business logic. If the processing is successful, return success information; if the processing fails, record the error and return detailed failure information.

[0008] Specifically, the step S3 specifically includes: If the unique hash value of the graphic information exists, the code value is confirmed based on whether the code is passed in; If the unique Hash value of the graphic information does not exist, a new identification code is generated according to the business rules and the database is queried to verify the uniqueness.

[0009] Specifically, the code confirmation code value is as follows: If a code is passed in, the code value in the relational database is checked to see if it is consistent with the passed in code value; if they are consistent, the code value in the relational database is returned; if they are inconsistent, a code conflict error is fed back; If no encoding is passed in, the existing encoding in the relational database is returned directly.

[0010] Specifically, generating a new identification code according to the business rules further includes: If the generated new identification code relational database does not exist, the identification code is stored and returned; If the generated new identification code relational database already exists, the system will automatically decrement the serial number and regenerate it; if there is still a conflict, the system will report an error and terminate the operation.

[0011] Specifically, the system automatically decrements the serial number up to 10 times.

[0012] Beneficial effects of the invention: The invention proposes a coding system and coding method based on a unified housing construction coding standard, which is used to solve the data management problem caused by inconsistent housing construction data coding. The system provides standardized identification code generation and management capabilities for all businesses that require coding through provincial unified coding services, ensuring the consistency and uniqueness of the coding. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] Figure 1 1 is a diagram of the coding system architecture based on the unified housing building coding standard in an embodiment of the present invention; Figure 2 It is a schematic diagram of a coding method based on a unified housing construction coding standard in an embodiment of the present invention. DETAILED DESCRIPTION

[0014] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, specific embodiments of the present invention are now described with reference to the accompanying drawings.

[0015] The present invention proposes a coding system and a coding method based on a unified housing construction coding standard. In a preferred embodiment, in a first aspect, a coding system based on a unified housing construction coding standard comprises the following modules: Standardized coding engine module: Generates a unique identification code that complies with the specifications based on unified standards and predefined rules, and stores the generated identification code and related information in a unified relational database.

[0016] In this embodiment, the unified standards and predefined rules include: The building code consists of 18 digits, namely: 1 to 6 digits are the county-level administrative division code, the seventh digit is the year-month classification code, the 8th to 13th digits are the license year or construction year code, and the 14th to 18th digits are the sequence code.

[0017] District and county administrative division code: The administrative division code of the building is 6 digits long. The code should comply with the provisions of the current national standard "Administrative Division Code of the People's Republic of China" GB / T 2260.

[0018] Year and month classification code: refers to the value type of the license year and month or construction year and month code, the code length is 1 digit. The code value is 1, 2, 3, 4, 5.

[0019] In this embodiment, the identification code includes a classification code: 1. When the license year and month or completion year and month code is the year and month of the construction project planning license or the rural construction planning license, the year and month classification code is 1; 2. When the license year and month or completion year and month code is the construction project construction license year and month, the year and month classification code is 2; 3. When the license year and month or construction year and month code is the completion acceptance year and month, the year and month classification code is 3; 4. When the license year or construction year code is the completion year, the year and month classification code is 4; 5. When the permission year or construction year code is the completion year, the year classification code is 5.

[0020] Also include the license year and month or construction year and month code: 1. The code for the year and month of building permit or the year and month of completion of a new house should be assigned during the stage of construction project planning permit. The code should be the year and month of the construction project planning permit or rural construction planning permit. The code is 6 digits long and in the format of "yyyymm", where "yyyy" refers to year and "mm" refers to month.

[0021] 2. For newly built buildings that are not coded during the planning permit stage, the permit year and month or completion year and month code should be assigned during the construction permit stage. The code should be the year and month of the construction project construction permit, with a length of 6 digits and the format of "yyyymm".

[0022] 3. For existing buildings, the license year and month or completion year and month code should be the year and month of the construction project planning license or rural construction planning license. The code is 6 digits long and in the format of "yyyymm".

[0023] When the year and month of the construction project planning permit or rural construction planning permit are unclear, the permit year and month or completion year and month code shall be the construction project construction permit year and month, with a code length of 6 digits and a format of "yyyymm"; when the year and month of the construction project construction permit is unclear, the permit year and month or completion year and month code shall be the completion acceptance year and month, with a code length of 6 digits and a format of "yyyymm".

[0024] When the completion acceptance month is unclear, the license year or construction year code should be the completion year, the code is 6 digits long, and the format is "yyyy00". When the completion year is unclear, the license year or construction year code should be the completion year, the code is 6 digits long, and the format is "yyy000".

[0025] Serial code: The code is 5 digits long and ranges from 00001 to 99999. It is automatically generated by a computer program. It should be ensured that the building code is not repeated. It is advisable to start coding from 00001 every year.

[0026] Storage and verification module: The generated identification code is stored and quickly verified through a relational database. In this embodiment, a relational database is a database system that uses a relational model to organize data. In a relational database, data is organized into tables, each of which consists of rows and columns, where rows represent records and columns represent fields. These tables are interconnected through specific relationships (such as primary keys and foreign keys) to form a complete data model. In addition, it also contains other important components: indexes, views, stored procedures, triggers, and relational integrity constraints.

[0027] Process control module: performs logical judgment, verification and error handling in the coding process; Log and audit module: records the entire process of coding operations and supports system traceability and data auditing.

[0028] In this embodiment, the identification code and related information include: a generated identification code, business attributes, and area information; the identification code quick verification includes: generating a unique Hash value based on graphic information, and performing quick verification and retrieval based on an ElasticSearch search server.

[0029] On the other hand, in this embodiment, a coding method based on the unified housing construction coding standard is proposed, which includes the following steps: Step S1: The caller sends a coding request to the system and calls the standardized coding engine module; Step S2: The system strictly checks the mandatory fields of the incoming data to ensure that the fields are complete and meet the format requirements, and regenerates the shared code each time it is called; Step S3: Query whether the unique Hash value of the graphic information already exists; Step S4: After obtaining the valid code value, call the relevant data interface for processing according to the business logic. If the processing is successful, return success information; if the processing fails, record the error and return detailed failure information.

[0030] In this embodiment, step S3 specifically includes: If the unique hash value of the graphic information exists, the code value is confirmed based on whether the code is passed in; If the unique Hash value of the graphic information does not exist, a new identification code is generated according to the business rules and the database is queried to verify the uniqueness.

[0031] Whether to pass in the encoding confirmation code value is as follows: If a code is passed in, the code value in the relational database is checked to see if it is consistent with the passed in code value; if they are consistent, the code value in the relational database is returned; if they are inconsistent, a code conflict error is fed back; If no encoding is passed in, the existing encoding in the relational database is returned directly.

[0032] Generating new identification codes based on business rules also includes: If the generated new identification code relational database does not exist, the identification code is stored and returned; If the generated new identification code relational database already exists, the system automatically decrements the sequence number and regenerates it; if there is still a conflict, the system reports an error and terminates the operation. In this embodiment, the system automatically decrements the sequence number up to 10 times.

[0033] In another embodiment, the coding system based on the unified housing construction coding standard provides standardized identification code generation and management capabilities for all businesses that require coding through provincial unified coding services, ensuring the consistency and uniqueness of the coding. Figure 1 As shown in the figure, it is implemented based on the data layer, service layer, implementation layer and call layer. The data layer sets a relational database to support data storage, the call layer provides a call interface, and the service layer provides the servers required by the system, such as ElasticSearch search server, Redis open source memory database, etc. The core modules of the system are set in the implementation layer, including: Standardized Coding Engine Module: Generates a unique identification code that complies with the specification based on unified standards and predefined rules. All business systems that require coding must call this service to ensure the standardization and uniqueness of the coding. The system generates a unique identification code based on different business combinations (such as region, business type), and stores the generated identification code and related information in a unified relational database.

[0034] Storage and verification module: The identification code is stored and quickly verified through a relational database to ensure the uniqueness and consistency of the code. Hash value of the image patch: The unique Hash value generated based on the image information is used for quick verification and retrieval.

[0035] Identification code and its associated information: Stores the generated identification code, business attributes, regional information, etc. to ensure data integrity and traceability.

[0036] These records are stored in ElasticSearch, using the inverted index and distributed query functions of ES to improve data query efficiency and retrieval speed.

[0037] Process control module: performs logical judgment, verification and error handling in the coding process to ensure the stability of the system in various scenarios.

[0038] Log and audit module: records the entire process of coding operations and supports system traceability and data auditing.

[0039] In this embodiment, a coding process is provided, such as Figure 2 As shown, including: 1. Field verification and preprocessing: The system first strictly verifies the mandatory fields of the incoming data to ensure that the fields are complete and meet the format requirements. The shared code is regenerated each time it is called, and no repetitive judgment is performed.

[0040] 2. Graphic information check: The system uses ElasticSearch to check whether the image spot hash value passed in already exists. In this embodiment, if the graphic information (hash value) exists, then: If a code is passed in, check whether the code value in the database is consistent with the passed in code value; if they are consistent, return the code value in the database; if they are inconsistent, return a coding conflict error.

[0041] If no encoding is passed in, the existing encoding in the database is simply returned.

[0042] If the graphics information does not exist, then: The system generates a new identification code according to the business rules and queries the database to verify its uniqueness. If the generated code does not exist, it is stored and returned. If the generated code already exists, the system automatically decrements the serial number and regenerates it, up to a maximum of 10 times. If there is still a conflict, the system reports an error and terminates the operation.

[0043] 3. Data processing and return: After obtaining the valid code value, the system calls the relevant data interface for processing according to the business logic. If the processing is successful, a success message is returned; if the processing fails, the system will record the error and return detailed failure information.

[0044] In this embodiment, the system is based on the efficient verification of ElasticSearch, and the coding system relies on the inverted index and distributed query capabilities of ElasticSearch to achieve efficient verification and management of identification codes, ensuring the uniqueness and accuracy of the coding.

[0045] Set up conflict handling for the decreasing algorithm: Use a decreasing sequence strategy to avoid coding conflicts and ensure the reliability of the system in a large-scale data environment.

[0046] Stable system architecture: Through reasonable business process design and efficient query of ElasticSearch, the system can maintain stable performance in medium and high concurrency situations, reducing coding conflicts and response delays.

[0047] The system is designed strictly according to the unified coding standards, achieving province-wide data coding standardization and greatly reducing system integration problems caused by inconsistent coding.

[0048] In this embodiment, the system uses the fast search function of ElasticSearch to support real-time verification and retrieval of identification codes, greatly improving the overall efficiency of coding operations and reducing query response time.

[0049] Through predefined verification rules and decreasing sequence algorithm, the system can effectively handle coding conflicts and provide clear error feedback in abnormal situations, thus enhancing the stability and reliability of the system.

[0050] The entire process of each coding operation is recorded in detail to facilitate data traceability and system auditing. This transparency supports the subsequent troubleshooting and improvement of problems.

[0051] Based on unified standards and combined with the fast retrieval and verification capabilities of ElasticSearch, this invention provides an efficient and reliable province-wide unified coding system, which successfully solves the problem of inconsistent data coding between cross-regional and cross-business systems. The system has a reasonable design and stable performance, and has broad application value and promotion prospects.

[0052] The present invention has shown and described the basic principles and main features of the present invention and the advantages of the present invention. Those skilled in the art should understand that the present invention is not limited to the above embodiments. The above embodiments and descriptions are only for explaining the principles of the present invention. Without departing from the spirit and scope of the present invention, the present invention may have various changes and improvements, which fall within the scope of the present invention. The scope of protection of the present invention is defined by the attached claims and their equivalents.

Claims

1. A coding system based on a unified housing construction coding standard, characterized in that: Includes the following modules: Standardized coding engine module: Generates a unique identification code that complies with the specification based on unified standards and predefined rules, and stores the generated identification code and related information in a unified relational database; Storage and verification module: Store and quickly verify the generated identification code through a relational database; Process control module: performs logical judgment, verification and error handling in the coding process; Log and audit module: records the entire process of coding operations and supports system traceability and data auditing.

2. A coding system based on the unified housing construction coding standard according to claim 1, characterized in that: The identification code and related information include: a generated identification code, service attributes and area information.

3. A coding system based on a unified housing construction coding standard according to claim 1, characterized in that: The identification code rapid verification includes: generating a unique Hash value according to the graphic information, and performing rapid verification and retrieval based on the ElasticSearch search server.

4. A coding method based on the unified housing construction coding standard, implemented based on the coding system based on the unified housing construction coding standard according to any one of claims 1 to 3, characterized in that: The following steps are involved: Step S1: The caller sends a coding request to the system and calls the standardized coding engine module; Step S2: The system strictly checks the mandatory fields of the incoming data to ensure that the fields are complete and meet the format requirements, and regenerates the shared code each time it is called; Step S3: Query whether the unique Hash value of the graphic information already exists; Step S4: After obtaining the valid code value, call the relevant data interface for processing according to the business logic. If the processing is successful, return success information; If the processing fails, the error is logged and detailed failure information is returned.

5. A coding method based on the unified housing construction coding standard according to claim 4, characterized in that: The step S3 specifically includes: If the unique hash value of the graphic information exists, the code value is confirmed based on whether the code is passed in; If the unique Hash value of the graphic information does not exist, a new identification code is generated according to the business rules and the database is queried to verify the uniqueness.

6. A coding method based on the unified housing construction coding standard according to claim 5, characterized in that: The specific value of the encoding confirmation code is as follows: If a code is passed in, the code value in the relational database is checked to see if it is consistent with the passed in code value; if they are consistent, the code value in the relational database is returned; if they are inconsistent, a code conflict error is fed back; If no encoding is passed in, the existing encoding in the relational database is returned directly.

7. A coding method based on the unified housing construction coding standard according to claim 5, characterized in that: The generating of a new identification code according to the business rules also includes: If the generated new identification code relational database does not exist, the identification code is stored and returned; If the generated new identification code relational database already exists, the system will automatically decrement the serial number and regenerate it; if there is still a conflict, the system will report an error and terminate the operation.

8. A coding method based on the unified housing construction coding standard according to claim 7, characterized in that: The system automatically decrements the serial number up to 10 times.

Images