CN115034192A - Data table generation and verification method, device, equipment and medium - Google Patents

Data table generation and verification method, device, equipment and medium Download PDF

Info

Publication number
CN115034192A
CN115034192A CN202210767588.8A CN202210767588A CN115034192A CN 115034192 A CN115034192 A CN 115034192A CN 202210767588 A CN202210767588 A CN 202210767588A CN 115034192 A CN115034192 A CN 115034192A
Authority
CN
China
Prior art keywords
data
target
power
verification
characteristic value
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202210767588.8A
Other languages
Chinese (zh)
Inventor
李锡刚
李俊辉
孔慧超
吴新雄
刘炜彬
叶锦辉
周泓
王文钟
梁咏秋
张德乐
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangdong Power Grid Co Ltd
Dongguan Power Supply Bureau of Guangdong Power Grid Co Ltd
Original Assignee
Guangdong Power Grid Co Ltd
Dongguan Power Supply Bureau of Guangdong Power Grid Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Guangdong Power Grid Co Ltd, Dongguan Power Supply Bureau of Guangdong Power Grid Co Ltd filed Critical Guangdong Power Grid Co Ltd
Priority to CN202210767588.8A priority Critical patent/CN115034192A/en
Publication of CN115034192A publication Critical patent/CN115034192A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60Protecting data
    • G06F21/602Providing cryptographic facilities or services
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60Protecting data
    • G06F21/64Protecting data integrity, e.g. using checksums, certificates or signatures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/20Natural language analysis
    • G06F40/237Lexical tools
    • G06F40/242Dictionaries
    • YGENERAL 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
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS 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/00Systems supporting electrical power generation, transmission or distribution
    • Y04S10/50Systems 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 Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • Artificial Intelligence (AREA)
  • Computer Security & Cryptography (AREA)
  • Bioethics (AREA)
  • Computer Hardware Design (AREA)
  • Software Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method, a device, equipment and a medium for generating and checking a data table. The method comprises the following steps: acquiring power data acquired by a corresponding power subsystem in a set time period, adding the power data to a power data set constructed by the corresponding power subsystem, acquiring a target power characteristic value matched with the power data set, determining a matched target form template according to the target power characteristic value, and importing the data in the power data set into the target form template to form a target data form; and carrying out table integrity check on the target data table and obtaining a check result. Through a specific correlation mode, a data form template matched with the electric power data set is found out, the electric power data set is led into the data form template, a target data form is generated, the report generation efficiency and accuracy are effectively improved, meanwhile, verification is carried out after the form is generated, the number of times of manually verifying the data format by a user is reduced, and the correctness of the form and the efficiency of checking the data of the form are improved.

Description

Data table generation and verification method, device, equipment and medium
Technical Field
The present invention relates to the field of data processing, and in particular, to a method, an apparatus, a device, and a medium for generating and checking a data table.
Background
The power grid subsystem is an electric energy production and consumption system which is formed by links of power generation, power transmission, power transformation, power distribution, power utilization and the like. In order to realize the production and supply and sale of electric energy and simultaneously ensure the safe and stable operation of the power grid, the power grid subsystem is respectively provided with corresponding information and control systems in each link and different levels, and the systems consist of various acquisition sensors, monitoring equipment, communication equipment, safety protection devices, automatic control devices and monitoring automation and scheduling automation systems and acquire, transmit and store mass data.
At present, in the work of processing daily basic and complicated business report forms by a plurality of power grid subsystems, the data of the forms are realized in a manual input mode, the work intensity requirement of workers is high, the work efficiency is low, and the system resources and the human resources are not saved favorably.
Disclosure of Invention
The invention provides a method, a device, equipment and a medium for generating and checking a data table, which are used for realizing automatic generation and checking of the data table.
According to a first aspect of the present invention, a method for generating and checking a data table is provided, which includes:
acquiring power data acquired by a corresponding power subsystem in a set time period, adding the power data to a power data set constructed by the corresponding power subsystem, and acquiring a target power characteristic value matched with the power data set;
according to the target power characteristic value, determining a matched target form template from pre-established data form templates, and importing the power data set data into the target form template to form a target data form;
and carrying out table integrity check on the target data table and obtaining a check result.
According to a second aspect of the present invention, there is provided a data table generation verification apparatus, including:
the characteristic value acquisition module is used for acquiring power data acquired by a corresponding power subsystem in a set time period, adding the power data into a power data set constructed by the corresponding power subsystem, and acquiring a target power characteristic value matched with the power data set;
the forming module is used for determining a matched target form template from pre-established data form templates according to the target power characteristic value, and importing the power data centralized data into the target form template to form a target data form;
and the result acquisition module is used for carrying out table integrity check on the target data table and acquiring a check result.
According to a third aspect of the present invention, there is provided an electronic apparatus comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores a computer program executable by the at least one processor, the computer program being executable by the at least one processor to enable the at least one processor to perform a method of generating and checking a data table according to any of the embodiments of the present invention.
According to another aspect of the present invention, there is provided a computer-readable storage medium storing computer instructions for causing a processor to implement the method for generating and checking a data table according to any one of the embodiments of the present invention when the computer instructions are executed.
According to the technical scheme of the embodiment of the invention, the electric power data collected by a relative electric power subsystem in a set time period is obtained, the electric power data is added into an electric power data set constructed corresponding to the electric power subsystem, and a target electric power characteristic value matched with the electric power data set is obtained; according to the target power characteristic value, determining a matched target form template from pre-established data form templates, and importing the power data set data into the target form template to form a target data form; and carrying out table integrity check on the target data table and obtaining a check result. Through a specific correlation mode, a data form template matched with the electric power data set is found out, the electric power data set is led into the data form template, a target data form is generated, the report generation efficiency and accuracy are effectively improved, meanwhile, verification is carried out after the form is generated, the number of times of manually verifying the data format by a user is reduced, and the correctness of the form and the efficiency of checking the data of the form are improved.
It should be understood that the statements in this section are not intended to identify key or critical features of the embodiments of the present invention, nor are they intended to limit the scope of the invention. Other features of the present invention will become apparent from the following description.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a flowchart of a method for generating and verifying a data table according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a data table generation and verification apparatus according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of an electronic device implementing the data table generation and verification method according to the embodiment of the present invention.
Detailed Description
In order to make those skilled in the art better understand the technical solutions of the present invention, 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 obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example one
Fig. 1 is a flowchart of a method for generating and checking a data table according to an embodiment of the present invention, where the embodiment is applicable to the generation and checking of a data table, the method may be executed by a data table generation and checking apparatus, the data table generation and checking apparatus may be implemented in a form of hardware and/or software, and the data table generation and checking apparatus may be configured in an electronic device.
Preferably, the data table generating and verifying device may be configured in a server associated with the power subsystem.
As shown in fig. 1, the method includes:
and S110, acquiring power data acquired by the corresponding power subsystem in a set time period, adding the power data to a power data set constructed by the corresponding power subsystem, and acquiring a target power characteristic value matched with the power data set.
In this embodiment, the set time period may be understood as acquiring the power data for a set time length, and if the set time period may be 1 hour, the power data within 1 hour is acquired every 1 hour. The power data may be understood as information to be acquired in the form of data. A power data set may be understood to comprise a collection of multiple power data.
In this embodiment, the power subsystem may be understood as a system capable of implementing functions of collecting and preprocessing corresponding data, and may include one or more of a Production Management System (PMS), an Energy Management System (EMS), and a Geographic Information System (GIS).
In the present embodiment, the target power characteristic value may be understood as a way for characterizing the power data set, and may be a number, a character string, an expression, or the like.
Specifically, the power subsystem collects power data, the execution main body can send a power data acquisition instruction containing a set time period to the power subsystem, the power subsystem receives the instruction and transmits a plurality of power data of the corresponding set time period, the execution main body acquires the plurality of power data of the set time period and adds the power data to a power data set constructed by the power subsystem, the execution main body can assign the power data set through an assignment statement, the power data set is characterized in a target power characteristic value mode, a target power characteristic value matched with the power data set is obtained, wherein the target power values of different power data sets are different, and the power data set can be quickly searched through the target power characteristic value.
And S120, according to the target power characteristic value, determining a matched target form template from pre-established data form templates, and importing the power data set data into the target form template to form a target data form.
In the present embodiment, the data table template may be understood as a data template established in a table form. The target table template may be understood as a table template matching the target power characteristic value. The target data table may be understood as a table including power data corresponding to the target power characteristic value.
Specifically, a data form template may be blanked in advance, and form rules of different power subsystems may be filled in the blank data form template to obtain corresponding data form templates. The execution agent may obtain the power data set characterized by the target power value and a corresponding target table template by sending an obtaining instruction including the target power value to the power subsystem, and the execution agent may call a table program to import data in the power data set into corresponding positions in a table according to table rules in the target table template to form a target data table.
And S130, carrying out table integrity check on the target data table and obtaining a check result.
In this embodiment, the verification result may be understood as representing that the verification passes or the verification fails.
It will be appreciated that one or more of the power subsystems may correspond to a server, which may be connected to a computer device, and that, since the target data form is automatically formed, a person using the corresponding computer device may need to verify the target data form in order to ensure its accuracy.
Specifically, the computer device sends a verification instruction of a corresponding target data table to the execution main body, after receiving the verification instruction containing the target power characteristic value, the execution main body finds out a corresponding target data table and a corresponding power data set according to the target power characteristic value, obtains corresponding data in the target data table according to a set verification rule, compares the corresponding data with original data such as the power data set, and obtains a verification result according to the comparison to achieve integrity verification, wherein the integrity verification may include formula verification and logic expression verification.
According to the data table generating and checking method provided by the embodiment, the data table template matched with the electric power data set is found out through a set association mode, the electric power data set is led into the data table template to generate the target data table, the configuration process and operation are very simple, the consumed time is short, the report generating efficiency and the accuracy are effectively improved, meanwhile, the checking is carried out after the table is generated, the checking requirements on differentiated table service data of different users are met, the number of times of manually checking the data format of the user is reduced, and the accuracy of the table and the efficiency of checking the table data are improved.
As a first optional embodiment of this embodiment, determining a matching target table template from pre-established data table templates according to the target power characteristic value includes:
a1, searching a target dictionary characteristic value corresponding to the target power characteristic value according to a pre-constructed characteristic value association table.
In this embodiment, the characteristic value association table may be understood as a table that associates target power characteristic values with corresponding target dictionary characteristic values. The target dictionary feature values may be understood as one way to characterize the target data dictionary and may be numbers, strings, expressions, or the like.
Specifically, the execution main body acquires a target power characteristic value transmitted by the power subsystem, brings the target power characteristic value into a characteristic value association table, searches the characteristic value association table, and searches for a target dictionary characteristic value corresponding to the target power characteristic value.
For example, the target power characteristic value may be set to 1, and if the target dictionary characteristic value corresponding to the target power characteristic value 1 in the characteristic value association table is 25, the found target dictionary characteristic value corresponding to the target power characteristic value 1 is 25.
b1, determining the target data dictionary corresponding to the characteristic value of the target dictionary, and obtaining the target table template having the association relation with the target data dictionary from the established data table templates.
In this embodiment, the target data dictionary may be understood as a manner for storing information and configuration included in the power data of the corresponding power subsystem, and each data dictionary corresponds to one power subsystem, for example, a data dictionary related to the production management system is established. The data dictionary may include a report type, an arrangement mode of automatic data, an area of the report, a header of each row of the report, a report calculation formula, a default format of null data, a unit of data, a conversion mode of data, and the like.
Specifically, when the target data dictionary is established, the value is assigned to obtain a corresponding target dictionary characteristic value. And the execution main body searches a target data dictionary corresponding to the target dictionary characteristic value in the plurality of data dictionaries according to the target dictionary characteristic value, and finds out a target table template corresponding to the target data dictionary from the plurality of table templates according to the incidence relation between each data dictionary and each table template. The target data dictionary can also be imported into the blank form template to form a target form template by establishing the blank form template, and the incidence relation between the target form template and the target data dictionary is established.
Optionally, the step of constructing the feature value association table includes:
a11, establishing at least one data dictionary related to the power subsystem, and setting dictionary characteristic values relative to each data dictionary.
Specifically, the execution main body can send an instruction for acquiring power data including a set time period to the power subsystem, the power subsystem receives the instruction and transmits a plurality of power data corresponding to the set time period, when the execution main body receives the power data transmitted by the power subsystem, information of the power subsystem is acquired, a data dictionary is established according to the information of the power subsystem, the data dictionary set can be assigned through assignment statements, and the data dictionary is represented in a dictionary characteristic value mode, wherein dictionary characteristic values of each data dictionary are different.
For example, the execution agent receives power data with a set time period of 1 hour, the power subsystem corresponding to the power data is a production management system, and information that may be included in the production management system is a task number, a completion number, a yield calculation formula, and the like. The report type corresponding to the information of the production management system can be; the arrangement mode of the automatic data can be from big to small; the area of the report can be the name of each product in the first column, the first action task number in the second column, the first action completion number in the third column and the first action yield in the fourth column; the head of the first row of the report can be the task number, the completion number and the yield; the report calculation formula can be: the finished product rate is the number of finished works/number of tasks; a default format for null data; the unit of data can be single, percent, etc.; the conversion mode of the data forms a data dictionary of the production management system.
For example, the dictionary feature value of the data dictionary related to the production management system is assigned as a, the dictionary feature value of the data dictionary related to the energy management system is assigned as b, and the dictionary feature value of the data dictionary related to the geographic information system is assigned as c.
a12, establishing at least one power data set related to the power subsystem, and setting power characteristic values relative to each power data set, wherein the power data set is empty initially.
Specifically, the execution main body obtains a plurality of electric power data in a set time period transmitted by the electric power subsystem, adds the electric power data to an electric power data set correspondingly constructed by the electric power subsystem, assigns the electric power data set through an assignment statement, characterizes the electric power data set in the form of an electric power characteristic value, and obtains the electric power characteristic value matched with the electric power data set. Wherein the power data set is empty when there is no power data, i.e. initially.
For example, the power characteristic value of the power data set related to the production management system may be assigned as 1, the power characteristic value of the power data set related to the energy management system may be assigned as 2, and the power characteristic value of the power data set related to the geographic information system may be assigned as 3.
a13, establishing the direct characteristic value corresponding relation between the characteristic value of each dictionary and the characteristic value of the electric power through the corresponding electric power subsystem, and forming a characteristic value association table containing the corresponding characteristic value.
It can be known that, since the data dictionary and the power data set both belong to the same power subsystem and are constructed according to the same time period, the dictionary feature values are used for representing the data dictionary, the power feature values are used for representing the power data set, and each dictionary feature value and each power feature value are different, the corresponding relationship can be directly established according to the dictionary feature values and the power feature values.
Specifically, a dictionary characteristic value and an electric characteristic value of each electric subsystem are obtained, and the dictionary characteristic value and the electric characteristic value of each electric subsystem are corresponding to form a characteristic value association table including the corresponding characteristic values.
Illustratively, the power characteristic value of the production management system is 1, and the dictionary characteristic value is a; the power characteristic value of the energy management system is 2, and the dictionary characteristic value is b; the power characteristic value of the geographic information system is 3, and the dictionary characteristic value is c. Then 1 in the eigenvalue correlation table corresponds to a, 2 to b, and 3 to c.
The step of establishing the incidence relation between the data dictionary and the data table template comprises the following steps:
b11, establishing at least one data form template, and importing the constructed data dictionary into the data form template.
For example, at least one data table template is established first, the constructed data dictionary is imported into the data table template, and since the data table may include a plurality of cells, header information of each row of a report in the data dictionary is filled into the corresponding cell according to area information of the report, for example, task numbers in a certain power subsystem are filled in a first column from the left of the table, completion numbers are filled in a second column from the left of the table, yield numbers are filled in a third column from the left of the table, and a report type, an arrangement mode of automatic data, an area of the report, a report calculation formula, a default format of null data, a unit of data, a conversion mode of data, and the like are imported into the data table template.
b12, determining that the association relationship exists between the data table template and the imported data dictionary.
Specifically, the dictionary feature values of the data dictionary may be assigned to the data table templates established according to the data dictionary, and the association relationship between the dictionary feature values and the data table templates may be established according to the dictionary feature values.
For example, the dictionary feature value of the production management system is a, and the dictionary feature value a is assigned to the data table template, then a may also characterize the data table template.
Through the configuration of the first optional embodiment of this embodiment, the data dictionary is built, the information and the configuration rule contained in the power subsystem are stored in the data dictionary mode, the data table template is built according to the data dictionary, and the corresponding relationship between the data table template and the data table template is established, so that the configuration process is simplified, and the report generation efficiency is effectively improved.
As a second optional embodiment of this embodiment, on the basis of the above steps, performing table integrity check on the target data table, and obtaining a check result, includes:
a2, after receiving the verification instruction of the target data table, verifying the verification instruction.
In this embodiment, the verification instruction may be understood as a verification requirement issued by a person using the computer device through the computer device, and may include a target dictionary characteristic value, a target power characteristic value, and identification information that need to be verified.
Specifically, if the relevant person wants to verify the formed target data table, the verification instruction can be transmitted to the execution main body by clicking the verification control, and after the execution main body receives the verification instruction, verification instruction verification is required to be performed in order to ensure that the verification instruction is sent by the relevant person.
b2, when the verification instruction meets the verification condition, carrying out formula verification on each cell included in the target data table according to the verification instruction, and carrying out logical expression verification on the target data table.
In this embodiment, the verification condition may be understood as a condition for determining whether the verification instruction is sent by a relevant person, and may be determined whether the verification instruction includes the identification information.
Specifically, after the execution main body receives the check instruction, the information included in the check instruction is confirmed, whether the information includes the identification information or not is checked, if the information includes the identification information, the check instruction is considered to meet the verification condition, the corresponding target data table, the target data dictionary and the target power data set are found out according to the characteristic value information included in the check instruction, the formula set is compared with the data dictionary, and whether the check formula is correct or not is determined. And if the formula check is passed, carrying out logic expression check, and if the formula check is not passed, not carrying out logic expression check. When the data passes the formula verification, the data in the target data table and the corresponding data in the target power data set are compared, and whether the two data are the same or not is judged, so that the logical expression verification of the target data table is realized.
Illustratively, the target data table includes only the device completion number: 13 and switch completion number: 21, the data 13 and the data 21 can be substituted into a logic expression, and the device completion number 14 and the switch completion number 21 are found from the target data set according to the data information in the logic expression, so that the logic expression is as follows: the number of finished devices: 13 ≠ 14, number of switch completions: if 21 is 21, the device completion number in the target data table is incorrect.
c2, obtaining a logic check result and a formula check result.
In this embodiment, the logic check result may be data correct or data error; the formula check result may be formula correct or formula incorrect.
Specifically, the execution subject obtains a logic verification result, and determines whether each data in the target data table is consistent with the target power data set; the execution subject obtains a formula check result and determines whether the formula in the target data table is consistent with that in the target data dictionary. And transmitting the logic verification result and the formula verification result to computer equipment for relevant personnel to check.
Illustratively, the logical check result shows that the device completion count in the target data table is incorrect.
Optionally, a second optional embodiment of this embodiment, on the basis of the above steps, further includes:
and if the check instruction does not meet the verification condition, determining that the check instruction is an abnormal request, refusing to respond to the check instruction and generating a request abnormity early warning.
Specifically, the execution main body determines that the check instruction does not satisfy the check regulation if the check instruction does not satisfy the check regulation, and if the check instruction is not the check instruction sent by the relevant person, the execution main body refuses to respond to the check instruction, generates a request abnormal instruction, sends the request abnormal instruction to the computer device, and performs request abnormal early warning, for example, performs popup window display in the computer device to "receive the abnormal check instruction".
Optionally, the step of verifying the instruction verification includes:
a21, extracting the identification information contained in the check instruction.
In this embodiment, the identification information may be understood as information for characterizing the encrypted identification. The encrypted identifier may be in the form of a number, a character string, or the like, and is replaced according to a set period, where if the set period may be 5s, the identifier information in the 5s may be a1, the identifier information in the next 5s may be a2, and so on, and the encrypted identifier is replaced according to the period.
Specifically, the execution main body sends identification information containing the encrypted identification to the computer equipment according to a set period, the computer equipment receives the identification information, when relevant personnel send a verification instruction, the computer equipment automatically adds the received identification information to the verification instruction and transmits the verification instruction to the execution main body, and the execution main body receives the verification instruction and extracts the identification information contained in the verification instruction.
a22, if the identification information contains the pre-negotiated encrypted identification, determining that the verification instruction meets the verification condition; otherwise, determining that the check instruction does not meet the verification condition.
Specifically, the execution main body compares the encrypted identifier in the identifier information with the pre-negotiated encrypted identifier in the corresponding period, and if the encrypted identifier is the same as the pre-negotiated encrypted identifier in the corresponding period, the execution main body determines that the verification instruction meets the verification condition; and if the verification instruction is different or the encrypted identification is not included in the identification information, determining that the verification instruction does not meet the verification condition.
Optionally, according to the check instruction, performing logical expression check on the target data table, and performing formula check on each included cell, including:
b21, determining the target data dictionary related to the target data table according to the dictionary characteristic value contained in the verification instruction.
Specifically, the target data table is established according to the dictionary feature values, so that the dictionary feature values corresponding to the target data table included in the verification instruction can be obtained, and the corresponding target data dictionary can be found according to the dictionary feature values because the dictionary feature values are used for representing the corresponding target data dictionary.
b22, according to the target data dictionary, carrying out formula check on the target data table.
Specifically, all the cells in the target data table are traversed, formulas in the cells are extracted to form a formula set, the formula set is compared with corresponding formulas in the target data dictionary, and whether the formulas are correct is checked.
Illustratively, the completion rate formula may be included in the target data table: and A is B/C and a generation rate formula: and E, extracting a finishing rate formula and a generation rate formula to generate a formula set, and comparing the formula set with the finishing rate formula A, D/F and the generation rate formula E, D/A in the target data dictionary to obtain that the finishing rate formula in the target data table is wrong, the generation rate formula is wrong, and the verification result is that the formula is not verified.
b23, determining a target power data set associated with the target data table according to the power characteristic value contained in the verification instruction.
Specifically, the target data table is established according to the power characteristic value, so that the power characteristic value corresponding to the target data table included in the verification instruction can be obtained, and the corresponding target power data can be found according to the power characteristic value because the power characteristic value is used for representing the corresponding target power data.
b24, carrying out logic expression check on the target data table according to the target power data set.
Specifically, a logic expression is generated according to the target power data set, wherein the logic expression may include mathematical signs equal to or unequal to, data information, and the like. And selecting corresponding data in the target power data set according to data information in the logic expression, traversing all cells in the target data table to find out the corresponding data, comparing the two data, and judging whether the two data are the same or not, thereby realizing the logic expression verification of the target data table.
Illustratively, the target data table includes only the device completion number: 13 and switch completion number: 21, the data 13 and the data 21 can be substituted into a logic expression, and the device completion number 14 and the switch completion number 21 are found from the target data set according to the data information in the logic expression, so that the logic expression is as follows: the number of finished devices: 13 ≠ 14, number of switch completions: if 21 is equal to 21, it can be known that the device completion number in the target data table is wrong, and the logical expression check is not passed.
Optionally, the second optional embodiment further includes:
a3, if the formula verification result is that the formula verification fails, carrying out a first alarm prompt of formula verification failure.
In this embodiment, the first alarm prompt may be understood as a prompt for showing that the formula verification fails, and may be prompted in the form of sound, pop-up window, or the like.
Specifically, if the formula verification result is that the formula verification fails, the execution subject generates a formula verification failure instruction and sends the formula verification failure instruction to the computer device, and the computer device can pass a popup window form, such as "formula verification fails"; or a first alarm prompt is given to related personnel in a sound mode, such as 'formula check failure'. And if the formula check is not passed, the logic check is not carried out.
b3, if the formula check result is that the formula check is passed, but the logical expression check result is that the logical check is not passed, performing a second alarm prompt of the logical check time report.
In this embodiment, the second alarm prompt may be understood as a prompt for showing that the logical expression check fails, and may be prompted in the form of sound, pop-up window, or the like.
Specifically, if the formula check result is that the formula check is not passed, the logical expression check is not performed. If the formula check result is that the formula check is passed, but the result of the logic expression check is that the logic check is not passed, the execution main body generates a logic check failure instruction and sends the logic check failure instruction to the computer equipment, and the computer equipment can pass a form of a popup window, such as 'logic check failure'; or a second alarm prompt is given to related personnel in a sound mode, such as 'logic verification fails'.
c3, if the formula check result is pass formula check and the logical expression check result is pass logical check, then carrying out message feedback of successful check.
Specifically, if the formula check result is that the formula check is passed and the result of the logical expression check is that the logical check is passed, the execution subject generates a check success instruction and sends the check success instruction to the computer device, and the computer device can pass a popup window form, such as "check success"; or through sound, such as "check success", to give feedback to the relevant person that the check was successful.
Through the arrangement of the second optional embodiment of the embodiment, the data form template is established according to the data dictionary, the connection with the specific power subsystem is established through the plurality of data dictionaries, the data in the power subsystem is imported into the corresponding data form template according to the setting of the data dictionary, the configuration process and operation are very simple, the consumed time is short, the data form generation efficiency and the accuracy are effectively improved, meanwhile, after the data form is generated, the setting and the data in the complete form are verified through formula verification and logic verification, the verification and inspection requirements on different user differentiated form service data are met, the number of times of manually verifying the data format of a user is reduced, and the correctness of the formula calculation result and the efficiency of form data verification are improved.
Example two
Fig. 2 is a schematic structural diagram of a device for generating and verifying a data table according to a second embodiment of the present invention. As shown in fig. 2, the apparatus includes: a characteristic value obtaining module 21, a forming module 22 and a result obtaining module 23. Wherein the content of the first and second substances,
the characteristic value obtaining module 21 is configured to obtain power data collected by the corresponding power subsystem in a set time period, add the power data to a power data set constructed by the corresponding power subsystem, and obtain a target power characteristic value matched with the power data set.
And the forming module 22 is configured to determine a matched target form template from pre-established data form templates according to the target power characteristic value, and import the power data set into the target form template to form a target data form.
And the result obtaining module 23 is configured to perform table integrity check on the target data table and obtain a check result.
According to the data table generating and checking device provided by the second embodiment, the data table template matched with the electric power data set is found out through a specific association mode, the electric power data set is led into the data table template, the target data table is generated, the report generation efficiency and the accuracy are effectively improved, meanwhile, checking is performed after the table is generated, the number of times of manually checking the data format by a user is reduced, and the correctness of the table and the efficiency of checking the data of the table are improved.
Optionally, the feature value obtaining module 21 includes:
and the searching unit is used for searching the target dictionary characteristic value corresponding to the target power characteristic value according to the pre-constructed characteristic value association table.
The method comprises the following steps of:
establishing at least one data dictionary related to the power subsystem, and setting dictionary characteristic values relative to each data dictionary;
establishing at least one power data set related to the power subsystem, and setting power characteristic values relative to the power data sets, wherein the power data sets are empty initially;
and establishing a direct characteristic value corresponding relation between each dictionary characteristic value and the power characteristic value through the corresponding power subsystem to form a characteristic value association table containing the characteristic value corresponding to each characteristic value.
And the first acquisition unit is used for determining a target data dictionary corresponding to the characteristic value of the target dictionary and acquiring a target table template which has an association relation with the target data dictionary from all the established data table templates.
The establishing step of the incidence relation between the data dictionary and the data form template comprises the following steps:
establishing at least one data table template, and importing the constructed data dictionary into the data table template;
and determining that an association relationship exists between the data table template and the imported data dictionary.
Optionally, the result obtaining module 23 includes:
and the verification unit is used for verifying the verification instruction after receiving the verification instruction of the target data table.
The step of verifying the verification instruction comprises the following steps:
extracting identification information contained in the check instruction;
if the identification information contains the pre-negotiated encryption identification, determining that the verification instruction meets the verification condition; otherwise, determining that the check instruction does not meet the verification condition.
And the first checking unit is used for carrying out formula checking on each cell included in the target data table and carrying out logic expression checking on the target data table according to the checking instruction when the checking instruction meets the verification condition.
The first verification unit is specifically configured to:
determining a target data dictionary related to the target data table according to dictionary feature values contained in the verification instruction;
according to the target data dictionary, formula verification is carried out on the target data table;
determining a target power data set associated with the target data table according to the power characteristic value contained in the check instruction;
and performing logic expression check on the target data table according to the target power data set.
And the second acquisition unit is used for acquiring a logic verification result and a formula verification result.
Optionally, the result obtaining module 23 further includes:
and the early warning unit is used for determining that the check instruction is an abnormal request if the check instruction does not meet the verification condition, refusing to respond to the check instruction and generating request abnormity early warning.
Optionally, the result obtaining module 23 further includes
And if the formula verification result is that the formula verification fails, performing first alarm reminding of formula verification failure.
And if the formula verification result is that the formula verification is passed, but the result of the logic expression verification is that the logic verification is not passed, performing second alarm reminding of the logic verification time report.
And if the formula verification result is that the formula verification is passed and the logical expression verification result is that the logical verification is passed, feeding back a message of successful verification.
The data table generation and verification device provided by the embodiment of the invention can execute the data table generation and verification method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
EXAMPLE III
FIG. 3 illustrates a schematic diagram of an electronic device 10 that may be used to implement an embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 3, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM)12, a Random Access Memory (RAM)13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 can perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM)12 or the computer program loaded from a storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 may also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.
A number of components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, or the like; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
Processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, or the like. The processor 11 performs the various methods and processes described above, such as the generation check method of the data table.
In some embodiments, the data table generation verification method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the above-described data table generation verification method may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the generation-verification method of the data table by any other suitable means (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, Field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be performed. A computer program can execute entirely on a machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service are overcome.
It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired result of the technical solution of the present invention can be achieved.
The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (12)

1. A method for generating and checking a data table is characterized by comprising the following steps:
acquiring power data acquired by a corresponding power subsystem in a set time period, adding the power data into a power data set constructed by the corresponding power subsystem, and acquiring a target power characteristic value matched with the power data set;
according to the target power characteristic value, determining a matched target form template from pre-established data form templates, and importing the power data set data into the target form template to form a target data form;
and carrying out table integrity check on the target data table and obtaining a check result.
2. The method of claim 1, wherein determining a matching target form template from pre-established data form templates according to the target power characteristic value comprises:
searching a target dictionary characteristic value corresponding to the target power characteristic value according to a pre-constructed characteristic value association table;
and determining a target data dictionary corresponding to the characteristic value of the target dictionary, and acquiring a target table template having an association relation with the target data dictionary from all established data table templates.
3. The method according to claim 2, wherein the step of constructing the eigenvalue correlation table comprises:
establishing at least one data dictionary related to the power subsystem, and setting dictionary characteristic values relative to each data dictionary;
establishing at least one power subsystem-related power data set, and setting a power characteristic value relative to each power data set, wherein the power data set is initially empty;
and establishing a direct characteristic value corresponding relation between each dictionary characteristic value and the electric characteristic value through the corresponding electric subsystem, and forming a characteristic value association table containing each characteristic value.
4. The method of claim 2, wherein the step of establishing the association between the data dictionary and the data table template comprises:
establishing at least one data form template, and importing the constructed data dictionary into the data form template;
and determining that an association relationship exists between the data table template and the imported data dictionary.
5. The method of claim 1, wherein performing a table integrity check on the target data table and obtaining a check result comprises:
after receiving a checking instruction of the target data table, verifying the checking instruction;
when the verification instruction meets the verification condition, carrying out formula verification on each cell included in the target data table and carrying out logic expression verification on the target data table according to the verification instruction;
and obtaining a logic verification result and a formula verification result.
6. The method of claim 5, wherein the step of verifying the instruction validation comprises:
extracting identification information contained in the checking instruction;
if the identification information contains a pre-negotiated encryption identification, determining that the verification instruction meets a verification condition; otherwise, determining that the check instruction does not meet the verification condition.
7. The method of claim 5, further comprising:
and if the check instruction does not meet the verification condition, determining that the check instruction is an abnormal request, refusing to respond to the check instruction and generating a request abnormity early warning.
8. The method according to claim 5, wherein the performing a logical expression check on the target data table and a formula check on each included cell according to the check instruction comprises:
determining a target data dictionary associated with the target data table according to dictionary feature values contained in the verification instruction;
according to the target data dictionary, formula verification is carried out on the target data table;
determining a target power data set associated with the target data table according to the power characteristic value contained in the verification instruction;
and performing logic expression verification on the target data table according to the target power data set.
9. The method of claim 5, further comprising:
if the formula verification result is that the formula verification fails, performing first alarm reminding of formula verification failure;
if the formula verification result is that the formula verification is passed, but the logic expression verification result is that the logic verification is not passed, performing second alarm reminding of the logic verification time report;
and if the formula verification result is that the formula verification is passed and the logical expression verification result is that the logical verification is passed, performing message feedback of successful verification.
10. A data table generation/verification apparatus, comprising:
the characteristic value acquisition module is used for acquiring power data acquired by a corresponding power subsystem in a set time period, adding the power data into a power data set constructed by the corresponding power subsystem, and acquiring a target power characteristic value matched with the power data set;
the forming module is used for determining a matched target form template from pre-established data form templates according to the target power characteristic value, and importing the power data centralized data into the target form template to form a target data form;
and the result acquisition module is used for carrying out table integrity check on the target data table and acquiring a check result.
11. An electronic device, characterized in that the electronic device comprises:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein, the first and the second end of the pipe are connected with each other,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the method of generating a check of a data table of any one of claims 1-9.
12. A computer-readable storage medium storing computer instructions for causing a processor to implement the method of generating a data table according to any one of claims 1 to 9 when executed.
CN202210767588.8A 2022-06-30 2022-06-30 Data table generation and verification method, device, equipment and medium Pending CN115034192A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210767588.8A CN115034192A (en) 2022-06-30 2022-06-30 Data table generation and verification method, device, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210767588.8A CN115034192A (en) 2022-06-30 2022-06-30 Data table generation and verification method, device, equipment and medium

Publications (1)

Publication Number Publication Date
CN115034192A true CN115034192A (en) 2022-09-09

Family

ID=83128288

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210767588.8A Pending CN115034192A (en) 2022-06-30 2022-06-30 Data table generation and verification method, device, equipment and medium

Country Status (1)

Country Link
CN (1) CN115034192A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116319718A (en) * 2023-03-10 2023-06-23 北京振中电子技术有限公司 Cloud data storage processing method, system, equipment and medium
CN118153536A (en) * 2024-05-09 2024-06-07 珠海金山办公软件有限公司 Processing method and device of table formula, electronic equipment and storage medium
CN118153536B (en) * 2024-05-09 2024-07-23 珠海金山办公软件有限公司 Processing method and device of table formula, electronic equipment and storage medium

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116319718A (en) * 2023-03-10 2023-06-23 北京振中电子技术有限公司 Cloud data storage processing method, system, equipment and medium
CN116319718B (en) * 2023-03-10 2023-12-12 北京振中电子技术有限公司 Cloud data storage processing method, system, equipment and medium
CN118153536A (en) * 2024-05-09 2024-06-07 珠海金山办公软件有限公司 Processing method and device of table formula, electronic equipment and storage medium
CN118153536B (en) * 2024-05-09 2024-07-23 珠海金山办公软件有限公司 Processing method and device of table formula, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
CN116107589B (en) Automatic compiling method, device and equipment of software codes and storage medium
CN115034192A (en) Data table generation and verification method, device, equipment and medium
CN115801589B (en) Event topological relation determination method, device, equipment and storage medium
CN115603955B (en) Abnormal access object identification method, device, equipment and medium
CN115048352B (en) Log field extraction method, device, equipment and storage medium
CN117034149A (en) Fault processing strategy determining method and device, electronic equipment and storage medium
CN115934550A (en) Test method, test device, electronic equipment and storage medium
CN112328436B (en) Data processing method based on parallel processing
CN115563507A (en) Generation method, device and equipment for renewable energy power generation scene
CN115599679A (en) Test rule base updating method and device, electronic equipment and storage medium
CN116303013A (en) Source code analysis method, device, electronic equipment and storage medium
CN115659347A (en) Safety testing method and device, electronic equipment and storage medium
CN115600038A (en) Page rendering method, device, equipment and medium
CN115544010A (en) Mapping relation determining method and device, electronic equipment and storage medium
CN115361290B (en) Configuration comparison method, device, electronic equipment and storage medium
CN117762950B (en) Log data analysis processing method, device and medium based on tree structure
CN116933088A (en) Secondary equipment fault data generation method and device, electronic equipment and medium
CN115495380A (en) Test case generation method and device, electronic equipment and storage medium
CN117455684A (en) Data processing method, device, electronic equipment, storage medium and product
CN116050351A (en) Structure comparison method, device and equipment of logic expression and storage medium
CN115759969A (en) Asset management method, device, equipment and medium applied to power swapping station
CN117033057A (en) Fault root cause positioning method, device, equipment and medium based on call chain data
CN118227580A (en) Log analysis method and device, electronic equipment and storage medium
CN114491208A (en) Information processing method and device and electronic equipment
CN118261304A (en) Method, device, equipment and storage medium for generating carbon emission reduction scheme

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