BioMed Research International

BioMed Research International / 2005 / Article
Special Issue

Data Mining in Genomics and Proteomics

View this Special Issue

Research article | Open Access

Volume 2005 |Article ID 729240 |

Nadim W. Alkharouf, D. Curtis Jamison, Benjamin F. Matthews, "Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases", BioMed Research International, vol. 2005, Article ID 729240, 8 pages, 2005.

Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases

Received27 Jul 2004
Revised26 Nov 2004
Accepted07 Dec 2004


Gene expression databases contain a wealth of information, but current data mining tools are limited in their speed and effectiveness in extracting meaningful biological knowledge from them. Online analytical processing (OLAP) can be used as a supplement to cluster analysis for fast and effective data mining of gene expression databases. We used Analysis Services 2000, a product that ships with SQLServer2000, to construct an OLAP cube that was used to mine a time series experiment designed to identify genes associated with resistance of soybean to the soybean cyst nematode, a devastating pest of soybean. The data for these experiments is stored in the soybean genomics and microarray database (SGMD). A number of candidate resistance genes and pathways were found. Compared to traditional cluster analysis of gene expression data, OLAP was more effective and faster in finding biologically meaningful information. OLAP is available from a number of vendors and can work with any relational database management system through OLE DB.

Copyright © 2005 Hindawi Publishing Corporation. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

More related articles

 PDF Download Citation Citation
 Order printed copiesOrder

Related articles

Article of the Year Award: Outstanding research contributions of 2020, as selected by our Chief Editors. Read the winning articles.