TY - CONF T1 - Time and space optimization for processing groups of multi-dimensional scientific queries T2 - Proceedings of the 18th annual international conference on Supercomputing Y1 - 2004 A1 - Aryangat,Suresh A1 - Andrade,Henrique A1 - Sussman, Alan KW - multi-query optimization KW - Scientific databases AB - Data analysis applications in areas as diverse as remote sensing and telepathology require operating on and processing very large datasets. For such applications to execute efficiently, careful attention must be paid to the storage, retrieval, and manipulation of the datasets. This paper addresses the optimizations performed by a high performance database system that processes groups of data analysis requests for these applications, which we call queries. The system performs end-to-end processing of the requests, formulated as PostgreSQL declarative queries. The queries are converted into imperative descriptions, multiple imperative descriptions are merged into a single execution plan, the plan is optimized to decrease execution time via common compiler optimization techniques, and, finally, the plan is optimized to decrease memory consumption. The last two steps are experimentally shown to effectively reduc the amount of time required while conserving memory space as a group of queries is processed by the database. JA - Proceedings of the 18th annual international conference on Supercomputing T3 - ICS '04 PB - ACM CY - New York, NY, USA SN - 1-58113-839-3 UR - http://doi.acm.org/10.1145/1006209.1006224 M3 - 10.1145/1006209.1006224 ER -