Cargando…

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

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 da...

Descripción completa

Detalles Bibliográficos
Autores principales: Alkharouf, Nadim W., Jamison, D. Curtis, Matthews, Benjamin F.
Formato: Texto
Lenguaje:English
Publicado: Hindawi Publishing Corporation 2005
Materias:
Acceso en línea:https://www.ncbi.nlm.nih.gov/pmc/articles/PMC1184053/
https://www.ncbi.nlm.nih.gov/pubmed/16046824
http://dx.doi.org/10.1155/JBB.2005.181
_version_ 1782124710765527040
author Alkharouf, Nadim W.
Jamison, D. Curtis
Matthews, Benjamin F.
author_facet Alkharouf, Nadim W.
Jamison, D. Curtis
Matthews, Benjamin F.
author_sort Alkharouf, Nadim W.
collection PubMed
description 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.
format Text
id pubmed-1184053
institution National Center for Biotechnology Information
language English
publishDate 2005
publisher Hindawi Publishing Corporation
record_format MEDLINE/PubMed
spelling pubmed-11840532005-09-07 Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases Alkharouf, Nadim W. Jamison, D. Curtis Matthews, Benjamin F. J Biomed Biotechnol Research Article 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. Hindawi Publishing Corporation 2005 /pmc/articles/PMC1184053/ /pubmed/16046824 http://dx.doi.org/10.1155/JBB.2005.181 Text en Hindawi Publishing Corporation
spellingShingle Research Article
Alkharouf, Nadim W.
Jamison, D. Curtis
Matthews, Benjamin F.
Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases
title Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases
title_full Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases
title_fullStr Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases
title_full_unstemmed Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases
title_short Online Analytical Processing (OLAP): A Fast and Effective Data Mining Tool for Gene Expression Databases
title_sort online analytical processing (olap): a fast and effective data mining tool for gene expression databases
topic Research Article
url https://www.ncbi.nlm.nih.gov/pmc/articles/PMC1184053/
https://www.ncbi.nlm.nih.gov/pubmed/16046824
http://dx.doi.org/10.1155/JBB.2005.181
work_keys_str_mv AT alkharoufnadimw onlineanalyticalprocessingolapafastandeffectivedataminingtoolforgeneexpressiondatabases
AT jamisondcurtis onlineanalyticalprocessingolapafastandeffectivedataminingtoolforgeneexpressiondatabases
AT matthewsbenjaminf onlineanalyticalprocessingolapafastandeffectivedataminingtoolforgeneexpressiondatabases