• Journal of Korea Multimedia Society
• /
• v.9 no.11
• /
• pp.1395-1409
• /
• 2006

A spatial data warehouse has spatial data cube composed of multi-dimensional data for efficient OLAP(On-Line Analytical Processing) operations. A spatial data cube supporting concept hierarchies holds huge amount of data so that many researches have studied a incremental update method for minimum modification of a spatial data cube. The Cube, however, compressed by eliminating prefix and suffix redundancy has coalescing paths that cause update inconsistencies for some updates can affect the aggregate value of coalesced cell that has no relationship with the update. In this paper, we propose incremental batch update method of a spatial data cube. The proposed method uses duplicated nodes and extended node structure to avoid update inconsistencies. If any collision is detected during update procedure, the shared node is duplicated and the duplicate is updated. As a result, compressed spatial data cube that includes concept hierarchies can be updated incrementally with no inconsistency. In performance evaluation, we show the proposed method is more efficient than other naive update methods.

• Digital Contents
• /
• no.6 s.73
• /
• pp.16-19
• /
• 1999

지난해 침체를 보였던 국내 데이터베이스(DB)산업이 경기 회복과 더불어 빠른 회복세를 보이고 있다. 특히 데이터 웨어하우스(DW)와 전자적자원관리(ERP) 시장이 활기를 띄고 있는 가운에 전자상거래 시장도 본격적인 기지개를 펴고 있다. 아울러 지식관리시스템 시장도 새로운 활로를 찾기 위한 방안을 모색하고 있다. 상반기 DB관련 시장 동향과 관련 전문가를 통해 현 시장의 문제점과 발전 방향을 살펴봤다.

• Digital Contents
• /
• no.2 s.57
• /
• pp.77-84
• /
• 1998

IMF 시대, 세계적인 기업들과의 심화된 경쟁환경에서 살아남기 위한 방안으로 정보기술을 활용한 전략적인 의사결정이 그 어느 때보다 중요한 이슈가 되고 있다. 엄청난 노력과 비용이 드는 데이터웨어하우스 혹은 통합 데이터베이스 구축은 기업내 축적된 데이터베이스를 효과적으로 활용하여 보다 나은 의사결정을 위한 전략 정보를 추출하는 것이 주요 목적이다. 데이터를 어떻게 활용할 것인가에 대한 중요 기술중의 하나가 바로 데이터마이닝이다. 그러나 데이터마이닝이 마치 마술상자로 오인되어 마이닝 툴만 가지고 있으면 모든 것이 저절로 해결될 것처럼 잘못 알려져 있는 경향이 있는 것도 사실이다. 본지에서는 데이터마이닝에 대한 정확한 이해를 돕기 위해 데이터마이닝에 대한 기본 이론과 기법, 실제 활용사례를 5회에 걸쳐 자세히 다루고자 한다.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.14 no.5
• /
• pp.2449-2456
• /
• 2013

The column-oriented database storage is a very advanced model for large-volume data analysis systems because of its superior I/O performance. Traditional data storages exploit row-oriented storage where the attributes of a record are placed contiguously in hard disk for fast write operations. However, for search-mostly datawarehouse systems, column-oriented storage has become a more proper model because of its superior read performance. Recently, solid state drive using MLC flash memory is largely recognized as the preferred storage media for high-speed data analysis systems. In this paper, we introduce fast column-oriented data storage model and then propose a new storage management scheme using a cross compressed replication for the high-speed column-oriented datawarehouse system. Our storage management scheme which is based on two MLC SSD achieves superior performance and reliability by the cross replication of the uncompressed segment and the compressed segment under high workloads of CPU and I/O. Based on the results of the performance evaluation, we conclude that our storage management scheme outperforms the traditional scheme in the respect of update throughput and response time of the column segments.

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

• Journal of Korea Multimedia Society
• /
• v.8 no.3
• /
• pp.297-312
• /
• 2005

Aggregation is an operation that plays a key role in multidimensional OLAP (MOLAP) systems of data warehouse. Existing aggregation operations in MOLAP have been proposed for file structures such as multidimensional arrays. These tile structures do not work well with skewed distributions. This paper presents a physical design methodology for storage structures ni MOLAP that use the multidimensional tile organizations adapting to a skewed distribution. In uniform data distribution, we first show that the performance of multidimensional analytical processing is highly affected by the similarity of the shapes between query regions and page regions in the domain space of the multidimensional file organizations. And than, in skewed distributions, we reflect the effect of data distributions on the design by using the shapes of the normalized query regions that are weighted with data density of those query regions. Finally, we demonstrate that the physical design methodology theoretically derived is indeed correct in real environments. In the two-dimensional file organizations, the results of experiments indicate that the performance of the proposed method is enhanced by more than seven times over the conventional method. We expect that the performance will be more enhanced when the dimensionality is more than two. The result confirms that the proposed physical design methodology is useful in a practical way.

• Journal of the Korea Institute of Building Construction
• /
• v.11 no.2
• /
• pp.100-107
• /
• 2011

As construction duration significantly influences the performance and the success of construction projects, it is necessary to appropriately manage the impact factors affecting construction duration. Recently, interest in the construction industry has been rising due to the recent change in the construction legal system, and the competition among the construction companies on construction time. However, the impact factors are extremely diverse. The existing productivity data on impact factors is not sufficient to properly identify the impact factor and measure the productivity from various perspectives, such as subcontractor, time, crew, work and so on. In this respect, a multidimensional analysis by a data warehouse is very helpful in order to view the manner in which productivity is affected by impact factors from various perspectives. Therefore, this research proposes a method that effectively takes the diverse productivity data of impact factors, and generates a multidimensional analysis. Decision tree analysis, a data mining technique, is also applied in this research in order to supply construction managers with appropriate productivity data on impact factors during the construction management process.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.16 no.9
• /
• pp.6376-6384
• /
• 2015

In practice of urban redevelopment promotion projects, since the decision-making is dependent on the verbal agreements between the participants, planning changes are frequently occur. A master plan can be utilized as an effective feedback and adjusting means for decisions. It is a difficult to establish a master plan quickly and effectively to consider the large number of information. Effective decision support system that can storage and retrieval information items systematically and efficiently necessary when planning master plan is required. In this study, a data-warehouse prototype that supports the master planning at early stage was suggested. A metadata index database was developed by identifying information items of base survey results and master plan cases. Also user interface for information searching was presented. The applicability of the prototype was evaluated by case application. It was found that the prototype allows effective searching of desired information through meta data.

• Proceedings of the Korean Institute of Communication Sciences Conference
• /
• 2006.07a
• /
• pp.731-731
• /
• 2006

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2007.06a
• /
• pp.805-806
• /
• 2007