Mobile database agents for building data warehouses

Autoren Edgar Weippl
Josef Altmann
Wolfgang Essmayr
TitelMobile database agents for building data warehouses
BuchtitelProc. 11th Int. Conf. on Database and Expert Systems Applications (DEXA 2000)
Typin Konferenzband
OrtGreenwich, London

Agent technology has a number of characteristics that make it well suited for automating information processing tasks and information retrieval. In this paper, we propose a pragmatic approach for applying mobile agent technology within distributed database management systems (DBMSs). The developed agent environment is based on the Oracle DBMS. It differs from other agent platforms (e.g. Aglets, Voyager) in its support of error recovery, transactions, efficient data processing, and security mechanisms. Building mobile database agents upon these services, the run-time environment is faster, more secure and much easier to handle. We first outline the application domain of a worldwide production environment and present the main principles of data warehouses that support the supervision and control of various tool machines located at different places. To illustrate the applicability of our approach, we describe the basic concepts of our experimental agent-based system for the Oracle DBMS processing large volumes of production data in Oracle databases connected via TCP/IP networks. We conclude with a discussion of the deficiencies of our system for mobile database agents that we have identified so far and outline further work.