MarinaBalina_DBTuningProject

MarinaBalina_DBTuningProject - Marina Balina N16636038...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Marina Balina N16636038 Advanced Database Systems 2007 Medical Research Database Tuning T ABLE OF C ONTENTS I NTRODUCTION ..............................................................................................3 D ATABASE S YSTEM ........................................................................................3 U SING C OVERING I NDEX ................................................................................4 D IRECT P ATH L OAD .....................................................................................10 U SING EXISTS VS . IN.................................................................................14 A NALYZING L ARGE Q UERIES .......................................................................18 U SING M ATERIALIZED V IEWS AND O PTIMIZER H INTS ................................26 C ONCLUSION ................................................................................................33 APPENDIX A .............................................................................................34 GENE DATABASE DATA DICTIONARY .......................................................................................................34 APPENDIX B .............................................................................................36 TXP DATABASE DATA DICTIONARY...........................................................................................................36 ViewTXPDonorReport......................................................................................................................................41 ViewLab .............................................................................................................................................................48 FINAL VERSION OF TXP LAB TEST QUERY ..............................................................................................49 APPENDIX C .............................................................................................54 PKD DATABASE DATA DICTIONARY..........................................................................................................54 PKD Entity Relationship Diagram...................................................................................................................61 Materialized View SQL.....................................................................................................................................62 ViewEventQuestion ...........................................................................................................................................69 ViewPatientInfo.................................................................................................................................................70 Original PKD Query Execution Plan ..............................................................................................................71 Introduction Our Rogosin Institute database server houses four database instances. Three of them Our Rogosin Institute database server houses four database instances....
View Full Document

This note was uploaded on 10/06/2011 for the course CS 2434 taught by Professor Shasha during the Spring '11 term at NYU.

Page1 / 75

MarinaBalina_DBTuningProject - Marina Balina N16636038...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online