CN107368586B - Multi-system data analysis method and platform - Google Patents

Multi-system data analysis method and platform Download PDF

Info

Publication number
CN107368586B
CN107368586B CN201710606028.3A CN201710606028A CN107368586B CN 107368586 B CN107368586 B CN 107368586B CN 201710606028 A CN201710606028 A CN 201710606028A CN 107368586 B CN107368586 B CN 107368586B
Authority
CN
China
Prior art keywords
data
database
real
information
time
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
Application number
CN201710606028.3A
Other languages
Chinese (zh)
Other versions
CN107368586A (en
Inventor
冯新强
石峥嵘
谷盛
穆慧灵
王凯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Huadian Heavy Industries Co Ltd
Original Assignee
Huadian Heavy Industries Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Huadian Heavy Industries Co Ltd filed Critical Huadian Heavy Industries Co Ltd
Priority to CN201710606028.3A priority Critical patent/CN107368586B/en
Publication of CN107368586A publication Critical patent/CN107368586A/en
Application granted granted Critical
Publication of CN107368586B publication Critical patent/CN107368586B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06NCOMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
    • G06N5/00Computing arrangements using knowledge-based models
    • G06N5/02Knowledge representation; Symbolic representation
    • G06N5/022Knowledge engineering; Knowledge acquisition
    • G06N5/025Extracting rules from data

Abstract

The invention discloses a multi-system data analysis method and a platform, wherein the method comprises the following steps: collecting data information of each system in port production; storing the data information into a database according to a preset storage rule; receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database, and extracting the data; analyzing the extracted data in real time to obtain an analysis result; and generating display content according to the analysis result, and displaying the display content. The invention solves the problem that all service systems can not intensively share data and carry out real-time analysis in the port production process.

Description

Multi-system data analysis method and platform
Technical Field
The invention relates to the technical field of data analysis, in particular to a multi-system data real-time analysis method and a multi-system data real-time analysis platform.
Background
In order to meet the production management needs, a large number of special service systems are built in ports and wharfs, and the special service systems comprise a Programmable Logic Controller (PLC) control system, a Human Machine Interface (HMI) upper monitoring system, a power supply and distribution system, a water and dust removal system, an energy management system, an information management system and the like. In the port production process, the PLC system collects the state and information of the field equipment through IO and communicates with the HMI system through IO driving, and the HMI system provides data for other systems through field binding or OPC mode. And the power supply and distribution system, the water sprinkling and dust removing system and the large-scale mechanical equipment are provided with independent PLC systems, and carry out communication and data transmission with the central control PLC system through address definition, mainly interlocking signals. The energy management system and the information management system configure respective dedicated relational databases.
Because each system is designed to bear the purpose of exclusive application, each system is independent, and rapid and effective information sharing cannot be realized. Meanwhile, the process equipment, the process state and the operation information can be only displayed in a centralized mode on an HMI of a central control room, the state of large-scale mechanical equipment can be only displayed on the HMI of a driver room, power supply and distribution equipment, water sprinkling and dust removing equipment, an energy system and the like can be only monitored under respective special system interfaces, and the large-scale mechanical equipment is mostly realized in a C/S mode.
Disclosure of Invention
Aiming at the problems, the invention provides a multi-system data analysis method and a multi-system data analysis platform, which solve the problem that all service systems cannot intensively share data and carry out real-time analysis in the port production process.
In order to achieve the above object, according to a first aspect of the present invention, there is provided a multi-system data analysis method, including:
collecting data information of each system in port production;
storing the data information into a database according to a preset storage rule;
receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database, and extracting the data;
analyzing the extracted data in real time to obtain an analysis result;
and generating display content according to the analysis result, and displaying the display content.
Preferably, before receiving the data call request, formulating a data extraction rule according to the data call request, searching the database for data meeting the data extraction rule, and extracting the data, the method further includes:
and analyzing the received data information application request to obtain a calling instruction.
Preferably, the storing the data information into a database according to a preset storage rule includes:
dividing the database into a real-time database and a relational database;
dividing the data information according to data attributes to obtain field dynamic data and full-field static information data;
and storing the field dynamic data into a real-time database, and storing the full-field static information data into a relational database.
Preferably, the method further comprises:
setting a thematic data area and an exchange data area in the real-time database and the relational database respectively, wherein the thematic data area transmits data to the exchange data area according to predefined data content;
and establishing data interactive connection between the real-time database and the relational database through the data exchange area.
Preferably, the receiving a data call request, formulating a data extraction rule according to the data call request, searching for data meeting the data extraction rule in the database, and extracting the data includes:
receiving a data calling instruction, and converting the calling instruction to obtain a data access statement;
formulating a data extraction rule according to the data access statement, and controlling the output of the data access statement;
and searching data meeting the data extraction rule in the database, and extracting the data.
According to a second aspect of the present invention, there is provided a multi-system data analysis platform, the platform comprising:
the data acquisition layer is used for acquiring data information of each system in port production;
the data storage layer is used for storing the data information into a database according to a preset storage rule;
the data control layer is used for receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database and extracting the data;
the real-time analysis layer is used for carrying out real-time analysis on the extracted data to obtain an analysis result;
and the service display layer is used for generating display content according to the analysis result and displaying the display content.
Preferably, the real-time analysis layer further comprises a request parsing module, wherein,
and the request analysis module is used for analyzing the received data information application request to obtain a calling instruction.
Preferably, the data storage layer includes:
the database dividing module is used for dividing the database into a real-time database and a relational database;
the data dividing module is used for dividing the data information according to data attributes to obtain field dynamic data and full-field static information data;
and the storage module is used for storing the field dynamic data into a real-time database and storing the full-field static information data into a relational database.
Preferably, the data storage layer further comprises a setting module and a connecting module, wherein,
the setting module is used for respectively setting a thematic data area and an exchange data area in the real-time database and the relational database, wherein the thematic data area transmits data to the exchange data area according to predefined data content;
and the connection module is used for establishing data interactive connection between the real-time database and the relational database through the data exchange area.
Preferably, the data control layer includes:
the conversion module is used for receiving a data calling instruction and converting the calling instruction to obtain a data access statement;
the formulating module is used for formulating a data extraction rule according to the data access statement and controlling the output of the data access statement;
and the extraction module is used for searching the data meeting the data extraction rule in the database and extracting the data.
Compared with the prior art, the method has the advantages that the data information of each system in port production is collected; storing the data information into a database according to a preset storage rule; receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database, and extracting the data; analyzing the extracted data in real time to obtain an analysis result; and generating display content according to the analysis result, and displaying the display content. Because the data acquisition and storage can read and store the data of each system in real time, a large number of independent service systems can be managed in a centralized way, and the real-time performance and the universality of data sharing are ensured; and unified management and control can be carried out on the data, and the result is displayed visually at last, so that transparent management of production data is realized, controllability of the production process is enhanced, and the degree of management refinement is improved. And the problem that all service systems cannot intensively share data and perform real-time analysis in the port production process is solved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a schematic flowchart of a multisystem data analysis method according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating data storage at step S12 in FIG. 1 according to an embodiment of the present invention;
fig. 3 is a flowchart illustrating data extraction in step S13 of fig. 1 according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a multi-system data analysis platform according to a third embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The terms "first" and "second," and the like in the description and claims of the present invention and the above-described drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "comprising" and "having," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not set forth for a listed step or element but may include steps or elements not listed.
Example one
Fig. 1 is a schematic flow chart of a multisystem data analysis method provided in an embodiment of the present invention, and the method includes the following steps:
s11, collecting data information of each system in port production;
specifically, the data acquisition is oriented to port field equipment and production management processes, and the acquisition of real-time data and management information is realized.
The data acquisition content comprises the following steps:
state information of conveying system equipment such as a belt conveyor, a gate valve, a protection switch and the like;
state information of large mechanical equipment such as a tipper, a ship unloader, a stacker-reclaimer, a ship loader and the like;
power supply equipment information including high-low voltage equipment, electrical auxiliary equipment and the like;
water spraying equipment information, specifically comprising spraying and related equipment;
the energy collection equipment information comprises an electricity and water consumption metering terminal and the like;
dynamic information of field production operation and running information of each system;
MES/MIS/ERP system management information.
S12, storing the data information into a database according to a preset storage rule;
specifically, the database is composed of a real-time database and a relational database, the real-time database mainly stores field dynamic data, and the relational database stores full-field static information. According to the equipment and the system, a thematic data area and an exchange data area are established in the real-time database and the relational database, and the real-time database and the relational database exchange data through the exchange data area.
S13, receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database, and extracting the data;
it is understood that, after receiving a data call instruction, the input of the call instruction may be controlled, and the corresponding output or input control is performed on the data extraction rule, the data association, and the data push.
S14, analyzing the extracted data in real time to obtain an analysis result;
specifically, the real-time analysis comprises equipment energy efficiency analysis, operation efficiency analysis, personnel efficiency analysis, fault alarm analysis, historical trend analysis, production key indexes, statistical analysis reports and the like.
And S15, generating display content according to the analysis result, and displaying the display content.
Specifically, the analysis result is displayed in real time in a visual mode, and is mainly reflected in full-field dynamics, historical trend, picture playback and statistical analysis result display.
According to the technical scheme disclosed by the first embodiment of the invention, data information of each system in port production is collected; storing the data information into a database according to a preset storage rule; receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database, and extracting the data; analyzing the extracted data in real time to obtain an analysis result; and generating display content according to the analysis result, and displaying the display content. Because the data acquisition and storage can read and store the data of each system in real time, a large number of independent service systems can be managed in a centralized way, and the real-time performance and the universality of data sharing are ensured; and unified management and control can be carried out on the data, and the result is displayed visually at last, so that transparent management of production data is realized, controllability of the production process is enhanced, and the degree of management refinement is improved. And the problem that all service systems cannot intensively share data and perform real-time analysis in the port production process is solved.
Example two
Referring to the first embodiment of the present invention and the specific process of steps S11 to S15 described in fig. 1, and referring to fig. 2, the step S12 stores the data information into the database according to the preset storage rule, which specifically includes:
s121, dividing the database into a real-time database and a relational database;
s122, dividing the data information according to data attributes to obtain field dynamic data and field static information data;
and S123, storing the field dynamic data into a real-time database, and storing the full-field static information data into a relational database.
And, the method further comprises:
setting a thematic data area and an exchange data area in the real-time database and the relational database respectively, wherein the thematic data area transmits data to the exchange data area according to predefined data content;
and establishing data interactive connection between the real-time database and the relational database through the data exchange area.
It will be appreciated that the database is comprised of a real-time database which primarily stores field dynamic data and a relational database which stores full field static information. According to the equipment and the system, a thematic data area and an exchange data area are established in the real-time database and the relational database. The whole-field static information mainly refers to parameters or data which do not change along with time, and comprises a flow equipment list, equipment specification parameters, staff information and the like which are issued to the field.
The production system database adopts a real-time industrial control database and a historical database, namely a real-time database, data of each production detection device is stored by trend filing, wherein the trend refers to process data in a time period, such as vibration, temperature, noise and the like of a belt conveyor, current values, voltage values and the like of key devices, and device condition detection, fault diagnosis and the like can be realized by analyzing the trend. The management database adopts a relational database. A special data area and an exchange data area are arranged in the real-time database and the relational database, and the special data area is composed of special database tables of equipment, processes, operation, management, faults, alarm, pictures, system operation and the like; the exchange data area is composed of a group exchange database table such as a dynamic receiving table and a shared storage table, and particularly, the dynamic receiving table and the shared storage table are well defined in advance, after the content in the special database table changes, the changed content is written into the dynamic storage table and the shared storage table, for example, the content such as the start-stop and fault states of equipment is defined in the dynamic table of the equipment, the flow state, the operation flow and the like are defined in the dynamic table of the flow, an instruction issuing mark or a plan changing mark and the like are defined in the dynamic table of the management, the shared table is used for associating the field production data with the management decision information, including the shared instruction number, the plan number, the operation amount and the like, and the data content is updated in real time. The special data is transmitted to the exchange data area according to the content organization requirement, wherein the content organization requirement refers to the transmission according to the predefined data content, for example, if the exchange data area defines the instruction of turning over the pile, fetching and loading, the transmission content includes the instruction number, plan number, operation area number, plan operation amount, etc. The transmission process is completed by the trigger, and the data exchange between the data exchange areas is completed through the components.
The data exchange assembly establishes connection handles with the real-time database and the relational database simultaneously to complete processing processes of data connection, data conversion, transaction submission, data transmission and the like, when the real-time database is read dynamically, data are converted through a storage process and written into a dynamic receiving table of the relational database, dynamic contents are stored into a sharing table through a trigger, and similarly, dynamic data such as data access, command issuing and the like are managed, written into the dynamic receiving table of the real-time database and then stored into the sharing table.
Correspondingly, referring to fig. 3, the step S13 receives the data call request, formulates a data extraction rule according to the data call request, searches the database for data meeting the data extraction rule, and extracts the data, and specifically includes:
s131, receiving a data calling instruction, and converting the calling instruction to obtain a data access statement;
s132, formulating a data extraction rule according to the data access statement, and controlling the output of the data access statement;
s133, searching the data meeting the data extraction rule in the database, and extracting the data.
Before step S13, the method further includes:
and analyzing the received data information application request to obtain a calling instruction.
After the corresponding data are extracted, the business logic of various equipment states, production data, system information monitoring, inquiry, retrieval and statistical analysis application is realized through full-field correlation analysis, a remote service request is responded, information organization is completed, then the information is published and displayed, then visual display is carried out through a Web page integration mode, the data are refreshed in real time, and local or remote browsing is provided in a B/S mode.
According to the technical scheme disclosed by the second embodiment of the invention, port equipment such as all process equipment, power supply and distribution, water sprinkling and dust removal, energy systems and the like are subjected to real-time state display, fault display and monitoring management, the running time of various equipment and parameters such as multiple data of onboard equipment are remotely accessed in real time, a reverse tracking means of stored data before and after the fault occurs is provided for the equipment and the operation process, a real-time picture playback function and history backtrack of the complete state are realized, and all real-time monitoring data are normally collected and monitored in the playback process; management data and production data are fused, and relevance indexes including equipment energy efficiency analysis, operation efficiency analysis, personnel efficiency analysis, fault alarm analysis, historical trend analysis and the like are analyzed in real time; and finally, visually displaying the production index KPI, the equipment OEE, the operation process, the running state, the operation control, the statistical analysis and other information of all the subsystems in a visual mode in real time. The invention further solves the problem that all service systems can not intensively share data and carry out real-time analysis in the port production process.
EXAMPLE III
Corresponding to the multisystem data analysis methods disclosed in the first and second embodiments of the present invention, a third embodiment of the present invention further provides a multisystem data analysis platform, and referring to fig. 4, the multisystem data analysis platform provided by the present invention is designed based on an SOA (Service-Oriented Architecture) Architecture, and the platform includes:
the data acquisition layer 1 is used for acquiring data information of each system in port production;
specifically, the field equipment and the production dynamic information in the data acquisition layer are acquired through a PLC system and an HMI system, and the management information and the static data are acquired through data binding. And a data acquisition interface machine is arranged to uniformly transmit data to the storage layer in an OPC mode.
The data storage layer 2 is used for storing the data information into a database according to a preset storage rule;
the data control layer 3 is used for receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database, and extracting the data;
the data control layer calls data of the data storage layer through a data access interface, and the data access interface performs data access in a JDBC mode. The data control layer is mainly used for data calling and feedback rule organization and controlling data request and feedback.
The real-time analysis layer 4 is used for carrying out real-time analysis on the extracted data to obtain an analysis result;
specifically, the real-time analysis layer realizes the business logic of various equipment states, production data, system information monitoring, inquiry, retrieval and statistical analysis application through full-field correlation analysis, responds to a remote service request, completes information organization and then releases the information to the business presentation layer. The information service interface is uniformly realized in a Webservice mode, and interaction between the presentation layer and the analysis layer is completed through service requests, service registration and service provision.
And the service display layer 5 is used for generating display content according to the analysis result and displaying the display content.
The functions of the service presentation layer are in a modular design, visual presentation is carried out in a Web page integration mode, data are refreshed in real time, local/remote browsing is provided in a B/S mode, and final visual presentation can comprise pie charts, bar charts, line charts, gauge charts, indicator cards, contrast charts, radar charts and the like, Web access is supported, the Web access comprises control pictures, signboards and the like, and mobile terminal and mobile phone App application are supported.
Specifically, the real-time analysis layer 4 further includes a request parsing module 41, wherein,
the request analysis module 41 is configured to analyze the received data information application request to obtain a call instruction.
Accordingly, the data storage layer 2 includes:
a database dividing module 21, configured to divide the database into a real-time database and a relational database;
the data dividing module 22 is used for dividing the data information according to data attributes to obtain field dynamic data and field static information data;
and the storage module 23 is configured to store the field dynamic data in a real-time database, and store the full-field static information data in a relational database.
Also, the data storage layer comprises a setting module 24 and a connection module 25, wherein,
the setting module 24 is configured to set a thematic data area and an exchange data area in the real-time database and the relational database, respectively, where the thematic data area transmits data to the exchange data area according to predefined data content;
the connection module 25 is configured to establish data interaction connection between the real-time database and the relational database through the exchange data area.
Correspondingly, the data control layer 3 includes:
the conversion module 31 is configured to receive a data call instruction, and convert the call instruction to obtain a data access statement;
the formulating module 32 is used for formulating a data extraction rule according to the data access statement and controlling the output of the data access statement;
and the extracting module 33 is configured to search the database for data meeting the data extracting rule, and extract the data.
In the third embodiment of the invention, the multi-system data analysis platform provided by the invention is designed based on an SOA architecture and is composed of five layers, namely a data acquisition layer, a data storage layer, a data access layer, a real-time analysis layer and a service presentation layer. The method comprises the steps of standardizing a data interface and a service interface through hierarchical definition and content specification, realizing data acquisition and storage by utilizing a real-time database and relational database design technology, analyzing equipment energy efficiency, operation efficiency, energy balance and key production indexes in real time through service logic and data association rules, and remotely browsing full-field dynamic and pictures by utilizing a WebService technology, so that a visual management means based on the Internet is provided for users, and the problem that all service systems cannot share data in a centralized manner and analyze the data in real time in the port production process is solved.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (6)

1. A multi-system data analysis method, the method comprising:
collecting data information of each system in port production, wherein the data information comprises real-time data and management information;
storing the data information into a database according to a preset storage rule, wherein the storing the data information into the database according to the preset storage rule comprises: dividing the database into a real-time database and a relational database; dividing the data information according to data attributes to obtain field dynamic data and full-field static information data; storing the field dynamic data into a real-time database, and storing the field static information data into a relational database, wherein a thematic data area and an exchange data area in the real-time database and the relational database are respectively arranged, and the thematic data area transmits data to the exchange data area according to predefined data content; establishing data interactive connection between the real-time database and the relational database through the data exchange area;
receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database, and extracting the data;
analyzing the extracted data in real time to obtain an analysis result;
and generating display content according to the analysis result, and displaying the display content.
2. The method of claim 1, wherein before receiving the data call request, formulating a data extraction rule according to the data call request, searching the database for data satisfying the data extraction rule, and extracting the data, the method further comprises:
and analyzing the received data information application request to obtain a calling instruction.
3. The method of claim 1, wherein the receiving a data call request, formulating a data extraction rule according to the data call request, searching the database for data satisfying the data extraction rule, and extracting the data comprises:
receiving a data calling instruction, and converting the calling instruction to obtain a data access statement;
formulating a data extraction rule according to the data access statement, and controlling the output of the data access statement;
and searching data meeting the data extraction rule in the database, and extracting the data.
4. A multi-system data analysis platform, the platform comprising:
the port production management system comprises a data acquisition layer, a management layer and a management layer, wherein the data acquisition layer is used for acquiring data information of each system in port production, and the data information comprises real-time data and management information;
the data storage layer is used for storing the data information into a database according to a preset storage rule, and the data storage layer comprises: the database dividing module is used for dividing the database into a real-time database and a relational database; the data dividing module is used for dividing the data information according to data attributes to obtain field dynamic data and full-field static information data; the storage module is used for storing the field dynamic data into a real-time database and storing the field static information data into a relational database, wherein a thematic data area and an exchange data area in the real-time database and the relational database are respectively arranged, and the thematic data area transmits data to the exchange data area according to predefined data content; establishing data interactive connection between the real-time database and the relational database through the data exchange area;
the data control layer is used for receiving a data calling instruction, formulating a data extraction rule according to the data calling instruction, searching data meeting the data extraction rule in the database and extracting the data;
the real-time analysis layer is used for carrying out real-time analysis on the extracted data to obtain an analysis result;
and the service display layer is used for generating display content according to the analysis result and displaying the display content.
5. The platform of claim 4, wherein the real-time analytics layer further comprises a request resolution module, wherein,
and the request analysis module is used for analyzing the received data information application request to obtain a calling instruction.
6. The platform of claim 4, wherein the data control layer comprises:
the conversion module is used for receiving a data calling instruction and converting the calling instruction to obtain a data access statement;
the formulating module is used for formulating a data extraction rule according to the data access statement and controlling the output of the data access statement;
and the extraction module is used for searching the data meeting the data extraction rule in the database and extracting the data.
CN201710606028.3A 2017-07-24 2017-07-24 Multi-system data analysis method and platform Active CN107368586B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710606028.3A CN107368586B (en) 2017-07-24 2017-07-24 Multi-system data analysis method and platform

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710606028.3A CN107368586B (en) 2017-07-24 2017-07-24 Multi-system data analysis method and platform

Publications (2)

Publication Number Publication Date
CN107368586A CN107368586A (en) 2017-11-21
CN107368586B true CN107368586B (en) 2021-01-19

Family

ID=60307521

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710606028.3A Active CN107368586B (en) 2017-07-24 2017-07-24 Multi-system data analysis method and platform

Country Status (1)

Country Link
CN (1) CN107368586B (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108537301B (en) * 2018-03-21 2021-06-11 广东鸿图科技股份有限公司 Full-process accurate tracing method for aluminum alloy die-casting product
CN110816938B (en) * 2019-11-15 2021-04-09 南京大树智能科技股份有限公司 Big data analysis method based on comprehensive detection platform of cigarette packaging machine
CN112668929B (en) * 2021-01-08 2023-12-22 上海振华重工(集团)股份有限公司 Production operation performance index system for automatic wharf and statistical method thereof
CN112765206B (en) * 2021-02-05 2022-09-09 杭州同声相应科技有限公司 Flow sensing and high K factor propagation prediction method, system and storage medium thereof
CN116032732A (en) * 2023-03-27 2023-04-28 北京全路通信信号研究设计院集团有限公司 Information transmission method, system, equipment and medium for railway freight system

Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101174972A (en) * 2006-11-03 2008-05-07 盛趣信息技术(上海)有限公司 System and method for analysis data collection and statistics
CN102609463A (en) * 2012-01-13 2012-07-25 广东电网公司电力科学研究院 Data cluster management system based on quasi-realtime platform
CN102637217A (en) * 2012-02-20 2012-08-15 苏州领佰思自动化科技有限公司 Large-scale integrated circuit wiring method based on cloud computing platform and system thereof
CN104008437A (en) * 2013-02-25 2014-08-27 陈国祥 Visualization display system of intelligent power network, and method thereof
CN104133753A (en) * 2014-06-12 2014-11-05 国家电网公司 Data quality monitoring method
CN105022769A (en) * 2015-01-07 2015-11-04 泰华智慧产业集团股份有限公司 Data interaction system of urban underground pipeline, and method thereof
CN105608643A (en) * 2015-12-15 2016-05-25 广西金中软件有限公司 Intelligent tourism integrated service management platform
CN105871605A (en) * 2016-03-30 2016-08-17 国网江西省电力科学研究院 Operation and maintenance monitoring platform based on big power marketing data
CN106373391A (en) * 2016-08-31 2017-02-01 中兴智能交通股份有限公司 Multi-dimensional intelligent scheduling service platform usage method serving for urban traffic
CN106570081A (en) * 2016-10-18 2017-04-19 同济大学 Semantic net based large scale offline data analysis framework
CN106779407A (en) * 2016-12-15 2017-05-31 国网浙江省电力公司杭州供电公司 A kind of electric power data fusion method based on data pool

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090113323A1 (en) * 2007-10-31 2009-04-30 Microsoft Corporation Data center operation optimization

Patent Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101174972A (en) * 2006-11-03 2008-05-07 盛趣信息技术(上海)有限公司 System and method for analysis data collection and statistics
CN102609463A (en) * 2012-01-13 2012-07-25 广东电网公司电力科学研究院 Data cluster management system based on quasi-realtime platform
CN102637217A (en) * 2012-02-20 2012-08-15 苏州领佰思自动化科技有限公司 Large-scale integrated circuit wiring method based on cloud computing platform and system thereof
CN104008437A (en) * 2013-02-25 2014-08-27 陈国祥 Visualization display system of intelligent power network, and method thereof
CN104133753A (en) * 2014-06-12 2014-11-05 国家电网公司 Data quality monitoring method
CN105022769A (en) * 2015-01-07 2015-11-04 泰华智慧产业集团股份有限公司 Data interaction system of urban underground pipeline, and method thereof
CN105608643A (en) * 2015-12-15 2016-05-25 广西金中软件有限公司 Intelligent tourism integrated service management platform
CN105871605A (en) * 2016-03-30 2016-08-17 国网江西省电力科学研究院 Operation and maintenance monitoring platform based on big power marketing data
CN106373391A (en) * 2016-08-31 2017-02-01 中兴智能交通股份有限公司 Multi-dimensional intelligent scheduling service platform usage method serving for urban traffic
CN106570081A (en) * 2016-10-18 2017-04-19 同济大学 Semantic net based large scale offline data analysis framework
CN106779407A (en) * 2016-12-15 2017-05-31 国网浙江省电力公司杭州供电公司 A kind of electric power data fusion method based on data pool

Also Published As

Publication number Publication date
CN107368586A (en) 2017-11-21

Similar Documents

Publication Publication Date Title
CN107368586B (en) Multi-system data analysis method and platform
CN107566498A (en) A kind of method for monitoring numerical control machine and system based on Internet of Things
Tang Research on smart logistics model based on Internet of Things technology
CN105589349A (en) Crawler for discovering control system data in an industrial automation environment
CN100592745C (en) Method and system for sending localization and identity dependent information to mobile terminals
CN107438095A (en) The session interface agency of manufacturing operation information
CN106054796A (en) Sewage treatment plant monitoring system and sewage treatment plant monitoring method based on cloud
CN106292580A (en) A kind of intelligent integrated formula semiconductor manufacturing performs system
Liu et al. RFID-enabled real-time production management system for Loncin motorcycle assembly line
Arantes et al. General architecture for data analysis in industry 4.0 using SysML and model based system engineering
Fischer et al. Design and use of geographic information systems and spatial models
CN111125236A (en) Three-dimensional dynamic information physical system based on GIS
KR20190106369A (en) Programmable Logic Controller pattern analysis system for improving lifetime and productivity of factory automation facilities, and method thereof
Almeida et al. Building blocks for the development of an IoT business model
CN103259853A (en) SOA-architecture-based method for device data collecting and monitoring early warning
CN107918816A (en) Water utilities inspection system
CN111047387B (en) Recovery management method and device
CN111125235A (en) Production control method
CN115391444A (en) Heterogeneous data acquisition and interaction method, device, equipment and storage medium
Vats et al. Big data analytics in real time for enterprise applications to produce useful intelligence
CN104793570A (en) Portable motor train unit fault processing support equipment and portable motor train unit fault processing support system
CN116094174A (en) Knowledge graph-based power grid operation and maintenance monitoring method, system, equipment and medium
CN109308563A (en) A kind of modularization industrial service platform, working method and configuration method
Li et al. Research on visual logistics big data information service system
Zhou et al. Research Review on Big Data of the Smart Grid

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