Advertisement

A multidatabase solution for a financial application

  • Munir Cochinwala
  • John Bradley
  • Ram Tanamy
  • Raghu Subramanian
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 819)

Abstract

We have built a multidatabase system to support a financial application that provides access to real-time and historical financial data concerning stocks, bonds, options and mutual funds. The arrival rate of data is 500 items per second, each of which may be saved in a DBMS. Sub-second response time is required for queries.

The consistency and performance of real-time data differs from those of historical data. Real-time data is non-persistent but requires database consistency. Historical data is persistent and requires serializability on 〈instrument, timestamp〉 pair. Since real-time data reflects current market activity, it must be delivered to users faster than historical data. Historical data has sub-second response requirements for queries. A typical query for historical data requests between 100–1000 records.

We could not find a single DBMS or even a multidatabase system that met our performance requirements and consistency definition. In this paper we define the characteristics of the application, the multidatabase system we used to support the applications, and some requirements for DBMS's in financial applications.

Keywords

Mutual Fund Financial Application Transaction Management Global Consistency Persistent Store 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    M. Cochinwala, K.C. Lee, W. Mansfield, Jr., and M. Yu: A Distributed Transaction Monitor. Proc. of RIDE-IMS 1993 April 1993Google Scholar
  2. 2.
    P. P. Chrysanthis and K. Ramamritham: A Formalism for Extended Transaction Models. Proc. of the 17th International Conference on VLDB September 1991Google Scholar
  3. 3.
    U. Dayal, M. Hsu, and R. Ladin: Organizing Long-Running Activities with Triggers and Transactions. Proc. of the ACM SIGMOD 1990.Google Scholar
  4. 4.
    A. K. Elmagarmid, Y. Leu, W. Litwin, and M. Rusinkiewicz: A Multidatabase Transaction Model for InterBase. Proc. of the 16th VLDB 1990Google Scholar
  5. 5.
    MarketFeed The Telerate Consolidated Feed: Technical Specifications August 1993Google Scholar
  6. 6.
    Telerate Ticker Feed Specification: Technical Specifications August 1993Google Scholar
  7. 7.
    I. Greif and S. Sarin: Data Sharing in Group Work. Computer-Supported Cooperative Work ed. Irene Greif Morgan Kaufruan Publishers, 1988Google Scholar
  8. 8.
    J. Pons and J. Vilarem: Mixed Concurrency Control: Dealing with Heterogeneity in Distributed Database Systems. Proc. of the Fourteenth Conference on VLDB Los Angeles 1988Google Scholar
  9. 9.
    Calton Pu: Superdatabases for Composition of Heterogeneous Databases. Proc. of the Fourth International Conference on Data Engineering Los Angeles, 1988Google Scholar
  10. 10.
    Tore Risch: Monitoring Database Objects. Proc. of the Fifteenth Conference on VLDB 1989Google Scholar
  11. 11.
    A. Rosenthal, S. Chakravarthy, B. Blaustein, and J. Blakeley: Situation Monitoring for Active Databases. Proc. of the 14th VLDB 1989Google Scholar
  12. 12.
    Yuri Breibart, Hector Garcia-Molina and Avi Silberschatz: Overview of Multidatabase Transaction Management. Stanford Technical Report No. STAN-CS-92-143 May 1992Google Scholar
  13. 13.
    Michael Heytens, Sheralyn Listgarten, Marie-Anne Neimat and Kevin Wilkinson: Smallbase: A Main-Memory DBMS for High-Performance Applications. Unpublished Draft October 1993.Google Scholar
  14. 14.
    M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos: On Rules, Procedures, Caching and Views in Database Systems. Proc. of the ACM SIGMOD 1990.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Munir Cochinwala
    • 1
  • John Bradley
    • 1
  • Ram Tanamy
    • 1
  • Raghu Subramanian
    • 1
  1. 1.Dow Jones TelerateHarborside Financial CenterJersey City

Personalised recommendations