Managing Temporal Financial Data in an Extensible Database

摘要

Complex financial products and trading applications are difficult to model and implement in conventional commercial databases due to temporal, object, rule and other data support requirements. Extensible database systems provide a better solution because of the ability to define complex data types, manipulate data of type procedure, define rules, operators and access methods to optimize these operators. The paper discusses the design issues in modeling financial trading systems in extensible DBMS. The complexity of financial products is analyzed and strategies for modeling these products are proposed. Operators relevant to financial trading are discussed alongwith access methods to optimize these operators. The paper describes an implementation of a financial trading system in POSTGRES.