• The KIPS Transactions:PartD
• /
• v.9D no.6
• /
• pp.971-980
• /
• 2002

As the importance of knowledge management is being recognized, there is a significant amount of increase for interest in data warehousing. On-Line Analytical Processing (OLAP) systems can effectively make use of data warehouses. Although there are many commercial OLAP products, they have been developed without any kind of standard resulting in poor data exchange and difficulty in interfacing among the OLAP products. In this paper we propose an OLAP metadata interchange model that can be used among different OLAP products and have implemented an OLAP metadata interchange system that can interchange the cubes created from the metadata. XML is used for the OLAP metadata model and the user interface is Web-based, which makes it easier to interchange metadata among different OLAP products. Users can experience the different analysis environments of different products without the need to learn the complex cube creation process for each product. By extending this research to design a common query language that can be used among OLAP products, OLAP products should be able to more easily talk to one another.

• Journal of Korea Society of Industrial Information Systems
• /
• v.19 no.2
• /
• pp.59-66
• /
• 2014

AGV is most often used for the automation of freight transportation in the manufacturing industry or the distribution warehouses. AGV is fairly costly and used in goods transport between the determined location. The main control device dedicated to AGV is often autonomously developed for simplification using PLC in industry field. However, AGV developed for simplification makes many errors in traffic because it is developed for the limited simple function. Control device dedicated to AGV has been developed to solve the problem but it is almost impossible to revise the device according to the character and structure of every manufacturing industry. The purpose of this study is to propose the design method of the control system interlocked with PLC and dedicated to AGV. The control system should be to improve the problem of traffic rolling and possible to be revised according to the character of factory. It is apparent the proposed AGV system is efficient in operation in the result of several traffic performance analysis through the tests.

• Journal of Digital Contents Society
• /
• v.16 no.1
• /
• pp.33-41
• /
• 2015

Since bitmap indices are useful for OLAP queries over low-cardinality data columns, they are frequently used in data warehouses. In many data warehouse applications, the domain of a column tends to be hierarchical, such as categorical data and geographical data. When the domain of a column is hierarchical, hierarchical bitmap index is able to significantly improve the performance of queries with conditions on that column. This strategy, however, has a limitation in that when a large scale hierarchy is used, building a bimamp for each distinct node leads to a large space overhead. Thus, in this paper, we introduce the way to build hierarchical bitmap index on an attribute whose domain is organized into a large-scale hierarchy in space-constrained environments. Especially, in order to figure out space overhead of hierarchical bitmap indices, we propose the cut-selection strategy which divides the entire hierarchy into two exclusive regions.

• Journal of Digital Convergence
• /
• v.15 no.9
• /
• pp.23-33
• /
• 2017

Given the expansion of globalization and international trade, the number of apparel consumers is growing every year, making it difficult to estimate the amount of handling needed from the logistics industry. To determine which management factors are important and which ones require improvement, fuzzy AHP was used. Using this method, the factors were ranked in the final analysis as follows: The first and most important factor was training employees (0.17), while the second was fire hazard management (0.169); the third-highest factor was inbound and outbound goods (0.142), and the fourth was the warehouse management system. Barcode management was ranked fifth. By these results, we were able to analyze the processes of clothing warehouses, noting that although the factors appear independent, they are actually connected while proceeding with full management control. Moreover, because of the special characteristics of garments, employee management is crucial. Due to the vulnerability of these goods to fire hazards, this factor must be well managed.

• Proceedings of the Korean Institute Of Construction Engineering and Management
• /
• 2008.11a
• /
• pp.877-882
• /
• 2008

The column gap of underground parking lots of office considering a business background and effective parking divisions is planned. A parking plan by column gap of fixed forms in atypical underground parking lots makes much extra storage rooms. Most of the edge of the parking lots are used for fan room. Part of the edge are located at parking ramps. Also warehouses are located in extra storage rooms. In this study compare study economical efficiency between life cycle costs and leases earnings. Consequently, It is proved that the warehouse rental is efficient because of lease earning guaranted years.

• Journal of KIISE:Databases
• /
• v.33 no.4
• /
• pp.353-362
• /
• 2006

A data warehouse is a data repository that enables users to store large volume of data and to analyze it effectively. In this research, we investigate an algorithm to establish a multidimensional data cube which is a powerful analysis tool for the contents of data warehouses and databases. There exists an inevitable retrieval overhead in a multidimensional data cube due to the sparsity of the cube. In this paper, we propose a dense sub-cube extraction algorithm that identifies dense regions from a large sparse data cube and constructs the sub-cubes based on the dense regions found. It reduces the retrieval overhead remarkably by retrieving those small dense sub-cubes instead of scanning a large sparse cube. The algorithm utilizes the bitmap and histogram based techniques to extract dense sub-cubes from the data cube, and its effectiveness is demonstrated via an experiment.

• Journal of Korean Society of Archives and Records Management
• /
• v.17 no.4
• /
• pp.155-175
• /
• 2017

This study explores the present state of the National Archives of Korea (NAK) and the branch archives and proposes development programs to reestablish their roles. With regard to the NAK, I discussed five issues, and for the branch archives, I discussed three. The issues on NAK are as follows: 1) Is NAK the nation's record keeper?; 2) Does NAK promote the establishment of local archives?; 3) Does NAK supervise and oversee the records management of all public institutions?; 4) What is the raison $d^{\prime}{\hat{e}}tre$ and the vision of NAK?; and 5) Does NAK perform a simple administrative service? Meanwhile, the issues on the branch archives are as follows: 1) Is the branch archives a permanent records management institution?; 2) Are the names of the branch archives appropriate?; and 3) Are the branch archives simple document warehouses?

• Journal of the Society of Disaster Information
• /
• v.14 no.3
• /
• pp.315-324
• /
• 2018

Purpose: This paper propose a temporary indoor positioning scheme with devices of internet of things (IoT) for disastrous situations in places without the infrastructure of networks. Method: The proposed scheme is based on the weighted centroid localization scheme that can estimate the position of a target with simple computation. Results: It also is implemented with the IoT devices at the underground parking lot, where the network is not installed, of general office building. According to the experiment results, the positioning error was around 10m without a priori calibration process at $82.5m{\times}56.4m$ underground space. Conclusion: The proposed scheme can be deployed many places without the infrastructure of networks, such as parking lots, warehouses, factory, etc.

• 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.

• Journal of Korea Port Economic Association
• /
• v.25 no.3
• /
• pp.1-20
• /
• 2009

A survey to pallet users was conducted in an aspect of the efficiency and benefit. The questionnaire identified the preference about the main variables such as price, size, conformity, material, which are the criteria of the users' choice. staffs in the capital region was selected as respondents and Cluster Analysis and Simulations was carried out with Conjoint Analysis. The result shows that the variables of material and conformity between facilities and products were more important than the variable of size. The respondents prefer the pallets with a various range of products because warehouses should keep a range of products under various condition of temperature. In accordance, the companies that provide a pallet pool service should set up individual marketing strategy by a type of customers so as to maximize the competitiveness in domestic or international markets. Furthermore, supplying standardized pallets should be consistent with the standardization not for individual logistics units, but for whole logistic systems. To achieve this, it requires the compatibility amongst a range of logistics activity participants by their characteristics.