Optimizing database queries

Details Optimizing database queries Optimizing database queries

2011-05-10

2011-05-10

Lee, Wilson (Department: 2163)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S719000, C707S720000

Reexamination Certificate

active

07941426

ABSTRACT:
Techniques for optimizing database queries for energy efficiency. A query optimizer is configured to compare energy requirements of query plans, and to select a query plan requiring minimal energy to execute. The query optimizer may also compare time performance of the query plans, and may select a query plan by matching to a user preference for a relative priority between energy requirements and time performance.

REFERENCES:
patent: 6356889 (2002-03-01), Lohman et al.
patent: 6636846 (2003-10-01), Leung et al.
patent: 6957211 (2005-10-01), Tyulenev et al.
patent: 7107262 (2006-09-01), Dettinger et al.
patent: 7523094 (2009-04-01), Thiemann et al.
patent: 7602570 (2009-10-01), De Boer
patent: 2003/0158842 (2003-08-01), Levy et al.
patent: 2005/0289098 (2005-12-01), Barsness et al.
patent: 2006/0218118 (2006-09-01), Gupta
patent: 2007/0050328 (2007-03-01), Li et al.
patent: 2008/0147593 (2008-06-01), Ramesh et al.
patent: 2009/0150413 (2009-06-01), Basu et al.
patent: 2009/0281986 (2009-11-01), Bestgen et al.
patent: 2009/0282272 (2009-11-01), Bestgen et al.
Jun-Zhao Sun (2007), Query Optimization Based on User-Specified Delay Item for Wireless Sensor Networks, pp. 493-498.
Jayaprakash Pisharath, Alok Choudhary and Mahmut Kandermir, Energy Management Schemes for Memory-Resident database systems, 2004, pp. 218-227.
Qingchun Ren and Qilian Liang (2006), A Quality-Guaranteed and Energy-Efficient Query Processing Algorithm for Sensor Networks, pp. 2175-2180.
Prabal K. Dutta and David E. Culler (2005), System Software Techiniques for Low-Power Operation in Wireless Sensor Networks, pp. 924-931.
Pisharath, Jayaprakash et al., Reducing Energy consumption of Queries in Memory-Resident Database Systems, Cases '04: Proceedings of the 2004 International Conference on Compilers, Architecture, and Synthesis for Embedded Systems, 2004, pp. 35-45, Washington, DC.

Affiliated with

Also associated with

Rating

Optimizing database queries does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2635304