CN110825740B - Method, device, terminal or server for associating data with model - Google Patents
Method, device, terminal or server for associating data with model Download PDFInfo
- Publication number
- CN110825740B CN110825740B CN201911047216.2A CN201911047216A CN110825740B CN 110825740 B CN110825740 B CN 110825740B CN 201911047216 A CN201911047216 A CN 201911047216A CN 110825740 B CN110825740 B CN 110825740B
- Authority
- CN
- China
- Prior art keywords
- field
- description
- name
- point location
- point
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method, a device, a terminal or a server for associating data with a model. The method comprises the steps of obtaining a point position table of data from an internet of things database, and determining a point position name/description list from the point position table; determining a main body type field, a parameter type field and an instance sequence number field in each point name/description field in the point name/description list; correspondingly matching the main body type field in the point position name/description field with the name of a model object in the building information model BIM; based on the matching result of the main body type, the parameter type field and the instance serial number field in each point name/description field are respectively matched with the parameter type and the instance serial number of the model object in the BIM. The method reduces the workload, ensures that the on-line data acquired by the Internet of things is synchronous with the off-line data in the BIM model, saves labor and improves the matching efficiency.
Description
Technical Field
The embodiment of the invention relates to a data and model association technology, in particular to a method, a device, a terminal or a server for associating data with a model.
Background
Building information models (Building Information Modeling, BIM) continue to extend from building design and construction to building operation and maintenance management, which tends to require the problem of fusing the BIM with the vast number of intelligent systems existing in the building, i.e., thousands of internet of things data points existing in the building need to be associated with model objects such as equipment or space in the BIM.
In most of the existing processes, engineers usually adopt Excel-table-based work to make point table editing and then upload the point table to a background database, or adopt single-point configuration editing, that is, the existing data table of data points and databases is respectively corresponding to model objects such as equipment or space in a BIM model through a computer visual interface.
The Excel table editing method is high in flexibility, but for most field engineers, some advanced editing functions in an Excel tool can not be mastered, and only single-point editing can be performed one by one, so that the final working efficiency is not high; second, automatic conversion of the data format sometimes occurs in an Excel tool, for example, the original data is a string of numbers "0123", but the format is character-type, and the format is imported into Excel to be converted into number 123 by default, and the easy change of the format leads to errors in subsequent form processing and data storage; in addition, the working mode is difficult to break off the situation of editing management data off line, so that the problem that data in a cloud database and data of an off-line document are not synchronous is brought; because of human misoperation, data asynchronous errors are extremely easy to generate.
The single-point configuration editing method is huge in workload, for example, a public building with 10 ten thousand square meters, the number of points can reach 3 ten thousand, the number of devices can reach 4 thousand, 3 ten thousand points are respectively corresponding to 4 thousand devices, the workload is huge, errors are easy to occur, and the inspection is difficult after the errors occur, so that the overall engineering efficiency is extremely low.
Disclosure of Invention
The invention provides a method, a device, a terminal or a server for associating data with a model, which can reduce workload, ensure that online data acquired by the Internet of things is synchronous with offline data in a BIM model, save manpower and improve matching efficiency.
In a first aspect, an embodiment of the present invention provides a method for associating data with a model, the method including: acquiring a point location table of data from an internet of things database, and determining a point location name/description list from the point location table; determining a main body type field, a parameter type field and an instance sequence number field in each point name/description field in the point name/description list; correspondingly matching the main body type field in the point position name/description field with the name of a model object in the building information model BIM; and based on a matching result of the main body type, correspondingly matching the parameter type field and the instance sequence number field in the point name/description field of each item with the parameter type and the instance sequence number of the model object of one type in the BIM.
In a second aspect, an embodiment of the present invention provides an apparatus for associating data with a model, the apparatus including: the system comprises a point location name/description list determining module, a point location name/description list determining module and a point location processing module, wherein the point location name/description list determining module is used for acquiring a point location list of data from an internet database and determining the point location name/description list from the point location list; the main body type field, the parameter type field and the instance sequence number field determining module is used for determining a main body type field, a parameter type field and an instance sequence number field in each point location name/description field in the point location name/description list; the first matching module is used for correspondingly matching the main body type field in the point location name/description field with the name of a model object in the building information model BIM; and the second matching module is used for correspondingly matching the parameter type field and the instance sequence number field in the point location name/description field of each item with the parameter type and the instance sequence number of one type of model object in the BIM respectively based on the matching result of the main body type.
In a third aspect, an embodiment of the present invention provides a data and model association apparatus, including:
one or more processors;
storage means for storing one or more programs,
The one or more programs, when executed by the one or more processors, cause the one or more processors to implement a method of associating data with a model as described in any embodiment of the present invention.
In a fourth aspect, embodiments of the present invention provide a computer readable storage medium having stored thereon a computer program which when executed by a processor implements a method for associating data with a model according to any embodiment of the present invention.
According to the embodiment of the invention, the point location list of the data is obtained from the internet of things database, and the point location name/description list is determined from the point location list; determining a main body type field, a parameter type field and an instance sequence number field in each point name/description field in the point name/description list; the main body type field in each point position name/description field and the name of a model object in the building information model BIM; based on the matching result of the main body type, the parameter type field and the instance sequence number field in each point location name/description field are respectively matched with the parameter type and the instance sequence number of one type of model object in the BIM, namely, the main body type field, the parameter type field and the instance sequence number field in the point location name/description field in the point location table of the data in the database of the Internet of things are respectively matched with the name, the parameter type and the instance sequence number of one type of model object in the BIM, so that the problem that the existing Internet of things data in the building is associated with the model object such as equipment or space in the BIM is solved, and the effects of reducing the workload, guaranteeing the synchronization of the online data acquired by the Internet of things and the offline data in the BIM are achieved, saving labor and improving the matching efficiency are achieved.
Drawings
FIG. 1 is a flow chart of a method for associating data with a model according to a first embodiment of the present invention;
FIG. 2 is a schematic diagram of a dot bit table according to an embodiment of the present invention;
FIG. 3 is a flow chart for determining a feature field of each point name/description field in a point name/description list according to an embodiment of the present invention;
FIG. 4 is a flow chart of determining a feature field of each of the point name/description fields in the point name/description list provided by an embodiment of the present invention;
FIG. 5 is a flow chart of a method for associating data with a model according to a second embodiment of the present invention;
FIG. 6 is a schematic structural diagram of an apparatus for associating data with a model according to a third embodiment of the present invention;
fig. 7 is a schematic structural diagram of a terminal or a server according to a fourth embodiment of the present invention.
Detailed Description
The invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.
Example 1
Fig. 1 is a flowchart of a method for associating data with a model, where the method may be applicable to a case where data of the internet of things is associated with a model object, such as a device or a space, in a BIM model, and the method may be performed by an apparatus for associating data with a model, where the apparatus may be implemented by software and/or hardware, and the apparatus may be integrated in a processor in a computer, as shown in fig. 1, and the method specifically includes:
S110, acquiring a point position table of data from an internet of things database, and determining a point position name/description list from the point position table;
fig. 2 is a schematic diagram of a dot bit table according to an embodiment of the present invention. As shown in FIG. 2, the point bit table may be obtained from an internet of things database or may be obtained by interfacing with a vendor or an embodiment of the intelligent system. The dot bit table can comprise dot bit description information according to the field implementation condition. By way of example, the point location Description information may include a point location name/Description (Description), such as "1# chiller chilled water supply temperature"; a point Data Type (Data Type), e.g., bool, int, double, str, etc.; a value description (not shown in fig. 2), for example, 0 is "off" and 1 is "on"; physical units (not shown in FIG. 2), such as, for example, C, m3/h, MPa, etc., and point location communication addresses, etc.
In one implementation of the embodiment of the present invention, optionally, determining the point name/description list from the point table may include: determining point location description information from a point location table; a list of point names/descriptions is determined from the point description information.
As shown in fig. 2, the point Description information may be determined from the point table, and the point Description information is extracted as a column of a point name/Description (Description), so as to generate a point name/Description list. The point location name/description list comprises a plurality of point location name/description fields, and each point location name/description field can correspond to the data of the internet of things. For example, the point name/description field may correspond to the data of the internet of things, such as a point communication address, a point value, a point data type, a value description, and a physical unit. For example, the point name/description field is "1# cooling pump start sequence", and the corresponding internet of things data may be a point communication address of "17", a point value of "3.000000", and a point data type of "Float".
S120, determining a main body type field, a parameter type field and an instance sequence number field in each point location name/description field in the point location name/description list;
wherein each of the point name/description fields may be composed of a body type field, a parameter type field, and an instance sequence number field. The body type field may be the name of equipment or space used in engineering practice, e.g., a chiller, a cryopump, or a cooling tower, etc.; the parameter type field may be a data type required by the device or space, for example, a start-up sequence, a difference between a water supply temperature and a set value, a water supply and return temperature difference, a water supply and return pressure difference, a water return temperature setting, a load demand, a number of stations, a water return flow rate, or the like; the instance number may represent a device or space number, and may be composed of a positive integer and a set symbol, e.g., 1#, 2#, 3#, etc. For example, the point location name/description field is "1# water chiller chilled water supply temperature", the main body type field is "water chiller", the parameter type field is "chilled water supply temperature", and the example serial number field is "1#".
In one implementation of the embodiment of the present invention, optionally, determining a body type field, a parameter type field, and an instance sequence number field of each of the point name/description fields in the point name/description list includes: acquiring a current appointed characteristic field, wherein the appointed characteristic field comprises an appointed main body type field, an appointed parameter type field or an appointed instance sequence number field; checking whether each point name/description field contains a current specified feature field; if yes, judging whether a characteristic field in each point location name/description field is empty, wherein the characteristic field comprises a main body type field, a parameter type field or an instance sequence number field; if the appointed characteristic field of each point name/description field is not null, covering the non-null appointed characteristic field by adopting the current appointed characteristic field; and if the characteristic field of each point location name/description field is null, taking the current appointed characteristic field as the characteristic field of the point location name/description field.
Wherein, optionally, the specified body type field comprises at least one of a chiller, a cryopump, a cooling tower, cooling water or chilled water; the appointed parameter type field comprises at least one of the difference between the water supply temperature and the set value, the water supply and return temperature difference, the water supply and return pressure difference, the water return temperature setting, the load demand, the number of stations, the water return flow or the starting sequence; the specific instance number field refers to a field composed of a positive integer and a set symbol.
Specifically, the current specified feature field may be specified as a specified body type field, and whether each point name/description field contains the current specified body type field is checked. If so, judging whether the main body type field in each point name/description field is empty; if not, covering the non-empty subject type field with the current specified subject type field; if empty, the current designated subject type field is taken as the subject type field of the point name/description field. If not, the body type field of the entry point name/description field may be left unchanged.
It should be noted that, the current specified feature field is a main body type field, where the specified main body type field may be one or more of a water chiller, a cryopump, a cooling tower, cooling water or chilled water; after the main body type field in each point name/description field in the point name/description list is checked, the next main body type field can be designated as the current designated main body type field, and whether each point name/description field contains the current designated main body type field is checked again until all preset main body type fields are designated.
For example, the point location name/description list includes "1# chiller chilled water supply temperature" and "chiller cooling tower number required" 2 point location name/description fields. If the current appointed main body type field is designated as a 'water chilling unit', the main body type field of the '1 # water chilling unit freezing water supply temperature' is designated as a 'water chilling unit'; while the body type field of "number of cooling towers required" remains unchanged. At this time, if the current designated body type field is designated as "chiller", the body type field of "1# chiller chilled water supply temperature" remains unchanged, i.e. "chiller", and the body type field of "chiller required number of cooling towers" is "chiller". If the current designated body type field is designated as a cooling tower, the body type field of the cooling water supply temperature of the No. 1 water chiller is kept unchanged, namely the cooling water chiller, and the body type field of the cooling tower number required by the cooling machine is covered with the cooling tower. This process may be repeated until all of the preset specified body type fields have been specified, or the body type field of each point name/description field is not empty.
In the embodiment of the invention, the current appointed characteristic field can be appointed as the appointed parameter type field, and whether each point location name/description field contains the current appointed parameter type field or not is checked. If so, judging whether the parameter type field in each point name/description field is empty; if not, covering the non-empty parameter type field with the current appointed parameter type field; if the parameter type field is empty, the current appointed parameter type field is taken as a parameter type field of the point name/description field. If not, the parameter type field of the entry point name/description field may be left unchanged.
It should be noted that, when the current specified parameter type field is set, the specified parameter type field may include one or more of a difference between the water supply temperature and the set value, a water supply and return temperature difference, a water supply and return pressure difference, a water return temperature setting, a load demand, a number of pieces, a water return flow rate, or a start sequence; after the parameter type field in each point name/description field in the point name/description list is checked, the next appointed parameter type field can be appointed as the current appointed parameter type field, and whether the appointed parameter type field is contained in each point name/description field is checked again until all preset appointed parameter type fields are appointed.
For example, the point location name/description list includes "the number of cooling tower required for cooling machines" and "1# cooling pump start sequence" 2 point location name/description fields. If the currently specified parameter type field is designated as "start-up sequence", the parameter type field of "1# cooling pump start-up sequence" is designated as "start-up sequence", and the parameter type field of "number of cooling towers required for cooling machine" remains unchanged. If the current designated parameter type field is designated as "number of stages", the parameter type field of "number of cooling tower required for chiller" is designated as "number of stages", and the parameter type field of "1# cooling pump start-up sequence" remains unchanged, i.e. "start-up sequence". This process may be repeated until all of the preset specified parameter type fields have been specified, or the parameter type field of each of the point name/description fields is not empty.
In the embodiment of the invention, the current appointed characteristic field can be appointed as the appointed example serial number field, and whether each point location name/description field contains the current appointed example serial number field or not is checked. If so, judging whether an instance sequence number field in each point name/description field is empty; if not, covering the non-empty instance sequence number field with the current appointed instance sequence number field; if the current appointed instance number field is empty, the instance number field of the point name/description field is used as the instance number field of the point name/description field. If not, the instance sequence number field of the entry point name/description field may be left unchanged.
It should be noted that, when the current specified instance sequence number field is referred to, the specified instance sequence number field may refer to a field formed by a positive integer and a set symbol; after the example serial number field in each point name/description field in the point name/description list is checked, the next appointed example serial number field can be appointed as the current appointed example serial number field, and whether the appointed example serial number field is contained in each point name/description field is checked again until all preset appointed example serial number fields are appointed.
For example, the list of point names/descriptions includes a "1# cooling pump start sequence" and a "2# cooling pump start sequence" 2 item point name/description field. If the currently specified instance number field is designated as "1#", then the instance number field of "1# cooling pump start sequence" is "1#", while the instance number field of "2# cooling pump start sequence" remains unchanged. If the currently specified instance number field is designated as "2#", then the instance number field of "1# cooling pump start sequence" remains unchanged, i.e., "1#", while the instance number field of "2# cooling pump start sequence" is "2#". This process may be repeated until all of the preset specified instance number fields have been specified, or the instance number field of each point name/description field is not empty.
It should be further noted that, the determination process of the main body type field, the parameter type field and the instance sequence number field of each point name/description field in the point name/description list may be performed simultaneously or separately, but the sequence is not specifically limited by the present invention.
In one implementation manner of the embodiment of the present invention, optionally, when a local adjustment instruction is received, it is determined whether the main body type field, the parameter type field and the instance sequence number field in each point name/description field are respectively matched with the history adjustment records of the specified main body type field, the specified parameter type field and the specified instance sequence number field; if not, replacing the corresponding unmatched items in the point name/description field with the appointed main body type field, the appointed parameter type field or the appointed instance serial number field of the history adjustment record.
After the main body type field, the parameter type field and the instance sequence number field of each point name/description field in the point name/description list are determined, a local adjustment instruction may be received, and local adjustment is performed on the main body type field, the parameter type field and the instance sequence number field of the point name/description field, so that the main body type field, the parameter type field and the instance sequence number field of the determined point name/description field are correct. The history adjustment record may be a specified body type field, a specified parameter type field, and a specified instance number field, which have been adjusted or are prone to error. For example, the point location name/description field is "number of cooling towers required for cooling" and when the current specified main body type field is "cooling", the main body type field is "cooling"; and when the currently specified body type field is re-specified as "cooling tower", its body type is covered as "cooling tower". However, in reality, the body type field of "number of cooling towers required for cooling" is "cooling". At this time, the designated body type field "chiller" may be taken as one of the history adjustment records. And judging that the main body type field in the 'cooling tower required number' is not matched with the 'cooling machine' in the history adjustment record, and replacing the main body type field in the 'cooling tower required number' with the 'cooling machine'.
Fig. 3 is a flowchart of determining a feature field of each point name/description field in the point name/description list according to an embodiment of the present invention. As shown in fig. 3, a point name/description list may be acquired first, where the point name/description list may have multiple point name/description fields; the current specified feature field may then be specified, which may include a specified body type field, a specified parameter type field, and a specified instance sequence number field; it may be checked whether each point name/description field contains a current specified feature field; if yes, judging whether a characteristic field in each point location name/description field is empty, wherein the characteristic field comprises a main body type field, a parameter type field or an instance sequence number field; if each point name/description field is not null, covering the non-null feature field by adopting the current appointed feature field; if each point location name/description field is empty, taking the current appointed characteristic field as the characteristic field of the point location name/description field; if the point name/description field does not contain the current appointed characteristic field, the characteristic field of the point name/description field is kept unchanged. When the current specified feature field is checked, the next specified feature field can be specified as the current specified feature field until all the specified feature fields are specified. After the main body type field, the parameter type field and the instance serial number field of each point name/description field in the point name/description list are determined, a local adjustment instruction may be received, and local adjustment may be performed on the main body type field, the parameter type field and the instance serial number field of the point name/description field, so that the main body type field, the parameter type field and the instance serial number field of the determined point name/description field are correct.
A flowchart for determining the body type field, the parameter type field, and the instance sequence number field of each of the point name/description fields in the point name/description list may refer to fig. 4. Fig. 4 is a flowchart for determining a feature field of each point name/description field in a point name/description list according to an embodiment of the present invention. As shown in fig. 4, the current specified feature field str may be specified to sequentially retrieve all the point name/description fields Li in the point name/description list { Li }. Judging whether str is contained in Li, if not, judging the next Li, and if so, judging whether the characteristic field of Li is empty; if str is empty as the characteristic field of Li, if str is not empty, the other specified characteristic fields already existing in Li are covered. As shown in fig. 4, after the characteristic field of Li in { Li } is determined, a local adjustment instruction may be received, and local adjustment may be performed on the characteristic field of Li, so that the determined characteristic field of Li is correct. Local adjustment may also be performed only for the point name/description field where the feature field is covered. The workload can be reduced, and the feature field determination of the point location name/description field can be quickly realized.
S130, correspondingly matching the main body type field in each point position name/description field with the name of a model object in the building information model BIM.
The main body type field in the point location name/description field is correspondingly matched with the name of a model object in the building information model BIM, so that each point location name/description field can be conveniently associated with the corresponding model object in the BIM. The model object of one type can be an equipment family or a space class, and the method and the device are applicable to matching of the equipment family or the space class in the BIM model and the data of the Internet of things. The device family may be a plurality of devices of the same type, and as an example, a plurality of centrifugal chillers exist in the BIM model, all centrifugal chillers may be referred to as a device family named as a centrifugal chiller, belong to a model object, and a main body type field "chiller set" may be correspondingly matched with all centrifugal chillers named as centrifugal chillers in the BIM model. The spatial class may be multiple spaces of the same type, which may be objects of a non-equipment family in the BIM model having spatial dimensions, such as rooms, lagoons, etc. For example, there are multiple pits in the BIM model, all of which may be referred to as a spatial class named "pit", belonging to a class of model objects, and the body type field "pit" may be correspondingly matched with all of the pits named "pits" in the BIM model. For a class of model objects in the BIM model, which can be equipment families or space classes, the method of the embodiment of the invention can be adopted to realize the association with the data of the Internet of things.
And S140, based on a matching result of the main body type, correspondingly matching the parameter type field and the instance serial number field in each point name/description field with the parameter type and the instance serial number of the model object in the BIM.
The matching of the main body type can be realized, and the main body type field in the point location name/description field is correspondingly matched with the name of the model object of the type in the BIM. Based on the result, the parameter type field and the instance sequence number field in the point name/description field are respectively matched with the parameter type and the instance sequence number of the model object in the BIM, namely, the matched model object in the class such as the equipment family or the space class in a certain class. It may be convenient to implement that each point name/description field may be associated with a matching item of a corresponding certain device or space in the BIM model, respectively, where the matching item may be formed by a name, a parameter type, and an instance sequence number of a class of model objects in the BIM model. For example, a model object is a device family of a certain class, and a main body type field 'water chiller' can be correspondingly matched with a device family 'centrifugal chiller' in the BIM model; correspondingly matching the parameter type field 'chilled water supply temperature' with the parameter type 'CHW-Temp' corresponding to the equipment family named 'centrifugal chiller' in the BIM model; and correspondingly matching the instance serial number field '1#' with an instance serial number 'CH 01' corresponding to the equipment family named 'centrifugal chiller' in the BIM model. The model object is a space class of a certain class, and the main body type field 'sewage pit' can be correspondingly matched with the space class 'sewage pit' in the BIM model; correspondingly matching the parameter type field Water temperature with the parameter type Water-Temp corresponding to the space class named as the sewage pit in the BIM model; and correspondingly matching the instance serial number field '1#' with the instance serial number 'WW 01' corresponding to the space class named 'sump' in the BIM model. The matching of the main body type field and the name is before, the matching of the parameter type field and the parameter type is after, and the matching of the parameter type field and the parameter type is not after, and the matching of the example serial number field and the example serial number is not consecutive. The matching can be that all fields adopt dictionary searching, maximum probability segmentation, hidden Markov model, viterbi algorithm and the like to carry out word segmentation operation to generate keywords; generating a word segmentation dictionary by using the numbers and the keywords; and respectively replacing the two fields with a number combination, and judging the number of codes of the first field in the second field and the total number of codes of the second field in the two fields to be matched, wherein the ratio of the two fields is the similarity. The two fields with the highest similarity degree can be selected for matching. At this time, the "1# chiller chilled water supply temperature" of the point location name/description field can be associated with the "CHW-Temp" matching item of the centrifugal chiller with the instance serial number "CH01" in the BIM model; the point name/description field "1# sump Water temperature" may be associated with the "Water-Temp" match for the sump with instance number "WW01" in the BIM model.
One use process of the embodiment of the invention may be: for a point location table obtained from an internet of things database or a supplier or an implementation party of an intelligent system, the point location description information contained in the point location table can be obtained, and the point location name/description can be obtained from the point location description information; the corresponding column of the point name/description in the point table can be extracted to generate a point name/description list. The point name/description list includes a plurality of point name/description fields, for example, the point name/description fields are: "1# chiller chilled water supply temperature". The body type field, the parameter type field, and the instance sequence number of the point name/description field can be determined by the above-described feature field determination method of the point name/description field. The main body type of the '1 # water chiller refrigeration water supply temperature' can be determined as a 'water chiller', and the parameter types are respectively as follows: "chilled Water supply temperature", example number "1#". The main body type field 'chiller' is correspondingly matched with the name 'centrifugal chiller' of a model object of a type in the BIM; the parameter type field 'chilled water supply temperature' is correspondingly matched with the parameter type 'CHW-Temp' of a model object in the BIM model; and the instance serial number field '1#' is correspondingly matched with the instance serial number 'CH 01' of one type of model object in the BIM model. At this time, the "1# chiller chilled water supply temperature" of the point name/description field may be associated with the "CHW-Temp" matching item of the centrifugal chiller with the instance number "CH01" in the BIM model. The Internet of things data corresponding to the point name/description field '1 # water chiller refrigerating water supply temperature' can be conveniently used as the data of 'CHW-Temp' of the centrifugal chiller with the example serial number of 'CH 01' in the BIM model.
According to the embodiment of the invention, the point location list of the data is obtained from the internet of things database, and the point location name/description list is determined from the point location list; determining a main body type field, a parameter type field and an instance sequence number field in each point name/description field in the point name/description list; the main body type field, the parameter type field and the instance sequence number field in each point name/description field are respectively matched with the names, the parameter types and the instance sequence numbers of a class of model objects in the building information model BIM, so that the problem that existing Internet of things data in a building are associated with model objects such as equipment or space in the BIM is solved, massive point name/description fields can be grouped according to three dimensions of the main body type field, the parameter type field and the instance sequence number field, and the original N point name/description fields are disassembled into N=J×K×L fields; the matching work grouping of the point location name/description field and the matching item of the model object in the BIM model is carried out, N workloads are reduced to J+K+L workloads, the total workload can be greatly reduced, the online and offline data synchronization is ensured, the labor is saved, and the point location table of the data is quickly matched with the matching item of the model object in the BIM model such as equipment or space.
Example two
Fig. 5 is a flowchart of a method for associating data with a model according to a second embodiment of the present invention. As shown in fig. 5, the method specifically includes:
s210, acquiring a point location table of data from an internet of things database, and determining a point location name/description list from the point location table;
s220, determining a main body type field, a parameter type field and an instance sequence number field in each point location name/description field in the point location name/description list;
s230, correspondingly matching the main body type field in each point position name/description field with the name of a model object in the building information model BIM;
s240, based on a matching result of the main body type, correspondingly matching a parameter type field and an instance serial number field in each point name/description field with the parameter type and the instance serial number of a model object in the BIM respectively;
s250, using the data corresponding to each point location name/description field as the data corresponding to the matching item matched with each point location name/description field in the BIM model; wherein the matching item is formed by the name, parameter type and instance sequence number of a model object in the BIM model.
As shown in fig. 2, the point name/description field may correspond to data of the internet of things, such as a point communication address (ID), a point Value (Value), a point data type (DataType), a Value description (not shown in fig. 2), and a physical unit (not shown in fig. 2). And according to the fact that each point name/description field is associated with a corresponding matching item of a certain device or space in the BIM model, the Internet of things data is used as the data of the matching item of the corresponding device or space in the BIM model. By way of example, the "1# chiller chilled water supply temperature" of the point name/description field may be associated with the "CHW-Temp" matching item of the centrifugal chiller with the instance number "CH01" in the BIM model, and the data of the internet of things corresponding to the "1# chiller chilled water supply temperature" of the point name/description field may be used as the CHW-Temp data of the CH01 centrifugal chiller in the BIM model. For example, the point name/description field "1# cold start sequence" in fig. 2 may be associated with a matching term formed by the CH-start sequence of the CH01 cold in the BIM model; taking data 2.000000 corresponding to the starting sequence of the No. 1 cold machine as data of a matching item formed by CH-Startup sequence of the CH01 cold machine; the data may be only a Value (Value), or may be a point data type (DataType), a Value description (not shown in fig. 2), a physical unit (not shown in fig. 2), or the like, in addition to the Value (Value).
According to the embodiment of the invention, the point location list of the data is obtained from the internet of things database, and the point location name/description list is determined from the point location list; determining a main body type field, a parameter type field and an instance sequence number field in each point name/description field in the point name/description list; the main body type field, the parameter type field and the instance serial number field in each point location name/description field are respectively matched with the name, the parameter type and the instance serial number of a model object in the building information model BIM correspondingly; the data corresponding to each point location name/description field is used as the data corresponding to the matching item matched with each point location name/description field in the BIM model, so that the problem that existing Internet of things data in a building is associated with data of equipment or matching items in a space in the BIM model is solved, massive point location name/description fields can be grouped according to three dimensions of a main body type field, a parameter type field and an instance sequence number field, and original N point location name/description fields are disassembled into N=J×K×L fields; the matching work grouping of the point location name/description field and the matching item of the model object in the BIM model is carried out, N workload is reduced to J+K+L workload, the workload can be greatly reduced, online and offline data synchronization is guaranteed, manpower is saved, the point location table of the data is quickly matched with the matching item of the model object in the BIM model such as equipment or space, and therefore the effect of matching the data of the Internet of things with the data of the matching item of the model object in the BIM model such as equipment or space can be quickly achieved.
Example III
Fig. 6 is a schematic structural diagram of an apparatus for associating data with a model according to a third embodiment of the present invention. With reference to fig. 6, the apparatus comprises: the point name/description list determination module 331, the body type field, the parameter type field, and the instance sequence number field determination module 332, a first matching module 333, and a second matching module 334.
The point location name/description list determining module 331 is configured to obtain a point location list of data from the internet of things database, and determine a point location name/description list from the point location list;
a body type field, a parameter type field, and an instance sequence number field determining module 332, configured to determine a body type field, a parameter type field, and an instance sequence number field in each of the point name/description fields in the point name/description list;
a first matching module 333, configured to correspondingly match a main body type field in each point name/description field with a name of a model object in the building information model BIM;
the second matching module 334 is configured to correspondingly match the parameter type field and the instance sequence number field in each point name/description field with the parameter type and the instance sequence number of the model object of the class in the BIM, respectively, based on the matching result of the main body type.
Optionally, the apparatus further comprises:
the data matching module is used for taking the data corresponding to each point location name/description field as the data corresponding to the matching item matched with each point location name/description field in the BIM model;
wherein the matching item is formed by the name, parameter type and instance sequence number of a model object in the BIM model.
Optionally, the dot name/description list determining module 331 includes:
the point location description information determining unit is used for determining point location description information from the point location table;
and the point location name/description list determining unit is used for determining the point location name/description list from the point location description information.
Optionally, the body type field, parameter type field, and instance sequence number field determination module 332 includes:
a current specified feature field obtaining unit, configured to obtain a current specified feature field, where the specified feature field includes a specified body type field, a specified parameter type field, or a specified instance sequence number field;
a current specified feature field checking unit for checking whether each point name/description field contains a current specified feature field;
the feature field judging unit is used for judging whether the feature field in each point location name/description field is empty when the point location name/description field contains the current appointed feature field, wherein the feature field comprises a main body type field, a parameter type field or an instance sequence number field;
The feature field covering unit is used for covering the non-empty feature field by adopting the current appointed feature field if the feature field of the point location name/description field is non-empty;
and the feature field determining unit is used for taking the current appointed feature field as the feature field of the point location name/description field if the point location name/description field is null.
Optionally, the main body type field, parameter type field, and instance sequence number field determining module 332 further includes:
the judging unit is used for judging whether the main body type field, the parameter type field and the instance serial number field in each point name/description field are matched with the history adjustment record of the appointed main body type field, the appointed parameter type field and the appointed instance serial number field respectively when the local adjustment instruction is received;
and the corresponding unmatched item replacing unit is used for replacing the corresponding unmatched item in the point location name/description field by the appointed main body type field, the appointed parameter type field or the appointed instance serial number field of the history adjustment record if the two items are unmatched.
Optionally, the specified body type field includes at least one of a chiller, a cryopump, a cooling tower, cooling water, or chilled water; the appointed parameter type field comprises at least one of the difference between the water supply temperature and the set value, the water supply and return temperature difference, the water supply and return pressure difference, the water return temperature setting, the load demand, the number of stations, the water return flow or the starting sequence; the specific instance number field refers to a field composed of a positive integer and a set symbol.
The device for associating the data with the model provided by the embodiment of the invention can execute the method for associating the data with the model provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of executing the method.
Example IV
Fig. 7 is a schematic structural diagram of a terminal or a server according to a fourth embodiment of the present invention, and as shown in fig. 7, the terminal or the server includes a processor 410, a memory 420, an input device 430 and an output device 440; the number of processors 410 in a terminal or server may be one or more, one processor 410 being taken as an example in fig. 7; the processor 410, memory 420, input device 430, and output device 440 in a terminal or server may be connected by a bus or other means, for example in fig. 7.
The memory 420 is used as a computer readable storage medium for storing software programs, computer executable programs, and modules, such as program instructions/modules corresponding to the method for associating data with a model in the embodiments of the present invention (e.g., the point name/description list determination module 331, the body type field, the parameter type field, and the instance sequence number field determination module 332 in the device for associating data with a model, the first matching module 333, and the second matching module 334). The processor 410 executes various functional applications of the device and data processing, i.e., implements the methods described above for associating data with a model, by running software programs, instructions, and modules stored in the memory 420.
Memory 420 may include primarily a program storage area and a data storage area, wherein the program storage area may store an operating system, at least one application program required for functionality; the storage data area may store data created according to the use of the terminal, etc. In addition, memory 420 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid-state storage device. In some examples, memory 420 may further include memory located remotely from processor 410, which may be connected to the device via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input means 430 may be used to receive entered numeric or character information and to generate key signal inputs related to user settings and function control of the device. The output 440 may include a display device such as a display screen.
Example five
A fifth embodiment of the present invention also provides a storage medium containing computer-executable instructions, which when executed by a computer processor, are for performing a method of associating data with a model, the method comprising:
Acquiring a point location table of data from an internet of things database, and determining a point location name/description list from the point location table;
determining a main body type field, a parameter type field and an instance sequence number field in each point name/description field in the point name/description list;
correspondingly matching the main body type field in the point position name/description field with the name of a model object in the building information model BIM;
and based on a matching result of the main body type, correspondingly matching the parameter type field and the instance sequence number field in the point name/description field of each item with the parameter type and the instance sequence number of the model object of one type in the BIM.
Of course, the storage medium containing the computer executable instructions provided in the embodiments of the present invention is not limited to the method operations described above, and may also perform the related operations in the data and model association method provided in any embodiment of the present invention.
From the above description of embodiments, it will be clear to a person skilled in the art that the present invention may be implemented by means of software and necessary general purpose hardware, but of course also by means of hardware, although in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, etc., and include several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method according to the embodiments of the present invention.
It should be noted that, in the embodiment of the data and model association apparatus, each unit and module included are only divided according to the functional logic, but not limited to the above division, so long as the corresponding functions can be implemented; in addition, the specific names of the functional units are also only for distinguishing from each other, and are not used to limit the protection scope of the present invention.
Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.
Claims (10)
1. A method for associating data with a model, comprising:
acquiring a point location table of data from an internet of things database, and determining a point location name/description list from the point location table;
Determining a main body type field, a parameter type field and an instance sequence number field in each point name/description field in the point name/description list;
correspondingly matching the main body type field in the point position name/description field with the name of a model object in the building information model BIM;
based on the matching result of the main body type, correspondingly matching the parameter type field and the instance sequence number field in the point location name/description field with the parameter type and the instance sequence number of a model object in the BIM respectively; wherein the class of model objects is a family of devices and/or a class of spaces.
2. The method as recited in claim 1, further comprising:
the data corresponding to the point location name/description field of each item is used as the data corresponding to the matching item matched with the point location name/description field of each item in the BIM;
the matching item is formed by the name, parameter type and instance sequence number of a model object in the BIM.
3. The method of claim 1, wherein determining a list of point names/descriptions from the point bit table comprises:
determining point location description information from the point location table;
And determining a point location name/description list from the point location description information.
4. The method of claim 1, wherein determining the body type field, the parameter type field, and the instance sequence number field for each of the point name/description fields in the point name/description list comprises:
acquiring a current appointed characteristic field, wherein the appointed characteristic field comprises an appointed main body type field, an appointed parameter type field or an appointed instance sequence number field;
checking whether each point name/description field contains the current specified feature field;
if yes, judging whether a characteristic field in each point location name/description field is empty, wherein the characteristic field comprises a main body type field, a parameter type field or an instance sequence number field;
if the feature field of the point location name/description field is not null, covering the non-null feature field by adopting the current appointed feature field;
and if the characteristic field of the point location name/description field is null, taking the current appointed characteristic field as the characteristic field of the point location name/description field.
5. The method as recited in claim 4, further comprising:
when a local adjustment instruction is received, judging whether a main body type field, a parameter type field and an instance sequence number field in the point location name/description field are matched with historical adjustment records of a specified main body type field, a specified parameter type field and a specified instance sequence number field respectively;
If not, replacing the corresponding unmatched items in the point name/description field with the appointed main body type field, the appointed parameter type field or the appointed instance serial number field of the history adjustment record.
6. The method of claim 4, wherein the step of determining the position of the first electrode is performed,
the specified body type field comprises at least one of a water chiller, a cryopump, a cooling tower, cooling water or chilled water;
the specified parameter type field comprises at least one of a difference between a water supply temperature and a set value, a water supply and return temperature difference, a water supply and return pressure difference, a water return temperature setting, a load demand, a number of water stations, a water return flow or a starting sequence;
the specified instance sequence number field refers to a field formed by a positive integer and a set symbol.
7. An apparatus for associating data with a model, comprising:
the system comprises a point location name/description list determining module, a point location name/description list determining module and a point location processing module, wherein the point location name/description list determining module is used for acquiring a point location list of data from an internet database and determining the point location name/description list from the point location list;
the main body type field, the parameter type field and the instance sequence number field determining module is used for determining a main body type field, a parameter type field and an instance sequence number field in each point location name/description field in the point location name/description list;
The first matching module is used for correspondingly matching the main body type field in the point location name/description field with the name of a model object in the building information model BIM;
the second matching module is used for correspondingly matching the parameter type field and the instance sequence number field in each point location name/description field with the parameter type and the instance sequence number of one type of model object in the BIM respectively based on the matching result of the main body type; wherein the class of model objects is a family of devices or a class of spaces.
8. The apparatus as recited in claim 7, further comprising:
the data matching module is used for taking the data corresponding to the point location name/description field of each item as the data corresponding to the matching item matched with the point location name/description field of each item in the BIM;
the matching item is formed by the name, parameter type and instance sequence number of a model object in the BIM.
9. A terminal or server, the terminal or server comprising:
one or more processors;
storage means for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of associating data with a model of any of claims 1-6.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements a method of associating data with a model according to any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911047216.2A CN110825740B (en) | 2019-10-30 | 2019-10-30 | Method, device, terminal or server for associating data with model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911047216.2A CN110825740B (en) | 2019-10-30 | 2019-10-30 | Method, device, terminal or server for associating data with model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110825740A CN110825740A (en) | 2020-02-21 |
| CN110825740B true CN110825740B (en) | 2023-08-15 |
Family
ID=69551587
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911047216.2A Active CN110825740B (en) | 2019-10-30 | 2019-10-30 | Method, device, terminal or server for associating data with model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110825740B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114428991B (en) * | 2022-03-31 | 2022-07-12 | 成都柔水科技有限公司 | Internet of things perception data display method based on CIM digital base |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR101293662B1 (en) * | 2013-01-11 | 2013-08-13 | 명지대학교 산학협력단 | System for creating bim(building information modeling) object breakdown structure and method therefor |
| CN106095989A (en) * | 2016-06-21 | 2016-11-09 | 上海市建筑科学研究院(集团)有限公司 | A kind of architectural engineering information switching method based on BIM |
| CN107480364A (en) * | 2017-08-09 | 2017-12-15 | 上海市地下空间设计研究总院有限公司 | The BIM models dynamic organization method of engineering construction information management |
| CN107688627A (en) * | 2017-08-21 | 2018-02-13 | 北京上格云技术有限公司 | Internet of things data management method, semantic database and computer system |
| CN108376376A (en) * | 2018-02-02 | 2018-08-07 | 北京筑业志远软件开发有限公司 | Construction engineering quality management standardized method based on BIM models |
| CN109387179A (en) * | 2018-11-26 | 2019-02-26 | 上海建工集团股份有限公司 | A kind of engineering construction Monitoring method of the subsidence and equipment |
| CN109951330A (en) * | 2019-03-14 | 2019-06-28 | 深圳力维智联技术有限公司 | A kind of management method and communication manager of automatic identification equipment type |
| CN110188454A (en) * | 2019-05-27 | 2019-08-30 | 北京建筑大学 | Architectural Equipment and Building Information Model matching process and device |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014091302A2 (en) * | 2012-12-06 | 2014-06-19 | Solibri, Inc. | System and method for quantified quality analysis and benchmarking for building information modeling |
| US10503707B2 (en) * | 2016-07-01 | 2019-12-10 | Salesforce.Com, Inc. | Field types defined via custom metadata types |
-
2019
- 2019-10-30 CN CN201911047216.2A patent/CN110825740B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR101293662B1 (en) * | 2013-01-11 | 2013-08-13 | 명지대학교 산학협력단 | System for creating bim(building information modeling) object breakdown structure and method therefor |
| CN106095989A (en) * | 2016-06-21 | 2016-11-09 | 上海市建筑科学研究院(集团)有限公司 | A kind of architectural engineering information switching method based on BIM |
| CN107480364A (en) * | 2017-08-09 | 2017-12-15 | 上海市地下空间设计研究总院有限公司 | The BIM models dynamic organization method of engineering construction information management |
| CN107688627A (en) * | 2017-08-21 | 2018-02-13 | 北京上格云技术有限公司 | Internet of things data management method, semantic database and computer system |
| CN108376376A (en) * | 2018-02-02 | 2018-08-07 | 北京筑业志远软件开发有限公司 | Construction engineering quality management standardized method based on BIM models |
| CN109387179A (en) * | 2018-11-26 | 2019-02-26 | 上海建工集团股份有限公司 | A kind of engineering construction Monitoring method of the subsidence and equipment |
| CN109951330A (en) * | 2019-03-14 | 2019-06-28 | 深圳力维智联技术有限公司 | A kind of management method and communication manager of automatic identification equipment type |
| CN110188454A (en) * | 2019-05-27 | 2019-08-30 | 北京建筑大学 | Architectural Equipment and Building Information Model matching process and device |
Non-Patent Citations (1)
| Title |
|---|
| 手写维文字符分割中的多信息融合路径寻优方法;许亚美;卢朝阳;李静;姚超;;西安交通大学学报(第08期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110825740A (en) | 2020-02-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108038183B (en) | Structured entity recording method, device, server and storage medium | |
| US20210374195A1 (en) | Information processing method, electronic device and storage medium | |
| CN109033220B (en) | Automatic selection method, system, equipment and storage medium of labeled data | |
| CN112559717B (en) | Search matching method, device, electronic equipment and storage medium | |
| CN110825740B (en) | Method, device, terminal or server for associating data with model | |
| CN113051896A (en) | Method and device for correcting text, electronic equipment and storage medium | |
| CN116484826B (en) | Operation ticket generation method, device, equipment and storage medium | |
| CN117271467A (en) | Log query and forwarding method, device, equipment and storage medium | |
| CN117633194A (en) | Large model prompt data processing method and device, electronic equipment and storage medium | |
| CN110807066B (en) | Method, device, terminal or server for associating data with model | |
| CN116955856A (en) | Information display method, device, electronic equipment and storage medium | |
| CN116578646A (en) | Time sequence data synchronization method, device, equipment and storage medium | |
| CN115544010A (en) | Mapping relation determining method and device, electronic equipment and storage medium | |
| CN116028517A (en) | Fusion database system and electronic equipment | |
| CN115525659A (en) | Data query method and device, electronic equipment and storage medium | |
| CN115329150A (en) | Method and device for generating search condition tree, electronic equipment and storage medium | |
| CN114580637A (en) | Knowledge graph-based Internet of things equipment and parameter association method | |
| CN116108589B (en) | Method, device, equipment and medium for constructing core model | |
| CN111488430B (en) | Method, device, equipment and storage medium for processing data of event | |
| CN116303369A (en) | Automatic coding method and device based on database, electronic equipment and medium | |
| CN117194435A (en) | Index data updating method, device, equipment and storage medium | |
| CN118568087A (en) | Operation sequencing result generation method, device, equipment and storage medium | |
| CN117610508A (en) | Text processing method, device and storage medium | |
| CN117057040A (en) | Ship design graph generation method, device, equipment and storage medium | |
| CN116820041A (en) | Comparison method, device, equipment and storage medium for controller control logic function |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |