Partitioning electrical data within a database

• US 20070266004A1
• Filed: 05/11/2006
• Published: 11/15/2007
• Est. Priority Date: 05/11/2006
• Status: Active Grant

• Current Assignee: Square D Company (Schneider Electric SE)
• Original Assignee: Square D Company (Schneider Electric SE)
• Inventors: Wall, Theresa, Stokes, Loretta, McInturff, Andy, Kaushik, Rekha, Patterson, Warren
• Granted Patent: US 7,548,907 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24554 Unary operations; Data partitioning operations
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A method of partitioning and archiving electrical data received from a power monitoring system in a database including a plurality of tables organized by at least group and date. Data in the database is queried by first searching an electrical data catalog to determine whether the data exists in the database before searching the database. The data is targeted by group and by date, yielding faster response times and enhanced database scalability. An electrical data retention table includes a set of rules governing, for each group, the maximum age of the data that can be stored in the table in the database. A data table associated with a particular group whose age exceeds the maximum age provided in the set of rules is removed from the database and from the electrical data catalog. If desired, the entire data table can be imported back into the database.

Claims

1. A method of partitioning electrical data in a database, comprising:

receiving data from a monitoring system that monitors measurable quantities of a utility, the data including time data representing at least the date the monitored data was acquired;

creating a plurality of tables in the database, each table being associated with a group and a date that are distinct from every other table in the database; and

storing a value of the monitored data in one of the plurality of tables based on at least the group to which the value belongs and the date the value was acquired.

2. The method of claim 1, further comprising:

querying the database for first monitored data belonging to a first group and acquired on a first date;

determining whether the first monitored data is present in the database by searching a data catalog stored in the database, the data catalog being logically distinct from the plurality of tables; and

responsive to the determining, if the data catalog indicates the presence of the first monitored data, retrieving the first monitored data from the table associated with the first group and the first date.

3. The method of claim 2, further comprising, responsive to the determining, if the data catalog does not indicate the presence of the first monitored data, searching an archive database for the first monitored data based on its associated first group and first date.

4. The method of claim 1, further comprising:

storing a set of data retention rules in the database, the rules indicating, for each group with which the tables are associated, a retention date range during which monitored data is stored in the database; and

based on the data retention rules, archiving monitored data to an archive database when a date associated with the monitored data to be archived falls outside of the retention date range associated with the group to which the monitored data to be archived belongs.

5. The method of claim 1, if the value of the monitored data does not belong to any group in the database, writing the monitored data received to a table of rejected data.

6. A computer readable storage medium encoded with instructions for directing a controller to perform the method of claim 1.

7. The method of claim 1, wherein the utility is selected from the group consisting of water, air, gas, energy, steam, and weather.

8. The method of claim 1, wherein the monitoring system is a power monitoring system and the utility is energy.

9. The method of claim 8, wherein the monitored data is electrical data.

10. The method of claim 8, wherein the at least one group is a group that includes a plurality of topics that relate to electrical energy.

11. The method of claim 10, wherein the plurality of topics any one or more of real energy, reactive energy, and apparent energy.

12. The method of claim 8, wherein the at least one group is a group that includes a plurality of topics that relate to electrical current.

13. The method of claim 12, wherein the plurality of topics include any one or more of current, average current, and maximum current.

14. The method of claim 8, wherein the at least one group is a group that includes a plurality of characteristics that relate to power quality.

15. The method of claim 14, wherein the plurality of characteristics include any one or more of total harmonic distortion (THD) current, THD voltage, harmonic factor, distortion power factor, total demand distortion, crest factor, and K-factor.

16. The method of claim 8, wherein the at least one group is a group that includes a plurality of electrical measurements that relate to electrical demand.

17. The method of claim 16, wherein the plurality of electrical measurements include any one or more of demand current, K-factor demand, peak demand current, coincident demand, demand power, peak demand power, KW demand, KVAR demand, and KVA demand.

18. A method of archiving electrical data, comprising:

creating in a database a plurality of tables, each table being associated with a distinct group and a distinct date relative to all other tables in the database;

storing electrical data that includes data corresponding to a group and a date in the corresponding one table associated with that corresponding group and that corresponding date, the electrical data being received from a power monitoring system;

providing a set of rules for retaining data in the database, the set of rules indicating on a per group basis the maximum age of data that can be stored in each group; and

removing from the database a first table whose data corresponds to a date that exceeds the corresponding maximum age for the group to which the first table belongs as provided in the set of rules.

19. The method of claim 18, further comprising archiving the first table in a data archive.

20. The method of claim 18, wherein the archiving is carried out remote from the database.

21. The method of claim 18, wherein the set of rules are stored in an electrical data retention table in the database.

22. The method of claim 18, further comprising:

storing the first table in an archive database;

providing an electrical data catalog in the database that includes at least a plurality of entries identifying the tables and their corresponding groups and dates; and

responsive to removing from the database the first table, removing from the electrical data catalog the entry corresponding to the first table.

23. The method of claim 22, further comprising:

importing from the archive database the first table into the database; and

writing into the electrical data catalog an entry corresponding to the first table.