• Journal of Computing Science and Engineering
• /
• v.1 no.2
• /
• pp.211-232
• /
• 2007

In this paper we investigate some issues and solutions related to the design of a Data Warehouse (DW), storing several aggregate measures about trajectories of moving objects. First we discuss the loading phase of our DW which has to deal with overwhelming streams of trajectory observations, possibly produced at different rates, and arriving in an unpredictable and unbounded way. Then, we focus on the measure presence, the most complex measure stored in our DW. Such a measure returns the number of distinct trajectories that lie in a spatial region during a given temporal interval. We devise a novel way to compute an approximate, but very accurate, presence aggregate function, which algebraically combines a bounded amount of measures stored in the base cells of the data cube. We conducted many experiments to show the effectiveness of our method to compute such an aggregate function. In addition, the feasibility of our innovative trajectory DW was validated with an implementation based on Oracle. We investigated the most challenging issues in realizing our trajectory DW using standard DW technologies: namely, the preprocessing and loading phase, and the aggregation functions to support OLAP operations.

• Journal of Hydrogen and New Energy
• /
• v.30 no.3
• /
• pp.282-288
• /
• 2019

When liquefied natural gas (LNG) is vaporized to form natural gas for industrial and household consumption, a tremendous amount of cold energy is transferred from LNG to seawater as a part of the phase-change process. This heat exchange loop is not only a waste of cold energy, but causes thermal pollution to coastal fishery areas by dumping the cold energy into the sea. This project describes an innovative new design for reclaiming cold energy for use by cold storage warehouses (operating in the 35 to $62^{\circ}C$ range). Conventionally, warehouse cooling is done by mechanical refrigeration systems that consume large amounts of electricity for the maintenance of low temperatures. Here, a closed loop LNG heat exchange system was designed (by simulator) to replace mechanical or vapor-compression refrigeration systems. The software PRO II with PROVISION V9.4 was used to simulate LNG cold energy, gas re-liquefaction, and the vaporized process under various conditions. The effects on sensible and latent heats from changes to the array type of heat exchangers have been investigated, as well as an examination of the optimum.

• Korean Journal of Construction Engineering and Management
• /
• v.5 no.4 s.20
• /
• pp.79-86
• /
• 2004

One of the most difficult tasks in pavement management information systems is establishing the links between performance measures of a structure and the design and construction inputs. In-situ pavement performance can be considered a response variable to many project input variables, such as design, construction, and traffic loading effects. If we are to fully understand the component of pavement performance and specify the inputs through design and construction specifications to achieve that performance we must develop quantitative relationship between input and response variables through a scientific, fully integrated Pavement Performance Analysis System (PPAS). Hence, the objective of this study is to design a database model required for developing an effective database template that will allow analysis of pavement performance measures based on design and construction information linked by location. In order to select the most appropriate database model, a conceptual database model (Entity Relationship Model) and dimensional model, which is believed to be the most effective modeling technique for data warehouse project, are designed and compared. It is believed that other state highway agencies could adopt the proposed design strategy for implementing a PPAS at the discretion of the state highway agencies.

• 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 the Society of Disaster Information
• /
• v.20 no.3
• /
• pp.672-681
• /
• 2024

Purpose: In order to secure a specific fire diffusion model, this study compares and analyzes the NIST UL standard application scenario and the performance-oriented design application scenario and examines the difference between the fire diffusion model and the surface fire model. Method: Temperature, visibility, and CO sensors were installed for each scenario using FDS, and the two scenarios were compared and analyzed through the changes. Result: As a result of analyzing the temperature, visibility, and CO for each scenario, the NIST UL standard application scenario is very similar to the actual fire, and the performance-oriented design application scenario shows a harsh fire situation. Conclusion: When designing fire safety for large buildings such as distribution warehouses, it is important to prepare comprehensive fire safety measures in consideration of both actual fire and harsh fire conditions.

• Annual Conference of KIPS
• /
• 2024.10a
• /
• pp.880-881
• /
• 2024

물류 자동화 과정에 핵심기술증 하나인 AMR 자동화 이동로봇을 Tractor-Trailer Type 으로 제작해 기존 물류창고에 있는 다양한 트레일러들을 이동화는 자동화 과정을 개발하였다. Aruco Marker 를 이용한 Trailer 결합과 Tractor-Trailer 의 주행 안정성을 강화하였다.

• Journal of Korea Multimedia Society
• /
• v.19 no.5
• /
• pp.939-947
• /
• 2016

As the number of legacy database systems and the size of data to manipulate have been vastly increased, it has become more difficult and complex to analyze characteristics of data. To improve the efficiency of data analysis and help administrators to make decisions in business life, BI(Business Intelligence) system is used. To construct data warehouse and cube from legacy database systems makes it easy and fast to transform raw data into integrated and categorized meaningful information. In this paper, we built a BI system for an University administration. Several source system databases were integrated to data warehouse to build data cubes. The implemented BI system shows much faster data analysis and reporting ability than the manipulation in legacy systems. It is especially efficient in multi dimensional data analysis, nonetheless in single dimensional analysis.

• The KIPS Transactions:PartC
• /
• v.14C no.2
• /
• pp.179-184
• /
• 2007

The problem of selecting base station location in the design of mobile communication system has been basically regarded as a problem of assigning maximum users in the cell to the minimum base stations while maintaining minimum SIR. and it is NP hard. The objective function of warehouse location problem, which has been used by many researchers, is not proper function in the base station location problem in CDMA mobile communication, The optimal and approximate solutions have been presented by using proposed object function and algorithms of exact solution, and the simulation results have been assessed and analyzed. The optimal and approximate solutions are found by using mixed integer programming instead of meta-heuristic search methods.

• The Journal of the Korea institute of electronic communication sciences
• /
• v.3 no.4
• /
• pp.313-318
• /
• 2008

The next generation Web 2.0 users are requiring a screen that satisfies visual and emotional factors regarding UI and the possibility of constant recognition about various information. To actively deal with these kinds of user demands, dual cooperation between the developer and designer is becoming more urgently needed. For this, Microsoft released Silverlight, a tool for when making a web presentation that enables persons to create a visually stunning webpage using diverse platforms and function. We applied clarity and animation to existing windows concepts, using Silverlight with which designers and developers can work together and is accessable to many development tools, and provided 3D effects to implement a Warehouse Management System.

• Journal of Korean Institute of Industrial Engineers
• /
• v.33 no.2
• /
• pp.227-236
• /
• 2007

This paper proposes a method for designing stacking warehouses of pyramid type which can be found in storage rooms for steel coils, paper rolls, and drums for oils. Formulas were derived for estimating the expected travel time of cranes and the expected time for rehandling activities. Based on the derived formulas, this study derives the cost function for determining the optimal numbers of rows, bays, tiers of stacks under the condition that the requirement for storage space is satisfied. Numerical examples were given.