A Multidatabase System for Tracking and Retrieval of Financial Data

We have built a multidatabase system to support a financial application that stores historical data used by traders to identify trends in the market. The application has an update rate (append-only) of 500 inserts per second and also has sub-second response requirements for queries. A typical query requests between 100-1000 records. In this paper we define the characteristics of the application, the multidatabase system we used to support the applications and the extensions we made in t.he application to achieve the required functionality and performance.

[1]  Jean-François Pons,et al.  Mixed concurrency control: Dealing with heterogeneity in distributed database systems , 1988, VLDB.

[2]  Munir Cochinwala,et al.  A distributed transaction monitor , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.

[3]  Calton Pu,et al.  Superdatabases for composition of heterogeneous databases , 1988, Proceedings. Fourth International Conference on Data Engineering.

[4]  Sharma Chakravarthy,et al.  Situation Monitoring for Active Databases , 1989, VLDB.

[5]  Ahmed K. Elmagarmid,et al.  A Multidatabase Transaction Model for InterBase , 1990, VLDB.

[6]  John Bradley,et al.  A Multidatabase Solution for a Financial Application , 1994, ADB.

[7]  Tore Risch,et al.  Monitoring Database Objects , 1989, VLDB.

[8]  Michael Stonebraker,et al.  On rules, procedure, caching and views in data base systems , 1990, SIGMOD '90.

[9]  Michael Stonebraker,et al.  On rules, procedures, caching and views in database systems , 1994, SIGMOD 1994.

[10]  Panos K. Chrysanthis,et al.  A Formalism for Extended Transaction Model , 1991, VLDB.

[11]  Umeshwar Dayal,et al.  Organizing long-running activities with triggers and transactions , 1990, SIGMOD '90.

[12]  Sunil K. Sarin,et al.  Data sharing in group work , 1986, TOIS.