TY - GEN
T1 - A multidatabase solution for a financial application
AU - Cochinwala, Munir
AU - Bradley, John
AU - Tanamy, Ram
AU - Subramanian, Raghu
N1 - Publisher Copyright:
© Springer-Verlag Berlin Heidelberg 1994.
PY - 1994
Y1 - 1994
N2 - 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 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.
AB - 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 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.
UR - http://www.scopus.com/inward/record.url?scp=85027491839&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=85027491839&partnerID=8YFLogxK
U2 - 10.1007/3-540-58183-9_50
DO - 10.1007/3-540-58183-9_50
M3 - Conference contribution
AN - SCOPUS:85027491839
SN - 9783540581833
T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
SP - 204
EP - 214
BT - Applications of Databases - 1st International Conference, ADB-1994, Proceedings
A2 - Litwin, Witold
A2 - Risch, Tore
PB - Springer Verlag
T2 - 1st International Conference on Applications of Databases, ADB-1994
Y2 - 21 June 1994 through 23 June 1994
ER -