CN111913961A - Transformer coil compression ratio cloud platform analysis system - Google Patents
Transformer coil compression ratio cloud platform analysis system Download PDFInfo
- Publication number
- CN111913961A CN111913961A CN202010750946.5A CN202010750946A CN111913961A CN 111913961 A CN111913961 A CN 111913961A CN 202010750946 A CN202010750946 A CN 202010750946A CN 111913961 A CN111913961 A CN 111913961A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- information
- transformer coil
- compression ratio
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a cloud platform analysis system for transformer coil compression ratios, which relates to the technical field of transformers and comprises a web front-end module, a rear-end interface module, a cloud server and a database, and solves the technical problem of rapidly counting compression ratio coefficients and target value data.
Description
Technical Field
The invention relates to the technical field of transformers, in particular to a cloud platform analysis system for a transformer coil compression ratio.
Background
The compression of the transformer coil involves many condition parameters, such as: reticulation, cushion, wire, pressure value, ambient temperature and humidity etc.. Many data are required to be recorded and stored, and the data volume is getting larger and larger with the increase of projects. The storage of data becomes a problem, the recording of paper forms is troublesome and difficult to store, and the query is inconvenient, and meanwhile, the analysis of the compression ratio coefficient and the target value data becomes an event which is difficult to realize by referring to numerous data.
Disclosure of Invention
The invention aims to provide a transformer coil compression ratio cloud platform analysis system, which solves the technical problem of rapidly counting compression ratio coefficients and target value data.
In order to achieve the purpose, the invention adopts the following technical scheme:
a transformer coil compression ratio cloud platform analysis system comprises a web front-end module, a rear-end interface module, a cloud server and a database;
the cloud server is used for calculating the transformer coil compression ratio according to the transformer coil data in the database and storing the transformer coil compression ratio into the database;
the rear-end interface module, the cloud server and the database are communicated with each other through the internet;
the web front-end module comprises a project management unit, a data management unit and a statistic management unit;
the project management unit comprises a project information newly-added module, a project information query module and a project information editing module;
the project information adding module is used for adding new project information and sending the project information to the database for registration and storage;
the project information query module is used for establishing indexes for all project information;
the project information editing module is used for deleting or modifying project information in the database;
the data management unit comprises a data information adding module, a data information table importing module, a data information inquiring module and a data information editing module;
the data information adding module is used for establishing a data storage area for transformer coil data input by a user;
the data information table importing module is used for establishing a data table for the transformer coil data in the data storage area;
the data information query module is used for establishing indexes for all data in the data storage area;
the data information editing module is used for modifying or deleting the data in the data storage area;
the data management unit sends all data in the data storage area to the database for storage;
the statistical analysis unit comprises a compression ratio coefficient statistical graph module and a target value statistical graph module;
the compression ratio coefficient statistical graph module is used for converting the compression ratio of the transformer coil in the database into a table form;
the target value statistical graph module is used for converting the target values in the database into a graph form;
the back-end interface module is used for connecting the web front-end module and the cloud server to enable the web front-end module and the cloud server to perform data interaction.
Preferably, the data processed by the data management unit and the data processed by the statistics management unit both include field information of a construction order number and a project name, and the field information of the construction order number and the project name is consistent with the field information of the construction order number and the project name in the project information and is updated synchronously.
Preferably, the transformer coil data comprises a pressure value dk, a set pressure value dx and a compression ratio coefficient, and the insertion and modification of the three fields relating to the pressure value dk, the set pressure value dx and the compression ratio coefficient do not provide an input box, but calculate the pressure value dk, the set pressure value dx and the compression ratio coefficient in the back-end interface module.
Preferably, the compression ratio coefficient statistical graph module is used for calling the compression ratio of the transformer coil from a database according to the index information and marking the average value of the compression ratio of the transformer coil; the target value statistical graph model calls a target value from a database according to the index information and marks the average value of the target value; the index information is provided by the item information query module or the data information query module.
The cloud platform analysis system for the transformer coil compression ratio solves the technical problem of rapidly counting the compression ratio coefficient and the target value data, realizes storage, query, modification and mapping analysis of the transformer coil related coefficient data, enables the transformer coil data to be stored in a cloud server, realizes query, modification and analysis of the data, and enables management of the data to be more convenient.
Drawings
FIG. 1 is a system architecture diagram of the present invention;
FIG. 2 is a flow chart of the present invention;
fig. 3 is a schematic diagram of a data interface connected with the internet of things according to the present invention.
Detailed Description
1-3, the cloud platform analysis system for transformer coil compression ratios comprises a web front-end module, a back-end interface module, a cloud server and a database;
the cloud server is used for calculating the transformer coil compression ratio according to the transformer coil data in the database and storing the transformer coil compression ratio into the database;
the rear-end interface module, the cloud server and the database are communicated with each other through the internet;
the web front-end module comprises a project management unit, a data management unit and a statistic management unit;
the project management unit comprises a project information newly-added module, a project information query module and a project information editing module;
the project information adding module is used for adding new project information and sending the project information to the database for registration and storage;
the project information query module is used for establishing indexes for all project information;
the project information editing module is used for deleting or modifying project information in the database;
the data management unit comprises a data information adding module, a data information table importing module, a data information inquiring module and a data information editing module;
the data information adding module is used for establishing a data storage area for transformer coil data input by a user;
the data information table importing module is used for establishing a data table for the transformer coil data in the data storage area;
the data information query module is used for establishing indexes for all data in the data storage area;
the data information editing module is used for modifying or deleting the data in the data storage area;
the data management unit sends all data in the data storage area to the database for storage;
the statistical analysis unit comprises a compression ratio coefficient statistical graph module and a target value statistical graph module;
the compression ratio coefficient statistical graph module is used for converting the compression ratio of the transformer coil in the database into a table form;
the target value statistical graph module is used for converting the target values in the database into a graph form;
the transformer adopts the cushion as main insulation, acquires the required coil height through increasing the thickness of cushion. Different manufacturers, different batches and different materials have different cushion block thicknesses, and the manufacturing requirements of the transformer coil are to obtain the thickness and the compression ratio of the cushion block under the characteristic temperature, humidity and pressure. According to the performance requirement of the transformer, the specified cushion block height and compression ratio are calculated, and in the embodiment, the target value refers to the cushion block height.
The back-end interface module is used for connecting the web front-end module and the cloud server to enable the web front-end module and the cloud server to perform data interaction.
Preferably, the data processed by the data management unit and the data processed by the statistics management unit both include field information of a construction order number and a project name, and the field information of the construction order number and the project name is consistent with the field information of the construction order number and the project name in the project information and is updated synchronously.
In the embodiment, the selection of the drop-down boxes of the construction order number and the project name is realized by selecting one field and then automatically matching the other field; the data information query module can perform full-field fuzzy query.
In this embodiment, the item information adding module is used for adding new item information and data information adding module, and is used for respectively including a construction order number field and a project name field for transformer coil data related to a project, and the transformer coil data and the project information are matched with each other through the construction order number field and the project name field.
Preferably, the transformer coil data comprises a pressure value dk, a set pressure value dx and a compression ratio coefficient, and the insertion and modification of the three fields relating to the pressure value dk, the set pressure value dx and the compression ratio coefficient do not provide an input box, but calculate the pressure value dk, the set pressure value dx and the compression ratio coefficient in the back-end interface module.
In this embodiment, the pressure value dk, the set pressure value dx and the compression ratio coefficient are calculated by the following formulas:
setting a pressure value dk as a cushion block length multiplied by a cushion block width multiplied by a design pressure value dk;
setting a pressure value dx which is the length of the lead, the width of the lead and the design pressure value dx;
the compression ratio coefficient is the height before compression/height after compression;
preferably, the compression ratio coefficient statistical graph module is used for calling the compression ratio of the transformer coil from a database according to the index information and marking the average value of the compression ratio of the transformer coil; the target value statistical graph model calls a target value from a database according to the index information and marks the average value of the target value; the index information is provided by the item information query module or the data information query module.
In this embodiment, a user realizes rapid analysis and query of the transformer coil compression ratio in the transformer coil compression ratio analysis system by the following steps:
step S1: a user accesses the web front-end module through the terminal equipment, and the web front-end module is used for providing a web page;
step S2: the project management unit provides project information newly-added options, project information query options and project information editing options in the web page;
the data management unit provides a data information newly-added option, a data information table importing option, a data information inquiry option and a data information editing option in the web page;
the statistical analysis unit provides compression ratio coefficient statistical graph options and target value statistical graph options in the web page;
step S3: a user selects a project information adding option in a web page and inputs data information related to the project, and a project information adding module adds new project information according to the input data information related to the project and registers the new project in a database;
step S4: a user selects a data information newly added option in a web page and inputs transformer coil data, a data information newly added module establishes a data storage area for the transformer coil data, and the transformer coil data is sent to a cloud server through a rear-end interface module;
step S5: the cloud server analyzes the transformer coil data, acquires a construction order number field and an item name field, and searches an item information table of the database by using the construction order number field and the item name field, wherein the item information table is searched by matching the construction order number field and the item information field with a provided field value, and the two fields are required to be matched at the same time, for example: if the matched construction order number has data to return, but the item name field values of the returned data are not matched with the acquired item name values, the result is still unmatched, no data is returned, and step S8 is executed; if the matching result returns, step S6 is executed;
as shown in table 1, it is an item information table of this embodiment:
| serial number | Type (B) | Query conditions | Field(s) | Remarks for note |
| 1 | Text | Precision of | sbbh | Device numbering |
| 2 | Text | Screening | sjzt | Data state |
| 3 | Text | Blurring | sgdh | Construction sheet number |
| 4 | Text | Blurring | xmmc | Name of item |
| 5 | Text | Screening | clzt | Measuring state |
| 6 | Floating point type | Range of | hjwd | Ambient temperature deg.C |
| 7 | Floating point type | Range of | xdsd | Relative humidity% |
| 8 | Shaping machine | Range of | pcxh | Batch number |
| 9 | Text | Blurring | bzbh | Standard cushion block numbering |
| 10 | Text | Blurring | dkcj | Cushion block manufacturer |
| 11 | Text | Screening | wwqk | Moire pattern condition |
| 12 | Floating point type | Range of | bzzl | Standard cushion weight (g) |
| 13 | Floating point type | Range of | bzgzzl | Standard cushion Dry weight (g) |
| 14 | Text | Screening | xqmc | Coil name |
| 15 | Text | Blurring | xqbz | Coil remark |
| 16 | Text | Blurring | xqxs | Coil form |
| 17 | Text | Blurring | fqmc | Partition name |
| 18 | Floating point type | Range of | dkc | Pad length (mm) |
| 19 | Floating point type | Range of | dkk | Cushion block width (mm) |
| 20 | Floating point type | Range of | sjyqdk | Design pressure valuedk(N/mm2) |
| 21 | Floating point type | Range of | sdyldk | Set pressure valuedk(kN) |
| 22 | Floating point type | Range of | sbyldk | Pressure value of the devicedk(kN) |
| 23 | Floating point type | Range of | dxc | Conducting wire length (mm) |
| 24 | Floating point type | Range of | dxk | Width of wire (mm) |
| 25 | Floating point type | Range of | sjyqdx | Design pressure valuedx(N/mm2) |
| 26 | Floating point type | Range of | sdyldx | Set pressure valuedx(kN) |
| 27 | Floating point type | Range of | sbyldx | Pressure value of the devicedx(kN) |
| 28 | Floating point type | Range of | sjgd | Design theoretical height mm |
| 29 | Floating point type | Range of | sjxs | Design of compression ratio coefficient |
| 30 | Floating point type | Range of | ysqgd | Height before compression (mm) |
| 31 | Floating point type | Range of | yshgd | Compressed height (mm) |
| 32 | Floating point type | Range of | ysbxs | Coefficient of compression ratio |
| 33 | Floating point type | Range of | mbz | Target value (mm) |
| 34 | Text | Blurring | tzqk | Description of the adjustment |
| 35 | Floating point type | Range of | xqysh | Coil compressed value (mm) |
TABLE 1
Step S6: establishing a transformer coil data information table, establishing a mapping table of the transformer coil data information table and item information, and inserting transformer coil data into the transformer coil data information table;
step S7: the cloud server returns the transformer coil data information table to the web page and displays that the data are inserted successfully;
step S8: the cloud server returns error information to the web page to prompt that the insertion fails.
As shown in fig. 3, which is a schematic diagram of a data interface in the embodiment of docking with the internet of things, the data interface in the embodiment of docking with the internet of things can be provided by the cloud server, so as to realize communication with the terminal of the internet of things, and the data interface is fed back to the Web terminal in a Web page manner.
The cloud platform analysis system for the transformer coil compression ratio solves the technical problem of rapidly counting the compression ratio coefficient and the target value data, realizes storage, query, modification and mapping analysis of the transformer coil related coefficient data, enables the transformer coil data to be stored in a cloud server, realizes query, modification and analysis of the data, and enables management of the data to be more convenient.
Claims (4)
1. The utility model provides a transformer coil compression ratio cloud platform analytic system which characterized in that: the system comprises a web front-end module, a back-end interface module, a cloud server and a database;
the cloud server is used for calculating the transformer coil compression ratio according to the transformer coil data in the database and storing the transformer coil compression ratio into the database;
the rear-end interface module, the cloud server and the database are communicated with each other through the internet;
the web front-end module comprises a project management unit, a data management unit and a statistic management unit;
the project management unit comprises a project information newly-added module, a project information query module and a project information editing module;
the project information adding module is used for adding new project information and sending the project information to the database for registration and storage;
the project information query module is used for establishing indexes for all project information;
the project information editing module is used for deleting or modifying project information in the database;
the data management unit comprises a data information adding module, a data information table importing module, a data information inquiring module and a data information editing module;
the data information adding module is used for establishing a data storage area for transformer coil data input by a user;
the data information table importing module is used for establishing a data table for the transformer coil data in the data storage area;
the data information query module is used for establishing indexes for all data in the data storage area;
the data information editing module is used for modifying or deleting the data in the data storage area;
the data management unit sends all data in the data storage area to the database for storage;
the statistical analysis unit comprises a compression ratio coefficient statistical graph module and a target value statistical graph module;
the compression ratio coefficient statistical graph module is used for converting the compression ratio of the transformer coil in the database into a table form;
the target value statistical graph module is used for converting the target values in the database into a graph form;
the back-end interface module is used for connecting the web front-end module and the cloud server to enable the web front-end module and the cloud server to perform data interaction.
2. The cloud platform analysis system for transformer coil compression ratios as claimed in claim 1, wherein: the data processed by the data management unit and the data processed by the statistics management unit both comprise field information of a construction order number and a project name, and the field information of the construction order number and the project name is consistent with the field information of the construction order number and the project name in the project information and is updated synchronously.
3. The cloud platform analysis system for transformer coil compression ratios as claimed in claim 1, wherein: the transformer coil data comprises a pressure value dk, a set pressure value dx and a compression ratio coefficient, and the insertion and modification of three fields of the pressure value dk, the set pressure value dx and the compression ratio coefficient do not provide an input frame, but calculate the pressure value dk, the set pressure value dx and the compression ratio coefficient in a back-end interface module.
4. The cloud platform analysis system for transformer coil compression ratios as claimed in claim 1, wherein: the compression ratio coefficient statistical graph module is used for calling the compression ratio of the transformer coil from a database according to the index information and marking the average value of the compression ratio of the transformer coil; the target value statistical graph model calls a target value from a database according to the index information and marks the average value of the target value; the index information is provided by the item information query module or the data information query module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010750946.5A CN111913961A (en) | 2020-07-30 | 2020-07-30 | Transformer coil compression ratio cloud platform analysis system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010750946.5A CN111913961A (en) | 2020-07-30 | 2020-07-30 | Transformer coil compression ratio cloud platform analysis system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111913961A true CN111913961A (en) | 2020-11-10 |
Family
ID=73286749
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010750946.5A Pending CN111913961A (en) | 2020-07-30 | 2020-07-30 | Transformer coil compression ratio cloud platform analysis system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111913961A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101641698A (en) * | 2006-12-08 | 2010-02-03 | Abb研究有限公司 | Be used to describe and manage the method and apparatus of transformer coil character |
| CN110781725A (en) * | 2019-09-11 | 2020-02-11 | 北京戴纳实验科技有限公司 | Laboratory data acquisition and management system |
| CN110909098A (en) * | 2019-11-14 | 2020-03-24 | 武汉一格空间科技有限公司 | Cloud geographic information data analysis method and system |
| CN111083662A (en) * | 2019-12-18 | 2020-04-28 | 深圳市快鱼环保技术有限公司 | Water quality monitoring Internet of things system based on cloud computing |
-
2020
- 2020-07-30 CN CN202010750946.5A patent/CN111913961A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101641698A (en) * | 2006-12-08 | 2010-02-03 | Abb研究有限公司 | Be used to describe and manage the method and apparatus of transformer coil character |
| CN110781725A (en) * | 2019-09-11 | 2020-02-11 | 北京戴纳实验科技有限公司 | Laboratory data acquisition and management system |
| CN110909098A (en) * | 2019-11-14 | 2020-03-24 | 武汉一格空间科技有限公司 | Cloud geographic information data analysis method and system |
| CN111083662A (en) * | 2019-12-18 | 2020-04-28 | 深圳市快鱼环保技术有限公司 | Water quality monitoring Internet of things system based on cloud computing |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104462430B (en) | The data processing method and device of relevant database | |
| CN100432921C (en) | Method and system for blending search engine results from disparate sources into one search result | |
| Lipkovich et al. | Biplot and singular value decomposition macros for Excel© | |
| CN1240012C (en) | Adaptive catalog page display | |
| CN111506559B (en) | Data storage method, device, electronic equipment and storage medium | |
| CN111563109B (en) | Radix statistics method, apparatus, system, device, and computer-readable storage medium | |
| CN110659282A (en) | Data route construction method and device, computer equipment and storage medium | |
| CN106997390A (en) | A kind of equipment part or parts commodity transaction information search method | |
| CN110442653B (en) | Method, device, server and storage medium for incrementally constructing CUBE model | |
| CN111913961A (en) | Transformer coil compression ratio cloud platform analysis system | |
| US20090119250A1 (en) | Method and system for searching and ranking entries stored in a directory | |
| CN108009195B (en) | Dimension reduction conversion method based on big data, electronic equipment and storage medium | |
| CN109558462A (en) | Data statistical approach and device | |
| CN103166927B (en) | A kind of XML communication protocol dynamic management approach | |
| CN106874498B (en) | Financial data access method and access device | |
| CN116089401A (en) | User data management method and system | |
| CN109151808A (en) | A kind of data analysing method and system | |
| CN115391659A (en) | News recommendation method and device, electronic equipment and computer readable storage medium | |
| CN108664573A (en) | A kind of quick processing system of big data and method with double-channel data library | |
| CN110968679A (en) | Data query method and device | |
| CN111125159A (en) | Data statistics method and device | |
| CN113239677A (en) | Data processing method and device, electronic equipment and storage medium | |
| KR20100110211A (en) | System and method for recommending contents layout | |
| CN111159499B (en) | Electric power system model searching and sorting method based on similarity between character strings | |
| CN117539869B (en) | Data processing system for acquiring data table |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20201110 |