• 한국컴퓨터정보학회논문지
• /
• 제23권3호
• /
• pp.49-54
• /
• 2018

A data warehouse is a system that collectively manages and integrates data of a company. And provides the basis for decision making for management strategy. Nowadays, analysis data volumes are reaching critical size challenging traditional data ware housing approaches. Current implemented solutions are mainly based on relational database that are no longer adapted to these data volume. NoSQL solutions allow us to consider new approaches for data warehousing, especially from the multidimensional data management point of view. In this paper, we extend the data warehouse design methodology based on relational database using star schema, and have developed a consistent design methodology from information requirement analysis to data warehouse construction for large scale data warehouse construction based on MongoDB, one of NoSQL.

• 디지털융복합연구
• /
• 제15권9호
• /
• pp.23-33
• /
• 2017

국가 간 다양한 상품 무역에서 파생되는 물류업무를 처리하기 위해 세계 물류시장은 성장하고 있는 추세이다. 특히 의류물류는 매년 처리량이 증가하고 있으며, 세계 산업 중 손꼽히는 매출 기록을 나타내고 있다. 현재 의류품목은 고가의 제품으로 성장하였으며, 정교하고 알맞은 물류서비스가 요청되고 있다. 본 논문은 3PL 서비스를 제공하는 회사들이 앞으로 성장하고 있는 의류시장에 대한 서비스 및 오퍼레이션에 대응할 수 있도록 효과적인 운영방안을 제시하는 것에 연구목적이 있다. Fuzzy AHP방법을 사용하여 의류창고 운영에 대한 중요요인의 가중치를 산출하였다. 분석결과, 1위로는 인력교육(0.17) 2위로는 화재관리(0.169), 3위로 입출고 관리(0.142)로 나타났으며, 4위와 5위는 각각 Warehouse management system 및 바코드 시스템으로 확인되었다. 즉 '의류' 특성을 정확히 이해하고 이를 바탕으로 인력교육, 화재관리 그리고 입출고관리를 수행해야하며, 이를 통하여 의류물류 서비스의 질을 제고할 수 있다.

• 한국전자통신학회논문지
• /
• 제8권12호
• /
• pp.1803-1810
• /
• 2013

물류창고 시스템에서는 물류의 입고/출고에 따른 재고현황의 변동이 잦고, 내용물에 따라 주위환경요소가 큰 영향을 미칠 수 있으므로, 재고현황 및 환경요소를 빠르고 정확하게 관리하는 것이 물류관리에 있어서 매우 중요하다. 하지만 현재 제안되고 있는 RFID 기반의 물류관리 시스템은 RFID 리더 간 통신에 대해 통일된 국제규격이 없고, 일반적으로 사용되는 중앙집중방식 MAC 방식의 경우 클러스터 헤더의 이동이나 채널 상황의 영향으로 인해 이 시간동안 각 노드 간 통신이 불가능하다. 따라서 본 논문에서는 채널 상황에 능동적으로 대처할 수 있는 물리계층 정보를 이용한 와이미디어 MAC 프로토콜 기반의 릴레이 협력통신 방안에 대한 결과를 제안한다.

• 한국경영과학회:학술대회논문집
• /
• 한국경영과학회 2006년도 추계학술대회
• /
• pp.327-331
• /
• 2006

This paper considers an integrated inventory-distribution system with a fleet of heterogeneous vehicles employed where a single warehouse distributes a single type of products to many spatially distributed retailers to satisfy their dynamic demands and the product is provided to the warehouse via procurement ordering from any manufacturing plant or market The Problem is formulated as an Mixed Integer Programming with the objective function of minimizing the sum of inventory holding cost (at the warehouse and retailers), and transportation cost and procurement ordering cost at the warehouse, subject to inventory-balancing constraints, ordering constraints, vehicle capacity constraints and transportation time constraints. The problem is Proven to be NP-hard. Accordingly, a Lagrangean heuristic procedure is derived and tested for its effectiveness through computational experiments with some numerical instances.

• Management Science and Financial Engineering
• /
• 제17권2호
• /
• pp.1-21
• /
• 2011

This paper considers an integrated inventory-distribution system with a fleet of heterogeneous vehicles employed where a single warehouse distributes a single type of products to many spatially distributed retailers to satisfy their dynamic demands. The problem is to determine order planning at the warehouse, and also vehicle schedules and delivery quantities for the retailers with the objective of minimizing the sum of ordering cost at the warehouse, inventory holding cost at both the warehouse and retailers, and transportation cost. For the problem, we give a Mixed Integer Programming formulation and develop a Lagrangean heuristic procedure for computing lower and upper bounds on the optimal solution value. The Lagrangean dual problem of finding the best Lagrangrean lower bound is solved by subgradient optimization. Computational experiments on randomly generated test problems showed that the suggested algorithm gives relatively good solutions in a reasonable amount of computation time.

• 산업경영시스템학회지
• /
• 제34권1호
• /
• pp.1-8
• /
• 2011

Controlling industrial vehicle operated by human in warehouse was not simple since the information transfer for controlling the vehicle was not easy. However, as the technology for the WMS (Warehouse Management System) has been advanced and the PDA (Personal Digital Assistant) has come into wide use in a workplace, the control of man-operated vehicle became less difficult as do to AGVS (Automated Guided Vehicle System). This study examines the ways to improve the efficiency of warehouse operation through introducing rule of task assignment for the vehicles, particularly forklift. This study, basically, refer to AGV operation policy because a great number of studies for AGV dispatching rule have been done and the mechanism for the controlling vehicles is very similar. The workers in field prefer to simple dispatching rules such as Shortest Retrieval Time First (SRTF), Shortest Travel Time First (STTF), and Longest Waiting Time First (LWTF). However, these rules have potential disadvantage. Thus, several rules made up by combining rules mentioned above are introduced and these new rules use threshold value or evaluation formula. The effectiveness of these new rules are tested by simulation and the results are compared. This study proposes favorable dispatching rules for forklift in warehouse for the efficiency of the vehicle operation and stability of service level.

• 대한전자공학회:학술대회논문집
• /
• 대한전자공학회 2008년도 하계종합학술대회
• /
• pp.725-726
• /
• 2008

In this paper, we introduce an ubiWarehouse system for the management of automobile parts. Because automotive parts are very various in kinds according to companies, models and manufacture year, it's hard to find exactly the desired parts and to control goods in stock. To solve this problem, we propose the model of context recognizer in which context data are expressed in a systematic type of 5W1H. And initial context data are grouped and integrated, and some conflict context information is solved. Finally user's intention is interpreted and served. As a result, the proposed system can be used to enhance conveniency and correctness of the management of various kinds of part's.

• 한국데이타베이스학회:학술대회논문집
• /
• 한국데이타베이스학회 1998년도 국제 컨퍼런스: 국가경쟁력 향상을 위한 디지틀도서관 구축방안
• /
• pp.448-474
• /
• 1998

Data warehouse (DW) is important for analytical processing. Metadata is a key to its architecture. This paper proposes an architecture that consists of seven components. To illustrate data warehouse environment (DWE), this Paper proposes taxonomies having four flows. on the basis or the taxonomies and metadata, this paper proposes a methodology for building the data warehouse and metadata simultaneously. This integrated development methodology (IDM) consists of seven phases: (i) preparatory phase, (ii) requirement analysis phase, (iii) data warehouse development phase, (iv) operational data store development phase, (v) data mart development phase, (vi) metastore development phase, and (vii) maintenance phase. A metastore system is Proposed to help develop metadata interactively. An illustrative example is investigated to demonstrate the usefulness of IDM.

• 대한안전경영과학회지
• /
• 제14권1호
• /
• pp.123-128
• /
• 2012

This paper deals with the productivity increment through construction of HT8 production system for automobile factory in China. HT8 production system start to build up several management indices. The important management indices consists of organization management, location management, management of order, management of defective item, management of delivery information, and warehouse management. This HT8 production system is expected to obtain the improvement for overall organization management and reduction by 50% in warehouse cost.

• 한국경영과학회지
• /
• 제3권1호
• /
• pp.69-73
• /
• 1978

This paper deals with the problem of determining the optimal inventory-transportation policy of the idealistically simple inventory-transportation system with the following assumptions: (1) The system consists of a single central warehouse and a single local warehouse, (2) The planning horizon is finite, (3) Demand rate is fixed costant, and so forth. Developed is the algorithm by which to identify the optimal inventory policy which minimizes the total cost incurred to the system over the given finite planning horizon. A sample numerical example is presented along with a discussion of the possible applications of the approach used n the algorithm.