ArticlePDF Available

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

Authors:

Abstract

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.
Real-time data integration of an
internet-of-things-based smart
warehouse: a case study
Chelinka Rafiesta Sahara
Sampoerna University, Jakarta, Indonesia, and
Ammar Mohamed Aamer
Northeastern University, College of Professional Studies, Toronto, Canada
Abstract
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 conguration. Radio-frequency identication (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 experimentationsresults proved that data integration plays a signicant 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 signicant components: conguration, databasing and transmission.
Research limitations/implications While the framework in this research was carried out in one of the
developing counties, this studysndings 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 efciency of
warehouse operations. Besides, this study offers an economical alternate for an organization to implement the
integration software reasonably.
Keywords Cyber-physical systems, Industry 4.0, Internet-of-things, Real-time data,
Smart warehouse
Paper type Research paper
1. Introduction
Warehousing operations play a critical role in managing inventory levels, storing goods and
logistics activities. The warehouses function is at the heart point in the supply chain (Aamer,
2018a;Mostafa et al.,2019). The warehouse operations present a meaningful task in
Erratum: It has come to the attention of the publisher that the article, Real-time data integration of
an internet-of-things based smart warehouse: a case studyby Ammar Mohamed Aamer and
Chelinka Raesta Sahara published in International Journal of Pervasive Computing and
Communications listed the authors in the incorrect order. The correct order of authors is Chelinka
Raesta Sahara and Ammar Mohamed Aamer. This error was introduced in the editorial process and
has now been corrected in the online version. The publisher sincerely apologises for this error and for
any inconvenience caused.
Smart
warehouse
Received 16 August2020
Revised 10 December2020
Accepted 21 January2021
International Journal of Pervasive
Computing and Communications
© Emerald Publishing Limited
1742-7371
DOI 10.1108/IJPCC-08-2020-0113
The current issue and full text archive of this journal is available on Emerald Insight at:
https://www.emerald.com/insight/1742-7371.htm
accommodating better-quality services and mitigating supply and demand (Sainathuni et al.,
2014). It is essential in warehouse operations to maintain costs at the minimum number and
improve customer satisfaction (Aamer, 2018c;Aamer, 2018b). Warehouse efciency has become
the focal point of competency among organizations to develop (Jermsittiparsert et al., 2019).
Organizations have adopted advanced technology to form an adaptive and exible
warehouse design for a competitive market that facilitates product visibility (Mourtzis et al.,
2019). Such a small operation of non-computerized managerial activity and motorized data
input is a piece of traditional complications that can also be overcome by adopting
appropriate technology. The internet-of-things (IoT) is theorized as one of the renowned
concepts of most promising technology in the fourth industrial revolution (Industry 4.0) that
is primarily used to enhance the control and improve performance in the supply chain such
as in the warehouse area (Mostafa et al.,2019). IoT accommodates the digital connectivity of
the physical and digital components to present real-time data storage and sharing,
positively impacting the customers satisfaction level (Rondero et al.,2019).
Real-time data storage and sharing provide a massive amount of data and location of goods
as continuous moving information (Vicuna et al., 2019). Thus, the virtue it gives to the product
enhances the movement accuracy and greater visibility of products (Mahroof, 2019).
Technologys data-driven process reects highly accurate and synchronized information for an
organizations improvement and improved decision-making. The presence of synchronized
accurate information also contributes a signicant role in eliminating the lead to a high
frequency of human errors, minimizing the handling process and reducing operating expenses
(Alyahya et al., 2016). Consequently, the real science behind successful warehouse management
can be inferred in obtaining, sharing and analyzing real-time information about the products
activities in the warehouse. It is worth noting that technology adoption in the warehouse has
also brought an adverse effect that hinders the assuring of performance renement conduct.
For example, in e-commerce retailerscases that used IoT in their operation, the problem
emerged from the time-critical picking orders that generated a massive amount of data from
various locations in monitoring needs (Boysen et al.,2019). There is a gap in the literature from
such a condition to explore technology advancementspredened requirements.
Real-time data integration is recognized as a signicant part of IoT-based warehouse that
provides real-time monitoring. Real-time data integration helps acquire adequate information that
consists of raw data and well-ordered data (Ellis and Leek, 2018). Integration also powers the role
of IoT-based warehouse to assure an accurate and reliable information ow is promoted (Mitchell
and Kovach, 2016). The success of integration accumulates to better support and collaborative
decision-making by eliminating distances and connecting managers across functional. Further,
real-time connection maintains the monitoring of customer behavior feasible (Fawcett et al., 2007).
However, real-time data integration does not come with an affordable cost of implementation and
a simple adoption process (Li et al.,2019). Creating a real-time data integration as building an IoT-
based warehouse necessitates a high investment cost and, most importantly, a detailed mature
design (Sainathuni et al.,2014). It is still a challenge to integrate data in a real-time manner as it
involves a diverse knowledge of novel technology and skills to reach a small number of delays.
Besides, there is a paucity of knowledge sharing related to real-time data integration that
provides an applicable implementation for small-medium businesses.
Motivated by the rationale and reason mentioned above, this studys main objective is to
design and apply a data integration framework, adopting the IoT concept in enabling real-time
data transfer and sharing. Radio-frequency identication (RFID) technology was selected to
support the integration process in this study. It is one of the most recognized IoT products that
reect real-time behaviors to enable real-time visibility and tracking in a warehouse (Zhong et
IJPCC
al., 2017). This study contributes to enriching the knowledge gap of the integration process of
real-time data in IoT-based warehouse to support the adoption of IoT-based warehouses.
Section 2 presents a theoretical background in which further insight about real-time data
integration for IoT-based warehouse in a systematic writing structure. Afterward, the
methodology of the study is explained in Section 3. Subsequently, the research result and
discussion consist of a fundamental concept, design framework, key factors and challenges
are discussed in Section 4. Section 5 summarizes the study, its signicance, limitations of the
research and future research suggestions.
2. Literature review
2.1 Internet of things and integration
IoT infrastructure is based on the foundation of various technologies such as Ambient
Intelligence, Internet Protocol, Communication technologies: WiFi, Bluetooth, ZigBee,
Embedded devices: RFID or wireless sensor networks and applications (Reaidy et al.,2015).
The implementation of IoT infrastructure comprises four creation aspects as Things,
Gateways, Network infrastructure and Cloud infrastructure (Hamdy et al.,2018). Things
represent a technological apparatus to gather physical data in a real-time manner. Gateways
stand as the connection to bridge activity between Things and Network infrastructure, but
Network infrastructure facilitates data ow and track security to the Cloud. Cloud
infrastructure acts as a data processing process or analytical machine.
The IoT structure comprises three different aspects: perception, network and application
(Trappey et al.,2017). In terms of the perception aspect, the ability of IoT in sensing the object is
represented in such technological products with many variety and applicability such as 2D-
barcode, circuits, sensors, actuators, controllers, RFID tags, imaging, mobile communication and
terminals. The network supports the perceived ability to enable a share of information. Network
composes of features such as device modeling, security, WiFi, ethernet, gateway control, GSM,
UMTS, LTE, LTE-A, Hadoop, OS, USB, NFC, HTTP, FTP DDS, Bluetooth, Cloud and database.
While for its application, IoT encompasses many sectors such as tracking, health-care and
logistics. With the whole structure of IoT, the main objective of its adoption in a warehouse is to
introduce automation to the warehouses controlling process (Atieh et al., 2016).
The promising benet of emerging IoT technology is the experience of real-time monitoring of
equipment, facilitates and goods (Chang et al.,2019). The mutual collaboration between IoT and
cloud computing promotes data accuracy at an advanced level (Tantalaki et al.,2019). The
enhancement of security and quicker handling is also the gain for organizations (Atieh et al.,
2016). In the warehouse operation, the reduction of cost has become the primary objective of
many enterprises (Leng et al., 2019). The warehouses business processscomplexitysuchas
much work-in-process and variety of demand triggers more errors. With the presence of IoT,
mistakes could be reduced and, perhaps, eliminated through automation (Zhou et al.,2017). In
general, the high adoption of IoT generates higher perceived benets and low cybersecurity risk
(Jalali et al.,2019). On the other hand, the IoT application challenges necessitated the need to
develop data acquisition methods and IoT technical capacity (Ding et al.,2020).
2.2 Internet of things-based warehouse
The compulsion of challenging activity tracking and identifying goods in a specicperiod
reects a complex undertaking (Tejesh et al., 2018). The idea of goods tracking can be realized by
obtaining up-to-date information (Rahman, 2016). Industry 4.0 allows technology to transform the
practice in streamlining the supply chain to gain data (Lototsky, 2019). An IoT-based
warehousing system is a technological involvement product that connects the physical
warehouse to facilitate continuous interconnected real-time information from various locations
Smart
warehouse
into a single database (Yerpude and Singhal, 2018). The adoption of technology into warehousing
enhances efciency by providing transparency and accuracy (Mahroof, 2019). The IoT-based
warehouse also offers strong business knowledge consisting of a data depository of operations,
decisions and external processes (Khan et al.,2012).
The transformation from a conventional warehouse operation into a high degree automation
warehouse system is motivated by the consideration of efcient management lacking (Leng et al.,
2019). According to Trappey et al. (2017), IoT plays a vital role in enabling a smart logistics and
warehouse in the context of Industry 4.0. The utilization of IoT integrated technology is the brain
that facilitates traceability and decision support in warehouse and logistics activity. From the
managerial perspective, IoT supports an excellent improvement for a decentralized management
warehouse (Reaidy et al., 2015). The process of data management in an IoT-based warehouse
involves a historical data maintenance process, while the extracting process to transform data into
valuable knowledge consists of ve activities presented in Figure 1. The IoT is adopted in the
warehouse management system to enable product information tracking (Tejesh and Neeraja,
2018).
2.3 Radio-frequency identication technology
RFID is a supporting technology that is considered a promising solution to address
inventory inaccuracy (Biswal et al.,2018). The automated industry trends were well-known
for many business applications such as Wal-Mart, Metro, Target and Tesco (Sydänheimo et
al.,2006;Hinkka et al.,2012). The use of RFID technology positively detects numerous
objects simultaneously at different distance levels in an instant way of communicating
(Rizzi, 2006). This advanced technological tool capable of enhancing information accuracy
and visibility through seamless monitoring. The usage of RFID in the warehouse
management system is commonly to track and trace goods exclusively for the inconsistency
of information due to changes and updates of the warehouse activities (Lee et al.,2017).
RFID allows storing a massive amount of data on the tags at a specic distance that requires
minor movement (Kamali, 2020;Trab et al., 2016). Data retrieval using RFID technology also
supports automatic identication and automated product identity extraction (Yaw Wong
and McFarlane, 2007). Therefore, human participation in the warehouse systems is slightly
altered from an actively involve worker to a human operator (Buntak et al.,2019).
The utilization of RFID technology in a warehouse is renowned for eliminating inefciency
and ineffectiveness (Chen et al.,2013). RFID technologys advantages simplify warehouse
management to provide better-quality control enablement, product visibility and delivery
reliability improvement (García et al.,2007). The integration of RFID technology with other
intelligence tolls such as sensors enables monitoring of goods in the warehouse, making operation
more exible (Abad et al.,2007). RFID could also be used for improving storage efciency and
process renement by combining the technology with warehouse management tools, resulting in
a labor waste reduction (Xiao et al.,2017). Besides its tracking performance, RFID is used to
enhance information systems by coordinating warehouse operations such as planning, execution
and control for the quick decision-making process (Zhong et al.,2013).
Figure 1.
Data roles in shaping
valuable knowledge
Data cleaning Data
integraon Data reducon Data
transformaon
Data
discrezaon
IJPCC
The RFID utilization returns lie in tracking in a simple, timely and accurate manner, providing more
visibility of object movements. In terms of capacity, RFID can store thousands of digits number and
track locations from a specic distance using frequencies via wireless communication networks, making
it possible to automatically read hundreds of tags per second (Wang et al., 2010). In general, it requires
signicant investment in process redesign, technology infrastructure and operation transformation to
reap the benets of RFID utilization (Lee et al., 2009).
2.4 Data integration
Data integration is dened as the process of connecting, managing and combining time-variant
data from various operations and locations (Kern et al.,2013;Shivtare and Shelar, 2015). This
processs implementation is renowned for facilitating more efcient decision-making (Chau et al.,
2013). Therefore, data integration is the heart of the IoT-based warehousing enablement aspect
(Calvanese et al.,2001). Data integration provides sufcient assistance for technology as a
prerequisite in ensuring data reliability and minimizes errors (Rizzi, 2006). It also helps distribute
data to many enterprises to enable more efciency (Fu et al., 2011). The integration process
necessitates a series of structuring actions from the specic textual format and numeric data into
homogenous format data (Huang et al.,2016;Rosenkranz et al.,2017;Shivtare and Shelar, 2015).
Moreover, various data acquisitions from multiple devices, software and systems generate more
complex heterogeneous unstructured data (Ren et al.,2019).
The integration of information and IoT technology allows improved organizational
decision-making (Huang et al.,2002). Moreover, the integration process gives the decision-
makers more accurate information at the right time for further analytical purposes (Pti
cek
et al., 2019). The integration process of data is also associated with the data warehousing
process. In data warehousing, it consists of a large scale of data sets that are non-relational
from each database (Bicevska and Oditis, 2016). The integration of data becomes as
essential as the data warehouse in extracting the vital data from a scattered form into
centralized, integrated storage (Santoso and Yulia, 2017). The data warehouses role plays a
signicant contribution in storing data sources and destinations, leading to designs for data
extraction, transformation and loading (Rosenkranz et al.,2017). In running the task of
tracking and identifying products, RFID faced two enormous challenges in moving goods.
The study by Burmester et al. (2017) identied protection control of moving goods and
security at each stage of the chain regarding ownership transfer protocols as the main two
challenges.
2.5 Real-time data systems
A real-time system is perceived as a reaction to external events that a computer system
encounters within some stipulated deadline (Tongren, 1998). Real-time systemsprimary
requirements include a stringent and low delay pattern and continuity of variation in time
relation between the data entities. Tantalaki et al. (2019) dened the real-time system as an
operation that behaves within the real-worldtime limit. The use of real-time data
positively contributes to the quality of decision-making. The result of performance
measurement based on its real-time value is required for allowing data visibility in
operations (Erkayaoglu and Dessureault, 2019). A real-time thing such as real-time location
or real-time data can provide the exact positioning of an object when combines with other
supporting technology (Halawa et al.,2019).
3. Methodology
The research plan presented in Figure 2 illustrates the detailed steps of the methodology
used to conduct the study at hand to address the research objectives comprehensively. The
Smart
warehouse
research plan was initially generated from examining the research problem, exploratory
research of related literature review and the brainstorming of concepts. The research plan is
composed of seven different levels of activities to achieve the reporting and analysis step.
The rst level is the preliminary activity comprising several tasks: qualitative data
collection, problem determination, objectives determination, exploratory research conduct,
best-practice selection and research approach determination. The second level involved the
Figure 2.
Research plan
IJPCC
data collection process. Following the data collection process was the instrument selection
process. Subsequently, the integration design was developed. Afterward, a pilot study was
executed with the physical representation building of the case company warehouse. Finally,
the validity testing and integration steps were carried out. The following section presents
more details about each level of the research methodology shown in Figure 2.
3.1 Preliminary activity
Preliminary activity referred to a compilation of events before conducting the data collection
process and helped reach a proper research approach. The event took place in a warehouse
of one of the local companies. The case company is one of the foreign direct investments in
Indonesia. The general model of real-time data integration for the IoT-based warehouse in
this study is displayed in Figure 3.Figure 3 presents the data ow in the case warehouse,
represented by a solid line where the data transfer from one part of an information system to
another location.
There are four different locations in the selected case company warehouse and it has
distinct data input and output to be recorded and received. In warehouse 1 where product
slotting and sortation happened, the data represents the goodsproperties such as the
number of daily goods stored from the production area, the number of goods based on their
product type and the time of goods entering the warehouse. In the labeling process area
where order picking took place, the goods were transferred from warehouse 1 to warehouse
2 based on the customer demand requirements. The detailed description included the
number of order goods according to the customer, the number of goods orders based on its
product type, the departure time of goods ordered and the time order entering the labeling
process. In warehouse 2 where it focused on zone picking, the specic detail of description to
Figure 3.
Real-time data
integration mapping
in the case warehouse
Smart
warehouse
ensure the correct number of orders labeled in the labeling process was checked in this area.
The last stage is to recheck the correctness of goods ordered by recalculating the ordered
product based on the pallet. The documenting method when the ordered product is shipped
based on the requested cargo happed in this area.
In the preliminary activity, the qualitative data collection was carried out rst to identify
the case companys main problem regarding the warehouse activity through in-depth
interviews and discussions with the employees and managers. The data from the
discussions and interviews were then used as resources for the problem determination
process. The problem was formulated at the case company as the inability to streamline the
warehouses performance because of manual data input, low visibility, back-and-forth
communication and the necessity of an improved decision-making process. This was in line
with this studys objective to increase data visibility and decision-making process by
developing a data shared-point system and designing a data integration system to provide
real-time information. Further exploratory research was conducted to obtain a best-practice
solution. The RFID technology was selected as the best supporting tool to enable real-time
data to support the integration data process to enhance data visibility and decision-making.
3.2 Data collection
The data collection objective was to gather useful information regarding warehouse activity,
data ow, technology utilization and employeesmovement. There were three approaches to
collecting data: in-depth interviews, informal discussions and comprehensive observations,
as suggested by Sileyew (2016). The in-depth interviews were conducted with the supply
chain director and management of the warehouse. The individual interviews from each
group provided the management perspectives on the current warehouse condition and a
thorough understanding of the existing warehouse situation and the business condition.
This further contributed to the renement and enhancement of this study objective. Several
informal discussions and interviews with the shop oor workers took place at different
times in four separate areas, known as warehouse 1, labeling area, warehouse 2, docking
area and administration ofces. Finally, the research team conducted in-depth observations
of employeesactivities and goods ow process over two months to collect information. This
information was related to the employment roles in deploying warehouse activity data such
as customer demand, total demand, type of products, eld setting, and many others.
3.3 Instrument selection
The instrument selection step involved the supporting tools selection step in managing the
obtained data and realizing the research objectives. The selected tools were generated as a
necessity resulted from data collection and an exploratory study conducted in the
preliminary activity section. This step mainly covered the activity of choosing RFID tag
types and RFID scanner types that best suited to the warehouse conditions such as
warehouse requirements, warehouse size, number of employees and employee involvement
in movable property.
3.4 Integration design
The foundation of integration design entails the data integration design framework, as
shown in Figure 4. The framework was generated based on the data ow and data exchange
in various case warehouse locations, which helped to realize the importance of the data
integration process. The integration process increases the usefulness of data and converts it
to information. The data would not add value if the data integration process was not
performed. This is because data would only be gathered from various places, neglecting the
IJPCC
process of data mapping, cleansing and transformation. Most importantly, the data
integration process enables the unication of systems to produce consistent data to reduce
errors. Furthermore, integrated data promotes the efciency of data analysis to generate
new knowledge and understanding.
3.5 Pilot testing
The pilot study aimed to look at the feasibility of a specic study design (Teijlingen and
Hundley, 2002;In, 2017). Pilot studies could be used as the pre-testingor trying outof a
research design or instrument (Baker, 1994). The primary objective of conducting a pilot
study is to point out any aw if it exists in the execution of an instrument, model or system
(Srinivasan and Lohith, 2017). The practicality through piloting contributes to a greater
understanding of working intricacy within a previously designed study or ongoing study to
give appropriate options for selecting which instrument or model for a specic research
circumstance (Malmqvist et al.,2019). This study used a prototyping model to test and
verify the data integration system conguration. This study relied on the in-depth
investigation of processes and operation scrutiny in gathering the design requirements. An
iterative process of prototyping model carried out to reach high delity of the existing
system. The warehouse prototype represented the replicated case warehouse as a small-
scale model to perform the data integration process. The warehouse operations were
simulated according to the actual productsow in the warehouses and the nal goods
shipment. The moving productsdata was collected via the RFID tags attached to boxes
representing the case warehouses actual ow. Hence, the real-time data integration was
carried out with the movement of products between each warehouse location. The
Figure 4.
Data integration
design framework
Smart
warehouse
realization of the integration process was established using several combinations of tools,
software and hardware to collect data from products as physical objects to a network
platform.
3.6 Validity testing
Validity testing aimed to assess the research quality reected in the underlying construct in
fullling the requirements and deliverables. As suggested by Taherdoost (2018), content
validity is a highly recommended type of validity test with several technique options. Some
of the mentioned techniques included a literature review, performing expert panels, CV ratio
(CVR) or Q-sorting. Content validity commonly relies on the expertsjudgment in the eld
(Mohajan, 2017). In this study, a literature review was used as a tool to support validity
testing. A consecutive assessment based on semi-structured interviews with the experts was
also performed to rene the real-time data integration design.
3.7 Interpretation
Interpretation refers to the process of reporting the analysis from the constructed design and
research. The content of the analysis is discussed explicitly in Section 4. The interpretation
involved a means of drawing inferences and data presentation in the forms of a graph, gure
or table to illustrate, recap and evaluate thedesign of a real-time data integration process.
4. Results and discussion
In each area of the warehouse, data was generated and shared between different locations.
Data from each site were collected in one repository to enabling data sharing and converting
data into information and knowledge. The data was raised in a single location called the
database. The database is electronically storing the homogenous data from different places
and various time details based on data classication from many time ranges in a computer
system. Data stored in the database can be further displayed to enable data visibility and
goods movement in the warehouse. The integrated data stored in the database could also be
analyzed using data analytics tools such as Power BI, KNIME and Excel.
The overall picture of the requirements and process of real-time data integration is
displayed in Figure 5. The following section details the procedures of creating real-time data
integration and data ow from when the data is obtained until it is stored. Besides, this
section focuses on what tools and software were chosen to create a shared point system and
create a real-time data integration framework.
4.1 Data scanning
The automation of the data scanning process was accomplished by using RFID handheld
readers to scan many products simultaneously from a specic distance. RFID handheld
scanner was chosen because of its high mobility and lightweight. The RFID scanner was
required to speed up the process of data scanning and converting the data into electronic
format. The source of data came from scanning using a Bluebird RFID handheld scanner.
RFID scanner must be congurated with its application every time the scanning process
would take place. The employee in charge of each warehouse location would scan the
product to tag the arrival time. The scanner generated data in the form of a universally
unique identier (UUID) number. Each UUID number belonged to one unique and specic
product. Apart from the scanning process, each product was labeled using RFID Tags
beforehand. The RFID scanners function was to detect and read data. In data collection, the
scanner was benecial to read a massive amount of data in such a shorttime.
IJPCC
4.2 Transitory data storing
The RFID handheld scanner had an RFID application. The RFID application was mainly
used to store the read data, but it could also be used to write code further. The applications
stored data was in comma-separated values (CSV) le format, containing the products
scanned UUID number. The scanner and application were linked via Bluetooth. The RFID
application had to be congurated with the scanner before using it for the rst time by
simply clicking the BT ONbutton in the scanners application and connectivity button.
The reading result in the application consisted of the read UUID number, the frequency of
the same ID read for more than one time and the received signal strength indicator. The
closer a number to zero indicated a better signal. The Data stored in the application could be
accessed in the le manager located on the device used; the data stored in a different le
every time the scanning process was initiated.
4.3 Data to cloud synchronization
The data containing UUID numbers were sent to the Cloud directly from the RFID
application. The data was automatically synchronized to the Cloud without human
interference in the transfer process. The primary reason to place data in the Cloud was to
enable automatic synchronization of data from RFID application to the Cloud. Data would
automatically be updated every minute or every time new data was scanned. Besides,
storing data in the Cloud would facilitate an automatic data transfer to the visualization and
analysis tools carried out using Power BI. Hence, the data would be updated at any time to
provide real-time reports and analysis. In doing so, the synchronization created more
extensive accessibility of data. In each RFID device, a synchronization tool was installed to
facilitate linkage between the application and the internet to upload data to the Cloud. The
synchronization tool provided an ofine or online synchronization of data. Figure 6 shows
the logic of using the synchronization device to accommodate real-time data transfer in this
study.
Figure 5.
Real-time data
integration tools and
software
Smart
warehouse
Figure 7 displays the menu of the synchronization tools installed in each device. The
synchronization history recorded the synchronization processs time and date at each start
and end of the process. The status menu displays the recent change of synchronization,
where it indicates the latest means of synchronization. In this study, an OneDrive was used
as the location to store the data in the Cloud. The synchronization toolsstatus folder
showed the synchronizations duration, status and synchronization schedule.
The average duration for each synchronization process in this study is displayed in
Figure 8. The data synchronization duration presented in Figure 8 covered the operation of
multiple experiments date. The duration ranged between 0 and 10 s, which was the delay
time before the data was successfully uploaded in the Cloud. This result is considered
acceptable when compared to the actual duration result and human intervention factors.
However, a shorter delay with lower latency ispreferred.
Figure 6.
Real-time data
transfer to the cloud
Figure 7.
Synchronization tool
interface
IJPCC
4.4 Data-to-database importing process
Importing data to a database system is a part of real-time data integration processes. The
data was retrieved from the Cloud and transferred to the database. The time it takes for an
operator to import one CSV le to the database is showed in Figure 9. The average duration
it took to import single data is 9 s and with a delay range of 0 s<delay 13 s. The average
duration was then assigned as timing tolerances in the process of real-time integration in
this study. Time tolerance represents a limited deviation from nominal timing, referring to
constant feedback delays and synchronization (Tongren, 1998).
When retrieving data from the Cloud, the data was the most recent uploaded. The data
was later imported into the database through the import menu on the Cloud. Afterward, the
data would be automatically sorted in the database based on the data categorization. The
type of imported data remained as a CSV le format that contained UUID numbers. By
introducing data to the database, there were several added values including keeping the
data le in a structured format, documenting the data as le history that could be
appropriately tracked and protected and adding more information that was not initially
specied in the data from the scanning process such as date, customer and product type.
4.5 Database structure
The database was accessed through the control panel menu in the Cloud, mainly used to
display the warehouses structured information. The process of creating a database was
carried out through a database relational management system using MySQL. The database
Figure 8.
Data synch duration
3-Mar 5-Mar 12-Mar 13-Mar 19-Mar 20-Mar 27-Mar
0
2
4
6
8
10
12
Date
Duraon (s)
Data Synch Duraon
Duraon AVG
Figure 9.
Data-to-database
importing duration
0:00:00
0:00:04
0:00:09
0:00:13
0:00:17
123456789101112131415
Time (seconds)
Repeon Number
Data-to-Database Imporng Duraon
Trial 1 Trial 2 Trial 3 Trial 4
Trial 5 Trial 6 Average
Smart
warehouse
was developed by fullling the database name, username and password under MySQL in
the hosting accounts database submenu. Afterward, the database was successfully created.
To access the database, a user simply clicks the database, under the current MySQL
database and user, then select phpMyAdmin. Other menu options such as deleting, repair,
backup, change password and permission were also available under the same line as
phpMyAdmin.By clicking phpMyAdmin, an interface, as in Figure 10, would be shown.
The phpMyAdminis a designed software to manage the activity and administration of
MySQL Database over the Cloud. In this study, ve tables were containing the necessary
information that appeared in the Cloud. The database structure is one component of the
proposed framework to enable real-time data integration in an IoT-based warehouse. The
rst table (data_uuid) stored information of registered UUID placed on the moving product.
The input_data table contained the productsdata that had been selected for order
fulllment. Simultaneously, additional unique information was added according to order
fulllment; the labeling table stored a new recorded time of product arrival. The scan_wh1
and scan_wh2 enabled verication of arrival product from the previous location as it
provided quantity information. The tables name represented a products location; this was
initiated to easily recognize the product whereabout and record arrival time based on
location. The data in the table covered information such as time, quantity, demand and due
date.
4.6 Integration process workow
According to this study results, Real-time data integration processes in smart warehousing
could be generated into three signicant components: conguration, databasing and
transmission. Various data such as customer orders, product locations, products inbound
and outbound, shipment schedules, could be generated in the warehouse. The logic of the
data integration process in the case warehouse is presented in Figure 11. The integration
process was composed of ve fundamental processes, from which the involvement of
components in the process could be detected. Different data formats were generated from
each method. This subsequently needed to be processed into an understandable data format.
Figure 10.
phpMyAdmin
IJPCC
The conguration embraced the process of setting and arranging between single
or multiple technology tools such as hardware or software to permit a state of
integration within a specic range. Databasing is the process of storing data from
various locations and types into a single place and format. The heart of its function
lay in the structural approach of the data. Transmission represented the process of
data transfer between two or more different media, networks or electronic devices.
Understanding data transfer is a cornerstone to enable the data integration process.
The data was transmitted in the form of electronic signals that were later saved in the
designated format.
4.7 Data-shared point interface
Data-shared point interface (DPI) in this study refers to collecting internet pages that
structured data into specially formatted information. DPI was customized and
arranged to replicate the case warehouse operations in deploying information based
on warehouse locations. As for the motivation, the DPI architecture was structured
following the Flight Information Display System (FIDS) as requested by the case
warehouse management. DPI displayed warehouse information in electronic display
boards in a real-time manner to be visible for all warehouse operators who had no
access to their communication device at a specic moment. This interface provided
the visibility of interconnected data from various warehouse locations by providing
network-accessible details on the goods movement. This interfaces primary role was
to provide knowledge and information by transforming the unstructured data into
well-formatted data. This interfaces expected impactful outcome was to offer
accurate data visibility regarding the whereabouts and condition of the products,
further supporting the better operational decision-making process. The data-shared
point system played an essential role in enabling data sharing by providing a single
point of sharing multiples users could access. This interface was designed to have
complete visual information for specically identied end-users. However, all
warehouse stakeholders could view the information on this interface if needed. The
information would be displayed in the center location of the warehouse. However,
access to the interface platform was restricted to each warehouse chief to import the
unstructured data. The data-shared point interface was composed of six main menus
with different contexts and activities, as depicted in Figure 12.
4.8 Key factors of real-time data integration for the internet of things-based warehouse
Based on the results and discussion presented above, one can conclude that some factors need to
be considered when designing data integration in a real-time manner, namely, adopting suitable
technology, selecting a data center and the capability of data distribution. The adoption of proper
Figure 11.
Integration process
workow
Smart
warehouse
technology that supports real-time data synchronization would allow the user to receive data in a
short time frame such as seconds or milliseconds. The selection of technology should be adjusted
to t the warehouses size, operation activities and the desired level of integration. For example,
the technology used in this study was RFID and XML (Extensible Markup Language). The RFID
could provide Real-time Locating System (RTLSs) and automated the process of data scanning.
The XML is a programming language that facilitated multiples data sharing between the system.
The availability of a data center or database and its capacity must be adjusted to tdata
generated from the warehouse operations. Having the right size to store data is essential because
it will affect the database performance if the capacity is not within the normal range. Finally,
processing and distributing data across multiple sources and points are crucial in enabling real-
time data integration for IoT-based Warehouses. Real-time data integration is a complex process
that requires the comprehension of various programming languages. This could be achieved by
having a diverse group of people from different backgrounds works on the integration
collaboratively.
Two studies related to real-time data integration for IoT-based warehouse were carried out in
recent years. Lee et al. (2017) conducted a study to manage a warehouse for a low-volume, high
product mix scenario. Another study by Wu et al. (2020) was carried out for a third-party
company warehouse to manage 3PL automotive parts. The important difference between these
studies was compared to our study in Table 1. The three studies are case study-based research
that used RFID technology to implement each proposed framework. The difference lies in
selecting supporting technology used to complement the implementation and the scope of the
study.
Figure 12.
Data-shared point
menu and its data
context
IJPCC
Table 1.
Comparison with
other similar studies
Parameters This study Lee et al. (2017) Wu et al. (2020)
Study objectives To design and apply a
framework of data
integration, adopting the
IoT concept in enabling a
real-time data transfer and
sharing
To propose an Internet of
things (IoT)-based
warehouse management
system with an advanced
data analytical approach
using computational
intelligence techniques to
enable smart logistics
To provide a framework
system and workow to
achieve higher operational
efciency and eliminate
paper-based documentation
system
Scope Warehouse management
system for a double-labeling
product in a manufacturing
company
Warehouse management
system for a low-volume,
high product mix scenario
Warehouse management
system for a 3PL automotive
parts company
Methodological
standpoint
Case study Case study Case study
Background study Inability to obtain, share
and analyze real-time
information of warehouse
operations and high cost of
real-time data integration
software and solution
There is an increase of
complexity and variety of
customer orders and
inefcient and inaccurate
order picking process
The warehousing operations
still relying on paper for
guiding and recording and
information is not
distributed evenly within
different divisions or
companies
Adopted
technology
RFID technology (tag and
scanner), Cloud system,
Web technology
RFID technology, wireless
sensors, mobile apps
IoT enabled cyber-physical
system (RFID), wireless
communication technology
(Bluetooth) and Cloud
system
Result/practical
implementation
Provide groundwork for
exploring theoretical
framework, guidelines for
developing more accurate
and timely data for enabling
smart warehouse and
framework for the more
economical application of
IoT-based warehouse
adoption
Increase data visibility in
performing seamless
operations and decision-
making processes in the
warehouse
A framework of proposed
IoT-based warehouse
management system
Fuzzy logic technique was
used to control the picking
process
Improve the efciency of
the receiving process and
order picking
Enhance the order fulll
performance (order ll rate
and order accuracy)
Provide conguration of the
proposed system
Provide workow of the
proposed system
Enable paperless operations
Provide challenges from
managerial, technical and
workforces point of view
Limitation study Human intervention was not
fully eliminated
The routing and storage
policies were not discussed
in detail
Missing details of correct
goodscode to maintain a
user-friendly interface
Future research Eliminate human
intervention and perform a
longitudinal study to
improve the studys
ndings and increase
sampled products
Application of fuzzy logic
for batch the zone,
sequential zone and wave
picking approaches
involving articial
intelligence and smart
robotics will further
improve warehouse
efciency
To furtherly integrate more
wireless transmitting
technology to improve the
reliability of the proposed
system
Smart
warehouse
5. Conclusions
The complexity of customer behavior and the digitalization of operations have driven the
need for warehousing transformation. The complexity of back and forth communication,
high latency of product rate and insufcient control of goods could be addressed with real-
time data integration. Real-time data integration increases data visibility in performing
seamless operations and decision-making processes. This study presented a framework for
designing and applying real-time data integration processes in an IoT-based warehouse
using RFID technology. The study found that data integration plays a signicant role in
structuring assorted data in the IoT-based warehouse.
Furthermore, having real-time visibility of integrated data enables quick response and
decision-making processes to overcome operational issues such as delays, poor tracking and
communication. In this study, the data went through several methods before it became
valuable information. Variation was apparent in the process of synchronization of data from
the RFID application to the Cloud. The divergence between the upper and lower limits was
between 0 and 7 s. The length of duration was affected by the size of the data and the
internet connection. The average time for transferring data to the database was 9 s, with a
delay range of 0 s<delay 13 s. In this study, the design of the shared-point interface was
also presented and discussed. This interface enabled the visibility of interconnected data
from various case warehouse locations by providing network-accessible information on the
goods movement. This interfaces primary role was to provide knowledge and information
by transforming the unstructured data into well-formatted data. The initial step toward real-
time integrated data was identifying and reengineering the warehouse processes, followed
by designing a proper infrastructure of real-time data integration. The study concluded that
real-time data integration processes in IoT-based warehousing could be generated into three
signicant components: conguration, databasing and transmission. Real-time data
integration could be executed for as long as there is a data input process and the data ow is
maintained between interface and software.
Theoretical and practical implications
The design and application of real-time data integration processes and the creation of data-
shared point systems in this study add to the body of knowledge of smart warehousing,
Industry 4.0 and the digitalization of supply chain management. The research at hand
provides the groundwork for researchers to explore the proposed theoretical framework and
develop it further to increase inventory management efciency of warehouse operations.
From a practical perspective, 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. The proposed framework of the IoT-based
warehouse in this study should help practitioners in adopting a more feasible and
economical application in acquiring the data integration software.
Limitations and future research
The study could be enhanced by performing a longitudinal study to improve the studys
ndings and increase sampled products. While the status of real-time data integration was
ensured in this study to maintain the productsvisibility and shared-point system creation,
there is still a human intervention in one of the processes of real-time data integration.
Further development is required to eliminate human intervention, even if it is minimal.
The current proposed framework involved six different processes in deploying the
information. The method covered reading, storing and processing, synchronizing and importing.
To reach a better level in allowing the data integration process in a real-time manner and most
IJPCC
importantly, to eliminate more delays, further research should be conducted. First, develop
customized mobile applications that support tools between the RFID tags reading result and
database. The customized mobile applications would allow the process of data transfer without
having to have human interference. With that in mind, the synchronization process between
Cloud and database could be facilitated and replace RFID applications. Second, further research
could be conducted to reduce the human intervention rate by using synchronization platforms
such as Zapier or Skyvia. Using such synchronization platforms, the data transfer could be
executed automatically from the Cloud to the database.
References
Aamer, A.M. (2018a), An application of lean assessment in a cross-docking distribution center,
Proceedings of the International Conference on Industrial Engineering and Operations
Management, 2018-March, pp. 976-984.
Aamer, A.M. (2018b), Outsourcing in non-developed supplier markets: a lean thinking approach,
International Journal of Production Research, Vol. 56 No. 18, pp. 6048-6065, available at: https://
doi.org/10.1080/00207543.2018.1465609
Aamer, A.M. (2018c), Distribution center capacity analysis in stochastic environment: an application
of value stream analysis and monte carlo simulation,IEEE International Conference on
Industrial Engineering and Engineering Management, 2017-December, available at: https://doi.
org/10.1109/IEEM.2017.8290122
Abad, E., Zampolli, S., Marco, S., Scorzoni, A., Mazzolai, B., Juarros, A., ... Sayhan, I. (2007), Flexible
tag microlab development: gas sensors integration in RFID exible tags for food logistic,
Sensors and Actuators B: Chemical, Vol. 127 No. 1, pp. 2-7, available at: https://doi.org/10.1016/j.
s.2007.07.007
Alyahya, S., Wang, Q. and Bennett, N. (2016), Application and integration of an RFID-enabled
warehousing management system a feasibility study,Journal of Industrial Information
Integration, Vol. 4, pp. 15-25, available at: https://doi.org/10.1016/j.jii.2016.08.001
Atieh, A.M., Kaylani, H., Al-Abdallat, Y., Qaderi, A., Ghoul, L., Jaradat, L. and Hdairis, I. (2016),
Performance improvement of inventory management system processes by an automated
warehouse management system,Procedia CIRP, Vol. 41, pp. 568-572, available at: https://doi.
org/10.1016/j.procir.2015.12.122
Baker, T.L. (1994), Doing Social Research (2nd Edn.), McGraw-Hill Inc., New York.
Bicevska, Z. and Oditis, I. (2016), Towards NoSQL-based data warehouse solutions,Procedia
Computer Science, Vol. 104, pp. 104-111, available at: https://doi.org/10.1016/j.procs.2017.01.080
Biswal, A.K., Jenamani, M. and Kumar, S.K. (2018), Warehouse efciency improvement using RFID in
a humanitarian supply chain: implications for indian food security system,Transportation
Research Part E: Logistics and Transportation Review, Vol. 109, pp. 205-224, available at: https://
doi.org/10.1016/j.tre.2017.11.010
Boysen, N., de Koster, R. and Weidinger, F. (2019), Warehousing in the e-commerce era: a survey,
European Journal of Operational Research, Vol. 277 No. 2, pp. 396-411, available at: https://doi.
org/10.1016/j.ejor.2018.08.023
Buntak, K., Kova
ci
c, M. and Mutavdžija, M. (2019), Internet of Things and Smart Warehouses as the
Future of Logistics, Vol. 6168, pp. 248-253.
Burmester, M., Munilla, J., Ortiz, A. and Caballero-Gil, P. (2017), An RFID-based smart structure for the
supply chain: resilient scanning proofs and ownership transfer with positive secrecy capacity
channels,Sensors ( Sensors), Vol. 17 No. 7, pp. 1-20, available at: https://doi.org/10.3390/s17071562
Calvanese, D., Giacomo, G.D.E., Lenzerini, M. and Rosati, R. (2001), Data integration in data
warehousing,International Journal of Cooperative Information Systems, Vol. 10 No. 3, pp. 237-271.
Smart
warehouse
Chang, C.H., Jiang, F.C., Yang, C.T. and Chou, S.C. (2019), On construction of a big data warehouse
accessing platform for campus power usages,Journal of Parallel and Distributed Computing,
Vol. 133, pp. 40-50, available at: https://doi.org/10.1016/j.jpdc.2019.05.011
Chau, K.W., Anson, M., Ying, C. and Jianping, Z. (2013), Integration of data warehouse into knowledge-
based system on construction management decision making,Hkie Transactions, Vol. 10 No. 1,
pp. 37-41. https://doi.org/10.1080/1023697X.2003.10667895
Chen, J.C., Cheng, C.H., Huang, P.B., Wang, K.J., Huang, C.J. and Ting, T.C. (2013), Warehouse management
with lean and RFID application: a case study,The International Journal of Advanced Manufacturing
Technology, Vol. 69 No. 1-4, pp. 531-542, available at: https://doi.org/10.1007/s00170-013-5016-8
Ding, Y., Jin, M., Li, S. and Feng, D. (2020), Smart logistics based on the internet of things technology:
an overview,International Journal of Logistics Research and Applications, pp. 1-23, available at:
https://doi.org/10.1080/13675567.2020.1757053
Ellis, S.E. and Leek, J.T. (2018), How to share data for collaboration,The American Statistician,
Vol. 72 No. 1, pp. 53-57, available at: https://doi.org/10.1080/00031305.2017.1375987
Erkayaoglu, M. and Dessureault, S. (2019), Improving mine-to-mill by data warehousing and
data mining,International Journal of Mining, Reclamation and Environment, Vol. 33 No. 6,
pp. 409-424, available at: https://doi.org/10.1080/17480930.2018.1496885
Fawcett, S.E., Osterhaus, P., Magnan, G.M., Brau, J.C. and McCarter, M.W. (2007), Information sharing
and supply chain performance: the role of connectivity and willingness,Supply Chain
Management: An International Journal, Vol. 12 No. 5, pp. 358-368, available at: https://doi.org/
10.1108/13598540710776935
Fu, X. Wu, K. Gong, X. and Xu, L. (2011), Procedia engineering on data integration, warehousing and
software reuse in the construction of digital campus: a review on performance, available at:
https://doi.org/10.1016/j.proeng.2011.08.583
García, A., Chang, Y.,Abarca, A. and Oh, C. (2007), RFID enhanced MAS for warehouse management,
5567, available at: https://doi.org/10.1080/13675560701427379
Halawa, F., Dauod, H., Lee, I.G., Li, Y., Yoon, S.W. and Chung, S.H. (2019), Introduction of a real time
location system to enhance the warehouse safety and operational efciency,International
Journal of Production Economics, Vol. 224, available at: https://doi.org/10.1016/j.ijpe.2019.107541
Hamdy, W., Mostafa, N. and Elawady, H. (2018), Towards a smart warehouse management system
towards a smart warehouse management system.
Hinkka, V., Holmström, J. and Främling, K. (2012), RFID tracking in the book supply chain: the
transition from postponed to speculative tagging,International Journal of Logistics Research and
Applications, Vol. 15 No. 3, pp. 199-214, available at: https://doi.org/10.1080/13675567.2012.709834
Huang, Z., Chen, L. and Frolick, M.N. (2016), Integrating Web- Based data into A, available at: https://
doi.org/10.1201/1078/43199.19.1.20020101/31473.4
Huang, Z., Chen, L.D. and Frolick, M.N. (2002), Integrating web-based data into a data warehouse,
Information Systems Management, Taylor and Francis Group, Vol. 19 No. 1, pp. 23-34.
Huang, B., Wang, W., Ren, S., Zhong, R.Y. and Jiang, J. (2019), A proactive task dispatching method based
on future bottleneck prediction for the smart factory,International Journal of Computer Integrated
Manufacturing, Vol. 32 No. 3, pp. 278-293, available at: https://doi.org/10.1080/0951192X.2019.1571241
In, J. (2017), Introduction objectives of a pilot study statistical round,Korean Journal of Anesthesiology,Vol.
70 No. 6, pp. 601-605, available at: https://doi.org/10.4097/kjae.2017.70.6.601
Jalali, M.S., Kaiser, J.P., Siegel, M. and Madnick, S. (2019), The internet of things promises new benets
and risks: a systematic analysis of adoption dynamics of IoT products,IEEE Security and Privacy,
Vol. 17 No. 2, pp. 39-48, available at: https://doi.org/10.1109/MSEC.2018.2888780
Jermsittiparsert, K., Sutduean, J. and Sriyakul, T. (2019), Role of warehouse attributes in supply chain
warehouse efciency in Indonesia,International Journal of Innovation, Creativity and Change,Vol.5
No. 2, pp. 786-802.
IJPCC
Kamali, A. (2020), Smart warehouse vs. Traditional Warehouse Review,CiiT International Journal
of Automation and Autonomous System, Vol. 11 No. 1.
Kern, R., Stolarczyk, T. and Nguyen, N.T. (2013), Expert systems with applications a formal
framework for query decomposition and knowledge integration in data warehouse federations,
Expert Systems with Applications, Vol. 40, pp. 2592-2606, available at: https://doi.org/10.1016/j.
eswa.2012.10.060
Khan, A., Ehsan, N., Mirza, E. and Zahoor, S. (2012), Integration between customer relationship
management (CRM) and data warehousing,Procedia Technology, Vol. 1, pp. 239-249, https://
doi. org/10.1016/j.protcy.2012.02.050
Lee, C.K.M., Lv, Y., Ng, K.K.H., Ho, W., Choy, K.L. and Lv, Y. (2017), Design and application of internet
of things- based warehouse management system for smart logistics,International Journal of
Production Research, Vol. 7543, available at: https://doi.org/10.1080/00207543.2017.1394592
Lee, Y.M., Cheng, F. and Leung, Y.T. (2009), A quantitative view on how RFID can improve inventory
management in a supply chain,International Journal of Logistics Research and Applications,
Vol. 12 No. 1, pp. 23-43, available at: https://doi.org/10.1080/13675560802141788
Leng, J., Yan, D., Liu, Q., Zhang, H., Zhao, G., Wei, L., ... Chen, X. (2019), Digital twin-driven joint
optimisation of packing and storage assignment in large-scale automated high-rise warehouse
product-service system,International Journal of Computer Integrated Manufacturing, pp. 1-18,
available at: https://doi.org/10.1080/0951192X.2019.1667032
Li, X., Zhao, N., Jin, R., Liu, S., Sun, X., Wen, X., ...Zhou, Y. (2019), Internet of things to network smart
devices for ecosystem monitoring,Science Bulletin, Vol. 64 No. 17, pp. 1234-1245, available at:
https://doi.org/10.1016/j.scib.2019.07.004
Lototsky, V. (2019), ScienceDirect model model of of the the automated automated warehouse warehouse
management management and and forecasting forecasting model system of the automated
warehouse management and forecasting in the conditions of transition to industry warehouse,IFAC-
PapersOnLine, Vol. 52 No. 13, pp. 78-82, available at: https://doi.org/10.1016/j.ifacol.2019.11.137
Mahroof, K. (2019), International journal of information management a human-centric perspective
exploring the readiness towards smart warehousing: the case of a large retail distribution
warehouse,International Journal of Information Management, Vol. 45, pp. 176-190, available at:
https://doi.org/10.1016/j.ijinfomgt.2018.11.008
Malmqvist, J., Hellberg, K., Möllås, G., Rose, R. and Shevlin, M. (2019), Conducting the pilot study: a
neglected part of the research process? Methodological ndings supporting the importance of
piloting in qualitative research studies,International Journal of Qualitative Methods, Vol. 18,
pp. 1-11, available at: https://doi.org/10.1177/1609406919878341
Mitchell, E.M. and Kovach, J.V. (2016), Improving supply chain information sharing using design
for six sigma,European Research on Management and Business Economics,Vol.22No.3,
pp. 147-154, available at: https://doi.org/10.1016/j.iedee.2015.02.002
Mohajan, H.K. (2017), Two criteria for good measurements in research: validity and reliability,
Annals of Spiru Haret University. Economic Series, Vol. 17 No. 4, pp. 59-82, available at: https://
doi.org/10.26458/1746
Mostafa, N., Hamdy, W. and Alawady, H. (2019), Impacts of internet of things on supply chains: a
framework for warehousing,Social Sciences, Vol. 8 No. 3, available at: https://doi.org/10.3390/
socsci8030084
Mourtzis, D., Samothrakis, V., Zogopoulos, V. and Vlachou, E. (2019), Warehouse design and operation
using augmented reality technology: a papermaking industry case study,Procedia CIRP, Vol.
79, pp. 574-579, available at: https://doi.org/10.1016/j.procir.2019.02.097
Pti
cek, M., Vrdoljak, B. and Guli
c, M. (2019), The potential of semantic paradigm in warehousing of
big data,Automatika, Vol. 60 No. 4, pp. 386-396, available at: https://doi.org/10.1080/
00051144.2019.1630582
Smart
warehouse
Rahman, N. (2016), An empirical study of data warehouse implementation effectiveness, available at:
https://doi.org/10.1080/17509653.2015.1113394
Reaidy, P.J., Gunasekaran, A. and Spalanzani, A. (2015), Bottom-up approach based on internet of
things for order fulllment in a collaborative warehousing environment,International Journal of
Production Economics, Vol. 159, pp. 29-40, available at: https://doi.org/10.1016/j.ijpe.2014.02.017
Ren, S., Zhang, Y., Liu, Y., Sakao, T., Huisingh, D. and Almeida, C.M.V.B. (2019), A comprehensive
review of big data analytics throughout product lifecycle to support sustainable smart
manufacturing: a framework, challenges and future research directions,Journal of Cleaner
Production, Vol.210, pp. 1343-1365, available at: https://doi.org/10.1016/j.jclepro.2018.11.025
Rizzi, A. (2006), Efciency improvement in manual warehouses through ERP systems implementation
and redesign of the logistics processes.
Rondero, G., Lizette, C., Martinez-Flores, Luis, J., Smith, N.R. and Morales, C. (2019), Digital supply
chain model in industry 4.0,Journal of Manufacturing Technology Management, Vol. 31 No. 5,
available at: https://doi.org/10.1108/JMTM-08-2018-0280
Rosenkranz, C., Holten, R., Räkers, M. and Behrmann, W. (2017), Supporting the design of data
integration requirements during the development of data warehouses: a communication theory-
based approach,European Journal of Information Systems, Vol. 26 No. 1, pp. 84-115, available
at: https://doi.org/10.1057/ejis.2015.22
Sainathuni, B., Parikh, P.J., Zhang, X. and Kong, N. (2014), The warehouse-inventory-transportation
problem for supply chains,European Journal of Operational Research, Vol. 237 No. 2, pp. 690-700,
available at: https://doi.org/10.1016/j.ejor.2014.02.007
Santoso, L.W. and Yulia, (2017), Data warehouse with big data technology for higher education,Procedia
Computer Science, Vol. 124, pp. 93-99, available at: https://doi.org/10.1016/j.procs.2017.12.134
Shivtare, P.S. and Shelar, P.P. (2015), Data warehouse with data integration: problems and solution, pp. 67-71.
Sileyew, K.J. (2016), We are IntechOpen, the worlds leading publisher of open access books built by scientists,
for scientists TOP 1%,Intech, i(Tourism),Vol.13,availableat:https://doi.org/10.5772/57353
Srinivasan, R. and Lohith, C.P. (2017), Strategic marketing and innovation for indian MSMEs,
Strategic Marketing and Innovation for Indian MSMEs, pp. 31-39, available at: https://doi.org/
10.1007/978-981-10-3590-6
Sydänheimo, L., Kivikoski, M. and Penttilä, K. (2006), Effect of item identierslength on passive radio
frequency identication technology with supply chain applications,International Journal of
Logistics Research and Applications, Vol. 9 No. 2, pp. 143-156, available at: https://doi.org/
10.1080/13675560600630818
Taherdoost, H. (2018), Sampling methods in research methodology; how to choose a sampling technique for
research,SSRN Electronic Journal, available at: https://doi.org/10.2139/ssrn.3205035
Tantalaki, N., Souravlas, S. and Roumeliotis, M. (2019), A review on big data real-time stream processing
and its scheduling techniques,International Journal of Parallel, Emergent and Distributed Systems,
Vol. 35 No. 5, pp. 1-31, available at: https://doi.org/10.1080/17445760.2019.1585848
Teijlingen, V. and Hundley, V. (2002), The importance of pilot studies,Nursing Standard ( Standard),
Vol. 16 No. 40, pp. 33-36, available at: https://doi.org/10.7748/ns2002.06.16.40.33.c3214
Tejesh, B.S.S. and Neeraja, S. (2018), Warehouse inventory management system using IoT and open source
framework,Alexandria Engineering Journal, Vol. 57 No. 4, available at: https://doi.org/10.1016/j.
aej.2018.02.003
Tongren, M. (1998), Fundamentals of implementing real-time control applications in distributed
computer systems,Real_Time Systems, Vol.250, pp. 219-250.
Trab, S., Bajic, E., Zouinkhi, A., Abdelkrim, M.N., Chekir, H. and Ltaief, R.H. (2016), A communicating
objects approach for smart logistics and safety issues in warehouses, available at: https://doi.
org/10.1177/1063293X16672508
IJPCC
Trappey, A.J.C., Trappey, C.V., Fan, C.Y., Hsu, A.P.T., Li, X.K. and Lee, I.J.Y. (2017), IoT patent
roadmap for smart logistic service provision in the context of industry 4.0,Journal of the
Chinese Institute of Engineers, Vol. 40 No. 7, pp. 593-602, available at: https://doi.org/10.1080/
02533839.2017.1362325
Vicuna, P., Mudigonda, S., Kamga, C., Mouskos, K. and Ukegbu, C. (2019), A generic and exible
geospatial data warehousing and analysis framework for transportation performance
measurement in smart connected cities,Procedia Computer Science, Vol. 155 No. 2018,
pp. 226-233, available at: https://doi.org/10.1016/j.procs.2019.08.033
Wang, Q., McIntosh, R. and Brain, M. (2010), A new-generation automated warehousing capability,
International Journal of Computer Integrated Manufacturing, Vol. 23 No. 6, pp. 565-573,
available at: https://doi.org/10.1080/09511921003706215
Wu, W., Cheung, C., Lo, S.Y., Zhong, R.Y. and Huang, G.Q. (2020), An IoT-enabled real-time logistics
system for a third party company: a case study,Procedia Manufacturing, Vol. 49, pp. 16-23.doi,
doi: 10.1016/j.promfg.2020.06.005.
Xiao, H., Bo, H. and Chen, W. (2017), Food warehousing simulation by RFID technology,Journal of
Interdisciplinary Mathematics, Vol. 20 No. 1, pp. 112-124, available at: https://doi.org/10.1080/
09720502.2016.1259766
Yaw Wong, C. and McFarlane, D. (2007), Radio frequency identication data capture and its impact on
shelf replenishment,International Journal of Logistics Research and Applications, Vol. 10 No. 1,
pp. 71-93, available at: https://doi.org/10.1080/13675560600813117
Yerpude, S. and Singhal, T.K. (2018), SMART warehouse with internet of things supported inventory
management SMART warehouse with internet of things supported inventory management
system,International Journal of Pure and Applied Mathematics, Vol. 118.
Zhong, R.Y., Xu, X. and Wang, L. (2017), IoT-enabled smart factory visibility and traceability using
laser-scanners,Procedia Manufacturing, Vol. 10, pp. 1-14, available at: https://doi.org/10.1016/j.
promfg.2017.07.103
Zhou, W., Piramuthu, S., Chu, F. and Chu, C. (2017), RFID-enabled exible warehousing,Decision
Support Systems, Vol. 98, pp. 99-112, available at: https://doi.org/10.1016/j.dss.2017.05.002
Zhong, R.Y., Li, Z., Pang, L.Y., Pan, Y., Qu, T. and Huang, G.Q. (2013), RFID-enabled real-time
advanced planning and scheduling shell for production decision making,International Journal
of Computer Integrated Manufacturing, Vol. 26 No. 7, pp. 649-662, available at: https://doi.org/
10.1080/0951192X.2012.749532
Corresponding author
Ammar Aamer can be contacted at: a.aamer@northeastern.edu
For instructions on how to order reprints of this article, please visit our website:
www.emeraldgrouppublishing.com/licensing/reprints.htm
Or contact us for further details: permissions@emeraldinsight.com
Smart
warehouse
... These technologies can be applied to logistics warehouses and require the integration of IoT technologies. This not only increases the efficiency of depositing and retrieving specific objects, but also improves the overall management of items in the warehouse [42]. Nevertheless, such research is generally performed separately, which likely hinders the technologies from reaching their full potential [43]. ...
... A digital twinning of a smart warehouse involves the interconnection of physical devices, machines, equipment, and sensors, including temperature, humidity, collision avoidance system sensors, etc., through an IoT network. Smart warehouses feature cloud computing workstations, radio frequency identification (RFID) or barcode systems, industrial robot arms, and unmanned aerial vehicles (UAVs) [42,51], as well as IoT sensors, including temperature, humidity, collision avoidance systems, etc. Cloud servers and MR devices convey the information using a message bus over a wide-area network (WAN), which includes typical IoT communication networks such as wireless local area networks (WLAN) and mobile wireless networks (5G). In the digital twinning of a smart warehouse, the physical devices, machines, equipment and sensors are interconnected through the IoT network. ...
... Only a few studies have considered the problem of two diferent warehouses in the same facility [31]. Te study by Dessouky and Wilson [32] attempted to integrate two warehouses into the system by developing a robotic assembly system that integrates with an AS/RS. ...
Article
Full-text available
There can be two automated storage and retrieval systems (AS/RS) in the same distribution center: one for pallets and the other for cases. Full pallets or half-full pallets are depalletized and moved to the case storage system. The number of cases depalletized daily for an item needs to be determined based on the average daily demand for that item. Too many depalletized cases ahead of time will inflate the required storage capacity of the case storage system. On the other hand, depalletizing only the necessary cases day by day might lead to too frequent material flow, and therefore more stacker cranes are necessary. Therefore, the number of depalletized pallets affects the number and utilization of stacker cranes in the pallet storage system. It also affects the needed space in the case storage system. This study determines the most efficient number of depalletized cases for three classes of items (A, B, and C), which are determined based on their daily demand. This is done using three scenarios. The total cost is minimized, considering the utilization of the two storage systems. More investigation was done for B items, which have daily demand levels of one layer of cases or more, but less than pallet size. First, analytical equations were formulated to model the system. The model was solved using a genetic algorithm (GA) with special chromosome representations. Results showed that B items can be grouped into two subgroups that are replenished based on two different material flow scenarios. Items with relatively large demand levels have scenario 3 as the optimal one. Results also showed that the model reduces both total costs and stacker crane utilization while improving system flexibility.
... Abdul Rehman et al. [43] state the benefits of IoT in logistics activities as facilitation of data exchange, communication between elements, and remote monitoring. Sahara et al. [44] explain that enhanced control, improved performance in the supply chain, and increased customer satisfaction are among the main benefits of IoT. Lastra et al. [45] claim that [46] outline that technology such as IoT, with the ability to sense and communicate, leads to measurement accuracy and cost reduction in logistics activities related to spare parts supply. ...
Article
Full-text available
Background: Spare parts warehousing in the oil and gas industry is essential for offshore production. With the introduction of Industry 4.0 and its subsequent technological tools, new functions are enabled in industrial logistics activities. Efficiency, visibility, optimization, and productivity are often mentioned as benefits of successful Industry 4.0 technology implementation in logistics activities. In this paper, the implementation of Industry 4.0 technologies such as the Industrial Internet of Things (IIoT) in spare parts warehousing in the oil and gas industry is studied. Method: 133 peer-reviewed journal publications indexed in Scopus and Web of Science are analyzed in a systematic literature review. The review is structured as frequency and content analysis. Aim: As there is limited research on this specific topic, the aim is for this paper to be a theoretical foundation that assists the industry with future solutions. Results: The list of benefits of implementation gathered from the literature is comprehensive. However, the list of challenges is particularly pertinent to the oil and gas industry and indicates a strong inclination towards limited and controlled implementation of some technologies. The safety demands of the industry mean there are many limitations to implementation currently. Conclusions: This paper reflects on the results, identifies research gaps, and gives proposals for future research.
... There are a number of studies that aim to integrate data from different sources at low cost. They cover the manual import of data into a single database (Wilamowska et al. 2013;Mahmoodpour and Lobov 2019), using a remote script to combine data from different sources (Coronado et al. 2018), and facilitating data warehousing by using a graphical tool (Hilario et al. 2021) or limiting the structure and variety of data (Sahara and Aamer 2021). Apart from that, methods of integrating data of mechanical parts can also be used for integrating data of digital systems in a low-cost manner, for example, by converting data to a standard format (Mostefai, Bouras, and Batouche 2005) or using a data model that includes the semantics shared between digital systems (Feng and Yang 1995). ...
Article
Full-text available
Integration involves the systematic linking of system components, functions and solutions. For digital systems comprising low-cost components, integration enables the sharing of resources and allows them to benefit from each others functionalities. However, in general integrating low-cost systems can be difficult, since data is heterogeneous and distributed over multiple sources and there is no common interface to interact with resources. This study proposes the use of reference architectures as a means of supporting such integration needs. Reference architectures are models that provide a structured template with common terminology and support integration through a systematic, repeatable framework. In this paper, we evaluate strategies to integrate digital systems formed from the same reference architecture. We first select three reference architectures and use them to conceptually design the integration of two low-cost digital systems based on different strategies. Then, the conceptually designed strategies are evaluated in terms of their effectiveness to be realised at low cost. Finally, the most effective strategy is deployed for an industrially relevant application, and validated by comparing its effectiveness to a system architecture driven integration. The evaluation results suggest that coordinators with a common service bus and virtual data integration are effective for integrating low-cost digital systems.
... With the evolving industry 4.0 technologies, data analytics has gained immense importance in firm's decision-making (Aamer & Sahara, 2021;Mubarak & Petraite, 2020). Data analytics revamp the firms' approach to generate and use data for improved business performance (Babu et al., 2021). ...
Article
Full-text available
This paper aims to assess the effects of absorptive capacity and analytics competence on sustainable economic performance. Data is gathered from 237 micro, small and medium enterprises (MSMEs) to examine the relationship between the research constructs using the structural equation modelling approach. The study supports the hypothesis that absorptive capacity directly affects sustainable economic performance and indirectly influences sustainable economic performance through risk resilience. On the other hand, analytics competence positively influences risk resilience but does not affect sustainable economic performance. The study adds to the body of knowledge by demonstrating the mediating role of risk resilience in absorptive capacity and sustainable economic performance relationships. Findings also indicate that risk resilience can be enhanced by developing absorptive capacity and analytics competencies in firms. The study discusses valuable implications for practitioners and scholars working in the field of risk resilience and analytics competence.
... However, in smart warehouses, the integration of the Internet of Things (IoT) employs communication protocols to connect every section and item. This results in seamless communication within the warehouse, ensuring that information is transmitted and received promptly [4]. ...
... Data warehouses are powerful tools that enable businesses to store and analyze large amounts of data. In the banking [9], health [10], [11], marine sector [12], and Internet of Things (IoT) industries [13], data warehouses can be used to improve efficiency and accuracy as well as gain insights into customer behavior and market trends. ...
Article
Full-text available
The Indonesian government has implemented a data warehouse named One Data (Satu Data) Indonesia (ODI) to support its operations since 2019. However, the implementation of this concept in universities has been limited, with only a few universities adopting it. Telkom University is one of the few universities in Indonesia that has already taken steps to implement ODI at the university level. The adoption of ODI at Telkom University is known as the One Data Telkom University (ODTU) project. This project aims to create a platform for universities to share data and collaborate more effectively. This paper thoroughly examines the implementation of the ODI policy and data warehouse framework at Telkom University, focusing on the ODTU data warehouse design and architecture. This paper discusses the implementation of ODTU into several applications, including the One Data Portal, One Data Dashboard, and One Data Market. Moreover, it identifies the challenges encountered during the implementation process, such as data integration, data privacy and security, standardized data models, and the promotion of a shared vision among stakeholders with varying levels of data literacy. Our analysis results demonstrate the effectiveness of the ODTU framework in improving data management practices at Telkom University. The customer satisfaction index (CSI) shows that across key reliability, assurance, and responsiveness measures, Telkom University experienced average score improvements of 3-6% after implementing ODTU. This study contributes to the existing literature on ODI policy adoption in the context of higher education institutions, providing insights for institutions seeking to improve their data management practices.
... Data warehouses are powerful tools that enable businesses to store and analyze large amounts of data. In the banking [9], health [10], [11], marine sector [12], and Internet of Things (IoT) industries [13], data warehouses can be used to improve efficiency and accuracy and gain insights into customer behavior and market trends. ...
Article
Full-text available
The Indonesian government has implemented a data warehouse named One Data (Satu Data) Indonesia (ODI) to support its operations since 2019. Unfortunately, implementing this concept in universities has been limited, with only a few universities adopting it. Telkom University is one of the few universities in Indonesia that is already taking steps to implement ODI at the university level. The adoption of ODI at Telkom University is known as the One Data Telkom University (ODTU) project. This project aims to create a platform for universities to share data and collaborate more effectively. This paper thoroughly examines the implementation of the ODI policy and data warehouse framework at Telkom University, focusing on the ODTU data warehouse design and architecture. This paper discusses the implementation of ODTU into several applications, including the One Data Portal, One Data Dashboard, and One Data Market. Moreover, the paper identifies the challenges encountered during the implementation process, such as data integration, data privacy and security, standardized data model, and promoting a shared vision among stakeholders with varying levels of data literacy. Our analysis results demonstrate the ODTU framework's effectiveness in improving data management practices at Telkom University. The customer satisfaction index (CSI) shows that across key reliability, assurance, and responsiveness measures, Telkom University saw average score improvements of 3-6% after implementing ODTU. This study contributes to the existing literature on ODI policy adoption in the context of higher education institutions, providing insights for institutions seeking to improve their data management practices.
Article
Purpose: Process digitization and artificial intelligence are the needs of today's industry. The Fourth Industrial Revolution along with the concept of Industry 4.0 provides a huge opportunity for the development of many industries. Industry 4.0 imposes high demands on production and logistics in cyber-physical systems. Therefore, the primary objective of this publication is to present the concept of Industry 4.0, with particular emphasis on the impact of its technological solutions on the process of distribution of industrial goods. The challenges and benefits of the concept of Industry 4.0 are also presented in the article. Design/methodology/approach: The work consists of two parts, the review of literature and the research part. The theoretical part presents the impact of technological solutions on the evolution of the distribution process. The empirical part focuses on the importance of technological solutions in the segment of Polish steel product distributors. In Poland, 9.7 million tons of steel is produced on average annually. In the world, according to the analyzes of the World Steel Association, 1781.5 million tons of steel was produced in 2022. Steel is an important construction and industrial material used in the production of cars, machines, ships, appliances, etc. Research was realized in Polish sector of companies. The questionnaire was build according the structure of Industry 4.0 based on pillars. In the questionnaire was used Likert scale from 1 to 5 with 5 being the highest. Findings: Steel sector companies are aware of the importance of the technology of Industry 4.0 in improving the course of the process and communication with the market. The respondents highly assessed the importance of the pillars of Industry 4.0 in the processes of storage and distribution of steel products, most often choosing 4 in the Likert scale from 1 to 5. Originality/value: Studies presented in this paper are strongly linked to the current concept of industrial development, which is Industry 4.0. Keywords: product distribution, Industry 4.0, steel industry. Category of the paper: research paper.
Article
Full-text available
With the boom of E-commerce in recent years, the third-party logistics (3PL) gains much favor for its large scope of service provided and economy of scale. Meanwhile, in the face of oceans of parcels to deliver, it casts requests on the efficiency of warehouse management to meet the need of customers. However, most companies conduct warehousing operations still relying on the paper for guiding and recording, and information is rarely shared even in the same company. Besides, few big companies are pursuing an automatic system to replace manpower, but in effect, the system is too mass and complicated to be stable and robust in usage. In this study, an IoT-enabled cyber-physical system assisted with wearable devices and wireless communication technologies, like RFID and Bluetooth, has been developed to cooperate with kinds of stakeholders to achieve higher operational efficiency. It has been deployed in a 3PL automotive-parts company at the Great Bay Area in China as a case study. Their nationally distributed warehouses realized real-time synchronizations of operations and information sharing within the company. Moreover, it not only highlighted the sustainability by nearly removing the paper in operations but also enhanced visibility and traceability throughout the whole process. The framework of the system and workflow proposed here can be duplicated or adjusted by other enterprises who share similar features. The success of this practice may motivate more 3PL companies to adopt cutting-edge technologies to create effective solutions for warehouse management.
Article
Full-text available
Current mass individualisation and service-oriented paradigm calls for high flexibility and agility in the warehouse system to adapt changes in products. This paper proposes a novel digital twin-driven joint optimisation approach for warehousing in large-scale automated high-rise warehouse product-service system. A Digital Twin System is developed to aggregate real-time data from physical warehouse product-service system and then to map it to the cyber model. A joint optimisation model on how to timely optimise stacked packing and storage assignment of warehouse product-service system is integrated to the Digital Twin System. Through perceiving online data from the physical warehouse product-service system, periodical optimal decisions can be obtained via the joint optimisation model and then fed back to the semi-physical simulation engine in the Digital Twin System for verifying the implementation result. A demonstrative prototype is developed and verified with a case study of a tobacco warehouse product-service system. The proposed approach can maximise the utilisation and efficiency of the large-scale automated high-rise warehouse product-service system.
Article
Full-text available
Purpose The purpose of this paper is to present a conceptual model that defines the essential components shaping the new Digital Supply Chains (DSCs) through the implementation and acceleration of Industry 4.0. Design/methodology/approach The scope of the present work exposes a conceptual approach and review of the key literature from 1989 to 2019, concerning the evolution and transformation of the actors and constructs in logistics and Supply Chain Management (SCM) by means of examining different conceptual models and a state-of-the-art review of Industry 4.0’s concepts and elements, with a focus on digitization in supply chain (SC) processes. A detailed study of the constructs and components of SCM, as defined by their authors, resulted in the development of a referential and systematic model that fuses the inherent concepts and roles of SCM, with the new technological trends directed toward digitization, automation, and the increasing use of information and communication technologies across logistics global value chains. Findings Having achieved an exploration of the different conceptual frameworks, there is no compelling evidence of the existence of a conceptual SCM that incorporates the basic theoretical constructs and the new roles and elements of Industry 4.0. Therefore, the main components of Industry 4.0 and their impact on DSC Management are described, driving the proposal for a new conceptual model which addresses and accelerates a vision of the future of the interconnectivity between different DSCs, grouped in clusters in order to add value, through new forms of cooperation and digital integration. Originality/value This research explores the gap in the current SCM models leading into Industry 4.0. The proposed model provides a novel and comprehensive overview of the new concepts and components driving the nascent and current DSCs. This conceptual framework will further aid researchers in the exploration of knowledge regarding the variables and components presented, as well as the verification of the newly revealed roles and constructs to understand the new forms of cooperation and implementation of Industry 4.0 in digitalized SCs.
Article
Full-text available
As a real time location system (RTLS) can provide positioning and tracking of forklifts and other mobile entities in a warehouse, the integration of RTLS into a data system has a significant potential to enhance safety and improve efficiency. The objective of this research is to demonstrate how RTLS technology can be leveraged to enhance the warehouse safety and operational efficiency via a real warehouse case study. The research is implemented using a novel three-phase framework to introduce the RTLS technology in the warehouse. The first phase evaluates available RTLS technology. Market research has been conducted to compare different RTLS technologies, and the outcome of this phase suggests that the ultra-wide band (UWB) is the best technology for indoor positioning and tracking in the warehouse with respect to several metrics. The second phase is the technology implementation, which aims to integrate RTLS with other existing warehouse operation systems, i.e., the warehouse management system (WMS) and the forklift fleet management system (FFMS). In this phase, light is shed on current challenges and proposed solutions of RTLS data accuracy and synchronization. The final phase is post-implementation, in which several methods and data visualization tools are proposed to tackle safety and operational issues. A real warehouse in the US has been used as a case study to evaluate the proposed framework. In particular, the following analyses have been conducted using the actual RTLS data: 1) harshness in braking, 2) compliance to routing policies, 3) driver patterns in intersections, 4) congestion identification and prevention, 5) speed per zone, 6) impact analysis, and 7) faults analysis. The results suggest that the proposed framework has a great potential to advance the current warehouse solutions one step forward to realize smart warehouse operations.
Article
Full-text available
During the development of research to compare the processes and impact of inclusive education in Sweden with results obtained from a study undertaken in Ireland, a pilot study was conducted and documented. The pilot study had three aims: (1) to gather data to provide guidance for a substantive study adapted to Swedish conditions through modification of Irish research procedures and instruments, (2) to critically interrogate how we as researchers could most effectively conduct a pilot study utilizing observational and video-recorded data, and (3) to use the Irish theoretical model as a tool of analysis for studying inclusion in two Swedish schools. Although pilot studies are frequently conducted to assess the efficacy of research instruments for use in qualitative research projects, few publications have drawn upon empirical findings related to such studies. Additionally, while methodological texts recommend the use of pilot studies in qualitative research, there is a lack of reported research focusing on how to conduct such pilot studies. We argue that our methodological findings may contribute to greater awareness of the important role that a pilot study may have for full-scale qualitative research projects, for example, in case study research where semi-structured qualitative interviews are used. This argument is based on the assumption that researchers, and especially novice researchers, having conducted a pilot study will be better informed and prepared to face the challenges that are likely to arise in the substantive study and more confident in the instruments to be used for data collection. A proper analysis of the procedures and results from the pilot study facilitates the identification of weaknesses that may be addressed. A carefully organized and managed pilot study has the potential to increase the quality of the research as results from such studies can inform subsequent parts of the research process.
Article
Full-text available
Rapid rise in information and communication technology in various walks of life has helped digitization of human services, including transportation. The result of digitization is vast amount of location and time data on humans and goods, which in turn provide a valuable resource for transportation system performance for the managing and operating agencies. A wide variety of transportation performance metrics (TPMs) to characterize, evaluate and improve the performance towards making the operating agencies, and thereby the cities, ‘smart’ must be presented suitably to policy and decision makers. TPMs and data sources are of varying spatiotemporal extent and data formats, necessitating interoperability. Estimating TPMs requires a generic data warehousing framework handling various datasets, preferably, built in-house for the agencies to sustainably move towards smart city goals and meeting federal data reporting mandates. In this study, such a flexible data analytics framework is demonstrated via novel data ingestion and visualization outputs. Several use cases for evaluating efficiency, reliability and sustainability of transportation projects and system are presented.
Article
Full-text available
Warehouse efficiency has now turned into a centre of competency or a strategic weapon among organizations. An efficient warehouse has the ability to fulfil customer needs quickly and increases a firm's performance. Thus, the objective of this study is to examine the role of warehouse attributes with regard to supply chain warehouse efficiency. Two warehouse attributes, namely; layout and operations are taken into consideration in this study. In addition, management information system (MIS) is investigated as a meditating variable between warehouse attributes and supply chain warehouse efficiency. Indonesian supply chain companies are the focus and data is gathered by collecting the opinion of supply chain company staff through questionnaire surveys. Data was examined by using the latest statistical techniques, namely; PLS-SEM. Findings of the study highlight that warehouse attributes have a positive influence on supply chain warehouse efficiency. Proper warehouse design and effective operations increase the warehouse efficiency among Indonesian supply chain companies. In addition, it is found that MIS is one of the mediating variables between warehouse attributes and supply chain warehouse efficiency.
Article
During the construction management process, an important issue is ta furnish construction managers with information about and insight inta the existing data with a view to facilitating more efficient decision making without interrupting the daily work of an on-line transaction processing system. With the recent advances in artificial Intelligence technology, the integration of data warehause into knowledge-based system (KBS) is a feasible solution. Data warehouse technology, which has not been applied to construction management, is a new database branch. It is meaningful ta experiment and gauge the full scope of its capability in this specific problem domain. This paper describes a prototype integrated KBS, which has been developed using a commercially available microcomputer-based expert system shell VISUAL RULE STUDIO, on construction management decision making. VISUAL RULE STUDIO acts as an ActlveX Designer under the Micrasoft Visual Basic programming environment, with hybrid knowledge representatian approach under object-oriented design environment. The coupling enables the right data to be tracked down and furnishes the necessary information in a direct, rapid and meaningful way. Through custom-built interactive graphical user interfaces, construction managers can view data from various perspectives with significantly reduced respanse time to queries, thus rendering more efficient decision making. Illustrative sample sessions using the system are also presented.
Article
Smart logistics is an effective way to meet the challenges of fast-changing customer expectations, take opportunities brought by new technologies, and facilitate new business models. This review paper systematically summarises the recent research and applications of smart logistics based on the internet of things (IoT), including smart freight transportation, warehousing, and delivery. A bibliometric analysis based on publications between 2008 and 2019 reveals main technologies and impacts of the research and applications of IoT-based smart logistics and their industrial and geographic distributions. The content analysis demonstrates the role and impact of IoT on smart logistics, reveals challenges of IoT-based smart logistics, and provides research needs for the development of smart logistics. The current challenges include technical problems of radio frequency identification and wireless sensor networks, limited extension and technical capacity of IoT,standardisation issues of IoT, data acquisition and processing issues of IoT, and security and privacy concerns on IoT. There is a strong research need to address the key technical issues of IoT, promote various IoT technologies in logistics practice, and jointly develop advanced information and communications technologies and management systems.
Article
Dynamic model of the automated warehouse management and forecasting system in the conditions of Industry 4.0 is discussed. Usage of inductive knowledge base allows to predict the appearance of bottlenecks in advance and actually turns the warehouse management system into an expert with all the necessary integral experience, which helps to reduce significantly the financial costs of excessive inventory and to prevent certain components shortage possibility.