CN107861933A - The method and apparatus for generating O＆M form - Google Patents
The method and apparatus for generating O＆M form Download PDFInfo
- Publication number
- CN107861933A CN107861933A CN201711224277.2A CN201711224277A CN107861933A CN 107861933 A CN107861933 A CN 107861933A CN 201711224277 A CN201711224277 A CN 201711224277A CN 107861933 A CN107861933 A CN 107861933A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- template
- point position
- control point
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- 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/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Computing Systems (AREA)
- Computer Security & Cryptography (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
This application discloses a kind of method and apparatus for generating O＆M form.Method includes：Receive report generation instruction；Obtain the corresponding report form template of report generation instruction；Report form type and data characteristics based on report form template, the monitoring data of control point position is regularly obtained from distributed memory system；Based on report form template and monitoring data, form is presented.In the method, the acquisition of report data is all to be obtained by timed task from distributed memory system, error is minimum, it ensure that the uniformity of report data and ageing, and current platform is disposed by distributed way, the stability of service is ensure that, live O＆M can be supported High Availabitity, is managed collectively and safeguards the report data of all self-built data centers.
Description
Technical field
The application is related to field of computer technology, and in particular to technical field of the computer network, more particularly to generation O＆M
The method and apparatus of form.
Background technology
Large-Scale Interconnected network technology enterprise generally possesses multiple self-built data centers, and the scale of data center is increasingly
Greatly, hundreds of millions of monitoring, operation/maintenance data are produced daily.Demand of the O＆M report data for different pieces of information center to form,
Being customized is realized, data center's present mode of operation is intuitively presented, and provides data supporting to policymaker.
Current report form type, integral point form, power consumption detail form are roughly divided into, wherein integral point form is by live O＆M
Personnel enter pedestrian in each integral point time to a position data (abbreviation of data center control point, namely report data monitoring source)
Work data preparation and making, power consumption detail form are then that the data in ten two points daily of night on the day of carry out manual sorting
And making.
The content of the invention
The embodiment of the present application proposes a kind of method and apparatus for generating O＆M form.
In a first aspect, the embodiment of the present application provides a kind of method for generating O＆M form, including：Report generation is received to refer to
Order；Obtain the corresponding report form template of report generation instruction；Report form type and data characteristics based on report form template, regularly from point
The monitoring data of control point position is obtained in cloth storage system；Based on report form template and monitoring data, form is presented.
In certain embodiments, report form type and data characteristics based on report form template, the monitoring number of control point position is obtained
According to including：Key word of the inquiry in response to receiving user's input, report form type and data characteristics based on report form template, acquisition
The monitoring data of control point position with key word of the inquiry；Instructed in response to the modification for receiving user's input, modification matching inquiry closes
The monitoring data of the control point position of key word；Report form type and data characteristics based on report form template, obtain amended control point
The monitoring data of position.
In certain embodiments, report form template inputs generation based on the user for meeting following rule：The of every page in Excel
One behavior is empty, explanation or date data and can not include a point position keyword；Formula is supported, and last of every page is classified as formula；
Every page second from the bottom is classified as a position keyword；Run the point position for being manually entered data and being separately configured.
In certain embodiments, method also includes：Receive the setting operation to the data threshold of control point position；According to setting
Operation, set data threshold；Exceed data threshold in response to the data of control point position, control point position is presented using predetermined color.
In certain embodiments, obtaining the corresponding report form template of report generation instruction includes：Obtained from MySQL database
Take the report form template that parsing is completed using PhpExcel storehouses；And/or via mutually redundant data platform HDP and the integration number of increasing income
The corresponding report form template of report generation instruction is obtained according to one of warehouse IDW.
In certain embodiments, method also includes：Receive the form of the Execl forms uploaded；Store the Execl lattice uploaded
The form of formula.
In certain embodiments, based on report form template and monitoring data, form, which is presented, to be included：Based on report form template and monitoring
Data, form is presented in a manner of Execl or Web page form.
In certain embodiments, based on report form template and monitoring data, in a manner of Execl forms or Web page form
Form, which is presented, to be included：Data center's power consumption detail form is presented in a manner of excel forms；In a manner of Web page form
Data center's integral point form is presented.
In certain embodiments, Web page form supports multiple data centers, the integral point report data at multiple moment to look into
Ask.
In certain embodiments, Web page form is realized following one or more using integral point report component：In response to connecing
Fold and instruct, merge selected cell；In response to receiving contrast instruction, selected cell is contrasted；In response to connecing
Export instruction is received, exports selected data content；In response to receiving picture download instruction, selected picture is downloaded.
Second aspect, the embodiment of the present application provide a kind of device for generating O＆M form, including：Instruction reception unit,
For receiving report generation instruction；Template acquiring unit, the report form template corresponding for obtaining report generation instruction；Data obtain
Unit is taken, for report form type and data characteristics based on report form template, control point is regularly obtained from distributed memory system
The monitoring data of position；Form display unit, for based on report form template and monitoring data, form to be presented.
In certain embodiments, data capture unit includes：Keyword query unit, in response to receiving user's input
Key word of the inquiry, report form type and data characteristics based on report form template, obtain the control point position of matching inquiry keyword
Monitoring data；Monitoring data changes unit, for being instructed in response to the modification for receiving user's input, changes matching inquiry keyword
Control point position monitoring data；Data capture unit is changed, for report form type and data characteristics based on report form template, is obtained
Take the monitoring data of amended control point position.
In certain embodiments, the report form template in template acquiring unit inputs life based on the user for meeting following rule
Into：Every page of the first behavior is empty in Excel, explanation or date data and can not include a point position keyword；Support formula, and every page
Last be classified as formula；Every page second from the bottom is classified as a position keyword；Run the point for being manually entered data and being separately configured
Position.
In certain embodiments, device also includes：Receiving unit is operated, for receiving to the data threshold of control point position
Setting operation；Threshold setting unit, for according to setting operation, setting data threshold；Color display unit, in response to prison
The data of control point position exceed data threshold, and control point position is presented using predetermined color.
In certain embodiments, template acquiring unit is further used for：Obtained from MySQL database and use PhpExcel
Complete the report form template of parsing in storehouse；And/or via mutually redundant one of the data platform HDP and integral data warehouse IDW of increasing income
Obtain the corresponding report form template of report generation instruction.
In certain embodiments, device also includes：Form receiving unit, for receiving the form of the Execl forms uploaded；
Form memory cell, for storing the form of the Execl forms uploaded.
In certain embodiments, form display unit is further used for：Based on report form template and monitoring data, with Execl
Or form is presented in the mode of Web page form.
In certain embodiments, in form display unit based on report form template and monitoring data, with Execl forms or
Form, which is presented, in the mode of Web page form includes：Data center's power consumption detail form is presented in a manner of excel forms；With
Data center's integral point form is presented in the mode of Web page form.
In certain embodiments, Web page form in form display unit supports multiple data centers, multiple moment
Integral point report data is inquired about.
In certain embodiments, the Web page form in form display unit uses integral point report component to realize with next
Item is multinomial：Merge instruction in response to receiving, merge selected cell；In response to receiving contrast instruction, contrast is chosen
Cell；In response to receiving export instruction, selected data content is exported；In response to receiving picture download instruction, download
Selected picture.
The third aspect, the embodiment of the present application provide a kind of equipment, including：One or more processors；Storage device, use
In the one or more programs of storage；When one or more programs are executed by one or more processors so that at one or more
Manage the method that device realizes a kind of as above any described generation O＆M form.
Fourth aspect, the embodiment of the present application provide a kind of computer-readable recording medium, are stored thereon with computer journey
Sequence, the method that a kind of as above any described generation O＆M form is realized when the program is executed by processor.
The method and apparatus for the generation O＆M form that the embodiment of the present application provides, receive report generation instruction first；Obtain
The corresponding report form template of report generation instruction；Report form type and data characteristics based on report form template, are regularly deposited from distribution
The monitoring data of control point position is obtained in storage system；Based on report form template and monitoring data, form is presented.In this course,
The acquisition of report data is all to be obtained by timed task from distributed memory system, and error is minimum, ensure that report data
Uniformity and ageing, and current platform is disposed by distributed way, ensure that the stability of service, being capable of High Availabitity
Live O＆M is supported on ground, is managed collectively and safeguards the report data of all self-built data centers.
Brief description of the drawings
By reading the detailed description made to non-limiting example made with reference to the following drawings, the application's is other
Feature, objects and advantages will become more apparent upon：
Fig. 1 shows the implementation that can be applied the method for the generation O＆M form of the application or generate the device of O＆M form
The exemplary system architecture of example；
Fig. 2 is the indicative flowchart according to one embodiment of the method for the generation O＆M form of the embodiment of the present application；
Fig. 3 is the schematic flow according to another embodiment of the method for the generation O＆M form of the embodiment of the present application
Figure；
Fig. 4 is the exemplary application scene according to the embodiment of the method for the generation O＆M form of the embodiment of the present application；
Fig. 5 is the exemplary block diagram according to one embodiment of the device of the generation O＆M form of the embodiment of the present application；
Fig. 6 is adapted for the structural representation for realizing the terminal device of the embodiment of the present application or the computer system of server
Figure.
Embodiment
The application is described in further detail with reference to the accompanying drawings and examples.It is understood that this place is retouched
The specific embodiment stated is used only for explaining related invention, rather than the restriction to the invention.It also should be noted that in order to
Be easy to describe, illustrate only in accompanying drawing to about the related part of invention.
It should be noted that in the case where not conflicting, the feature in embodiment and embodiment in the application can phase
Mutually combination.Describe the application in detail below with reference to the accompanying drawings and in conjunction with the embodiments.
Fig. 1 shows the implementation that can be applied the method for the generation O＆M form of the application or generate the device of O＆M form
The exemplary system architecture 100 of example.
As shown in figure 1, system architecture 100 can include terminal device 101,102,103, network 104 and server 105,
106.Network 104 between terminal device 101,102,103 and server 105,106 provide communication link medium.Net
Network 104 can include various connection types, such as wired, wireless communication link or fiber optic cables etc..
User 110 can be interacted with using terminal equipment 101,102,103 by network 104 with server 105,106, to connect
Receive or send message etc..Various telecommunication customer end applications, such as search engine can be installed on terminal device 101,102,103
Class application, the application of shopping class, JICQ, mailbox client, social platform software, the application of audio and video playing class etc..
Terminal device 101,102,103 can be the various electronic equipments for having display screen, including but not limited to intelligent sound
Case, smart mobile phone, wearable device, tablet personal computer, E-book reader, MP3 player (Moving Picture Experts
Group Audio Layer III, dynamic image expert's compression standard audio aspect 3), MP4 (Moving Picture
Experts Group Audio Layer IV, dynamic image expert's compression standard audio aspect 4) it is player, on knee portable
Computer and desktop computer etc..
Server 105,106 can be to provide the server of various services, such as terminal device 101,102,103 is provided
The background server of support.Background server such as can be analyzed or be calculated to the request of data of terminal at the processing, and will analysis
Or result of calculation is pushed to terminal device.
It should be noted that in the application embodiment provided generation O＆M form method typically by server 105,
106 or terminal device 101,102,103 perform, correspondingly, generation O＆M form device be generally positioned at server 105,106
Or in terminal device 101,102,103.
It should be understood that the number of the terminal device, network and server in Fig. 1 is only schematical.According to realizing need
Will, can have any number of terminal device, network and server.
Fig. 2 is refer to, Fig. 2 shows one embodiment of the method for the generation O＆M form according to the embodiment of the present application
Indicative flowchart.
As shown in Fig. 2 the method 200 of the generation O＆M form includes：
In step 210, report generation instruction is received.
In the present embodiment, electronic equipment (such as the terminal device shown in Fig. 1 of the method for operation generation O＆M form
Or server) receive user from the human-computer interaction device of terminal device or instructed using the report generation submitted, the report generation
Instruction can be with indicating predetermined report form template.
In a step 220, the corresponding report form template of report generation instruction is obtained.
In the present embodiment, after report generation instruction is received, the corresponding template of report generation instruction can be obtained,
Namely report tableau format is obtained, and report tableau format to include report form type and the data characteristics of form.
In a specific example, report form template can input generation based on the user for meeting following rule：In Excel
Every page of the first behavior is empty, explanation or date data and can not include a point position keyword；Support formula, and every page last row
For formula；Every page second from the bottom is classified as a position keyword (being used to obtain report data from control point position)；Operation is manually entered
Data and the point position (being used for manual entry) being separately configured.
Here report form template, report form template can be inquired about according to data center's module, report form type etc., and can be to report
Table template is applied, cancels the operation such as application or deletion, and management granularity has one in whole report form template, report form template
Each cell in sheet, sheet.In the database for preserving report form template, the report form template of each version can be preserved,
So that user can be as needed, free switching report form template.
In some optional implementations of the present embodiment, it can be obtained from MySQL database and use PhpExcel storehouses
Complete the report form template of parsing；And/or obtained via mutually redundant one of the data platform HDP and integral data warehouse IDW of increasing income
Take the corresponding report form template of report generation instruction.
In this implementation, report form template can include when completing parsing using PhpExcel storehouses, the step of parsing：
" Merge Cells " first is parsed, then parses " normal cells lattice ".Data format can be parsed, and character string is carried out to rich text
Conversion；Data type can be parsed, such as：Date etc.；Pattern can be parsed, such as：Font, color etc.；Need to parse
Go out formula.After being parsed, storage is formatted into MySQL database, is conveniently managed.Afterwards, can be from MySQL data
The report form template that parsing is completed using PhpExcel storehouses is obtained in storehouse.Meanwhile the method for generating O＆M form can be by increasing income
Data platform HDP and integral data warehouse IDW realizes that double storehouses are mutually standby, ensures data recovery not easy to be lost and easy on line.
In some optional implementations of the present embodiment, the above method can also include：Receive the Execl forms uploaded
Form；And the form of the Execl forms of storage upload.It can so be reported based on the form of the Execl forms of upload
Table template.
In step 230, report form type and data characteristics based on report form template, are regularly obtained from distributed memory system
Take the monitoring data of control point position.
In the present embodiment, can be from distributed storage system by timed task according to report form type and data characteristics
Uniting, (such as Redis) is middle to obtain control point position data, and data type can include original point position data, HVAC system running state
Deng so as to meet the ageing of form.Here timing acquisition data, refer at the time of statistical report form is needed, from point
The monitoring data of control point position is obtained in cloth storage system.For example, integral point form, can be obtained once at each integral point moment
Data；Power consumption detail form, electric power data can be obtained automatically in ten two points daily of night.
In some optional implementations of the present embodiment, report form type and data characteristics based on report form template, obtain
The monitoring data of control point position can include：Key word of the inquiry in response to receiving user's input, the form based on report form template
Type and data characteristics, obtain the monitoring data of the control point position of matching inquiry keyword；In response to receiving repairing for user's input
Change instruction, change the monitoring data of the control point position of matching inquiry keyword；Report form type and data based on report form template are special
Sign, obtain the monitoring data of amended control point position.
In this implementation, it is contemplated that the supply vendor of data center is numerous, and the acquisition system of each supply vendor
Destabilizing factor is there may exist, therefore causes to cause error in data or some points position (such as point position without collector) to need
Want manual entry, the method for the generation O＆M form in the application supports online error correction, to meet that live operation maintenance personnel (namely is adopted
With the user of the method for generation O＆M form) instruct (such as point position title or other keywords) to carry out according to keyword query
Data search and editor, error correction number is unrestricted, and after the completion of error correction, the form can regenerated is comprising after error correction
Data.
In step 240, based on report form template and monitoring data, form is presented.
In the present embodiment, the core concept that form is presented is exactly " report form template+monitoring data ", and wherein report form template is determined
The justice appearance form of form, the data content of form can be determined based on monitoring data.The mode of form is presented, can be existing
Have and be used for the mode that form is presented in technology or the technology of future development, the application is not limited this.For example, report can be based on
Table template and monitoring data, form is presented in a manner of Execl or Web page form.In a specific example, based on report
Table template and monitoring data, in a manner of Execl forms or Web page form form being presented can include：With excel forms
Data center's power consumption detail form is presented in mode；Data center's integral point form is presented in a manner of Web page form.
When form is presented, form renders flow and can be：Report form template is obtained from database first, is obtained afterwards
Monitoring data (is stored in database) by timing services, renders report style afterwards (if report data was included across day
Data, formula can be automatically generated by regular expression), generate form afterwards, last Excel export or Web show.
In some specific examples, Excel file form can apply to " data center's power consumption detail form ", branch
Hold across the daily sheet data (could support up one month) of export, the form of inquiry can render the progress of form to improve with real-time display
Consumer's Experience；Web page form can apply to " data center's integral point form ", support multiple data centers, multiple moment
Integral point report data is inquired about, therefore realizes the report data for being managed collectively all self-built data centers, facilitates operation maintenance personnel to carry out
It is unified to safeguard.Here Web page form, integral point report component can be used to realize that the component is a front end assemblies, met
The functions such as cell span, contrast, export, picture download.
Specifically, Web page form can perform following one or more operations using integral point report component：In response to connecing
Fold and instruct, merge selected cell；In response to receiving contrast instruction, selected cell is contrasted；In response to connecing
Export instruction is received, exports selected data content；In response to receiving picture download instruction, selected picture is downloaded.
The method for the generation O＆M form that the above embodiments of the present application provide, first, the acquisition of report data all passes through
Timed task obtains from distributed memory system, and error is minimum, it is ensured that the uniformity of report data and ageing；Its
Secondary, the platform of method for generating O＆M form is disposed by distributed way, ensure that the stability of service, being capable of High Availabitity
Support live O＆M；Finally, report form template only has few constraint, and each data center can enter according to the O＆M feature of itself
Row flexible configuration.
Further, Fig. 3 is refer to, Fig. 3 shows the generation O＆M according to the embodiment of the present application on the basis of Fig. 1
The indicative flowchart of another embodiment of the method for form.
As shown in figure 3, the method 300 of the generation O＆M form includes：
In the step 310, report generation instruction is received.
In the present embodiment, step 310 is corresponding with step 210, therefore, operation and feature described in step 210
Step 310 is equally applicable to, will not be repeated here.
In step 320, the corresponding report form template of report generation instruction is obtained.
In the present embodiment, step 320 is corresponding with step 220, therefore, operation and feature described in step 220
Step 320 is equally applicable to, will not be repeated here.
In a step 330, report form type and data characteristics based on report form template, are regularly obtained from distributed memory system
Take the monitoring data of control point position.
In the present embodiment, step 330 is corresponding with step 230, therefore, operation and feature described in step 230
Step 330 is equally applicable to, will not be repeated here.
In step 340, based on report form template and monitoring data, form is presented.
In the present embodiment, step 340 is corresponding with step 240, therefore, operation and feature described in step 240
Step 340 is equally applicable to, will not be repeated here.
In step 350, the setting operation of the data threshold to control point position is received.
In the present embodiment, the electronic equipment of operation generation O＆M form can receive O＆M people via human-computer interaction device
Setting operation of the member for the data threshold of control point position.
In step 360, according to setting operation, data threshold is set.
In the present embodiment, support according to setting operation, the data threshold of configuration monitoring point position.Here setting operation,
Batch increase threshold value can be included, delete threshold value, modification threshold value and inquiry threshold value, and support the configuration of multiple threshold values.
In step 370, exceed data threshold in response to the data of control point position, control point is presented using predetermined color
Position.
In the present embodiment, when form is presented, can according to the data threshold of setting, using with not less than data
The control point position of threshold value different color renders the control point position more than data threshold.It is for example, general not less than data threshold
Logical control point position is rendered using white or grey, and the emphasis point position not less than data threshold is rendered using green, more than number
Rendered according to the point position of threshold value using red.It should be appreciated that this example does not represent the restriction to the application, art technology
Personnel the different color of sets itself can render all kinds of control point positions as needed.
The method for the generation O＆M form that the above embodiments of the present application provide, can on the basis of the embodiment shown in Fig. 2
To remind operation maintenance personnel to pay close attention to some key points, and according to the color of these key points, make corresponding O＆M plan
Slightly adjust.
Below in conjunction with Fig. 4, the exemplary application scene of the method for the generation O＆M form of the embodiment of the present application is described.
As shown in figure 4, the method 400 of generation O＆M form is run in electronic equipment 420, method includes：
First, report generation instruction 401 is received；
Afterwards, the report form template 402 corresponding to report generation instruction 401 is obtained；
Afterwards, report form type 403 and data characteristics 404 based on report form template 402, regularly from distributed memory system
Obtain the monitoring data 405 of control point position；
Finally, based on report form template 402 and monitoring data 405, form 406 is presented.
It should be appreciated that the method for the generation O＆M form shown in above-mentioned Fig. 4, only generates the method for O＆M form
Exemplary application scene, the restriction to the application is not represented.For example, reception can also further be disclosed to control point in Fig. 4
The setting operation of the data threshold of position；Afterwards according to setting operation, data threshold is set；Finally in response to the data of control point position
More than data threshold, control point position is presented using predetermined color, carrys out wash with watercolours so as to the different color of sets itself as needed
Contaminate all kinds of control point positions.The method of the generation O＆M form provided in the above-mentioned application scenarios of the application, can be with report data
Acquisition be all to be obtained by timed task from distributed memory system, error is minimum, ensure that report data uniformity and
It is ageing, and current platform is disposed by distributed way, ensure that the stability of service, can support scene High Availabitity
O＆M, it is managed collectively and safeguards the report data of all self-built data centers.
With further reference to Fig. 5, as the realization to the above method, the embodiment of the present application provides a kind of generation O＆M form
Device one embodiment, the embodiment of the device of the generation O＆M form and the generation O＆M form shown in Fig. 1 to Fig. 4
The embodiment of method is corresponding, thus, generates operation and the feature of the method description of O＆M form into Fig. 4 above with respect to Fig. 1
The unit for generating the device 500 of O＆M form and wherein including is equally applicable to, will not be repeated here.
As shown in figure 5, the device 500 of the generation O＆M form includes：Instruction reception unit 510, for receiving form life
Into instruction；Template acquiring unit 520, the report form template corresponding for obtaining report generation instruction；Data capture unit 530,
For report form type and data characteristics based on report form template, the monitoring of control point position is regularly obtained from distributed memory system
Data；Form display unit 540, for based on report form template and monitoring data, form to be presented.
In some optional implementations of the present embodiment, data capture unit 530 includes：Keyword query unit 531,
For the key word of the inquiry in response to receiving user's input, report form type and data characteristics based on report form template, matching is obtained
The monitoring data of the control point position of key word of the inquiry；Monitoring data changes unit 532, in response to receiving repairing for user's input
Change instruction, change the monitoring data of the control point position of matching inquiry keyword；Data capture unit 533 is changed, for based on report
The report form type and data characteristics of table template, obtain the monitoring data of amended control point position.
In some optional implementations of the present embodiment, report form template in template acquiring unit 520 be based on meeting with
Lower regular user inputs generation：Every page of the first behavior is empty in Excel, explanation or date data and can not to include point position crucial
Word；Formula is supported, and last of every page is classified as formula；Every page second from the bottom is classified as a position keyword；Operation is manually entered
Data and the point position being separately configured.
In some optional implementations of the present embodiment, device also includes：Receiving unit 550 is operated, for reception pair
The setting operation of the data threshold of control point position；Threshold setting unit 560, for according to setting operation, setting data threshold；Face
Color display unit 570, exceed data threshold for the data in response to control point position, control point position is presented using predetermined color.
In some optional implementations of the present embodiment, template acquiring unit 520 is further used for：From MySQL data
The report form template that parsing is completed using PhpExcel storehouses is obtained in storehouse；And/or via it is mutually redundant increase income data platform HDP and
One of integral data warehouse IDW obtains the corresponding report form template of report generation instruction.
In some optional implementations of the present embodiment, device also includes：Form receiving unit 580, for reception
The form of the Execl forms of biography；Form memory cell 590, for storing the form of the Execl forms uploaded.
In some optional implementations of the present embodiment, form display unit 540 is further used for：Based on report form template
And monitoring data, form is presented in a manner of Execl or Web page form.
In some optional implementations of the present embodiment, in form display unit 540 based on report form template and monitoring
Data, in a manner of Execl forms or Web page form form is presented includes：Data center is presented in a manner of excel forms
Power consumption detail form；Data center's integral point form is presented in a manner of Web page form.
In some optional implementations of the present embodiment, the Web page form in form display unit 540 is supported multiple
Data center, the inquiry of the integral point report data at multiple moment.
In some optional implementations of the present embodiment, the Web page form in form display unit 540 uses integral point
Report component is realized following one or more：Merge instruction in response to receiving, merge selected cell；In response to reception pair
Than instruction, selected cell is contrasted；In response to receiving export instruction, selected data content is exported；In response to receiving
Picture download instruction, download selected picture.
Present invention also provides a kind of embodiment of equipment, including：One or more processors；Storage device, for depositing
Store up one or more programs；When one or more programs are executed by one or more processors so that one or more processors
The method for realizing the generation O＆M form described in as above any one.
Present invention also provides a kind of embodiment of computer-readable recording medium, computer program is stored thereon with, should
The method that the generation O＆M form described in as above any one is realized when program is executed by processor.
Below with reference to Fig. 6, it illustrates suitable for for realizing the calculating of the terminal device of the embodiment of the present application or server
The structural representation of machine system 600.Terminal device shown in Fig. 6 is only an example, should not be to the work(of the embodiment of the present application
Any restrictions can be brought with use range.
As shown in fig. 6, computer system 600 includes CPU (CPU) 601, it can be read-only according to being stored in
Program in memory (ROM) 602 or be loaded into program in random access storage device (RAM) 603 from storage part 608 and
Perform various appropriate actions and processing.In RAM 603, also it is stored with system 600 and operates required various programs and data.
CPU 601, ROM 602 and RAM 603 are connected with each other by bus 604.Input/output (I/O) interface 605 is also connected to always
Line 604.
I/O interfaces 605 are connected to lower component：Importation 606 including keyboard, mouse etc.；Penetrated including such as negative electrode
The output par, c 607 of spool (CRT), liquid crystal display (LCD) etc. and loudspeaker etc.；Storage part 608 including hard disk etc.；
And the communications portion 609 of the NIC including LAN card, modem etc..Communications portion 609 via such as because
The network of spy's net performs communication process.Driver 610 is also according to needing to be connected to I/O interfaces 605.Detachable media 611, such as
Disk, CD, magneto-optic disk, semiconductor memory etc., it is arranged on as needed on driver 610, in order to read from it
Computer program be mounted into as needed storage part 608.
Especially, in accordance with an embodiment of the present disclosure, it may be implemented as computer above with reference to the process of flow chart description
Software program.For example, embodiment of the disclosure includes a kind of computer program product, it includes being carried on computer-readable medium
On computer program, the computer program include be used for execution flow chart shown in method program code.Such
In embodiment, the computer program can be downloaded and installed by communications portion 609 from network, and/or be situated between from detachable
Matter 611 is mounted.When the computer program is performed by CPU (CPU) 601, perform and limited in the present processes
Above-mentioned function.
It should be noted that computer-readable medium described herein can be computer-readable signal media or meter
Calculation machine readable storage medium storing program for executing either the two any combination.Computer-readable recording medium for example can be --- but not
Be limited to --- electricity, magnetic, optical, electromagnetic, system, device or the device of infrared ray or semiconductor, or it is any more than combination.Meter
The more specifically example of calculation machine readable storage medium storing program for executing can include but is not limited to：Electrical connection with one or more wires, just
Take formula computer disk, hard disk, random access storage device (RAM), read-only storage (ROM), erasable type and may be programmed read-only storage
Device (EPROM or flash memory), optical fiber, portable compact disc read-only storage (CD-ROM), light storage device, magnetic memory device,
Or above-mentioned any appropriate combination.In this application, computer-readable recording medium can any include or store journey
The tangible medium of sequence, the program can be commanded the either device use or in connection of execution system, device.And at this
In application, computer-readable signal media can include in a base band or as carrier wave a part propagation data-signal,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited
In electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can
Any computer-readable medium beyond storage medium is read, the computer-readable medium, which can send, propagates or transmit, to be used for
By instruction execution system, device either device use or program in connection.Included on computer-readable medium
Program code can be transmitted with any appropriate medium, be included but is not limited to：Wirelessly, electric wire, optical cable, RF etc., or it is above-mentioned
Any appropriate combination.
Flow chart and block diagram in accompanying drawing, it is illustrated that according to the system of the various embodiments of the application, method and computer journey
Architectural framework in the cards, function and the operation of sequence product.At this point, each square frame in flow chart or block diagram can generation
The part of one unit of table, program segment or code, a part for the unit, program segment or code include one or more
For realizing the executable instruction of defined logic function.It should also be noted that some as replace realization in, institute in square frame
The function of mark can also be with different from the order marked in accompanying drawing generation.For example, two square frames succeedingly represented are actual
On can perform substantially in parallel, they can also be performed in the opposite order sometimes, and this is depending on involved function.Also
It is noted that the combination of each square frame and block diagram in block diagram and/or flow chart and/or the square frame in flow chart, Ke Yiyong
Function as defined in execution or the special hardware based system of operation are realized, or can be referred to specialized hardware and computer
The combination of order is realized.
Being described in unit involved in the embodiment of the present application can be realized by way of software, can also be by hard
The mode of part is realized.Described unit can also be set within a processor, for example, can be described as：A kind of processor bag
Include instruction reception unit, template acquiring unit, data capture unit and form display unit.The title of these units is in certain feelings
The restriction to the unit in itself is not formed under condition, for example, instruction reception unit is also described as " receiving report generation to refer to
The unit of order ".
As on the other hand, present invention also provides a kind of nonvolatile computer storage media, the non-volatile calculating
Machine storage medium can be the nonvolatile computer storage media included in device described in above-described embodiment；Can also be
Individualism, without the nonvolatile computer storage media in supplying terminal.Above-mentioned nonvolatile computer storage media is deposited
One or more program is contained, when one or more of programs are performed by an equipment so that the equipment：Receive
Report generation instructs；Obtain the corresponding report form template of report generation instruction；Report form type and data based on report form template are special
Sign, the monitoring data of control point position is regularly obtained from distributed memory system；Based on report form template and monitoring data, report is presented
Table.
Above description is only the preferred embodiment of the application and the explanation to institute's application technology principle.People in the art
Member should be appreciated that invention scope involved in the application, however it is not limited to the technology that the particular combination of above-mentioned technical characteristic forms
Scheme, while should also cover in the case where not departing from foregoing invention design, carried out by above-mentioned technical characteristic or its equivalent feature
The other technical schemes for being combined and being formed.Such as features described above has similar work(with (but not limited to) disclosed herein
The technical scheme that the technical characteristic of energy is replaced mutually and formed.
Claims (22)
1. a kind of method for generating O＆M form, including：
Receive report generation instruction；
Obtain the corresponding report form template of the report generation instruction；
Report form type and data characteristics based on the report form template, control point position is regularly obtained from distributed memory system
Monitoring data；
Based on the report form template and the monitoring data, form is presented.
2. the method according to claim 11, wherein, the report form type and data characteristics based on the report form template,
Obtaining the monitoring data of control point position includes：
Key word of the inquiry in response to receiving user's input, report form type and data characteristics based on the report form template, is obtained
Match the monitoring data of the control point position of the key word of the inquiry；
Instructed in response to the modification for receiving user's input, change the monitoring number of the control point position of the matching key word of the inquiry
According to；
Report form type and data characteristics based on the report form template, obtain the monitoring data of amended control point position.
3. according to the method for claim 1, wherein, the report form template inputs life based on the user for meeting following rule
Into：
Every page of the first behavior is empty in Excel, explanation or date data and can not include a point position keyword；
Formula is supported, and last of every page is classified as formula；
Every page second from the bottom is classified as a position keyword；
Run the point position for being manually entered data and being separately configured.
4. according to the method for claim 1, wherein, methods described also includes：
Receive the setting operation to the data threshold of the control point position；
According to the setting operation, the data threshold is set；
Exceed the data threshold in response to the data of the control point position, the control point position is presented using predetermined color.
5. according to the method for claim 1, wherein, the acquisition report generation instructs corresponding report form template bag
Include：
The report form template that parsing is completed using PhpExcel storehouses is obtained from MySQL database；And/or
The report generation instruction institute is obtained via mutually redundant increase income one of data platform HDP and integral data warehouse IDW
Corresponding report form template.
6. according to the method for claim 1, wherein, methods described also includes：
Receive the form of the Execl forms uploaded；
Store the form of the Execl forms uploaded.
7. according to the method for claim 1, wherein, described to be based on the report form template and the monitoring data, presentation is reported
Table includes：
Based on the report form template and the monitoring data, form is presented in a manner of Execl or Web page form.
8. the method according to claim 11, wherein, based on the report form template and the monitoring data, with Execl forms
Or the mode of Web page form is presented form and included：
Data center's power consumption detail form is presented in a manner of excel forms；
Data center's integral point form is presented in a manner of Web page form.
9. according to the method for claim 7, wherein, the Web page form supports multiple data centers, multiple moment
Integral point report data is inquired about.
10. according to the method described in claim 7 to 9 any one, wherein, the Web page form uses integral point form group
Part is realized following one or more：
Merge instruction in response to receiving, merge selected cell；
In response to receiving contrast instruction, selected cell is contrasted；
In response to receiving export instruction, selected data content is exported；
In response to receiving picture download instruction, selected picture is downloaded.
11. a kind of device for generating O＆M form, including：
Instruction reception unit, for receiving report generation instruction；
Template acquiring unit, the report form template corresponding for obtaining the report generation instruction；
Data capture unit, for report form type and data characteristics based on the report form template, regularly from distributed storage system
The monitoring data of control point position is obtained in system；
Form display unit, for based on the report form template and the monitoring data, form to be presented.
12. device according to claim 11, wherein, the data capture unit includes：
Keyword query unit, for the key word of the inquiry in response to receiving user's input, the form based on the report form template
Type and data characteristics, obtain the monitoring data for the control point position for matching the key word of the inquiry；
Monitoring data changes unit, for being instructed in response to the modification for receiving user's input, changes the matching inquiry and closes
The monitoring data of the control point position of key word；
Data capture unit is changed, for report form type and data characteristics based on the report form template, obtains amended prison
The monitoring data of control point position.
13. device according to claim 11, wherein, the report form template in the template acquiring unit is based on meeting
Following regular user inputs generation：
Every page of the first behavior is empty in Excel, explanation or date data and can not include a point position keyword；
Formula is supported, and last of every page is classified as formula；
Every page second from the bottom is classified as a position keyword；
Run the point position for being manually entered data and being separately configured.
14. device according to claim 11, wherein, described device also includes：
Receiving unit is operated, for receiving the setting operation to the data threshold of the control point position；
Threshold setting unit, for according to the setting operation, setting the data threshold；
Color display unit, exceed the data threshold for the data in response to the control point position, be in using predetermined color
The existing control point position.
15. device according to claim 11, wherein, the template acquiring unit is further used for：
The report form template that parsing is completed using PhpExcel storehouses is obtained from MySQL database；And/or
The report generation instruction institute is obtained via mutually redundant increase income one of data platform HDP and integral data warehouse IDW
Corresponding report form template.
16. device according to claim 11, wherein, described device also includes：
Form receiving unit, for receiving the form of the Execl forms uploaded；
Form memory cell, for storing the form of the Execl forms uploaded.
17. device according to claim 11, wherein, the form display unit is further used for：
Based on the report form template and the monitoring data, form is presented in a manner of Execl or Web page form.
18. device according to claim 17, wherein, in the form display unit based on the report form template and institute
Monitoring data is stated, form, which is presented, in a manner of Execl forms or Web page form includes：
Data center's power consumption detail form is presented in a manner of excel forms；
Data center's integral point form is presented in a manner of Web page form.
19. device according to claim 17, wherein, the Web page form in the form display unit is supported
Multiple data centers, the inquiry of the integral point report data at multiple moment.
20. according to the device described in claim 17 to 19 any one, wherein, the Web in the form display unit
Page form is realized following one or more using integral point report component：
Merge instruction in response to receiving, merge selected cell；
In response to receiving contrast instruction, selected cell is contrasted；
In response to receiving export instruction, selected data content is exported；
In response to receiving picture download instruction, selected picture is downloaded.
21. a kind of equipment, including：
One or more processors；
Storage device, for storing one or more programs；
When one or more of programs are by one or more of computing devices so that one or more of processors are real
The now method of the generation O＆M form as described in any in claim 1-10.
22. a kind of computer-readable recording medium, is stored thereon with computer program, realized such as when the program is executed by processor
The method of any described generation O＆M form in claim 1-10.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711224277.2A CN107861933A (en) | 2017-11-29 | 2017-11-29 | The method and apparatus for generating O＆M form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711224277.2A CN107861933A (en) | 2017-11-29 | 2017-11-29 | The method and apparatus for generating O＆M form |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107861933A true CN107861933A (en) | 2018-03-30 |
Family
ID=61704378
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711224277.2A Pending CN107861933A (en) | 2017-11-29 | 2017-11-29 | The method and apparatus for generating O＆M form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107861933A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109446199A (en) * | 2018-10-19 | 2019-03-08 | 天津字节跳动科技有限公司 | Cell data processing method and device |
| CN109766534A (en) * | 2018-12-19 | 2019-05-17 | 益萃网络科技（中国）有限公司 | Report form generation method, device, computer equipment and readable storage medium storing program for executing |
| CN110096503A (en) * | 2019-03-22 | 2019-08-06 | 重庆长安汽车股份有限公司 | A kind of analysis method and system of three coordinate measuring point data of white body |
| CN110209714A (en) * | 2019-04-19 | 2019-09-06 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and computer readable storage medium |
| CN111125146A (en) * | 2019-11-27 | 2020-05-08 | 中国联合网络通信集团有限公司 | Report generation method and device and storage medium |
| WO2020233345A1 (en) * | 2019-05-21 | 2020-11-26 | 深圳壹账通智能科技有限公司 | Natural language processing-based data chart generation method and related device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101183356A (en) * | 2007-12-14 | 2008-05-21 | 华为技术有限公司 | Realization method of Excel report forms and Excel reporting system |
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN106209495A (en) * | 2016-06-24 | 2016-12-07 | 浪潮(北京)电子信息产业有限公司 | The report form generation method of a kind of cloud monitoring system and device |
| US20170004124A1 (en) * | 2015-06-30 | 2017-01-05 | Datawatch Corporation | Systems and methods for automatically creating tables using auto-generated templates |
-
2017
- 2017-11-29 CN CN201711224277.2A patent/CN107861933A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101183356A (en) * | 2007-12-14 | 2008-05-21 | 华为技术有限公司 | Realization method of Excel report forms and Excel reporting system |
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| US20170004124A1 (en) * | 2015-06-30 | 2017-01-05 | Datawatch Corporation | Systems and methods for automatically creating tables using auto-generated templates |
| CN106209495A (en) * | 2016-06-24 | 2016-12-07 | 浪潮(北京)电子信息产业有限公司 | The report form generation method of a kind of cloud monitoring system and device |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109446199A (en) * | 2018-10-19 | 2019-03-08 | 天津字节跳动科技有限公司 | Cell data processing method and device |
| CN109766534A (en) * | 2018-12-19 | 2019-05-17 | 益萃网络科技（中国）有限公司 | Report form generation method, device, computer equipment and readable storage medium storing program for executing |
| CN110096503A (en) * | 2019-03-22 | 2019-08-06 | 重庆长安汽车股份有限公司 | A kind of analysis method and system of three coordinate measuring point data of white body |
| CN110096503B (en) * | 2019-03-22 | 2023-04-18 | 重庆长安汽车股份有限公司 | Analysis method and system for white vehicle body three-coordinate measuring point data |
| CN110209714A (en) * | 2019-04-19 | 2019-09-06 | 平安科技（深圳）有限公司 | Report form generation method, device, computer equipment and computer readable storage medium |
| WO2020233345A1 (en) * | 2019-05-21 | 2020-11-26 | 深圳壹账通智能科技有限公司 | Natural language processing-based data chart generation method and related device |
| CN111125146A (en) * | 2019-11-27 | 2020-05-08 | 中国联合网络通信集团有限公司 | Report generation method and device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107861933A (en) | The method and apparatus for generating O＆M form | |
| CN109711877B (en) | Advertisement picture processing method and device, computer storage medium and electronic equipment | |
| CN110472207A (en) | List generation method and device | |
| CN113435846A (en) | Business process arranging method and device, computer equipment and storage medium | |
| CN109814856A (en) | Data entry method, device, terminal and computer readable storage medium | |
| CN107506218A (en) | The management method and management system of a kind of configuration file | |
| CN113051354B (en) | Online source searching method and device based on dynamic configuration and computer equipment | |
| CN109101309A (en) | For updating user interface method and device | |
| CN110532487A (en) | The generation method and device of label | |
| CN116450353A (en) | Processor core matching method and device, electronic equipment and storage medium | |
| CN116305895A (en) | Product model generation method, device, computer equipment and storage medium | |
| CN114218291A (en) | Portrait generation method, apparatus, device and storage medium based on target object | |
| CN110765610B (en) | PDM integration method, PDM integration device, computer equipment and storage medium | |
| CN111814044A (en) | Recommendation method and device, terminal equipment and storage medium | |
| CN111241089B (en) | ERP system secondary development method, system, device and readable storage medium | |
| CN116450723A (en) | Data extraction method, device, computer equipment and storage medium | |
| CN107798556A (en) | For updating method, equipment and the storage medium of situation record | |
| CN114201157A (en) | Method and system for customizing target service module by low code | |
| CN104574098B (en) | Application program type electronic shop system and its transaction method and application program generator | |
| CN113190509A (en) | Animation processing method and device, electronic equipment and computer readable storage medium | |
| CN112561558A (en) | Express time portrait generation method, generation device, equipment and storage medium | |
| CN114154048A (en) | Method and device for constructing recommendation model, electronic equipment and storage medium | |
| CN107704318A (en) | The method and apparatus of example scheduling | |
| CN117076542B (en) | Data processing method and related device | |
| WO2024114340A1 (en) | Method and apparatus for constructing digital twin model in plurality of logistics scenarios, and device and medium |
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: 20180330 |