CAREERGeneratingProvablyCorrectQueryOptimizers.docVIP

CAREER: Generating Provably Correct Query Optimizers Mitch Cherniack Department of Computer ScienceBrandeis University Contact Information 415 South St., Mailstop 018 Waltham, MA, 02454 Phone: (781) 736-2738 Fax : (781) 736-2741 Email:  HYPERLINK mailto:mfc@ mfc@ URL: /~mfc WWW PAGE /~cokokola List of Supported Students and Staff Xiaoyu Wang, 2nd year Ph.D. student, Antonella Di Lillo, 1st year Masters student (summer support) Project Award Information Award Number: IIS-9984960 Duration: 10/01/2000 -- 09/01/2004 (presently in year 1) Title: CAREER: Generating Provably Correct Query Optimizers Keywords Query Optimization, Formal Methods, Rule-Based Optimizers Project Summary The goal of this project is to assist researchers and developers in building query optimizers that are provably correct. Specifically, this research group is building a framework which accepts specifications of optimizer components and their interactions, and generates optimizers that can be shown to satisfy the property that the plans they construct always return the data specified in a user queries. The groups approach separates the components of the optimizer into those that require correctness proofs (the safety critical components) from those that do not. Languages are under design for formally specifying those components, and tools are under construction that both generate these components according to the specifications, and generate proof obligations enabling their verification with an automated theorem prover. The experimental research is linked to the educational goal of training students in the application of formal methods in building large software systems. The results of this project will provide a sandbox for database researchers in both academia and industry, to introduce new optimizer techniques and products while providing tangible guarantees that they are free of errors. Publications and Products COKO-KOLA Query Rewriter Generator. Available for Linux and Solaris f