A data warehouse approach to semantic integration of pseudomonas data
Authors: 
Kamar Marrakchi, Abdelaali Briache, Amine Kerzazi, Ismael Navas-Delgado, José Francisco Aldana-Montes, Mohamed Ettayebi, Khalid Lairini, Badr Din Rossi HassaniAuthors Info & Claims
Kamar Marrakchi, Abdelaali Briache, Amine Kerzazi, Ismael Navas-Delgado, José Francisco Aldana-Montes, Mohamed Ettayebi, Khalid Lairini, Badr Din Rossi HassaniAuthors Info & ClaimsPages 90 - 105
Abstract
Biological research and development are routinely producing terabytes of data that need to be organized, queried and reduced to useful scientific knowledge. Even though data integration can provide solutions to such biological problems, it is often problematic due to the sources' heterogeneity and their semantic and structural diversity. Moreover, necessary updates of both structure and content of databases provide further challenges for an integration process. We present a new biological data warehouse for Pseudomonas species "PseudomonasDW" to integrate annotation and pathway data from highly different resources. The combination of knowledge from multiple disciplines and sources should advance the understanding of cellular processes and lead to the prediction of cellular behavior in its entirety. The key aspect of our approach is the combination of a materialized and a virtual data integration to exploit their advantages in a new hybrid approach. The data are extracted from the original data sources using SB-KOM (System Biology Khaos Ontology-based Mediator) and then stored locally in the data warehouse to ensure a fast performance and data consistency.
References
[1]
Buttler, D., Coleman, M., Critchlow, T., Fileto, R., Han, W., Pu, C., Rocco, D., Xiong, L.: Querying multiple bioinformatics information sources: can Semantic web research help. ACM SIGMOD 31, 59-64 (2002).
[2]
The gene Ontology Consortium: The Gene Ontology (GO) database and informatics resource. Nucleic Acids Research 32, 258-261 (2004).
[3]
Florescu, D., Levy, A.Y., Mendelzon, A.O.: Database Techniques for the World-Wide Web: A Survey. ACM SIGMOD 27, 59-74 (1998).
[4]
Lenzerini, M.: Data Integration: A Theoretical Perspective. In: ACM Symposium on Principles of Database Systems (2002).
[5]
Sujansky, W.: Heterogeneous Database Integration in Biomedecine. Methodological Review. Journal of Biomedical Informatics 34, 285-298 (2001).
[6]
Allaire, M.: Diversité fonctionnelle des Pseudomonas producteurs d'antibiotiques dans les rhizosphères de conifères en pépinières et en milieu naturel. PhD Thesis, Faculty of Agriculture and Food University Laval Québec (2005).
[7]
Kohler, J., Baumbach, J., Taubert, J., Specht, M., Skusa, A., Rueegg, A., Rawlings, C., Verier, P., Philippi, S.: Graph-based analysis and visualization of experimental results with Ondex. Bioinformatics 22, 1383-1390 (2006).
[8]
Shah, S.P., Huang, Y., Xu, T., Yuen, M.M.S., Ling, J., Ouellette, B.F.F.: Atlas-a data warehouse for integrative bioinformatics. BMC Bioinformatics 6 (2005).
[9]
Lee, T.J., Pouliot, Y., Wagner, V., Gupta, P., Stringer-Calvert, D.W.J., Tenenbaum, J.D.: BioWarehouse: a bioinformatics database warehouse toolkit. BMC Bioinformatics 7 (2006).
[10]
Töpel, T., Hofestädt, R., Scheible, D., Trefz, F.: RAMEDIS: the rare metabolic diseases database. Applied Bioinformatics 5, 115-118 (2006).
[11]
Choi, C.C., Munch, R., Leupold, S., Klein, J., Siegel, I., Thielen, B., Benkert, B., Kucklick, M., Schobert, M., Barthelmes, J., Ebeling, C., Haddad, I., Scheer, M., Grote, A., Hiller, K., Bunk, B., Schreiber, K., Retter, I., Schomburg, D., Jahn, D.: SYSTOMONASan integrated database for systems biology analysis of Pseudomonas. Nucleic Acids Research 35, 537-537 (2007).
[12]
Trißl, S., Rother, K., Rother, Muller, H., Steinke, T., Koch, I., Preissner, R., Frommel, C., Leser, U.: Columba: an integrated database of proteins, structures, and annotations. BMC Bioinformatics 6 (2005).
[13]
Calvanese, D., Giacomo, G.D., Lenzerini, M., Naradi, D., Rosati, R.: Source integration in data warehousing. In: DEXA Workshop, pp. 192-197 (1998).
[14]
Kanehisa, M., Goto, S., Hattori, M., Aoki-Kinoshita, K.F., Itoh, M., Kawashima, S., Katayama, T., Araki, M., Hirakawa, M.: From genomics to chemical genomics: new developments in KEGG. Nucleic Acids Research 34, 354-357 (2006).
[15]
Chang, A., Scheer, M., Grote, A., Schomburg, I., Schomburg, D.: BRENDA, AMENDA and FRENDA the enzyme information system: new content and tools in 2009. Nucleic Acids Research 37, 588-592 (2009).
[16]
The UniProt Consortium: The Universal Protein Resource (UniProt) in 2010. Nucleic Acids Research 38, 142-148 (2010).
[17]
Benson, D.A., Karsch-Mizrachi, L., Lipman, D.J., Ostell, J., Sayers, E.W.: GenBank. Nucleic Acids Research 38, 46-51 (2010).
[18]
Munch, R., Hiller, K., Barg, H., Heldt, D., Linz, S., Wingender, E., Jahn, D.: PRODORIC: prokaryotic database of gene regulation. Nucleic Acids Research 31, 266-269 (2003).
[19]
Navas-Delgado, I., Aldana-Montes, J.F.: Extending SD-Core for Ontology-based Data Integration. Journal of Universal Computer Science 15, 3201-3230 (2009).
[20]
Navas-Delgado, I., Roldan Garcia, M.M., Mazorra, D.D., Aldana-Montes, J.F.: Developing Data Services. In: The 17th Conference on Advanced Information System Engineering. Data Integration and the Semantic Web, DISWeb 2005, vol. 4, pp. 287-301 (2005).
[21]
Chniber, O., Kerzazi, A., Navas-Delgado, I., Aldana-Montes, J.F.: KOMF: The Khoas Ontology-based Mediator Framework NETTAB 2008: Bioinformatics Methods for Biomedical Complex System Applications (2008).
[22]
Navas-Delgado, I., Kerzazi, A., Chniber, O., Aldana-Montes, J.F.: A Semantic Middleware Applied to Molecular Biology. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM-WS 2008. LNCS, vol. 5333, pp. 976-985. Springer, Heidelberg (2008).
[23]
Navas-Delgado, I., Aldana-Montes, J.F.: SD-Core: Generic Semantic Middleware Components for the Semantic Web. In: Lovrek, I., Howlett, R.J., Jain, L.C. (eds.) KES 2008, Part II. LNCS (LNAI), vol. 5178, pp. 617-622. Springer, Heidelberg (2008).
[24]
Hillebrand, G.G., Kanellakis, P.C., Mairson, H.G., Vardi, M.Y.: Undecidable Boundedness Problems for Datalog Programs. J. of Logic Programming 25, 163-190 (1995).
[25]
Jorg, T., Dessloch, S.: Towards generating ETL processes for increlental loading. In: Proc. Intl. Symposium on Database Engineering and Applications, vol. 299, pp. 101-110 (2008).
[26]
Neerincx, P.B.T., Leunissen, J.: Evolution of web services in bioinformatics. Brief. Bioinform. 6, 178-188 (2005).
[27]
Marrakchi, K., Briache, A., Kerzazi, A., Navas-Delgado, I., Aldana-Montes, J.F., Ettayebi, M., Lairini, K., Rossi Hassani, B.D.: PseudomonasDW Ontology: an ontology for Pseudomonas species. Technical report (ITI.10-2), Department of Computer Languages and Computing Science, Higher Technical School of Computer Science Engineering University of Málaga (2010).
Index Terms
- A data warehouse approach to semantic integration of pseudomonas data
Index terms have been assigned to the content through auto-classification.
Recommendations
Alliance Rules for Data Warehouse Cleansing
ICSPS '09: Proceedings of the 2009 International Conference on Signal Processing SystemsData Cleansing is an activity performed on the data sets of data warehouse to enhance and maintain the quality and consistency of the data. This paper addresses the problems related with dirty data, entrance of dirty data and detection of dirty data in ...
Fuzzy integration of web data sources for data warehousing
EUROCAST'07: Proceedings of the 11th international conference on Computer aided systems theoryIn this paper we show our work related to an approach for monitoring web sources on the World Wide Web using its temporal properties in order to integrate them in a temporal Data Warehouse. We use these temporal properties obtained for integrating data ...
Semantic integration of heterogeneous classical data sources in ontological data warehouse
LOPAL '18: Proceedings of the International Conference on Learning and Optimization Algorithms: Theory and ApplicationsThe development of semantic web technologies and the expansion of the amount of data managed within companies databases lead to an enormous quantity of heterogeneous, distributed and autonomous data sources. However, this growth of information will give ...
Comments
Information & Contributors
Information
Published In
Publisher
Springer-Verlag
Berlin, Heidelberg
Publication History
Published: 25 August 2010
Author Tags
Qualifiers
- Article
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 0Total Downloads
- Downloads (Last 12 months)0
- Downloads (Last 6 weeks)0
Reflects downloads up to 27 Jul 2024
Other Metrics
Citations
View Options
View options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in