• Title/Summary/Keyword: Warehouse system

Search Result 413, Processing Time 0.022 seconds

Design of DatawareHouse Real-Time Cleansing System using XMDR (XMDR을 이용한 데이터웨어하우스 실시간 데이터 정제 시스템 설계)

  • Song, Hong-Youl;Jung, Kye-Dong;Choi, Young-Keum
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.14 no.8
    • /
    • pp.1861-1867
    • /
    • 2010
  • A datawarehouse is generally used in organizations for decision and policy making. And In a distribute environment when a new system is added, there needs considerable amount of time and cost due to the difference between the systems. Therefore, to solve this matter. Firstly, heterogeneous data structures can be handled by creating abstract queries according to the standard schema and by separating the queries using XMDR. Secondly, metadata dictionary which defines synonyms of metadata and methods for data expression is used to overcome difference of definition and expression of data. Especially, work presented in this thesis provides standardized information for data integration and minimizing the effects of integration on local systems in discrete environments using XMDR to create information of data warehouse in realtime.

A Cache Manager for Enhancing the Performance of Query Evaluation in Data Warehousing Environment (데이타웨어하우스 환경에서의 질의 처리 성능 향상을 위한 캐시 관리자)

  • 심준호
    • Journal of KIISE:Databases
    • /
    • v.30 no.4
    • /
    • pp.408-419
    • /
    • 2003
  • Data warehouses are usually dedicated to the processing of quires issued by decision support system(DSS). The response time of DSS queries is typically several orders of magnitude higher than the one of OLTP queries. Since DSS queries are often submitted interactively, techniques for reducing their response time are important. The caching of query results is one such technique particularly well suited to the DSS environment. In this paper, we present a cache manager for such an environment. Specifically, we define a canonical form of query. The cache manager looks up a query based on the exact query match or using a suggested query split process if the query is found is non-canonical form or in canonical form, respectively. It dynamically maintains the cache content by employing a profit function which reflects in an integrated manner the query execution cost, the size of query result, the reference rate, the maintenance cost of each result due to updates of their base tables, and the frequency of such updates. We performed the experimental evaluation and it positively shows the performance benefit of our cache manager.

A Study on the Establishment Direction of Smart Distribution Logistics Center in the era of the Fourth Industrial Revolution (4차 산업혁명시대의 스마트 유통물류센터 구축방향에 관한 연구)

  • Park, Jung-Hyun;Oh, Jae-Gyun;Kim, Dong-Myung;Yeo, Gi-Tae
    • Journal of Digital Convergence
    • /
    • v.17 no.2
    • /
    • pp.59-71
    • /
    • 2019
  • This research is aimed to identify the building factors and deriving the importance of each factor for establishing the smart distribution center in the fourth industrial revolution era. The research methodology used CFPR(Consistent Fuzzy Preference Relations) to effectively extract expert knowledge. Research has shown as principle factors that "Service" is the first factor to be considered as 0.271, followed by "Infra(Warehouse)"(0.254), "Information System"(0.247), and "Equipment"(0.228). And as detailed factors, "Reliability" showed the highest importance as 0.091, followed "Visibility of Information System"(0.076), "Space Advancement"(0.075), "Location"(0.074) and "Satisfaction of service"(0.073). This study has implications in that it has presented an establishment direction for the smart distribution center.

An Approach to Improve the Rooftop Space of Commercial Facilities (상업시설의 루프탑 공간 개선방안 연구)

  • Kim, Hye-Ri;Kim, Young-Hwa;Lee, Sang-Hong
    • Journal of the Architectural Institute of Korea Planning & Design
    • /
    • v.34 no.6
    • /
    • pp.93-103
    • /
    • 2018
  • In the past, the rooftop was a place where a water tank was to be installed, and a space of secretion and concealment such as a warehouse exposed in the air. It was because it was judged to hinder the beauty of a city as a whole without having any functional value per se. However, the roof portion is increasingly being utilized for a space such as a cafe, a pub, and a lounge as the rooftop is highly recognized as a place for leisure activities other than an idle space in modern times. Nonetheless, there are no detailed ordinances and criteria corresponding to such circumstances. For example, in case of the rooftop space, the building code applied to the rooftop space is a legal system when the rooftop was an idle space in the past though people have now accessed more increasingly to the rooftop than in the past. This study investigated the definition on the rooftop space evolved in accordance with the change of the rooftop space and the related legal system in Korea, and conducted a survey for the purpose of performing the field investigation for the analysis of physical status in 117 spaces that form the rooftop space in the rooftop of small-scale commercial facilities with 2 stories through 4 stories in Korea and analyze the recognition of users and analyzing the recognition of users. We analyzed the problems in the rooftop space through analysis of derived data, and suggested improvement plans.

LED Chromaticity-Based Indoor Position Recognition System for Autonomous Driving (자율 주행을 위한 LED 색도 기반 실내 위치 인식 시스템)

  • Jo, So-hyeon;Woo, Joo;Byun, Gi-sig;Jeong, Jae-hoon
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2021.10a
    • /
    • pp.603-605
    • /
    • 2021
  • With the expansion of the indoor service-providing robot market and the electrification of automobiles, research on autonomous driving is being actively conducted. In general, in the case of outside, the location is mainly recognized through GPS, and location positioning is performed indoors using technologies such as WiFi, UWB (Ultra-Wide Band), VLP, LiDAR, and Vision. In this paper, we introduce a system for location-positioning using LED lights with different color temperatures in an indoor environment. After installing LED lights in a simulated environment such as a tunnel, it was shown that information about the current location can be obtained through the analysis of chromaticity values according to location. Through this, it is expected to be able to obtain information about the location of the vehicle in the tunnel and the movement of the device in a room such as a warehouse or a factory.

  • PDF

A study for Secure the Reliability of Automated Guided Vehicle Remote Control System (무인운반차 RCS(Remote Control System)의 신뢰확보를 위한 연구)

  • Jeon, Hyong-Mo;Kang, Sang-Won
    • Journal of Digital Convergence
    • /
    • v.15 no.5
    • /
    • pp.207-215
    • /
    • 2017
  • With rapid development of IT technology and biotechnology, human lifespan is extended rapidly, and we are living in the era where aging becomes the social issue. Due to this aging problem, manpower is mainly replaced by Automated Guided Vehicles (AGV) in manufacturing factories or warehouse logistics transportation. Rate of AGV use increases sharply every year. AGVs, which were used only in Smart Factories, extends its usage into indoor and outdoor operation by changing their usages to container transportation that can carry huge containers in the harbor. With the expansion of AGVs usage, the importance of RCS (Remote Control System) is also increased. In this study, we surveyed and analyzed the characteristics and technology trends of technical features of AGV's RCS that are developing in various ways to establish quality evaluation system of AGV RCS. Based on this, and by referring to international quality assessment standards, ISO/IEC 25000 series, we derived evaluation items on functional suitability and usability to secure reliability of AGV RCS. Also, it is our intention to develop evaluation model using those derived usability and reliability evaluation items.

A Study on Eco-friendly Policy and Current State of Japanese Logistics (일본 물류분야에 대한 친환경정책과 현황에 관한 연구)

  • Yoon, Song-Han
    • Journal of Korea Port Economic Association
    • /
    • v.27 no.4
    • /
    • pp.253-270
    • /
    • 2011
  • The problem of global warming faced a big turning point due to the adoption of "Kyoto protocol"in 1997. Therefore, by enacting "Act on Advancement of Integration and Streamlining of Distribution Business"and "green logistics partnership council"to reduce $CO_2$ emission, fulfillment of distribution work is comprehensively and effectively supported by Japan. In particular, the green management certification system, which promotes green management based on the independent and planned environmental measures of transportation service of harbor employers, warehouse operators, and trucking employers of logistics sector, is promoted. As such, the Japanese government is actively promoting the eco-friendly green logistics policy to reduce $CO_2$ emission in terms of the prevention of global warming by building the comprehensive and efficient logistics system. Therefore, this thesis studied the status of the green logistics policy of Japan where the eco-friendly logistics system is being built ahead of Korea and as a result, it presented the implications on the green logistics strategy which is eco-friendly and can be developed continuously, the development of eco-friendly green logistics industry, the introduction of green logistics certification system, Departmental roles and responsibility of administrative agencies.

Operaton Cost Model for Feed Production (배합사료 공장의 작동비용 모델)

  • Park, Kyung Kyoo;Chung, Do Sup;Charles, Deyoe
    • Journal of Biosystems Engineering
    • /
    • v.10 no.1
    • /
    • pp.69-75
    • /
    • 1985
  • For the purpose of estimating the operating cost for feed production, energy consumption, labor requirement, maintenance cost, and supplies and miscellaneous costs are analyzed and developed as mathematical models. Mathematical model for energy usage Consists of electrical energy, boiler fuel energy and vehicle fuel energy. The mathematil model for electrical energy usage for the swine and poultry feed mill and the complete pelleted feed mill are developed, based on the general model mill and the computer program for its design developed in Kansas State University (Park, 1982). Also, the boiler fuel energy consumption model and the vehicle fuel energy consumption model are developed by analyzing the boiler system and the vehicle operation in the warehouse. In order to develop a mathematical model for labor requirement, the data that Vosloh (1968, 1976) constructed for labor requirement in his model mill are used by assuming that his model mill is similar to this model, in terms of labor assignment standards. Maintenance and repair costs are obtained by assuming to be 5.5% of the total capital investment cost. Also, supplies and miscellaneous costs are estimated by using Vosloh's report and it is approximately 0.87 dollars per ton based on daily production.

  • PDF

A Study on the Revitalization of Yangsan ICD (양산 ICD 활성화 방안에 관한 연구)

  • Lee, Dong-Hun;Kim, Yul-Seong;Park, Ho;Shin, Jae-Yeong
    • Journal of Korea Port Economic Association
    • /
    • v.31 no.4
    • /
    • pp.121-132
    • /
    • 2015
  • Yangsan ICD (Inland Container Depot) has played an important role for Busan Port and Korea's port & logistics industries, increasing international logistics competitiveness and containers' transportation competitiveness in Busan region dealing with 1330 thousand TEU in 2005, since its opening in March 2000. However, it is necessary to seek new measures to revitalize Yangsan ICD, since its cargo volume decreased rapidly owing to the opening of Busan New Port and hinterland in 2006. This study constructed an evaluation model using AHP (Analytic Hierarchy Process) and conducted a survey targeting local businesses and persons concerned in Yangsan ICD to seek measures for revitalization. The results suggest that Yangsan ICD needs to switch functions to logistics centers (terminal facilities, logistics warehouse) for revitalization considering its advantage of facility location. Moreover, by extending the utilization period and securing building-to-land ratio, existing and new businesses' stable activity should be guaranteed. Furthermore, utilizing facilities such as the railway station in ICD, an active railway revitalization policy may increase cargo volume. Yangsan ICD should perform its role as an inland logistics depot through the revitalization of railway freight transportation in the national logistics system focusing on road freight transportation.

Study on Design of Mobile Robot for Autonomous Freight Transportation (무인 화물이송 이동로봇의 설계에 관한 연구)

  • Jeong, Dong-Hyuk;Park, Jin-Il;Kim, Yong-Tae
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.23 no.3
    • /
    • pp.202-207
    • /
    • 2013
  • In the paper, we design a autonomous mobile robot for freight transportation and propose an operation method of the robot in the warehouse. In order to implement autonomous navigation, it is needed to recognize the position of the robot and track the path to the target. Previous methods are hard to change the workspace environment and need high cost to install and keep a maintenance of the system. The lifter of freight transportation robot is designed to load and unload a baggage through up and down motion. Also, ultrasonic sensor, RFID, QR-code and camera sensor is used to carry out various functions while the robot navigates in the various environment. We design an operation method of the mobile robot in order to effectively arrive a goal position and transport a freight. The proposed methods are verified through various experiments.