A Data Warehouse Based Modelling Technique for Stock Market Analysis

  • Authors

    • Debomita Mondal
    • Giridhar Maji
    • Takaaki Goto
    • Narayan C. Debnath
    • Soumya Sen
    2018-07-27
    https://doi.org/10.14419/ijet.v7i3.13.17325
  • Analytical Processing, Data Warehouse, Lattice of cuboids, Prediction and forecasting, Stock Markets

  • 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.

     

     

  • References

    1. [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

  • Downloads

  • How to Cite

    Mondal, D., Maji, G., Goto, T., C. Debnath, N., & Sen, S. (2018). A Data Warehouse Based Modelling Technique for Stock Market Analysis. International Journal of Engineering & Technology, 7(3.13), 165-170. https://doi.org/10.14419/ijet.v7i3.13.17325

    Received date: 2018-08-10

    Accepted date: 2018-08-10

    Published date: 2018-07-27