KR-20260063756-A - AMI DATA STORAGE SYSTEM AND METHOD USING REDIS DB

Abstract

The storage system for AMI data utilizing a Redis DB according to the present invention comprises: a modem that receives and transmits metering data composed of a Key value, a Value value, and a Metering Value of an Advanced Metering Infrastructure (AMI); a Redis DB in which only Key-Value values among the metering data are accumulated and stored; a server that receives metering data from the modem, extracts Key-Value values, and queries the Redis DB with the extracted Key-Value values to determine whether the metering data is stored; and an Oracle DB in which the metering data is stored. Since DB transactions are minimized, the occurrence of DB Locks can be reduced, thereby providing the effect of improving data storage speed.

Inventors

• 권혁록
• 정종열
• 최 선

Assignees

• 한전케이디엔주식회사

Dates

Publication Date

20260507

Application Date

20241031

Claims (5)

1. A modem that receives and transmits metering data composed of a Key value, a Value value, and a metering value of an Advanced Metering Infrastructure (AMI); Lady DB in which only Key-Value values among the above meter reading data are accumulated and stored; A server that receives meter reading data from the above modem, extracts Key-Value values, and queries the above Lady DB with the extracted Key-Value values to determine whether to store the meter reading data; and A storage system for AMI data utilizing Redis DB, characterized by including an Oracle DB in which the above meter reading data is stored.
2. In Article 1, The above server is A data receiving unit that receives meter reading data read by the intelligent remote meter reading device from a plurality of the above modems; A pre-stored determination unit that extracts a Key-Value from the meter reading data, queries the extracted Key-Value from the Lady DB, and if the Key-Value is not found in the Lady DB, determines the meter reading data received by the data receiving unit as new data and stores the extracted Key-Value in the Lady DB; and A method for storing AMI data using Redis DB, characterized by including a data storage unit that stores the meter reading data in an Oracle DB when the above meter reading data is determined to be new data.
3. (a) A step in which a data receiving unit of the above server receives meter reading data read by the intelligent remote meter reading device through a modem; (b) A step in which a determination unit of whether the server has been stored extracts the Key-Value from the meter reading data; (c) A step of querying the Key-Value values extracted by the above-mentioned storage determination unit from a Redis DB where only Key-Value values are stored; (d) A step in which the above-mentioned storage determination unit determines whether a Key-Value value retrieved from the Redis DB exists after step (c); (e) a step in which the above-mentioned storage determination unit stores the Key value or Value value in the above-mentioned Redis DB if the above-mentioned Key value or Value value does not exist in the above-mentioned Redis DB in step (d); characterized by including a method for storing AMI data using Redis DB.
4. In Paragraph 3, The above-mentioned storage determination unit A method for storing AMI data using Redis DB, characterized by repeating the process after step (b) for newly received meter reading data when a Key value or Value exists in the Redis DB in step (d) above.
5. In Paragraph 3, (e) After step (f) a step in which, if the extracted Key-Value does not exist, the data storage unit determines that the meter reading data is new data and the data storage unit stores the meter reading data in an Oracle DB; further comprising a method for storing AMI data using Redis DB.

Description

AMI Data Storage System and Method Using Redis DB The present invention relates to a storage system and method for AMI data utilizing a Redis DB, and more specifically, to a storage system and method for AMI data utilizing a Redis DB that can effectively store data in a DB without receiving excessively duplicated data and querying the DB, that is, while minimizing the DB load. To prevent data loss, the high-voltage meter reading system uses LTE modems at the site to duplicately transmit not only the data for the current time but also the entire (96) data for the past day. To store this data, the server checks the database for each data item to determine whether to store it and only stores the new data. At this time, in order to determine whether data has been stored, each session processing data accesses the DB to determine whether the data has been stored. Since a maximum of 96 pieces of data are transmitted at once per day, there is a problem in that a lot of resources (DB resources) must be used to determine whether there is duplicate data. In addition, there is a problem in that excessive access to the database to determine data duplication leads to lock contention, which can cause slowdowns in data processing speed and increase database load. Figure 1 is a configuration diagram of a storage system for AMI data using Redis DB according to the present invention. Figure 2 is a block diagram of a storage system server for AMI data utilizing Redis DB according to the present invention. Figure 3 is a flowchart of a method for storing AMI data using Redis DB according to the present invention. Terms and words used in this specification and claims should not be interpreted as being limited to their ordinary or dictionary meanings, and should be interpreted in a meaning and concept consistent with the technical spirit of the invention, based on the principle that the inventor can appropriately define the concept of use to best describe his invention. Therefore, the embodiments described in this specification and the configurations illustrated in the drawings are merely one preferred embodiment of the present invention and do not represent all of the technical ideas of the present invention; thus, it should be understood that various equivalents and modifications that can replace them may exist at the time of filing this application. A method for storing AMI data using a Redis DB according to the present invention will be described below with reference to the attached drawings. Before describing the method for storing AMI data using Redis DB according to the present invention, the system is briefly described. Figure 1 is a configuration diagram of a storage system for AMI data using Redis DB according to the present invention. As illustrated in FIG. 1, the storage system for AMI data utilizing Redis DB according to the present invention includes a modem (100), a server (200), an Oracle DB (300), and a Redis DB (400). First, AMI (Advanced Metering Infrastructure) is an intelligent remote metering device that uses two-way communication to provide customers with real-time information, such as power usage and electricity rates, thereby encouraging voluntary conservation and demand response. The above modem (100) communicates with the intelligent remote metering device and receives metering data, such as power usage, from the intelligent remote metering device. At this time, the intelligent remote meter reading device reads 95 meter reading data every 15 minutes and transmits them to the modem, with 1 day's worth (about 96) of data. The above server (200) does not connect to the Oracle DB (300) but queries the Key value in the Redis DB (400), which stores only the Key value and the Value corresponding to the Key value, to check whether the meter reading data exists. The above server (200) includes a data receiving unit (210), a storage determination unit (220), and a data storage unit (230) as shown in FIG. 2. The data receiving unit (210) receives metering (meter reading) data read by the intelligent remote meter reading device from a plurality of the modems (100). The above meter reading data includes the meter number, metering date, and metering time, and includes meter reading values such as power consumption and electricity charges. The above-mentioned storage determination unit (220) queries the above-mentioned Redis DB (400) with a Key value, which is a meter number, or a Value value composed of the date and time of meter reading. The above-mentioned storage determination unit (220) skips the storage process without processing if, as a result of querying the Key or Value, the corresponding Key or Value exists in the above-mentioned Redis DB (400). Conversely, the above-mentioned storage determination unit (220) determines new data and stores the Key or Value in the above-mentioned Redis DB (400) if, as a result of querying the Key or Value, the corresponding Key or Value does not exist in the above-mentioned R