CN112231371A - Configurable report generation method and system based on engineering machinery big data - Google Patents

Configurable report generation method and system based on engineering machinery big data Download PDF

Info

Publication number
CN112231371A
CN112231371A CN202011102539.XA CN202011102539A CN112231371A CN 112231371 A CN112231371 A CN 112231371A CN 202011102539 A CN202011102539 A CN 202011102539A CN 112231371 A CN112231371 A CN 112231371A
Authority
CN
China
Prior art keywords
report
engineering machinery
service type
information
big data
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
Application number
CN202011102539.XA
Other languages
Chinese (zh)
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.)
China Power Industry Internet Co ltd
Original Assignee
China Power Industry Internet 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 China Power Industry Internet Co ltd filed Critical China Power Industry Internet Co ltd
Priority to CN202011102539.XA priority Critical patent/CN112231371A/en
Publication of CN112231371A publication Critical patent/CN112231371A/en
Pending legal-status Critical Current

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/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Fuzzy Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a configurable report generation method and a system based on engineering machinery big data, wherein the method comprises the following steps: establishing a report unit set containing various report units, and acquiring a report request, wherein the report request comprises service type information and query condition information; associating the service type information with the query condition information to generate service configuration attribute information with the service type as a label; selecting a report unit based on the service configuration attribute information, and generating a report page; acquiring big data of the engineering machinery based on the service type information and the query condition information to obtain a result data set; and displaying the result data set to a report page and outputting the result data set. The report data of big data acquisition and analysis can be automatically displayed in a configurable mode aiming at the business data statistical report needed by the engineering machinery industry, the development efficiency of the statistical analysis report of the engineering machinery industry can be improved, the development amount of repeated codes is reduced, and the code reusability is improved.

Description

Configurable report generation method and system based on engineering machinery big data
Technical Field
The invention relates to the technical field of engineering machinery data processing, in particular to a configurable report generation method and a configurable report generation system based on engineering machinery big data.
Background
At present, with the development of industrial internet, the informatization requirement of the engineering machinery industry is higher and higher, real-time and historical operation report data such as oil consumption, working time, engine load, water temperature and oil temperature of machinery need to be collected in real time, intelligent analysis is carried out through big data technology to give a report display, and powerful support is provided for managers to make decisions. However, the conventional reporting system is difficult to completely meet the requirements of the engineering machinery industry, so that developers are led to develop multiple sets of reporting systems according to the needs of the engineering machinery industry, the development and maintenance costs are high, and the data analysis effect is poor.
Because the traditional reporting system is that each manufacturer in the engineering machinery industry needs to develop one or more sets of reporting systems, and one set of reporting system is made for different engineering machinery equipment or manufacturers, the developers need to develop and maintain the reporting systems at the same time, and the multiple sets of reporting systems are used, so that the enterprise development and maintenance cost is high, and the user experience is not good. In addition, the existing technologies are that manufacturers of enterprises in the engineering machinery industry act on the basis of each other, respective business report systems are independently developed, the configurability of report templates can only be realized, and the expandability and the mobility are poor. The requirements of various equipment types, complex service, high data analysis requirement and the like in the current engineering machinery industry cannot be met. In addition, the report system is not directly combined with big data at present, collected and analyzed data are stored in a database table through a big data technology, and the report system reads the data from the database table for displaying.
Disclosure of Invention
Aiming at the defects in the prior art, the invention provides a configurable report generation method and a configurable report generation system based on engineering machinery big data, which are integrated with a big data technology, can automatically display report data acquired and analyzed by big data in a configurable mode aiming at a business data statistical report required by the engineering machinery industry, can improve the development efficiency of the statistical analysis report of the engineering machinery industry, reduce the development amount of repeated codes, improve the code reusability, and can improve the data analysis efficiency of the report by acquiring and analyzing the data through the big data technology.
In order to achieve the above object, the present invention provides a configurable report generating method based on engineering machinery big data, which comprises the following steps:
step 1, establishing a report unit set containing various report units, and acquiring a report request, wherein the report request comprises service type information and query condition information;
step 2, associating the service type information with the query condition information to generate service configuration attribute information with the service type as a label;
step 3, selecting a report unit based on the service configuration attribute information, and generating a report page;
step 4, large data acquisition is carried out on the engineering machinery based on the service type information and the query condition information, and a result data set is obtained;
and 5, displaying the result data set to a report page and outputting the result data set.
In one embodiment, in step 1, the report unit includes, but is not limited to, a line graph component, a bar graph component, and a pie graph component.
In one embodiment, in step 1, the service type information includes, but is not limited to, an operating duration, a fuel consumption, an engine load, and a volume.
In one embodiment, in step 1, the query condition information includes, but is not limited to, a device type, a device number, a running start time, and a running end time.
In one embodiment, in step 2, the association relationship between the service type information and the query condition information is one-to-many or many-to-many, where the many-to-many association is implemented by a tag configuration technique in the mapping file.
In order to achieve the above object, the present invention further provides a configurable report generating system based on engineering machinery big data, including:
the information acquisition module is used for acquiring a report request, wherein the report request comprises service type information and query condition information;
the information correlation module is used for correlating the service type information with the query condition information to generate service configuration attribute information with the service type as a label;
the big data query module is used for carrying out big data acquisition on the engineering machinery according to the service type information and the query condition information to obtain a result data set;
the report page generating module is used for selecting a report unit according to the service configuration attribute information and generating a report page;
and the report display module is used for receiving the result data set, importing the result data set into a report page and displaying the result data set.
Compared with the prior art, the configurable report generation method and system based on the engineering machinery big data have the following beneficial effects:
1. configuring based on the business of the engineering machinery industry, flexibly collocating and associating the business type with the business query condition, and then carrying out configurable combination with the configurable report template after association; therefore, the complex business technology and the report technology are encapsulated, the development difficulty in the later period can be reduced, the development effect can be improved, and the reusability and the expandability of the report method and the report system in the engineering machinery industry can also be effectively improved;
2. the method combines the big data technology directly with the report method and system, can directly depend on the data source of the report on the big data module, and provides effective support for displaying the real-time data report in the engineering machinery industry.
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 some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the structures shown in the drawings without creative efforts.
FIG. 1 is a schematic flow chart of a configurable report generation method based on big data of engineering machinery in an embodiment of the present invention;
fig. 2 is a schematic block diagram of a configurable report generation method based on engineering machinery big data in the embodiment of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
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.
It should be noted that all the directional indicators (such as up, down, left, right, front, and rear … …) in the embodiment of the present invention are only used to explain the relative position relationship between the components, the movement situation, etc. in a specific posture (as shown in the drawing), and if the specific posture is changed, the directional indicator is changed accordingly.
In addition, the descriptions related to "first", "second", etc. in the present invention are only for descriptive purposes and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present invention, "a plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.
In the present invention, unless otherwise expressly stated or limited, the terms "connected," "secured," and the like are to be construed broadly, and for example, "secured" may be a fixed connection, a removable connection, or an integral part; the connection can be mechanical connection, electrical connection, physical connection or wireless communication connection; they may be directly connected or indirectly connected through intervening media, or they may be connected internally or in any other suitable relationship, unless expressly stated otherwise. The specific meanings of the above terms in the present invention can be understood by those skilled in the art according to specific situations.
In addition, the technical solutions in the embodiments of the present invention may be combined with each other, but it must be based on the realization of those skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination of technical solutions should not be considered to exist, and is not within the protection scope of the present invention.
Fig. 1 shows a configurable report generating method based on big data of engineering machinery disclosed in this embodiment, which includes the following steps:
step 1, establishing a report unit set containing various report units, and acquiring a report request, wherein the report request comprises service type information and query condition information. Wherein, the report unit is a line graph component, a bar graph component, a pie graph component and the like; the service type information is the service type of the engineering machinery industry, such as working duration, oil consumption, engine load, volume and the like; the query condition information is a service query condition of the engineering machinery industry, such as equipment type, equipment number, operation starting time, operation ending time and the like.
And 2, associating the service type information with the query condition information to generate service configuration attribute information with the service type as a label. The association relationship between the service type information and the query condition information is a one-to-many association relationship or a many-to-many association relationship, for example, the working duration can be associated with the device type and the device number; the fuel consumption may be associated with a device type, an operation start time, and an operation end time. And storing the service type information and the query condition information into a file to form a mapping file, and realizing many-to-many association by a tag configuration technology in the mapping file. .
Step 3, the business configuration attribute information with the business type as the label generated by associating the business type information with the query condition information can be directly combined with a report unit to generate a report page of the corresponding business;
and 4, carrying out big data acquisition on the engineering machinery based on the service type information and the query condition information to obtain a result data set. Specifically, the method comprises the following steps: and importing the service type information and the query condition information into a big data query module, wherein the big data query module firstly matches a data acquisition terminal according to the service type information, then carries out data acquisition and data analysis according to the query condition, and finally returns the acquired and analyzed data as a result data set.
And 5, displaying the result data set to a report page and outputting the result data set.
The report generation method in the embodiment is integrated with the big data technology, can automatically display report data of big data collection and analysis in a configurable mode aiming at the business data statistical report needed by the engineering machinery industry, can improve the development efficiency of the statistical analysis report of the engineering machinery industry, reduces the development amount of repeated codes, improves the code reusability, and can improve the data analysis efficiency of the report by collecting and analyzing the data through the big data technology.
The report generation method in the embodiment is configured based on the business of the engineering machinery industry, flexibly matches and associates the business type with the business query condition, and then performs configurable combination with the configurable report template after association; therefore, the complex business technology and the report technology are packaged, the development difficulty in the later period can be reduced, the development effect can be improved, and the reusability and the expandability of the report method and the report system in the engineering machinery industry can also be effectively improved. The method combines the big data technology directly with the report method and system, can directly depend on the data source of the report on the big data query module, and provides effective support for real-time data report display in the engineering machinery industry.
The report generation in the present embodiment is further described below with reference to specific examples.
1. Firstly, a common public report unit set is established based on Echarts, and a line graph component LineA and a bar graph component BarA are established.
2. Selecting a working time report page worktimes, selecting a line graph component LineA to display daily working time statistics, and selecting a bar graph component BarA to display monthly working time statistics.
3. And acquiring service type information and adding a service type working time worktimetype.
4. Acquiring query condition information, wherein query condition items comprise: the device type: deviceType; the operation start time: startTime; end time of operation: endTime.
5. According to the service type working time worktype and the query condition device type deviceType, operating a start time startTime and an end time running for correlation, taking out the worktimetype, deviceType, startTime and end time, and generating a mapping file according to the associable relation rule, wherein the generated mapping file comprises a service type tag name btype, and the attribute under the btype tag comprises the worktimetype; and querying a conditional tag name bquery, wherein the attributes under the bquery tag comprise deviceType, startTime and endTime. And then, realizing the association operation between the service type label btype and the query condition label bquery through the label configuration in the mapping file, and forming the service configuration attribute information with the service type of worktimetype _ property.
6. And selecting report page worktimes, selecting service type information worktime _ property, and generating a working time statistical report page. When the service type information is selected by default, the service type is selected to be associated with all query condition items, and the selection items can be modified manually.
7. The operation user inputs query conditions and equipment types in the page of the working time statistical form: a pump truck; the operation start time: 2019-01-01; end time of operation: 2019-09-05, and forming a conditional instruction query _ worktimetype after the condition is output.
8. And clicking the query, and sending a query condition instruction query _ worktimetype to the big data query module by the report module.
9. And the big data query module receives a query condition instruction query _ worktimetype and analyzes the instruction into specific items of the service type and the query condition.
10. And the big data query module matches the acquisition terminal number 256 through the service type working time worktimetype obtained after disassembly.
11. The big data query module acquires device data with three conditions of deviceType ═ pump truck, startTime ═ 2019-01-01, endTime ═ 2019-09-05 and the like which are simultaneously satisfied from the terminal with the terminal number 256 according to query conditions, and stores the device data as resultA.
12. And the big data query module performs data analysis on the collected resultants, performs statistical analysis on the collected resultants by day and month respectively to obtain result data sets resultday and resultmonth, and encapsulates the result data sets to be stored as result.
13. And the big data query module returns the final result of the acquisition and analysis to the report page.
14. The report page disassembles the received data result set result according to a display mode required by the working time statistical report page, for example, resultday data is displayed on a LineA report component of the report page, is represented by a line graph, resultmonth data is displayed on a BarA report component of the report page, is represented by a bar graph, and the like, so that an integral working time statistical report page with data is finally formed.
15. The operator can export or print the data through the working time statistics report page.
Fig. 2 shows a configurable report generating system based on big data of engineering machinery disclosed in this embodiment, including:
the information acquisition module is used for acquiring a report request, wherein the report request comprises service type information and query condition information;
the information correlation module is used for correlating the service type information with the query condition information to generate service configuration attribute information with the service type as a label;
the big data query module is used for carrying out big data acquisition on the engineering machinery according to the service type information and the query condition information to obtain a result data set;
the report page generating module is used for selecting a report unit according to the service configuration attribute information and generating a report page;
and the report display module is used for receiving the result data set, importing the result data set into a report page and displaying the result data set.
The above description is only a preferred embodiment of the present invention, and is not intended to limit the scope of the present invention, and all modifications and equivalents of the present invention, which are made by the contents of the present specification and the accompanying drawings, or directly/indirectly applied to other related technical fields, are included in the scope of the present invention.

Claims (6)

1. A configurable report generation method based on big data of engineering machinery is characterized by comprising the following steps:
step 1, establishing a report unit set containing various report units, and acquiring a report request, wherein the report request comprises service type information and query condition information;
step 2, associating the service type information with the query condition information to generate service configuration attribute information with the service type as a label;
step 3, selecting a report unit based on the service configuration attribute information, and generating a report page;
step 4, large data acquisition is carried out on the engineering machinery based on the service type information and the query condition information, and a result data set is obtained;
and 5, displaying the result data set to a report page and outputting the result data set.
2. The configurable report generation method based on big data of engineering machinery according to claim 1, wherein in step 1, the report units include, but are not limited to, a line graph component, a bar graph component, and a pie graph component.
3. The configurable report generation method based on big data of engineering machinery according to claim 1, wherein in step 1, the service type information includes, but is not limited to, working duration, oil consumption, engine load, and volume.
4. The configurable report generation method based on big data of engineering machinery according to claim 1, wherein in step 1, the query condition information includes, but is not limited to, equipment type, equipment number, operation start time, and operation end time.
5. The configurable report generation method based on big data of engineering machinery according to claim 1, 2, 3 or 4, characterized in that in step 2, the correlation between the service type information and the query condition information is one-to-many or many-to-many, wherein the many-to-many correlation is implemented by a tag configuration technology in the mapping file.
6. A configurable report generation system based on big data of engineering machinery is characterized by comprising:
the information acquisition module is used for acquiring a report request, wherein the report request comprises service type information and query condition information;
the information correlation module is used for correlating the service type information with the query condition information to generate service configuration attribute information with the service type as a label;
the big data query module is used for carrying out big data acquisition on the engineering machinery according to the service type information and the query condition information to obtain a result data set;
the report page generating module is used for selecting a report unit according to the service configuration attribute information and generating a report page;
and the report display module is used for receiving the result data set, importing the result data set into a report page and displaying the result data set.
CN202011102539.XA 2020-10-15 2020-10-15 Configurable report generation method and system based on engineering machinery big data Pending CN112231371A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011102539.XA CN112231371A (en) 2020-10-15 2020-10-15 Configurable report generation method and system based on engineering machinery big data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011102539.XA CN112231371A (en) 2020-10-15 2020-10-15 Configurable report generation method and system based on engineering machinery big data

Publications (1)

Publication Number Publication Date
CN112231371A true CN112231371A (en) 2021-01-15

Family

ID=74113104

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011102539.XA Pending CN112231371A (en) 2020-10-15 2020-10-15 Configurable report generation method and system based on engineering machinery big data

Country Status (1)

Country Link
CN (1) CN112231371A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113626477A (en) * 2021-07-19 2021-11-09 浙江浙大中控信息技术有限公司 Configurable reporting system and method based on water plant Internet of things system
CN114116826A (en) * 2022-01-26 2022-03-01 树根互联股份有限公司 Index calculation system for working condition of Internet of things equipment

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105550941A (en) * 2015-12-16 2016-05-04 国家电网公司 Communication system device and running mode analysis evaluation method
CN107085932A (en) * 2017-04-24 2017-08-22 华南理工大学 Big data collector and its operation method remotely configurable under a kind of manufacturing environment
US20170277708A1 (en) * 2016-03-22 2017-09-28 Tata Consultancy Services Limited Systems and methods for de-normalized data structure files based generation of intelligence reports
CN107391652A (en) * 2017-07-17 2017-11-24 山东浪潮通软信息科技有限公司 A kind of templating form interface defines system and method
CN108984506A (en) * 2018-08-01 2018-12-11 北京中电普华信息技术有限公司 A kind of generation method and device of configurable intelligent report forms
CN110769070A (en) * 2019-10-31 2020-02-07 中电工业互联网有限公司 Configurable alarm method, system and storage medium based on Internet of things

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105550941A (en) * 2015-12-16 2016-05-04 国家电网公司 Communication system device and running mode analysis evaluation method
US20170277708A1 (en) * 2016-03-22 2017-09-28 Tata Consultancy Services Limited Systems and methods for de-normalized data structure files based generation of intelligence reports
CN107085932A (en) * 2017-04-24 2017-08-22 华南理工大学 Big data collector and its operation method remotely configurable under a kind of manufacturing environment
CN107391652A (en) * 2017-07-17 2017-11-24 山东浪潮通软信息科技有限公司 A kind of templating form interface defines system and method
CN108984506A (en) * 2018-08-01 2018-12-11 北京中电普华信息技术有限公司 A kind of generation method and device of configurable intelligent report forms
CN110769070A (en) * 2019-10-31 2020-02-07 中电工业互联网有限公司 Configurable alarm method, system and storage medium based on Internet of things

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113626477A (en) * 2021-07-19 2021-11-09 浙江浙大中控信息技术有限公司 Configurable reporting system and method based on water plant Internet of things system
CN113626477B (en) * 2021-07-19 2023-10-10 浙江中控信息产业股份有限公司 Configurable report system and method based on water plant Internet of Things system
CN114116826A (en) * 2022-01-26 2022-03-01 树根互联股份有限公司 Index calculation system for working condition of Internet of things equipment

Similar Documents

Publication Publication Date Title
CN108090073A (en) A kind of conversion method and device of configurable bill of materials
CN112231371A (en) Configurable report generation method and system based on engineering machinery big data
CN109800250B (en) System architecture for no longer configuring enterprise central server
CN107545093B (en) The technological design and assembly of spacecraft execute interactive system and exchange method
CN105182935A (en) Product production control system and control method
CN111915366A (en) User portrait construction method and device, computer equipment and storage medium
EP3042345A2 (en) Methods and systems for generating baselines regarding vehicle service request data
CN103020339A (en) Method for implementing combined automobile circuit diagrams
CN111538775A (en) Train running state data analysis method and system and rail transit vehicle
CN111522735A (en) Shunting method and device for test experiment
CN101169655A (en) Process control system
CN110795406A (en) Service file transmission method, device, system and storage medium
CN108197310B (en) Industrial part management method and device based on big data
CN111401023B (en) Report generation method, report generation device, server and storage medium
CN112559514B (en) Information processing method and system
CN116743790B (en) Device data acquisition, device data analysis method and device and computer device
CN115794804A (en) Engineering internal control data visualization processing system and method based on big data technology
CN103577613A (en) Demonstration method and demonstration device for service interaction relationship data
US20050049982A1 (en) Systems and methods for managing distributed design chains
CN115062051A (en) Universal assembly cross-database language query method and system
CN114969031A (en) Visual data display method and related device
CN113190587A (en) Data processing method and device for realizing service data processing
CN111160876A (en) Internet of things identification analysis information input method based on input equipment identity
CN109766965B (en) Implementation method of RFID supply chain data calculation framework
CN102402506A (en) Rural circulation price data exchange engine

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20210115