• Proceedings of the Korean Information Science Society Conference
• /
• 2012.06c
• /
• pp.10-12
• /
• 2012

클라우드를 기반으로 한 대용량 데이터의 처리 및 분석의 요구가 커지면서, 대용량 관계형 데이터에 대한 분산 처리의 수요 또한 증가하고 있다. 본 논문은 HDFS를 사용하는 관계형 저장 시스템에서 대용량 데이터를 효율적으로 처리하기 위해 개발한 BST 기반 색인에 대해 설명한다.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2004.05a
• /
• pp.569-572
• /
• 2004

최근 데이터베이스를 이용한 정보처리응용 시스템이 증가하고 있는 추세이다. 이러한 응용 시스템의 데이터를 종합적으로 분석 처리하여 사용자 요구에 신속하게 응답할 수 있도록 다양하고 고품질의 정보 서비스를 지원하기 위해 데이터 웨어하우스 환경에 관한 연구가 많이 이루어지고 있다. 이러한 환경을 제공하기 위해서는 많은 데이터 정보가 요구되며, 이를 분석하여 사용자 의사 결정에 적합한 정보 추출 수행은 기존의 관계형 데이터베이스 환경의 테이블들에 대한 질의 수행에서 시간적인 낭비 요소가 많이 존재한다. 그러므로 본 논문에서는 사용자 질의에서 자주 요구되는 사실 혹은 데이터를 통합, 저장 및 수행하기 위한 테이블 생성을 사용자가 직접 선택 정의함으로써 편리하게 테이블 생성할 수 있도록 설계 및 구현한다. 또한 본 내용에서 포함되는 내용으로 기존 일반적인 SQL 질의를 수행할 수 있도록 한다.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2005.06a
• /
• pp.133-138
• /
• 2005

Automotive pulleys play a key role in driving the cooling pump, oil pump, air-conditioner and so on by using an engine power. Researches on design processes and technologies of the pulleys can be found in many literatures. On the other hand, the areas related to manufacturing processes of the pulleys have been treated negligently. Vast data extracted from various information systems are transformed, integrated, and summarized to become a special database for helping users make a decision. The database, namely the data warehouse has been popularly used in the marketing and customer management of enterprises and recently applied to improve the design and manufacturing processes. In this study the manufacturing process of pulleys were analyzed through the intensive investigation of shop-floors and the interviews with workers and managers. The defects generated during a manufacturing process were categorized in a few types and the causes of defects examined for extracting the dominant parameters in the setup process for producing pulleys. As the first step to construct the data warehouse for the manufacturing processes of pulleys, authors proposed its architecture focused on the reduction of defect rate during the setup process.

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

• Proceedings of the Korea Database Society Conference
• /
• 1999.06a
• /
• pp.403-413
• /
• 1999

Today's businesses are experiencing intensive global competition and the most accelerating pace of change ever. Competitors have sprung up that were not even on the business's radar. This environment impacts all decisions and strategies as business try to dominate their market or their industry merely to survive. So recently most of organizations are considering on building the data warehouse system to pursuit the business intelligence. We need the proper model to guide the approach to plan building data warehouse system when we want to plan it in considering the organizational status. Therefore we suggest a model to decide the approach to build data warehouse considering the project's environmental factors. First we review Ronald S. Swift(1998)'s five environmental factors that we have to consider when planing to build data warehouse. Then we propose a model to decide DW approach by the degree of those factors to be measured. DW approaches in this model are classified in conservative approach, technological approach, increasing approach. enterprise- wide approach, and ideal approach.

• Asia pacific journal of information systems
• /
• v.14 no.3
• /
• pp.169-187
• /
• 2004

Self-maintainability of data warehouse(DW) views is an ability to maintain the DW views without requiring an access to (i) any underlying databases or (ii) any information beyond the DW views and the delta of the databases. With our proposed method, DW views can be updated by using only the old views and the differential files such as different files, referential integrity differential files, linked differential files, and backward-linked differential files that keep the truly relevant tuples in the delta. This method avoids accessing the underlying databases in that the method achieves self-maintainability even in preparing auxiliary information. We showed that out method can be applicable to the DW views that contain joins over relations in a star schema, a snowflake schema, or a galaxy schema.

• 한국디지털정책학회:학술대회논문집
• /
• 2003.12a
• /
• pp.191-210
• /
• 2003

In modern dynamic management environment, there is growing recognition that information & knowledge management systems are essential for CEO's Efficient/effective decision making, As a key component to cope with this current, we suggest the management performance analysis system based on Knowledge Discovery in Database (KDD). The system measures management performance that is considered with both VA(Value-Added), which represents stakeholder's point of view and EVA(Economic Value-Added), which represents shareholder's point of view, The relationship between management performance and some 80 financial ratios is analyzed, and then important financial ratios are drawn out. In analyzing the relationship, we applied KDD process which includes such as multidimensional cube, OLAP(On -Line Analytic Process), data mining and AHP(Analytic Hierarchy Process). To demonstrate the performance of the system, we conducted a case study using financial data over the 16-years from 1981 to 1996 of Korean automobile industry which is taken from database of KISFAS(Korea Investors Services Financial Analysis System).

• Electronics and Telecommunications Trends
• /
• v.19 no.5 s.89
• /
• pp.41-52
• /
• 2004

기업들은 전자우편, 전자상거래, 데이터웨어하우스, 네트워크 기반 응용 등에서 산출되는 대량의 데이터를 지속적으로 축적하기 위한 스토리지(storage) 기반 구축에 심혈을 기울이고 있다. 이는 기업들이 자신의 고객들에게 경쟁력이 있는 보다 나은 서비스를 제공할 뿐만 아니라 기업의 생산성을 높이기 위한 수단으로 활용하기 때문이다. 실제로, 기업에서 비즈니스 프로세스를 지원할 수 있는 스토리지 구축에 대한투자가 전략적으로 이루어지고 있으나, 여러 문제들에 직면해 있다. 본 고에서는 기존 스토리지 시스템들에서 야기되는 기술적 한계를 살펴보고, 이를 해결하기 위한 차세대 스토리지 시스템으로 연구가 진행되는 객체기반 스토리지 시스템의 기술을 살펴본다. 그리고, 개발된 객체기반 스토리지 시스템들의 사례 조사를 통해 기술 개발의 현 주소를 파악해 본다.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.24 no.67
• /
• pp.49-60
• /
• 2001

Data warehouse(DW) manages all information in a Enterprise and also offers the specific information to users. However, it might be difficult to develope an effective DW system due to varieties in computing facilities, data base, and operating systems. The heterogeneous system environments make it harder to extract data and to provide proper information to usesr in real time. Also commonly occurred is data inconsistency of non-integrated legacy system, which requires an effective and efficient data extraction flow control as well as data cleansing. We design the integrated automatic ETT(Extraction Transformation Transportation) system to control data extraction flow and suggest implementation methodology. Detail analysis and design are given to specify the proposed ETT approach with a real implementation.

• Proceedings of the Korean Institute of Building Construction Conference
• /
• 2011.05a
• /
• pp.163-165
• /
• 2011

Construction documents or Data is highly valuable as the information that process are stored in. However it is not systematically manage to a document, productivity decrease and important information that can be reused to other projects is lost. The purpose of this study is a development for linked management prototype of construction data and documents that can manage to construction documents along with data, based on stored data, create second information. It is anticipated that searching time and efforts will be effectively reduced.