DOI QR코드

DOI QR Code

Design of Flexible DSS Architecture for OTC Derivatives Trading: 'A' Bank Case

장외파생상품거래를 위한 유연한 의사결정지원시스템 아키텍처 설계에 관한 연구: A은행 사례

  • 이근우 (우리은행 트레이딩부) ;
  • 양근우 (계명대학교 사회과학대학 전자무역학과)
  • Received : 2011.01.24
  • Accepted : 2011.03.11
  • Published : 2011.03.31

Abstract

Model-based decision support system (DSS) has acted as a crucial role in strengthening the business competitiveness by providing a way of modeling and solving real-world decision problems in a quantitative and scientific manner. It is even more important for trading OTC derivatives, which requires extensive financial-engineering expertise while actively reacting to the continuously changing financial market. This paper proposes a flexible model-based DSS architecture that can support user-friendly interface for executing and analyzing the models and can adapt to the changes of financial market seamlessly. For user-friendliness, we implement the user-interfaces (UIs) using Microsoft Excel, a very widely used spreadsheet program for its great generality and extensibility. Users can utilize the analysis results of DSS or reprocess them for their special needs through the UIs in the form of familiar spreadsheets easily. For adaptiveness to the markets, the proposed architecture is constructed based on the object-oriented concepts, which enables such changes as release of a new financial product can be updated into the system without any delay at the lowest cost. We investigate the practical benefits and limitations of the proposed architecture by a case study on the construction of Model-based Trading Support System (MTSS), performed by a commercial bank in Korea.

Keywords

References

  1. 김준석, 김우상, "금융기관의 차세대시스템이 금융상품 개발 및 비즈니스 프로세스 단순화에 미친 효과: 기업은행 사례를 중심으로," Information Systems Review, Vol. 10, No. 2, 2008. 8, pp. 159-177.
  2. 박정희, 이기동, "A Framework of the Web-Based Knowledge Management Agent for Financial Decision Support System," 정보시스템연구, 제15권, 제3호, 2006. 9, pp. 175-186.
  3. 신정범, 김재균, 장길상, " SOA 및 BPM 기반의 정보시스템 구축 방법론: 고객지향 수주생산 환경에서의 제품 BOM 관리 적용 사례," 정보시스템연구, 제18권, 제1호, 2009. 3, pp. 77-95.
  4. 최형림, 김현수, 홍순구, 박영재, 최성욱, 조민제, 박창현, 강시협, 안병선, "RTE 환경에서의 SOA 기반 협업적 분산 에이전트 개발," 정보시스템연구, 제19권, 제1호, 2010. 3, pp. 79-96. https://doi.org/10.5859/KAIS.2010.19.1.079
  5. Applegate, L.M., Konsynski, B.R., and Nunamaker, J.F., "Model Management Systems: Design for Decision Support," Decision Support Systems, Vol. 2, 1986, pp. 81-91. https://doi.org/10.1016/0167-9236(86)90124-7
  6. Blanning, R., "A Relational Framework for Join Implementation in Model Management," Decision Support Systems, Vol. 1, 1985, pp. 69-82. https://doi.org/10.1016/0167-9236(85)90198-8
  7. Booch, G., Rumbaugh, J., and Jacobson, I., The Unified Modeling Language User Guide, Addison-Wesley, Massachusetts, 1999.
  8. Box, D., Essential COM, Addison-Wesley, Massachusetts, 1998.
  9. Desai, S., "Are EXDBs better than RDBMSs for Model Management," Working Paper, Anderson Graduate School of Management, University of California, Los Angeles, 1991.
  10. Geoffrion, A.M., "An Introduction to Structured Modeling," Management Science, Vol. 33, 1987, pp. 547-588. https://doi.org/10.1287/mnsc.33.5.547
  11. Gold, N., Mohan, A., Knight, C., and Munro, M., "Understanding Service-Oriented Software," IEEE Software, March/April 2004, pp. 71-77. https://doi.org/10.1109/MS.2004.1270766
  12. Gorry, A. and Scott-Morton, M.S., "A framework for information systems," Sloan Management Review, Vol. 13, No. 1, Fall 1971, pp. 56-79.
  13. Hull, J.C., Options, Futures, and Other Derivatives, Prentice Hall, New Jersey, 1997.
  14. Joshi, M., C++ Design Patterns and Derivatives Pricing, Cambridge University Press, 2004.
  15. Lee, K. and Huh, S., "A Model-Solver Integration Framework for Autonomous and Intelligent Model Solution," Decision Support Systems, Vol. 42, 2006, pp. 926-944. https://doi.org/10.1016/j.dss.2005.08.003
  16. LeBlack, L.J., Randels, D.Jr., and Swann, T.K., "Herry International's Spreadsheet Optimization Model for Assigning Managers to Construction Projects," Interfaces, Vol. 30, 2000, pp. 95-106.
  17. Lenard, M., "Representing Models as Data," Journal of Management Information Systems, Vol. 2, 1986, pp. 36-48. https://doi.org/10.1080/07421222.1986.11517745
  18. Little, J.D.C., "Models and managers: The concept of a decision calculus," Management Science, Vol. 16, No. 8, April 1970, pp. 466-485. https://doi.org/10.1287/mnsc.16.8.B466
  19. Ma, J., "An Object-Oriented Framework for Model Management," Decision Support Systems, Vol. 13, 1995, pp. 133-139. https://doi.org/10.1016/0167-9236(93)E0036-D
  20. Ma, J., "Type and Inheritance Theory for Model Management," Decision Support Systems, Vol. 19, 1997, pp.53-60. https://doi.org/10.1016/S0167-9236(96)00052-8
  21. Muhanna, W.A and Pick, R., "Composite Models in SYMMS," Proceedings of the 21st Hawaii International Conference on System Science, 1988, pp. 418-427.
  22. Power, D.J., "Supporting decision-makers: An expanded framework," 2001 Informing Science Conference e-book proceedings, Krakow, Poland, June 19-22, 2001, pp. 431-436.
  23. Power, D.J., A brief history of spreadsheets, DSSResources.COM, World Wide Web, http://dssresources.com/history/sshistory.html, version 3.6, August 2004.
  24. Power, D.J. and Sharda, R., "Model-driven decision support systems: Concepts and research directions," Decision Support Systems, Vol. 43, 2007, pp. 1044-1061. https://doi.org/10.1016/j.dss.2005.05.030
  25. Raden, N., Shedding light on shadow IT: Is Excel running your business?, DSSResources.COM, 26 Feb. 2005.
  26. Shim, J.P., Warkentin, M., Courtney, J.F., Power, D.J., Sharda, R., and Carlsson, C., "Past, Present, and Future of Decision Support Technology," Decision Support Systems Vol. 33, 2002, pp. 111-126. https://doi.org/10.1016/S0167-9236(01)00139-7
  27. Sprague, R. and Carlson, E., Building Effective Decision Support Systems, Prentice Hall, 1982.
  28. Stankovic, J.A., Son, S.H., and Hansson, J., "Misconceptions about Real-Time Databases," IEEE Computer, June 1999, pp. 29-36. https://doi.org/10.1109/2.769440
  29. Turban, E., Decision Support and Expert Systems, Prentice Hall, 1995.
  30. Zeleznikow, J. and Nolan, J.R., "Using Soft Computing to Build Real World Intelligent Decision Support Systems in Uncertain Domains," Decision Support Systems, Vol. 31, 2001, pp. 263-285. https://doi.org/10.1016/S0167-9236(00)00135-4
  31. Calypso, Cross-Asset Front-to-Back, http://www.calypso.com/solutions/cross-asset-front-to-back.php, 2010.
  32. FinCad, Excel Solutions, http://www.fincad.com/derivatives-solutions/analytics/default.aspx, 2010.
  33. MathWorks, MATLAB - The Language for Technical Computing, http://www.mathworks. com/products/matlab/, 2010.
  34. Misys, Summit, http://www.misys.com/tcm/markets/otc_derivative_trading_solutions-summit.html, 2008,
  35. Murex, MX III, http://www.murex.com/mxIII.php, 2009
  36. Numerix, World-Class Solutions for Today's Challenges, http://www.numerix.com/products-and-services, 2010.
  37. QuantLib, A Free/Open-Source Library for Quantitative Finance, http://quantlib.org/, 2010.
  38. Thomson Reuters, Kondor Trade Processing, http://thomsonreuters.com/content/financial/pdf/enterprise/KondorTradeProcessing.pdf, 2010.
  39. Wikipedia, Proprietary Software, http://en.wikipedia.org/wiki/Closed_source_software, 16 Nov. 2010a.
  40. Wikipedia, Visual Basic for Applications, http://en.wikipedia.org/wiki/Visual_Basic_for_Applications, 3 Nov. 2010b.
  41. Wikipedia, Procedural Programming, http://en.wikipedia.org/wiki/Procedural_programming, 8 Nov. 2010c.
  42. Wikipedia, Sensitivity Analysis, http://en.wikipedia.org/wiki/What-if_analysis, 14 Jan. 2011a.
  43. Wikipedia, Multithreading (Computer Architecture), http://en.wikipedia.org/wiki/Multithreading_(computer_architecture), 4 Jan. 2011b.