A Data Warehouse Based Modelling Technique for Stock Market Analysis

  • Abstract
  • Keywords
  • References
  • PDF
  • Abstract

    The objective of this paper is identifying a warehouse model to build an analytical framework and analyze different important parameters which directly impact the changes of share market. We identify parameters that represent different viewing windows and perspectives towards stock market performance and movement trends. We categorize and define many intrinsic as well as external factors that may affect stock market as a whole. Sensex and Nifty are used as the pulse of Indian stock market. In this paper, we focus on defining a suitable OLAP model which can cater all the parameters that affect share market. We also identify different applications of this analytical model for forecasting information to help decision making.



  • Keywords

    Analytical Processing; Data Warehouse; Lattice of cuboids; Prediction and forecasting; Stock Markets

  • References

      [1] Codd, E.F., Codd, S.B., & Salley, C.T. (1993), “Providing OLAP to User-Analysts: An IT Mandate”, Codd and Date, Inc., 1993.

      [2] BSE India, http://www. bseindia.com accessed on May 29, 2016.

      [3] Inmon, W. H. “Building the data warehouse”. John wiley & sons. 2005

      [4] Sen, S., Roy, S., Sarkar, A., Chaki, N., and Debnath, N. C., (July, 2014) “Dynamic Discovery of Query Path on the Lattice of Cuboids using Hierarchical Data Granularity and Storage Hierarchy". Elsevier Journal of Computational Science 5(4): 675-683.

      [5] Sen, S., Chaki, N., and Cortessi, A. “Optimal space and time complexity analysis on the lattice of cuboids using Galois connections for data warehousing”, IEEE Proceedings of the International Conference on Computer Sciences and Convergence Information Technology (ICCIT 09), Seoul, Korea, 2009.

      [6] Sen, S. and Chaki, N. “Efficient traversal in data warehouse based on concept hierarchy using Galois connections”, IEEE Proceedings of the Second International Conference on Emerging Applications of Information Technology (EAIT 2011), Kolkata, India, February 19–20, 2011, http://dx.doi.org/10.1109/EAIT.2011.69,ISBN: 978-0-7695-4329-1.

      [7] Rusu, V., and Rusu, C., “Forecasting methods and stock market analysis”. Creative Math, 12(2003) pp. 103-110.

      [8] Wang, D., Cao, L., Gao, X., and Li, T. “Data mining in oil price time series analysis”. Communications of the IIMA, 6(3), 12. 2015

      [9] Han, J. “OLAP mining: An integration of OLAP with data mining”. In Proceedings of the 7th IFIP (Vol. 2, pp. 1-9). 1993

      [10] Pérez, J. M., Berlanga, R., Aramburu, M. J., and Pedersen, T. B. “R-cubes: OLAP cubes contextualized with documents.” 2007 IEEE 23rd International Conference on Data Engineering (ICDE 2007) (pp. 1477-1478). IEEE.

      [11] Liao, S. H. and Chou, S. Y. “Data mining investigation of co-movements on the Taiwan and China stock markets for future investment portfolio.” Expert Systems with Applications 40.5 (2013): 1542-1554

      [12] Atsalakis, G. S., and Valavanis, K. P. “Surveying stock market forecasting techniques–Part II: Soft computing methods”. Expert Systems with Applications 36.3 (2009) :5932-5941.

      [13] Basher, S.A. and P. Sadorsky. “Oil price risk and emerging stock markets.” Global Finance Journal 17 (2006): 224–251.

      [14] Mukhuti, S. and Bhunia, A. “Is it true that Indian gold price influenced by Indian stock market reaction?” E3 Journal of Business Management and Economics Vol. 4.8 (2013): 181-186

      [15] Maji, G., Sen, S, & Sarkar, A. “Share market sectorial Indices movement forecast with lagged correlation and association rule mining”, In IFIP International Conference on Computer Information Systems and Industrial Management (pp. 327-340). Springer.

      [16] Mandal, S. and Maji, G. “Integrating Telecom CDR and Customer Data from Different Operational databases and Data warehouses into a Central Data Warehouse for Business Analysis”, International Journal of Engineering Research & Technology (IJERT) Vol. 5.2 (2016): 516-523




Article ID: 16344
DOI: 10.14419/ijet.v7i3.13.16344

Copyright © 2012-2015 Science Publishing Corporation Inc. All rights reserved.