Data integration method, device, computer equipment and storage medium

Abstract

This application provides a data integration method, apparatus, computer equipment, and storage medium, belonging to the field of data governance technology. The method includes: acquiring first ranking information of a target project and a database of the target project at multiple stages, each stage's database including entity data of multiple entities of the target project at that stage; for each entity, determining first attribute information of the entity at each stage based on the first ranking information and the entity data at each stage; screening the first attribute information of the entity at each stage to determine second attribute information that meets preset conditions; acquiring integration processing information of the entity at multiple stages; and integrating the second attribute information of the multiple stages based on the integration processing information to obtain integrated data of the entity. This method achieves data integration of entity data from the second attribute information of multiple stages, thereby improving the application efficiency when applying entity data.

Description

Technical Field

[0001] This application relates to the field of data governance technology, and in particular to a data integration method, apparatus, computer equipment, and storage medium. Background Technology

[0002] In the process of enterprise digital transformation, entity data, such as equipment and facility entities, serves as the foundational data for any construction project within the enterprise, running sequentially through the construction and operation phases. Each entity's entity data includes multiple attributes representing that entity. For example, for a compressor, its entity data includes attributes such as pressure, speed, manufacturer, and classification code. Because the construction phase includes multiple stages such as preliminary design, construction drawing design, procurement, and construction, the entity data generated at each stage is stored in its respective database, and the sorting rules for entity data differ between databases, resulting in significant data dispersion. Therefore, when applying entity data from multiple stages during the operation phase, it is necessary to query entity data in multiple databases separately. Furthermore, when comparing entity data from multiple stages during the construction phase, the different sorting rules in each database make it difficult to find corresponding data within the entity data. This makes the application of entity data time-consuming, labor-intensive, and inefficient. Therefore, it is necessary to integrate entity data from multiple stages, combine the entity data from multiple stages into one, and sort it according to a unified sorting rule in order to improve the application efficiency of entity data. Summary of the Invention

[0003] This application provides a data integration method, apparatus, computer equipment, and storage medium, which can improve the application efficiency of entity data. The technical solution is as follows:

[0004] On the one hand, a data integration method is provided, the method comprising:

[0005] Obtain the first sorting information of the target project and the database of the target project in multiple stages, wherein the database of each stage includes the entity data of multiple entities of the target project in that stage;

[0006] For each entity, based on the first sorting information and the entity data of the entity at each stage, the first attribute information of the entity at each stage is determined, and the first sorting information is used to guide the sorting of the entity data in the first attribute information;

[0007] The first attribute information of the entity at each stage is screened to determine the second attribute information that meets the preset conditions;

[0008] The entity is obtained through integrated processing information at multiple stages, which is used to guide the integration of second attribute information at the multiple stages.

[0009] Based on the integrated processing information, the second attribute information of the multiple stages is integrated to obtain the integrated data of the entity. The integrated data includes multiple versions of third attribute information. Each version of the third attribute information includes entity data from at least one stage of the second attribute information. The entity data in each version of the third attribute information is sorted according to a preset sorting rule.

[0010] In one possible implementation, the first attribute information further includes the state information of the entity data. The step of screening the first attribute information of the entity at each stage to determine the second attribute information that meets preset conditions includes:

[0011] From multiple first attribute information, determine the target first attribute information whose state information is the first state information;

[0012] The target first attribute information is used as the second attribute information, and the first status information is used to indicate that the first attribute information meets the preset conditions.

[0013] In one possible implementation, the first attribute information further includes a unique identifier of the entity data, stage information, and information indicating completeness of settings; the preset conditions include a first preset condition and a second preset condition; and the method further includes:

[0014] For each first attribute information, if the plurality of entities do not include any first attribute information that is completely identical to the unique identifier and stage information in the plurality of first attribute information in the plurality of stages, and the set complete information is complete, then the status information is updated to first status information, and the first status information is used to indicate that the first attribute information meets the first preset condition and meets the second preset condition.

[0015] For each first attribute information, if the plurality of entities do not include first attribute information that is completely identical to the unique identifier and stage information in the plurality of first attribute information in the plurality of stages, and the set complete information is incomplete, then the status information is updated to second status information, the second status information being used to indicate that the first attribute information meets the first preset condition and does not meet the second preset condition.

[0016] For each first attribute information, if the plurality of entities include first attribute information that is completely identical to the unique identifier and stage information in the plurality of first attribute information in the plurality of stages, and the set complete information is complete, then the status information is updated to third status information, the third status information being used to indicate that the first attribute information does not meet the first preset condition and meets the second preset condition;

[0017] For each first attribute information, if the plurality of entities include first attribute information that is completely identical to the unique identifier and stage information in the plurality of first attribute information in the plurality of stages, and the set complete information is incomplete, then the status information is updated to fourth status information, the fourth status information being used to indicate that the first attribute information does not meet the first preset condition and does not meet the second preset condition.

[0018] In one possible implementation, the multiple stages are multiple stages arranged in chronological order. The integrated processing information includes sequence information of the multiple stages, encoding processing information of each stage, and a preset sorting rule for the entity data of the third attribute information in the integrated data. The step of integrating the second attribute information of the entity in the multiple stages based on the integrated processing information to obtain the integrated data of the entity includes:

[0019] Based on the entity's encoding processing information at each stage and the sequence information, the second attribute information of the multiple stages is processed sequentially to obtain multiple versions of fourth attribute information. The entity encoding in the multiple versions of fourth attribute information is the same. The entity encoding is used to represent the entity. Each version of fourth attribute information includes entity data in the second attribute information of the corresponding stage and entity data in the second attribute information of each stage before the stage.

[0020] The entity data in the fourth attribute information of each version is sorted according to the preset sorting rule to obtain the integrated data of the entity. The integrated data includes the third attribute information of multiple versions, and the entity data in the third attribute information of each version is sorted according to the preset sorting rule.

[0021] In one possible implementation, the processing method corresponding to the encoded processing information includes one of creation processing, collection processing, temporary storage processing, creation or collection processing, creation and association processing, and collection and association processing. The encoded processing information is used to guide the processing of entities in the second attribute information, which includes a unique identifier and a reference identifier.

[0022] Based on the entity's encoded processing information at each stage and the sequence information, the second attribute information of the multiple stages is processed sequentially to obtain multiple versions of the fourth attribute information, including:

[0023] If the processing method corresponding to the encoded processing information is creation processing, then entity encoding is created for the entity in the second attribute information to obtain fourth attribute information containing entity encoding;

[0024] If the processing method corresponding to the encoded processing information is aggregation processing, then the target fourth attribute information that matches the unique identifier of the second attribute information is determined from multiple fourth attribute information. The entity of the target fourth attribute information is the same as the entity of the second attribute information. The entity encoding of the target fourth attribute information is assigned to the entity in the second attribute information to obtain fourth attribute information containing entity encoding.

[0025] If the processing method corresponding to the encoded processing information is creation or collection processing, and the multiple fourth attribute information does not include target fourth attribute information that matches the unique identifier of the second attribute information, then entity encoding is created for the entity in the second attribute information to obtain fourth attribute information containing entity encoding.

[0026] If the processing method corresponding to the encoded processing information is temporary storage processing, then the second attribute information is stored to obtain the fifth attribute information;

[0027] If the processing method corresponding to the encoded processing information is creation and association processing, then the target fifth attribute information that matches the comparison identifier of the second attribute information is determined. The entity of the target fifth attribute information is the same as the entity of the second attribute information. Entity codes are created for the entities of the second attribute information and the target fifth attribute information, respectively obtaining the fourth attribute information containing the entity code corresponding to the second attribute information and the fourth attribute information containing the entity code corresponding to the target fifth attribute information.

[0028] If the processing method corresponding to the encoded processing information is aggregation and association processing, then the target fifth attribute information that matches the comparison identifier of the second attribute information is determined, the target fourth attribute information that matches the unique identifier of the second attribute information is determined from the plurality of fourth attribute information, and the entity encoding of the target fourth attribute information is assigned to the entities of the second attribute information and the target fifth attribute information, respectively obtaining the fourth attribute information containing the entity encoding corresponding to the second attribute information and the fourth attribute information containing the entity encoding corresponding to the target fifth attribute information.

[0029] In one possible implementation, the integrated processing information includes encoding processing information, and obtaining the encoding processing information of the entity at each stage includes:

[0030] Obtain the second sorting information of the target project;

[0031] Based on the second sorting information of the target project and the database of the target project at multiple stages, the encoding processing information of each entity at each stage is determined, wherein the second sorting information is used to guide the sorting of the encoding processing data in the encoding processing information.

[0032] On the other hand, a data integration apparatus is provided, the apparatus comprising:

[0033] The first acquisition module is used to acquire the first sorting information of the target project and the database of the target project in multiple stages, wherein the database of each stage includes the entity data of multiple entities of the target project in that stage;

[0034] The first determining module is used to determine, for each entity, first attribute information of the entity at each stage based on the first sorting information and the entity data of the entity at each stage, wherein the first sorting information is used to guide the sorting of the entity data in the first attribute information;

[0035] The second determining module is used to screen the first attribute information of the entity at each stage and determine the second attribute information that meets the preset conditions.

[0036] The second acquisition module is used to acquire integrated processing information of the entity at multiple stages, and the integrated processing information is used to guide the integration of the second attribute information at the multiple stages.

[0037] The processing module is used to integrate the second attribute information of the multiple stages based on the integrated processing information to obtain the integrated data of the entity. The integrated data includes multiple versions of third attribute information. Each version of the third attribute information includes entity data from at least one stage of the second attribute information. The entity data in each version of the third attribute information is sorted according to a preset sorting rule.

[0038] In one possible implementation, the first attribute information further includes the state information of the entity data, and the second determining module is used for:

[0039] From multiple first attribute information, determine the target first attribute information whose state information is the first state information;

[0040] The target first attribute information is used as the second attribute information, and the first status information is used to indicate that the first attribute information meets the preset conditions.

[0041] In one possible implementation, the first attribute information further includes a unique identifier of the entity data, stage information, and information indicating completeness of settings; the preset conditions include a first preset condition and a second preset condition; and the device further includes:

[0042] The first update module is used to update the status information to first status information for each first attribute information if the plurality of entities do not include first attribute information that is completely identical to the unique identifier and stage information in the first attribute information in the plurality of stages, and the set complete information is complete. The first status information is used to indicate that the first attribute information meets the first preset condition and meets the second preset condition.

[0043] The second update module is used to update the status information to a second status information for each first attribute information if the plurality of entities do not include first attribute information that is completely identical to the unique identifier and stage information in the first attribute information in the plurality of stages, and the set complete information is incomplete. The second status information is used to indicate that the first attribute information meets the first preset condition and does not meet the second preset condition.

[0044] The third update module is used to update the status information to a third status information for each first attribute information if the multiple entities include first attribute information that is completely identical to the unique identifier and stage information in the multiple first attribute information of the multiple stages, and the set complete information is complete. The third status information is used to indicate that the first attribute information does not meet the first preset condition and meets the second preset condition.

[0045] The fourth update module is used to update the status information to a fourth status information for each first attribute information if the plurality of entities include first attribute information that is completely identical to the unique identifier and stage information in the first attribute information in the plurality of stages, and the set complete information is incomplete. The fourth status information is used to indicate that the first attribute information does not meet the first preset condition and does not meet the second preset condition.

[0046] In one possible implementation, the multiple stages are multiple stages arranged in chronological order, and the integrated processing information includes sequence information of the multiple stages, encoded processing information of each stage, and a preset sorting rule for the entity data of the third attribute information in the integrated data. The processing module includes:

[0047] The processing unit is configured to process the second attribute information of the multiple stages sequentially based on the encoding processing information of the entity at each stage and the sequence information to obtain multiple versions of fourth attribute information. The entity encoding in the multiple versions of fourth attribute information is the same. The entity encoding is used to represent the entity. Each version of fourth attribute information includes entity data in the second attribute information of the corresponding stage of the version and entity data in the second attribute information of each stage before the stage.

[0048] The sorting unit is used to sort the entity data in the fourth attribute information of each version according to the preset sorting rule to obtain the integrated data of the entity. The integrated data includes the third attribute information of multiple versions, and the entity data in the third attribute information of each version is sorted according to the preset sorting rule.

[0049] In one possible implementation, the processing method corresponding to the encoded processing information includes one of creation processing, collection processing, temporary storage processing, creation or collection processing, creation and association processing, and collection and association processing. The encoded processing information is used to guide the processing of entities in the second attribute information, which includes a unique identifier and a reference identifier.

[0050] The processing unit is used for:

[0051] If the processing method corresponding to the encoded processing information is creation processing, then entity encoding is created for the entity in the second attribute information to obtain fourth attribute information containing entity encoding;

[0052] If the processing method corresponding to the encoded processing information is aggregation processing, then the target fourth attribute information that matches the unique identifier of the second attribute information is determined from multiple fourth attribute information. The entity of the target fourth attribute information is the same as the entity of the second attribute information. The entity encoding of the target fourth attribute information is assigned to the entity in the second attribute information to obtain fourth attribute information containing entity encoding.

[0053] If the processing method corresponding to the encoded processing information is creation or collection processing, and the multiple fourth attribute information does not include target fourth attribute information that matches the unique identifier of the second attribute information, then entity encoding is created for the entity in the second attribute information to obtain fourth attribute information containing entity encoding.

[0054] If the processing method corresponding to the encoded processing information is temporary storage processing, then the second attribute information is stored to obtain the fifth attribute information;

[0055] If the processing method corresponding to the encoded processing information is creation and association processing, then the target fifth attribute information that matches the comparison identifier of the second attribute information is determined. The entity of the target fifth attribute information is the same as the entity of the second attribute information. Entity codes are created for the entities of the second attribute information and the target fifth attribute information, respectively obtaining the fourth attribute information containing the entity code corresponding to the second attribute information and the fourth attribute information containing the entity code corresponding to the target fifth attribute information.

[0056] If the processing method corresponding to the encoded processing information is aggregation and association processing, then the target fifth attribute information that matches the comparison identifier of the second attribute information is determined, the target fourth attribute information that matches the unique identifier of the second attribute information is determined from the plurality of fourth attribute information, and the entity encoding of the target fourth attribute information is assigned to the entities of the second attribute information and the target fifth attribute information, respectively obtaining the fourth attribute information containing the entity encoding corresponding to the second attribute information and the fourth attribute information containing the entity encoding corresponding to the target fifth attribute information.

[0057] In one possible implementation, the integrated processing information includes encoded processing information, and the second acquisition module is used for:

[0058] Obtain the second sorting information of the target project;

[0059] Based on the second sorting information of the target project and the database of the target project at multiple stages, the encoding processing information of each entity at each stage is determined, wherein the second sorting information is used to guide the sorting of the encoding processing data in the encoding processing information.

[0060] On the other hand, a computer device is provided, the computer device including one or more processors and one or more memories, the one or more memories storing at least one instruction, the at least one instruction being loaded and executed by the one or more processors to perform the operations performed by the data integration method described in any of the above implementations.

[0061] On the other hand, a computer-readable storage medium is provided, wherein at least one instruction is stored in the computer-readable storage medium, the at least one instruction being loaded and executed by a processor to perform the operations performed by the data integration method described in any of the above implementations.

[0062] On the other hand, a computer program product or computer program is provided, the computer program product or computer program including computer program code stored in a computer-readable storage medium. A processor of a computer device reads the computer program code from the computer-readable storage medium, and the processor executes the computer program code, causing the computer device to perform the operations performed by the data integration method described above.

[0063] The beneficial effects of the technical solutions provided by the embodiments of the present application include at least:

[0064] This application provides a data integration method. The method sorts entity data in a database across multiple stages using first sorting information to obtain first attribute information, thus achieving pre-integration of entity data across multiple stages. Then, it integrates second attribute information from multiple stages that meets preset conditions to obtain integrated data. The entity data in the integrated data is sorted according to a preset sorting rule, achieving data integration of entity data from the second attribute information of multiple stages. Thus, when applying entity data, the integrated data allows direct access to entity data based on the sorting rules of multiple stages, thereby improving the efficiency of entity data application. Attached Figure Description

[0065] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying 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.

[0066] Figure 1 This is a flowchart of a data integration method provided in an embodiment of this application;

[0067] Figure 2 This is a schematic diagram of a process for quality checking of first attribute information provided in an embodiment of this application;

[0068] Figure 3 This is a flowchart illustrating a data integration method provided in an embodiment of this application;

[0069] Figure 4 This is a block diagram of a data integration device provided in an embodiment of this application;

[0070] Figure 5 This is a block diagram of a computer device provided in an embodiment of this application. Detailed Implementation

[0071] To make the objectives, technical solutions, and advantages of this application clearer, the embodiments of this application will be described in further detail below with reference to the accompanying drawings.

[0072] This application provides a data integration method, see [link to relevant documentation]. Figure 1 The methods include:

[0073] Step 101: The computer device acquires the first sorting information of the target project and the database of the target project at multiple stages.

[0074] Each stage's database includes entity data for multiple entities within the target project at that stage. The target project can be any construction project of the enterprise; for example, for an oil company, the target project could be an oil extraction project or a natural gas extraction project. Entities include equipment entities and facility entities; equipment entities include machinery and equipment such as compressors, engines, and pipelines, while facility entities include power grid facilities, bridge facilities, site facilities, and other institutions, organizations, systems, and buildings established to meet the construction needs of the project. Entity data for any entity includes data representing the entity's attributes, such as the project number and site number of the project to which the entity belongs. For equipment entities, this also includes the equipment's pressure, power, and manufacturer. The multiple stages represent the various phases of the target project's construction, such as the preliminary design stage, construction drawing stage, procurement stage, and construction stage.

[0075] The first sorting information is used to sort the entity data. The database also includes classification codes and classification names for entities. The first sorting information further includes sorting information based on the entity's classification code and classification name, as shown in Table 1. Table 1 illustrates one method for sorting entity classification codes and entity classification names. If the entity is a compressor, its corresponding entity classification code and entity classification name sorting method is shown in Table 2. The entity classification code is 100301, and the entity classification name is centrifugal natural gas compressor.

[0076] It should be noted that entity data includes data representing the attributes of an entity, and the first sorting information also includes information for sorting the entity data at each stage, used to sort the entity data; for example, see the data table in Table 3, which includes the entity's classification code and attribute data, and is supplemented with a unique identifier for each first attribute information, the stage in which the entity data in the first attribute information was generated, and a first data state for representing the status information of the first attribute information. In this way, the first sorting information can achieve a detailed division of entity data at multiple stages.

[0077] Table 1

[0078] Serial Number Entity classification code Entity category name 1 2 …

[0079] Table 2

[0080] Serial Number Entity classification code Entity category name 1 100301 Centrifugal natural gas compressor

[0081] Table 3

[0082]

[0083] Step 102: For each entity, the computer device determines the first attribute information of the entity at each stage based on the first sorting information and the entity data of the entity at each stage.

[0084] The first sorting information is used to guide the sorting of entity data in the first attribute information. The first sorting information is information that sorts the entity data according to, for example, the order shown in Table 3.

[0085] It should be noted that before determining the first attribute information of an entity at each stage based on the first sorting information and the entity data at each stage, the computer equipment pre-integrates the entity data of each entity in the databases of multiple stages. The entity data of these multiple stages is then mapped to attributes in stages to obtain the entity data of the entity at each stage, as shown in Table 4. The integration result data in the first column of the table includes all entity data used to represent attributes and the units of measurement for the entity data. The second, third, fourth, and fifth columns, etc., represent the entity data corresponding to multiple stages. Taking a compressor as an example, see Table 5. The entity data of the compressor includes entity data representing attributes such as compressor number, version, classification code, preliminary design data identifier, construction drawing data identifier, procurement data identifier, construction data identifier, MDM (Master Data Management) station number, pipeline engineering code, construction period pipeline number, construction period station number, design location number, design pressure, rated speed, rated flow, manufacturer, factory number, and commissioning time. For the preliminary design phase, entity data includes classification code, preliminary design data identifier, project code, pipeline number, station number, design location number, design pressure, and rated speed. For the construction drawing phase, entity data includes classification code, construction drawing data identifier, project code, pipeline number, station number, design location number, design pressure, rated speed, and rated flow rate. For the procurement phase, entity data includes classification code, procurement data identifier, project code, pipeline number, rated speed, rated flow rate, manufacturer, and serial number. For the construction phase, entity data includes classification code, construction data identifier, project code, pipeline number, station number, design location number, manufacturer, serial number, and commissioning time.

[0086] It should be noted that the pre-integrated information includes pre-defined complete information; that is, the entity data in the pre-integrated information includes pre-defined complete entity data, which is mandatory in the pre-integrated information shown in Table 4. The pre-defined complete entity data can be set and changed as needed. For example, for the compressor in Table 5, the pre-defined complete entity data includes classification code, project number, pipeline number, battlefield code, design location number, production site and factory number, etc., which can be used to represent the entity's classification, project, location, and production information.

[0087] Table 4

[0088]

[0089] Table 5

[0090]

[0091]

[0092] In this step, the computer equipment sorts the entity data in the pre-integrated information shown in Table 4 according to the first sorting information shown in Table 3, obtaining the first attribute information of the entity at each stage. Continuing with the example of a compressor, the compressor has multiple stages: preliminary design stage, construction drawing stage, procurement stage, and construction stage. The entity data in the pre-integrated information of the compressor shown in Table 4 is sorted according to the order in the first sorting information shown in Table 3, obtaining the first attribute information of the compressor at the preliminary design stage, construction drawing stage, procurement stage, and construction stage.

[0093] The first sorting information also includes a first data status, which indicates whether the entity data in the first attribute information has undergone quality checks, and the results of the quality checks. The first data status includes various states such as newly added, failed uniqueness check, failed integrity check, modified and awaiting inspection, duplicated and invalid data, passed quality check, data temporarily stored, and data processed. Specifically, "newly added" indicates that the entity data in the first attribute information was directly obtained from the pre-integrated information and has not undergone quality checks. "Passed quality check" indicates that the entity data in the first attribute information has undergone quality checks and passed the checks.

[0094] Refer to Tables 6, 7, 8, and 9, which show the sorting information of entity data in the first attribute information of the compressor during the preliminary design, construction drawing, procurement, and construction phases, respectively. The first attribute information for each phase includes the entity data generated during that phase. Tables 10, 11, 12, and 13 show the first attribute information for the preliminary design, construction drawing, procurement, and construction phases when the first data status is "new." As can be seen from the tables, the entity data for each phase is arranged sequentially.

[0095] Table 6

[0096]

[0097] Table 7

[0098]

[0099] Table 8

[0100]

[0101] Table 9

[0102]

[0103]

[0104] Table 10

[0105]

[0106] Table 11

[0107]

[0108] Table 12

[0109]

[0110] Table 13

[0111]

[0112] In this embodiment of the application, the entity data is sorted by the first sorting information to obtain the first attribute information, thereby realizing the preprocessing of the entity data and improving the efficiency of subsequent integration of entity data.

[0113] Step 103: The computer equipment screens the first attribute information of the entity at each stage and determines the second attribute information that meets the preset conditions.

[0114] The first attribute information also includes the entity data's status information. The status information includes the unique identifier and first data status as shown in Table 3. The first attribute information also includes the entity data's unique identifier, stage information, and complete setting information. The preset conditions include a first preset condition and a second preset condition. Determining the status information includes at least one of the following implementation methods:

[0115] (1) For each first attribute information, if multiple entities do not include first attribute information that is completely identical to the unique identifier and stage information in the first attribute information in multiple stages, and the set complete information is complete, then the computer device updates the status information to the first status information. The first status information is used to indicate that the first attribute information meets the first preset condition and meets the second preset condition.

[0116] The first status information indicates that a unique identifier has been generated in the first attribute information, and the first data status is "passed quality check." The unique identifier indicates that among multiple first attribute information entries for multiple entities at multiple stages, there is no first attribute information that is completely identical to the unique identifier and stage information in the first attribute information; that is, this first attribute information is unique among multiple first attribute information entries and there is no duplicate first attribute information. "Passed quality check" indicates that the data in the complete information set in the first attribute information is filled in completely.

[0117] The unique identifier is entity data used to indicate the uniqueness of the entity corresponding to the first attribute information. The unique identifier of any entity can be the same or different at different stages. For example, for an entity that is a compressor, the unique identifiers at different stages are shown in Table 14. The unique identifiers at the preliminary design stage include the classification code, project code, pipeline number, battlefield number, and design location number. The unique identifiers at the construction drawing stage and the construction stage are the same as those at the preliminary design stage. The unique identifiers at the procurement stage include the manufacturer and the serial number.

[0118] The code information is used to represent the classification code of the entity, and the stage information is used to represent the stage corresponding to the first attribute information. For example, for the area with design location number 004001, construction period battlefield number SP001, construction period pipeline number T01, and pipeline project code ZEDB in the first attribute information, the entity classification code is 100301, and the stage is the preliminary design stage. This indicates that the compressor with entity classification code 1000301 generates entity data in the above area during the preliminary design stage.

[0119] Table 14

[0120]

[0121] Refer to Tables 15, 16, 17, and 18, which show the first attribute information for the compressor entity at the preliminary design stage, construction drawing stage, procurement stage, and construction stage, respectively, after passing quality inspection. As can be seen from the tables, a unique identifier is generated in the first attribute information, and the first data status is "passed quality inspection," meaning the status information is the first status information.

[0122] Table 15

[0123]

[0124] Table 16

[0125]

[0126] Table 17

[0127]

[0128] Table 18

[0129]

[0130] (2) For each first attribute information, if multiple entities do not include first attribute information that is completely identical to the unique identifier and stage information in the first attribute information in multiple stages, and the set complete information is incomplete, then the computer device updates the status information to the second status information. The second status information is used to indicate that the first attribute information meets the first preset condition and does not meet the second preset condition.

[0131] The second status information indicates that a unique identifier has been generated in the first attribute information, and the first data status is "failed integrity check." "Failed integrity check" means that the data in the first attribute information, which is supposed to be complete, is incomplete.

[0132] (3) For each first attribute information, if multiple entities include first attribute information that is completely identical to the unique identifier and stage information in multiple first attribute information in multiple stages, and the set complete information is complete, then the computer device updates the status information to the third status information. The third status information is used to indicate that the first attribute information does not meet the first preset condition and meets the second preset condition.

[0133] The third status information indicates that no unique identifier was generated in the first attribute information, meaning the unique identifier is empty. The first data status is that it failed the uniqueness check but passed the quality check. "Failed the uniqueness check" indicates that multiple entities in multiple stages have multiple first attribute information entries containing first attribute information that is completely identical to the unique identifier and stage information in the first attribute information. In other words, this first attribute information is not unique among multiple first attribute information entries and contains first attribute information that is duplicated.

[0134] (4) For each first attribute information, if multiple entities include first attribute information that is completely identical to the unique identifier, code information and stage information in multiple first attribute information in multiple stages, and the set complete information is incomplete, then the status information is updated to the fourth status information. The fourth status information is used to indicate that the first attribute information does not meet the first preset condition and does not meet the second preset condition.

[0135] The fourth status information is that no unique identifier was generated in the first attribute information, that is, the unique identifier is empty. The first data status is that it failed the uniqueness check and failed the integrity check.

[0136] It should be noted that the computer equipment also verifies and modifies the first attribute whose status information is not the first status information. The computer equipment queries the first attribute information whose status information is the second, third, or fourth status information. For first data status information that fails the integrity check, verification is performed. If it is determined that the information set to be complete in the first attribute information is incomplete, the information set to be complete is modified to make it complete. For first data status information that fails the uniqueness check, verification is performed. If it is determined to be duplicate data, the first data status is changed to "data duplicate and invalid". For first attribute information that has been verified and modified, the first data status is changed to "modified and awaiting inspection". The first attribute information with the first data status of "new" and "modified and awaiting inspection" is re-tested for quality, the status information is updated, and finally, the first attribute information with a generated unique identifier and a first data status that passes the quality check and the first attribute information with a first data status that does not generate a unique identifier and a first data status that is "data duplicate and invalid" are obtained.

[0137] See Figure 2 The diagram illustrates the process of quality checking for the second attribute information. The computer equipment performs a quality check on the status information in the first attribute information. For first attribute information that passes the uniqueness and integrity checks, the status information is updated to "passed quality check." For first attribute information that fails the uniqueness or integrity checks, data verification and modification are performed, and the above steps are repeated for a new quality check.

[0138] After determining the status information of the first attribute information, the computer device determines the second attribute information that meets the preset conditions through the following steps (1)-(2):

[0139] (1) The computer device determines the target first attribute information of the first state information from multiple first attribute information.

[0140] The first status information is that a unique identifier has been generated in the first attribute information, and the first data status is that it has passed the quality check.

[0141] (2) The computer device uses the target first attribute information as the second attribute information, and the first status information is used to indicate that the first attribute information meets the preset conditions.

[0142] In this embodiment of the application, by determining the second attribute information that meets the preset conditions, the first attribute information is filtered, thus avoiding the impact of the first attribute information that fails the quality check on data integration.

[0143] Step 104: The computer device acquires integrated processing information of the entity at multiple stages.

[0144] The integration processing information guides the integration of second attribute information from multiple stages. These multiple stages are arranged chronologically, and the integration processing information includes the sequence information of each stage, the encoding processing information for each stage, and the preset sorting rules for the entity data of the third attribute information within the integrated data.

[0145] The multiple stages are arranged chronologically, and their order can be determined based on the sequence in which each stage occurs. For example, the multiple stages could be the preliminary design stage, the construction drawing stage, the procurement stage, and the construction stage. Based on the chronological order of the multiple stages, their sequence would be: preliminary design stage, construction drawing stage, procurement stage, and construction stage, arranged sequentially.

[0146] Computer devices can acquire encoded processing information through the following steps (1)-(2):

[0147] (1) The computer device obtains the second sorting information of the target item.

[0148] The database also includes encoding processing data, and the second sorting information is used to sort the encoding processing data in the database. Encoding processing data includes processing method data and encoding rule data. Processing method data includes creation processing, aggregation processing, temporary storage processing, creation or aggregation processing, creation and association processing, aggregation and association processing, etc. Encoding rule data includes encoding methods and encoding rules. Encoding methods include direct creation encoding, reference creation, and reference creation. Direct creation directly creates a unified entity code for an entity across multiple stages based on the data standard of the encoding rules. Reference creation refers to referencing the entity code of a certain stage or the attribute value of the entity data used to represent attributes in the entity data, and then combining it with the encoding rules to create a unified entity code for the entity across multiple stages. Reference creation directly references the entity code of a certain stage if it is unique among multiple second attribute information, using that entity code as the unified entity code for the entity across multiple stages. Encoding rules are the rules corresponding to the encoding methods; for example, if the encoding method is direct creation, the corresponding encoding rule can be a 13-bit sequential encoding.

[0149] The second sorting information sorts the processing method data, as shown in Table 19. Entity classification code, entity classification name, and processing method for each stage are arranged in sequence. The second sorting information sorts the coding rule data, as shown in Table 20. Entity classification code, entity classification name, code name, coding method, and coding rule are arranged in sequence.

[0150] Table 19

[0151]

[0152] Table 20

[0153]

[0154] (2) The computer device determines the coding processing information of each entity at each stage based on the second sorting information of the target project and the database of the target project at multiple stages. The second sorting information is used to guide the sorting of the coding processing data in the coding processing information.

[0155] The encoding processing information includes processing method information and encoding rule information. The processing method information is obtained by the computer device sorting the processing method data based on the sorting method in the second sorting information. The encoding rule information is obtained by the computer device sorting the encoding rule data based on the sorting method in the second sorting information.

[0156] Continuing with the example of a compressor, refer to Table 21. Table 21 shows the processing methods for the compressor in the preliminary design stage, construction drawing stage, procurement stage, and construction stage, respectively: creation, collection, temporary storage, and collection and association. The construction stage is associated with the procurement stage. Refer to Table 22, which shows the encoding method and rules for the compressor. The encoding method is direct creation, and the corresponding encoding rule is a 13-bit sequential code.

[0157] Table 21

[0158]

[0159] Table 22

[0160] Serial Number Entity classification code Entity category name Encoding name Encoding method Coding Rules 1 100301 Centrifugal natural gas compressor Compressor number Create directly 13-bit serial encoding

[0161] Step 105: The computer device integrates the second attribute information from multiple stages based on the integrated processing information to obtain the integrated data of the entity.

[0162] The integrated data includes multiple versions of third attribute information. Each version of the third attribute information includes entity data from at least one stage of the second attribute information. The entity data in each version of the third attribute information is sorted according to a preset sorting rule.

[0163] In this step, the computer device processes the second attribute information of multiple stages sequentially based on the encoded processing information and sequence information of the entity at each stage, resulting in multiple versions of fourth attribute information. The computer device then sorts the entity data in each version of the fourth attribute information according to a preset sorting rule to obtain integrated entity data. The integrated data includes multiple versions of third attribute information, and the entity data in each version of the third attribute information is sorted according to a preset sorting rule.

[0164] Continuing with the example of multiple stages in sequence, namely the preliminary design stage, the construction drawing stage, the procurement stage, and the construction stage, the computer equipment processes the second attribute information of the preliminary design stage, the construction drawing stage, the procurement stage, and the construction stage in sequence to obtain the fourth attribute information of the entity in each stage.

[0165] Among them, the entity codes in the fourth attribute information of multiple versions are the same. The entity code is used to represent the entity. The fourth attribute information of each version includes the entity data in the second attribute information of the corresponding stage of that version and the entity data in the second attribute information of each stage before that stage.

[0166] The third attribute information in multiple versions includes general and specialized fields, as shown in Table 23. General fields include entity code, version, classification code, first-stage data identifier, second-stage data identifier, third-stage data identifier, fourth-stage data identifier, and second data status for each stage. Specialized fields include entity data generated by the entity at each stage to represent attributes, consistent with the entity data in the attribute mapping of the pre-integrated information and the entity data in the second attribute information. The preset sorting rules for the third attribute information can be set and changed as needed.

[0167] It should be noted that the version number is used to mark the update status of the third attribute information generated after the integration and processing of the second attribute information at different stages. The version number consists of one letter and two numbers; the letter indicates the stage of the second attribute information, such as A for stage one, B for stage two, etc. The numbers indicate the update status of the third attribute information, such as the initial value of the newly generated third attribute information being 01, and subsequent updates incrementing by one from the previous version. The second data status is used to indicate the status of the entity data in the third attribute information, determined in conjunction with the version and coding approval process. The second data status includes states such as creation application pending, creation application pending approval, creation approval completed, update pending approval, update approval completed, and data valid.

[0168] Table 23

[0169]

[0170] Continuing with the example of the third attribute information for multiple versions of a compressor, the preset sorting rules are shown in Table 24. The multiple stages are the preliminary design stage, construction drawing stage, procurement stage, and construction stage. Common fields include entity code, version, classification code, preliminary design stage data identifier, construction drawing stage data identifier, procurement stage data identifier, construction stage data identifier, and second data status. Specialized fields include pipeline engineering code, construction period pipeline number, construction period station number, design location number, design pressure, rated speed, rated flow rate, manufacturer, factory serial number, and commissioning time.

[0171] Table 24

[0172]

[0173]

[0174] The processing method corresponding to the encoded processing information includes one of the following: creation processing, collection processing, temporary storage processing, creation or collection processing, creation and association processing, and collection and association processing. The encoded processing information is used to guide the processing of entities in the second attribute information. The computer device processes the second attribute information, including at least one of the following implementation methods:

[0175] (1) If the processing method corresponding to the encoded processing information is creation processing, the computer device creates entity encoding for the entity in the second attribute information and obtains the third attribute information containing the entity encoding.

[0176] In this process, computer equipment creates codes for entities based on the coding rules information in the coding processing information. Continuing with the compressor example in Table 22, the coding method is direct creation, and the corresponding coding rule is 13-bit sequential coding. Therefore, the entity code for the compressor is directly created using the 13-bit sequential coding method.

[0177] Taking the preliminary design phase as an example, the creation process includes the following steps A1-A6:

[0178] A1: The computer device queries the coding rule information in the entity classification code query coding processing information, creates an code for the entity based on the queried coding rule information, and obtains the fourth attribute information containing the entity code.

[0179] A2: The computer device maps the numerical values ​​of the entity data in the second attribute information to the fourth attribute information.

[0180] A3: The computer device maps and fills the data in the fourth attribute information to make the data in the fourth attribute information complete.

[0181] Specifically, the created entity code is mapped to the entity code in the fourth attribute information; a version is generated according to the version encoding rules; the unique identifier in the second attribute information is mapped to the stage data identifier in the third attribute information based on the stage corresponding to the second attribute information; and the second data status in the fourth attribute information is updated to creation application temporary storage.

[0182] It should be noted that since the preliminary design stage is the first stage, the version number corresponding to this stage is A01. The fourth attribute information of this version only includes the entity data of the preliminary design stage. The third attribute information obtained by sorting the entity data in the fourth attribute information of this version according to the preset sorting rules is shown in Table 25. The second data status is creation application temporary storage. The third attribute information includes the values ​​of general fields such as entity code, version, classification code, preliminary design stage data identifier and second data status, as well as the values ​​of special fields such as pipeline engineering code, construction period pipeline number, construction period station number, design location number, design pressure, and rated speed.

[0183] Table 25

[0184]

[0185] A4: The computer device updates the first data status in the second attribute information to "data processed".

[0186] In this embodiment of the application, by updating the first data state of the processed second attribute information, the repeated processing of the second attribute information can be avoided, thereby improving processing efficiency.

[0187] A5: The computer device initiates an encoding application and approval process for third-attribute information.

[0188] The computer device initiates the approval process based on the approval process data in the database, and updates the second data status from application temporary storage to application creation pending approval.

[0189] A6: In response to the approval of the coding application, the computer device changes the second data status to "Application approval completed".

[0190] Among them, the third attribute information of the version corresponding to the preliminary design stage, the second data status of which is the third attribute information of the application approval completed is shown in Table 26. It includes the values ​​of general fields such as entity code, version, classification code, preliminary design stage data identifier and second data status, as well as the values ​​of special fields such as pipeline engineering code, construction period pipeline number, construction period station number, design location number, design pressure and rated speed.

[0191] Table 26

[0192]

[0193] (2) If the processing method corresponding to the encoded information is aggregation processing, then the target fourth attribute information that matches the unique identifier of the second attribute information is determined from multiple third attribute information. The entity of the target fourth attribute information is the same as the entity of the second attribute information. The entity encoding of the target fourth attribute information is assigned to the entity in the second attribute information to obtain the fourth attribute information containing the entity encoding.

[0194] Taking the processing method at the construction drawing stage as an example, the process includes the following steps A1-A6:

[0195] A1: The unique identifier of the second attribute information of computer equipment based on the entity's classification code and stage information is retrieved from the unique identifier information.

[0196] A2: The computer device determines the target fourth attribute information that matches the unique identifier among multiple fourth attribute information based on the unique identifier of the second attribute information.

[0197] In another possible implementation, if there are multiple instances of the target fourth attribute information, then the second data status is determined to be "approval completed," and the target fourth attribute information with the highest version is the target fourth attribute information corresponding to the second attribute information. "Highest version" indicates that the target fourth attribute information is the latest updated version.

[0198] A3: The computer device compares the value of the entity data in the second attribute information with the value of the entity data in the target fourth attribute information, maps the value of the entity data in the second attribute information to the fourth attribute information, and determines a new fourth attribute information. The status of the second data in the fourth attribute information is updated to "Creation Request Temporary Storage".

[0199] It should be noted that the data identifiers for different stages are different. The second attribute information includes different stage data identifiers from the target fourth attribute information. By supplementing the fourth attribute information with these stage data identifiers, the supplemented stage data identifiers, as newly added entity data, can effectively distinguish the stage corresponding to the second attribute information from the stage corresponding to the target third attribute information.

[0200] It should be noted that since the construction drawing stage is the second stage, the version number corresponding to this stage is B01. The fourth attribute information of this version includes entity data from both the construction drawing stage and the preliminary design stage. If the entity data from the construction drawing stage overlaps with that from the preliminary design stage, the entity data in the third attribute information of the version corresponding to the construction drawing stage will be selected from the entity data from the construction drawing stage. The third attribute information of this version, sorted according to a preset sorting rule, is shown in Table 27. The second data status is "Creation Application Temporary Storage," including values ​​for general fields such as entity code, version, classification code, preliminary design stage data identifier, construction drawing stage data identifier, and second data status, as well as values ​​for special fields such as pipeline engineering code, construction period pipeline number, construction period station number, design location number, design pressure, and rated speed.

[0201] It should be noted that since the preliminary design stage is the stage before the construction drawing stage, the second attribute information of the preliminary design stage has already been encoded during the construction drawing stage, resulting in the third attribute information of the corresponding version of the preliminary design stage. Arranging the third attribute information of the version corresponding to the preliminary design stage before the third attribute information of the version corresponding to the construction drawing stage allows for comparison of the third attribute information of the two versions during the encoding process, facilitating timely updates of the third attribute information of the current version.

[0202] Table 27

[0203]

[0204] It should be noted that, since the encoding of the second attribute information is performed sequentially according to the order of multiple stages, in one possible implementation, if the entity data of a certain attribute field in the third attribute information of the previous stage has a value (i.e., it is not empty), and the entity data of the corresponding attribute field in the second attribute information of the current stage has a value (i.e., it is not empty), then the value of the corresponding attribute field in the second attribute information is used as the value of the corresponding attribute field in the third attribute information of the current stage; if the entity data of the corresponding attribute field in the second attribute information of the current stage has no value, then the value of the corresponding attribute field in the third attribute information of the previous stage is used as the value of the corresponding attribute field in the third attribute information of the current stage; if the corresponding attribute field in the second attribute information of the current stage does not exist, then the value of the corresponding attribute field in the third attribute information of the previous stage is used as the value of the corresponding attribute field in the third attribute information of the current stage. In another possible implementation, if the entity data of a certain attribute field in the third attribute information of the previous stage is null, and the entity data of the corresponding attribute field in the second attribute information of the current stage has a value (i.e., it is not null), then the value corresponding to that attribute field in the second attribute information is used as the value corresponding to that attribute field in the third attribute information of the current stage. If the corresponding attribute field in the second attribute information of the current stage does not exist or is null, then the value corresponding to that attribute field in the third attribute information of the current stage is null. See Table 28 for specific implementation details.

[0205] Table 28

[0206]

[0207]

[0208] A4: The computer device updates the first data status in the second attribute information to "data processed".

[0209] In this embodiment of the application, by updating the first data state of the processed second attribute information, the repeated processing of the second attribute information can be avoided, thereby improving processing efficiency.

[0210] A5: The computer device initiates an encoding application and approval process for third-attribute information.

[0211] The computer device initiates the approval process based on the approval process data in the database, and updates the second data status from "Application Created Temporarily Stored" to "Application Created Pending Approval".

[0212] A6: In response to the approval of the coding application, the computer device changes the second data status to "Application approval completed".

[0213] Among them, the third attribute information of the version corresponding to the construction drawing stage, the second data status of the third attribute information of the second serial number in Table 29 is as follows: it includes the values ​​of general fields such as entity code, version, classification code, preliminary design stage data identifier, construction drawing stage data identifier, and second data status, as well as the values ​​of special fields such as pipeline engineering code, construction period pipeline number, construction period station number, design location number, design pressure, and rated speed.

[0214] It should be noted that since the preliminary design stage is the stage before the construction drawing stage, the second attribute information of the preliminary design stage has already been encoded during the construction drawing stage, resulting in the third attribute information of the corresponding version of the preliminary design stage. Arranging the third attribute information of the version corresponding to the preliminary design stage before the third attribute information of the version corresponding to the construction drawing stage allows for comparison of the third attribute information of the two versions during the encoding process, facilitating timely updates of the third attribute information of the current version.

[0215] Table 29

[0216]

[0217] (3) If the processing method corresponding to the encoded processing information is creation or collection processing, and the target fourth attribute information that matches the unique identifier of the second attribute information is not included among the multiple fourth attribute information, then entity encoding is created for the entity in the second attribute information to obtain the fourth attribute information containing the entity encoding.

[0218] In another possible implementation, if the processing method corresponding to the encoded information is creation or aggregation, and multiple fourth attribute information includes target fourth attribute information that matches the unique identifier of the second attribute information, then the entity code of the target fourth attribute information is assigned to the entity in the second attribute information, resulting in third attribute information containing the entity code. This avoids repeatedly creating entity codes for the entity.

[0219] The collection process is the same as the above implementation method (2), and the creation of entity codes is the same as the above implementation method (1), so it will not be repeated here.

[0220] (4) If the processing method corresponding to the encoded processing information is temporary storage, then the second attribute information is stored to obtain the fifth attribute information.

[0221] It should be noted that if the second attribute information cannot be directly aggregated or created with multiple fourth attribute information at the current stage, then the second attribute information will not be processed for the time being. Instead, the first data status of the second attribute information will be updated to data temporary storage to obtain the fifth attribute information.

[0222] Taking the processing method of the compressor's second attribute information in the procurement stage as temporary storage as an example; refer to Table 30, update the first data status in the second attribute information to temporary data storage.

[0223] Table 30

[0224]

[0225] (5) If the processing method corresponding to the encoded processing information is creation and association processing, then determine the target fifth attribute information that matches the comparison identifier of the second attribute information. The entity of the target fifth attribute information is the same as the entity of the second attribute information. Create entity codes for the entities of the second attribute information and the target fifth attribute information to obtain the fourth attribute information containing the entity code corresponding to the second attribute information and the fourth attribute information containing the entity code corresponding to the target fifth attribute information, respectively.

[0226] The reference identifier is used to match the second attribute information of multiple stages of the same entity. The reference identifier includes a reference field and calculation logic for the comparison. The reference field is the data included in the entity data. By matching the reference identifiers of the second attribute information with the reference information of multiple third attribute information, the target third attribute information that matches the second attribute information is determined. The reference identifier for each stage is obtained from the reference identifier information of the entity.

[0227] In one possible implementation, the reference identifier for each stage represents a unique entity, and the calculation logic is that the values ​​of the reference fields are equal. Referring to the reference identifier information in Table 31, taking multiple stages such as preliminary design stage, construction drawing stage, procurement stage, and construction stage as an example, the reference fields for the construction stage and the procurement stage are the manufacturer and the date of delivery, and the calculation logic is that the values ​​are equal; in this way, the target's fifth attribute information can be quickly and directly determined.

[0228] In another possible implementation, the entity represented by the reference field in the second attribute information is a unique entity, while the entity represented by the reference field in the fifth attribute information is a group or class of entities. In this case, numerical values, numerical ranges, and the relative positions of the entities are needed to match the reference fields. Referring again to Table 31, for example, if the reference field in the preliminary design stage is the starting / ending station number, and the reference field in the construction stage is "station number + relative station distance," then the calculation logic for these two reference fields is that the station number is located between the starting and ending station numbers. In this way, the target fifth attribute information can be accurately determined through the corresponding reference identifier.

[0229] Table 31

[0230]

[0231] In this implementation, the processing method is creation and association processing, so the second attribute information must be associated with the fifth attribute information. This implementation can be achieved through the following steps A1-A8:

[0232] A1: The computer device queries the coding rule information in the entity classification code query coding processing information, creates an code for the entity based on the queried coding rule information, and obtains the fourth attribute information containing the entity code.

[0233] A2: The computer device determines the target fifth attribute information that matches the reference identifier among multiple fifth attribute information based on the reference identifier of the second attribute information.

[0234] The number of fifth attribute information of the target can be multiple.

[0235] A3: The computer device determines the target fourth attribute information that matches the unique identifier among multiple fourth attribute information based on the unique identifier of the second attribute information.

[0236] In another possible implementation, if there are multiple instances of the target fourth attribute information, then the second data status is determined to be "approval completed," and the target fourth attribute information with the highest version is the target fourth attribute information corresponding to the second attribute information. "Highest version" indicates that the target fourth attribute information is the latest updated version. For example, for multiple stages such as preliminary design stage, construction drawing stage, procurement stage, and construction stage, the stage corresponding to the highest version is the construction stage.

[0237] A4: The computer device maps the values ​​of the entity data in the second attribute information and the target fifth attribute information to the fourth attribute information.

[0238] In one possible implementation, the second attribute information and the target fifth attribute information correspond to a fourth attribute information. The priorities of the stages corresponding to the second attribute information and the target fifth attribute information are compared. If the priority of the stage corresponding to the second attribute information is higher than the priority of the stage corresponding to the target fifth attribute information, the value of the entity data of the second attribute information is mapped to the fourth attribute information. If the priority of the stage corresponding to the second attribute information is lower than the priority of the target fifth attribute information, the value of the entity data of the target fifth attribute information is mapped to the fourth attribute information. The priorities of multiple stages are arranged in chronological order, with the stage occurring latest having the highest priority. For example, the preliminary design stage, construction drawing stage, procurement stage, and construction stage are multiple stages arranged in chronological order, with the priorities of the stages decreasing sequentially.

[0239] In another possible implementation, the second attribute information and the target fifth attribute information each correspond to a fourth attribute information. In this case, the entity data of the second attribute information and the entity data of the target fifth attribute information are mapped to the fourth attribute information corresponding to the second attribute information and the fourth attribute information corresponding to the target fifth attribute information, respectively.

[0240] A5: The computer device maps and fills the data in the fourth attribute information to keep the data in the fourth attribute information intact.

[0241] In this step, the created code is mapped to the entity code of the fourth attribute information; a version is generated according to the version coding rules; based on the stage corresponding to the second attribute information and the target fifth attribute information, the unique identifier in the second attribute information is mapped to the data identifier of the corresponding stage in the fourth attribute information; the second data status in the fourth attribute information is updated to "Creation Request Temporary Storage". The fourth attribute information of this version is sorted according to a preset sorting rule to obtain the third attribute information.

[0242] A6: The computer device updates the first data status in the second attribute information to "data processed", so that the first data status in the fifth attribute information of the target remains as "data temporarily stored".

[0243] In this embodiment of the application, by updating the first data state of the processed second attribute information, the repeated processing of the second attribute information can be avoided, thereby improving processing efficiency.

[0244] A7: Computer equipment initiates an encoding application and approval process for third-attribute information.

[0245] The computer device initiates the approval process based on the approval process data in the database, and updates the second data status from application temporary storage to application creation pending approval.

[0246] A8: In response to the approval of the coding application, the computer device changes the second data status to "Application approval completed".

[0247] (6) If the processing method corresponding to the encoded processing information is collection and association processing, then determine the target fifth attribute information that matches the comparison identifier of the second attribute information, determine the target fourth attribute information that matches the unique identifier of the second attribute information from multiple third attribute information, assign the entity code of the target third attribute information to the entity of the second attribute information and the target fifth attribute information, and obtain the fourth attribute information containing the entity code corresponding to the second attribute information and the fourth attribute information containing the entity code corresponding to the target fifth attribute information, respectively.

[0248] In this implementation, the processing method is aggregation and association processing. Therefore, the second attribute information must be associated with the fifth attribute information. The second attribute information and the associated fifth attribute information are the second attribute information of the same entity in two stages.

[0249] Taking the construction phase as an example of a collection and association process, and linking the construction phase to the procurement phase; this collection and association process includes the following steps A1-A8:

[0250] A1: The unique identifier of the second attribute information of computer equipment based on the entity's classification code and stage information is retrieved from the unique identifier information.

[0251] A2: The computer device determines the target fourth attribute information that matches the unique identifier among multiple fourth attribute information based on the unique identifier of the second attribute information.

[0252] In another possible implementation, if there are multiple instances of the target fourth attribute information, then the second data status is determined to be "approval completed," and the target fourth attribute information with the highest version is the target fourth attribute information corresponding to the second attribute information. "Highest version" indicates that the target fourth attribute information is the latest updated version.

[0253] A3: The computer device determines the target fifth attribute information that matches the reference identifier among multiple fifth attribute information based on the reference identifier of the second attribute information.

[0254] In this step, based on the classification code, the stage, association stage, and reference identifier information corresponding to the second attribute information, the reference field and calculation logic in the reference identifier are determined; in the second attribute information of the association stage, the second attribute information whose first data status is data temporary processing is queried, that is, the fifth attribute information; based on the reference identifier of the second attribute information, the target fifth attribute information that matches the reference identifier of the second attribute information is determined among multiple fifth attribute information.

[0255] A4: The computer device maps the values ​​of the entity data in the second attribute information and the target fifth attribute information to the fourth attribute information.

[0256] In one possible implementation, the second attribute information and the target fifth attribute information correspond to a third attribute information. The priorities of the stage corresponding to the second attribute information and the stage corresponding to the target fifth attribute information are compared. If the priority of the stage corresponding to the second attribute information is greater than the priority of the stage corresponding to the target fifth attribute information, the value of the entity data of the second attribute information is mapped to the third attribute information. If the priority of the stage corresponding to the second attribute information is less than the priority of the target fifth attribute information, the value of the entity data of the target fifth attribute information is mapped to the fourth attribute information.

[0257] In another possible implementation, the second attribute information and the target fifth attribute information each correspond to a third attribute information. Then, the entity data of the second attribute information and the entity data of the target fifth attribute information are mapped to the fourth attribute information corresponding to the second attribute information and the fourth attribute information corresponding to the target fifth attribute information, respectively.

[0258] A5: The computer device maps and fills the data in the fourth attribute information to keep the data in the fourth attribute information intact.

[0259] In this step, the created code is mapped to the entity code of the fourth attribute information; a version is generated according to the version coding rules; based on the stage corresponding to the second attribute information and the target fifth attribute information, the unique identifier in the second attribute information is mapped to the data identifier of the corresponding stage in the fourth attribute information; and the second data status in the fourth attribute information is updated to creation request temporary storage.

[0260] It should be noted that since the construction phase is the first phase, the version number corresponding to this phase is C01. The fourth attribute information of this version includes entity data from the preliminary design phase, construction drawing phase, procurement phase, and construction phase. The third attribute information of this version is obtained by sorting the fourth attribute information according to a preset sorting rule. If the entity data of the construction phase overlaps with the entity data of the preliminary design phase, construction drawing phase, or procurement phase, the entity data in the third attribute information of the version corresponding to the construction phase will be selected from the entity data of the construction phase. The second data status of the third attribute information of the version corresponding to the construction phase is the third attribute information temporarily stored in the creation application, as shown in the third attribute information of the third serial number in Table 32. The third attribute information includes the values ​​of general fields such as entity code, version, classification code, preliminary design phase data identifier, construction drawing phase data identifier, procurement phase data identifier, construction phase data identifier, and second data status, as well as the values ​​of special fields such as pipeline project code, construction period pipeline number, construction period station number, design location number, design pressure, rated speed, rated flow, manufacturer, factory number, and commissioning time.

[0261] It should be noted that since the preliminary design stage, construction drawing stage, and procurement stage are stages preceding the construction stage, the second attribute information of the preliminary design stage, construction drawing stage, and procurement stage has already been encoded during the construction stage, resulting in the third attribute information of the corresponding versions of the preliminary design stage, construction drawing stage, and procurement stage. Arranging the third attribute information of the versions corresponding to the preliminary design stage and the construction drawing stage before the third attribute information of the construction drawing stage allows for comparison of the third attribute information of multiple versions during the encoding process, facilitating timely updates of the third attribute information of the current version.

[0262] Table 32

[0263]

[0264] A6: The computer device updates the first data status in the second attribute information to "data processed", so that the first data status in the fifth attribute information of the target remains as "data temporarily stored".

[0265] In this embodiment of the application, by updating the first data state of the processed second attribute information, the repeated processing of the second attribute information can be avoided, thereby improving processing efficiency.

[0266] A7: Computer equipment initiates an encoding application and approval process for third-attribute information.

[0267] The computer device initiates the approval process based on the approval process data in the database, and updates the second data status from application temporary storage to application creation pending approval.

[0268] A8: In response to the approval of the coding application, the computer device changes the second data status to "Application approval completed".

[0269] The third attribute information of the version corresponding to the construction stage, with the second data status being "Creation Approval Completed", is shown in the third attribute information of the second serial number in Table 33. It includes the values ​​of general fields such as entity code, version, classification code, preliminary design stage data identifier, construction drawing stage data table identifier, procurement stage data identifier, construction stage data identifier, and second data status, as well as the values ​​of special fields such as pipeline project code, construction period pipeline number, construction period station number, design location number, design pressure, rated speed and rated flow, manufacturer, factory number, and commissioning time.

[0270] It should be noted that since the preliminary design stage, construction drawing stage, and procurement stage are stages preceding the construction stage, the second attribute information of the preliminary design stage, construction drawing stage, and procurement stage has already been coded during the construction stage, resulting in the third attribute information of the corresponding versions of the preliminary design stage, construction drawing stage, and procurement stage. Arranging the third attribute information of the versions corresponding to the preliminary design stage and the construction drawing stage before the third attribute information of the construction drawing stage allows for comparison of the third attribute information of multiple versions during the coding process, facilitating timely updates of the third attribute information of multiple versions.

[0271] Table 33

[0272]

[0273] In this embodiment, third attribute information is obtained by processing the second attribute information of the same entity at multiple stages, so that the multiple stages have a unified entity code and a unified sorting method, which facilitates the comparison of entity data of multiple versions of the same entity.

[0274] It should be noted that when publishing integrated data, the computer device, based on the classification of the entity to be published, queries any version of the integrated data whose second data status is "created and approved completed" for the third attribute information. The second data status of this third attribute information is then updated to "data valid," indicating that the third attribute information is valid data after integration, and the third attribute information is then published. For example, see Table 34, where the version number of the third attribute information of the third sequence number is C01, the second data status is "data valid," and the integrated data is being published.

[0275] Table 34

[0276]

[0277]

[0278] See Figure 3 This figure is a flowchart illustrating the data integration method provided in an embodiment of this application. The computer device acquires a database, determines first attribute information based on first sorting information, pre-integration information, and entity data in the database, performs a quality check on the first attribute information, and obtains second attribute information. The second attribute information is then integrated based on processing method information, encoding rule information, unique identifier information, and comparison identifier information to obtain integrated data.

[0279] This application provides a data integration method. The method sorts entity data in a database across multiple stages using first sorting information to obtain first attribute information, thus achieving pre-integration of entity data across multiple stages. It then integrates second attribute information from multiple stages that meets preset conditions to obtain integrated data. The entity data in the integrated data is sorted according to a preset sorting rule, achieving data integration of entity data from the second attribute information across multiple stages. Therefore, when applying entity data, the integrated data allows direct access to entity data based on the sorting rules of multiple stages, thereby improving the efficiency of entity data application.

[0280] This application also provides a data integration device, see [link to relevant documentation] Figure 4 The device includes:

[0281] The first acquisition module 401 is used to acquire the first sorting information of the target project and the database of the target project in multiple stages. The database of each stage includes the entity data of multiple entities of the target project in the stage.

[0282] The first determining module 402 is used to determine the first attribute information of the entity at each stage for each entity based on the first sorting information and the entity data of the entity at each stage. The first sorting information is used to guide the sorting of the entity data in the first attribute information.

[0283] The second determining module 403 is used to screen the first attribute information of the entity at each stage and determine the second attribute information that meets the preset conditions.

[0284] The second acquisition module 404 is used to acquire integrated processing information of an entity at multiple stages. The integrated processing information is used to guide the integration of second attribute information at multiple stages.

[0285] The processing module 405 is used to integrate the second attribute information of multiple stages based on the integrated processing information to obtain integrated data of the entity. The integrated data includes multiple versions of third attribute information. Each version of the third attribute information includes entity data from at least one stage of the second attribute information. The entity data in each version of the third attribute information is sorted according to a preset sorting rule.

[0286] In one possible implementation, the first attribute information also includes the state information of the entity data. The second determining module 403 is used to: determine the target first attribute information whose state information is the first state information from multiple first attribute information; use the target first attribute information as the second attribute information, and the first state information is used to indicate that the first attribute information meets the preset conditions.

[0287] In one possible implementation, the first attribute information also includes a unique identifier for the entity data, stage information, and complete setting information; the preset conditions include a first preset condition and a second preset condition; and the device further includes:

[0288] The first update module is used to update the status information to the first status information for each first attribute information if multiple entities do not include first attribute information that is completely identical to the unique identifier and stage information in the first attribute information in multiple stages, and the complete information is set to be complete. The first status information is used to indicate that the first attribute information meets the first preset condition and meets the second preset condition.

[0289] The second update module is used to update the status information to the second status information for each first attribute information if multiple entities do not include first attribute information that is completely identical to the unique identifier and stage information in the first attribute information in multiple stages, and the set complete information is incomplete. The second status information is used to indicate that the first attribute information meets the first preset condition and does not meet the second preset condition.

[0290] The third update module is used to update the status information to the third status information for each first attribute information. If multiple entities include first attribute information that is completely identical to the unique identifier and stage information in multiple first attribute information in multiple stages, and the complete information is set to be complete, the third status information is used to indicate that the first attribute information does not meet the first preset condition but meets the second preset condition.

[0291] The fourth update module is used to update the status information to the fourth status information for each first attribute information. If multiple entities include first attribute information that is completely identical to the unique identifier and stage information in multiple first attribute information in multiple stages, and the set complete information is incomplete, the fourth status information is used to indicate that the first attribute information does not meet the first preset condition and does not meet the second preset condition.

[0292] In one possible implementation, the multiple stages are multiple stages arranged in chronological order. The integrated processing information includes the sequence information of the multiple stages, the encoded processing information of each stage, and the third attribute information. The entity data in the integrated data is sorted according to a preset sorting rule. The processing module 405 includes:

[0293] The processing unit is used to process the second attribute information of multiple stages sequentially based on the encoding processing information and sequence information of the entity at each stage, so as to obtain multiple versions of fourth attribute information. The entity encoding in the multiple versions of fourth attribute information is the same. The entity encoding is used to represent the entity. Each version of fourth attribute information includes the entity data in the second attribute information of the corresponding stage and the entity data in the second attribute information of each stage before the stage.

[0294] The sorting unit is used to sort the entity data in the fourth attribute information of each version according to a preset sorting rule to obtain the integrated data of the entities. The integrated data includes the third attribute information of multiple versions, and the entity data in the third attribute information of each version is sorted according to the preset sorting rule.

[0295] In one possible implementation, the processing method corresponding to the encoded processing information includes one of creation processing, aggregation processing, temporary storage processing, creation or aggregation processing, creation and association processing, and aggregation and association processing. The encoded processing information is used to guide the processing of entities in the second attribute information, which includes a unique identifier and a reference identifier. The processing unit is used to: if the processing method corresponding to the encoded processing information is creation processing, create entity codes for the entities in the second attribute information to obtain fourth attribute information containing entity codes.

[0296] If the processing method corresponding to the encoded information is aggregation processing, then the target fourth attribute information that matches the unique identifier of the second attribute information is determined from multiple fourth attribute information. The entity of the target fourth attribute information is the same as the entity of the second attribute information. The entity encoding of the target fourth attribute information is assigned to the entity in the second attribute information to obtain the fourth attribute information containing the entity encoding.

[0297] If the processing method corresponding to the encoded information is creation or aggregation processing, and the target fourth attribute information that matches the unique identifier of the second attribute information is not included among the multiple fourth attribute information, then entity encoding is created for the entity in the second attribute information to obtain the fourth attribute information containing the entity encoding.

[0298] If the processing method corresponding to the encoded information is temporary storage, then the second attribute information is stored to obtain the fifth attribute information;

[0299] If the processing method corresponding to the encoded processing information is creation and association processing, then the target fifth attribute information that matches the comparison identifier of the second attribute information is determined. The entity of the target fifth attribute information is the same as the entity of the second attribute information. Entity codes are created for the entities of the second attribute information and the target fifth attribute information, respectively obtaining the fourth attribute information containing the entity code corresponding to the second attribute information and the fourth attribute information containing the entity code corresponding to the target fifth attribute information.

[0300] If the processing method corresponding to the encoded processing information is aggregation and association processing, then the target fifth attribute information that matches the comparison identifier of the second attribute information is determined, the target fourth attribute information that matches the unique identifier of the second attribute information is determined from multiple fourth attribute information, and the entity code of the target fourth attribute information is assigned to the entities of the second attribute information and the target fifth attribute information, respectively obtaining the fourth attribute information containing the entity code corresponding to the second attribute information and the fourth attribute information containing the entity code corresponding to the target fifth attribute information.

[0301] In one possible implementation, the integrated processing information includes encoded processing information. The second acquisition module 404 is used to: acquire second sorting information of the target project; and, based on the second sorting information of the target project and the database of the target project at multiple stages, determine the encoded processing information of each entity at each stage. The second sorting information is used to guide the sorting of the encoded processing data in the encoded processing information.

[0302] Figure 5This illustration shows a structural block diagram of a computer device 500 provided in an exemplary embodiment of this application. The computer device 500 may be a portable mobile computer device, such as a smartphone, tablet computer, MP3 player (Moving Picture Experts Group Audio Layer III), MP4 player (Moving Picture Experts Group Audio Layer IV), laptop computer, or desktop computer. The computer device 500 may also be referred to as a user device, portable computer device, laptop computer device, desktop computer device, or other names.

[0303] Typically, computer device 500 includes a processor 501 and a memory 502.

[0304] Processor 501 may include one or more processing cores, such as a quad-core processor, an octa-core processor, etc. Processor 501 may be implemented using at least one hardware form selected from DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), and PLA (Programmable Logic Array). Processor 501 may also include a main processor and a coprocessor. The main processor, also known as a CPU (Central Processing Unit), is used to process data in the wake-up state; the coprocessor is a low-power processor used to process data in the standby state. In some embodiments, processor 501 may integrate a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content required to be displayed on the screen. In some embodiments, processor 501 may also include an AI (Artificial Intelligence) processor, which is used to handle computational operations related to machine learning.

[0305] Memory 502 may include one or more computer-readable storage media, which may be non-transitory. Memory 502 may also include high-speed random access memory and non-volatile memory, such as one or more disk storage devices or flash memory devices. In some embodiments, the non-transitory computer-readable storage media in memory 502 is used to store at least one instruction, which is executed by processor 501 to implement the data integration method provided in the method embodiments of this application.

[0306] In some embodiments, the computer device 500 may also optionally include a peripheral device interface 503 and at least one peripheral device. The processor 501, memory 502, and peripheral device interface 503 can be connected via a bus or signal line. Each peripheral device can be connected to the peripheral device interface 503 via a bus, signal line, or circuit board. Specifically, the peripheral device includes at least one of the following: a radio frequency circuit 504, a display screen 505, a camera assembly 506, an audio circuit 507, a positioning assembly 508, and a power supply 509.

[0307] Peripheral device interface 503 can be used to connect at least one I / O (Input / Output) related peripheral device to processor 501 and memory 502. In some embodiments, processor 501, memory 502 and peripheral device interface 503 are integrated on the same chip or circuit board; in some other embodiments, any one or two of processor 501, memory 502 and peripheral device interface 503 can be implemented on separate chips or circuit boards, which is not limited in this embodiment.

[0308] The radio frequency (RF) circuit 504 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The RF circuit 504 communicates with communication networks and other communication devices via electromagnetic signals. The RF circuit 504 converts electrical signals into electromagnetic signals for transmission, or converts received electromagnetic signals back into electrical signals. Optionally, the RF circuit 504 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a user identity module card, etc. The RF circuit 504 can communicate with other computer devices through at least one wireless communication protocol. This wireless communication protocol includes, but is not limited to: the World Wide Web, metropolitan area networks, intranets, various generations of mobile communication networks (2G, 3G, 4G, and 5G), wireless local area networks, and / or WiFi (Wireless Fidelity) networks. In some embodiments, the RF circuit 504 may also include circuitry related to NFC (Near Field Communication), which is not limited in this application.

[0309] Display screen 505 is used to display a UI (User Interface). This UI may include graphics, text, icons, videos, and any combination thereof. When display screen 505 is a touch display screen, it also has the ability to collect touch signals on or above its surface. These touch signals can be input as control signals to processor 501 for processing. In this case, display screen 505 can also be used to provide virtual buttons and / or a virtual keyboard, also known as soft buttons and / or a soft keyboard. In some embodiments, there may be one display screen 505, disposed on the front panel of computer device 500; in other embodiments, there may be at least two display screens, disposed on different surfaces of computer device 500 or in a folded design; in still other embodiments, display screen 505 may be a flexible display screen, disposed on a curved or folded surface of computer device 500. Furthermore, display screen 505 may be configured as a non-rectangular irregular shape, i.e., a non-rectangular screen. Display screen 505 may be made of materials such as LCD (Liquid Crystal Display) or OLED (Organic Light-Emitting Diode).

[0310] The camera assembly 506 is used to acquire images or videos. Optionally, the camera assembly 506 includes a front-facing camera and a rear-facing camera. Typically, the front-facing camera is located on the front panel of the computer device, and the rear-facing camera is located on the back of the computer device. In some embodiments, there are at least two rear-facing cameras, which are any one of a main camera, a depth-sensing camera, a wide-angle camera, and a telephoto camera, to achieve background blurring by fusion of the main camera and the depth-sensing camera, panoramic shooting by fusion of the main camera and the wide-angle camera, VR (Virtual Reality) shooting, or other fusion shooting functions. In some embodiments, the camera assembly 506 may also include a flash. The flash can be a single-color temperature flash or a dual-color temperature flash. A dual-color temperature flash is a combination of a warm-light flash and a cool-light flash, which can be used for light compensation at different color temperatures.

[0311] The audio circuit 507 may include a microphone and a speaker. The microphone is used to collect sound waves from the user and the environment, converting the sound waves into electrical signals that are input to the processor 501 for processing, or input to the radio frequency circuit 504 for voice communication. For stereo sound acquisition or noise reduction purposes, multiple microphones may be used, each located in a different part of the computer device 500. The microphone may also be an array microphone or an omnidirectional microphone. The speaker is used to convert the electrical signals from the processor 501 or the radio frequency circuit 504 into sound waves. The speaker may be a conventional diaphragm speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, it can convert electrical signals not only into audible sound waves but also into inaudible sound waves for purposes such as distance measurement. In some embodiments, the audio circuit 507 may also include a headphone jack.

[0312] The positioning component 508 is used to locate the current geographical location of the computer device 500 in order to enable navigation or LBS (Location Based Service). The positioning component 508 can be a positioning component based on the US GPS (Global Positioning System), China's BeiDou system, or Russia's Galileo system.

[0313] Power supply 509 is used to supply power to the various components in computer device 500. Power supply 509 can be AC ​​power, DC power, a disposable battery, or a rechargeable battery. When power supply 509 includes a rechargeable battery, the rechargeable battery can be a wired rechargeable battery or a wireless rechargeable battery. A wired rechargeable battery is a battery that is charged via a wired line, and a wireless rechargeable battery is a battery that is charged via a wireless coil. The rechargeable battery can also be used to support fast charging technology.

[0314] In some embodiments, the computer device 500 further includes one or more sensors 510. The one or more sensors 510 include, but are not limited to: an accelerometer 511, a gyroscope 512, a pressure sensor 513, a fingerprint sensor 514, an optical sensor 515, and a proximity sensor 516.

[0315] Accelerometer 511 can detect the magnitude of acceleration along the three coordinate axes of a coordinate system established by computer device 500. For example, accelerometer 511 can be used to detect the components of gravitational acceleration along the three coordinate axes. Processor 501 can control display screen 505 to display the user interface in either a landscape or portrait view based on the gravitational acceleration signal acquired by accelerometer 511. Accelerometer 511 can also be used for games or for acquiring user motion data.

[0316] The gyroscope sensor 512 can detect the orientation and rotation angle of the computer device 500. The gyroscope sensor 512, in conjunction with the accelerometer sensor 511, can collect 3D motion data from the user on the computer device 500. Based on the data collected by the gyroscope sensor 512, the processor 501 can perform the following functions: motion sensing (e.g., changing the UI based on the user's tilt), image stabilization during shooting, game control, and inertial navigation.

[0317] The pressure sensor 513 can be disposed on the side bezel of the computer device 500 and / or on the lower layer of the display screen 505. When the pressure sensor 513 is disposed on the side bezel of the computer device 500, it can detect the user's grip signal on the computer device 500, and the processor 501 can perform left / right hand recognition or quick operation based on the grip signal collected by the pressure sensor 513. When the pressure sensor 513 is disposed on the lower layer of the display screen 505, the processor 501 can control the operable controls on the UI interface based on the user's pressure operation on the display screen 505. The operable controls include at least one of button controls, scroll bar controls, icon controls, and menu controls.

[0318] The fingerprint sensor 514 is used to collect the user's fingerprint. The processor 501 identifies the user's identity based on the fingerprint collected by the fingerprint sensor 514, or the fingerprint sensor 514 identifies the user's identity based on the collected fingerprint. When the user's identity is identified as trusted, the processor 501 authorizes the user to perform relevant sensitive operations, including unlocking the screen, viewing encrypted information, downloading software, making payments, and changing settings. The fingerprint sensor 514 can be located on the front, back, or side of the computer device 500. When the computer device 500 has physical buttons or a manufacturer's logo, the fingerprint sensor 514 can be integrated with the physical buttons or manufacturer's logo.

[0319] An optical sensor 515 is used to collect ambient light intensity. In one embodiment, the processor 501 can control the display brightness of the display screen 505 based on the ambient light intensity collected by the optical sensor 515. Specifically, when the ambient light intensity is high, the display brightness of the display screen 505 is increased; when the ambient light intensity is low, the display brightness of the display screen 505 is decreased. In another embodiment, the processor 501 can also dynamically adjust the shooting parameters of the camera assembly 506 based on the ambient light intensity collected by the optical sensor 515.

[0320] The proximity sensor 516, also known as a distance sensor, is typically located on the front panel of the computer device 500. The proximity sensor 516 is used to detect the distance between the user and the front of the computer device 500. In one embodiment, when the proximity sensor 516 detects that the distance between the user and the front of the computer device 500 is gradually decreasing, the processor 501 controls the display screen 505 to switch from a screen-on state to a screen-off state; when the proximity sensor 516 detects that the distance between the user and the front of the computer device 500 is gradually increasing, the processor 501 controls the display screen 505 to switch from a screen-off state to a screen-on state.

[0321] Those skilled in the art will understand that Figure 5 The structure shown does not constitute a limitation on the computer device 500, and may include more or fewer components than shown, or combine certain components, or use different component arrangements.

[0322] This application also provides a computer-readable storage medium storing at least one instruction, which is loaded and executed by a processor to implement the operation performed by the data integration method of any of the above implementations.

[0323] This application also provides a computer program product or computer program, which includes computer program code stored in a computer-readable storage medium. The processor of a computer device reads the computer program code from the computer-readable storage medium and executes the computer program code, causing the computer device to perform the operations described above by the data integration method.

[0324] In some embodiments, the computer program involved in the present application embodiments may be deployed and executed on a computer device, or executed on multiple computer devices located in one location, or executed on multiple computer devices distributed in multiple locations and interconnected through a communication network. Multiple computer devices distributed in multiple locations and interconnected through a communication network may constitute a blockchain system.

[0325] This application provides a data integration method. The method sorts entity data in a database across multiple stages using first sorting information to obtain first attribute information, thus achieving pre-integration of entity data across multiple stages. It then integrates second attribute information from multiple stages that meets preset conditions to obtain integrated data. The entity data in the integrated data is sorted according to a preset sorting rule, achieving data integration of entity data from the second attribute information across multiple stages. Therefore, when applying entity data, the integrated data allows direct access to entity data based on the sorting rules of multiple stages, thereby improving the efficiency of entity data application.

[0326] The above are merely optional embodiments of this application and are not intended to limit this application. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the protection scope of this application.

Claims

1. A data integration method, characterized in that, The method includes: Obtain first sorting information of the target project and a database of the target project in multiple stages. The database of each stage includes entity data of multiple entities of the target project in that stage. The target project is a construction project, the multiple stages are multiple stages during the construction of the target project, the multiple entities include equipment entities and facility entities, and the entity data of each entity includes data for representing the attributes of the entity. For each entity, based on the first sorting information and the entity data of the entity at each stage, the first attribute information of the entity at each stage is determined, and the first sorting information is used to guide the sorting of the entity data in the first attribute information; The first attribute information of the entity at each stage is screened to determine the second attribute information that meets the preset conditions; The entity is obtained through integrated processing information at multiple stages, which is used to guide the integration of second attribute information at the multiple stages. Based on the integrated processing information, the second attribute information of the multiple stages is integrated to obtain the integrated data of the entity. The integrated data includes multiple versions of third attribute information. Each version of the third attribute information includes entity data from at least one stage of the second attribute information. The entity data in each version of the third attribute information is sorted according to a preset sorting rule. The version is used to mark the update status of the third attribute information generated by the integrated processing of the second attribute information of different stages. Wherein, the multiple stages are multiple stages arranged in chronological order, and the integrated processing information includes the sequence information of the multiple stages, the encoding processing information of each stage, and the entity data of the third attribute information in the integrated data according to a preset sorting rule. The step of integrating the second attribute information of the multiple stages based on the integrated processing information to obtain the integrated data of the entity includes: Based on the entity's encoding processing information at each stage and the sequence information, the second attribute information of the multiple stages is processed sequentially to obtain multiple versions of fourth attribute information. The entity encoding in the multiple versions of fourth attribute information is the same. The entity encoding is used to represent the entity. Each version of fourth attribute information includes entity data in the second attribute information of the corresponding stage and entity data in the second attribute information of each stage before the stage. The entity data in the fourth attribute information of each version is sorted according to the preset sorting rules to obtain the integrated data of the entity.

2. The data integration method according to claim 1, characterized in that, The first attribute information also includes the status information of the entity data. The step of screening the first attribute information of the entity at each stage to determine the second attribute information that meets preset conditions includes: From multiple first attribute information, determine the target first attribute information whose state information is the first state information; The target first attribute information is used as the second attribute information, and the first status information is used to indicate that the first attribute information meets the preset conditions.

3. The data integration method according to claim 2, characterized in that, The first attribute information also includes the unique identifier of the entity data, stage information, and complete setting information. The preset conditions include a first preset condition and a second preset condition. The method further includes: For each first attribute information, if the plurality of entities do not include any first attribute information that is completely identical to the unique identifier and stage information in the plurality of first attribute information in the plurality of stages, and the set complete information is complete, then the status information is updated to first status information, and the first status information is used to indicate that the first attribute information meets the first preset condition and meets the second preset condition. For each first attribute information, if the plurality of entities do not include first attribute information that is completely identical to the unique identifier and stage information in the plurality of first attribute information in the plurality of stages, and the set complete information is incomplete, then the status information is updated to second status information, the second status information being used to indicate that the first attribute information meets the first preset condition and does not meet the second preset condition. For each first attribute information, if the plurality of entities include first attribute information that is completely identical to the unique identifier and stage information in the plurality of first attribute information in the plurality of stages, and the set complete information is complete, then the status information is updated to third status information, the third status information being used to indicate that the first attribute information does not meet the first preset condition and meets the second preset condition; For each first attribute information, if the plurality of entities include first attribute information that is completely identical to the unique identifier and stage information in the plurality of first attribute information in the plurality of stages, and the set complete information is incomplete, then the status information is updated to fourth status information, the fourth status information being used to indicate that the first attribute information does not meet the first preset condition and does not meet the second preset condition.

4. The data integration method according to claim 1, characterized in that, The processing method corresponding to the encoded processing information includes one of the following: creation processing, collection processing, temporary storage processing, creation or collection processing, creation and association processing, and collection and association processing. The encoded processing information is used to guide the processing of entities in the second attribute information, which includes a unique identifier and a reference identifier. Based on the entity's encoding processing information at each stage and the sequence information, the second attribute information of the multiple stages is processed sequentially to obtain multiple versions of fourth attribute information, including: If the processing method corresponding to the encoded processing information is creation processing, then entity encoding is created for the entity in the second attribute information to obtain fourth attribute information containing entity encoding; If the processing method corresponding to the encoded processing information is aggregation processing, then the target fourth attribute information that matches the unique identifier of the second attribute information is determined from multiple fourth attribute information. The entity of the target fourth attribute information is the same as the entity of the second attribute information. The entity encoding of the target fourth attribute information is assigned to the entity in the second attribute information to obtain fourth attribute information containing entity encoding. If the processing method corresponding to the encoded processing information is creation or collection processing, and the multiple fourth attribute information does not include target fourth attribute information that matches the unique identifier of the second attribute information, then entity encoding is created for the entity in the second attribute information to obtain fourth attribute information containing entity encoding. If the processing method corresponding to the encoded processing information is temporary storage processing, then the second attribute information is stored to obtain the fifth attribute information; If the processing method corresponding to the encoded processing information is creation and association processing, then the target fifth attribute information that matches the comparison identifier of the second attribute information is determined. The entity of the target fifth attribute information is the same as the entity of the second attribute information. Entity codes are created for the entities of the second attribute information and the target fifth attribute information, respectively obtaining the fourth attribute information containing the entity code corresponding to the second attribute information and the fourth attribute information containing the entity code corresponding to the target fifth attribute information. If the processing method corresponding to the encoded processing information is aggregation and association processing, then the target fifth attribute information that matches the comparison identifier of the second attribute information is determined, the target fourth attribute information that matches the unique identifier of the second attribute information is determined from the plurality of fourth attribute information, and the entity encoding of the target fourth attribute information is assigned to the entities of the second attribute information and the target fifth attribute information, respectively obtaining the fourth attribute information containing the entity encoding corresponding to the second attribute information and the fourth attribute information containing the entity encoding corresponding to the target fifth attribute information.

5. The data integration method according to claim 1, characterized in that, The integrated processing information includes encoded processing information, and obtaining the integrated processing information of the entity at multiple stages includes: Obtain the second sorting information of the target project; Based on the second sorting information of the target project and the database of the target project at multiple stages, the encoding processing information of each entity at each stage is determined, wherein the second sorting information is used to guide the sorting of the encoding processing data in the encoding processing information.

6. A data integration device, characterized in that, The device includes: The first acquisition module is used to acquire the first sorting information of the target project and the database of the target project in multiple stages. The database of each stage includes the entity data of multiple entities of the target project in that stage. The target project is a construction project, the multiple stages are multiple stages during the construction of the target project, the multiple entities include equipment entities and facility entities, and the entity data of each entity includes data for representing the attributes of the entity. The first determining module is used to determine, for each entity, first attribute information of the entity at each stage based on the first sorting information and the entity data of the entity at each stage, wherein the first sorting information is used to guide the sorting of the entity data in the first attribute information; The second determining module is used to screen the first attribute information of the entity at each stage and determine the second attribute information that meets the preset conditions. The second acquisition module is used to acquire integrated processing information of the entity at multiple stages, and the integrated processing information is used to guide the integration of the second attribute information at the multiple stages. The processing module is used to integrate the second attribute information of the multiple stages based on the integrated processing information to obtain the integrated data of the entity. The integrated data includes multiple versions of third attribute information. Each version of the third attribute information includes entity data from at least one stage of the second attribute information. The entity data in each version of the third attribute information is sorted according to a preset sorting rule. The version is used to mark the update status of the third attribute information generated by the integrated processing of the second attribute information of different stages. Wherein, the multiple stages are multiple stages arranged in chronological order, and the integrated processing information includes the sequence information of the multiple stages, the encoded processing information of each stage, and the entity data of the third attribute information in the integrated data according to a preset sorting rule. The processing module is used for: Based on the entity's encoding processing information at each stage and the sequence information, the second attribute information of the multiple stages is processed sequentially to obtain multiple versions of fourth attribute information. The entity encoding in the multiple versions of fourth attribute information is the same. The entity encoding is used to represent the entity. Each version of fourth attribute information includes entity data in the second attribute information of the corresponding stage and entity data in the second attribute information of each stage before the stage. The entity data in the fourth attribute information of each version is sorted according to the preset sorting rules to obtain the integrated data of the entity.

7. The apparatus according to claim 6, characterized in that, The first attribute information also includes the status information of the entity data. The second determining module is used for: From multiple first attribute information, determine the target first attribute information as the first state information; use the target first attribute information as the second attribute information, and use the first state information to indicate that the first attribute information meets the preset conditions.

8. A computer device, characterized in that, The computer device includes one or more processors and one or more memories, wherein at least one instruction is stored in the one or more memories, and the at least one instruction is loaded and executed by the one or more processors to perform the operation performed by the data integration method as described in any one of claims 1 to 5.

9. A computer-readable storage medium, characterized in that, The storage medium stores at least one instruction, which is loaded and executed by a processor to perform the operation of the data integration method as described in any one of claims 1 to 5.

Images