• Title/Summary/Keyword: Data Warehouse

Search Result 348, Processing Time 0.026 seconds

A Study on development of WMS System for H Automobile Plant in China (자동차 공장의 WMS 구축에 관한 연구 -중국 H 자동차를 중심으로-)

  • Zhang, Jing-Lun;Lee, Doo-Yong;Jang, Jung-Hwan;Yoo, Sung-Hee;Lee, Chang-Ho
    • Journal of the Korea Safety Management & Science
    • /
    • v.15 no.1
    • /
    • pp.193-198
    • /
    • 2013
  • Warehouse Management System was a helper of business in past, but it is perceived as a core competitive power and a tool for generating new business. It have been come out some new prospects for WMS due to generalization of global outsourcing and extension of the range of supply chain. In China, H automobile company construct the new WMS for providing the production extension and increment of part demand for A/S. This paper deals with the location management in warehouse, warehouse management, delivery management of goods from a warehouse, inventory management organizing WMS for construction of A/S warehouse in H motor in China. Then we identified the several problems of existing warehouse and constructed the driving organization and methods for overcoming these problems. We continually gather data for analysing the effects of new A/S warehouse and WMS construction.

Data Integration for DW Construction

  • Yongmoo Suh;Jung, Chul-Yong
    • The Journal of Information Technology and Database
    • /
    • v.4 no.2
    • /
    • pp.79-95
    • /
    • 1998
  • Useful data being distributed over several systems, we have a problem in accessing and utilizing them. Recognizing this problem, researchers have proposed two concepts as solutions to the problem, multidatabase and data warehouse. The one provides a virtual view over the distributed data, and the latter is a materialized view of it. Recently, more attention has been paid to the latter, which is a single of distributed database, collected along a time dimension. So, the major issues in building a data warehouse are 1) how to define a global schema for the data warehouse, 2) how to capture changes from local databases, and 3) how to represent time-varying values of data item. This paper presents an integrated approach to these issues, borrowing the research results from such areas as multidatabase, active databases and temporal databases.

A Study on Implementing a Data Warehouse for Efficient Operating and Managing a Port Authority (효율적인 항만공사의 운영과 관리를 위한 데이터 웨어하우스 구현방안에 관한 연구)

  • Kim, Teahun;Kim, Sangyoul
    • Journal of Korea Port Economic Association
    • /
    • v.29 no.2
    • /
    • pp.195-209
    • /
    • 2013
  • A data warehouse is not an operational database, only a database for decision support. It is defied as "a subject-oriented, integrated, time-variant and non-volatile collection of data". It is an indispensable element of successful information processing technology. This study is designed to suggest a better way to use database for efficient Port Authority's management. It is expected to play a significant role in introducing a data warehouse dedicated to port industry. Data warehouses are to serve as an opportunity to be fully exploited as a strategic technology for ports. Seven subject areas supporting ideas of researchers constitute this study.

Status of Spatial Data Warehouse in Korea (한국의 공간데이터웨어하우스 기술현황 조사)

  • Kim, Seung-Yong;Yom, Jae-Hong
    • Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
    • /
    • 2007.04a
    • /
    • pp.237-242
    • /
    • 2007
  • The NGIS(National Geographic Information System) project is in its third phase currently. To put the produced data to practical use, central and local governments are trying to implement spatial data warehouse(SDW). In this study, status of local and international SDW(Spatial Data Warehouse) technology were investigated. It has been observed that in Korea it was necessary to shift the focus from management of spatial data to servicing of spatial data to information end users. To that end, the following tasks should be pursued : 1) standardization, 2) automatic ways of linking various legacy administrative information, 3) development of customized middleware for spatial data integration and 4) legal system infra structure.

  • PDF

A Comparative Test of ETT Tools for Data Warehousing (데이터 웨어하우스 ETT 도구들의 평가 및 검증)

  • Kim, Gi-Un;Suh, Yong-Moo
    • Asia pacific journal of information systems
    • /
    • v.10 no.2
    • /
    • pp.213-236
    • /
    • 2000
  • Many enterprises continue to have an interest in the usage of new information technologies to gain a competitive advantage. In particular, their interest in the data warehouse and the data mining reveals the aspect of such a trend. Although lots of vendors announce a variety of tools for data warehousing, many a enterprise have a difficulty in building a robust data warehouse due to the lack of the ability of selecting an appropriate data warehouse technology options. Therefore, this study presents some evaluation factors, evaluation methods, and evaluation results about ETT tools, mainly in terms of a comparative test for the current available data warehousing ETT tools, Also, this paper suggests some guides about choosing the right ETT tools.

  • PDF

Analysis of Environment Improving Budget of School Facilities by Using Data Warehouse Technology - Focused on Elementary, Middle, High School of OO Office of Education - (데이터 웨어하우스 기술을 활용한 학교시설물의 환경개선예산 분석 - OO교육청 초·중·고등학교를 중심으로 -)

  • Pak, Min-Kyu;Son, Chang-Baek;Ryu, Han-Guk
    • The Journal of Sustainable Design and Educational Environment Research
    • /
    • v.13 no.1
    • /
    • pp.15-23
    • /
    • 2014
  • With introduction of amended educational curriculum in 2007, optimizing project of educational environment to accomplish its purposes and goals includes expanding educational facilities and supplying eco-friendly school facilities. However, while the focus of optimizing project of educational environment is quality improvement of educational facilities, aging of these facilities built at th times of quantitative expansion and its management become serious problems. Higher concerns on studies and jobs on management of building caused by serious aging of facilities, management cost of building becomes a very crucial issue. Therefore, this study aims to analyze environment improvement budget of school facilities through building and using data warehouse, by investigating and analyzing the current status of environment improvement budget of school facilities and its cost through questionnaire and interview surveys on officers who are in charge of environment improvement budget of school facilities in educational administrations. This study thus analyzed environment improving budget of school facilities by using data warehouse technology collecting related data to the topic and setting levels by region, school class, establishment year, school facility types and others.

Development of Data Warehouse for Construction Material Management (건설공사 자재 관리를 위한 데이터 웨어하우스 개발)

  • Ryu, Han-Guk
    • Journal of the Korea Institute of Building Construction
    • /
    • v.11 no.3
    • /
    • pp.319-325
    • /
    • 2011
  • During a construction project, construction managers must be provided with material information to help them to make decisions more efficiently without delaying the delivery of material. Construction work can be smoothly performed with the proper material supply. Construction duration depends on several material-related decisions, including the order, delivery, and allocation of material to the correct work location. Hence, it is worthwhile to introduce data warehouse techniques that generate subject-oriented and integrated data to construction material management. The data warehouse for construction material management can perform multidimensional analysis and then define KPIs (Key Performance Index) in order to provide construction managers with construction material information such as lead time, material delivery rate, material installation rate and so on. This research proposes a method of effectively facilitating large amounts of data in the operating systems during the construction management process. In other words, the proposed method can supply structured and multi-perspective material-related information using data warehouse techniques.

Role of Radio Frequency Identification (RFID) in Warehouse and Logistic Management System using Machine Learning Algorithm

  • Laviza Falak Naz
    • International Journal of Computer Science & Network Security
    • /
    • v.24 no.6
    • /
    • pp.109-118
    • /
    • 2024
  • The world today is advancing towards a digital solution for every indusial domain varying from advanced engineering and medicine to training and management. The supply cycles can only be boosted via an effective management of the warehouse and a stronger hold over the logistics and inventory insights. RFID technology has been an open source tool for various MNCs and corporal organization who have progressed along a considerable drift on the charts. RFID is a methodology of analysing the warehouse and logistic data and create useful information in line to the past trends and future forecasts. The method has a high tactical accuracy and has been seen providing up to 99.57% accurate insights for the future cycle, based on the organizational capabilities and available resources. This paper discusses the implementation of RFID on field and provides results of datasets retrieved from controlled data of a practical warehouse and logistics system.

A Study on the Effective Spatial Data Warehouse (효율적인 공간 데이타 웨어하우스에 관한 연구)

  • 이기영
    • Journal of the Korea Society of Computer and Information
    • /
    • v.3 no.4
    • /
    • pp.126-131
    • /
    • 1998
  • Spatial data warehouse, whose importance is being increased, is composed of huge amounts of historical spatial data for organizational decision making and it also allows users to obtain useful geospatial information through analyzing and summmarizing spatial data. In this paper, we survey effective spatial multidimensional model which is based on virtual scenario for spatial data warehouse modelling. Therefore, we describe spatial multidimensional analytical query which provide multiple analytical functions according tom user's requests.

  • PDF