Proficient speculative execution model for SQL statements

Enforcing transaction consistency, data integrity and security specifications lead to the creation and manipulation of the data in all the commercial applications. Speculative execution is a technique implemented for reducing the dependences in the high performance microprocessors which supports the hardware and software techniques. Speculative parallelism exploits the instruction level parallelism, increases utilization and the granularity of the code. In this paper we are proposing a proficient execution model for the execution of the SQL statements with the speculative multithreaded processors and a thread spawning scheme for this model on Multicores. A mathematical formulation to reduce CPU time and memory requirements is dealt to make the analysis.