CN114125811A - Smart management system for centralized reading SIM card - Google Patents
Smart management system for centralized reading SIM card Download PDFInfo
- Publication number
- CN114125811A CN114125811A CN202111264006.6A CN202111264006A CN114125811A CN 114125811 A CN114125811 A CN 114125811A CN 202111264006 A CN202111264006 A CN 202111264006A CN 114125811 A CN114125811 A CN 114125811A
- Authority
- CN
- China
- Prior art keywords
- sim card
- data
- flow
- management system
- terminal
- 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
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W8/00—Network data management
- H04W8/18—Processing of user or subscriber data, e.g. subscribed services, user preferences or user profiles; Transfer of user or subscriber data
- H04W8/183—Processing at user equipment or user record carrier
-
- 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
Abstract
The invention relates to a centralized reading SIM card beneficial management system, comprising: when the SIM card is inserted into the terminal, the ip address of the terminal is the ip address of the SIM card, and after the terminal is on line, the ip address is automatically updated to the file. By utilizing the principle, the data of the electricity utilization information acquisition system and the data of the communication operator are organically integrated, a data calculation process is compiled, and a lean management applet for centralized reading of the SIM card is developed. The program reads data to an sqlite database by using oledb, screens the data from the database according to logic, presents the data to a chart, and finally exports the data to excel. The method can realize the analysis and utilization of the big data of the centralized reading SIM card, has quick operation, high accuracy, simple and convenient operation, easy introduction, strong universality and easy popularization.
Description
Technical Field
The invention relates to the technical field of power management, in particular to a centralized reading SIM card lean management system.
Background
With the continuous popularization of the application of the electricity information system, the GPRS network using the wireless private network SIM card is used for communication, and the method becomes a basic communication means for the electricity information system to collect data of private and public transformer users. Compared with a wired transmission network, the GPRS has the advantages of wide area coverage, high terminal flexibility, low hardware cost and the like.
In the aspect of daily operation and maintenance of the SIM card, the SIM card without flow and with over flow needs to be cleaned in time. The no-flow and over-flow SIM card deletion work relates to system files and field application conditions, the no-flow SIM card is required to be used without a terminal on a determined field, and the SIM card is sold after the files are cleaned, so that the situation that a secondary issuing time number segment is occupied and cannot be built is avoided; the over-flow SIM card needs to be adjusted according to the information of the terminal where the over-flow SIM card is located and the specific analysis reason. The above work puts forward higher requirements on the accuracy of the SIM card file, and in order to improve the efficiency and the accuracy of the SIM card management work, research and development on the intensive management function of the centralized reading SIM card are urgently needed.
Disclosure of Invention
In order to solve the technical problems in the background art, the invention provides a centralized-reading SIM card lean management system which can realize the analysis and utilization of big data of the centralized-reading SIM card, has the advantages of quick operation, high accuracy, simple and convenient operation, easy introduction, strong universality and easy popularization.
The technical scheme adopted by the invention for solving the technical problems is as follows:
collect and copy smart management system of SIM card, include:
when the SIM card is inserted into the terminal, the ip address of the terminal is the ip address of the SIM card, and after the terminal is on line, the ip address is automatically updated to the file. By utilizing the principle, the data of the electricity utilization information acquisition system and the data of the communication operator are organically integrated, a data calculation process is compiled, and a lean management applet for centralized reading of the SIM card is developed.
The program reads data to an sqlite database by using oledb, screens the data from the database according to logic, presents the data to a chart, and finally exports the data to excel.
The cleaning of the no-flow SIM card comprises the following steps: and importing a data table required for cleaning the non-flow SIM card, clicking calculation, and automatically analyzing the terminal use condition and the system filing condition of the non-flow SIM card by a program, classifying the non-flow SIM card, and giving a cleaning prompt according to the classification.
The operation of the SIM card file reforming comprises the following steps: relevant data required by the SIM card file rectification is imported, clicking calculation is carried out, and the program can screen out wrong file details required to be rectified and matched to obtain corresponding correct file information. And the subsequent correction and modification is convenient.
The analysis of the super-flow SIM card comprises the following steps: and (4) importing the super-flow SIM card details, clicking to calculate, and automatically judging the distribution area, the equipment manufacturer and the flow condition of the SIM card by a program, wherein the program is used for guiding the field processing, the charge adjustment and the like of the super-flow SIM card.
The analysis result of the SIM card system file rectification can be exported to an excel table, so that the subsequent verification processing is facilitated.
The analysis result of the non-flow SIM card cleaning can be exported to an excel table, so that the subsequent verification processing is facilitated.
The invention has the beneficial effects that:
(1) and (4) analyzing and utilizing the big data of the centralized reading SIM card. According to daily operation management requirements and working difficulties of the SIM card, electricity utilization information acquisition system data and communication operator data are integrated in a targeted manner, a strict and efficient SIM card cleaning and defect eliminating mechanism is realized by means of a small program, and the SIM card data management quality is effectively improved.
(2) The SIM card management applet is initiated. The applet is compiled according to the internal logic of the SIM card management work, and covers SIM card management core functions of no-flow SIM card cleaning, over-flow SIM card analysis, SIM card system file operation rectification and the like. The user can obtain the analysis of research and judgment by importing the original data extracted from the electric power and the operator, and the analysis is directly applied to the subsequent work.
(3) The operation is fast and the accuracy is high. In a near-Yili area, the number of SIM cards in transportation is about 43w, the file data volume is large, if a traditional Excel table is used for function operation, the card pause is easy to occur, a worker needs to repeatedly perform screening calculation on the data for multiple times, the process is complicated, the error is easy to occur, and the time consumption is long. The small program embeds complex calculation formulas and judgment rules, and has high accuracy and high speed.
(4) Simple operation and easy operation. The user only needs to import the related data according to the format, and does not need to spend a great deal of energy on learning data analysis and calculation processing.
(5) The universality is strong, and the popularization is easy. The small program function can meet the requirements of the cleaning work of the SIM cards of all levels of units. The mobile and the communication centralized reading SIM cards are both suitable for the program.
Drawings
The invention is further illustrated with reference to the following figures and examples.
FIG. 1 is a diagram of a SIM card information handling interface;
FIG. 2 is a logic diagram of the operation of a no-flow SIM card clean-up;
FIG. 3 is a diagram of a no-flow SIM card file rectification interface;
fig. 4 is a diagram of an over-flow SIM card analysis interface.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings.
When the SIM card is inserted into the terminal, the ip address of the terminal is the ip address of the SIM card, and after the terminal is on line, the ip address is automatically updated to the file. By utilizing the principle, the data of the electricity utilization information acquisition system and the data of the communication operator are organically integrated, a data calculation process is compiled, and a lean management applet for centralized reading of the SIM card is developed.
The program reads data to an sqlite database by using oledb, screens the data from the database according to logic, presents the data to a chart, and finally exports the data to excel.
1. And cleaning the non-flow SIM card. And importing a data table required for cleaning the non-flow SIM card, clicking calculation, and automatically analyzing the terminal use condition and the system filing condition of the non-flow SIM card by a program, classifying the non-flow SIM card, and giving a cleaning prompt according to the classification. The analysis result can be exported to an excel table, so that the subsequent verification processing is facilitated.
2. And operating the SIM card file rectification. Relevant data required by the SIM card file rectification is imported, clicking calculation is carried out, and the program can screen out wrong file details required to be rectified and matched to obtain corresponding correct file information. And the subsequent correction and modification is convenient.
3. And analyzing the super-flow SIM card. And (4) importing the super-flow SIM card details, clicking to calculate, automatically judging the distribution area, equipment manufacturer and flow condition of the SIM card by a program, and generating a pie chart of an analysis result for guiding the field processing, charge adjustment and the like of the super-flow SIM card.
The invention has the technical effects that:
1. the abnormal SIM card defect eliminating work efficiency and accuracy are improved. Because the small program is convenient to operate, the difficulty of abnormal SIM card analysis work is greatly reduced, and the working personnel can directly apply the program to export data, so that the working efficiency is effectively improved. The calculation formula and the judgment rule are built in, errors in the calculation process are avoided, the accuracy of subsequent defect elimination is ensured, and the influence on the actual operation of the terminal is reduced. At present, the direct supply area finishes the work of mobile and communication SIM card file rectification, adjusts more than 400 super-flow rates and 5000 card sales in total, and has no terminal off-line in the process.
2. The total charge of the centralized reading SIM card is reduced. The method comprises the steps of regularly extracting data of electric power and communication operators, rapidly studying and judging by utilizing a small program, timely canceling a non-operating non-flow SIM card, adjusting package cost of the super-flow SIM card, detecting and processing a data transmission function of a manufacturer in which the super-flow terminal is centralized and the like according to an analysis result, and averagely reducing the communication cost by about 3W yuan per month.
The use condition is as follows: the small program with the smart management function of the SIM card is popularized and used in the collection specialties of the whole city, and each unit is responsible for the feedback operation of people, so that the popularization and application conditions are good.
The popularization prospect is as follows: according to the operation analysis report of the unified management work of the communication services of the public network of the provincial company, 575483 total SIM cards with zero flow account for 13.37 percent of the communication cards in the activation period by 2 months of the whole province in 19 years. The total number of 30684 SIM cards of the super flow of the 2 month province accounts for 0.71 percent of the proportion of the communication card in the activation period. The monthly fee for collecting and copying SIM cards is 2.9 yuan, and if the SIM cards are not consumed in time, millions of yuan of communication funds can be saved in each month. The small program has universality in internal computing logic, can be popularized and used in the provincial acquisition specialty, and has higher popularization value.
In light of the foregoing description of the preferred embodiment of the present invention, many modifications and variations will be apparent to those skilled in the art without departing from the spirit and scope of the invention. The technical scope of the present invention is not limited to the content of the specification, and must be determined according to the scope of the claims.
Claims (6)
1. Collect and copy smart management system of SIM card, its characterized in that includes:
when the SIM card is inserted into the terminal, the ip address of the terminal is the ip address of the SIM card, and after the terminal is on line, the ip address is automatically updated to the file. By utilizing the principle, the data of the electricity utilization information acquisition system and the data of the communication operator are organically integrated, a data calculation process is compiled, and a lean management applet for centralized reading of the SIM card is developed.
The program reads data to an sqlite database by using oledb, screens the data from the database according to logic, presents the data to a chart, and finally exports the data to excel.
2. The smart management system for a collective SIM card according to claim 1,
the no-flow SIM card cleaning comprises the following steps: and importing a data table required for cleaning the non-flow SIM card, clicking calculation, and automatically analyzing the terminal use condition and the system filing condition of the non-flow SIM card by a program, classifying the non-flow SIM card, and giving a cleaning prompt according to the classification.
3. The smart management system for a collective SIM card according to claim 1,
the operating SIM card file reforming comprises the following steps: relevant data required by the SIM card file rectification is imported, clicking calculation is carried out, and the program can screen out wrong file details required to be rectified and matched to obtain corresponding correct file information. And the subsequent correction and modification is convenient.
4. The smart management system for a collective SIM card according to claim 1,
the over-traffic SIM card analysis comprises: and (4) importing the super-flow SIM card details, clicking to calculate, and automatically judging the distribution area, the equipment manufacturer and the flow condition of the SIM card by a program, wherein the program is used for guiding the field processing, the charge adjustment and the like of the super-flow SIM card.
5. The smart management system for a collective SIM card according to claim 2,
the analysis result can be exported to an excel table, so that the subsequent verification processing is facilitated.
6. The smart management system for a collective SIM card according to claim 3,
the analysis result can be exported to an excel table, so that the subsequent verification processing is facilitated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111264006.6A CN114125811A (en) | 2021-10-27 | 2021-10-27 | Smart management system for centralized reading SIM card |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111264006.6A CN114125811A (en) | 2021-10-27 | 2021-10-27 | Smart management system for centralized reading SIM card |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114125811A true CN114125811A (en) | 2022-03-01 |
Family
ID=80377546
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111264006.6A Pending CN114125811A (en) | 2021-10-27 | 2021-10-27 | Smart management system for centralized reading SIM card |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114125811A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130015809A1 (en) * | 2010-03-29 | 2013-01-17 | Ifs Informationstechnik Gmbh | Device and method for controlled exchange of energy between an electrical power network and a load |
| CN105207807A (en) * | 2015-08-21 | 2015-12-30 | 积成电子股份有限公司 | SIM card flow analysis method applied to power consumption information acquisition system |
| CN205177145U (en) * | 2015-12-10 | 2016-04-20 | 国网四川省电力公司电力科学研究院 | Power consumption information acquisition test terminal |
| US20160165451A1 (en) * | 2014-12-05 | 2016-06-09 | Honeywell International Inc. | System and Method Of Preventing Unauthorized SIM Card Usage |
| CN107655515A (en) * | 2017-08-04 | 2018-02-02 | 国网浙江省电力公司 | A kind of acquisition terminal and live defect elimination method of the main website without communication failure |
| CN214256350U (en) * | 2020-10-31 | 2021-09-21 | 联通系统集成有限公司贵州省分公司 | Power grid and third-party Internet of things capability docking system |
-
2021
- 2021-10-27 CN CN202111264006.6A patent/CN114125811A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130015809A1 (en) * | 2010-03-29 | 2013-01-17 | Ifs Informationstechnik Gmbh | Device and method for controlled exchange of energy between an electrical power network and a load |
| US20160165451A1 (en) * | 2014-12-05 | 2016-06-09 | Honeywell International Inc. | System and Method Of Preventing Unauthorized SIM Card Usage |
| CN105207807A (en) * | 2015-08-21 | 2015-12-30 | 积成电子股份有限公司 | SIM card flow analysis method applied to power consumption information acquisition system |
| CN205177145U (en) * | 2015-12-10 | 2016-04-20 | 国网四川省电力公司电力科学研究院 | Power consumption information acquisition test terminal |
| CN107655515A (en) * | 2017-08-04 | 2018-02-02 | 国网浙江省电力公司 | A kind of acquisition terminal and live defect elimination method of the main website without communication failure |
| CN214256350U (en) * | 2020-10-31 | 2021-09-21 | 联通系统集成有限公司贵州省分公司 | Power grid and third-party Internet of things capability docking system |
Non-Patent Citations (4)
| Title |
|---|
| 张杨，等: "基于无监督学习方法的SIM卡流量优化与分析", 《企业管理》, no. 2, pages 294 - 295 * |
| 杨帆帆;: "电力行业SIM卡管理的探索与实践", 贵州电力技术, no. 03, pages 66 - 68 * |
| 柯敏玲: "供电企业移动SIM行业卡管理的探索与实践", 《技术与市场》, vol. 21, no. 11, pages 174 - 175 * |
| 黄慧军，等: "构建电力SIM卡状态管控创新机制", 《农电管理》, no. 3, pages 33 - 34 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107666148B (en) | Line fault studying and judging method based on distribution transformer power failure signal | |
| CN202600765U (en) | Data comprehensive management system for intelligent power supply system | |
| CN104580390A (en) | Electric power information scheduling engine in self-service mobile phone electricity-bill-paying terminal and using method of electric power information scheduling engine | |
| CN113935818A (en) | Order settlement method, system and electronic equipment | |
| CN102075896B (en) | Price previewing method and system | |
| CN114004588A (en) | Distributed photovoltaic user integrated settlement platform | |
| CN114125811A (en) | Smart management system for centralized reading SIM card | |
| CN114255073A (en) | Marketing census method based on data center station | |
| CN109035065A (en) | Water power exception usage behavior analysis method based on multiple-in-one | |
| CN110705916B (en) | Method and system for judging small and micro load electric quantity of transformer | |
| CN102486882A (en) | Electric power self-help payment terminal system | |
| CN107316202A (en) | A kind of rate of load condensate electricity price measuring method based on number of users spatial distribution characteristic | |
| CN101692298A (en) | Electric power movable charging system | |
| CN102236840A (en) | Automatic computer management system and method for school fee | |
| CN108682136A (en) | Remote meter reading unified platform | |
| CN202711453U (en) | Remote meter reading system based on WCDMA (Wideband Code Division Multiple Access) network | |
| CN112016631A (en) | Improvement scheme related to low-voltage treatment | |
| CN110827013A (en) | Method and system for settling small micro-load electric quantity in suspension and volume reduction transformer | |
| CN205692279U (en) | A kind of property electricity charge electronics account checking apparatus | |
| Zhang et al. | Policy Analysis and Recommendation for Self-Supply Power Stations | |
| CN110598901B (en) | Electric energy meter correction management system | |
| WO2024007094A1 (en) | User utility bill payment analysis method based on clustering algorithm and tsvm model | |
| CN113329074A (en) | Comprehensive energy efficiency bill pushing and reading system based on AI robot | |
| Xu et al. | Research and Application of Digital Billing for Coal-to-Electricity Users Based on Label Portrait Technology | |
| CN114417804A (en) | System and method for generating certificate based on intelligent accounting platform and page modeling |
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 |