CN114443683A - System, method, device and medium for on-site query of automatic operation of power grid equipment - Google Patents
System, method, device and medium for on-site query of automatic operation of power grid equipment Download PDFInfo
- Publication number
- CN114443683A CN114443683A CN202111557847.6A CN202111557847A CN114443683A CN 114443683 A CN114443683 A CN 114443683A CN 202111557847 A CN202111557847 A CN 202111557847A CN 114443683 A CN114443683 A CN 114443683A
- Authority
- CN
- China
- Prior art keywords
- module
- query
- data
- user
- hoc
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 238000004891 communication Methods 0.000 claims abstract description 12
- 238000012216 screening Methods 0.000 claims description 49
- 230000006870 function Effects 0.000 claims description 15
- 238000004364 calculation method Methods 0.000 claims description 11
- 238000012545 processing Methods 0.000 claims description 9
- 238000005516 engineering process Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 5
- 230000000007 visual effect Effects 0.000 claims description 4
- 230000006399 behavior Effects 0.000 claims description 3
- 238000012800 visualization Methods 0.000 claims description 3
- 238000007670 refining Methods 0.000 claims description 2
- 238000013461 design Methods 0.000 abstract description 3
- 239000000284 extract Substances 0.000 abstract description 3
- 230000002452 interceptive effect Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 9
- 238000004458 analytical method Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000013459 approach Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000007639 printing Methods 0.000 description 2
- 238000012935 Averaging Methods 0.000 description 1
- 206010063385 Intellectualisation Diseases 0.000 description 1
- 230000001174 ascending effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 239000002360 explosive Substances 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
-
- 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/24—Querying
- G06F16/245—Query processing
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Business, Economics & Management (AREA)
- Probability & Statistics with Applications (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Public Health (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Water Supply & Treatment (AREA)
- Fuzzy Systems (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an ad hoc query system, a method, equipment and a medium for automatic operation of power grid equipment, wherein the system comprises the following components: the query configuration module is in communication connection with the ad hoc query module and is used for converting data in the database into a user-oriented business object; the ad hoc query module is in communication connection with the query configuration module and the advanced layout module and is used for setting different query modes and query conditions for a user; and the advanced layout module is in communication connection with the ad hoc query module and is used for performing advanced layout on a query result according to a service scene and user requirements. According to the invention, by constructing an intelligent system for automatically operating and instantly inquiring the power grid equipment, which is convenient and fast to customize requirements, flexibly extracts information and adopts humanized interactive design, diversified information acquisition requirements are met, and rapid summary statistics and knowledge sharing are realized, so that the aims of rapidly acquiring information, saving labor cost, responding to demand changes in a personalized manner and providing effective decision support in time are fulfilled.
Description
Technical Field
The invention relates to the technical field of automation of power grid equipment, in particular to an ad hoc query system, method, equipment and medium for automatic operation of power grid equipment.
Background
At present, the human society has advanced into the information age. With the advent of the internet plus era and the continuous maturity of new technologies such as cloud, large, object, mobile, intelligent and chain, information technology is evolving towards the next generation of high speed, intelligence and fusion. The progress of information technology drives and supports mode innovation, management innovation and system innovation. High-quality enterprises in all fields continuously think and explore, self innovation and improvement are kept constantly, the traditional service mode is changed towards the direction of intellectualization and modernization, and a reasonable production and operation mode is actively and perfectly realized.
With the continuous deepening of the information of the power grid enterprise and the application of intelligent equipment, an intelligent power grid and the like in the field of electric power, the service data of power grid operation shows explosive growth, and users need to inquire the service data of the power grid operation according to actual requirements.
Disclosure of Invention
The invention aims to provide an ad hoc query system, method, equipment and medium for automatic operation of power grid equipment, which can actively sense and instantly screen power grid operation data and operation management indexes, effectively improve the sensing value of customers, establish a set of efficient ad hoc query intelligent system facing users, enhance the active sensing of the users and improve the working efficiency.
In order to achieve the above object, the present invention provides an ad hoc query system for automatically operating power grid equipment, comprising:
the query configuration module, the ad hoc query module and the advanced layout module;
the query configuration module is in communication connection with the ad hoc query module and is used for converting data in a database into a user-oriented business object;
the ad hoc query module is in communication connection with the query configuration module and the advanced layout module and is used for setting different query modes and query conditions for a user;
and the advanced layout module is in communication connection with the ad hoc inquiry module and is used for performing advanced layout on an inquiry result according to a service scene and user requirements.
Further, preferably, the query configuration module includes:
the system comprises a semantic model management module, a screening condition configuration module, a data source configuration module and a sequence configuration module;
the semantic model management module is used for managing a theme domain, a data theme and an entity object;
the screening condition configuration module is used for setting screening conditions and combinations of the screening conditions;
the data source configuration module is used for configuring the relationship with the subject domain according to the data source queried by the system;
and the sequence configuration module is used for making the browsing and querying results clearer according to different sequence arrangements and data combination requirements.
Further, preferably, the semantic model management module includes:
the system comprises a theme domain management module, a data theme management module and an entity object management module;
the theme domain management module is used for determining a theme domain according to the requirement of system query statistics;
the data theme management module is used for decomposing the theme domain, analyzing the attribute and the behavior related to the theme domain in each system and classifying the data forming the theme domain.
And the entity object management module is used for refining the data theme and determining the attribute of the entity object.
Further, as a preference, the screening condition configuration module includes:
the device comprises a calculation function setting module, a screening condition setting module and a condition relation setting module;
the calculation function setting module is used for selecting a built-in calculation statistical function to meet the requirement of data operation;
the screening condition setting module is used for setting the condition of the query data;
and the condition relation setting module is used for combining a plurality of screening conditions into a required condition relation.
Further, as a preference, the ad hoc query module includes:
the system comprises a user-defined query module, an instant query module, a timing query module and a result export module;
the user-defined query module is used for setting user-defined query conditions according to user requirements and actual conditions;
the instant query module is used for carrying out real-time query according to the user requirements and the actual conditions;
the timing query module is used for performing timing query on data with low use frequency but high importance degree;
and the result exporting module is used for exporting and storing the query result.
Further, preferably, the custom query module includes:
a user-defined query condition module, a user-defined screening template module and a template preview module;
the user-defined query condition module is used for displaying built-in query conditions through a visual interface so as to enable a user to select the query conditions;
the user-defined screening template module is used for setting a user-defined screening template according to the historical query conditions of the user;
and the template previewing module is used for previewing the user-defined screening template.
Further, preferably, the advanced layout module includes:
the data processing module and the reminding and early warning module;
the data processing module is used for editing, calculating, combining and comparing data to form final data and supporting subsequent report export and release;
and the reminding and early warning module is used for informing related personnel to check the statistical result in a set mode according to reminding and early warning conditions set by a user.
The invention also provides an ad hoc query method for the automatic operation of the power grid equipment, which comprises the following steps:
selecting data dimensions of data according to user requirements and configuring screening conditions;
performing data query according to the data dimension, the screening condition and the query mode, and returning a data query result;
and the query result is laid out through a visualization technology, and the laid-out query result is displayed to a user.
The present invention also provides a terminal device, including:
one or more processors;
a memory coupled to the processor for storing one or more programs;
when executed by the one or more processors, the one or more programs cause the one or more processors to implement the ad hoc inquiry method for the automated operation of the power grid device as described in any one of the above.
The invention also provides a computer-readable storage medium, on which a computer program is stored, which, when executed by a processor, implements the ad hoc query method for the automatic operation of the power grid device according to any one of the above.
Compared with the prior art, the invention has the beneficial effects that:
according to the invention, by constructing an intelligent system for automatically operating and instantly inquiring the power grid equipment, which is convenient and fast to customize requirements, flexibly extracts information and adopts humanized interactive design, diversified information acquisition requirements are met, and rapid summary statistics and knowledge sharing are realized, so that the aims of rapidly acquiring information, saving labor cost, responding to demand changes in a personalized manner and providing effective decision support in time are fulfilled.
Drawings
In order to more clearly illustrate the technical solution of the present invention, the drawings required to be used in the embodiments will be briefly described below, and obviously, the drawings in the following description are only some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
Fig. 1 is a schematic structural diagram of an ad hoc query system for automatically operating a power grid device according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a query configuration module according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a semantic model management module according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a screening condition configuration module provided in an embodiment of the present invention;
fig. 5 is a schematic structural diagram of an ad hoc query module according to an embodiment of the present invention;
FIG. 6 is a flow chart illustrating a custom query approach according to an embodiment of the present invention;
FIG. 7 is a schematic structural diagram of a custom query module provided in an embodiment of the present invention;
FIG. 8 is a block diagram of an advanced layout module provided in accordance with an embodiment of the present invention;
fig. 9 is a schematic flow chart illustrating a reminding and warning method according to an embodiment of the present invention;
FIG. 10 is a flow diagram of a high level layout approach provided by one embodiment of the present invention;
fig. 11 is a schematic flowchart of an ad hoc query method for automatically operating a power grid device according to an embodiment of the present invention;
fig. 12 is a schematic structural diagram of a terminal device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be understood that the step numbers used herein are for convenience of description only and are not intended as limitations on the order in which the steps are performed.
It is to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
The terms "comprises" and "comprising" indicate the presence of the described features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
The term "and/or" refers to and includes any and all possible combinations of one or more of the associated listed items.
Referring to fig. 1, an embodiment of the invention provides an ad hoc inquiry system for automatically operating power grid devices. As shown in fig. 1, the power grid equipment is an ad hoc inquiry system automatically operated by the following modules. The method comprises the following specific steps:
a query configuration module 10, an ad hoc query module 20 and a high-level layout module 30;
the query configuration module 10 is in communication connection with the ad hoc query module 20, and is configured to convert data in a database into a user-oriented business object;
the ad hoc query module 20 is in communication connection with the query configuration module 10 and the advanced layout module 30, and is used for setting different query modes and query conditions for a user;
the advanced layout module 30 is in communication connection with the ad hoc query module 20, and is configured to perform advanced layout on a query result according to a service scenario and a user requirement.
It should be noted that, the query configuration module 10 specifically implements definition of a semantic layer by query configuration, and converts relevant contents such as tables, storage processes, fields, field types, and the like in a database into a user-oriented service object.
Specifically, as shown in fig. 2, preferably, in an alternative embodiment, the query configuration module 10 includes:
a semantic model management module 11, a screening condition configuration module 12, a data source configuration module 13 and a sequence configuration module 14;
the semantic model management module 11 is configured to manage a theme domain, a data theme, and an entity object;
the screening condition configuration module 12 is configured to set a screening condition and a combination of the screening conditions;
the data source configuration module 13 is configured to configure a relationship with the topic domain according to a data source queried by the system;
it should be noted that the data source configuration module 13 can make the source information simple and easy to understand, and the service personnel can also operate the content that only the computer professional technicians know before.
The sequence configuration module 14 is configured to make the browsing query result clearer according to different sequence arrangements and data combination requirements. Such as ascending, descending, grouping, combining, etc.
Specifically, as shown in fig. 3, in an optional embodiment, the semantic model management module 11 includes the following sub-modules:
a theme domain management module 111, a data theme management module 112 and an entity object management module 113;
the topic domain management module 111 is configured to determine a topic domain according to a requirement of system query statistics;
specifically, the theme domain management module may perform abstract synthesis, classification, and analysis and utilization on data in each system, and each theme basically corresponds to one macroscopic analysis field. The representative topic domain can also be determined based on the requirements of the query statistics.
The data topic management module 112 is configured to decompose the topic domains, analyze attributes and behaviors related to the topic domains in each system, and classify data constituting the topic domains.
The entity object management module 113 is configured to refine a data topic and determine an attribute of an entity object.
Specifically, as shown in fig. 4, in an optional embodiment, the screening condition configuration module 12 includes the following sub-modules:
a calculation function setting module 121, a screening condition setting module 122, and a condition relation setting module 123;
the calculation function setting module 121 is configured to select a built-in calculation statistical function to meet a requirement for performing operation on data;
it should be noted that the calculation function setting module 121 includes calculation functions such as summing, averaging, absolute value, maximum value, and minimum value.
The screening condition setting module 122 is configured to set a condition of query data;
it should be noted that the screening condition setting module 122 includes setting conditions greater than, less than, equal to, etc.
The condition relation setting module 123 is configured to combine the multiple screening conditions into a required condition relation.
It should be noted that the condition relation setting module 123 is specifically configured to combine a plurality of screening conditions into a required condition relation. For example, the screening condition A and the screening condition B are in the relation of "and", or in the relation of "or", etc.
Specifically, as shown in fig. 5, in an optional embodiment, the chairman query module 20 includes the following sub-modules:
a custom query module 21, an instant query module 22, a timing query module 23 and a result derivation module 24;
the user-defined query module 21 is configured to set a user-defined query condition according to a user requirement and an actual situation;
it should be noted that the user query requirement may be set in a customized manner according to actual situations, and includes two parts, namely a customized query condition and a customized screening template, and a specific query manner is shown in fig. 6.
The instant query module 22 is used for performing real-time query according to the user requirements and actual conditions;
it should be noted that the instant query module 22 can perform the operation efficiency estimation according to the user-defined query condition, and display the data result through the real-time query function with less time consumption.
The timing query module 23 is configured to perform timing query on data with a low use frequency but a high importance degree;
specifically, the timing query module 23 is to meet some data query requirements that real-time data is not needed, the use frequency is not high, but the importance degree is high, and if the system determines that the time is long after performing operation efficiency estimation according to the user-defined query condition, the data result is displayed through the timing query function. And setting to run at fixed time through the system, and storing a data result.
And the result exporting module 24 is used for exporting and storing the query result.
Specifically, the query data is often shared as a result, and the system ensures convenience in viewing the result, ensures that the data can be reused, and can be saved as a permanent record file if necessary. The result export mainly comprises two parts of exporting the document and printing. Exporting the result output of the document supporting various file formats, including Word, Excel, PDF and the like; the printing supports setting of a print style.
It should be noted that, as a priority, in an optional embodiment, as shown in fig. 7, the custom query module 21 includes:
a custom query condition module 211, a custom screening template module 212 and a template preview module 213;
the user-defined query condition module 211 is configured to display a built-in query condition through a visual interface, so that a user selects the query condition;
specifically, the user-defined query condition module 211 can display the complex built-in parameters through a simple and understandable visual interface, so that the user can complete query requirement customization through convenient and easy dragging operation in the foreground.
The custom screening template module 212 is configured to set a custom screening template according to a historical query condition of a user;
specifically, the customized screening template module 212 may present the actual situation that the query templates are similar for the same or similar work, the customized template of the user may define whether to share, and the template may be divided into two parts, namely a personalized template and a public template, through the management of the authority.
The template preview module 213 is configured to preview a custom screening template.
Specifically, the template preview module 213 may be configured to provide a template preview function (without data, only in a template format) for the system, so as to avoid the condition of error and omission in the template definition process, and display a presentation style after setting a custom query condition, and the user may check whether the content of the data item meets the query requirement through preview.
Specifically, as a priority, in an alternative embodiment, as shown in fig. 8, the advanced layout module 30 includes:
a data processing module 31 and a reminding and early warning module 32;
the data processing module 31 is used for editing, calculating, merging and comparing data to form final data, and supporting subsequent report export and release;
specifically, the data processing module 31 is used for displaying the result data processed by the system, which may not meet the data presentation form required by the final report or which may not meet the actual requirement, and the system supports the user-defined data processing, and performs editing, operation, combination, comparison and the like on the data to form effective final data, thereby supporting the subsequent report export and release.
The reminding and early warning module 32 is used for informing related personnel to check the statistical result in a set mode according to reminding and early warning conditions set by a user.
Specifically, the reminding and early warning module 32 is to avoid that the waiting time is too long in the query process and the working efficiency is affected, a user can set reminding and early warning conditions, including a message receiving mode, early warning time, reminding people or early warning objects, and the like, and when the background statistics is completed, the user informs related people to view the statistical result in the set mode, and the specific working flow of the reminding and early warning module is as shown in fig. 9.
It should be noted that, usually, a work report or work result, not only listed data, but also additional analysis description and format adjustment are needed, and the system provides a flexible document formatting and advanced layout function for editing key data, and is set as required according to a business scenario. And displaying the key data in a large amount of data in a key mode according to the data query result by means of character color, regional background, insert graphic representation and the like, assisting a user in quickly positioning the key data or paying attention to sensitive data, and finally forming a formal work report. The workflow of the high-level layout is shown in fig. 10.
Compared with the prior art, the automatic operation ad hoc query system for the power grid equipment has the advantages that:
according to the invention, by constructing an intelligent system for automatically operating and instantly inquiring the power grid equipment, which is convenient and fast to customize requirements, flexibly extracts information and adopts humanized interactive design, diversified information acquisition requirements are met, and rapid summary statistics and knowledge sharing are realized, so that the aims of rapidly acquiring information, saving labor cost, responding to demand changes in a personalized manner and providing effective decision support in time are fulfilled.
As shown in fig. 11, the present invention further provides an ad hoc query method for the automatic operation of the power grid device, which includes steps S10 to S30. The method comprises the following steps:
s10, selecting data dimensionality of data according to user requirements and configuring screening conditions;
s20, performing data query according to the data dimension, the screening condition and the query mode, and returning a data query result;
and S20, laying out the query result through a visualization technology, and displaying the laid-out query result to a user.
Referring to fig. 12, an embodiment of the present invention provides a terminal device, including:
one or more processors;
a memory coupled to the processor for storing one or more programs;
when executed by the one or more processors, the one or more programs cause the one or more processors to implement the ad hoc inquiry method for the automated operation of the power grid equipment as described above.
The processor is used for controlling the overall operation of the terminal equipment so as to complete all or part of the steps of the ad hoc inquiry method for the automatic operation of the power grid equipment. The memory is used to store various types of data to support operation at the terminal device, and these data may include, for example, instructions for any application or method operating on the terminal device, as well as application-related data. The Memory may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as Static Random Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk, or optical disk.
In an exemplary embodiment, the terminal Device may be implemented by one or more Application Specific 1 integrated circuits (AS 1C), a Digital Signal Processor (DSP), a Digital Signal Processing Device (DSPD), a Programmable Logic Device (PLD), a Field Programmable Gate Array (FPGA), a controller, a microcontroller, a microprocessor, or other electronic components, and is configured to perform the ad hoc query method for automatically operating the grid Device according to any one of the embodiments described above, so AS to achieve the technical effects consistent with the above method.
In another exemplary embodiment, a computer-readable storage medium is also provided, which includes a computer program, which when executed by a processor, implements the steps of the ad hoc query method for the automatic operation of the power grid device according to any one of the above embodiments. For example, the computer-readable storage medium may be the above-mentioned memory including a computer program, and the above-mentioned computer program may be executed by a processor of a terminal device to implement the ad hoc query method for automatically operating a power grid device according to any one of the above-mentioned embodiments, and achieve the technical effects consistent with the above-mentioned method.
While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention.
Claims (10)
1. An ad hoc inquiry system for automatic operation of power grid equipment, comprising:
the system comprises a query configuration module, an ad hoc query module and a high-level layout module;
the query configuration module is in communication connection with the ad hoc query module and is used for converting data in a database into a user-oriented business object;
the ad hoc query module is in communication connection with the query configuration module and the advanced layout module and is used for setting different query modes and query conditions for a user;
and the advanced layout module is in communication connection with the ad hoc inquiry module and is used for performing advanced layout on an inquiry result according to a service scene and user requirements.
2. The ad hoc query system according to claim 1, wherein the query configuration module comprises:
the system comprises a semantic model management module, a screening condition configuration module, a data source configuration module and a sequence configuration module;
the semantic model management module is used for managing a theme domain, a data theme and an entity object;
the screening condition configuration module is used for setting screening conditions and combinations of the screening conditions;
the data source configuration module is used for configuring the relationship with the subject domain according to the data source queried by the system;
and the sequence configuration module is used for making the browsing and querying results clearer according to different sequence arrangements and data combination requirements.
3. The ad hoc query system according to claim 2, wherein the semantic model management module comprises:
the system comprises a theme domain management module, a data theme management module and an entity object management module;
the theme domain management module is used for determining a theme domain according to the requirement of system query statistics;
the data theme management module is used for decomposing the theme domain, analyzing the attribute and the behavior related to the theme domain in each system and classifying the data forming the theme domain;
and the entity object management module is used for refining the data theme and determining the attribute of the entity object.
4. The ad hoc query system of claim 2, wherein the screening condition configuration module comprises:
the device comprises a calculation function setting module, a screening condition setting module and a condition relation setting module;
the calculation function setting module is used for selecting a built-in calculation statistical function to meet the requirement of data operation;
the screening condition setting module is used for setting the condition of the query data;
and the condition relation setting module is used for combining a plurality of screening conditions into a required condition relation.
5. The ad hoc inquiry system according to claim 1, wherein said ad hoc inquiry module comprises:
the system comprises a user-defined query module, an instant query module, a timing query module and a result export module;
the user-defined query module is used for setting user-defined query conditions according to user requirements and actual conditions;
the instant query module is used for carrying out real-time query according to the user requirements and the actual conditions;
the timing query module is used for performing timing query on data which is not high in use frequency but high in importance degree;
and the result exporting module is used for exporting and storing the query result.
6. The ad hoc query system of claim 5, wherein the custom query module comprises:
a user-defined query condition module, a user-defined screening template module and a template preview module;
the user-defined query condition module is used for displaying built-in query conditions through a visual interface so as to enable a user to select the query conditions;
the user-defined screening template module is used for setting a user-defined screening template according to the historical query conditions of the user;
and the template previewing module is used for previewing the user-defined screening template.
7. The ad hoc query system according to claim 1, wherein the advanced layout module comprises:
the data processing module and the reminding and early warning module;
the data processing module is used for editing, calculating, combining and comparing data to form final data and supporting subsequent report export and release;
and the reminding and early warning module is used for informing related personnel to check the statistical result in a set mode according to reminding and early warning conditions set by a user.
8. An ad hoc query method for automatic operation of power grid equipment is characterized by comprising the following steps:
selecting data dimensionality of data according to user requirements and configuring screening conditions;
performing data query according to the data dimension, the screening condition and the query mode, and returning a data query result;
and the query result is laid out through a visualization technology, and the laid-out query result is displayed to a user.
9. A terminal device, comprising:
one or more processors;
a memory coupled to the processor for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the ad hoc inquiry method for the automated operation of the power grid device of claim 8.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the ad hoc query method for the automated operation of a power grid device according to claim 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111557847.6A CN114443683A (en) | 2021-12-16 | 2021-12-16 | System, method, device and medium for on-site query of automatic operation of power grid equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111557847.6A CN114443683A (en) | 2021-12-16 | 2021-12-16 | System, method, device and medium for on-site query of automatic operation of power grid equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114443683A true CN114443683A (en) | 2022-05-06 |
Family
ID=81364482
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111557847.6A Pending CN114443683A (en) | 2021-12-16 | 2021-12-16 | System, method, device and medium for on-site query of automatic operation of power grid equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114443683A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116821164A (en) * | 2023-08-31 | 2023-09-29 | 成都智慧锦城大数据有限公司 | Searching method for realizing visual flexible combination dynamic configuration |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
| US20180373753A1 (en) * | 2017-06-27 | 2018-12-27 | Vladyslav Flaks | Technologies for implementing ontological models for natural language queries |
| CN109684403A (en) * | 2018-12-24 | 2019-04-26 | 广东电网有限责任公司 | Dispatching of power netwoks information query method |
| CN111708516A (en) * | 2020-05-20 | 2020-09-25 | 上海迅搭云科技有限公司 | Web application customization development system on network |
| CN112417010A (en) * | 2020-11-06 | 2021-02-26 | 珠海市卓轩科技有限公司 | User group tracking analysis system and method based on configuration |
-
2021
- 2021-12-16 CN CN202111557847.6A patent/CN114443683A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
| US20180373753A1 (en) * | 2017-06-27 | 2018-12-27 | Vladyslav Flaks | Technologies for implementing ontological models for natural language queries |
| CN109684403A (en) * | 2018-12-24 | 2019-04-26 | 广东电网有限责任公司 | Dispatching of power netwoks information query method |
| CN111708516A (en) * | 2020-05-20 | 2020-09-25 | 上海迅搭云科技有限公司 | Web application customization development system on network |
| CN112417010A (en) * | 2020-11-06 | 2021-02-26 | 珠海市卓轩科技有限公司 | User group tracking analysis system and method based on configuration |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116821164A (en) * | 2023-08-31 | 2023-09-29 | 成都智慧锦城大数据有限公司 | Searching method for realizing visual flexible combination dynamic configuration |
| CN116821164B (en) * | 2023-08-31 | 2023-11-21 | 成都智慧锦城大数据有限公司 | Searching method for realizing visual flexible combination dynamic configuration |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228169B (en) | Chart making method, device, equipment and medium based on eCharts tool | |
| CN108512691A (en) | Cloud automatic early-warning O＆M monitoring system based on Hadoop | |
| US10055106B2 (en) | Information display processing system, information display processing method, and program recording medium | |
| CN110007913A (en) | Visual flow chart of data processing setting method, device, equipment and storage medium | |
| US20180067905A1 (en) | System and method for dynamic linking between graphic documents and comment data bases | |
| CN112015412A (en) | Device and method for generating business model based on form engine | |
| CN102495832A (en) | System for automatically generating document in software development process | |
| CN105701300A (en) | Spacecraft electrical information query system | |
| CN115796549A (en) | Comprehensive energy management and control platform constructed based on low-code platform | |
| CN112527250A (en) | Software development platform based on visualization | |
| WO2023116216A1 (en) | Data visualization method and apparatus, and device and storage medium | |
| CN114443683A (en) | System, method, device and medium for on-site query of automatic operation of power grid equipment | |
| CN108830540B (en) | Method, device and system for processing engineering project archive | |
| CN116610394A (en) | Template and module-based data visualization page configuration method, system and device | |
| CN115935915A (en) | Document processing method, computer device, and storage medium | |
| CN115471582A (en) | Map generation method and device, computer equipment and storage medium | |
| CN112363698A (en) | Method, device, electronic equipment and medium for visually constructing web page | |
| CN112069780A (en) | Control method and device for custom billboard data display in third-party platform | |
| CN114935996B (en) | Method, computer device and storage medium for online processing of documents | |
| CN113722341B (en) | Operation data processing method and related device | |
| CN112215454B (en) | Intelligent decision-making system for power grid enterprise management | |
| CN108460816A (en) | A kind of interactive intelligent generation system of intelligent grid communication planning design report | |
| CN113806596B (en) | Operation data management method and related device | |
| CN113704593B (en) | Operation data processing method and related device | |
| CN116362634B (en) | System, method, equipment and storage medium for integrated management of system and process |
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: 20220506 |