Real-time data integration of an internet-of-things-based smart warehouse: a case study

Purpose Creating a real-time data integration when developing an internet-of-things (IoT)-based warehouse is still faced with challenges. It involves a diverse knowledge of novel technology and skills. This study aims to identify the critical components of the real-time data integration processes in IoT-based warehousing. Then, design and apply a data integration framework, adopting the IoT concept to enable real-time data transfer and sharing. Design/methodology/approach The study used a pilot experiment to verify the data integration system configuration. Radio-frequency identification (RFID) technology was selected to support the integration process in this study, as it is one of the most recognized products of IoT. Findings The experimentations’ results proved that data integration plays a significant role in structuring a combination of assorted data on the IoT-based warehouse from various locations in a real-time manner. This study concluded that real-time data integration processes in IoT-based warehousing could be generated into three significant components: configuration, databasing and transmission. Research limitations/implications While the framework in this research was carried out in one of the developing counties, this study’s findings could be used as a foundation for future research in a smart warehouse, IoT and related topics. The study provides guidelines for practitioners to design a low-cost IoT-based smart warehouse system to obtain more accurate and timely data to support the quick decision-making process. Originality/value The research at hand provides the groundwork for researchers to explore the proposed theoretical framework and develop it further to increase inventory management efficiency of warehouse operations. Besides, this study offers an economical alternate for an organization to implement the integration software reasonably.

[1]  Feng Cheng,et al.  A quantitative view on how RFID can improve inventory management in a supply chain , 2009 .

[2]  Duncan McFarlane,et al.  Radio frequency identification data capture and its impact on shelf replenishment , 2007 .

[3]  Zane Bicevska,et al.  Towards NoSQL-based Data Warehouse Solutions , 2017 .

[4]  Arun Kumar Biswal,et al.  Warehouse efficiency improvement using RFID in a humanitarian supply chain: Implications for Indian food security system , 2018 .

[5]  Ali Mohamed Abbas Kamali,et al.  Smart Warehouse vs. Traditional Warehouse - Review , 2019 .

[6]  Jamison V. Kovach,et al.  Improving supply chain information sharing using Design for Six Sigma , 2016 .

[7]  Anas M. Atieh,et al.  Performance Improvement of Inventory Management System Processes by an Automated Warehouse Management System , 2016 .

[8]  George Q. Huang,et al.  An IoT-enabled Real-time Logistics System for A Third Party Company: A Case Study , 2020 .

[9]  M. Erkayaoğlu,et al.  Improving mine-to-mill by data warehousing and data mining , 2019 .

[10]  Wei Zhang,et al.  A Unified Framework for Street-View Panorama Stitching , 2016, Sensors.

[11]  A. Aamer.  An Application of Lean Assessment in a Cross-Docking Distribution Center , 2017 .

[12]  Kareem Kamal A. Ghany.  Data Integration in Data Warehousing , 2012 .

[13]  Walaa Hamdy,et al.  Impacts of Internet of Things on Supply Chains: A Framework for Warehousing , 2019, Social Sciences.

[14]  S. Neeraja,et al.  Warehouse inventory management system using IoT and open source framework , 2018, Alexandria Engineering Journal.

[15]  Santiago Omar Caballero Morales,et al.  Digital supply chain model in Industry 4.0 , 2019, Journal of Manufacturing Technology Management.

[16]  Amy J. C. Trappey,et al.  IoT patent roadmap for smart logistic service provision in the context of Industry 4.0 , 2017 .

[17]  Ngoc Thanh Nguyen,et al.  A formal framework for query decomposition and knowledge integration in data warehouse federations , 2013, Expert Syst. Appl..

[18]  Angappa Gunasekaran,et al.  Bottom-Up Approach based on Internet of things for Order Fulfillment in a Collaborative Warehousing Environment , 2015 .

[19]  Andrés Ortiz,et al.  An RFID-Based Smart Structure for the Supply Chain: Resilient Scanning Proofs and Ownership Transfer with Positive Secrecy Capacity Channels † , 2017, Sensors.

[20]  Rustem A. Sabitov,et al.  Model of the Automated Warehouse Management and Forecasting System in the Conditions of Transition to Industry 4.0 , 2019, IFAC-PapersOnLine.

[21]  Sung Hoon Chung,et al.  Introduction of a real time location system to enhance the warehouse safety and operational efficiency , 2020 .

[22]  Wei Chen,et al.  Food warehousing simulation by RFID technology , 2017 .

[23]  Pratik J. Parikh,et al.  The warehouse-inventory-transportation problem for supply chains , 2014, Eur. J. Oper. Res..

[24]  Boris Vrdoljak,et al.  The potential of semantic paradigm in warehousing of big data , 2019 .

[25]  Q. Wang,et al.  A new-generation automated warehousing capability , 2010, Int. J. Comput. Integr. Manuf..

[26]  Martin Törngren,et al.  Fundamentals of Implementing Real-Time Control Applications in Distributed Computer Systems , 1998, Real-Time Systems.

[27]  N. Mostafa,et al.  Towards a Smart Warehouse Management System , 2018 .

[28]  Lijun Wei,et al.  Digital twin-driven joint optimisation of packing and storage assignment in large-scale automated high-rise warehouse product-service system , 2019, Int. J. Comput. Integr. Manuf..

[29]  Dimitris Mourtzis,et al.  Warehouse Design and Operation using Augmented Reality technology: A Papermaking Industry Case Study , 2019, Procedia CIRP.

[30]  Ahmed Zouinkhi,et al.  A communicating object’s approach for smart logistics and safety issues in warehouses , 2017, Concurr. Eng. Res. Appl..

[31]  Chien-Jung Huang,et al.  Warehouse management with lean and RFID application: a case study , 2013 .

[32]  Antonio Rizzi,et al.  Efficiency improvement in manual warehouses through ERP systems implementation and redesign of the logistics processes , 1999 .

[33]  Feng Chu,et al.  RFID-enabled flexible warehousing , 2017, Decis. Support Syst..

[34]  Jan Holmström,et al.  RFID tracking in the book supply chain: the transition from postponed to speculative tagging , 2012 .

[35]  Hamed Taherdoost,et al.  Sampling Methods in Research Methodology; How to Choose a Sampling Technique for Research , 2016 .

[36]  L. Kinsman,et al.  Blending Video-Reflexive Ethnography With Solution-Focused Approach: A Strengths-Based Approach to Practice Improvement in Health Care , 2019, International Journal of Qualitative Methods.

[37]  E. Balla,et al.  We are IntechOpen , the world ’ s leading publisher of Open Access books Built by scientists , for scientists 12 . 2 % , 2012 .

[38]  R. Srinivasan,et al.  Strategic Marketing and Innovation for Indian MSMEs , 2017 .

[39]  Xixu Fu,et al.  On Data Integration, Warehousing and Software Reuse in the Construction of Digital Campus: A Review on Performance , 2011 .

[40]  Ray Y. Zhong,et al.  RFID-enabled real-time advanced planning and scheduling shell for production decision making , 2013, Int. J. Comput. Integr. Manuf..

[41]  J. Malmqvist,et al.  Conducting the Pilot Study: A Neglected Part of the Research Process? Methodological Findings Supporting the Importance of Piloting in Qualitative Research Studies , 2019, International Journal of Qualitative Methods.

[42]  King Lun Choy,et al.  Design and application of Internet of things-based warehouse management system for smart logistics , 2018, Int. J. Prod. Res..

[43]  Marc Räkers,et al.  Supporting the design of data integration requirements during the development of data warehouses: a communication theory-based approach , 2017, Eur. J. Inf. Syst..

[44]  M. Kivikoski,et al.  Effect of item identifiers' length on passive radio frequency identification technology with supply chain applications , 2006 .

[45]  Zhenyu Huang,et al.  Integrating Web-Based Data into A Data Warehouse , 2002, Inf. Syst. Manag..

[46]  Gregory M. Magnan,et al.  Information sharing and supply chain performance: the role of connectivity and willingness , 2007 .

[47]  Lars Nielsen,et al.  Efficient Motion Planning for Autonomous Vehicle Maneuvers Using Duality-Based Decomposition , 2019 .

[48]  Ammar Mohamed Aamer,et al.  Outsourcing in non-developed supplier markets: a lean thinking approach , 2018, Int. J. Prod. Res..

[49]  Yingfeng Zhang,et al.  A comprehensive review of big data analytics throughout product lifecycle to support sustainable smart manufacturing: A framework, challenges and future research directions , 2019, Journal of Cleaner Production.

[50]  Chih-Hung Chang,et al.  On construction of a big data warehouse accessing platform for campus power usages , 2019, J. Parallel Distributed Comput..

[51]  Ammar M. Aamer.  Distribution Center capacity analysis in stochastic environment: An application of value stream analysis and Monte Carlo simulation , 2017, 2017 IEEE International Conference on Industrial Engineering and Engineering Management (IEEM).

[52]  Kamran Mahroof,et al.  A human-centric perspective exploring the readiness towards smart warehousing: The case of a large retail distribution warehouse , 2019, Int. J. Inf. Manag..

[53]  Lihui Wang,et al.  IoT-enabled Smart Factory Visibility and Traceability Using Laser-scanners , 2017 .

[54]  Nils Boysen,et al.  Warehousing in the e-commerce era: A survey , 2019, Eur. J. Oper. Res..

[55]  Nadeem Ehsan,et al.  Integration between Customer Relationship Management (CRM) and Data Warehousing , 2012 .

[56]  Stavros Souravlas,et al.  A review on big data real-time stream processing and its scheduling techniques , 2020, Int. J. Parallel Emergent Distributed Syst..

[57]  Zhang Jianping,et al.  Integration of Data Warehouse into Knowledge-based System on Construction Management Decision Making , 2003 .

[58]  Mingzhou Jin,et al.  Smart logistics based on the internet of things technology: an overview , 2020 .

[59]  Xinwei Wang,et al.  Internet of Things to network smart devices for ecosystem monitoring. , 2019, Science bulletin.

[60]  Haradhan Kumar Mohajan,et al.  Two Criteria for Good Measurements In Research: Validity and Reliability , 2017 .

[61]  Sandeep Mudigonda,et al.  A Generic and Flexible Geospatial Data Warehousing and Analysis Framework for Transportation Performance Measurement in Smart Connected Cities , 2019 .

[62]  Andrea Scorzoni,et al.  Flexible tag microlab development: Gas sensors integration in RFID flexible tags for food logistic , 2007 .

[63]  Mohammad S. Jalali,et al.  The Internet of Things Promises New Benefits and Risks: A Systematic Analysis of Adoption Dynamics of IoT Products , 2019, IEEE Security & Privacy.

[64]  J. In.  Introduction of a pilot study , 2017, Korean journal of anesthesiology.

[65]  A. García,et al.  RFID enhanced MAS for warehouse management , 2007 .

[66]  E. Teijlingen,et al.  The importance of pilot studies. , 2002, Nursing standard (Royal College of Nursing (Great Britain) : 1987).

[67]  Jeffrey T. Leek,et al.  How to Share Data for Collaboration , 2018, The American statistician.

[68]  Leo Willyanto Santoso,et al.  Data Warehouse with Big Data Technology for Higher Education , 2017 .

[69]  Ray Y. Zhong,et al.  A proactive task dispatching method based on future bottleneck prediction for the smart factory , 2019, Int. J. Comput. Integr. Manuf..

[70]  Nayem Rahman.  An empirical study of data warehouse implementation effectiveness , 2017 .

[71]  Qian Wang,et al.  Application and integration of an RFID-enabled warehousing management system - a feasibility study , 2016, J. Ind. Inf. Integr..