Automatic information point table generation method and device and readable storage medium
By obtaining the template information of the template library and the basic information of the terminal equipment, and automatically generating and correcting the information point table, the problem of low efficiency in the generation and access of information point tables in the prior art is solved, and efficient and accurate information point table generation and access are achieved.
Patent Information
- Application Number
- CN202411611688.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-12
- Publication Date
- 2025-02-28
AI Technical Summary
In the prior art, the generation and access of information point tables rely on manual operations, resulting in low efficiency and human errors dependent on human errors, and failing to establish a close relationship with the distribution network software system.
By obtaining the template information of the template library and the basic information of the terminal device, the initial information point table is automatically generated, and the initial information point table is supported to correct the initial information point table, and the target information point table is generated to reduce the intervention of manual operations.
The automatic generation and access of information point tables is realized, the efficiency of generating information point tables is improved, the possibility of human errors is reduced, and the accuracy and consistency of information point tables is enhanced.
Smart Images

Figure CN119538888A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of circuit breaker detection, and in particular to a method, a device and a readable storage medium for generating an automatic information point table. Background Art
[0002] At present, with the continuous growth of society's demand for electricity and the continuous improvement of power quality requirements, distribution automation has become an important technical means to improve power supply reliability. The distribution automation system (Data Management System, referred to as DMS) is the main application support system for the construction of distribution network automation. All kinds of distribution automation terminal changes, changes, and renovation projects need to be manually entered into the information point table in the DMS, and each information point table must be stored, configured, and checked. Although these tasks do not require complex business skills, the workload is large, tedious, and time-consuming. At the same time, the accuracy of the information point table storage is directly related to the accuracy of the automation system data.
[0003] In the related art, the generation and access of information point tables usually rely on manual operations, such as manually generating point tables based on Excel templates and manually accessing the system. However, this method has the problem that the supporting data needs to be exported within the system, compiled outside the system, and then imported. The probability of human error is high, and a close relationship with the distribution network software system (Outage Management System, referred to as OMS) and DMS cannot be established. Therefore, there is a technical problem of low efficiency in generating information point tables.
[0004] With respect to the above-mentioned technical problem of low efficiency in generating the information point table, no effective solution has been proposed yet. Summary of the invention
[0005] The embodiments of the present invention provide a method, device and readable storage medium for generating an automatic information point table, so as to at least solve the technical problem of low efficiency in generating an information point table.
[0006] According to one aspect of an embodiment of the present invention, a method for generating an automated information point table is provided. The method may include: obtaining template information of a template library and basic information of a terminal device, wherein the template information is used to represent information stored in the template library, the template library is established using basic information of a variety of terminal devices, and the basic information is used to indicate the location and / or identification of the terminal device in the network; based on the template information and the basic information, generating an initial information point table, wherein the initial information point table is used to record and manage a variety of information points in different systems, and the information points are used to indicate target functions in different systems; in response to the state of the correction instruction being a valid state, correcting the initial information point table according to the correction instruction to obtain a target information point table.
[0007] Optionally, the method for generating an automated information point table includes: respectively acquiring basic information of a plurality of terminal devices; integrating the basic information of the plurality of terminal devices to obtain an integrated result; and establishing a template library based on the integrated result.
[0008] Optionally, the method for generating an automated information point table includes: in response to the state of the forwarding instruction being a valid state, forwarding the target information point table to the target system according to the forwarding instruction.
[0009] Optionally, in response to the state of the forwarding instruction being a valid state, forwarding the target information point table to the target system according to the forwarding instruction, including: obtaining forwarding parameters, wherein the forwarding parameters are used to indicate information about the forwarded content and the forwarding object; forwarding the target information point table to the target system according to the forwarding parameters.
[0010] Optionally, after obtaining the target information point table, the method for generating the automatic information point table further includes: storing the target information point table in a template library.
[0011] Optionally, the method for generating an automated information point table further includes: generating a corresponding target file according to the initial information point table or the target information point table, and exporting the target file.
[0012] According to another aspect of an embodiment of the present invention, a device for generating an automated information point table is also provided. The device may include: an acquisition unit, used to acquire template information of a template library and basic information of a terminal device, wherein the template information is used to represent information stored in the template library, the template library is established using basic information of a variety of terminal devices, and the basic information is used to indicate the location and / or identification of the terminal device in the network; a generation unit, used to generate an initial information point table based on the template information and the basic information, wherein the initial information point table is used to record and manage a variety of information points in different systems, and the information points are used to indicate target functions in different systems; a correction unit, used to correct the initial information point table according to the correction instruction in response to the state of the correction instruction being a valid state, to obtain a target information point table.
[0013] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is also provided, the computer-readable storage medium including a stored program, wherein when the program is executed by a processor, the device where the storage medium is located is controlled to execute the method for generating an automated information point table in an embodiment of the present invention.
[0014] According to another aspect of the embodiment of the present invention, a processor is provided, which is used to run a program, wherein the method for generating an automatic information point table in the embodiment of the present invention is executed when the program is run.
[0015] According to another aspect of the embodiment of the present invention, a computer program product is provided, which includes computer instructions, and when the computer instructions are executed by a processor, the method for generating an automatic information point table in the embodiment of the present invention is implemented.
[0016] In an embodiment of the present invention, template information of a template library and basic information of a terminal device are obtained, wherein the template information is used to represent information stored in the template library, the template library is established using basic information of a variety of terminal devices, and the basic information is used to indicate the location and / or identification of the terminal device in the network; based on the template information and the basic information, an initial information point table is generated, wherein the initial information point table is used to record and manage a variety of information points in different systems, and the information points are used to indicate target functions in different systems; in response to the state of the correction instruction being a valid state, the initial information point table is corrected according to the correction instruction to obtain a target information point table. In other words, the embodiment of the present invention can automatically generate an information point table through the template information of the template library and the basic information of the terminal device, and supports the correction of the generated information point table, thereby reducing the intervention of manual operations, thereby solving the technical problem of low efficiency in generating the information point table, and achieving the technical effect of improving the efficiency of generating the information point table. BRIEF DESCRIPTION OF THE DRAWINGS
[0017] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:
[0018] Figure 1 is a flow chart of a method for generating an automatic information point table according to an embodiment of the present invention;
[0019] Figure 2 is a schematic diagram of a fully automatic design and access system for an information point table based on a configurable template library of different types of terminal point tables according to an embodiment of the present invention;
[0020] Figure 3 is a flow chart of a method for fully automatic design and access of an information point table based on a configurable template library of different types of terminal point tables according to an embodiment of the present invention;
[0021] Figure 4 It is a schematic diagram of a device for generating an automatic information point table according to an embodiment of the present invention. DETAILED DESCRIPTION
[0022] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.
[0023] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, functional component or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, functional components or devices.
[0024] According to an embodiment of the present invention, an embodiment of a method for generating an automated information point table is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.
[0025] Figure 1 is a flow chart of a method for generating an automatic information point table according to an embodiment of the present invention, such as Figure 1 As shown, the method may include the following steps:
[0026] Step S101, obtaining template information of a template library and basic information of a terminal device.
[0027] In the technical solution provided in the above step S101 of the present invention, the template information is used to represent the information stored in the template library, which is established using the basic information of various terminal devices, and the basic information is used to indicate the location and / or identification of the terminal device in the network. The template library can also be called a point table template library.
[0028] In this embodiment, the template information of the template library and the basic information of the terminal device are obtained. For example, the user selects the required template information and terminal device information from the template library through the information point table automatic design and access system, and then the template information of the template library and the basic information of the terminal device are obtained according to the user's selection content. This is only an illustrative example, and the specific method of obtaining the template information of the template library and the basic information of the terminal device is not limited.
[0029] For example, corresponding point table template libraries are established according to different types of distribution automation terminals (such as telemetry, telesignaling, and telecontrol). These template libraries can be flexibly configured according to actual needs to adapt to the characteristics and needs of different terminal devices. Each template library contains all possible information points of the terminal device, as well as detailed information such as the format, data type, and value range of these information points.
[0030] For another example, when a new information point table needs to be generated, the user only needs to select the corresponding terminal type and template library in the tool, and then enter basic information such as the description, IP address, link address, etc. of the terminal device.
[0031] Step S102: Generate an initial information point table based on the template information and the basic information.
[0032] In the technical solution provided in the above step S102 of the present invention, the initial information point table is used to record and manage various information points in different systems, and the information points are used to indicate a specific aspect or function in different systems, that is, the target function.
[0033] In this embodiment, after the template information of the template library and the basic information of the terminal device are acquired in step S101, an initial information point table is generated according to the template information and the basic information.
[0034] Optionally, the initial information point table may include, but is not limited to: channel information, remote terminal unit (RTU for short) information, three remote point information, and the like.
[0035] For example, the corresponding information point table will be automatically generated according to the information input by the user and the selected template library, including channel information, RTU information, three-remote point information, etc.
[0036] Step S103, in response to the state of the correction instruction being a valid state, the initial information point table is corrected according to the correction instruction to obtain a target information point table.
[0037] In the technical solution provided by the above step S103 of the present invention, after the initial information point table is generated in step S102, the state of the correction instruction is obtained. When the state of the correction instruction is valid, the initial information point table is corrected according to the correction instruction to obtain the target information point table.
[0038] In this embodiment, when the state of the correction instruction is a valid state, it means that the initial information point table needs to be corrected at this time. Based on this, the initial information point table is corrected according to the correction instruction to obtain the target information point table.
[0039] For example, if the user needs to modify the exported information point table, the modified file can be directly imported into the tool and automatically updated to the template library.
[0040] It should be noted that the above embodiment can be executed by a fully automatic design and access system for an information point table.
[0041] In the above steps S101 to S103 of the present invention, the template information of the template library and the basic information of the terminal device are obtained, wherein the template information is used to represent the information stored in the template library, the template library is established by using the basic information of various terminal devices, and the basic information is used to indicate the location and / or identification of the terminal device in the network; based on the template information and the basic information, an initial information point table is generated, wherein the initial information point table is used to record and manage various information points in different systems, and the information points are used to indicate a specific aspect or function in different systems; in response to the state of the correction instruction being a valid state, the initial information point table is corrected according to the correction instruction to obtain the target information point table. That is to say, the embodiment of the present invention can automatically generate an information point table through the template information of the template library and the basic information of the terminal device, and supports the correction of the generated information point table, thereby reducing the intervention of manual operations, thereby solving the technical problem of low efficiency in generating the information point table, and achieving the technical effect of improving the efficiency of generating the information point table.
[0042] The above method of this embodiment is further introduced below.
[0043] As an optional implementation mode, the method for generating an automatic information point table also includes: respectively acquiring basic information of multiple terminal devices; integrating the basic information of the multiple terminal devices to obtain an integration result; and establishing a template library based on the integration result.
[0044] In this embodiment, basic information of various terminal devices is obtained, wherein the terminal devices may be: different types of distribution automation terminals, such as telemetry, telesignaling, and teleregulation, etc.; the basic information may be detailed information such as format, data type, and value range.
[0045] Optionally, after acquiring basic information of various terminal devices, the basic information of various terminal devices is integrated to establish a template library. That is, the various basic information is classified and sorted to establish a template library.
[0046] For example, corresponding point table template libraries are established according to different types of distribution automation terminals (such as telemetry, telesignaling, and telecontrol). These template libraries can be flexibly configured according to actual needs to adapt to the characteristics and needs of different terminal devices. Each template library contains all possible information points of the terminal device, as well as detailed information such as the format, data type, and value range of these information points.
[0047] As an optional embodiment, the method for generating an automatic information point table further includes: in response to the state of the forwarding instruction being a valid state, forwarding the target information point table to the target system according to the forwarding instruction.
[0048] In this embodiment, the state of the forwarding instruction is obtained. When the state of the forwarding instruction is valid, it means that the user needs to forward the target information point table. Based on this, the target information point table is forwarded according to the forwarding instruction.
[0049] For example, users only need to select the corresponding data management system interface and forwarding parameters, and then click the "one-click forwarding" button. After receiving the forwarding instruction, the information point table fully automatic design and access system will automatically send the information point table to the designated DMS system, and perform storage configuration and verification on it to ensure the accuracy and completeness of the information.
[0050] As an optional implementation method, in response to the status of the forwarding instruction being a valid state, forwarding the target information point table to the target system according to the forwarding instruction, including: obtaining forwarding parameters, wherein the forwarding parameters are used to indicate information about the forwarded content and the forwarding object; and forwarding the target information point table to the target system according to the forwarding parameters.
[0051] In this embodiment, the forwarding parameters of the forwarding instruction are obtained, and the target information point table is forwarded according to the forwarding parameters, wherein the forwarding parameters may be a DMS system interface or the like.
[0052] Optionally, forwarding parameters refer to a series of key information that the user needs to specify or select when performing a forwarding operation to ensure that the information point table can be correctly and effectively forwarded to the target DMS system. These forwarding parameters usually include but are not limited to the following aspects: DMS system interface, target address or path, data format, authentication information, etc.
[0053] Optionally, by precisely specifying the forwarding content and objects, it can be ensured that the data is not mis-transmitted or omitted during the transmission process, thereby ensuring the accuracy and integrity of the data.
[0054] As an optional implementation manner, after obtaining the target information point table, the method for generating the automatic information point table further includes: storing the target information point table in a template library.
[0055] In this embodiment, after the target information point table is generated or the target information point table is forwarded, the target information point table is stored in the template library.
[0056] For example, the fully automatic design and access system for information point tables will automatically send the information point tables to the designated DMS system, and perform storage configuration and verification on them to ensure the accuracy and completeness of the information.
[0057] As an optional implementation manner, the method for generating an automatic information point table further includes: generating a corresponding target file according to the initial information point table or the target information point table; and exporting the target file.
[0058] In this embodiment, according to the initial information point table or the target information point table, a corresponding target file is generated and exported. For example, the file format may be Excel, CSV, etc.
[0059] For example, the generated information point table can be exported to a standard file format (such as Excel, CSV, etc.) to facilitate users to view and modify.
[0060] It should be noted that the above embodiment can be executed by a fully automatic design and access system for an information point table.
[0061] In this embodiment, the template information of the template library and the basic information of the terminal device are obtained, wherein the template information is used to represent the information stored in the template library, the template library is established by using the basic information of various terminal devices, and the basic information is used to indicate the location and / or identification of the terminal device in the network; based on the template information and the basic information, an initial information point table is generated, wherein the initial information point table is used to record and manage various information points in different systems, and the information points are used to indicate a specific aspect or function in different systems; in response to the state of the correction instruction being a valid state, the initial information point table is corrected according to the correction instruction to obtain a target information point table. That is to say, the embodiment of the present invention can automatically generate an information point table through the template information of the template library and the basic information of the terminal device, and supports the correction of the generated information point table, thereby reducing the intervention of manual operations, thereby solving the technical problem of low efficiency in generating the information point table, and achieving the technical effect of improving the efficiency of generating the information point table.
[0062] The technical solution of the embodiment of the present invention is illustrated below in conjunction with preferred implementation modes.
[0063] At present, with the continuous growth of society's demand for electricity and the continuous improvement of power quality requirements, distribution automation has become an important technical means to improve power supply reliability. The distribution automation system (DMS) is the main application support system for the construction of distribution network automation. All kinds of distribution automation terminal changes, changes, and renovation projects need to be manually entered into the information point table in the DMS, and each information point table must be stored, configured, and checked. Although these tasks do not require complex business skills, the workload is large, tedious, and time-consuming. At the same time, the accuracy of the information point table storage is directly related to the accuracy of the automation system data.
[0064] In the related art, the generation and access of information point tables usually rely on manual operations, such as manually generating point tables based on Excel templates and manually accessing the system. However, this method has the problem that the supporting data needs to be exported within the system, compiled outside the system, and then imported. The probability of human error is high, and a close relationship with the distribution network OMS and DMS cannot be established. Therefore, there is a technical problem of low efficiency in generating information point tables. With respect to the above-mentioned technical problem of low efficiency in generating information point tables, no effective solution has been proposed so far.
[0065] However, the embodiment of the present invention proposes a method for fully automatic design and access of information point tables based on configurable point table template libraries of different types of terminals. Corresponding point table template libraries are established according to different types of distribution automation terminals. When a new information point table needs to be generated, the user only needs to select the corresponding terminal type and template library in the tool, and enter the basic information such as the description, IP address, and link address of the terminal device. The corresponding information point table will be automatically generated based on the information entered by the user and the selected template library. If the user needs to correct the exported information point table, the generated initial information point table can be corrected. The technical problem of low efficiency in generating information point tables is solved, and the technical effect of improving the efficiency of generating information point tables is achieved.
[0066] The embodiments of the present invention are further described below.
[0067] Figure 2 is a schematic diagram of a fully automatic design and access system for information point tables based on a configurable template library of different types of terminal point tables according to an embodiment of the present invention, such as Figure 2 As shown, the fully automatic design and access system 200 includes: an information point table template editing module 201, an information point table template generating module 202 and a terminal information input module 203.
[0068] In this embodiment, after the user selects a point table template, the user can edit the selected template through the information point table template editing module 201, and then generate the final point table according to the edited point table template and the terminal information entered by the user obtained by the terminal information entry module 203 according to the information point table template generation module 202, and store the point table in the database.
[0069] Figure 3 is a flow chart of a method for fully automatic design and access of information point tables based on a configurable template library of different types of terminal point tables according to an embodiment of the present invention, such as Figure 3 As shown, the method for fully automatic design and access of the information point table includes the following steps:
[0070] Step S301, constructing a configurable terminal point table template library.
[0071] In this embodiment, corresponding point table template libraries are established according to different types of distribution automation terminals (such as telemetry, telesignaling, teleregulation, etc.) These template libraries can be flexibly configured according to actual needs to adapt to the characteristics and needs of different terminal devices.
[0072] Optionally, each template library contains all possible information points of the terminal device, as well as detailed information such as the format, data type, and value range of these information points.
[0073] Step S302, realizing automatic generation of an information point table.
[0074] In this embodiment, when a new information point table needs to be generated, the user only needs to select the corresponding terminal type and template library in the system, and then enter basic information such as the description, IP address, link address, etc. of the terminal device.
[0075] Optionally, the system will automatically generate a corresponding information point table according to the information input by the user and the selected template library, including channel information, remote terminal unit information (RTU for short), three remote point information, etc.
[0076] Optionally, RTU is a device used for data collection, monitoring and control of remote devices. RTU is usually connected to devices such as sensors and actuators to transmit data to a monitoring center or control center. RTU information includes information such as the RTU model, serial number, communication protocol, communication method, and installation location. In the information point table, RTU information is used to describe the basic information and configuration of each RTU in the system for monitoring, management, and maintenance.
[0077] Step S303, supporting the export and modified import of the point table.
[0078] In this embodiment, the generated information point table can be exported to a standard file format (such as Excel, CSV, etc.) to facilitate users to view and modify.
[0079] Optionally, if the user needs to modify the exported information point table, the modified file can be directly imported into the tool and automatically updated to the template library.
[0080] Step S304: forwarding the point table information to the DMS system with one click.
[0081] In this embodiment, the information point table is forwarded to the DMS system with one click. The user only needs to select the corresponding DMS system interface and forwarding parameters in the system, and then click the "one-click forwarding" button.
[0082] Optionally, the system will automatically send the information point table to the designated DMS system, and perform storage configuration and verification on it to ensure the accuracy and completeness of the information.
[0083] Alternatively, in traditional methods, the generation and access of information point tables usually requires a lot of manual operations, such as manually generating point tables based on Excel templates, manual review and modification, etc. These operations are cumbersome and time-consuming, increasing the workload. Due to the involvement of manual operations, the probability of human error increases significantly. The accuracy of the information point table is crucial to the operation of the distribution automation system, and any error may cause system abnormality or failure.
[0084] Alternatively, under the existing technology, the generation and access process of the information point table is long and cannot quickly respond to the change requirements of the terminal equipment. This reduces work efficiency and may affect the stability and reliability of the power system. Traditional methods usually rely on a fixed template library, which is difficult to adapt to changes in terminal equipment types and characteristics. When the terminal equipment changes, the template library needs to be manually updated, which increases maintenance costs and time costs.
[0085] Optionally, the present invention can realize automatic generation and access of the information point table, reduce the intervention of manual operation, thereby improving the degree of automation and work efficiency. The use of fully automated design and access mode can significantly reduce the probability of human error and improve the accuracy of the information point table.
[0086] Optionally, based on a configurable template library, it can be flexibly adjusted according to changes in terminal device types and characteristics. This reduces maintenance costs and time costs and improves the adaptability and scalability of the system.
[0087] Optionally, by realizing the rapid generation and access of the information point table, the present invention can shorten the work process and improve work efficiency, which helps the power system to respond to the change requirements of the terminal equipment more quickly and improve the stability and reliability of the system.
[0088] Optionally, forwarding parameters refer to a series of key information that the user needs to specify or select when performing a forwarding operation to ensure that the information point table can be correctly and effectively forwarded to the target DMS system. These forwarding parameters generally include but are not limited to the following aspects.
[0089] Optionally, DMS system interface: The user needs to select or specify the interface of the target DMS system to be forwarded. Different DMS systems may have different interface standards and requirements, so selecting the correct interface is the key to ensure successful forwarding.
[0090] Optionally, target address or path: The user needs to specify the storage location or path of the information point table in the DMS system. This usually includes the database name, table name, field name, etc. to ensure that the data can be accurately placed in the target location.
[0091] Optionally, data format: Depending on the requirements of the DMS system, the user may need to select or specify the data format of the information point table. For example, some DMS systems may require data to be transmitted and stored in a specific format (such as CSV, Excel, JSON, etc.).
[0092] Optionally, authentication information: If the DMS system requires identity authentication or authorization to access, the user also needs to provide relevant authentication information, such as user name, password, access key, etc. This information is used to ensure that the user has the authority to access and modify data in the DMS system.
[0093] Optionally, other configuration parameters: Depending on the specific DMS system and forwarding requirements, users may also need to configure other parameters, such as forwarding frequency, data cleaning rules, error handling strategies, etc. These parameters help ensure the quality, efficiency, and security of forwarded data.
[0094] Optionally, the data management system is a comprehensive management system that integrates data integration and cleaning, data governance, data development, and data application. It should cover data management functional domains such as metadata management, data standard management, data quality management, master data management, and data security management, and provide a one-stop solution for enterprise data management. Its basic function is to extract valuable data from a large amount of data resources according to user requirements. For example, these data can be obtained through retrieval, sorting, merging, conversion, and aggregation.
[0095] Optionally, data integration: The data management system should be able to support bidirectional reading and writing functions between multiple heterogeneous data sources, including common relational databases, non-relational databases, big data databases, text files, message queues, API interfaces, etc. The data integration function should be able to support both batch integration and real-time integration to meet different application scenarios.
[0096] Optionally, data cleaning and processing: The data management system should be able to replace traditional ELT tools and have obvious advantages such as component-based, drag-and-drop, online testing, and process orchestration. Common data cleaning and processing components such as data conversion, string processing, filtering, deduplication, standardization, desensitization, encryption, digital signature, data set association, and data set merging can also support script components for complex data processing scenarios.
[0097] Optionally, data model management: The data management system should have data warehouse planning and design functions, divide the data warehouse into the source layer, governance layer, application layer and sharing layer, and design conceptual models, logical models and physical models at each layer. For the physical model, it should be able to provide audit, synchronization and version management functions to ensure the consistency, integrity and accuracy of the data model during the data warehouse construction process.
[0098] Optionally, metadata management: metadata management is the basis of data management. The data management system should be able to provide adapters for various metadata collection, automatically collect technical metadata, and supplement management attributes and business attributes based on technical metadata, providing a unified caliber for subsequent data resource catalogs, data security management and control, and report development.
[0099] Optionally, master data management: The main goal of master data management is to ensure that master data is consistent, accurate and reliable throughout the organization, and that this data can be shared and integrated between various systems and applications. The data management system should have means such as master data coding rule management, master data maintenance, master data version management, master data integration and sharing, etc.
[0100] Optionally, data quality management: Data quality management should be able to quickly convert data standards into quality rules, monitor the overall data quality in real time according to the data change cycle, identify problematic data, and distribute problematic data according to the data source department and data responsible person. At the same time, it can periodically issue data quality assessment reports, including overall data quality evaluation, problematic data distribution, and problematic data repair status of each department.
[0101] Optionally, data security management: The data management system should combine big data technology and industry characteristics, have the functions of data classification and grading, and intelligent identification of sensitive data, and combine sensitive data management, data desensitization, data encryption and other security control methods to ensure data security and availability.
[0102] Optionally, data management systems have a wide range of applications in various fields, including but not limited to: Enterprise: Help enterprises organize and store data so that they can be easily accessed when needed. Employees can easily find the information they need to complete their work, improve work efficiency and decision-making accuracy. Education: In the field of education, data management systems can be used to manage students' learning data, teachers' teaching data, etc., to provide a basis for education evaluation and teaching reform. Medical: In the medical field, data management systems can be used to manage patients' medical records, medical equipment's operating data, etc., to provide support for medical diagnosis and treatment.
[0103] Alternatively, with the continuous development of technologies such as big data, cloud computing, and artificial intelligence, data management systems are also constantly innovating and upgrading. Future data management systems will be more intelligent, automated, and efficient, and will be able to better meet the needs of enterprises for data management.
[0104] Optionally, the present invention has the following beneficial effects: improving work efficiency and accuracy, and automating design and access.
[0105] Optionally, the present invention realizes the fully automatic design and access of the information point table through a configurable template library, avoiding a lot of tedious work required for manual input and configuration in traditional methods.
[0106] Optionally, automated processes reduce the possibility of human error and improve the accuracy and consistency of information point table design.
[0107] Optionally, one-key forwarding function: The system establishes an association with the distribution automation system (DMS) and supports the one-key forwarding function of point meter information, which simplifies the information transmission process and improves work efficiency.
[0108] Optionally, to enhance flexibility and scalability, a configurable template library: The template library is configurable, which means that it can be flexibly adjusted according to different needs and scenarios and has strong adaptability.
[0109] Optionally, when a new terminal type or information point table format appears, it is only necessary to update the template library without making large-scale modifications to the system itself.
[0110] Optionally, multiple terminal types are supported: the present invention supports multiple types of terminals such as telemetry, telesignaling, and teleregulation, meeting the information point table design requirements of different devices in the distribution automation system.
[0111] Optionally, optimize user experience and operational convenience with a user-friendly interface: The system provides an intuitive and easy-to-use user interface, allowing operators to easily perform operations such as template configuration, point table generation and access.
[0112] Optionally, simplify the operation process: through automated and intelligent design, the complex process of traditional information point table design and access is simplified, and the operation difficulty and threshold are reduced.
[0113] In this embodiment, a corresponding point table template library is established according to different types of distribution automation terminals. When a new information point table needs to be generated, the user only needs to select the corresponding terminal type and template library in the tool and input the basic information such as the description, IP address, link address, etc. of the terminal device. The corresponding information point table will be automatically generated according to the information entered by the user and the selected template library. If the user needs to modify the exported information point table, the generated initial information point table can be modified. The technical problem of low efficiency in generating the information point table is solved, and the technical effect of improving the efficiency of generating the information point table is achieved.
[0114] According to an embodiment of the present invention, there is also provided an automatic information point table generation device. It should be noted that the automatic information point table generation device can be used to execute the automatic information point table generation method in the method embodiment.
[0115] Figure 4 Schematic diagram of a device for generating an automatic information point table according to an embodiment of the present invention. Figure 4 As shown, the automatic information point table generation device 400 may include: an acquisition unit 401, a generation unit 402 and a correction unit 403.
[0116] The acquisition unit 401 is used to acquire the template information of the template library and the basic information of the terminal device, wherein the template information is used to represent the information stored in the template library, the template library is established using the basic information of various terminal devices, and the basic information is used to indicate the location and / or identification of the terminal device in the network.
[0117] The generating unit 402 is used to generate an initial information point table based on the template information and the basic information, wherein the initial information point table is used to record and manage various information points in different systems, and the information points are used to indicate target functions in different systems.
[0118] The correction unit 403 is used to correct the initial information point table according to the correction instruction in response to the state of the correction instruction being a valid state, so as to obtain a target information point table.
[0119] Optionally, the automatic information point table generation device 400 may further include: a first acquisition unit, used to respectively acquire basic information of multiple terminal devices; an integration unit, used to integrate the basic information of multiple terminal devices to obtain an integration result; and an establishment unit, used to establish a template library based on the integration result.
[0120] Optionally, the automatic information point table generating device 400 may further include: a forwarding unit, configured to forward the target information point table to the target system according to the forwarding instruction in response to the state of the forwarding instruction being a valid state.
[0121] Optionally, the forwarding unit may include: an acquisition module, used to acquire forwarding parameters, wherein the forwarding parameters are used to indicate information about the forwarded content and the forwarding object; and a forwarding module, used to forward the target information point table according to the forwarding parameters.
[0122] Optionally, the automatic information point table generating device 400 may further include: a storage unit, configured to store the target information point table in a template library.
[0123] Optionally, the device 400 for generating an automated information point table may further include: a fourth determination module, used to determine the speed curve of the circuit breaker operating device based on the motion curve; a first generation unit, used to generate a corresponding target file according to the initial information point table or the target information point table; and an export unit, used to export the target file.
[0124] In this embodiment, the template information of the template library and the basic information of the terminal device are obtained, wherein the template information is used to represent the information stored in the template library, the template library is established by using the basic information of various terminal devices, and the basic information is used to indicate the location and / or identification of the terminal device in the network; based on the template information and the basic information, an initial information point table is generated, wherein the initial information point table is used to record and manage various information points in different systems, and the information points are used to indicate a specific aspect or function in different systems; in response to the state of the correction instruction being a valid state, the initial information point table is corrected according to the correction instruction to obtain a target information point table. That is to say, the embodiment of the present invention can automatically generate an information point table through the template information of the template library and the basic information of the terminal device, and supports the correction of the generated information point table, thereby reducing the intervention of manual operations, thereby solving the technical problem of low efficiency in generating the information point table, and achieving the technical effect of improving the efficiency of generating the information point table.
[0125] According to an embodiment of the present invention, a computer-readable storage medium is further provided. The storage medium includes a stored program, wherein the program executes the method for generating an automated information point table in the method embodiment.
[0126] According to an embodiment of the present invention, a processor is further provided. The processor is used to run a program, wherein when the program is run, the method for generating an automatic information point table in the method embodiment is executed.
[0127] According to an embodiment of the present invention, a computer program product is also provided. The computer program product includes computer instructions. When the computer instructions are executed by a processor, the method for generating an automatic information point table in the method embodiment is implemented.
[0128] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.
[0129] In the above embodiments of the present invention, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.
[0130] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic. For example, the division of units can be a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.
[0131] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed over multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.
[0132] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.
[0133] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent functional component, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software functional component, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server or network device, etc.) to perform all or part of the steps of the methods of each embodiment of the present invention. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, disk or optical disk, etc., which can store program codes.
[0134] The above are only preferred embodiments of the present invention. It should be pointed out that, for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.
Claims
1. A method for generating an automatic information point table, characterized in that: include: Acquire template information of a template library and basic information of a terminal device, wherein the template information is used to represent information stored in the template library, the template library is established using basic information of a plurality of terminal devices, and the basic information is used to indicate a location and / or identification of the terminal device in a network; Based on the template information and the basic information, an initial information point table is generated, wherein the initial information point table is used to record and manage various information points in different systems, and the information points are used to indicate target functions in the different systems; In response to the state of the correction instruction being a valid state, the initial information point table is corrected according to the correction instruction to obtain a target information point table.
2. The method according to claim 1, characterized in that The method further comprises: Respectively obtain the basic information of the multiple terminal devices; Integrate the basic information of the multiple terminal devices to obtain an integration result; Based on the integration result, the template library is established.
3. The method according to claim 1, characterized in that: The method further comprises: In response to the state of the forwarding instruction being a valid state, the target information point table is forwarded to the target system according to the forwarding instruction.
4. The method according to claim 3, characterized in that In response to the state of the forwarding instruction being a valid state, forwarding the target information point table to the target system according to the forwarding instruction, including: Acquire forwarding parameters, wherein the forwarding parameters are used to indicate information about the forwarded content and the forwarded object; According to the forwarding parameters, the target information point table is forwarded to the target system.
5. The method according to claim 1, characterized in that After obtaining the target information point table, the method further includes: The target information point table is stored in the template library.
6. The method according to any one of claims 1 to 5, characterized in that The method further comprises: Generate a corresponding target file according to the initial information point table or the target information point table; Export the target file.
7. A device for generating an automatic information point table, characterized in that: include: an acquiring unit, configured to acquire template information of a template library and basic information of a terminal device, wherein the template information is used to represent information stored in the template library, the template library is established using basic information of a plurality of terminal devices, and the basic information is used to indicate a location and / or identification of the terminal device in a network; A generating unit, configured to generate an initial information point table based on the template information and the basic information, wherein the initial information point table is used to record and manage various information points in different systems, and the information points are used to indicate target functions in the different systems; The correction unit is used for correcting the initial information point table according to the correction instruction in response to the state of the correction instruction being a valid state, so as to obtain a target information point table.
8. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored program, wherein when the program is executed by a processor, the device where the storage medium is located is controlled to execute the method according to any one of claims 1 to 6.
9. A processor, characterized in that: The processor is used to run a program, wherein the program executes the method according to any one of claims 1 to 6 when running.
10. A computer program product, characterized in that The computer program product comprises computer instructions, which implement the method according to any one of claims 1 to 6 when executed by a processor.
Citation Information
Patent Citations
Distribution network terminal point table automatic generation device and generation method thereof
CN113392145A
Transformer substation monitoring information point table generation method, device and equipment and storage medium
CN114818626A
Method and system for automatically checking monitoring information point table of transformer substation
CN115576928A