Abstract
Governmental and environmental agencies have recognized that data Warehouses (DWs) oriented to the environmental domain can have a deep impact on the ability to preserve the environment. However, extracting environmental data from external sources in order to load them into the data organization area of a DW is much more complex when compared with conventional DWs. In environmental DWs, extraction is frequently based on autonomous, heterogeneous external sources distributed over the Web. In order to improve this process, we propose an architecture that combines a middleware system and DW technology. The use of this architecture has been achieved through the implementation of a tool called LSExtract, which has been built on top of a middleware system called Le Select. Its goal is to locate and extract relevant and accurate information from heterogeneous data sources over the Web, extract data published by Le Select, and load it, after some transformations, into the data organization area of an environmental DW.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Gunther, O. Environmental Information Systems. Springer-Verlag Berlin Heidelberg, 1998.
Sheth, A. Changing Focus on Interoperability in Information Systems: From System, Syntax, Structure to Semantics. In: Interoperating Geographic Information Systems. M. Goodchild, M. Egenhofer, R. Fegeas, and C. Kottman (eds.), Kluwer, 1998.
Tanaka A., Valduriez P. and the Ecobase Project members. The Ecobase Project: Database and Web Technologies for Environmental Information Systems. ACM SIGMOD Record 30(3), 2001.
Domenig, R and Dittrich, K. An Overview and Classification of Mediated Query Systems. ACM SIGMOD Record 28(3), 1999.
Kimball, R., Reeves, L., Ross, M., and Thornthwaite, W. The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses. John Wiley & Sons, 1998.
Molina, G., Papakonstantinou, Y, and Quass, D. The TSIMMIS Approach to Mediation: Data Model and Languages. Journal of Intelligent Information Systems, 1997.
Tomasic, A., Raschid, L., and Valduriez, P. Scaling Acces to Heterogenous Data Source with Disco. IEEE Transaction on Knowlegde and Data Engineering 10(5), 1998.
Konig-Ries, B. and Reck, C. An Architecture for Transparent Access to Semantically Heterogeneous Information Sources. 1 st International Workshop on Cooperative Information Agents, Berlin, 1997.
Dittrich, K. and Domenig, R. Towards Exploitation of the Data Universe. 3 rd International Conference on Business Information System, 1999.
Carey, M., Haas, L., Schwarz, P., Arya, M., Cody, W., Fagin, R., Flickner, M., Luniewski, A., Niblack, W., Petkovic, D., Thomas, J., Williams, J., and Wimmers, E. Towards Heterogeneous Multimedia Information Systems: The Garlic Approach. 5th International Workshop on Research Issues in Data Engineering-Distributed Object Management (RIDE-DOM’95), May 1995.
Amzal, M., Manolescu, I., Simon, E., Xhumari, F., and Lavric, A. Sharing Autonomous and Heterogeneous Data Sets and Programs with Le Select, http://caravel.inria.fr/Fpro totype_LeSelect.html.
Martinez, M. and Roussopoulos, N. MOCHA: A Self-Extensible Database Middleware System for Distributed Management Data. ACM SIGMOD International Conference on Management Data, Dallas, Texas, USA, 2000.
Wiederhold, G. Mediation to Deal with Heterogeneous Data Sources. In: A. Vckovski, K. Brassel, and H.-J. Schek (eds.) INTEROP’99. Zurich, 1999.
Inmon, W. Building the Data Warehouse. John Wiley & Sons, 2nd Edition, 1996.
United States Environmental Protection Agency. available at http://www.epa.gov [last access Dec. 2000].
Barcay, T., Gray, J., and Slutz, D. Microsoft TerraServer: A Spatial Data Warehouse. ACM SIGMOD, 2000.
Sheth, A., Kashyap, V., and Lima, T. Semantic Information Brokering: How Can a Multi-agent Approach Help? 3 rd International Workshop on Cooperative Information Agents, July 1999.
Resource Description Framework Model and Syntax, (http://www.w3.org/RDF)
Victorino, M. Use of Mediation Technology to Extract Data and Metadata on the Webfor Environmental Decision Support Systems (in Portuguese). MS Thesis, Department of Computer Engineering, IME, Rio de Janeiro, Brazil, 2001.
FGDC, Federal Geographic Data Committee. Available at http://www.fgdc.gov/metadata/metadata.html, [last access Jun 2001].
Moura, A., Campos, M., and Barreto, C. A Survey on Metadata for Describing and Retrieving Internet Resources. World Wide Web (WWW) Journal, 1(4): 221–240, 1999.
Empresa Brasileira de Pesquisa Agropecuária (EMBRAPA SOLOS). Rio de Janeiro, Brazil. Available at http://www.embrapa.br/ [last access Oct. 2000].
Instituto Agronomico de Campinas (IAC). São Paulo, Brazil. Available at http://nimnt.barao.iac.br/homeiac/ [last access Oct. 2000].
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
de Moura, A.M.C., Victorino, M., Tanaka, A. (2002). Combining Mediator and Data Warehouse Technologies for Developing Environmental Decision Support Systems. In: Egenhofer, M.J., Mark, D.M. (eds) Geographic Information Science. GIScience 2002. Lecture Notes in Computer Science, vol 2478. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45799-2_14
Download citation
DOI: https://doi.org/10.1007/3-540-45799-2_14
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-44253-0
Online ISBN: 978-3-540-45799-2
eBook Packages: Springer Book Archive