CFP last date
20 January 2025
Reseach Article

Efficient Data Integration in Retail SCM using Inbound and Outbound Data Interfaces

by Sachin More
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 186 - Number 54
Year of Publication: 2024
Authors: Sachin More
10.5120/ijca2024924266

Sachin More . Efficient Data Integration in Retail SCM using Inbound and Outbound Data Interfaces. International Journal of Computer Applications. 186, 54 ( Dec 2024), 56-61. DOI=10.5120/ijca2024924266

@article{ 10.5120/ijca2024924266,
author = { Sachin More },
title = { Efficient Data Integration in Retail SCM using Inbound and Outbound Data Interfaces },
journal = { International Journal of Computer Applications },
issue_date = { Dec 2024 },
volume = { 186 },
number = { 54 },
month = { Dec },
year = { 2024 },
issn = { 0975-8887 },
pages = { 56-61 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume186/number54/efficient-data-integration-in-retail-scm-using-inbound-and-outbound-data-interfaces/ },
doi = { 10.5120/ijca2024924266 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-12-27T02:45:35.341827+05:30
%A Sachin More
%T Efficient Data Integration in Retail SCM using Inbound and Outbound Data Interfaces
%J International Journal of Computer Applications
%@ 0975-8887
%V 186
%N 54
%P 56-61
%D 2024
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The modern business landscape is characterized by a diverse array of IT software systems, each serving specific functions within the organization. This has resulted in a complex network of heterogeneous systems spanning across on-premises and multi-cloud environments including multi-regional data centers. The prevalent use of microservices architecture adds to the complexity, presenting challenges in maintaining data synchronization, communication, and orchestration to ensure a cohesive operation. These systems must work in concert, akin to an orchestra, sending and receiving signals to maintain seamless data and application synchronization ensuring atomicity of the transactions. In this Framework, we have proposed several data interface methodologies and built solutions to ensure Data is synchronized on a timely basis in preventing losses caused purely by data discrepancies and assure data quality across the enterprise application ecosystem. The intent is to save millions of dollars in losses and create avenues for growth achieved through aspects of data quality and integrity.

References
  1. W. Xiaojin, S. Shucai, X. Yehua, J. Tao and L. Hongkun, "Research on Data Standardization and Unified Data Interface Based on Digital Station System," 2022 IEEE 5th Advanced Information Management, Communicates, Electronic and Automation Control Conference (IMCEC), Chongqing, China, 2022, pp. 1372-1376, doi: 10.1109/IMCEC55388.2022.10019942.
  2. A. Singh, A. Fisher, C. Allwardt and R. B. Melton, "A Data Exchange Interface for a Standards-Based Data Integration Platform," 2020 IEEE Power & Energy Society Innovative Smart Grid Technologies Conference (ISGT), Washington, DC, USA, 2020, pp. 1-5, doi: 10.1109/ISGT45199.2020.9087646.
  3. R. B. Melton, K. P. Schneider, E. Lightner, T. E. Mcdermott, P. Sharma, Y. Zhang, et al., "Leveraging Standards to Create an Open Platform for the Development of Advanced Distribution Applications", IEEE Access, vol. 6, pp. 37361-37370, 2018
  4. L. Gifre, M. Ruiz and L. Velasco, "Interfaces for Monitoring and Data Analytics Systems," 2019 21st International Conference on Transparent Optical Networks (ICTON), Angers, France, 2019, pp. 1-4, doi: 10.1109/ICTON.2019.8840489.
  5. J. Sreemathy, I. Joseph V., S. Nisha, C. Prabha I. and G. Priya R.M., "Data Integration in ETL Using TALEND," 2020 6th International Conference on Advanced Computing and Communication Systems (ICACCS), Coimbatore, India, 2020, pp. 1444-1448, doi: 10.1109/ICACCS48705.2020.9074186.
  6. P. S. Diouf, A. Boly and S. Ndiaye, "Variety of data in the ETL processes in the cloud migration and validation: State of the art", 2018 IEEE International Conference on Innovative Research and Development (ICIRD), pp. 1-5, 2018.
  7. L. Munoz, J. Mazon and J. Trujillo, ETL Process Modeling Conceptual for Data Warehouse: A Systematical Mapping Study, vol. 2016, June 2011.
  8. T. Mi, R. Aseltine and S. Rajasekaran, "Data Integration on Multiple Data Sets," 2008 IEEE International Conference on Bioinformatics and Biomedicine, Philadelphia, PA, USA, 2008, pp. 443-446, doi: 10.1109/BIBM.2008.48.
  9. A. McCallum, K. Nigam, and L. Ungar. Efficient clustering of high-dimensional data sets with application to reference matching. Proceedings of the Sixth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, pages 169-178, 2000.
  10. Y. Zhao and G. Karypis. Evaluation of hierarchical clustering algorithms for document datasets. CIKM 02: Proceedings of the eleventh international conference on Information and knowledge management, pages 515-524, 2002.
  11. R. Shree, T. Choudhury, S. C. Gupta and P. Kumar, "KAFKA: The modern platform for data management and analysis in big data domain," 2017 2nd International Conference on Telecommunication and Networks (TEL-NET), Noida, India, 2017, pp. 1-5, doi: 10.1109/TEL-NET.2017.83435
Index Terms

Computer Science
Information Sciences
Banking
Event sourcing
E-commerce
Enterprise application
Interfaces
Supply Chain retail
stock management

Keywords

ERP CDC Data sync inbound outbound Real time Batch mode Traces PUSH PULL XML agents snapshots RESTful Web Services