A real time data extraction, transformation and loading solution for semi-structured text files

Authors:
Nuno Viana;Ricardo Raminhos;João Moura-Pires
Affiliations:
UNINOVA, Caparica, Portugal;UNINOVA, Caparica, Portugal;CENTRIA/FCT, Caparica, Portugal
Venue:
EPIA'05 Proceedings of the 12th Portuguese conference on Progress in Artificial Intelligence
Year:
2005

Citing 3
Cited 1

NoDoSE—a tool for semi-automatically extracting structured and semistructured data from text documents

SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
A generic and customizable framework for the design of ETL scenarios

Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)

Configuring Systems of Massively Distributed, Autonomous and Interdependent Decision Makers

International Journal of Decision Support System Technology

Quantified Score

Hi-index	0.00

Visualization

Abstract

Space applications’ users have been relying for the past decades on custom developed software tools capable of addressing short term necessities during critical Spacecraft control periods. Advances in computing power and storage solutions have made possible the development of innovative decision support systems. These systems are capable of providing high quality integrated data to both near real time and historical data analysis applications. This paper describes the implementation of a new approach for a distributed and loosely coupled data extraction and transformation solution capable of extracting, transforming and perform loading of relevant real-time and historical Space Weather and Spacecraft data from semi-structured text files into an integrated space-domain decision support system. The described solution takes advantage of XML and Web Service technologies and is currently working under operational environment at the European Space Agency as part of the Space Environment Information System for Mission Control Purposes (SEIS) project.