Data Distribution with a Market Data Information System

The recent liberalisation of the German energy market forced the energy industry to develop and install new information systems to support agents on the energy trading floors in their analytical tasks. Besides classical approaches of building a data warehouse to give insight into the time series to understand market and pricing mechanisms, it is crucial to provide a variety of external data from the web. Starting from a multidimensional data model and a collection of buy and sell transactions a data warehouse is built that gives analytical support to the agents. Following the idea of web farming we harvest the web, match the external information sources after a filtering and evaluation process to the data warehouse objects and present this qualified information on a user interface where market values are correlated with those external sources over the time axis. Finally the paper presents a concept of re-engineering the database and discusses the theoretical aspects of a distributed database system. A data model is designed and mechanisms for replication, suited for this particular model, are introduced.

[1]  Madhavan K. Nayar.  ACHIEVING INFORMATION INTEGRITY , 1993 .

[2]  W. H. Inmon,et al.  Building the Data Warehouse,3rd Edition , 2002 .

[3]  C. J. Date.  An Introduction to Database Systems , 1975 .

[4]  Jakob Nielsen,et al.  Usability engineering , 1997, The Computer Science and Engineering Handbook.

[5]  Ramez Elmasri,et al.  Fundamentals of Database Systems, 5th Edition , 2006 .

[6]  Michael McGill,et al.  Introduction to Modern Information Retrieval , 1983 .

[7]  Gerard Salton,et al.  Automatic Text Processing: The Transformation, Analysis, and Retrieval of Information by Computer , 1989 .

[8]  Richard D. Hackathorn,et al.  Web Farming for the Data Warehouse , 1998 .

[9]  Nicholas R. Jennings,et al.  Intelligent Agents III. Agent Theories, Architectures, and Languages ECAI'96 Workshop (ATAL), Budapest, Hungary, August 12-13, 1996, Proceedings , 1997 .

[10]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[11]  Charles Dye.  Oracle Distributed Systems , 1999 .

[12]  Amihai Motro,et al.  Superviews: Virtual Integration of Multiple Databases , 1987, IEEE Transactions on Software Engineering.

[13]  Christopher M. Bishop,et al.  Neural networks for pattern recognition , 1995 .

[14]  Tarun Khanna,et al.  Foundations of neural networks , 1990 .

[15]  Thomas C. Redman,et al.  Data Quality: The Field Guide , 2001 .

[16]  Ben Shneiderman,et al.  Visual information seeking: tight coupling of dynamic query filters with starfield displays , 1994, CHI '94.

[17]  Klaus R. Dittrich,et al.  Architektur von Datenbanksystemen , 1987, Datenbankhandbuch.

[18]  Cristiano Castelfranchi,et al.  Proceedings of the 7th International Workshop on Intelligent Agents VII. Agent Theories Architectures and Languages , 2000 .

[19]  Jan Holthuis,et al.  Der Aufbau von Data Warehouse-Systemen , 1998 .

[20]  Jakob Nielsen,et al.  Chapter 4 – The Usability Engineering Lifecycle , 1993 .