Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-05-11
2009-06-16
Rones, Charles (Department: 2164)
Data processing: database and file management or data structures
Database design
Data structure types
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.
Kaushik Rekha
McInturff Andy Mark
Patterson Warren
Stokes Loretta
Wall Theresa
Quader Fazlul
Rones Charles
LandOfFree
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.
Profile ID: LFUS-PAI-O-4130911