Design of Customer Information Management System

  • Rohini Narayan
  • Gitanjali MehtaEmail author
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 1049)


The Customer Information Management (CIM) needs to handle, maintain and store the customer data. To facilitate this objective, the need for an application that takes the customer and the item details from the external source files and store the same in the Data Warehouse (DW) is required. It is an ETL system developed to create the mapping to load the target from the source files after applying criteria as required by the administrator and will also provide the overall features and functionalities required to store and maintain customer data. The data stored in the DW is transformed (cleaned and integrated), thus it is credible and can be used for business insights. This serves as an important component for BI (Business Intelligence) which will help in transforming raw/operational data into some meaningful information. The Fact_Inventory which is developed provides us the historical data in a summarized form which can be used for managerial, strategic and analytical decisions by the Analysts team and the end users. It acts as a vast storehouse for the already operated data and can be referred to as an ‘Informational System’.


Information management Data warehouse Business intelligence 


  1. 1.
    N.L.B. Putri, Design of information systems customer relationship management to improve services sales approach system development life cycle (SDLC), 6(1), 466–472 (2017)Google Scholar
  2. 2.
    H.S. Soliman, Customer relationship management and its relationship to the marketing performance. Int. J. Bus. Soc. Sci. 2(10), 166–182 (2011)Google Scholar
  3. 3.
    M. Anshari, N. Almunawar, M. Arif, S. Lim, A. Al-Mudimigh, Customer relationship management and big data enabled: personalization & customization services. Appl. Comput. Inform. 15(2), 94–101 (2019)CrossRefGoogle Scholar
  4. 4.
    E. Prayitno, N.A. Astuty, Positive impact of customer relationship management (CRM) implementation to improving the services of animal polyclinics customers, in 2017 International Conference on Sustainable Information Engineering and Technology (SIET), Malang, 2017, pp. 246–250Google Scholar
  5. 5.
    W.K.R. Perera, K.A. Dilini, T. Kulawansa, A review of big data analytics for customer relationship management, in International Conference on Information Technology Research, 2018, pp. 1–6Google Scholar
  6. 6.
    I.J. Chen, K. Popovich, Understanding customer relationship management (CRM) people process and technology. Bus. Process Manag. J. 9(5), 17, 672–688 (2003)Google Scholar
  7. 7.
    G. Mehta, G. Mittra, V.K. Yadav, Application of IoT to optimize data center operations, in International Conference on Computing, Power and Communication Technologies, 2018, pp. 738–742Google Scholar
  8. 8.
    A. Mishra, D. Mishra, Customer relationship management: implementation process perspective. Acta Polytech. Hung. 6(4), 83–99 (2009)Google Scholar
  9. 9.
    M. Srivastava, Customer relationship management: a technology driven tool. SIBM 2, 14–25 (2012)Google Scholar

Copyright information

© Springer Nature Singapore Pte Ltd. 2020

Authors and Affiliations

  1. 1.School of Electrical, Electronics and Communication EngineeringGalgotias UniversityGreater NoidaIndia

Personalised recommendations