Skip to main content

A Data Warehouse Based Schema Design on Decision-Making in Loan Disbursement for Indian Advance Sector

  • Conference paper
  • First Online:
Emerging Technologies in Data Mining and Information Security

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 813))

Abstract

Disbursement of loan is an important decision-making process for the corporate like banks and NBFC (Non-banking Finance Corporation) those offers loans. The business involves several parameters and the data which are associated to these parameters are generated from heterogeneous data sources and also belong to different business verticals. Henceforth the decision-making on loan scenarios are critical and the outcome involve solving the issues like whether to grant the loan or not, if sanctioned what is highest amount, etc. In this paper we consider the traditional parameters of loan sanction process along with these we identify one special case of Indian credit lending scenario where the people having old loans with good repayment history get priority. This limits the business opportunities for Bank/NBFC or other loan disbursement organizations as potential good customers having no loan history are treated with less priority. In this research work we propose a data warehouse model which integrates the existing parameters of loan disbursement related decisions and also incorporates the newly identified concepts to give the priorities to the customers who don’t have any old credit history.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 259.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 329.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Indian Institute of Banking & Finance: Principles and Practices of Banking, 3rd edn., pp. 267–274 (2015)

    Google Scholar 

  2. Throve, H.A.: Analytical study of priority and non-priority sector lending with reference to Nationalized Banks in India. Paridnya—The MIBM Res. J. 3(1) (2015)

    Google Scholar 

  3. Dave, K.S.: A study of priority sector lending for selected public sector banks of India. IJRAR-Int. J. Res. Anal. Rev. 3(3) (2016)

    Google Scholar 

  4. Bhiwandikar, M.: Role of CGTMSE and CIBIL in supporting the Indian Economy. ISSN-2347-7571, Volume 1, Issue 6, June 2014

    Google Scholar 

  5. Uppal, R.K.: Priority sector advances: trends, issues and strategies. J. Account. Tax. 1(5), 079–089 (2009)

    Google Scholar 

  6. Maji, G., Sen, S.: A data warehouse based analysis on CDR to depict market share of different mobile brands. IEEE Indicon (2015). https://doi.org/10.1109/INDICON.2015.7443706

    Article  Google Scholar 

  7. Peyravi, M.H.: A schema selection framework for data warehouse design. Int. J. Mach. Learn. Comput. 2(3) (2012)

    Google Scholar 

  8. Sen, S., Chaki, N., Cortesi, A.: Optimal space and time complexity analysis on the lattice of cuboids using galois connections for data warehousing. In: 4th International Conference on Computer Sciences and Convergence Information Technology (ICCIT 2009). https://doi.org/10.1109/iccit.2009.185

  9. Sen, S., Roy, S., Sarkar, A., Chaki, N., Debnath, N.C.: Dynamic discovery of query path on the lattice of cuboids using hierarchical data granularity and storage hierarchy. Elsevier J. Comput. Sci. 5(4), 675–683 (2014)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Soumya Sen .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Das, I., Roy, S., Chatterjee, A., Sen, S. (2019). A Data Warehouse Based Schema Design on Decision-Making in Loan Disbursement for Indian Advance Sector. In: Abraham, A., Dutta, P., Mandal, J., Bhattacharya, A., Dutta, S. (eds) Emerging Technologies in Data Mining and Information Security. Advances in Intelligent Systems and Computing, vol 813. Springer, Singapore. https://doi.org/10.1007/978-981-13-1498-8_53

Download citation

Publish with us

Policies and ethics