• 한국경영정보학회:학술대회논문집
• /
• 2008.06a
• /
• pp.620-627
• /
• 2008

In this paper, recognizing the importance of the database query optimization design methods, we implemented mobile database with mobile program (J2ME) which is a useful database procedures. In doing so, we emphasize the logical query optimization which brings mobile database to performance improvement. The research implies that the suggested mobile program (J2ME) would contribute to the realization of the efficient mobile database as the related technology develops in the future.

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

Recognizing the importance of the database query optimization design methods, we implemented mobile database with mobile program (J2ME) which is a useful database procedures. In doing so, we emphasize the logical query optimization which brings mobile database to performance improvement. The research implies that the suggested mobile program (J2ME) would contribute to the realization of the efficient mobile database as the related technology develops in the future.

• The Journal of Information Technology and Database
• /
• v.7 no.2
• /
• pp.47-59
• /
• 2000

In this paper, we analyze the applicability of a general optimization algorithm to a database optimization problem. The index selection problem Is the problem to choose a set of indexes for a database in a way that the cost to process queries in the given workload is minimized subject to a given storage space restriction for storing indexes. The problem is well known in database research fields, and many optimization and/or heuristic algorithms have been proposed. Our work differs from previous research in that we formalize the problem in the form of non-linear Integer Programming model, and investigate the feasibility and applicability of a general purpose optimization algorithm, called OPBDP, through experiments. We implemented algorithms to generate workload data sets and problem instances for the experiment. The OPBDP algorithm, which is a non-linear 0-1 Integer Programming problem solver based on Davis-Putnam method, worked generally well for our problem formulation. The experiment result showed various performance characteristics depending on the types of decision variables, variable navigation methods and ocher algorithm parameters, and indicates the need of further study on the exploitation of the general purpose optimization techniques for the optimization problems in database area.

• Journal of the Korean Society for Aeronautical & Space Sciences
• /
• v.31 no.5
• /
• pp.25-36
• /
• 2003

Aircraft design pursues integrated design efforts by considering all design elements together. In the integrated design environment, it is crucial for the design data to be consistent, free of errorm, and most recent. Database design process consists of the analysis of the data which shall be stored and managed, the construction of the E-R Diagram, and the mapping of the database table. As a DBMS (DataBase Management System), Oracle 8i is employed to design and construct the database. The database design methodology is devised to apply for the several MDO(Multidisciplinary Design Optimization) techniques like MDF(MultiDisplinary Feasible), IDF(Individual Discipline Feasible), and CO(Collaborative Optimization). The defined process is demonstrated through a couple of design examples, including a simple numerical example and a UCAV(Unmanned Combat Aerial Vehicle) design optimization.

• Journal of the Computational Structural Engineering Institute of Korea
• /
• v.20 no.2
• /
• pp.165-179
• /
• 2007

For the purpose of optimum design of reinforced concrete structures, pre-determined section database of column and beam are constructed and arranged in order of the resisting capacity. Then, regression equations representing the relation between section number and section resisting capacity are derived. In advance, effective optimization algorithms which search optimized solution quickly using direct search method from these database are proposed. In practice, from the fact that engineers conduct member design close to capacity optimization rather than cost optimization, both capacity and cost optimization using proposed algorithms are performed, and the review for the obtained results are followed. Moreover, the investigation for the applicability and effectiveness of the Introduced design procedure is conducted through correlation study for example structures. Because of no restriction in constructing objective functions with very simple optimization processes and fast convergence, the introduced method can effectively be used in the preliminary design stage. Especially, selected solutions from database are directly applicable in practice because these sections already satisfy all the requirements in design codes and practical restrictions.

• Journal of the Computational Structural Engineering Institute of Korea
• /
• v.21 no.6
• /
• pp.563-569
• /
• 2008

In this paper, the missile database system for the multidisciplinary design and optimization framework has been designed and investigated. The requirements of the missiles database are analyzed and the database design concept has been defined first. The data flow among the analysis disciplines is investigated and the Entity-Relation diagram is constructed to develop the database table and to define the database schema. The developed database system is integrated into the missile design framework to perform the store, search and management of the design data during the design and analysis of the missile development, hence the efficiency and validity of the database designed in this study has been demonstrated.

• Journal of Information Processing Systems
• /
• v.18 no.3
• /
• pp.374-388
• /
• 2022

Database systems usually have many parameters that must be configured by database administrators and users. RocksDB achieves fast data writing performance using a log-structured merged tree. This database has many parameters associated with write and space amplifications. Write amplification degrades the database performance, and space amplification leads to an increased storage space owing to the storage of unwanted data. Previously, it was proven that significant performance improvements can be achieved by tuning the database parameters. However, tuning the multiple parameters of a database is a laborious task owing to the large number of potential configuration combinations. To address this problem, we selected the important parameters that affect the performance of RocksDB using random forest. We then analyzed the effects of the selected parameters on write and space amplifications using analysis of variance. We used a genetic algorithm to obtain optimized values of the major parameters. The experimental results indicate an insignificant reduction (-5.64%) in the execution time when using these optimized values; however, write amplification, space amplification, and data processing rates improved considerably by 20.65%, 54.50%, and 89.68%, respectively, as compared to the performance when using the default settings.

• International Journal of Highway Engineering
• /
• v.19 no.6
• /
• pp.117-127
• /
• 2017

PURPOSES : The objective of this research is establishing system components and optimizing operational procedures in order to systematically manage road cave-ins in urban areas. METHODS : Based on the literature review and alternative comparison, optimization methods is suggested. RESULTS : Throughout the study, location referencing system, database structure, and operation strategy(procedure) were clarified, and the optimization methods for each item were suggested. CONCLUSIONS : Road cave-in management should be focused on user safety rather than focusing on economic aspects. The occurrence of road cave-in should be addressed thoroughly by road management system(location referencing system, database structure, and operation strategy(procedure), and the optimization methods), since they are closely related to road users' safety.

• Journal of the Institute of Electronics Engineers of Korea CI
• /
• v.45 no.3
• /
• pp.75-85
• /
• 2008

The DBMS are widely used in embedded systems. The flash memory is used as a storage device of a embedded system. The optimizer of existing database system assumes that the storage device is disk. There is overhead to overwrite on flash memory unlike disk. The block of flash memory should be erased before write. Due to this reason, query optimization model based on disk does not adequate for flash-aware database. Especially embedded system should minimize the consumption of energy, but consumes more energy because of excessive erase operations. This paper proposes new energy based cost model of embedded database and shows the comparison between disk based cost model and energy based cost model.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2000.04a
• /
• pp.160-163
• /
• 2000

Due to the complexities of the real-world system, a water resource management program has to deal with various types of data. It appears that management personnel who has to use the program usually suffers from the technical burdens of handling large amount of data and understanding the optimization theory when they try to interpret the results. By combining the capabilities of database technology and modeling technique with optimization procedure we can develop a reliable decision supporting tool for multi-reservoir operation planning, which yields operating schedule for each dam in a river basin. We introduce two special data handling methodology for the real world application. First, by treating dams, hydro-electric power generating facilities and demand sites as separate database tables, the proposed data handling scheme can be applied to general water resource system in Korea. Second, by assigning variable names using predetermined key words, we can save searching time for identifying the moaning of the variables, so that we can quickly save the results of the optimization run to the database.