AN EXECUTIVE INFORMATION SYSTEM FOR SECURITIES BROKER’S RISK MANAGEMENT WITH DATA WAREHOUSING AND OLAP

Yung-Hsin Wang, Shing-Han Li, Kuo-Lung Sun

2007

Abstract

With the open domestic financial market, the targets of investment and money management are toward diversity. The competition from internationalization makes the stock market no more flourishing as usual. The risk of margin trading becomes important information that securities firms try to analyze and get controlled. According to current regulations and working process, this study constructs an executive information system with the application of data warehouse and online analytical processing (OLAP) to help securities brokers make decisions in the operation of risk management for margin purchase and short sale of securities. The result solves the problem that managers of margin trading usually face when using traditional account systems.

References

  1. Chaudhuri, S., Dayal, U., 1997. An Overview of Data Warehousing and OLAP Technology. SIGMOD Record, 26 (1), 65-74.
  2. Inmon, W.H., 1996. Building the Data Warehouse, John Wiley & Sons. New York.
  3. Spofford, G., 2001. MDX Solutions: With Microsoft SQL Server Analysis Services, Wiley. New York.
  4. TSEC, 2006. Regulations Governing Margin and Stock Loans by Securities Firms. Retrieved from http://eng.selaw.com.tw/ FLAWDAT0202.asp.
  5. Turban, E., Aronson, J.E., 2001. Decision Support Systems and Intelligent Systems, Prentice Hall. NJ, 6th edition.
Download


Paper Citation


in Harvard Style

Wang Y., Li S. and Sun K. (2007). AN EXECUTIVE INFORMATION SYSTEM FOR SECURITIES BROKER’S RISK MANAGEMENT WITH DATA WAREHOUSING AND OLAP . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 508-511. DOI: 10.5220/0002375705080511


in Bibtex Style

@conference{iceis07,
author={Yung-Hsin Wang and Shing-Han Li and Kuo-Lung Sun},
title={AN EXECUTIVE INFORMATION SYSTEM FOR SECURITIES BROKER’S RISK MANAGEMENT WITH DATA WAREHOUSING AND OLAP},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={508-511},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002375705080511},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - AN EXECUTIVE INFORMATION SYSTEM FOR SECURITIES BROKER’S RISK MANAGEMENT WITH DATA WAREHOUSING AND OLAP
SN - 978-972-8865-88-7
AU - Wang Y.
AU - Li S.
AU - Sun K.
PY - 2007
SP - 508
EP - 511
DO - 10.5220/0002375705080511