• Proceedings of the Korean Information Science Society Conference
• /
• 2000.10a
• /
• pp.163-165
• /
• 2000

고객 DB를 통해 세분 고객별로 구매량, 주요 고객을 파악케 하며 각종 마케팅 활동이나 판촉활동이 고객의 구매/이용 패턴에 어떤 영향을 미치며, 물품을 구매하는 소비자의 다양한 구매 패턴을 분석하기 위해서 쇼핑몰 운영자가 여러 각도에서 문제 분석과 의사 결정을 빠르고 신속하게 할 수 있도록 기존 쇼핑몰의 관계형 DB을 이용하여, 다차원적 데이터 모델링을 통해서 다차원적인 분석이 가능하도록 하는 ROLAP를 이용한 인터넷 쇼핑몰의 데이터 웨어하우스 구축 방안을 제시하고자 한다.

• Annual Conference of KIPS
• /
• 2008.11a
• /
• pp.318-321
• /
• 2008

국제물류 EPCglobal Network 프레임워크에서 대용량 운송 데이터베이스의 누적과 경영 전략의 의사결정에 필요한 지식 탐사를 위해 데이터 웨어하우스 시스템 도입이 요구된다. 따라서 본 연구에서는 국제물류 통합 플랫폼을 지원하는 데이터 웨어하우스를 설계하기 위해 현재 데이터베이스 시스템을 분석하고 다차원 데이터 모델인 사실 별자리 스키마 구조를 이용한다. 또한 설계된 데이터웨어하우스를 통해 의사결정을 지원할 수 있는 지식탐사를 위한 질의들의 예를 보여준다.

• The KIPS Transactions:PartD
• /
• v.10D no.3
• /
• pp.407-416
• /
• 2003

As the usage of database systems dramatically increases and the amount of data pouring into them is massive, the performance administration techniques for using database systems effectively are getting more important. Especially in data warehouses, the performance management is much more significant mainly because of large volume of data and complex queries. The objectives and characteristics of data warehouses are different from those of other operational systems so adequate techniques for performance monitoring and tuning are needed. In this paper we extend functionalities of the DBMax, a performance administration tool for Oracle database systems, to apply it to data warehouse systems. First we analyze requirements based on summary management and ETL functions they are supported for data warehouse performance improvement in Oracle 9i. Then, we design architecture for extending DBMax functionalities and implement it. In specifics, we support SQL tuning by providing details of schema objects for summary management and ETL processes and statistics information. Also we provide new function that advises useful materialized views on workload extracted from DBMax log files and analyze usage of existing materialized views.

• The Journal of the Convergence on Culture Technology
• /
• v.6 no.3
• /
• pp.401-412
• /
• 2020

This study analyzed the causes of warehouse fires using a creative problem-solving technique called TRIZ. It identified preventive measures by applying 4M. The results are as follows. First, this study examined the inconsistency among the causes of warehouse fires using TRIZ. Second, it analyzed human factors and fire prevention measures in warehouses such as safety standards for managers, and methods for the promotion of safety consciousness among workers, and for the reinforcement of construction technology for sandwich panel workers. Third, it identified the mechanical and facility factors and fire prevention measures in warehouses such as safety facilities, the expanded installation of safety devices, the adoption and development of fire suppression equipment, and the deployment of methods to improve the fire resistance of sandwich panels. Fourth, it presented working and environmental factors and fire prevention measures in warehouses such as the tightening of safety precautions and the supervision of working methods, and setting fire partitions both in loading places and based on performance-based design. Finally, it proposed managerial factors and fire prevention measures in warehouses such as specific targeting for firefighting with low fire hazards, reviewing the material quality regulations of non-combustible or higher for sandwich panels in the specific target of firefighting that cannot apply fire safety standards, installing sprinklers in cold storage, and mandating the installation of automated facilities with retroactive application regardless of the floor area in the warehouse with a sandwich panel structure.

• Fire Science and Engineering
• /
• v.30 no.3
• /
• pp.23-30
• /
• 2016

A fire extinguishing system for a rack warehouse was recently designed, which only consider the gross area and number of stories. However, the design of such a system should take into account not only the planar structuree, but also the elevation perspectives due to its vertical structure. Moreover, the fire load of the commodities palletized on the racks should be considered, in order to design a performance-based fire safety system that is appropriate for these environmental conditions. For this reason, this study analyzed the fire characteristics of the commodities palletized on the racks (pallet + the commodities in a box unit + vinyl packing material), taking into consideration the results of a field investigation conducted in Korea, as well as the Hazard Classifications of Commodities used in other countries. Through this analysis, the heat release rate (HRR) and smoke production rate (SPR) were derived.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2004.05b
• /
• pp.354-357
• /
• 2004

Data warehouse is subject-oriented, integrated, non-volatiled data, and it used for OLAP(On-Line Analytical Processing) the extraction of information from making decision processing. In the present, lots of study have been devoted to multidimensional modeling between OLAP operator and star schema. In this paper, the design of using the snowflake schema for object-oriented conceptual relation is more extended than using drill-across operator. The object-oriented relation schema which was not applicable has been improved through the design.

• Journal of Distribution Science
• /
• v.7 no.4
• /
• pp.47-56
• /
• 2009

The purpose of this study is to present an alternative improving the efficient and reasonable of the physical distribution system management is influenced by many factors. Therefore, the study depends on the documentary method and survey method to achieve the purpose of this study. The major components of a physical distribution system are refers to as elements, include warehouse·storage system, transportation system, inventory system, physical distribution information system. The factors used in this study are ① factor of product(quality·A/S·added value of product·adaption of product·technical competitive power to other enterprises), ② factor of market(market channel·kinds of customer·physical distribution share), ③ factor of warehouse·storage(warehouse design·size·direction·storage ability·warehouse quality), ④ factor of transportation(promptness·reliability·responsibility·kinds of transportation·cooperation united transportation system·national transportation network), ⑤ factor of packaging (packaging design·material·educating program·pollution degree measure program), ⑥ factor of inventory(ordinary inventory criterion·consistence for inventories record), ⑦ factor of unloaded(unloaded machine·having machine ratio), ⑧ factor of information system (physical distribution quantity analysis·usable computer part), ⑨ factor of physical distribution cost(sales ratio to product) ⑩ factor of physical distribution system(physical distribution center etc). The implication of this study can be summarized as follows: ① In firms that have not adopted a systems integrative approach, physical distribution is a fragmented and often uncoordinated set of activities spread throughout various functions with function having its own set of priorities and measurements. ② The physical distribution is recognized as more an important strategic factor than a simple cost reduction factor, ③ It can be used a strategic competition tool to enterprise.

• Journal of the Korean Society of Systems Engineering
• /
• v.17 no.2
• /
• pp.122-128
• /
• 2021

Despite various economic crises, the domestic parcel delivery market handled 3.37 billion parcels in 2020 while maintaining annual growth due to the activation of e-commerce. In particular, in the case of the metropolitan area, which accounts for about 70% of the nation's parcel throughput, the increase in parcel delivery volume is directly related to the increase in freight vehicles in central area of Seoul,. And it leads to an increase of unnecessary social and environmental costs such as traffic congestion, road damage, and environmental pollution in the city. Therefore, in this paper we proposed the underground urban logistics system utilizing the existing urban rail infrastructure, and establish a conceptual design by operational scenario. In order to establish conceptual design of underground urban logistics system, we use order picking system process, which is use in warehouse, produce result combined ISO/IEC 26702. The results of this study can be usefully used before the underground urban logistics system is introduced.

• Spatial Information Research
• /
• v.13 no.3 s.34
• /
• pp.239-252
• /
• 2005

The major reason that spatial data warehousing has attracted a great deal of attention in business GIS in recent years is due to the wide availability of huge amount of spatial data and the imminent need for fuming such data into useful geographic information. Therefore, this research has been focused on designing and implementing the pilot tested system for spatial decision making. The purpose of the system is to predict targeted marketing area by discriminating the customers by using both transaction quantity and the number of customer using credit card in department store. Moreover, the pilot tested system of this research provides OLAP tools for interactive analysis of multidimensional data of geographically various granularities, which facilitate effective spatial data mining. focused on the analysis methodology, the case study is aiming to use GIS and clustering for knowledge discovery. Especially, the importance of this study is in the use of snowflake schema model capabilities for GIS framework.

• Journal of the Computational Structural Engineering Institute of Korea
• /
• v.28 no.6
• /
• pp.579-588
• /
• 2015

The data model for structural experiment information formally organizes the information involved in the structural experiments before the data repository using the data model is implemented. The data model is particularly required for the data repositories for the large-scale structural experiment information and the general information for various types of experiments, such as the NEEShub Project Warehouse developed by NEES. This paper proposes criteria for evaluating the organization and the use of design model for structural experiment information. The term of AVE(attribute value existence) indicates the ratio of attributes who values exist in objects, and then used for defining the Attribute AVE for the use of an attribute, the Class AVE for a class, the Class Level AVE for a class including its lower-level classes, the Project AVE for a project including all classes at class levels, and the Data Model AVE for a data model including projects. These criteria are applied to the projects in the NEES data model, and it is successively possible to numerically describe the evaluation of the use of classes and attributes in the data model.