CN113592435A - Intelligent monitoring and early warning system for material supply - Google Patents
Intelligent monitoring and early warning system for material supply Download PDFInfo
- Publication number
- CN113592435A CN113592435A CN202110778324.8A CN202110778324A CN113592435A CN 113592435 A CN113592435 A CN 113592435A CN 202110778324 A CN202110778324 A CN 202110778324A CN 113592435 A CN113592435 A CN 113592435A
- Authority
- CN
- China
- Prior art keywords
- data
- early warning
- intelligent monitoring
- management
- monitoring
- 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
Images
Classifications
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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
- 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/258—Data format conversion from or to a database
-
- 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
- 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
- G06Q10/00—Administration; Management
- G06Q10/04—Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
-
- G—PHYSICS
- G08—SIGNALLING
- G08B—SIGNALLING OR CALLING SYSTEMS; ORDER TELEGRAPHS; ALARM SYSTEMS
- G08B21/00—Alarms responsive to a single specified undesired or abnormal condition and not otherwise provided for
- G08B21/18—Status alarms
- G08B21/24—Reminder alarms, e.g. anti-loss alarms
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Quality & Reliability (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Emergency Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an intelligent monitoring and early warning system for material supply, which relates to the technical field of intelligent monitoring of material supply, and is used for comprehensively integrating and communicating full-flow service data of a material supply chain and realizing intelligent monitoring and early warning reminding of key indexes; the whole intelligent monitoring and early warning system for material supply solves the problems of material management data, particularly the situations of data dispersion and lack of comprehensive application of rated material allocation management data, and utilizes an ETL (extract transform load) technology to realize the comprehensive analysis, processing and comprehensive application of the dispersed data of each service system, so as to provide real and timely data support for management decision, and assist decision makers to more efficiently manage and control important information and detail levels of material management, particularly each link of rated material allocation.
Description
Technical Field
The invention relates to the technical field of intelligent monitoring of material supply, in particular to an intelligent monitoring and early warning system for material supply.
Background
Because partial business processing of material center portion is managed through the manual work under the line, relevant information transfer is untimely, sharing nature is poor, the transparency is low, managers can't know the actual conditions of business in real time, generally lack one set of unified management tool who concentrates relevant business information of show, realize visual management of show to relevant information such as real-time video, equipment, material, need carry out holistic dispatch, plan overall planning and the early warning processing of special condition to the resource simultaneously. In the process of normal materialized operation, factors such as large service processing data volume, wide association range, variable service problems, complex processing strategies and the like need professional teams and comprehensive service knowledge support, the original simple common manual work is used as judgment, better service level development is difficult to support, a processing mode with large number of applications is urgently needed to be introduced, better, faster and more accurate information service is intelligently provided, the service processing capacity and response speed are improved, and a more effective service system and management strategy are formed.
The existing offline manual management mode causes untimely related information transmission, poor sharing performance and low transparency, and in the process of normal materialized operation, the factors of large service processing data volume, wide association range, variable service problems, complex processing strategies and the like are factors, and simple common manual work is a problem that better service level development is difficult to support.
Disclosure of Invention
The invention provides an intelligent monitoring and early warning system for material supply, which solves the problems that the prior art adopts an offline manual management mode, so that the related information is not transferred in time, the sharing performance is poor, the transparency is low, in the process of normal materialized operation, the service processing data volume is large, the association range is wide, the service problems are variable, the processing strategy is complex and the like, and the simple common manual work is used for judging that better service level is difficult to support.
In order to alleviate the above problems, the technical scheme adopted by the invention is as follows:
the invention provides an intelligent monitoring and early warning system for material supply, which comprises:
a data source for providing material management data;
the data center processes the material management data based on an ETL technology, and stores material management intermediate data in the processing process and finally obtained material management result data;
and the data application module is used for displaying the material management result data to a user and realizing the monitoring and early warning of the user on the material management data.
In a preferred embodiment of the present invention, the data sources include a materials system, an electronic commerce system, a demand forecasting system, an investment planning system, a production system, a capital construction management system, and a financial system.
In a preferred embodiment of the present invention, the storage modules of the data center include three levels of storage modes of an operational data storage, a data warehouse and a data mart according to the granularity and data category of the data storage.
In a preferred embodiment of the present invention, the data application module includes a monitoring display function module, a warehouse scheduling platform display function module, and a material center large-screen monitoring data processing function module, and the material center large-screen monitoring data processing function module includes a purchasing center large-screen monitoring data processing function module, and a warehouse center large-screen monitoring data processing function module.
In a preferred embodiment of the present invention, the monitoring display function module includes a main screen display module and a sub-screen display module.
In a preferred embodiment of the present invention, the operational data store can be used to provide data required for displaying detailed reports of materials management.
In a preferred embodiment of the present invention, the processing of the material management data by the data center at least includes data extraction, data cleaning, data conversion, and data loading.
In a preferred embodiment of the present invention, the metadata management of the data warehouse includes the establishment of metadata, the integration of technical metadata, the integration of business metadata, impact and dependency analysis, and the update and maintenance of metadata.
In a preferred embodiment of the present invention, the data warehouse stores data in a hierarchy, including a source layer, a history storage layer, and a data model layer.
Compared with the prior art, the invention has the beneficial effects that:
the method has the advantages that the full-flow service data of the material supply chain is comprehensively integrated and communicated, and intelligent monitoring and early warning reminding of key indexes are realized; the whole intelligent monitoring and early warning system for material supply solves the problems of material management data, particularly the situations of data dispersion and lack of comprehensive application of rated material allocation management data, and utilizes an ETL (extract transform load) technology to realize the comprehensive analysis, processing and comprehensive application of the dispersed data of each service system, so as to provide real and timely data support for management decision, and assist decision makers to more efficiently manage and control important information and detail levels of material management, particularly each link of rated material allocation.
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
FIG. 1 is a schematic block diagram of a logic architecture of an intelligent monitoring and early warning system for material supply according to the present invention;
FIG. 2 is a block diagram of the functional architecture of the intelligent monitoring and early warning system for material supply according to the present invention;
fig. 3 is a schematic block diagram of a data architecture of the intelligent monitoring and early warning system for material supply according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, 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 some, but not all, embodiments of the present invention. The components of embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. 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.
Referring to fig. 1, fig. 2 and fig. 3, the present invention provides an intelligent monitoring and early warning system for material supply, including:
a data source for providing material management data;
the data center processes the material management data based on the ETL technology, and stores material management intermediate data in the processing process and finally obtained material management result data;
and the data application module is used for displaying the material management result data to the user and realizing the monitoring and early warning of the user on the material management data.
In this embodiment, the data sources include a material system, an electronic commerce system, a demand forecasting system, an investment planning system, a production system, a capital construction management system, and a financial system. In addition, material management data can be imported from other business systems, and all these systems providing data for the decision support system form data sources in the basic data architecture.
In the embodiment, the storage module of the data center comprises three levels of storage modes of operation type data storage, data warehouse and data mart according to the granularity and data category of the data storage.
Wherein, the detailed material management data is stored in the ODS (operation type data storage) according to the data subject model in a form conforming to a three-level normal form before being processed and loaded into the data warehouse. The ODS stores source data provided by the service system, and the stored data are basically consistent with the source system, so that data integration and processing are facilitated. The ODS is an important functional area in the operation and control of the material domain, is used as a buffer area before data enters a data warehouse area, integrates various types of data from a material management system database, and can be used as a data source for displaying detailed reports.
In this embodiment, the data repository area is a centralized, integrated data storage area that is specifically organized for enterprise data integration and data history storage needs. The data warehouse is composed of enterprise information covering a plurality of subject domains, the information is mainly low-level and fine-grained data, and meanwhile, certain-grained summarized data can be established according to data analysis requirements. They are updated periodically at a certain frequency, primarily to provide integrated, high quality data for the data marts. Data warehouses focus on the storage and integration of data, typically employ lightweight indexes, and are generally rarely directed towards end users.
Data in the data warehouse area are stored according to the theme, the granularity of the data is consistent with that of the ODS buffer area or is thicker than that of the buffer area, the data are mainly enterprise-level data and historical information, and the period of online storage of the data is generally longer. The data of the data warehouse area is formed by integrating the data of the ODS buffer area according to the requirements of the data warehouse model.
In this embodiment, a material domain operation control data mart is established according to the service requirement of material domain operation control, and the data of the data mart is directly from the data warehouse. In this way, overall data consistency can be maintained.
In this embodiment, the process of processing the material management data by the data center includes:
data extraction, which supports the direct connection mode of a database to extract data or extract data from text files
And (4) data cleaning, namely cleaning and confirming the data through an ETL tool so as to enable the data to meet the data standard and quality required by a data warehouse.
And data conversion, namely performing data conversion and calculation work through an ETL tool.
And data loading, namely completing data loading work from a data source to an ODS layer, an ODS layer to a DW layer and a DW layer to a DM layer through an ETL tool.
And a data transmission condition report is obtained by feeding back the data loading condition to an ETL manager and related personnel in charge of data uploading in an Email mode.
The data warehouse metadata management platform provides high-quality, accurate and easily managed data for users, provides support for converting the data into knowledge, and runs through the whole life cycle of data warehouse construction, operation and maintenance. Meanwhile, in the whole process of constructing the data warehouse, such as data source analysis, an ETL process, a database structure, a data model, organization and front-end display of business application topics, strong support for corresponding metadata is required. The lifecycle of metadata management includes metadata acquisition and establishment, metadata storage, metadata browsing, metadata analysis, metadata maintenance and the like.
The data warehouse stores data according to a hierarchy and comprises a source layer, a history storage layer and a data model layer.
Valuable data can be extracted by data extraction, the repeated use of resources when in use is avoided, computing resources are wasted, data are stored, a service database is stored in a time range, newly-added data are changed by data transmission, ODS can store the data, the data are stored in an MID layer through a snapshot merging mode, the latest and complete version of the data are obtained by an ODS layer data computer after a certain time, then the MID layer is modeled and merged to a DW layer, the data can be simplified and processed after the MID layer is abstracted and merged with a service model, on one hand, the data source of a data warehouse can be guaranteed to be accurate, on the other hand, the data can be checked in time when problems occur, on the other hand, historical data can be extracted and stored in a targeted manner through two modes of ODS for an extraction source system, when historical data is stored, incremental slicing, full slicing and a linked list can be performed, so that accurate availability of the data, data history checkability and data safety performance can be realized.
In this embodiment, the data warehouse metadata management includes the following key components:
1) and (3) establishing metadata: technical metadata mainly come from various application software, models, ETL and the like, and data models, conversion rules, scheduling processes and analysis models defined by developers are reflected in a metadata mode; the service metadata is mainly from service knowledge and is collected in the form of external files.
2) Integration of technical metadata: integrated management can be achieved for the metadata of the various components of the data warehouse database, ETL, etc.
3) Integration of service metadata: besides independent business metadata query, metadata definition and calculation methods can be searched through report elements in various analysis reports. The user can conveniently refer to the metadata information of the service element while performing service analysis.
4) Impact and dependency analysis: the influence of any change on other parts is found from the metadata, and the purpose and the association of one entity with other entities are determined. The influence of the change of the data source on the ODS model can be analyzed by performing forward analysis from the change of the data source, or the source data model used by the ODS model can be analyzed by performing backward analysis from the ODS model. Dependencies between metadata can be graphically represented.
5) Updating and maintaining metadata: the user can conveniently update and manage the metadata.
In this embodiment, quota material allocation is used as a service core, key indexes and application scenes of the whole process of material management are comprehensively integrated, comprehensive material management data display is realized through a large-screen visual application technology, and panoramic monitoring and query display of quota material data are realized through data integration and communication of quota materials in logistics treasures, a material system and a contract management system. The whole material supply intelligent monitoring and early warning system solves the problems of material management data, particularly the situations of data dispersion and lack of comprehensive application of rated material allocation management data, provides real and timely data support for management decision, and assists decision makers to more efficiently manage and control important information and detail levels of material management, particularly each link of rated material allocation.
According to different requirements, different technical means and display methods can be adopted to display data to users, and decision analysis is achieved. In this embodiment, as shown in fig. 2, the data application module includes a monitoring display function module, a warehouse scheduling platform display function module, and a material center large-screen monitoring data processing function module, and the material center large-screen monitoring data processing function module includes a purchasing center large-screen monitoring data processing function module, and a warehouse center large-screen monitoring data processing function module.
The monitoring display function module comprises a main screen display module and a sub-screen display module.
In this embodiment, the end users of the data analysis result include a headquarters user and users of each molecular company, each level of users can access the portal site of the system, and each user can access information such as various indexes, reports, dashboards and the like by logging in the portal site deployed at one level of the headquarters.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (9)
1. The utility model provides a goods and materials supply intelligent monitoring early warning system which characterized in that includes:
a data source for providing material management data;
the data center processes the material management data based on an ETL technology, and stores material management intermediate data in the processing process and finally obtained material management result data;
and the data application module is used for displaying the material management result data to a user and realizing the monitoring and early warning of the user on the material management data.
2. The intelligent monitoring and early warning system for material supply according to claim 1, wherein the data source comprises a material system, an electronic commerce system, a demand forecasting system, an investment planning system, a production system, a capital construction management system and a financial system.
3. The intelligent monitoring and early warning system for material supply according to claim 1, wherein the storage module of the data center comprises three levels of storage modes of an operation type data storage, a data warehouse and a data mart according to the granularity and the data category of the data storage.
4. The intelligent monitoring and early warning system for material supply according to claim 3, wherein the data application module comprises a monitoring display function module, a warehouse scheduling platform display function module and a material center large-screen monitoring data processing function module, and the material center large-screen monitoring data processing function module comprises a purchasing center large-screen monitoring data processing function module and a warehouse center large-screen monitoring data processing function module.
5. The intelligent monitoring and early warning system for material supply according to claim 4, wherein the monitoring and displaying function module comprises a main screen display module and a sub-screen display module.
6. The intelligent monitoring and early warning system for material supply according to claim 3, wherein the operational data storage can be used for providing data required for showing detailed reports of material management.
7. The intelligent monitoring and early warning system for material supply according to claim 3, wherein the processing process of the material management data by the data center at least comprises data extraction, data cleaning, data conversion and data loading.
8. The intelligent monitoring and early warning system for material supply according to claim 7, wherein the metadata management of the data warehouse comprises establishment of metadata, integration of technical metadata, integration of business metadata, influence and dependence analysis and updating and maintenance of metadata.
9. The intelligent monitoring and early warning system for material supply according to claim 8, wherein the data warehouse stores data according to a hierarchy, and comprises a source layer, a history storage layer and a data model layer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110778324.8A CN113592435A (en) | 2021-07-09 | 2021-07-09 | Intelligent monitoring and early warning system for material supply |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110778324.8A CN113592435A (en) | 2021-07-09 | 2021-07-09 | Intelligent monitoring and early warning system for material supply |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113592435A true CN113592435A (en) | 2021-11-02 |
Family
ID=78246621
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110778324.8A Pending CN113592435A (en) | 2021-07-09 | 2021-07-09 | Intelligent monitoring and early warning system for material supply |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113592435A (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108280532A (en) * | 2017-09-02 | 2018-07-13 | 国网辽宁省电力有限公司 | A kind of improved power equipment asset management system and method |
| CN112732823A (en) * | 2020-12-30 | 2021-04-30 | 福建正孚软件有限公司 | Method for realizing enterprise material supply whole process monitoring system |
-
2021
- 2021-07-09 CN CN202110778324.8A patent/CN113592435A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108280532A (en) * | 2017-09-02 | 2018-07-13 | 国网辽宁省电力有限公司 | A kind of improved power equipment asset management system and method |
| CN112732823A (en) * | 2020-12-30 | 2021-04-30 | 福建正孚软件有限公司 | Method for realizing enterprise material supply whole process monitoring system |
Non-Patent Citations (1)
| Title |
|---|
| 张艳玲: "基于数据仓库的数据分析在物资管理中的应用", 《物流工程与管理》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9536225B2 (en) | Aggregating business analytics architecture and configurator | |
| Rujirayanyong et al. | A project-oriented data warehouse for construction | |
| CN104615617A (en) | Dispatch monitoring information processing system for substation equipment | |
| Schiefer et al. | Management and controlling of time-sensitive business processes with sense & respond | |
| Li et al. | Entity-relationship diagram | |
| Abd-Elfattah et al. | Dashboard technology based solution to decision making | |
| Vieira et al. | On the use of simulation as a Big Data semantic validator for supply chain management | |
| CN115496337A (en) | Data system for supporting brain of enterprise | |
| Nagabhushana | Data warehousing OLAP and data mining | |
| Brusakova | Metrics for Cognitive Management of IT Services | |
| CN113592435A (en) | Intelligent monitoring and early warning system for material supply | |
| Stefanovic et al. | Developing adaptive business intelligence systems for agile supply chain analytics | |
| Seah et al. | The Significance of Technology in Digitalising Malaysia Industries | |
| Mutschler et al. | An approach to quantify the costs of business process intelligence | |
| Madhikerrni et al. | Data discovery method for Extract-Transform-Load | |
| Stefanovic et al. | A review of advances in supply chain intelligence | |
| Ji et al. | Modeling of image, video and text fusion quality data packet system for aerospace complex products based on business intelligence | |
| Luckham et al. | Why Companies Should Develop Event Models | |
| Wu et al. | Research on decision support system of automobile service based on distributed data warehouse | |
| Ballard et al. | Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC | |
| JP7533041B2 (en) | Information processing device, information processing method, and program | |
| Davis | The business value of semantic technologies | |
| Florea | Business process management solutions performance tuning and configuration | |
| Kulikov et al. | Method of Designing a Software Analytical Complex Based on a Cartesian Closed Category Using Virtual Objects | |
| Mirabel et al. | Conceptual Framework for Efficient Inbound Supply Chain Analytics |
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 |