SYSTEM AND METHOD FOR SYNCHRONIZING CONSUMPTION DATA FROM CONSUMPTION METERS

• US 20160131509A1
• Filed: 11/07/2014
• Published: 05/12/2016
• Est. Priority Date: 11/07/2014
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: NELSON, Lawrence, MCAULIFFE, Timothy, SISKA, David
• Application Number:
  US14/535,756
• Publication Number:
  US 20160131509A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G01D 4/02 Details
• CPC Class Codes: G06Q 50/06 Energy or water supply

Abstract

Systems, methods, and other embodiments associated with synchronizing consumption data are described. In one embodiment, a method includes determining when a first consumption data of a first type and a second consumption data of a second type, derived from a same consumption meter, are unsynchronized with each other. The example method also includes synchronizing the first consumption data with the second consumption data when the two types of data are determined to be unsynchronized with each other.

Claims

1. A computer-implemented method comprising:

reading, by a meter data management tool, at least one data structure comprising first consumption data and second consumption data derived from a consumption meter;

determining, by the meter data management tool, when the first consumption data and the second consumption data are unsynchronized with each other;

synchronizing, by the meter data management tool, the first consumption data with the second consumption data when the determining indicates that the first consumption data and the second consumption data are unsynchronized with each other; and

outputting, by the meter data management tool, synchronized first consumption data and synchronized second consumption data to at least one data structure.

2. The computer-implemented method of claim 1, wherein the first consumption data and the second consumption data are unsynchronized with each other when a difference between a total consumption value of the first consumption data and a total consumption value of the second consumption data, over a same determined period of time, is greater than a determined threshold value.

3. The computer-implemented method of claim 1, wherein the synchronizing comprises adjusting at least one of the first consumption data and the second consumption data to match a total consumption value of the first consumption data with a total consumption value of the second consumption data over a determined period of time.

4. The computer-implemented method of claim 1, wherein the first consumption data comprises register consumption data, and the second consumption data comprises interval consumption data distributed over a plurality of consumption time intervals.

5. The computer-implemented method of claim 1, further comprising identifying and filling in gaps in the second consumption data, by the meter data management tool, based at least in part on interpolating the second consumption data.

6. The computer-implemented method of claim 1, further comprising identifying and filling in gaps in the second consumption data, by the meter data management tool, by applying a set of predetermined rules to the second consumption data based, at least in part, on the first consumption data.

7. The computer-implemented method of claim 1, wherein the second consumption data comprises interval consumption data distributed over a plurality of consumption time intervals, and wherein the synchronizing comprises adjusting the interval consumption data for each consumption time interval of the plurality of consumption time intervals to make a total consumption value of the second consumption data match a total consumption value of the first consumption data over a determined period of time.

8. The computer-implemented method of claim 1, further comprising evenly extrapolating, by the meter data management tool, the first consumption data across a plurality of consumption time periods associated with the second consumption data.

9. The computer-implemented method of claim 1, further comprising unevenly extrapolating, by the meter data management tool, the first consumption data across a plurality of consumption time periods associated with the second consumption data based on at least a determined profile.

10. The computer-implemented method of claim 1, further comprising billing a customer associated with the consumption meter based, at least in part, on a total consumption value of at least one of the synchronized first consumption data and the synchronized second consumption data.

11. A computing system, comprising:

data loading and validation logic configured to;

(i) read at least one data structure comprising primary consumption data and secondary consumption data derived from a same consumption meter,

(ii) pre-process at least one of the primary consumption data and the secondary consumption data to put in a form that is compatible with a data synchronization process, and

(iii) determine when the primary consumption data and the secondary consumption data are unsynchronized with each other;

data synchronization logic configured to synchronize the primary consumption data with the secondary consumption data by performing the data synchronization process; and

data output logic configured to output the synchronized primary consumption data and secondary consumption data to at least one data structure of a database device.

12. The computing system of claim 11, further comprising rule configuration logic configured to facilitate user generation of rules to be applied by at least the data synchronization logic and the data loading and validation logic.

13. The computing system of claim 11, wherein the synchronization logic is configured to adjust at least one of the primary consumption data and the secondary consumption data to match a total consumption value of the primary consumption data with a total consumption value of the secondary consumption data over a determined period of time.

14. The computing system of claim 11, wherein the synchronization logic is configured to synchronize the primary consumption data with the secondary consumption data by:

(i) extrapolating the primary consumption data across a plurality of consumption time periods associated with the secondary consumption data, and

(ii) adjusting the secondary consumption data, for at least one consumption time period of the plurality of consumption time periods, based on, at least in part, the extrapolated primary consumption data such that a total consumption value of the adjusted secondary consumption data matches a total consumption value of the extrapolated primary consumption data over a determined period of time.

15. The computing system of claim 11, wherein the primary consumption data comprises register consumption data, and the secondary consumption data comprises interval consumption data distributed over a plurality of consumption time intervals.

16. A non-transitory computer-readable medium storing computer-executable instructions that are part of an algorithm that, when executed by a computer, cause the computer to perform a method, wherein the instructions comprise instructions configured for:

reading at least one data structure comprising register data and interval data derived from a consumption meter;

determining when the register data and the interval data are unsynchronized with each other; and

synchronizing the register data with the interval data, when the register data and the interval data are determined to be unsynchronized with each other, by performing a data synchronization process that matches a total consumption value of the interval data with a total consumption value of the register data.

17. The non-transitory computer-readable medium of claim 16, wherein the instructions further comprise instructions configured for outputting the synchronized register data and interval data to at least one data structure of a database device.

18. The non-transitory computer-readable medium of claim 16, wherein the instructions for determining comprise instructions configured for calculating a difference between the total consumption value of the register data and the total consumption value of the interval data, over a same determined time period, that is greater than a determined threshold value.

19. The non-transitory computer-readable medium of claim 16, wherein the instructions for synchronizing comprise instructions configured for adjusting the interval data until a difference between the total consumption value of the register data and the total consumption value of the interval data, over a same determined time period, is less than a determined threshold value.

20. The non-transitory computer-readable medium of claim 16, wherein the instructions further comprise instructions configured for pre-processing at least one of the register data and the interval data, before determining when the register data and the interval data are unsynchronized, to put at least one of the register data and the interval data in a form that is compatible with the data synchronization process.