Priority frequency maptable for query optimization using materialized views

Islam, Md. Rafiqul and Chowdhury, Morshed 2005, Priority frequency maptable for query optimization using materialized views, in ICIT 2005 : Human computer interaction : Proceedings of the 2nd International Conference on Information Technology, [University of Jordan], Amman, Jordan, pp. 15-18.

Attached Files
Name Description MIMEType Size Downloads

Title Priority frequency maptable for query optimization using materialized views
Author(s) Islam, Md. Rafiqul
Chowdhury, Morshed
Conference name International Conference on Information Technology (2nd: 2005: Amman, Jordan)
Conference location Amman, Jordan
Conference dates 3-5 May. 2005
Title of proceedings ICIT 2005 : Human computer interaction : Proceedings of the 2nd International Conference on Information Technology
Editor(s) Al-Dahoud, A.
Publication date 2005
Conference series International Conference on Information Technology
Start page 15
End page 18
Publisher [University of Jordan]
Place of publication Amman, Jordan
Keyword(s) materialized views
maptable
query optimization
priority frequency table
Summary In this paper query optimization using materialized views has been analyzed and a comprehensive and efficient technique has been proposed to create Map-table. Materialized views can provide massive improvements in query processing time, especially for aggregation queries over large tables. To realize this potential, a number of existing techniques have been considered regarding the problem of maintaining materialized views as well as optimal searching time and memory overhead. Keeping this in mind, an optimal algorithm has been proposed in this paper for query optimization. It has been demonstrated that the proposed algorithm reduces the searching time substantially and reducing the memory size as well.
ISBN 9957858300
9789957858308
Language eng
Field of Research 080605 Decision Support and Group Support Systems
HERDC Research category E1 Full written paper - refereed
ERA Research output type E Conference publication
Persistent URL http://hdl.handle.net/10536/DRO/DU:30005740

Document type: Conference Paper
Collection: School of Information Technology
Connect to link resolver
 
Unless expressly stated otherwise, the copyright for items in DRO is owned by the author, with all rights reserved.

Versions
Version Filter Type
Access Statistics: 386 Abstract Views, 1 File Downloads  -  Detailed Statistics
Created: Mon, 07 Jul 2008, 09:53:34 EST

Every reasonable effort has been made to ensure that permission has been obtained for items included in DRO. If you believe that your rights have been infringed by this repository, please contact drosupport@deakin.edu.au.