CN113254548A - Method for integrating multidimensional data of park - Google Patents
Method for integrating multidimensional data of park Download PDFInfo
- Publication number
- CN113254548A CN113254548A CN202110624699.9A CN202110624699A CN113254548A CN 113254548 A CN113254548 A CN 113254548A CN 202110624699 A CN202110624699 A CN 202110624699A CN 113254548 A CN113254548 A CN 113254548A
- Authority
- CN
- China
- Prior art keywords
- data
- service
- integration
- campus
- file
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 21
- 230000010354 integration Effects 0.000 claims abstract description 42
- 238000013500 data storage Methods 0.000 claims abstract description 10
- 230000006855 networking Effects 0.000 claims abstract description 5
- 238000007781 pre-processing Methods 0.000 claims abstract description 4
- 230000005856 abnormality Effects 0.000 claims description 6
- 238000010586 diagram Methods 0.000 claims description 6
- 238000007726 management method Methods 0.000 claims description 4
- 230000002159 abnormal effect Effects 0.000 claims description 3
- 238000004519 manufacturing process Methods 0.000 claims description 3
- 238000012986 modification Methods 0.000 claims description 3
- 230000004048 modification Effects 0.000 claims description 3
- 238000006243 chemical reaction Methods 0.000 abstract description 3
- 238000000605 extraction Methods 0.000 abstract description 3
- 238000011068 loading method Methods 0.000 abstract description 3
- 238000012545 processing Methods 0.000 abstract description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000013475 authorization Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006641 stabilisation Effects 0.000 description 1
- 238000011105 stabilization Methods 0.000 description 1
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to the technical field of parks, in particular to a method for integrating multidimensional data of a park, which comprises the following steps: s1, determining a data source; s2, building a data integration service; s3, providing data storage service; and S4, realizing data sharing service, wherein the data sources comprise campus internal enterprise applications, a supplier service system, a campus Internet of things device, a campus internal or external database, third party authorized data and edge node preprocessing service erected in a campus, namely, the data sources can be regarded as data with networking capability in the campus. The data integration service can realize real-time forwarding of equipment data, collects and integrates parts frequently used at high frequency in the integrated data from a dispersed service system, and stores the parts in a data warehouse according to different themes through extraction, conversion and loading processing, thereby ensuring the consistency and uniqueness of public service data.
Description
Technical Field
The invention relates to the technical field of parks, in particular to a method for integrating multidimensional data of a park.
Background
In order to meet the development of the industrial park and improve the market competitiveness of the area, various intelligent software systems or Internet of things facility equipment are often installed and used in the industrial park, for example, in order to provide the property operation efficiency, a property management system is introduced to realize the online service scene under the property line. Undoubtedly, the service requirements of single or multiple departments in the park can be well met by using the software and hardware systems or facility equipment in the park, so that the overall operation benefit of the park is improved. When a park enters a rapid growth period or a mature stabilization period from a starting development period, investment of various software systems or Internet of things facilities and equipment of the park can be greatly reduced, colleagues deposit a large amount of asset data, how to enable early investment to exert the maximum clustering effect at this stage, and a real intelligent park is constructed, which is a valuable proposition.
At the same time, parks face long, unsolved challenges: the prior used facility identification and software system of the internet of things are different from suppliers, so that the property of the parks are respectively developed in a political and political chimney mode, and interconnection and intercommunication are basically difficult.
Disclosure of Invention
Based on the park proposed in the background art, there are long-standing challenges that are difficult to solve: the invention provides a park multidimensional data integration method, which solves the technical problems that park assets are developed in a chimney type and are difficult to interconnect and intercommunicate basically due to different suppliers of Internet of things facility identification and software systems used in the prior art.
The invention provides an integration method of park multidimensional data, which comprises the following steps:
s1, determining a data source;
s2, building a data integration service;
s3, providing data storage service;
and S4, realizing the data sharing service.
Preferably, the data source includes a campus internal enterprise application, a provider service system, a campus internet of things device, a campus internal or external database, third party authorization data, and a campus-installed edge node preprocessing service, that is, any data having networking capability in a campus can be regarded as the data source.
Preferably, the data integration service comprises three parts of application integration, device integration and message integration, wherein the application integration supports two methods of data source integration or API integration and supports the integration of applications on the premise of non-invasive modification.
Preferably, the device integration follows MQTT standard protocol to connect with the Internet of things device, so that real-time forwarding of device data can be realized, the message integration uses a message storage container Topic to perform centralized management, and any resource needing message transmission service needs to establish Topic and configure subscription authority to ensure successful connection with the Topic.
Preferably, the data storage mainly provides a common data warehouse service, and parts of the integrated data which are frequently used at high frequency are collected and integrated from the scattered business systems, and then are stored in the data warehouse according to different subjects through extraction, conversion and loading processing, so that the consistency and uniqueness of the common business data are ensured.
Preferably, the data open sharing service is that the API, the data source and the custom function are packaged into a standard RESTFul API based on a data integration service and are open to the outside, an open interface allows tight connection between an application and equipment, and open data provides fertile production materials for north-south connection.
Preferably, the data storage includes a fault report file, a basic information file, and an original data file, the fault report file is used for describing basic information related to the current abnormality, and the fault report file includes basic information of the abnormality, a fault recording report, a protection action report, a system section and information, and auxiliary information.
Preferably, the basic information file stores and describes the power grid basic information related to the abnormal equipment at this time, and the basic information includes power grid wiring diagram information, equipment basic information and secondary equipment information; the original data file is an original recording file interacted with the service system and is stored in a corresponding directory folder, and the file name is the original recording file name.
The beneficial effects of the invention are as follows: the data with networking capability in any garden can be regarded as data sources, the data sources are wide, the data integration service can realize real-time forwarding of equipment data, parts of the integrated data which are frequently used at high frequency are collected and integrated from a scattered service system, and then are extracted, converted and loaded, and are stored in a data warehouse according to different themes, so that the consistency and uniqueness of public service data are ensured.
The parts of the device not involved are the same as or can be implemented using prior art.
Drawings
FIG. 1 is a schematic structural diagram of a method for integrating multidimensional data of a campus according to the present invention;
FIG. 2 is a schematic diagram of a data source of a method for integrating multidimensional data of a park according to the present invention;
fig. 3 is a schematic structural diagram of a data integration service of the method for integrating multidimensional data of a campus according to the present invention.
Detailed Description
The technical solution of the present patent will be described in further detail with reference to the following embodiments.
Reference will now be made in detail to embodiments of the present patent, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary only for the purpose of explaining the present patent and are not to be construed as limiting the present patent.
In the description of this patent, it is to be understood that the terms "center," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," and the like are used in the orientations and positional relationships indicated in the drawings for the convenience of describing the patent and for the simplicity of description, and are not intended to indicate or imply that the referenced devices or elements must have a particular orientation, be constructed and operated in a particular orientation, and are not to be considered limiting of the patent.
In the description of this patent, it is noted that unless otherwise specifically stated or limited, the terms "mounted," "connected," and "disposed" are to be construed broadly and can include, for example, fixedly connected, disposed, detachably connected, disposed, or integrally connected and disposed. The specific meaning of the above terms in this patent may be understood by those of ordinary skill in the art as appropriate.
Referring to fig. 1 to 3, a method for integrating multidimensional data of a campus, comprising the steps of:
s1, determining a data source;
s2, building a data integration service;
s3, providing data storage service;
and S4, realizing the data sharing service.
In the invention, the data sources comprise campus internal enterprise applications, a supplier service system, a campus Internet of things device, a campus internal or external database, third party authorized data and edge node preprocessing services erected in a campus, namely, the data with networking capability in the campus can be regarded as data.
In the invention, the data integration service comprises three parts of application integration, equipment integration and message integration, and the application integration supports two methods of data source integration or API integration and supports the integration of application on the premise of non-invasive modification.
In the invention, the device integration follows MQTT standard protocol to connect with the Internet of things device, so that real-time forwarding of device data can be realized, the message integration uses the message storage container Topic to carry out centralized management, and any resource needing message transmission service needs to establish Topic and configure subscription authority to ensure successful connection with the Topic.
In the invention, the data storage mainly provides a public data warehouse service, the part frequently used with high frequency in the integrated data is collected and integrated from a scattered service system, and then is stored in the data warehouse according to different subjects after extraction, conversion and loading processing, thereby ensuring the consistency and uniqueness of the public service data.
In the invention, the data open sharing service is that an API, a data source and a self-defined function are packaged into a standard RESTFul API based on a data integration service and are open to the outside, an open interface enables applications and equipment to be tightly connected, and open data provides fertile production materials for north-south connection.
In the invention, the data storage comprises a fault report file, a basic information file and an original data file, wherein the fault report file is used for describing basic information related to the abnormality, and the fault report file comprises basic information of the abnormality, a fault recording report, a protection action report, a system section and information and auxiliary information.
In the invention, a basic information file stores and describes the basic information of the power grid related to the abnormal equipment at this time, including power grid wiring diagram information, basic equipment information and secondary equipment information; the original data file is an original recording file interacted with the service system and is stored in a corresponding directory folder, and the file name is the original recording file name.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention should be equivalent or changed within the scope of the present invention.
Claims (8)
1. A method for integrating multidimensional data of a park, which is characterized by comprising the following steps:
s1, determining a data source;
s2, building a data integration service;
s3, providing data storage service;
and S4, realizing the data sharing service.
2. The method according to claim 1, wherein the data sources include campus-internal enterprise applications, provider business systems, campus internet of things devices, campus-internal or external databases, third party authorized data, and campus-installed edge node preprocessing services, that is, any data with networking capability in a campus can be considered as the data source.
3. The method for integrating multidimensional data of a park as claimed in claim 1, wherein the data integration service comprises three parts of application integration, equipment integration and message integration, the application integration supports two methods of data source integration or API integration, and supports the integration of applications on the premise of non-invasive modification.
4. The method for integrating multidimensional data of a park as claimed in claim 1, wherein the device integration follows MQTT standard protocol to connect with Internet of things devices, so as to realize real-time forwarding of device data, the message integration uses a message storage container, Topic, for centralized management, and any resource requiring message delivery service needs to create Topic and configure subscription authority to ensure successful connection with Topic.
5. The method as claimed in claim 1, wherein the data storage mainly provides a common data warehouse service, and the parts of the integrated data that are frequently used with high frequency are collected and integrated from the distributed business system, and then are extracted, converted, loaded and stored in the data warehouse according to different topics, so as to ensure the consistency and uniqueness of the common business data.
6. The method as claimed in claim 1, wherein the data open sharing service encapsulates API, data source and custom function into standard RESTFul API and opens to outside based on data integration service, the open interface allows tight connection between application and device, and the open data provides fertile production material for north-south connection.
7. The method as claimed in claim 5, wherein the data storage includes a fault report file, a basic information file, and a raw data file, the fault report file is used for describing basic information related to the abnormality, and the fault report file includes basic information about the abnormality, a fault recording report, a protection action report, a system profile and information, and auxiliary information.
8. The method for integrating the multidimensional data of the park as claimed in claim 7, wherein the basic information file stores and describes basic power grid information related to the abnormal equipment at this time, including power grid wiring diagram information, basic equipment information and secondary equipment information; the original data file is an original recording file interacted with the service system and is stored in a corresponding directory folder, and the file name is the original recording file name.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110624699.9A CN113254548A (en) | 2021-06-04 | 2021-06-04 | Method for integrating multidimensional data of park |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110624699.9A CN113254548A (en) | 2021-06-04 | 2021-06-04 | Method for integrating multidimensional data of park |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113254548A true CN113254548A (en) | 2021-08-13 |
Family
ID=77186701
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110624699.9A Pending CN113254548A (en) | 2021-06-04 | 2021-06-04 | Method for integrating multidimensional data of park |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113254548A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105096045A (en) * | 2015-07-29 | 2015-11-25 | 湖北视纪印象科技股份有限公司 | Public network service system for creative industry park |
| CN107169687A (en) * | 2017-07-17 | 2017-09-15 | 浙江欧歌科技股份有限公司 | A kind of wisdom garden service system |
| CN110543464A (en) * | 2018-12-12 | 2019-12-06 | 广东鼎义互联科技股份有限公司 | Big data platform applied to smart park and operation method |
| CN110913023A (en) * | 2019-12-27 | 2020-03-24 | 深圳云谷星辰信息技术有限公司 | Big data management platform for industrial park |
| CN112184528A (en) * | 2020-10-17 | 2021-01-05 | 安顺市颐秀合科技有限公司 | Big data intelligent platform in wisdom garden |
| CN112883011A (en) * | 2021-02-05 | 2021-06-01 | 京东方科技集团股份有限公司 | Real-time data processing method and device |
-
2021
- 2021-06-04 CN CN202110624699.9A patent/CN113254548A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105096045A (en) * | 2015-07-29 | 2015-11-25 | 湖北视纪印象科技股份有限公司 | Public network service system for creative industry park |
| CN107169687A (en) * | 2017-07-17 | 2017-09-15 | 浙江欧歌科技股份有限公司 | A kind of wisdom garden service system |
| CN110543464A (en) * | 2018-12-12 | 2019-12-06 | 广东鼎义互联科技股份有限公司 | Big data platform applied to smart park and operation method |
| CN110913023A (en) * | 2019-12-27 | 2020-03-24 | 深圳云谷星辰信息技术有限公司 | Big data management platform for industrial park |
| CN112184528A (en) * | 2020-10-17 | 2021-01-05 | 安顺市颐秀合科技有限公司 | Big data intelligent platform in wisdom garden |
| CN112883011A (en) * | 2021-02-05 | 2021-06-01 | 京东方科技集团股份有限公司 | Real-time data processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108134764B (en) | Distributed data sharing and exchanging method and system | |
| CN112698953A (en) | Power grid intelligent operation and detection platform based on micro-service | |
| CN107888539A (en) | Internet-of-things terminal access device and method | |
| CN106127657A (en) | A kind of municipal government hot line platform for data arrangement | |
| CN103916296A (en) | Communication system integrated with local area network | |
| CN110968629A (en) | Cross-hierarchy heterogeneous data aggregation-based unified information resource management method and system | |
| CN110096545A (en) | One kind being based on big data platform data processing domain architecting method | |
| CN100353708C (en) | System and method meeting network management requirement of mass terminal equipment | |
| CN100388665C (en) | Telecommunication network calling centre system and its implementing method | |
| CN111506297A (en) | Mobile top layer design system | |
| CN103401924A (en) | B/S (Browser/Server) architecture-based front distributed intelligent community operation platform | |
| CN105743870A (en) | Design method of intelligent substation integrated business platform service interfaces | |
| CN102262751A (en) | Method and system for acquiring service application based on SOA (service-oriented architecture) | |
| CN1972276A (en) | A management method and system for protocol access | |
| CN113254548A (en) | Method for integrating multidimensional data of park | |
| CN107422181A (en) | A kind of electric energy meter for supporting 698 communications protocol | |
| CN116033375B (en) | Communication base station total station intelligent management and control method and system | |
| CN114885012B (en) | System access method and system of Internet of things platform | |
| CN111786879A (en) | Intelligent fusion terminal gateway supporting containerization | |
| CN106059635A (en) | Bluetooth setting method and device for electronic equipment and Bluetooth connection method | |
| CN116502817A (en) | Basic unit administers wisdom platform | |
| CN114139943A (en) | Electric power Internet of things communication safety protection system and method and readable storage medium | |
| CN111031132A (en) | Industrial Internet system architecture based on standard communication protocol and implementation method thereof | |
| CN205453848U (en) | System is grouied busy to pronunciation | |
| Miu et al. | A Real-time Detection Framework for Abnormal Devices in the Power Internet of Things |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20210813 |