Construction drawing design and drawing examination interaction method and device, equipment and storage medium

Abstract

The invention discloses a construction drawing design and drawing examination interaction method, device and equipment and a storage medium, and relates to the technical field of drawing examination interaction.The method comprises the steps that a shared database is established and used for storing construction drawing data submitted by a design end user and feedback information of a drawing examination end user; safety verification and primary processing are carried out on construction drawing data input by the design end user, and the processed construction drawing data are stored in the shared database; verifying the identity of a drawing auditing end user, and extracting corresponding construction drawing data from the shared database based on the identity of the drawing auditing end user for auditing to obtain feedback information; and associating the feedback information with the corresponding construction drawing data and storing the feedback information and the corresponding construction drawing data in the shared database. According to the method, the shared database is established, information transmission delay is reduced, the drawing checking period is shortened, all operations of a user can be achieved, historical operations and change conditions can be conveniently traced, and integrity and accuracy of data are ensured through safety verification and primary processing.

Description

Technical Field

[0001] The present application relates to the field of interactive drawing review technology, and more specifically, to a construction drawing design and review interactive method, device, equipment and storage medium. Background Art

[0002] In the construction industry, the design and review of construction drawings are two crucial steps. The design phase is typically completed by designers, who produce detailed construction drawings based on client requirements and building codes. Reviewers, on the other hand, are responsible for carefully scrutinizing construction drawings to ensure they comply with building codes, are safe, reliable, and economically sound.

[0003] In existing technologies, the data exchange between construction drawing designers and reviewers primarily relies on traditional communication methods, such as email, phone calls, and paper drawing delivery. After completing the construction drawings, designers send them to reviewers via email or paper. Reviewers manually flip through and examine the drawings, recording their comments. Reviewers then provide feedback to designers via email or phone. Designers then modify the drawings based on the reviewers' comments and send the revised drawings back to the reviewers.

[0004] However, in the existing technology, due to the reliance on traditional communication methods such as email and telephone, there is often a delay in the transmission of information between design and review, which leads to an extension of the review cycle. Drawings delivered by email are easily intercepted or tampered with, and there is a risk of data leakage. The transmission of paper drawings is likely to be lost or maliciously modified. Drawings and opinions need to be repeatedly transmitted many times, which increases the workload of designers and reviewers and reduces work efficiency. At the same time, there is a lack of operation records and data change records, making it difficult to trace historical operations and changes in the construction drawing design and review process, which is not conducive to subsequent quality control and improvement. Summary of the Invention

[0005] In response to at least one defect or improvement need in the prior art, the present invention provides a method, device, equipment and storage medium for interactive construction drawing design and review, which is used to solve the problems in the prior art that information transmission between design and review is often delayed, resulting in an extension of the review cycle, drawings delivered by email are easily intercepted or tampered with, there is a risk of data leakage, loss or malicious modification, and drawings and opinions need to be repeatedly transmitted multiple times, which reduces work efficiency. At the same time, there is a lack of operation records and data change records, making it difficult to trace historical operations and changes in the construction drawing design and review process.

[0006] To achieve the above objectives, according to a first aspect of the present invention, a construction drawing design and review interactive method is provided, comprising:

[0007] Establish a shared database to store construction drawing data submitted by design users and feedback information from review users;

[0008] Conduct security verification and preliminary processing of the construction drawing data entered by the design end user, and store the processed construction drawing data in a shared database;

[0009] Authenticate the user of the drawing review end, extract the corresponding construction drawing data from the shared database based on the identity of the user of the drawing review end, and review and obtain feedback information;

[0010] The feedback information is associated with the corresponding construction drawing data and stored in a shared database.

[0011] In one possible implementation, the construction drawing data entered by the design end user is securely verified and preliminarily processed, and the processed construction drawing data is stored in a shared database, which also includes:

[0012] Analyze the construction drawing data and standardize the data format to obtain the construction drawing data in a preset format;

[0013] Pre-process the construction drawing data in a preset format and verify the integrity of the pre-processed construction drawing data;

[0014] Store verified construction drawing data in a shared database.

[0015] In a possible implementation, parsing the construction drawing data and standardizing the data format to obtain the construction drawing data in a preset format further includes:

[0016] Identify the construction drawing data and determine the file type corresponding to the construction drawing data;

[0017] Parse construction drawing data according to file type and extract key information from the construction drawing data;

[0018] Perform structural analysis on the extracted key information to obtain data structure information;

[0019] The format of key information is unified based on data structure information and preset format standards to obtain construction drawing data in the preset format.

[0020] In one possible implementation, preprocessing the construction drawing data in a preset format and verifying the integrity of the preprocessed construction drawing data further includes:

[0021] Perform coordinate conversion, unit unification and layer merging on construction drawing data in preset formats;

[0022] Verify the integrity of the pre-processed construction drawing data using preset integrity verification rules, and obtain the verified construction drawing data;

[0023] The construction drawing data that fails the verification shall be corrected and re-preprocessed and verified for integrity.

[0024] In a possible implementation, the user of the drawing review terminal is authenticated, and based on the identity of the user of the drawing review terminal, corresponding construction drawing data is extracted from the shared database for review to obtain feedback information, which also includes:

[0025] Verify the identity of the user on the drawing review side and determine the corresponding access rights based on the identity of the user on the drawing review side;

[0026] Extract the corresponding construction drawing data from the shared database based on the access rights of the user at the drawing review end;

[0027] Receive feedback information uploaded by the review user after reviewing the construction drawing data.

[0028] In a possible implementation, extracting corresponding construction drawing data from a shared database based on the access rights of the drawing review end user further includes:

[0029] Based on the access rights of the review end user, the corresponding construction drawing data is retrieved from the shared database and marked;

[0030] A data extraction query statement is constructed based on the construction drawing data tag requested for access, and the corresponding data is extracted from the shared database.

[0031] In one possible implementation, a shared database is established to store construction drawing data submitted by design-side users and feedback information from review-side users, and also includes:

[0032] Configure the server for the shared database and set user permissions for the shared database;

[0033] The data table structure in the database is set based on the construction drawing design business and construction drawing review business.

[0034] According to a second aspect of the present invention, there is also provided a construction drawing design and review interactive device, comprising:

[0035] An establishment module configured to establish a shared database for storing construction drawing data submitted by design-end users and feedback information from review-end users;

[0036] A data entry module is configured to perform security verification and preliminary processing on the construction drawing data entered by the design end user, and store the processed construction drawing data in a shared database;

[0037] A drawing review module is configured to authenticate the user of the drawing review terminal and extract the corresponding construction drawing data from the shared database based on the identity of the user of the drawing review terminal for review and obtain feedback information;

[0038] The associated storage module is configured to associate the feedback information with the corresponding construction drawing data and store them in a shared database.

[0039] According to a third aspect of the present invention, there is also provided a construction drawing design and review interaction device, which includes at least one processing unit and at least one storage unit, wherein the storage unit stores a computer program, and when the computer program is executed by the processing unit, the processing unit performs the steps of any one of the above-mentioned construction drawing design and review interaction methods.

[0040] According to a fourth aspect of the present invention, a storage medium is further provided, which stores a computer program executable by a construction drawing design and drawing review interaction device. When the computer program is run on the construction drawing design and drawing review interaction device, the construction drawing design and drawing review interaction device executes the steps of any one of the above-mentioned construction drawing design and drawing review interaction methods.

[0041] In general, the above technical solutions conceived by the present invention can achieve the following beneficial effects compared with the prior art:

[0042] The present invention provides a construction drawing design and review interaction method. By establishing a shared database, design-end users and review-end users can directly access and update data in the database, thereby shortening the review cycle and avoiding delays in traditional email delivery methods. The shared database provides higher data security and reduces the risk of data leakage, loss or malicious modification. The construction drawing data entered by the design-end user is securely verified and preliminarily processed to ensure the integrity and accuracy of the data and prevent data leakage and tampering. The review-end user can directly extract the construction drawing data from the shared database for review without waiting for email delivery or repeated requests. At the same time, the shared database can record all operations of the design-end user and the review-end user, including data submission, review, modification, etc. By associating feedback information with construction drawing data, the historical operations and changes in the construction drawing design and review process can be clearly traced, which helps to resolve disputes, analyze the causes of problems, and provide strong support for subsequent design and improvement. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the following briefly introduces the drawings required for use in the embodiments. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0044] Figure 1 A schematic diagram of a flow chart of an embodiment of the construction drawing design and drawing review interactive method provided by the present invention;

[0045] Figure 2 The present invention provides Figure 1 A flow chart of an embodiment of step S102;

[0046] Figure 3 The present invention provides Figure 2 A flow chart of an embodiment of step S201;

[0047] Figure 4 The present invention provides Figure 2 A flow chart of an embodiment of step S202;

[0048] Figure 5 The present invention provides Figure 1 A flow chart of an embodiment of step S103;

[0049] Figure 6 A schematic structural diagram of an embodiment of the construction drawing design and review interactive device provided by the present invention;

[0050] Figure 7 A schematic diagram of the structure of the construction drawing design and review interactive device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0051] In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely for the purpose of explaining the present invention and are not intended to limit the present invention. In addition, the technical features involved in the various embodiments of the present invention described below may be combined with each other as long as they do not conflict with each other.

[0052] The terms "first," "second," "third," and the like in the specification and claims of this application and the accompanying drawings are used to distinguish between different objects, not to describe a particular order. Furthermore, the terms "including," "having," and any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, product, or apparatus comprising a series of steps or elements is not limited to the listed steps or elements, but may optionally include steps or elements not listed, or may optionally include other steps or elements inherent to the process, method, product, or apparatus.

[0053] The present invention provides a construction drawing design and review interaction method, device, equipment and storage medium, which are described below respectively.

[0054] See also Figure 1 , Figure 1 This is a flow chart of an embodiment of the construction drawing design and review interaction method provided by the present invention. In a specific embodiment of the present invention, a construction drawing design and review interaction method is disclosed, including:

[0055] S101. Establish a shared database for storing construction drawing data submitted by design-end users and feedback information from review-end users;

[0056] S102: Perform security verification and preliminary processing on the construction drawing data entered by the design end user, and store the processed construction drawing data in a shared database;

[0057] S103: Authenticate the user of the drawing review terminal, extract the corresponding construction drawing data from the shared database based on the identity of the user of the drawing review terminal, review and obtain feedback information;

[0058] S104: Associating the feedback information with the corresponding construction drawing data and storing them in a shared database.

[0059] In the above embodiment, first, according to the actual needs of construction drawing design and review, the database structure is planned, including data tables, fields and their relationships, to ensure that the database can efficiently store and query construction drawing data and review feedback information. Select a suitable database management (such as MySQL, PostgreSQL, etc.), install and configure it, and set the database security policy, such as user authority management, data encryption, etc., to ensure data security. After the database is built, the data is initialized, including creating the necessary table structure and index. At the same time, the existing construction drawing data and review feedback information are imported into the database for subsequent use and query.

[0060] Design users enter construction drawing data through a specific interface or screen. During the data entry process, security verification is performed, such as checking data integrity and formatting, to ensure that the entered data complies with pre-set specifications and standards. Preliminary processing of the entered data, such as data cleaning and format conversion, improves data quality and usability, facilitating subsequent analysis and review. Verified and processed construction drawing data is stored in a shared database, which is regularly backed up to prevent data loss or corruption.

[0061] Before accessing the shared database, reviewers are required to undergo identity verification. This verification process uses usernames, passwords, and verification codes to ensure that only authorized users can access the database. Once verified, reviewers can retrieve the corresponding construction drawing data from the shared database for review based on their permissions and roles. During the review process, users can annotate the drawings, suggest modifications, and provide feedback. Upon completion of the review, feedback is generated containing review comments and modification suggestions. This information is used to guide design users in revising and improving the construction drawings.

[0062] The generated feedback information is associated with the corresponding construction drawing data to ensure an accurate correspondence between the two. This allows designers to easily access relevant review feedback when viewing construction drawings. The associated feedback information and construction drawing data are stored in a shared database, and the relevant database records are updated. Subsequent users can access the latest construction drawings and review feedback information when accessing the database. Maintaining a historical record of construction drawings and review feedback information allows for tracing and querying when needed, helping to analyze issues during the design and review process, summarize lessons learned, and improve the efficiency and quality of subsequent work.

[0063] Compared with the prior art, the present embodiment provides a construction drawing design and review interaction method. By establishing a shared database, design-end users and review-end users can directly access and update data in the database, thereby shortening the review cycle and avoiding the delay in traditional email delivery methods. The shared database provides higher data security and reduces the risk of data leakage, loss or malicious modification. The construction drawing data entered by the design-end user is securely verified and preliminarily processed to ensure the integrity and accuracy of the data and prevent data leakage and tampering. The review-end user can directly extract the construction drawing data from the shared database for review without waiting for email delivery or repeated requests. At the same time, the shared database can record all operations of the design-end user and the review-end user, including data submission, review, modification, etc. By associating feedback information with construction drawing data, the historical operations and changes in the construction drawing design and review process can be clearly traced, which helps to resolve disputes, analyze the causes of problems, and provide strong support for subsequent design and improvement.

[0064] See also Figure 2 , Figure 2 The present invention provides Figure 1 FIG. 1 is a flow chart of an embodiment of step S102 in FIG. 1 . In some embodiments of the present invention, security verification and preliminary processing of construction drawing data entered by a design end user are performed, and the processed construction drawing data is stored in a shared database, further comprising:

[0065] S201, parsing the construction drawing data and standardizing the data format to obtain the construction drawing data in a preset format;

[0066] S202: Preprocessing the construction drawing data in a preset format and verifying the integrity of the preprocessed construction drawing data;

[0067] S203. Store the verified construction drawing data in a shared database.

[0068] In the above embodiment, since the construction drawing data may come from different design software or platforms, their data formats and structures may be different. Therefore, it is necessary to have a strong parsing capability that can identify and extract key information in the drawings, such as lines, graphics, text annotations, etc. After parsing the drawing data, the data format is standardized, and the drawing data of different formats and structures are converted into a unified, preset format for subsequent processing and storage. The standardization process includes the conversion of data types, the unification of coordinate systems, the specification of layers and line types, etc. After parsing and standardization, construction drawing data that conforms to the preset format is obtained, which has good structure and readability, laying the foundation for subsequent processing and storage.

[0069] The purpose of preprocessing is to further improve data quality and usability, including removing redundant information, correcting erroneous data, and supplementing missing data. For example, it may be possible to automatically detect and correct issues such as broken lines and overlapping shapes in drawings. After preprocessing is complete, the construction drawing data is verified for integrity to ensure that it has not been lost or damaged during transmission and processing.

[0070] Verification includes checking the completeness of key drawing information, the availability of layers and line types, and the accuracy of dimensioning. If incomplete data or errors are found during verification, prompt feedback will be provided to the design user, along with correction suggestions. The design user can then make corrections based on this feedback and re-upload the drawing data.

[0071] During storage, encryption technology can be used to protect data security, and appropriate access permissions can be set to ensure that only authorized users can access and modify data. To prevent data loss or corruption, shared databases are regularly backed up. Data recovery capabilities are also available, allowing for rapid restoration of data to a previous state when needed.

[0072] See also Figure 3 , Figure 3 The present invention provides Figure 2 FIG. 1 is a flow chart of an embodiment of step S201 in FIG. 1 . In some embodiments of the present invention, parsing the construction drawing data and standardizing the data format to obtain the construction drawing data in a preset format further includes:

[0073] S301, identifying the construction drawing data and determining the file type corresponding to the construction drawing data;

[0074] S302, parsing the construction drawing data according to the file type, and extracting key information from the construction drawing data;

[0075] S303, performing structural analysis on the extracted key information to obtain data structure information;

[0076] S304: Unify the format of key information based on the data structure information and the preset format standard to obtain construction drawing data in the preset format.

[0077] In the above embodiment, the system identifies the file type of the construction drawing data by file extension, file header information or specific file signature. Common construction drawing file formats include DWG (AutoCAD drawing), DXF (drawing interchange format), PDF (portable document format), JPG / PNG (image format), etc. The first few bytes of the construction drawing file (usually called the file header) are read, which contains the characteristic information of the file, and the read file header information is matched with the file header characteristics of the known construction drawing file type. For example, DWG files usually start with a specific byte sequence. These byte sequences are unique tags used by AutoCAD software to identify DWG files and determine the file type corresponding to the construction drawing data.

[0078] Based on the identified file type, an appropriate parsing method is selected to process the construction drawing data. For example, for DWG files, a specialized CAD parsing library may be used to read and parse the drawing data. During the parsing process, key information from the construction drawing data is extracted, such as lines, graphics, text annotations, dimensions, and layer information. After extracting key information, an information integrity check is performed to ensure that all necessary information has been successfully extracted and that no information has been omitted or corrupted.

[0079] Structural analysis is performed on the extracted key information to understand its organizational relationships and hierarchical structure. For example, analysis can be performed on the connections between lines and shapes, or on the associations between text annotations and shapes. Structural analysis can reveal data structure information, such as the data's hierarchy, associations, and attribute information. Once this data structure is obtained, optimization can be performed to improve data processing and storage efficiency. For example, duplicate data items may be merged or redundant data structures may be removed.

[0080] Pre-set format standards are established to regulate the format and structure of construction drawing data. These standards may include requirements for data type, length, accuracy, and encoding. Based on this data structure and pre-set format standards, the extracted key information is formatted uniformly. For example, data in different formats can be converted to a unified format, and data with different encodings can be converted to a unified encoding. After this formatting process, construction drawing data conforming to the pre-set format is generated, ensuring good structure and readability. Furthermore, quality checks are performed on the generated data to ensure compliance with the pre-set format and standards.

[0081] See also Figure 4 , Figure 4 The present invention provides Figure 2 FIG. 1 is a flow chart of an embodiment of step S202 in FIG. 1 . In some embodiments of the present invention, preprocessing the construction drawing data in a preset format and verifying the integrity of the preprocessed construction drawing data further includes:

[0082] S401, performing coordinate conversion, unit unification, and layer merging processing on the construction drawing data in a preset format;

[0083] S402: Verify the integrity of the pre-processed construction drawing data using a preset integrity verification rule, and obtain construction drawing data that passes the verification;

[0084] S403. Correct the construction drawing data that fails the verification, and re-perform pre-processing and integrity verification.

[0085] In the above embodiment, since the construction drawings may come from different design software or platforms, their coordinates may be different. In order to ensure the consistency and comparability of the data, the construction drawing data in a preset format is converted into coordinates and unified into preset coordinates, which helps in subsequent analysis and processing. The dimensioning, length, area and other data in the construction drawings may use different units. In order to eliminate the inconvenience and errors caused by unit differences, these data are unified and converted into preset unit standards. For example, all length units are unified into meters or millimeters. During the design process, the construction drawings may contain multiple layers to distinguish different graphic elements or design contents. However, in subsequent processing and analysis, too many layers may increase the complexity and difficulty of processing. Therefore, the layers are merged, and layers with similar properties or functions are merged into one layer to simplify the data structure and improve processing efficiency.

[0086] Pre-set integrity verification rules may include, but are not limited to, checking the presence of key information, the correctness of data formats, and the completeness of layers and line types. Pre-processed construction drawing data is verified according to these rules. During the verification process, each data item is checked for compliance with the rules, and the verification results are recorded. After verification, the verified construction drawing data is obtained, confirming that it meets the pre-set integrity and accuracy requirements and can be used for subsequent analysis and processing.

[0087] Based on identified issues, the design user may automatically revise construction drawing data that fails verification. This revision process may include supplementing missing information, correcting erroneous data, and adjusting layer structures. After revisions are completed, the construction drawing data is reprocessed and re-verified for integrity to ensure that the revised data conforms to pre-set formatting and standards and is complete and accurate. If the data still fails re-verification, the user will be prompted to make revisions until it passes verification.

[0088] See also Figure 5 , Figure 5 The present invention provides Figure 1The flowchart of an embodiment of step S103 in FIG. 1 is a flow chart of an embodiment of the present invention. In some embodiments of the present invention, identity verification is performed on the review end user, and based on the identity of the review end user, corresponding construction drawing data is extracted from the shared database for review to obtain feedback information, which also includes:

[0089] S501: Verify the identity of the user at the drawing review end and determine the corresponding access rights according to the identity of the user at the drawing review end;

[0090] S502, extracting corresponding construction drawing data from a shared database based on the access rights of the drawing review end user;

[0091] S503: Receive feedback information uploaded by the drawing review end user after reviewing the construction drawing data.

[0092] In the above embodiment, a multi-factor authentication mechanism is used to verify the identity of the review end user, including but not limited to username / password verification, digital certificate verification, dynamic password verification, or biometric identification (such as fingerprint and facial recognition). This multi-level verification method ensures the authenticity and security of the user's identity. A user identity information database is maintained, which contains the registration information, permission level, role assignment, etc. of the review end user. When verifying the user's identity, this information database is queried to obtain the user's detailed identity information and permission settings. Based on the identity and role of the review end user, their access rights are dynamically determined, including but not limited to viewing construction drawings of a specific project, editing review comments, downloading related files, etc. The allocation of permissions follows the principle of least privilege, that is, users are granted only the minimum set of permissions required to complete their work.

[0093] Before extracting construction drawing data, the reviewer's access rights are rechecked to ensure they have access to the requested data, preventing data leaks and unauthorized access. Based on the user's access rights and request parameters, the corresponding construction drawing data is extracted from the shared database. This extraction process may involve operations such as data decryption and format conversion to ensure data security and availability during transmission and use. To improve data access efficiency, data caching technology is employed to cache frequently accessed construction drawing data in a local or distributed cache. Furthermore, the data extraction process is optimized to reduce unnecessary database queries and data transfers.

[0094] An intuitive review interface is provided for review users, on which users can view construction drawing data, make annotations, fill in review opinions, and perform other operations. The review interface supports multiple interaction methods, such as mouse dragging and keyboard shortcuts, to improve user work efficiency. Feedback information may include review opinions, modification suggestions, problem annotations, etc., which are of great significance for design users to modify and improve construction drawings. After receiving the feedback information, it is processed, such as format conversion and content parsing, and the processed information is stored in a shared database. At the same time, an association relationship is established between the feedback information and the design user and the construction drawing data for subsequent query and tracing. After receiving the feedback information, a notification or reminder is automatically sent to the design user to inform him that the construction drawing data has been reviewed and feedback has been provided, which helps to speed up the response speed of the design user and improve the efficiency of the entire review process.

[0095] In some embodiments of the present invention, extracting corresponding construction drawing data from a shared database based on the access rights of the drawing review end user further includes:

[0096] Based on the access rights of the review end user, the corresponding construction drawing data is retrieved from the shared database and marked;

[0097] A data extraction query statement is constructed based on the construction drawing data tag requested for access, and the corresponding data is extracted from the shared database.

[0098] In the above embodiment, the identity and access rights of the user at the drawing review end are first verified to ensure that the user is qualified to access specific construction drawing data. The user's access rights are parsed to clarify which projects, drawings, and specific access operations (such as viewing, annotating, downloading, etc.) the user can access. Based on the user's access rights, the construction drawing data records that the user has the right to access are queried from the permission control table of the shared database. The query results are preliminarily screened to exclude data that the user does not have the right to access, ensuring that the data subsequently processed is all the data that the user has the right to view. The construction drawing data after the preliminary screening is marked, and the marking content may include but is not limited to the drawing's ID, name, version, project to which it belongs, access permission level, etc. The purpose of marking is to facilitate subsequent data extraction and processing, and to ensure that the extracted data is accurate.

[0099] Based on the previously marked construction drawing data, one or more data extraction query statements are constructed. The query statement clearly specifies the data fields, data tables, and filtering conditions to be extracted, ensuring that the extracted data meets the user's access rights and requirements. The constructed query statement is sent to the shared database for query. The database management extracts the qualified construction drawing data from the corresponding data tables according to the query statement requirements. After the database query is executed, the extracted construction drawing data is returned to the review user. The returned data may include detailed drawing information, related attachments, historical versions, etc., depending on the user's access rights and request parameters. During the data extraction and return process, necessary security measures such as data encryption and access control are implemented to ensure data security and integrity. At the same time, the extracted data is also verified for integrity to ensure that the data is not lost or damaged during transmission and processing.

[0100] In some embodiments of the present invention, a shared database is established for storing construction drawing data submitted by design-end users and feedback information from review-end users, further comprising:

[0101] Configure the server for the shared database and set user permissions for the shared database;

[0102] The data table structure in the database is set based on the construction drawing design business and construction drawing review business.

[0103] In the above embodiment, appropriate server hardware, including processors, memory, and storage devices, is selected based on the expected data storage volume and access frequency to ensure efficient database operation. A stable and secure operating system, such as Linux or Windows Server, is installed on the server to provide an operating environment for the database software. The server's network settings are configured to ensure that the database can be accessed by both design and review users via the network, and firewall rules are set to protect database security. A suitable database management system (DBMS), such as MySQL, PostgreSQL, or Oracle, is selected and installed. Basic database parameters, such as the database name, character set, and storage path, are configured. Database backup and recovery policies are set, and database backups are performed regularly to prevent data loss. Based on the needs of construction drawing design and review, different user roles are defined, such as design users, review users, and administrators. Each user role is assigned corresponding database access permissions. For example, a design user may have permissions to upload and modify construction drawings, a review user may have permissions to view and annotate construction drawings, and an administrator may have comprehensive database management permissions. A strict permission verification mechanism is implemented to ensure that users can only access authorized data and functions.

[0104] Determine the type and amount of data that needs to be stored, as well as the relationships and dependencies between the data. Design a data table for storing construction drawing data, including fields such as drawing ID, drawing name, version, submission time, submitter, drawing file path, etc. Design a data table for storing user feedback information on the review end, including fields such as feedback ID, drawing ID (associated with the construction drawing data table), feedback time, feedback person, feedback content, etc. Design a data table for storing user information, including fields such as user ID, user name, password (encrypted storage), role, contact information, etc. Based on business needs, it may be necessary to design other auxiliary data tables, such as project information tables, drawing type tables, etc. Establish appropriate relationships between data tables, such as establishing an association between the construction drawing data table and the feedback information data table through the drawing ID, and set foreign key constraints and indexes to ensure data integrity and query efficiency. Optimize the data table structure based on actual usage, such as adjusting field types, adding indexes, splitting large tables, etc., to improve database performance and maintainability.

[0105] In order to better implement the construction drawing design and review interactive method in the embodiment of the present invention, based on the construction drawing design and review interactive method, please refer to Figure 6 , Figure 6 This is a schematic structural diagram of an embodiment of a construction drawing design and review interactive device provided by the present invention. This embodiment of the present invention provides a construction drawing design and review interactive device 600, including:

[0106] Establishing module 610, which is configured to establish a shared database for storing construction drawing data submitted by design-end users and feedback information from review-end users;

[0107] The data entry module 620 is configured to perform security verification and preliminary processing on the construction drawing data entered by the design end user, and store the processed construction drawing data in the shared database;

[0108] The drawing review module 630 is configured to authenticate the user of the drawing review terminal and extract the corresponding construction drawing data from the shared database based on the identity of the user of the drawing review terminal for review and obtain feedback information;

[0109] The association storage module 640 is configured to associate the feedback information with the corresponding construction drawing data and store the data in a shared database.

[0110] It should be noted here that the device 600 provided in the above embodiment can implement the technical solutions described in the above method embodiments. The specific implementation principles of the above modules or units can be found in the corresponding contents in the above method embodiments, which will not be repeated here.

[0111] See also Figure 7 , Figure 7This is a schematic diagram of the structure of a construction drawing design and review interactive device provided by an embodiment of the present invention. Based on the above-described construction drawing design and review interactive method, the present invention also provides a construction drawing design and review interactive device. The construction drawing design and review interactive device can be a computing device such as a mobile terminal, desktop computer, notebook, PDA, or server. The construction drawing design and review interactive device 700 includes a processor 710, memory 720, and a display 730. Figure 7 Only some components of the construction drawing design and review interactive device are shown, but it should be understood that it is not required to implement all the shown components, and more or fewer components may be implemented instead.

[0112] In some embodiments, the memory 720 may be an internal storage unit of the construction drawing design and review interaction device 700, such as the hard drive or memory of the construction drawing design and review interaction device 700. In other embodiments, the memory 720 may also be an external storage device of the construction drawing design and review interaction device 700, such as a plug-in hard drive, a Smart Media Card (SMC), a Secure Digital (SD) card, a flash memory card, etc. equipped on the construction drawing design and review interaction device 700. Furthermore, the memory 720 may include both the internal storage unit of the construction drawing design and review interaction device 700 and an external storage device. The memory 720 is used to store application software installed in the construction drawing design and review interaction device 700 and various data, such as the program code for installing the construction drawing design and review interaction device 700. The memory 720 may also be used to temporarily store data that has been output or is about to be output. In one embodiment, the memory 720 stores a construction drawing design and review interaction program 740, which can be executed by the processor 710 to implement the construction drawing design and review interaction method of each embodiment of the present application.

[0113] In some embodiments, the processor 710 can be a central processing unit (CPU), a microprocessor, or other data processing chip, used to run program codes stored in the memory 720 or process data, such as executing construction drawing design and drawing review interaction methods.

[0114] In some embodiments, the display 730 can be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, or an OLED (Organic Light-Emitting Diode) touchscreen. The display 730 is used to display information on the construction drawing design and review interactive device 700 and to display a visual user interface. Components 710-730 of the construction drawing design and review interactive device 700 communicate with each other via a system bus.

[0115] In one embodiment, when the processor 710 executes the construction drawing design and review interaction program 740 in the memory 720 , the steps in the above construction drawing design and review interaction method are implemented.

[0116] This embodiment further provides a computer-readable storage medium storing a construction drawing design and drawing review interactive program. When the construction drawing design and drawing review interactive program is executed by a processor, the following steps are implemented:

[0117] Establish a shared database to store construction drawing data submitted by design users and feedback information from review users;

[0118] Conduct security verification and preliminary processing of the construction drawing data entered by the design end user, and store the processed construction drawing data in a shared database;

[0119] Authenticate the user of the drawing review end, extract the corresponding construction drawing data from the shared database based on the identity of the user of the drawing review end, and review and obtain feedback information;

[0120] The feedback information is associated with the corresponding construction drawing data and stored in a shared database.

[0121] In summary, the present invention provides a construction drawing design and review interaction method. By establishing a shared database, design-end users and review-end users can directly access and update data in the database, thereby shortening the review cycle and avoiding delays in traditional email delivery methods. The shared database provides higher data security and reduces the risk of data leakage, loss or malicious modification. The construction drawing data entered by the design-end user is securely verified and preliminarily processed to ensure the integrity and accuracy of the data and prevent data leakage and tampering. The review-end user can directly extract the construction drawing data from the shared database for review without waiting for email delivery or repeated requests. At the same time, the shared database can record all operations of the design-end user and the review-end user, including data submission, review, modification, etc. By associating feedback information and construction drawing data, the historical operations and changes in the construction drawing design and review process can be clearly traced, which helps to resolve disputes, analyze the causes of problems, and provide strong support for subsequent design and improvement.

[0122] The present 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 above method. The computer-readable storage medium may include, but is not limited to, any type of disk, including a floppy disk, an optical disk, a DVD, a CD-ROM, a microdrive, a magneto-optical disk, a ROM, a RAM, an EPROM, an EEPROM, a DRAM, a VRAM, a flash memory device, a magnetic card or an optical card, a nanosystem (including a molecular memory IC), or any type of medium or device suitable for storing instructions and / or data.

[0123] It should be noted that for the aforementioned method embodiments, for the sake of simplicity, they are all expressed as a series of action combinations, but those skilled in the art should be aware that this application is not limited by the order of the actions described, because according to this application, certain steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by this application.

[0124] In the above embodiments, the description of each embodiment has its own focus. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0125] In the several embodiments provided in this application, it should be understood that the disclosed devices can be implemented in other ways. For example, the device embodiments described above are merely schematic. For example, the division of the units is merely a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some service interface, and the indirect coupling or communication connection of the device or unit can be electrical or other forms.

[0126] The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of these units may be selected to achieve the purpose of this embodiment according to actual needs.

[0127] In addition, the functional units in the various embodiments of the present application may be integrated into a single processing unit, or each unit may exist physically separately, or two or more units may be integrated into a single unit. The aforementioned integrated units may be implemented in the form of hardware or software functional units.

[0128] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable memory. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a memory, including a number of instructions for enabling a computer device (which can be a personal computer, server or network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present application. The aforementioned memory includes: various media that can store program codes, such as a USB flash drive, a read-only memory (ROM), a random access memory (RAM), a mobile hard disk, a magnetic disk or an optical disk.

[0129] Those skilled in the art will understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable memory, which may include: a flash drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, etc.

[0130] The above is only an exemplary embodiment of the present disclosure and cannot be used to limit the scope of the present disclosure. That is, any equivalent changes and modifications made according to the teachings of the present disclosure are still within the scope of the present disclosure. After considering the specification and practicing the disclosure herein, those skilled in the art will easily think of the implementation scheme of the present disclosure. This application is intended to cover any variation, use or adaptation of the present disclosure, which follows the general principles of the present disclosure and includes common knowledge or customary technical means in the art that are not recorded in the present disclosure. The description and examples are to be regarded as exemplary only, and the scope and spirit of the present disclosure are defined by the claims.

[0131] The technical features of the above embodiments can be combined arbitrarily. To make the description concise, 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.

[0132] It will be easily understood by those skilled in the art that the above description is merely a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A construction drawing design and review interactive method, characterized in that: include: Establish a shared database to store construction drawing data submitted by design users and feedback information from review users; Performing security verification and preliminary processing on the construction drawing data entered by the design end user, and storing the processed construction drawing data in the shared database; Authentication is performed on the user of the drawing review end, and based on the identity of the user of the drawing review end, corresponding construction drawing data is extracted from the shared database for review to obtain feedback information; The feedback information is associated with the corresponding construction drawing data and stored in the shared database.

2. The construction drawing design and review interactive method according to claim 1, characterized in that: The security verification and preliminary processing of the construction drawing data input by the design end user, and storing the processed construction drawing data in the shared database, further includes: Parsing the construction drawing data and standardizing the data format to obtain construction drawing data in a preset format; Pre-process the construction drawing data in a preset format and verify the integrity of the pre-processed construction drawing data; The verified construction drawing data is stored in the shared database.

3. The construction drawing design and review interactive method according to claim 2, characterized in that: The parsing of the construction drawing data and data format standardization to obtain construction drawing data in a preset format further includes: Identifying the construction drawing data and determining the file type corresponding to the construction drawing data; Parsing the construction drawing data according to the file type, and extracting key information from the construction drawing data; Performing structural analysis on the extracted key information to obtain data structure information; The format of the key information is unified based on the data structure information and the preset format standard to obtain construction drawing data in the preset format.

4. The construction drawing design and review interactive method according to claim 2, characterized in that: The pre-processing of the construction drawing data in a preset format and verifying the integrity of the pre-processed construction drawing data further includes: Perform coordinate conversion, unit unification and layer merging on construction drawing data in preset formats; Verify the integrity of the pre-processed construction drawing data using preset integrity verification rules, and obtain the verified construction drawing data; The construction drawing data that fails the verification shall be corrected and re-preprocessed and verified for integrity.

5. The construction drawing design and review interactive method according to claim 1, characterized in that: The authentication of the drawing review end user is performed, and based on the identity of the drawing review end user, corresponding construction drawing data is extracted from the shared database for review to obtain feedback information, further comprising: Verify the identity of the user at the drawing review end, and determine corresponding access rights based on the identity of the user at the drawing review end; Extracting corresponding construction drawing data from the shared database based on the access rights of the drawing review end user; Receive feedback information uploaded by the drawing review end user after reviewing the construction drawing data.

6. The construction drawing design and review interactive method according to claim 5, characterized in that: The step of extracting corresponding construction drawing data from the shared database based on the access rights of the drawing review end user further includes: Based on the access rights of the drawing review end user, corresponding construction drawing data is retrieved from the shared database and marked; A data extraction query statement is constructed based on the construction drawing data tag requested for access, and the corresponding data is extracted from the shared database.

7. The construction drawing design and review interactive method according to claim 1, characterized in that: The establishment of a shared database for storing construction drawing data submitted by design-end users and feedback information from review-end users also includes: Configuring a shared database server and setting user permissions for the shared database; The data table structure in the database is set based on the construction drawing design business and construction drawing review business.

8. A construction drawing design and review interactive device, characterized in that: include: An establishment module configured to establish a shared database for storing construction drawing data submitted by design-end users and feedback information from review-end users; A data entry module is configured to perform security verification and preliminary processing on the construction drawing data entered by the design end user, and store the processed construction drawing data in the shared database; A drawing review module is configured to authenticate the identity of the review user and extract corresponding construction drawing data from the shared database based on the identity of the review user to review and obtain feedback information; The associated storage module is configured to associate the feedback information with the corresponding construction drawing data and store the data in the shared database.

9. A construction drawing design and review interactive device, characterized in that: The method comprises at least one processing unit and at least one storage unit, wherein the storage unit stores a computer program, and when the computer program is executed by the processing unit, the processing unit executes the steps of the construction drawing design and review interaction method according to any one of claims 1 to 7.

10. A storage medium, characterized in that: It stores a computer program that can be executed by a construction drawing design and review interaction device. When the computer program runs on the construction drawing design and review interaction device, the construction drawing design and review interaction device executes the steps of the construction drawing design and review interaction method described in any one of claims 1 to 7.

Images