• Proceedings of the Korea Information Processing Society Conference
• /
• 2003.11c
• /
• pp.1449-1452
• /
• 2003

국내에서 지방자치단체의 정보화 추진은 정보화의 변화 추세에 따라 업무별로 자료를 구축하여 활용되고 있으나 통합적으로 연결된 형태의 자료구축이 이루어지지 않고 있어 현 정보시스템의 활용 효율을 높이고 의사결정지원을 위한 정보시스템의 구축이 필요하다. 이에 지방자치단체에서 업무적으로 연결된 통합 DB(Database)와 DW(Data Warehouse)를 구축하여 업무 편리성을 높이고 의사결정에 활용할 수 있는 모델을 제시한다.

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

• Journal of Information Technology Services
• /
• v.8 no.1
• /
• pp.1-9
• /
• 2009

It is essential for companies to manage massive data for dealing with large volume of transactions and customers' needs. To this end, the companies have operated data warehouse with many complex tools for data gathering and reporting to the end-users. However, the data from the heterogeneous tools at the various sources cannot be exchanged because of the different interfaces. Therefore, the data cannot be controlled with integrated manner, and furthermore the companies do not focus the quality of data resulting in the data quality problem. Thus, this study suggests how to manage massive data with a metadata. In particular, we investigate current status of metadata management, its appliance, and perspectives. The contribution of this research is to apply the metadata management system to the real world and to suggest its management procedure.

• The Journal of Korean Institute for Practical Engineering Education
• /
• v.4 no.1
• /
• pp.80-85
• /
• 2012

The importance of warehouse is increasing since the role of warehouse in modern industry is changing from concept of storage to concept of circulation which facilitates purchasing, production, storage and distribution activities by induction of information system. In this study, a program is developed using C# for evaluating efficiency of automated storage and retrieval system(AS/RS). A simulation work is done for eight operating schemes under the combination of three conditions, which are storing method, the shape of automatic warehouse and the sequence of command performs, and the moving distance of stacker crane is calculated using the same gateway data. Using this program, the optimal operating scheme can be proposed based on the analyzed results of simulation. This progrm shows the effectiveness and applicability through the simulation work and can be utilized for courses which are related to factory facilities.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2000.04a
• /
• pp.28-35
• /
• 2000

In order to acquire the precise and fast response for an analytical query, proper selection of the views to materialize in data warehouse is very crucial. In traditional algorithms, the whole relation is considered to be selected as materialized views. However, materializing the whole relation rather than a part of relation results in much worse performance in terms of time and space cost. Therefore, we present a new algorithm for selection of views to materialize using clustering method in order to improve the performance of data warehouse including this problem. In the presented algorithm, ASVMR(Algorithm for Selection of Views to Materialize using Reduced table), we first generate reduced tables in data warehouse using automatic clustering based on attribute-values density, then we consider the combination of reduced tables as materialized views instead of the combination of the original base relations. We also show the experimental results in which both time and space cost are approximately 1.8 times better than the conventional algorithms.

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

• Genomics & Informatics
• /
• v.2 no.4
• /
• pp.191-194
• /
• 2004

Exponentially increasing biopathway data in recent years provide us with means to elucidate the large-scale modular organization of the cell. Given the existing information on metabolic and regulatory networks, inferring biopathway information through scientific reasoning or data mining of large scale array data or proteomics data get great attention. Naturally, there is a need for a user-friendly system allowing the user to combine large and diverse pathway data sets from different resources. We built a data warehouse - BIOWAY - for analyzing and visualizing biological pathways, by integrating and customizing resources. We have collected many different types of data in regards to pathway information, including metabolic pathway data from KEGG/LIGAND, signaling pathway data from BIND, and protein information data from SWISS-PROT. In addition to providing general data retrieval mechanism, a successful user interface should provide convenient visualization mechanism since biological pathway data is difficult to conceptualize without graphical representations. Still, the visual interface in the previous systems, at best, uses static images only for the specific categorized pathways. Thus, it is difficult to cope with more complex pathways. In the BIOWAY system, all the pathway data can be displayed in computer generated graphical networks, rather than manually drawn image data. Furthermore, it is designed in such a way that all the pathway maps can be expanded or shrinked, by introducing the concept of super node. A subtle graphic layout algorithm has been applied to best display the pathway data.

• The KIPS Transactions:PartD
• /
• v.11D no.1
• /
• pp.183-194
• /
• 2004

The existing management job of research expenses has been divided into three parts： budget planning, budget draw-up, and exact settlement of budget. However, it caused some problems. Under this current circumstance it is required to obtain research expenses steadily, to operate efficiently and to use them clearly to solve such problems. As a result of a study on data warehouse development process of existing system integration company (Inmon, IBM) to reflect current trend described above, data warehouse development process of Inmon uses systematic and gradual access as a classical development cycle method. It causes overlap and feedback to the previous step in the process of each step Is requested. And another problem that it is difficult to toil what function refers and corrects data because functions and data are separated during performing development process at data warehouse development process of IBM is caused. Integrated management data warehouse development process of research expenses in the enterprise environment which applies UML at planning and analysis step, design step and implement and test step is suggested in this paper. Information retrieval agent uses existing budget plan DB, budget draw-up DB and budget settlement DB to find out information that a user wants to know. Information retrieval agent collects and saves information at integration database and information integration agent extracts, transports, transforms and loads the data. Information integration agent reduces a user's efforts to access to a number of information sources and check each of them. It also screens out data that a user may not need. As a result, integrated management data warehouse development process of research expenses in the enterprise environment reflects a user's requirements as much as possible and provides various types of information to make a decision which is needed to establish the policy of research expense management. It helps an end user approach his/her desired analysis information quickly and get various data from the comprehensive viewpoint rather than the fragmentary viewpoint. Furthermore, as it integrated three systems into one, it is possible to share data, to integrate the system, to reduce operating expenses and to simplify supporting environment for the decision making.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.38 no.3
• /
• pp.87-94
• /
• 2015

Recently, management based on statistical data has become a big issue and the importance of the statistics has been emphasized for the management innovation in the defense area. However, the Military Management based on the statistics is hard to expect because of the shortage of the statistics in the military. There are many military information systems having great many data created in real time. Since the infrastructure for gathering data form the many systems and making statistics by using gathered data is not equipped, the usage of the statistics is poor in the military. The Analytical Defense Statistics System is designed to improve effectively the defense management in this study. The new system having the sub-systems of Data Management, Analysis and Service can gather the operational data from interlocked other Defense Operational Systems and produce Defense Statistics by using the gathered data beside providing statistics services. Additionally, the special function for the user oriented statistics production is added to make new statistics by handling many statistics and data. The Data Warehouse is considered to manage the data and Online Analytical Processing tool is used to enhance the efficiency of the data handling. The main functions of the R, which is a well-known analysis program, are considered for the statistical analysis. The Quality Management Technique is applied to find the fault from the data of the regular and irregular type. The new Statistics System will be the essence of the new technology like as Data Warehouse, Business Intelligence, Data Standardization and Statistics Analysis and will be helpful to improve the efficiency of the Military Management.