CN112905711B - Database system for pipe gallery - Google Patents
Database system for pipe gallery Download PDFInfo
- Publication number
- CN112905711B CN112905711B CN201911225176.6A CN201911225176A CN112905711B CN 112905711 B CN112905711 B CN 112905711B CN 201911225176 A CN201911225176 A CN 201911225176A CN 112905711 B CN112905711 B CN 112905711B
- Authority
- CN
- China
- Prior art keywords
- data
- database
- database system
- spatial
- information
- 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
Images
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/29—Geographical information databases
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
- G06F16/287—Visualization; Browsing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/34—Browsing; Visualisation therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
Abstract
A database system for a pipe rack, wherein: the database system is used for storing the spatial data of the pipe rack and the attribute data of the pipe rack; the attribute data includes structure data and: unstructured/semi-structured data, the spatial data comprising: digital line drawing data, topographic and geomorphic data and DEM data; and, the spatial data is associated with the attribute data in the database system. From this, this disclosure has realized a novel piping lane database system, and it not only is favorable to the discernment to the information in the space, is favorable to unified visual show moreover.
Description
Technical Field
The present disclosure relates to the field of databases, and more particularly, to a database system for a pipe rack.
Background
With the continuous development of the pipe gallery industry, the corresponding informatization system is more and more complex, the data volume is more and more huge, and the identification of related information challenges the experience of users more and more, so that a novel database needs to be formed as soon as possible to effectively manage the system data.
How to provide a database system which is more convenient for unified data storage and later-stage visualization application is a technical problem which needs to be solved urgently in the field.
Disclosure of Invention
In order to solve the above technical problem, the present disclosure provides a database system for a pipe rack, wherein:
the database system is used for storing the spatial data of the pipe rack and the attribute data of the pipe rack;
the attribute data includes structure data and: unstructured/semi-structured data, wherein,
the structural data is stored in a relational database and includes: basic data stored in a basic database, monitoring data stored in a monitoring database, and business data stored in a business database; the basic data comprise cabin body structure data, cabin space distribution data, pipe access corridor line data, pipe corridor accessory facility data and monitoring equipment data; the service data comprises duty data, patrol data, porch service acceptance data, operation and maintenance emergency data and internal management data; the monitoring data comprises data of various monitored objects, including temperature and humidity data, gas concentration data, liquid level data, water pump data and illumination data;
the unstructured/semi-structured data is stored in a non-relational database, and the unstructured/semi-structured data comprises: picture data, audio data, video data, and other document data;
the spatial data includes: digital line drawing data, topographic and geomorphic data and DEM data;
and also,
the spatial data and the attribute data are associated in the database system.
In a preferred embodiment of the method of the invention,
the spatial data and the attribute data are associated in the database system by the steps of:
s100, analyzing a BIM model of the pipe gallery and expressing in a light weight mode: extracting required geometric, assembly, dimension and tolerance information, compressing the geometric information, simplifying and extracting the assembly, dimension and tolerance information, and then realizing lightweight expression of BIM model information by adopting WebGL under a B/S structure;
s200, on the basis of the step S100, further taking the IFC as the standard of the BIM model, taking the CityGML as the standard of the 3D GIS model, further taking the IFC and the CityGML as media, and realizing data conversion and association of the BIM and the GIS through data analysis and semantic mapping.
Preferably, the first and second liquid crystal materials are,
the monitoring database is a real-time database, and data mapping is carried out on the data according to the following steps:
s1000, taking out data in the real-time database;
s2000, converting the extracted real-time data into data of a corresponding table, a corresponding field and a corresponding data type in the distributed database according to the corresponding relation in the field mapping table;
and S3000, inserting the converted data into the corresponding table field in the distributed database.
From this, this disclosure has realized a novel piping lane database system, and it not only is favorable to the discernment to the information in the space, is favorable to unified visual show moreover.
Drawings
FIG. 1 is a schematic diagram of a structure shown in one embodiment of the present disclosure;
fig. 2 is a schematic diagram of a data mapping process according to an embodiment of the disclosure.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present disclosure more clear, the technical solutions of the embodiments of the present disclosure will be described clearly and completely with reference to fig. 1 to 2 of the embodiments of the present disclosure, and it is obvious that the described embodiments are some embodiments of the present disclosure, but not all embodiments. It should be noted that, in the present disclosure, the embodiments and features of the embodiments may be combined with each other without conflict. The present invention will be described in detail below with reference to the embodiments with reference to the attached drawings. All other embodiments, which can be derived by a person skilled in the art from the embodiments disclosed herein without making any creative effort, shall fall within the protection scope of the present disclosure.
It should be noted that the terms "first", "second", etc. in the description and claims of the present disclosure and the accompanying drawings are only used for distinguishing some objects and are not used for describing a specific order or sequence. It is to be understood that the terms so used are interchangeable under appropriate circumstances for describing the embodiments of the disclosure herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Referring to FIG. 1, in one embodiment, the present disclosure discloses a database system for a pipe rack, wherein:
the database system is used for storing the spatial data of the pipe rack and the attribute data of the pipe rack;
the attribute data includes structure data and: unstructured/semi-structured data, in which,
the structural data is stored in a relational database and includes: basic data stored in a basic database, monitoring data stored in a monitoring database, and business data stored in a business database; the basic data comprise cabin body structure data, cabin space distribution data, pipe access corridor line data, pipe corridor affiliated facility data and monitoring equipment data; the service data comprises duty data, patrol data, corridor service acceptance data, operation and maintenance emergency data and internal management data; the monitoring data comprises data of various monitored objects, including temperature and humidity data, gas concentration data, liquid level data, water pump data and illumination data;
the unstructured/semi-structured data is stored in a non-relational database, and the unstructured/semi-structured data comprises: picture data, audio data, video data, and other document data;
the spatial data includes: digital line drawing data, topographic and geomorphic data and DEM data;
and the number of the first and second electrodes,
the spatial data and the attribute data are associated in the database system.
For the embodiment, a novel pipe gallery database system is realized, and it can be understood that the data sources are numerous, wherein the monitoring data mainly come from various online monitoring instruments or sensors, and the service data mainly come from an operation platform supported by the database system. In the embodiment, the unified storage and management of various data and the characteristics of various databases are fully considered, and the embodiment is favorable for identifying information in space by all data of the management corridor and for unified visual display because the spatial data and the attribute data are associated in the database system. For example, each database is typically provided with a data interface for interfacing with a backend or superior platform for visual presentation.
In a further embodiment of the method according to the invention,
the various databases are physically separate but logically related.
It can be appreciated that the physically separate but logically related nature of the various databases makes it logically closely related in the run management, which is advantageous in maintaining data consistency.
In another embodiment of the present invention, the substrate is,
the spatial data and the attribute data are associated in the database system by the steps of:
s100, analyzing a BIM model of the pipe gallery and expressing in a light weight mode: extracting required geometric, assembly, dimension and tolerance information, compressing the geometric information, simplifying and extracting the assembly, dimension and tolerance information, and then realizing lightweight expression of BIM model information by adopting WebGL under a B/S structure;
s200, on the basis of the step S100, further taking the IFC as the standard of the BIM model, taking the CityGML as the standard of the 3D GIS model, further taking the IFC and the CityGML as media, and realizing data conversion and association of the BIM and the GIS through data analysis and semantic mapping.
With respect to the above-described embodiments of the present invention,
the IFC (Industry Foundation Classes) standard is a building engineering data exchange standard established by an IAI (International Alliance of Interoperability) organization, is a format commonly used by BIM at present, and can realize information interaction and sharing among different specialties and different design software of a building model. The IFC data standard utilizes a hierarchical and modular framework structure to describe various types of data and information in the engineering project full lifecycle management process.
In addition, a series of data storage standards and system interface specifications, such as GML, OWS and a modeling specification, type GML standard, which is widely used in three-dimensional scene simulation, are developed in consideration of the geographic information system association to realize spatial information sharing and interoperation between different GIS systems. City geographic map Markup Language (City geographic map Markup Language) is an international standard for realizing information sharing and visualization of three-dimensional City models, defines three-dimensional geometric, topological and semantic information of City space objects, and has a data storage format following XML extensible Markup Language. The information model stored based on the CityGML standard not only can visually express the appearance of urban buildings, but also defines the categories, attributes and interrelationships between the geographic objects. Therefore, the standard is not only a common geographic graphic file format, but also can be used for realizing complex analysis functions such as data mining, topic query and the like by using the information stored by the model.
In view of this, in order to reduce the overhead of data and the bandwidth occupation in the transmission process, and also to improve the user experience, the embodiment performs lightweight expression on the BIM model, and meanwhile, in order to implement association between the BIM model and the GIS model in the pipe gallery database system, the embodiment innovatively implements a specific implementation manner for associating the spatial data and the attribute data described in the present disclosure.
In another embodiment of the present invention, the substrate is,
the monitoring database is a real-time database, and data mapping is carried out on the data according to the following steps:
s1000, taking out data in the real-time database;
s2000, converting the extracted real-time data into data of a corresponding table, a corresponding field and a corresponding data type in the distributed database according to the corresponding relation in the field mapping table;
and S3000, inserting the converted data into the corresponding table field in the distributed database.
It can be appreciated that monitoring data often places very high real-time requirements, and business data or underlying data need not be in such real-time. However, as for the operation platform interfacing with the database system, with the development of the cloud computing technology, various possible terminals and APPs all need to access data in the database system, especially, various applications or functions on the cloud platform need to access data of the real-time database, and the root is that the final purpose of cloud platform construction is to provide data for applications such as various business systems, data mining, auxiliary support, and the like, which inevitably results in communication between the real-time database of the monitoring system and the distributed database of the cloud platform. However, this faces the problem of how to map the data of the real-time database into the distributed database of the cloud platform. With the above embodiment, it is a good solution to the above problems in terms of the pipe rack database. It should be noted that the database system according to the present disclosure may include the distributed database facing the cloud platform application.
In another embodiment of the present invention, the substrate is,
considering that the data sources that the piping lane is related are extensive, data types are various, data volume is big etc. for the validity of guaranteeing high in the clouds data and the efficiency of database system operation, this disclosure still further carries out standardized processing to attribute data and spatial data in the database system:
(1) establish noun term criteria: all nouns are normalized and coded during data acquisition; it can be appreciated that this is because pipe gallery database systems face a large number of noun terms;
(2) data classification criteria: establishing reasonable data classification for a large amount of data such as a corridor main body, affiliated facilities, a pipe entering corridor line, managers and the like, wherein the classification principle is based on the storage management and sharing exchange of the data;
(3) the standard of the work flow is as follows: the method comprises the steps of establishing a workflow standard respectively for daily management and emergency management of a pipe gallery, wherein at least the work flow is combed according to requirements of all departments to a pipe gallery administration department, a pipe gallery entering line unit, an operation management unit, a public security department, a fire fighting department and the like.
That is to say, through this embodiment, the database system will establish its own system standard to be favorable to generally being applicable in the industry, under the prerequisite of guaranteeing the validity of cloud end data and the efficiency of database system operation, further reduce the combined cost of piping lane database system in this field.
It can be appreciated that the technical solutions of the present disclosure enable a person skilled in the art to make full use of spatial data and attribute data, in particular the association of both. In the process of continuous development of pipe gallery construction, the visual expression at different stages of design, construction and operation is facilitated, and therefore the development level of the industry is improved.
In another embodiment, the spatial positions of the elements (such as beams, walls, columns, floors, pipes, and the like) involved in the pipe gallery are calculated, and the database system can also determine the mutual spatial relationship among the elements and further combine the attribute data of the elements, so that a corresponding thematic map can be obtained on the basis of the spatial positions, the attribute data and the mutual spatial relationship. That is, the present disclosure can further relate the space and all information and graphs related to the space, and is more beneficial to the data visualization of the database system in its corresponding work platform. It should be noted that, for the thematic map, the display of the corresponding index, the operation and maintenance KPI, and the like can also be realized through spatial superposition analysis and spatial attribute data calculation.
Considering the association between the spatial data and the attribute data, for the modeling process of the BIM model, 3D modeling of the utility tunnel and the internal devices/pipelines can be performed by using the BIM modeling software, and the attribute information (basic information, maintenance information, cost information, contract information) of the utility tunnel and the internal devices/pipelines is correspondingly added; meanwhile, sensor information related to the monitoring data, including fire information, environmental information, safety information, and equipment information, is input at the corresponding location. This means that, with the support of the database system of the present disclosure, when a dangerous situation occurs at a certain location, a trigger condition may also be set, and the video information at that location is automatically called.
Furthermore, the information is integrated through the BIM model, and an information integrated BIM model can be formed. In addition, for the operation platform corresponding to the database system, a manager can accurately position any structural part or equipment/pipeline in the comprehensive pipe rack through visual management, and can view the part needing to be known in a 360-degree dead angle-free mode. For the equipment and the pipelines in the pipe gallery, besides the appearance and the spatial position information, different colors or patterns can be covered on the relevant fault parts to express the current different states (operation and maintenance state, cost control state, contract dispute state and the like), and the management and decision of a manager can be assisted by utilizing the intuitive mode.
The above is merely a preferred embodiment of the present disclosure and is not intended to limit the present disclosure, which may be variously modified and varied by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present disclosure should be included in the protection scope of the present disclosure.
Claims (3)
1. A database system for a pipe rack, wherein:
the database system is used for storing the spatial data of the pipe rack and the attribute data of the pipe rack;
the attribute data includes structure data and: unstructured/semi-structured data, in which,
the structural data is stored in a relational database and includes: basic data stored in a basic database, monitoring data stored in a monitoring database, and business data stored in a business database; the basic data comprise cabin body structure data, cabin space distribution data, pipe access corridor line data, pipe corridor accessory facility data and monitoring equipment data; the service data comprises duty data, patrol data, corridor service acceptance data, operation and maintenance emergency data and internal management data; the monitoring data comprises data of various monitored objects, including temperature and humidity data, gas concentration data, liquid level data, water pump data and illumination data;
the unstructured/semi-structured data is stored in a non-relational database, and the unstructured/semi-structured data comprises: picture data, audio data, video data, and other document data;
the spatial data includes: digital line drawing data, topographic and geomorphic data and DEM data;
and also,
the spatial data and the attribute data are associated in the database system.
2. The system of claim 1, wherein preferably the spatial data and the attribute data are associated in the database system by:
s100, analyzing a BIM model of the pipe gallery and expressing in a light weight mode: extracting required geometric, assembly, dimension and tolerance information, compressing the geometric information, simplifying and extracting the assembly, dimension and tolerance information, and then realizing lightweight expression of BIM (building information modeling) by adopting webGL under a B/S (browser/server) structure;
s200, on the basis of the step S100, further taking the IFC as the standard of the BIM model, taking the CityGML as the standard of the 3D GIS model, further taking the IFC and the CityGML as media, and realizing data conversion and association of the BIM and the GIS through data analysis and semantic mapping.
3. The system of claim 1, wherein the monitoring database is a real-time database, wherein the data is mapped according to the following steps:
s1000, taking out data in the real-time database;
s2000, converting the extracted real-time data into data of a corresponding table, a corresponding field and a corresponding data type in a distributed database according to the corresponding relation in the field mapping table;
and S3000, inserting the converted data into the corresponding table field in the distributed database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911225176.6A CN112905711B (en) | 2019-12-03 | 2019-12-03 | Database system for pipe gallery |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911225176.6A CN112905711B (en) | 2019-12-03 | 2019-12-03 | Database system for pipe gallery |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112905711A CN112905711A (en) | 2021-06-04 |
| CN112905711B true CN112905711B (en) | 2023-02-17 |
Family
ID=76104601
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911225176.6A Active CN112905711B (en) | 2019-12-03 | 2019-12-03 | Database system for pipe gallery |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112905711B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106960410A (en) * | 2017-03-30 | 2017-07-18 | 中建地下空间有限公司 | Underground pipe gallery approaches to IM based on BIM and GIS technology |
| CN108664666A (en) * | 2018-07-02 | 2018-10-16 | 青岛华高物联网科技有限公司 | A kind of underground pipe gallery three dimensional device cruising inspection system |
-
2019
- 2019-12-03 CN CN201911225176.6A patent/CN112905711B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106960410A (en) * | 2017-03-30 | 2017-07-18 | 中建地下空间有限公司 | Underground pipe gallery approaches to IM based on BIM and GIS technology |
| CN108664666A (en) * | 2018-07-02 | 2018-10-16 | 青岛华高物联网科技有限公司 | A kind of underground pipe gallery three dimensional device cruising inspection system |
Non-Patent Citations (1)
| Title |
|---|
| 城市综合管廊运营管理系统构建;郑立宁等;《建筑经济》;20161005(第10期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112905711A (en) | 2021-06-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109165394B (en) | A kind of standardization BIM model lightweight implementation method | |
| CN105139453B (en) | A kind of threedimensional model display systems | |
| CN105022769B (en) | A kind of City Underground Pipeline interactive system and its method | |
| CN113902605A (en) | Smart park operation and maintenance management mode based on CIM framework | |
| CN105931168A (en) | Smart city service configuration based on information grid service | |
| CN104573032A (en) | Emergency simulation drilling all-in-one machine for nuclear emergency device | |
| CN108694244A (en) | A kind of electric network synthetic application platform based on three-dimensional data | |
| CN106598000B (en) | A kind of production scheduling and security management and control system | |
| CN104794151A (en) | Spatial knowledge service system building method based on collaborative plotting technology | |
| CN110348070B (en) | System modeling method based on model system engineering and hyper-network theory | |
| WO2016081628A1 (en) | System and method for aggregating and analyzing data and creating a spatial and/or non-spatial graphical display based on the aggregated data | |
| Wang et al. | Research on key technologies of city information modeling | |
| CN109309713A (en) | Piping lane operation management system based on wisdom piping lane aware communications integrating device | |
| Bi et al. | Research on the construction of City information modelling basic platform based on multi-source data | |
| CN112905711B (en) | Database system for pipe gallery | |
| CN202870564U (en) | Digital mine safety production local area network system | |
| CN115424212A (en) | Electric power operation field violation identification system and application thereof | |
| CN115587793A (en) | Engineering supervision method, system, equipment and medium based on building information model | |
| CN110858354A (en) | Urban public safety service system | |
| CN109905416A (en) | A kind of urban air-quality intelligent dispatching system | |
| Li | Construction of university fire safety facilities management information system based on WebGis | |
| CN109711647A (en) | A kind of public safety support platform | |
| Casey et al. | Semantics in CAD/GIS integration | |
| CN104933106A (en) | Database device for IFC informatization model | |
| Han | A Study on the Plan to Construct the Comprehensive Perception System and Intelligent Operation and Maintenance System of the Intelligent Pipe Corridor |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Yang Dangfeng Inventor after: Chen Hui Inventor after: Liu Xiaodong Inventor after: Wu Peipei Inventor after: Hu Kun Inventor before: Yang Dangfeng Inventor before: Su Feng Inventor before: Liu Xiaodong Inventor before: Chen Hui Inventor before: Quan Feng Inventor before: Ma Xiaodong Inventor before: Wu Peipei Inventor before: Huang Yong Inventor before: Hu Kun |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |