• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.6 no.8
• /
• pp.1336-1345
• /
• 2002

Materialized views in data warehouse play important roles in rapidly answering to users's requests for information Processing. More views in data warehouse, can respond to the users more rapidly because the user's requests may be processed by using only the materialized views with higher probabilities rather than accessing base relations. The limited duration, during which the materialized views are updated due to base relations's changes, limits the number of materialized views in data warehouse. In this paper, we propose efficient policy for updating the materialized views, which can save the update duration of views although MIN/MAX values frequently change in base relation. The policy updates the materialized views by distinguishing whether MIN/MAX values's changes in the base relation are insert value or delete value. Then, the number of accesses to the base relation is descreased when updating the MIN/MAX values in the materialized views.

• Information Systems Review
• /
• v.7 no.1
• /
• pp.65-80
• /
• 2005

The Seoul Metropolitan Subway Corporation (SMS) and the Seoul Metropolitan Rapid Transit Corporation (SMRT), which manage the city's eight subway lines, are intending to overcome their operational inefficiencies. The two investigators of the paper realize with emphasis that it is essential for the two subway authorities to analyze subway transit data prior to put policies and plans into practice. In this paper, the investigators propose a new, and an intuitive, way of analyzing subway passenger transit patterns. To achieve this goal, they have implemented a data mart by blending the "Pass Card" log data into the multidimensional model. The subway passenger's transit patterns and the practical implications of this system are also investigated.

• Journal of Internet Computing and Services
• /
• v.3 no.2
• /
• pp.39-56
• /
• 2002

In distributed computing environments, there are many database applications that should share data each other such as data warehousing and data mining with autonomy on local databases. The first step to such applications is the integration of heterogeneous database schema, but there is no accepted common data model for the integration and also are difficulties on the construction of integration program. In this paper, we use the XML Schema for the representation of common data model and exploit XSLT for reducing the programming difficulties. We define the schema integration operations and develop a methodology for the semi-automatic schema integration according to schema conflicts types. Our integration method has benefits on standardization, extendibility on schema integration process comparing to existing methodologies.

• Journal of Information Technology Applications and Management
• /
• v.24 no.1
• /
• pp.45-61
• /
• 2017

Business intelligence has been attracting much attention these days. Despite such popularity of BI systems, it is widely known that about a half of BI system projects have failed. To grasp why many BI projects end in failure and what factors would make BI projects less failure-prone, a number of BI studies were made to produce a variety of CSFs. However, there is a paucity of information on whether these CSFs are distinctive from those of typical information systems. By identifying how BI CSFs differ from CSFs of typical information systems, we would be able to explain why most BI projects are more likely to be failure. It is believed that a corrective measure about CSFs will lead to more success in future BI projects. In addition, though there have been a number of similar types of BI systems such as decision support systems and executive information systems in existence, there was no study to determine whether there is ever a discrimination between CSFs of BI systems and the similarly-titled systems. This study is to answer these questions using a literature review analysis. The findings of our study are expected to be helpful in a successful implementation of BI systems.

• Journal of the Korea Society of Computer and Information
• /
• v.13 no.1
• /
• pp.65-73
• /
• 2008

The telematics data management deals with queries on stream data coming from moving cars. So the stream DBMS should process the large amount of data stream in real-time. In this article, previous research projects are analyzed in the aspects of query processing. And a hybrid model is introduced where query preprocessor is used to process all types of queries in one singe system. Decreasing cost and rapidly increasing Performance of devices may guarantee the utmost parallelism of the hybrid system. As a result, various types of stream DBMS queries could be processed in a uniform and efficient way in a single system.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.49 no.1
• /
• pp.35-42
• /
• 2007

This paper develops a Sustainable Regional Economic Growth Model (SREG) which estimates the relation of labor population change and employment increase in each occupation and maximum limits and minimum requirements of employment increase by labor population change in a specified region using multiplier theory. To develop the proposed model, sustainable regional economic growth is defined as a steady increase of labor population over a long term period and the limit of employment increase is defined as the estimated labor population change in the region with no need for commutation from the surrounded areas. Developed model was applied to 67 county in Pennsylvania State and the results revealed that the investment in infrastructure occupations, such as transportation, warehousing, utilities, information, communication, and other public utilities, maximizes the effects for increasing employment, whereas finance, insurance, and real estate occupations have minimum effects for increasing employment. Calculated minimum requirements of occupations show that infra-structure occupations is a critical factor for labor population change and maximum limits of occupations show that agriculture and finance occupations are difficult to increase independently.

• Journal of Information Technology and Architecture
• /
• v.10 no.1
• /
• pp.71-77
• /
• 2013

XML schema matching is the task of finding semantic correspondences between elements of two schemas. XML schema matching plays an important role in many application, such as schema integration, data integration, data warehousing, data transformation, peer-to-peer data management, semantic web etc. In this paper, we propose an XML element matching algorithm based on rules and structural properties. The proposed algorithm involves classifying elements as unique or non-unique elements according to the structural properties of XML documents and deciding on element matching in accordance with rules. We present experimental results that demonstrate the effectiveness of the proposed approach.

• Journal of The Korea Institute of Healthcare Architecture
• /
• v.21 no.1
• /
• pp.27-36
• /
• 2015

Purpose : Ministry of Health & Welfare started to 'Comprehensive care ward' project for patient hospitalization in order to help the economic and medical By providing comprehensive care services through professional nursing staff since 2013. Many physical environments changes are expected by providing comprehensive care services. The purpose of this study is to investigate the comprehensive care services and identify the problems of the corresponding physical environment usage. Methods : Data were collected through research, field surveys, and expert interviews to analyze and investigate the physical environment of the 'Comprehensive care ward'. Results : Physical environments changes in accordance with the comprehensive care services provided in 'Comprehensive care ward' are being only partially achieved. It have to considered not only ward environmental improvement for nursing services provided directly to the patient, but Including nurses warehousing space, work space. Implications : Comprehensive care ward project is scheduled to be operational even some wards throughout the hospital since 2018. This study is basic research for architectural planning of the future ward with comprehensive care services in public hospital.

• The Transactions of the Korea Information Processing Society
• /
• v.7 no.1
• /
• pp.20-28
• /
• 2000

In distributed data processing environments, heterogeneous data sources should corporate each other. The CORBA standards proposed by OMG solve this problem by the integration of platform independent applications. In this paper, we design and implement a CASE tool that help linking CORBA applications to relational databases by interface method. This CASE tool manipulates the database schema and generates IDL and $C^{++}$ stubs corresponding to the schema. We explain the code generation process and evaluate the data access performance of the interface method compared to adapter method and various implementation languages. The implemented tool can be used for developing applications that need relational database corporation environments such as distributed information systems or data warehousing. etc.

• Journal of the Korean Society of Manufacturing Technology Engineers
• /
• v.18 no.6
• /
• pp.565-575
• /
• 2009

A forklift (also called a lift truck) is a powered industrial truck that is used to lift and transport materials. It has become an indispensable piece of equipment in manufacturing and warehousing operations. The modem forklift is equipped with automatic transmission to meet the requirement of loading and easy operation of the vehicle. This paper proposes the design of TECU(Transmission Electronic Control Unit) which is applied to PSD322-Axle transmission. Garofalo's control technique is generally used to the automatic transmission. We consider the work quality and market requirement that does not want to control engine throttle. This paper proposes new controller system which guarantees efficient speed changes with simple system. This new system does not control the engine throttle spontaneously. But it has the load of engine and vehicle as a maximum disturbance. The scope of the disturbance is limited to the stoll area of the torque converter. This paper proposes a ideal control commander that converges relative velocity of the input and ouput of a clutch into a zero. We design linear controller to execute the idea control commander. We applied the control algorithm to the forklift of PSD322-Axle type and the performance of this controller was verified.