• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2006.05a
• /
• pp.1702-1706
• /
• 2006

In the field of rice research, insertional mutants have become a valuable resource for studies of gene function. However, a well-designed database yet in the area of rice functional genomics. The relevant data are widely distributed and independently managed by the individual research groups. Heterogeneous data format in the distributed database systems causes many problems related to redundancy and compatibility. In this research, integration of the distributed databases using agent technology is pursued. In particular, a data integration agent, an ontology agent, a comparison agent, and resource agents are designed, whereby the integrated database is maintained. Moreover a framework for the web-based information system, which provides information to biologists and permits biologists to add new data to the database, is proposed. To establish an interoperable data format, an XML-based data model is also developed adopting ontology concept.

• Journal of Environmental Health Sciences
• /
• v.43 no.4
• /
• pp.298-306
• /
• 2017

Objectives: Since 1998, the Korea National Health and Nutrition Examination Survey (KNHANES) has been conducted in order to investigate the health and nutritional status of Koreans. The food intake data of individuals in the KNHANES has also been utilized as source dataset for risk assessment of chemicals via food. To improve the reliability of intake estimation and prevent missing data for less-responded foods, the structure of integrated long-standing datasets is significant. However, it is difficult to merge multi-year survey datasets due to ineffective cleaning processes for handling extensive numbers of codes for each food item along with changes in dietary habits over time. Therefore, this study aims at 1) cleaning the process of abnormal data 2) generation of integrated long-standing raw data, and 3) contributing to the production of consistent dietary exposure factors. Methods: Codebooks, the guideline book, and raw intake data from KNHANES V and VI were used for analysis. The violation of the primary key constraint and the $1^{st}-3rd$ normal form in relational database theory were tested for the codebook and the structure of the raw data, respectively. Afterwards, the cleaning process was executed for the raw data by using these integrated codes. Results: Duplication of key records and abnormality in table structures were observed. However, after adjusting according to the suggested method above, the codes were corrected and integrated codes were newly created. Finally, we were able to clean the raw data provided by respondents to the KNHANES survey. Conclusion: The results of this study will contribute to the integration of the multi-year datasets and help improve the data production system by clarifying, testing, and verifying the primary key, integrity of the code, and primitive data structure according to the database normalization theory in the national health data.

• Journal of Energy Engineering
• /
• v.25 no.1
• /
• pp.131-144
• /
• 2016

Damage occur frequently around the world on climate change and the main cause of greenhouse gas emissions regulation is growing. To this end, the government has built integrated management system for national building energy. The building energy information is total 6.8 million complex. Integrated management system for national building energy database are matched building registers information and energy information of the supply agencies. However, the matching process has its limitations so advanced work is in progress continuously. This study analyzed integrated management system for national building energy database quality and limitations and deduce improvement plan to increase system reliability and availability. The existing database matching average rate is 85.6%. 58.2% of the total non-matching data type has no building information. To ensure the ease of new database matching and the accuracy of the existing database matching, address standarization and building properties system are needed between building information and energy information. Also, The system construction is required to include information on other energy sources like petroleum energy which has high proportion of non-urban areas and small residential areas and renewable energy which has high potential in development and utilization.

• The Transactions of the Korea Information Processing Society
• /
• v.4 no.1
• /
• pp.1-10
• /
• 1997

In this paper, for useful administration of the data which have ambiguities meaningfully and hard to treat, a new relation database model using an integrated fuzzy sets and rough sets relational database one. After proposing Fuzzy-rough relational database model on the base of integrated Fuzzy and Rough sets, Application of the examples of arithmetic is analyzed through the Access DBMS and the visual basic by composing and representing database based on fuzzy and rough sets which are characterized as fuzzy sets and rough sets on Pentium computer(166Mhz). This paper was induced to reduce the data incompleteness.

• Herbal Formula Science
• /
• v.25 no.1
• /
• pp.39-49
• /
• 2017

Objectives : The contents of the literature associated with the medical records were entered into the database. We want to find the structure and search methods for efficient utilization of the database. Methods : The contents were entered into the database using the 'Access 2014 of the MS'. The Query Sentences were created and utilized for a search. Results : We could find information about the prescriptions, medical records and patients by the herbs and symptom combinations using the single table named 'Integrated Knowledge' and queries. Integrated Knowledge is a table that gathered patient information, prescription information and symptom information together. Conclusions : If you store patient, prescription and symptom information on a single table, you could search and use the results by various combinations of the various elements included in the table. These results could help curing patients on the basis of evidence-based treatment at the clinics.

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.17 no.5
• /
• pp.137-142
• /
• 2017

The development of medical devices based on the theory of tranditional Korean medicine is increasing due to population aging and emerging demand for medical services. Various clinical trials are being conducted to ensure the clinical effectiveness of the developed medical devices, and the importance of systematic management of variously collected information in this process is increasing. In this paper, we designed and constructed the database that can systematically manage the medical information of the patient and the pulse measurement information in conducting clinical trials by using pulse analysis system which is a representative diagnostic method of traditional Korean medicine. The constructed database can be efficiently used for the verification of existing algorithms or developing new algorithms through the quality control of various information and measured data on clinical trials. It also has several advantages in the control of clinical data. The results of this study can contribute to the establishment of Korean medical device data standard for the construction of integrated database management system that can share information with different kind of pulse analysis system and other bio-signal measuring devices.

• Korean Journal of Computational Design and Engineering
• /
• v.11 no.3
• /
• pp.183-196
• /
• 2006

A new operation strategy. which can guarantee the data consistency of engineering information among the various intelligent information systems, is presented for engineering information of bridges, and construction methodology of integrated database is developed to support the strategy. The two core standard techniques are adopted to construct the integrated database. One is the Standard for the Exchange of Product Model Data (STEP) for CAD/CAE information and the other is the Extensible Markup Language(XML) for engineering document information. The former enabler structural engineers to handle the structural details with three-dimensional geometry-based information of bridges, and ACIS solid modeling kernel is employed to develop AutoCAD based application modules. The latter can make document files into data type for web-based application modules which assist end-users to search and retrieve engineering document data. In addition, relaying algorithm is developed to integrate the two different information, e.g. CAD/CAE information and engineering document information. The pilot application modules are also developed, and a case study subjected to the Han-Nam bridge is presented at the end of the paper to illustrate the use of the developed application modules.

• Journal of Korean Association for Spatial Structures
• /
• v.1 no.2 s.2
• /
• pp.59-66
• /
• 2001

This paper describes three modules for development of the Space Frame Integrated Design System(SFIDS). The Control Module is implemented to control the developed system. The Model Generation Module based on PATRAN user interface enables users to generate a complicated finite element model for space frame structures. The Optimum Design Module base on a branch of combinatorial optimization techniques which can realize the optimization of a structure having a large number of members designs optimum members of a space frame after evaluating analysis results. The Control Module and the Model Generation Module Is implemented by PATRAN Command Language(PCL) while C++ language is used in the Optimum Design Module. The core of the system is PATRAN database, in which the Model Generation Module creates information of a finite element model. Then, PATRAN creates Input files needed for the analysis program from the information of the finite element model in the database, and in turn, imports output results of analysis program to the database. Finally, the Optimum Design Module processes member grouping of a space frame based on the output results, and performs optimal member selection of a space frame. This process is repeated until the desired optimum structural members are obtained.

• Proceedings of the KSR Conference
• /
• 2007.11a
• /
• pp.1196-1202
• /
• 2007

In construction of high speed railway, the fan shape is limited to achieve reduction of required travel time and concrete railway which has structural stability and induces small maintenance cost with allowable ground settlement is recently applied. So construction of concrete railway on soft ground in which considerable ground settlement occurs increases and settlement management in soft ground section is required. Field monitoring on ground movement and integrated geotechnical information system which manages construction, design, and field monitoring data are essential for settlement management of concrete railway subgrade. Site investigation data are also required due to future repair work. Therefore in this study, integrated geotechnical information system for construction and maintenance of concrete railway is developed. The developed system consists of a database and an application program. The database contains site investigation, construction, design, and field monitoring data throughout a railway. Application program performs various functions on managing and utilizing information in the database with graphic visualization of output. And by providing integrating information with comprehensible visual displays, the applicability and effectiveness of the developed system for construction and maintenance management were confirmed.

• Journal of the Institute of Electronics Engineers of Korea TC
• /
• v.41 no.11
• /
• pp.39-45
• /
• 2004

This paper proposes an algorithm of address analysis for the next-generation networks. That is, we present integrated address analysis of the Numbering Plans of public telecommunication networks such as those of the ATM network. The purpose of implementing software for integrated address analysis is to actively and flexibly cope with a large change of information while operating the system and the network. By designing and implementing a database structure and an address analysis algorithm, interworking is possible among part (local) networks that each have a different Addressing Plan within an integrated network. Proposed relational model database structure has effect that do to manage address information of complicated network efficiently. Also, apply in real environment and proved excellency through interworking test to verify mechanism that propose.