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...
Autores principales: | , , |
---|---|
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 |