Method and system for scheduling workload in databases

Details Method and system for scheduling workload in databases Method and system for scheduling workload in databases

2006-12-20

2009-10-06

Trujillo, James (Department: 2159)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07599969

ABSTRACT:
A method for scheduling a workload comprising a plurality of transactions relating to a database management system is disclosed. The method comprises the steps of determining a log space amount required by each transaction in the workload, estimating the total log space required for executing the workload based on the log space amounts required by each transaction, and scheduling execution of the workload based on the estimated total log space.

REFERENCES:
patent: 6542893 (2003-04-01), Quernemden
patent: 6732124 (2004-05-01), Koseki et al.
patent: 6944711 (2005-09-01), Mogi et al.
patent: 7302455 (2007-11-01), Cordsmeyer et al.
patent: 2003/0208464 (2003-11-01), Lee et al.
patent: 2005/0234842 (2005-10-01), Lau et al.
patent: 2001028113 (2001-04-01), None
“Database log file storage”, International Business Machines. (http://publib.boulder.ibm.com/infocenter/cmod/v8r3m0/index.jsp?topic=/com.ibm.ondemand.mp.doc/ars1p171136.htm), Dec. 15, 2006.
“SQL Server 6.5 Optimization Tips”, Sequel Server Worldwide Users Group. (http://www.mssqlcity.com/Tips/tipSQL65.htm), Dec. 15, 2006.
“Database Resource Planning”, Microsoft Corporation. (http://msdn2.microsoft.com.en-us/library/ms166482.aspx), Dec. 15, 2006.
“Tips for Performance Tuning SQL Server Database Settings”, SQL-Server-Performance.Com. (http://www.sql-server-performance.com/database—settings.asp),Feb. 20, 2006.
“How to Estimate the Database Size for Site Server Analysis”, Microsoft Corporation. (http://support.microsoft.com/kb/q216559/), Nov. 10, 2000.
Ferreto, T., De Rose, C., and Northfleet, C., “Scheduling BoT Applications in Grids Using a Slave Oriented Adaptive Algorithm”, Springer Berlin/Heidelberg, Parallel and Distributed Processing and Applications, vol. 3358/2004, copyright 2004, pp. 392-398, ISBN 978-3-540-24128-7. (www.springerlink.com/index/8D4EEMPKGT9TL42A.pdf).
Feitselson, D. G., “Metrics for Parallel Job Scheduling and Their Convergence”, Springer Berlin/Heidelberg, Job Scheduling Strategies for Parallel Processing: 7thInternational Workshop, JSSPP 2001, Cambridge, MA, USA, Jun. 16, 2001, Revised Papers, p. 181. (www.springerlink.com/index/YQW8HMNLET36PK1.pdf).
Smith, W., Taylor, V., and Foster, I, “Using Run-Time Predictions to Estimate Queue Wait Times and Improve Scheduler Performance”. (www.globus.org/alliance/publications/papers/p.pdf), Dec. 20, 2006.
Covreur, J., “Curiosity is Bliss: Scheduling Your Network Connections (SYNC)”, Jan. 26, 2004. (http://blog.monstuff.com/archives/000133.html).

Affiliated with

Also associated with

Rating

Method and system for scheduling workload in databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for scheduling workload in databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for scheduling workload in databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4053110