Partitioning electrical data within a database

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

Reexamination Certificate

active

07548907

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.

REFERENCES:
patent: 6487457 (2002-11-01), Hull et al.
patent: 6657553 (2003-12-01), Bergman et al.
patent: 2004/0098415 (2004-05-01), Bone et al.
patent: 2004/0128146 (2004-07-01), Williams et al.
patent: 2004/0210608 (2004-10-01), Lee et al.
Energy Manager EXT brochure; Dated Aug. 11, 2005; Published by Electro Industries/GaugeTech, Westbury, NY.
Nexus Communicator 2.0 Log Database Structure; Dated Oct. 18, 2001; Revision 1.20; Published by Electro Industries/GaugeTech, Westbury, NY.
DEC Data Systems: “DEC Data Systems—DataWise Manual” May 6, 2006, XP002470188, p. 5-p. 6, p. 58-60, p. 129.
Don Landing et al.: “Sensor Data Analysis Framework Research Roadmap—Integrating Stream Processing and Persistent Data Retrieval”, Feb. 2006, XP002470189, the whole document.
Harrison M: “EPC Information Service—Data Model and Queries” Internet Citation, Oct. 1, 2003, XP002355668, the whole document.
Gehrke J et al: “Sensor and Actuator networks—Query processing in sensor networks” IEEE Pervasive Computing, IEEE Service Center, Los Alamitos, CA, US, vol. 3, No. 1, Jan. 2004, pp. 46-55, XP0011108155, the whole document.
Bonnet P et al: “Querying the Physical World” IEEE Personal Communications, IEEE Communications Society, US, vol. 7, No. 5, Oct. 2000, pp. 10-15, XP000966619, the whole document.
Ledlie J et al: “Provenance-Aware Sensor Data Storage” Data Engineering Workshops, 2005, 21st International Conference on Tokyo, Japan Apr. 5-8, 2005, Piscataway, NJ, USA, IEEE, Apr. 5, 2005, pp. 1189-1189, XP010924091, the whole document.
Kevin Chang et al: “SensorBase.org—A Centralized Repository to Slog Sensor Network Data” Center for Embedded Network Sensing. Papers. Paper 116, May 5, 2006, XP002470190, the whole document.
Written Opinion corresponding to co-pending International Patent Application Serial No. PCT/US2007/011247, European Patent Office, dated May 15, 2008, 12 pages.
International Search Report corresponding to co-pending International Patent Application Serial No. PCT/US2007/011247, European Patent Office, dated May 15, 2008, 8 pages.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Partitioning electrical data within a database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Partitioning electrical data within a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Partitioning electrical data within a database will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-4130911

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.