• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.12 no.6
• /
• pp.1087-1094
• /
• 2008

Recently, XML has been widely used as a standard for a data exchange, and there has emerged the tendency that the size of XML document becomes larger. The data transfer can cause problems due to the increase in traffic, especially when a massive data such as Data Warehouse is being collected and analyzed. Therefore, an XMDR wrapper can solve this problem since it analyzes the tree structures of XML Schema, regenerates XML Schema using the analyzed tree structures, and sends it to each station with an XMDR Query. XML documents which are returned as an outcome encode XML tags according to XML Schema, and send standardized messages. As the formalized XML documents decrease network traffic and comprise XML class information, they are efficient for extraction, conversion, and alignment of data. In addition, they are efficient for the conversion process through XSLT, too, as they have standardized forms. In this paper we profuse a method in which XML Schema and XMDR_Query sent to each station are generated through XMDR(extended Meta-Data Registry) and the generation of products and XML conversion occur in each station wrapper.

• IE interfaces
• /
• v.15 no.2
• /
• pp.159-171
• /
• 2002

Data Warehouses integrate data from multiple heterogeneous information sources and transform them into a multidimensional representation for decision support applications. Data warehousing has emerged as one of the most powerful tools in delivering information to users. Most previous researches have focused on marketing, customer service, financing, and insurance industry. Further, relatively less research has been done on data warehouse systems in the complex manufacturing industry such as ship production, which is characterized complex product structures and production processes. In the ship production, data warehouse systems is a requisite for effective cost analysis because collecting and analysis of diverse and large of cost-related(material/production cost, productivity) data in its operational systems, was becoming increasingly cumbersome and time consuming. This paper proposes architecture of the data warehouse systems to support cost analysis in the ship production. Also, in order to illustrate the usefulness of the proposed architecture, the prototype system is designed and implemented with the object of the enterprise of producing a large-scale ship.

• IE interfaces
• /
• v.17 no.4
• /
• pp.426-439
• /
• 2004

This research discusses knowledge contents needed to build an OLAP system for medical sector, OLAP functionalities from past studies, and a medical intelligence system which is a kind of OLAP. The knowledge requirements which consist of nine contents and OLAP fundamental functionalities are applied to the system. Most past studies have focused on developing a medical data warehouse rather than OLAP. The medical intelligence system supplies health care providers (i.e., doctors, clinicians, researchers and nurses) and non-providers (i.e., managers and business analysts) with multidimensional OLAP functionalities. The system can be used to gain a deeper understanding of specific medical issues. In this research, we focus not on medical data warehouse, but on the technical challenges of designing and implementing an effective medical intelligence system for health care information. An architecture is applied to developing the medical intelligence system for a medical center in order to illustrate its practical usage. Six packages in the developed system are discussed in this research: Explorer, Analyzer, Reporter, Statistician, Visualizer, and Meta Administrator packages. Evaluation of the system and ongoing research directions conclude the research.

• Proceedings of the Korea Contents Association Conference
• /
• 2009.05a
• /
• pp.463-466
• /
• 2009

Some strategies for the integrated water management system based on GIS was suggested for the comprehensive and systematic management on the watershed. Contents of database and thematic layers for the related elements with GIS was indicated to estimate the quantity of total pollution loads and to simulate the water quality. Also, functions for the information providing was suggested on the connection with spatial data and attribute data, the search for collected data, the analysis for time series, and the visual presentations. Finally, it was suggested to integrate the existing systems and database structures, and to construct of data warehouse.

• Journal of the Korea Society of Computer and Information
• /
• v.15 no.1
• /
• pp.201-206
• /
• 2010

According to the ubiquitous technology development, managing of the warehouse system which stores and manages agriculture products is realized effectively. This paper proposes an ontology-based context aware system model for the purpose of storing and managing agricultural products using ubiquitous sensors to share and distribute information. In these days, owing to penetrating ubiquitous technologies into our way of life, the importance of information is increasing gradually. The importance of ontology in a domain is getting as well. Therefore, this paper focuses on describing to get data from ubiquitous devices such as sensors, and designs and build an ontology-based agricultural product warehouse model.

• Spatial Information Research
• /
• v.15 no.3
• /
• pp.347-362
• /
• 2007

GIS has been rapidly developed since 1995 when the Ministry of Construction and Transportation started the First National GIS Construction Project and built large scale topographic map at local governments level. From that time local governments have been built several application system such as road management system, waterworks management system, sewer management system, underground facilities management system, and urban planning information system, etc. However, the construction of GIS application system at different department level brings the problem of data sharing and overlapping database construction. To overcome this environment Enterprise GIS concepts has been introduced. In case of Seoul Metropolitan government Spatial Data Warehouse have been constructed. However, Seoul Metropolitan government still have the problem of inactive use of GIS system and adaption to the rapidly changing information environment. This study aims to present Strategic plan to uggrade Enterprise GIS concenpt from data centric to service centric architecture at local government level.

• Journal of Korea Society of Industrial Information Systems
• /
• v.15 no.2
• /
• pp.115-126
• /
• 2010

Modern society can be described as ubiquitous computing over the concept of information. Information technology(IT) has been developing in a way that relative technologies are integrated to each other. Especially in ubiquitous environment, medical information industry shows significant interest in the U-healthcare service area. This paper will first look into U-healthcare service environment and component of Integrated Medical Information Systems(IMIS). Secondly, it examines the basic technological factors for integrated medical information systems, which is datawarehouse, network, communication standards and technology related U-healthcare service. Finally it proposes how to implement and operate new integrated medical information system for ubiquitous health care service. The system will do point of care(POC) for customers by real time and diagnose them using their various and personal medical data. The information will be communicated back to the customers, which will improve their satisfaction.

• Journal of the Korea Society of Computer and Information
• /
• v.17 no.2
• /
• pp.215-224
• /
• 2012

This study performs an exploratory investigation of the needs of the customers who use academic information service from a research institute, K, that provides information services for domestic academic institutions of natural science and technology. K institute is planning customized services in order to improve customer satisfaction on the academic information service And therefore, the institute begins the research on customer needs analysis and customer segmentation. The research is regarded as well-timed, because CRM implementation in public organizations has been activated recently. Data mining and data warehousing techniques were used for pilot analyses. For the purpose of customer segmentation, a mixed segmentation model, which adds product life cycle concept to the 'balanced customer segmentation' model, which in turn considers the value of customers from the organizational viewpoint and the value of organizations from the customer's viewpoint, simultaneously, was applied. The result of investigation indicated that, in the case of K, 'balanced customer segmentation' and 'contents reach approach' which uses data warehouse/OLAP, rather than those customer segmentation techniques that are often used within the industry, are the more potent ways of approach. This exploratory case study is expected to provide a useful guideline for 'deriving an organizationally unique CRM model' that recently is one of the hot topics in the CRM area.

• The KIPS Transactions:PartD
• /
• v.16D no.4
• /
• pp.463-474
• /
• 2009

To analyze multidimensional data conveniently and efficiently, OLAP (On-Line Analytical Processing) systems or e-business are widely using views in a horizontal form to represent measurement values over multiple dimensions. These views can be stored as materialized views derived from several sources in order to support accesses to the integrated data. The horizontal views can provide effective accesses to complex queries of OLAP or e-business. However, we have a problem of occurring maintenance of the horizontal views since data sources are distributed over remote sites. We need a method that propagates the changes of source tables to the corresponding horizontal views. In this paper, we address incremental maintenance of horizontal views that makes it possible to reflect the changes of source tables efficiently. We first propose an overall framework that processes queries over horizontal views transformed from source tables in a vertical form. Under the proposed framework, we propagate the change of vertical tables to the corresponding horizontal views. In order to execute this view maintenance process efficiently, we keep every change of vertical tables in a differential file and then modify the horizontal views with the differential file. Because the differential file is represented as a vertical form, its tuples should be converted to those in a horizontal form to apply them to the out-of-date horizontal view. With this mechanism, horizontal views can be efficiently refreshed with the changes in a differential file without accessing source tables. Experimental results show that the proposed method improves average performance by 1.2$\sim$5.0 times over the existing methods.

• Journal of Korean Society for Geospatial Information Science
• /
• v.17 no.1
• /
• pp.121-129
• /
• 2009

Today, it is difficult to re-use and share spatial information, because of the explosive growth of heterogeneous information and specific characters of spatial information accumulated by diverse local agency. A spatial analysis of subsurface spatial informa-tion, one of the National Spatial Data Infrastructure, needs related spatial information such as, topographical map, geologic map, underground facility map, etc. However, current methods using standard format or spatial datawarehouse cannot consider a se-mantic hetergenity. In this paper, the layered ontology model which consists of generic concept, measuremnt scale, spatial model, and subsurface spatial information has developed. Also, the current ontology building method pertained to human experts is a expensive and time-consuming process. We have developed the MDA-based metamodel(UML Profile) of ontology that can be a easy under-standing and flexiblity of environment change. The semantic quality of devleoped ontology model has evaluated by reasoning engine, Pellet. We expect to improve a semantic sharing, and strengthen capacities for developing GIS experts system using knowledge representation ability of ontology.