A multidatabase solution for a financial application

Munir Cochinwala, John Bradley, Ram Tanamy, Raghu Subramanian

Research output: Chapter in Book/Report/Conference proceedingConference contribution

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.

Original languageEnglish (US)
Title of host publicationApplications of Databases - 1st International Conference, ADB-1994, Proceedings
EditorsTore Risch, Witold Litwin
PublisherSpringer Verlag
Pages204-214
Number of pages11
ISBN (Print)9783540581833
StatePublished - Jan 1 1994
Externally publishedYes
Event1st International Conference on Applications of Databases, ADB-1994 - Vadstena, Sweden
Duration: Jun 21 1994Jun 23 1994

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume819 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Other

Other1st International Conference on Applications of Databases, ADB-1994
Country/TerritorySweden
CityVadstena
Period6/21/946/23/94

All Science Journal Classification (ASJC) codes

  • Theoretical Computer Science
  • Computer Science(all)

Fingerprint

Dive into the research topics of 'A multidatabase solution for a financial application'. Together they form a unique fingerprint.

Cite this