Performance Comparison of CRM Systems Dedicated to Reporting Failures to IT Department

  • Hubert Zarzycki
  • Jacek M. Czerniak
  • Dawid Lakomski
  • Piotr Kardasz
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 504)


This paper contains study to confirm advantage of database systems in the client-side architecture for certain applications. Research investigates whether the client-side architecture systems can be more efficient at the significant load as compared to server-side architectures systems. The experiments were carried out for two types of servers and clients for a variety of tasks and servers load. For the purpose of experiments a two-part database system for reporting failures to IT department has been developed in Visual C# language according to former design assumptions. Then it was compared with the same system developed using PHP in the server-side architecture. The study has proven the advantage of client-side architecture systems in case of servers under high load and confirmed importance of using such architecture for small and medium-sized systems. Additionally, it indicated the necessity to optimize queries in order to accelerate operation of both kinds of applications as well as the need to use optimum network setup of the server.


Database MySQL MsSQL C# Visual Studio.NET PHP ERP CRM Client-side Server-side 


  1. 1.
    Adamczyk, J.: The CRM in a classic and web context (in Polish) (2009)Google Scholar
  2. 2.
    Angryk, R.A., Czerniak, J.: Heuristic algorithm for interpretation of multi-valued attributes in similarity-based fuzzy relational databases. Int. J. Approx. Reason. 51(8), 895–911 (2010)CrossRefGoogle Scholar
  3. 3.
    Apiecionek, L., Czerniak, J.M.: QoS solution for network resource protection. In: Informatics 2013: Proceedings of the Twelfth International Conference on Informatics, pp. 73–76 (2013)Google Scholar
  4. 4.
    Apiecionek, L., Czerniak, J.M., Dobrosielski, W.T.: Quality of services method as a DDoS protection tool. In: Intelligent Systems’2014, Tools, Architectures, Systems, Applications, vol. 2, pp. 323, 225–234 (2015)Google Scholar
  5. 5.
    Apiecionek, L., Czerniak, J.M., Zarzycki, H.: Protection tool for distributed denial of services attack. In: Beyond Databases, Architectures and Structures, BDAS, 2014, vol. 424, 405–414 (2014)Google Scholar
  6. 6.
    Bojar, W., Drelichowski, L., Lewandowski, R., Oszuscik, G., Zarzycki, H.: A comparative analysis of polish economic development across the eu countries with the use of olap tools during 1994–2009. In: Studies and Proceedings of Polish Association for Knowledge Management, vol. 59, pp. 124–147 (2012)Google Scholar
  7. 7.
    Converse, T., Park, J., Morgan, C.: PHP5 i MySql Bible. Helion, Gliwice (2005)Google Scholar
  8. 8.
    Czerniak, J., Zarzycki, H.: Application of rough sets in the presumptive diagnosis of urinary system diseases. Artif. Intell. Secur. Comput. Syst. 752, 41–51 (2003)CrossRefGoogle Scholar
  9. 9.
    Czerniak, J.: Evolutionary approach to data discretization for rough sets theory. Fundamenta Informaticae 92(1–2), 43–61 (2009)MathSciNetGoogle Scholar
  10. 10.
    Czerniak, J.M., Apiecionek, L., Zarzycki, H.: Application of ordered fuzzy numbers in a new ofnant algorithm based on ant colony optimization. In: Beyond Databases, Architectures and Structures, BDAS, 2014, vol. (424), pp. 259–270 (2014)Google Scholar
  11. 11.
    Czerniak, J.M., Dobrosielski, W., Zarzycki, H., Apiecionek, L.: A proposal of the new owlant method for determining the distance between terms in ontology. In: Intelligent Systems’2014, Tools, Architectures, Systems, Applications, vol. 2, pp. 323, 235–246 (2015)Google Scholar
  12. 12.
    Czerniak, J., Dobrosielski, W., Apiecionek, L.: Representation of a trend in OFN during fuzzy observance of the water level from the crisis control center. In: Proceedings of the Federated Conference on Computer Science and Information Systems, IEEE Digital Library, ACSIS, vol. 5, pp. 443–447 (2015)Google Scholar
  13. 13.
    Czerniak, J., Macko, M., Ewald, D.: The cutmag as a new hybrid method for multi-edge grinder design optimization. Adv. Intell. Syst. Comput. 401, 327–337 (2016)CrossRefGoogle Scholar
  14. 14.
    Czerniak, J., Smigielski, G., Ewald, D., Paprzycki, M.: New proposed implementation of ABC method to optimization of water capsule flight. In: Proceedings of the Federated Conference on Computer Science and Information Systems, IEEE Digital Library, ACSIS, vol. 5, pp. 489–493 (2015)Google Scholar
  15. 15.
    Dejnaka, A.: CRM. Zarzadzanie relacjami z klientami, Helion, Gliwice (2002)Google Scholar
  16. 16.
    Ewald, D., Czerniak, J.M., Zarzycki, H.: Approach to solve a criteria problem of the ABC algorithm used to the WBDP multicriteria optimization. In: Intelligent Systems’2014, Mathematical Foundations, Theory, Analyses, vol. 1, pp. 322, 129–137 (2015)Google Scholar
  17. 17.
    Kozik, R., Choraś, M., Flizikowski, A., Theocharidou, M., Rosato, V., Rome, E.: Advanced services for critical infrastructures protection. J. Ambient Intell. Hum. Comput. 6(6), 783–795 (2015).
  18. 18.
    Owedyk, J., Mathia, Z., Zarzycki, H.: Optimization algorithm supported on minimizing the Kullback-Leibler information divergence in some dynamical systems. Wroclaw Sch. Technol. Sci. Bull. 5, 12–19 (2015)Google Scholar
  19. 19.
    Solis, D.: Ilustrated C#. Apress (2008)Google Scholar
  20. 20.
    Swierczewski, L.: Intel manycore testing lab—hardware and software environment focused on didactic of development and efficiency testing in software parallelin. Wroclaw Sch. Technol. Sci. Bull. 3, 32–36 (2013)Google Scholar
  21. 21.
    Walser, K.: Auswirkungen des CRM auf die IT-integration. Eul Verlag (2006)Google Scholar
  22. 22.
    Yuan, S., Chang, W.: Mixed-initiative synthesized learning approach for web-based CRM. Expert Syst. Appl. 20(2), 187–200 (2001)CrossRefGoogle Scholar
  23. 23.
    Zakrzewski, P.: How to prepare the implementation of CRM (in Polish). Magazyn Modern Mark. 7, 38–42 (2001)MathSciNetGoogle Scholar
  24. 24.
    Zarzycki, H.: Enterprise resource planning systems application and implementation on the example of simple.erp software package. Adv. Inf. Syst. Manage. AITM 205, 281–291 (2011)Google Scholar
  25. 25.
    Zarzycki, H., Fronczak, E.: A practical approach to computer system architecture for an agro-food industry information center. PSZW 33, 248–255 (2010)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2017

Authors and Affiliations

  • Hubert Zarzycki
    • 1
  • Jacek M. Czerniak
    • 2
  • Dawid Lakomski
    • 2
  • Piotr Kardasz
    • 3
  1. 1.Department of Computer ScienceWroclaw School of Information TechnologyWrocławPoland
  2. 2.AIRlab Artificial Intelligence and Robotics LaboratoryInstitute of Technology, Casimir the Great University in BydgoszczBydgoszczPoland
  3. 3.Cluster of Research, Development and InnovationWrocławPoland

Personalised recommendations