A machine learning approach for predictive warehouse design

Warehouse management systems (WMS) track warehousing and picking operations, generating a huge volumes of data quantified in millions to billions of records. Logistic operators incur significant costs to maintain these IT systems, without actively mining the collected data to monitor their business processes, smooth the warehousing flows, and support the strategic decisions. This study explores the impact of tracing data beyond the simple traceability purpose. We aim at supporting the strategic design of a warehousing system by training classifiers that can predict the storage technology (ST), the material handling system (MHS), the storage allocation strategy (SAS), and the picking policy (PP) of a storage system. We introduce the definition of a learning table, whose attributes are benchmarking metrics applicable to any storage system. Then, we investigate how the availability of data in the warehouse management system (i.e. varying the number of attributes of the learning table) affects the accuracy of the predictions. To validate the approach, we illustrate a generalisable case study which collects data from sixteen different real companies belonging to different industrial sectors (automotive, manufacturing, food and beverage, cosmetics and publishing) and different players (distribution centres and third-party logistic providers). The benchmarking metrics are applied and used to generate learning tables with varying number of attributes. A bunch of classifiers is used to identify the crucial input data attributes in the prediction of ST, MHS, SAS, and PP. The managerial relevance of the data-driven methodology for warehouse design is showcased for 3PL providers experiencing a fast rotation of the SKUs stored in their storage systems.

Perancangan Data Warehouse Rumah Sakit Berbasis Online Analytical Processing (OLAP)

<p class="BodyCxSpFirst">Pemanfaatan teknologi informasi sangat penting bagi rumah sakit, karena berpengaruh pula terhadap kualitas pelayanan kesehatan yang secara manual diubah menjadi digital dengan menggunakan teknologi informasi.Dalam penelitian ini penulis menggunakan metodologi <em>Nine step</em> sebagai acuan dalam merancang suatu <em>data warehouse</em><em>,</em> untuk pemodelan menggunakan skema konstelasi fakta dengan 3 tabel fakta dan 11 tabel dimensi. Perbedaan penelitian ini dengan penelitian sebelumnya terletak pada sumber data yang diekstrak langsung dari <em>database</em> SIMRS yang digunakan rumah sakit, sehingga tidak ada ekstraksi data secara manual.Penelitian ini bertujuan untuk menghasilkan desain data warehouse berbasis Online Analytical Processing (OLAP) sebagai sarana penunjang kualitas pelayanan kesehatan rumah sakit. OLAP yang dihasilkan akan berupa desain data warehouse dengan berbagai dimensi yang akan menghasilkan tampilan informasi berupa Chart maupun Grafik sehingga informasinya mudah dibaca dan dipahami oleh berbagai pihak.</p><p class="BodyCxSpFirst"> </p><p class="BodyCxSpFirst"><em><strong>Abtract</strong></em></p><p class="BodyCxSpFirst"><em>The use of information technology is very important for hospitals, because it also affects the quality of health services, which manualy changed to digital using information technology. In this study, the authors used the Nine step methodology as a reference in designing a data warehouse for modeling using a fact constellation schema with 3 fact tables and 11 dimension tables. the different in this study from previous research is that the data source was taken directly from the SIMRS database used by the hospital, so there is no manual data extraction.</em><em>The aim of this research is to be able to produce a Data Warehouse design based on Online Analytical Processing (OLAP) as a means of supporting the quality of hospital health services. The resulting OLAP will be a data warehouse design with various dimensions will produce the displays information in the form of a graph or chart so that the information is easy to read and understand by various parties.</em></p><p class="BodyCxSpLast"><em> </em></p><p class="BodyCxSpFirst"><em><strong><br /></strong></em></p>

Design framework for a lean warehouse – a case study-based approach

PurposeThis purpose of this study is to develop a simple framework for designing a warehouse incorporating lean principles. Multiple objectives like resource planning, material handling, storage, inventory management, including internal and external logistics, are considered.Design/methodology/approachA design procedure to incorporate lean principles for designing a warehouse for a complex multi-model production line has been proposed. The preferred standards and factors affecting warehouse design, the inputs and outputs of process flow characteristics, are incorporated into the design. Current and future state value stream mappings are drawn to bring out the challenges in the value flow.FindingsThe framework for designing a lean warehouse have been implemented and validated in a heavy machinery manufacturer. This framework will ease the work of the future lean-based warehouse designers to apply simple step-by-step processes to achieve the goal with the nearest accuracy. The steps followed can be summarized as defining the lean processes, making the lean process as the design base, collecting inputs like stock-keeping unit master, inventory and space details, and building the lean warehouse design with the step-by-step processes.Practical implicationsPractical tips on warehouse design have been explained focusing on the part volume, quantity handled, inventory and throughput. This will assist the practitioners in designing a lean warehouse and leading to an improved operational performance.Originality/valueA simplified design procedure for designing a lean warehouse, along with a real-time case study has been enumerated in detail. Effective use of space and resources with lean tools and techniques lead to better storage and picking efficiency resulting in an overall reduction in cost.

Implementasi Data Warehouse Menggunakan Pentaho BI di Hartaning House Homestay

Hartaning House is one of the homestays in Ubud Gianyar that rents out homestay rooms to foreign and local tourists, but currently does not have a data-based system that facilitates business reports. This research aims to provide a proposed solution in the form of designing and implementing data related to room rental, to facilitate the determination of the promotion of equal distribution of all homestay rooms. The implementation will use an open source application, namely (Pentaho Business Intelligence) for making reports that are used to facilitate analysis. The data is made in a multi-dimensional design to facilitate the application of the data warehouse design and system designs that have been made.

RANCANGAN DATA WAREHOUSE AKADEMIK POLITEKNIK PARIWISATA BALI BERBASIS LINUX OPENSUSE

This study aims to design an academic data warehouse at Politeknik Pariwisata Bali because there are several information systems that require a system capable of handling databases of several existing information system applications and perform analysis. A data warehouse is the right solution for handling databases of several information systems that are not yet integrated. The research method begins with literature study, identification of problems, determining research objectives, designing solutions, namely designing an academic data warehouse, determining the hardware and software specifications needed, and ending with discussions and drawing conclusions. The result of this research is an academic data warehouse design that can be implemented properly. Besides, the results of this study are also accompanied by specifications for open-source hardware and software to save costs. The data warehouse design produced in this study uses a database of 3 information systems which is the main business process of a college, namely: Academic Information System, Information System for New Student Admissions, Research Information System. The three databases of the information system are internal data sources using the MySQL DBMS. The resulting academic data warehouse design uses open source software, namely: openSUSE, Pentaho Data Integration, MySQL DBMS.

Optimization of warehouse management based on artificial intelligence technology

This paper analyzes the artificial intelligence algorithms related to the storage path optimization problem and focuses on the ant colony algorithm and genetic algorithm with better applicability. The genetic algorithm is used to optimize the parameters of the ant colony algorithm, and the performance of the ant colony algorithm is improved. A typical route optimization problem model is taken as an example to prove the effectiveness of parameter optimization. This paper proposes a combined forecasting method through data preprocessing algorithm and artificial intelligence optimization. The combined prediction method first uses wavelet transform threshold processing to remove the noise data in the original data and then uses three separate methods to reduce noise. Forecast warehouse data and obtain intermediate forecast results. This article analyzes warehouse management and can solve the problems in the company’s warehouse management from the aspects of warehouse design and planning, warehouse design, and integrated warehouse management. After comparative analysis and selection, this paper uses the SLP method to rationally adjust and arrange the relative position and area of each functional area of the warehouse, and improve the evaluation index system. Experimental research shows that under the guidance of this article to optimize storage strategy, cargo location layout, and warehousing workflow, the employee reward mechanism mobilizes the enthusiasm of employees, improves work efficiency, and reduces storage costs. The above-mentioned various optimization and storage improvement measures finally reduced the total storage cost by 17%, effectively achieving the goal of cost control.