Investigating Design Choices between Bitmap index and B-tree index for a Large Data Warehouse System

QR Code

Investigating Design Choices between Bitmap index and B-tree index for a Large Data Warehouse System

Building indexes on database is common, but it has an important impact on the query performance, especially in large databases such as a Data Warehouse where the queries are usually very complex and ad hoc. If a proper index structure is chosen, the query response time call be accelerated. Until now...

Full description

Bibliographic Details
Main Authors:	Morteza, Zaker, Somnuk, Phon-Amnuaisuk, Su-Cheng, Haw
Format:	Conference or Workshop Item
Published:	2008
Subjects:	T Technology (General) QA75.5-76.95 Electronic computers. Computer science
Online Access:	http://shdl.mmu.edu.my/2841/

Similar Items

Optimizing the Data Warehouse Design by Hierarchical Denormalizing
by: Morteza, Zaker, et al.
Published: (2008)

Affective music processing: Challenges
by: Phon-Amnuaisuk, Somnuk
Published: (2005)

Properties of Bayesian student model for INQPRO
by: Ting, Choo-Yee, et al.
Published: (2012)

Determining a Suitable Desired Factors for Nonnegative Matrix Factorization in Polyphonic Music Transcription
by: Sophea, Seng, et al.
Published: (2007)

Effects of Time and Frequency Resolution on Nonnegative Matrix Factorization
by: Sophea, Seng, et al.
Published: (2007)

Evolution of structural path indexing techniques in XML databases: A survey and open discussion
by: Su-Cheng, Haw, et al.
Published: (2008)

Chorale harmonization: A view from a search control perspective
by: Phon-Amnuaisuk, Somnuk, et al.
Published: (2006)

Data Warehouse Considerations: Investigating Indices And Hierarchical Denormalized Snowflakes (HDS)
by: Zaker, Morteza
Published: (2009)

Towards music fitness evaluation with the hierarchical SOM
by: Edwin Hui Hean, Law, et al.
Published: (2008)

Establishing a Probabilistic Model for Cognitive Learning Style
by: Teh, Yoke-Jin, et al.
Published: (2005)

A cascaded classifier approach for improving detection rates on rare attack categories in network intrusion detection
by: Khor, Kok Chin, et al.
Published: (2012)

Effects of Communication Range, Noise and Help Request Signal on Particle Swarm Optimization with Area Extension (AEPSO)
by: Atyabi, Adham, et al.
Published: (2007)

Cooperative learning of homogeneous and heterogeneous particles in Area Extension PSO
by: Atyabi, Adham, et al.
Published: (2008)

A Review of Recent Alignment-Free Clustering Algorithms in Expressed Sequence Tag
by: Ng, Keng-Hoong, et al.
Published: (2009)

A Feature Selection Approach for Network Intrusion Detection
by: Khor, Kok-Chin, et al.
Published: (2009)

Modeling and intervening across time in scientific inquiry exploratory learning environment
by: Ting, Choo Yee, et al.
Published: (2008)

Clustering of Expressed Sequence Tag (EST) with Markov Models and Self-Organizing Maps: An Exploratory Study
by: Ng, Keng Hoong, et al.
Published: (2008)

Convergence index for BPN training
by: Gunasekaran, S
Published: (2003)

Intelligent learning environment: Building hybrid system from standard application and web application
by: Chee, , KS, et al.
Published: (2005)

Evolving music generation with SOM-fitness genetic programming
by: Phon-Amnuaisuk, Somnuk, et al.
Published: (2007)

Interactivities in music intelligent tutoring system
by: Phon-Amnuaisuk, S., et al.
Published: (2005)

Manufacturing Test Data Analysis-On Comparing Different Classification Algorithms
by: Lee, Jia Keat, et al.
Published: (2007)

Particle swarm optimization with area extension (AEPSO)
by: Atyabi, A, et al.
Published: (2007)

iProt – A Data Warehouse For Protein Database.
by: Jaya, M.I., et al.
Published: (2007)

Adaptive GA: An Essential Ingredient in High-Level Synthesis
by: Choong, Florence Chiao Mei, et al.
Published: (2008)

Indexing Of Bilingual Knowledge Bank Based On The Synchronous Sstc Structure
by: Ye , Hong Hoe
Published: (2006)

db4DNASeq: An Object-oriented DNA Database Model associated with Sequence Search Method
by: Ng, Keng Hoong, et al.
Published: (2008)

Performance Optimization of Java Virtual Machine on Dual-Core Technology for Web Services - A Study
by: Mun, Chong Kam, et al.
Published: (2007)

An Efficiency Analysis Of Seaports Using Extended Window Analysis, Malmquist Index And Simar-wilson Approach
by: Naser Al-Eraqi , Ahmed Salem
Published: (2009)

Performance evaluation of inverted files, B-Tree and B+ Tree indexing algorithm on Malay text / Suhanah Rosnan
by: Rosnan, Suhanah
Published: (2016)

Data storage practices and query processing in XML databases: A survey
by: Haw, Su-Cheng, et al.
Published: (2011)

INLAB2: Fast Native XML Storage and Query Retrieval
by: Su-Cheng, Haw, et al.
Published: (2008)

Modeling of the biliary tree structure in MRCP images
by: Logeswaran, , Rajasvaran, et al.
Published: (2005)

A Comparative Study and Benchmarking on XML Parsers
by: Haw, Su Cheng, et al.
Published: (2007)

Visualizing Phylogenetic Trees: Algorithms And Visual Comparison Techniques
by: Wan Zainon, Wan Mohd Nazmee
Published: (2011)

Division-Based Methods For Large Point Sets Registration
by: Chen , Junfen
Published: (2016)

Scale-space segment growing for hierarchical detection of biliary tree structure
by: LOGESWARAN, RAJASVARAN
Published: (2005)

Gpu Based Fast Phylogenetic Tree Construction Algorithm With Reduce Dataset
by: Ibrahim, Najihah
Published: (2016)

Genogram Visualization Using Social Network Approach For Medical Family Tree
by: Bokhare, Siti Fatimah
Published: (2018)

An ant colony optimization approach to the degree-constrained minimum spanning tree problem
by: Ewe, HT, et al.
Published: (2005)