System and method of high volume import, validation and estimation of meter data
First Claim
1. A system for high volume import, validation, and estimation of meter data comprising:
- at least one receiver server configured to;
receive meter data from a plurality of external devices, each external device being assigned to one of a plurality of device groupings;
sort the meter data into a plurality of workbins respectively associated with the plurality of device groupings; and
compress the meter data contained in each workbin into a plurality of data files, each data file being identifiable by workbin;
a plurality of validation and estimation servers configured to;
import, for one workbin at a time, all data files associated with such workbin from the at least one receiver server;
store historic data associated with each workbin;
validate the meter data contained within the data files against the historic data, by comparing such meter data with historic data from comparable prior periods of time;
use stored historic data for a given workbin to estimate replacement values for meter data that is determined to be invalid or missing for such given workbin; and
form the validated and estimated meter data into a plurality of import files;
wherein the plurality of validation and estimation servers operate during a plurality of processing windows, each processing window corresponding to one of the plurality of workbins such that all data files associated with a workbin are processed by the plurality of validation and estimation servers as a batch; and
at least one database server configured to import and store the plurality of import files.
3 Assignments
0 Petitions
Accused Products
Abstract
A meter data management system includes one or more application servers configured to receive, validate and estimate received meter data. The one or more application servers may include various memory/media elements for storing raw and transformed meter data as well as software in the form of computer-executable instructions, which are executed by a processor to implement a variety of functions, including establishing a mapping between the plurality of external devices and a plurality of preconfigured processing workbins (e.g., collections of meter channels in the same time zones), transforming the received meter data into a plurality of data files identified by timing parameter and workbin, validating data provided in each data file, estimating missing or invalid data, and automatically writing validated (and optionally estimated) data as import files to a database server. Such clean data files are then imported to one or more dedicated databases installed on the database server.
-
Citations
8 Claims
-
1. A system for high volume import, validation, and estimation of meter data comprising:
-
at least one receiver server configured to; receive meter data from a plurality of external devices, each external device being assigned to one of a plurality of device groupings; sort the meter data into a plurality of workbins respectively associated with the plurality of device groupings; and compress the meter data contained in each workbin into a plurality of data files, each data file being identifiable by workbin; a plurality of validation and estimation servers configured to; import, for one workbin at a time, all data files associated with such workbin from the at least one receiver server; store historic data associated with each workbin; validate the meter data contained within the data files against the historic data, by comparing such meter data with historic data from comparable prior periods of time; use stored historic data for a given workbin to estimate replacement values for meter data that is determined to be invalid or missing for such given workbin; and form the validated and estimated meter data into a plurality of import files; wherein the plurality of validation and estimation servers operate during a plurality of processing windows, each processing window corresponding to one of the plurality of workbins such that all data files associated with a workbin are processed by the plurality of validation and estimation servers as a batch; and at least one database server configured to import and store the plurality of import files. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
Specification