| Author(s) | Collection number | Pages | Download abstract | Download full text |
|---|---|---|---|---|
| Гавенко М. М., Лабецька М. Т., Havenko S. F. | № 2 (69) | 55-64 |
|
|
CRM-systems are critical elements of modern business and information ecosystems, as they allow for the automation of integration, management, analysis and processing of customer data. An important aspect is the choice of a DBMS architecture that is sufficient for optimal performance, scalability and availability for a specific CRM system. The article presents data from a comparative analysis of the performance of relational (SQL) and non-relational (NoSQL) databases, taking into account such parameters as transactional consistency, availability, speed, horizontal scaling and performance under load.
This article examines the most common SQL-DBMSs (MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, SQLite, MariaDB, IBM Db2, SAP HANA) from the point of view of ensuring ACID-properties (transactional integrity) and the most common NoSQL-DBMSs (MongoDB, Cassandra, Redis, DynamoDB, Couchbase, Firebase Realtime Database, Elasticsearch, Neo4j) from the point of view of compliance with BASE-properties. And also conducted their group comparative analysis on key performance parameters.
SQL and NoSQL databases have clear differences, which determines their optimal use in CRM-systems. SQL databases provide high transactional consistency and reliability, which makes them ideal for centralized CRM. They demonstrate stable query execution time due to the structured nature of data and support for ACID guarantees, which confirms their advantage in systems with high requirements for transactional processing. NoSQL databases are distinguished by their horizontal scaling efficiency and availability of up to 99%. These databases are optimal for CRM with a distributed architecture, where processing large volumes of unstructured data and real-time operation are important. MongoDB and Redis provide the best performance in CRM systems focused on dynamic data.
Further research into database performance in environments with tens of thousands of simultaneous queries, as well as integration with cloud platforms, opens up prospects for improving the efficiency and availability of CRM systems.
Keywords: CRM systems, relational and non-relational databases (SQL and NoSQL), data processing, transactional integrity - ACID, BASE, data storage efficiency, CAP, DBMS.
doi: 10.32403/1998-6912-2024-2-69-46-54
- 1. Saha, L., Tripathy, H. K., Nayak, S. R., & Barsocchi, P. (2021). Amalgamation of customer relationship management and data analytics in different business sectors—A systematic literature review. Sustainability, 13(9), 5279.
- 2. Jani, Y. (2021). The role of SQL and NoSQL databases in modern data architectures.
- 3. Faraz, H., & Chausson, A. (2022). SQL vs. NoSQL: Optimizing database performance for modern e-commerce systems.
- 4. Malyi, R., & Serdyuk, P. (2024). Developing a performance evaluation benchmark for event sourcing databases.
- 5. Elmasri, R., & Navathe, S. B. (2016). Fundamentals of database systems (7th ed.). Pearson.
- 6. Buttle, F., & Maklan, S. (2019). Customer relationship management: Concepts and technologies (4th ed.). Routledge.
- 7. H.R. Vyawahare, P.P. Karde, V.M. Thakare. (2021). Hybrid approaches in database management for scalable CRM systems.
- 8. Nasser Taleb, Mohammad Salahat, Liaqat Ali. (2022). Impact of data storage techniques on CRM efficiency.
- 9. Kola, H. G. (2023). SQL in Data Engineering: Techniques for Large Datasets.
- 10. Kosasih, O., Hidayat, K., & Hutahayan, B. (2024). Developing sustainable business-to-business (B2B) strategies in service innovation for enhancing customer loyalty in the petrochemical industry: A systematic review. Taylor & Francis.
- 11. Hasan, M. M. (2024). Customer Relationship Management Practices by Inpace Management Services Ltd. United International University Repository.