• Journal of the Korea Society of Computer and Information
• /
• v.9 no.4 s.32
• /
• pp.5-12
• /
• 2004

The data transformation between XML and Relation Database is made through the Principle of mapping bewtween them. There are two ways to access SQL Server, one is to assign SQL query to URL and the other is to use template file. MS-SQL server takes advantage of OpenXML function to transform the results of executing SQL query into XML documents. That is, OpenXML first makes node tree and then transforms row set data of XML documents into XML data of relation type. In order to insert XML data into database data. data is extracted from parsing XML documents using sp_xml_preparedocument procedure, and then the document structure is mapped into tree structure and stored in a table of database. Consequently, Data transformation between XML and Relation Database is made through mapping bewtween them. This article proposes the principle of mapping between XML and Relation Database and then shows the implementation of transformation between them so that it introduces the possibilty of bringing the extension and efficiency of data and various effects.

• The Journal of Natural Sciences
• /
• v.8 no.1
• /
• pp.115-121
• /
• 1995

The Conventional database management system is not applicable because of their inadequate performance and difficulty of CAD database that is dependant to hierarchical structure and to repeat accesses of large data. For effective management and easy tool integration of CAD database, hierarchy Interface System(HIS) is designed and GROCO(Graph Representation fOr Complex Objects) Model is presented. Hierarchy Interface System which is composed of two subsystems of a configurator and a converter is designed for the interface between a conventional database management system and CAD tools. GROCO Model is a directed cyclic graph having five node-types for representing semantics and supports efficiently CAD database characters having a hierarchical structure of complex objects.

• Journal of Korean Society of Forest Science
• /
• v.88 no.1
• /
• pp.63-72
• /
• 1999

In this study, a relational database program to manage the data involved in forest planning was developed in such a way to simulate the whole process of 'Younglim' planning in Korean National Forest System. Using the pull-down menu system of various functions required for developing 'Younglim' plan, the database program can handle the data of forest inventory, 10-year working plans, annual working plans and the history of forest operations automatically and simultaneously. The model was designed to run under the environment of Korean version of Windows 95. Visual Basic 5.0 was used as the basic tool for programming and Microsoft ACCESS as the basic engine of the database system. In this paper, the process of designing the structure of database program following the process of 'Younglim' plan and the structure of the model are discussed. In addition, the functions of menu system are presented using the screen-mode output windows of the model.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2022.05a
• /
• pp.22-24
• /
• 2022

Recently, Graph Database (GDB) is being used in wide range of industrial fields. GDB is a database system which adopts graph structure for storing the information. GDB handles the information in the form of a graph which consists of vertices and edges. In contrast to the relational database system which requires pre-defined table schema, GDB doesn't need a pre-defined structure for storing data, allowing a very flexible way of thinking about and using the data. With GDB, we can handle a large volume of heavily interconnected data. A network service provider provides its services based on the heavily interconnected communication network facilities. In many cases, their information is hosted in relational database, where it is not easy to process a query that requires recursive graph traversal operation. In this study, we suggest a way to store an example set of interconnected network facilities in GDB, then show how to graph-query them efficiently.

• Journal of the Earthquake Engineering Society of Korea
• /
• v.10 no.3 s.49
• /
• pp.135-147
• /
• 2006

The essential information elements for the Earthquake Damage Evaluation System (EDES) of highway bridges are defined in this study, and a database construction method, which fits the circumstances of Korea, is proposed. The information elements for the EDES of highway bridges are categorized in two groups: structure related information, location related information. The structure related information is composed of the fragility curve information which is necessary for earthquake damage evaluation of highway bridges. The data structure of road network, which represents the location related information, is defined in more detail than the existing GIS-based data structure of road network for modeling of junctions. A pilot GIS-based EDES subjected to 110 bridges on expressway in Korea is developed, and it is verified that the proposed database construction method for the EDES can be used to develop a decision making system for quick retrofitting of the seismic damages of highway bridges and road network.

• The Transactions of the Korean Institute of Electrical Engineers A
• /
• v.48 no.7
• /
• pp.847-854
• /
• 1999

The setting of protective relays, which is critical to the power system security and reliability, requires a huge volume of data processing and repetitive calculation. Since it has been performed by relay engineers manually, it is vulnerable to human errors, its computerization has been pursued, in which the efficient management of the data is the key to the success. The database for power system protection must accommodate not only the power system network data but also a variety of protective devices. Also its information should be able to be viewed and updated with easy by operators and by computer programs. This paper describes several existing database designs for power system protection, their advantages and disadvantages. Also this paper has identified the required function and designed the database for the KEPCO power system data structure for the benefit of the relay setting process, etc..

• Proceedings of the Korea Information Processing Society Conference
• /
• 2009.04a
• /
• pp.399-400
• /
• 2009

As a part of the era of human centric applications people started to care about their well being utilizing any possible mean. This paper proposes a framework for real time on-body sensor health-care system, addresses the current issues in such systems, and utilizes an enhanced online divisive agglomerative clustering algorithm (EODAC); an algorithm that builds a top-down tree-like structure of clusters that evolves with streaming data to rationally cluster on-body sensor data and give accurate diagnoses remotely, guaranteeing high performance, and scalability. Furthermore it does not depend on the number of data points.

• Journal of the Korean Geotechnical Society
• /
• v.18 no.6
• /
• pp.43-59
• /
• 2002

In this study, database systems which were used to select the waterproof method according to leakage patterns of underground structures were built by performing pilot tests, reviewing literatures, and analysing the gathered data statistically. The database was built by using check lists which consisted of 5 major items and 73 subdivided items, and 26 major parameters according to 4 classified grades were determined on the base of survey which considered various in-situ conditions. The database of waterproof methods was comprised of 10 methods which were applied in Korea. From the database of waterproof methods, application ranges and design conditions of waterproof methods were suggested. From the results of study, database system consists of parameters selection database, waterproof method database, and design condition database. From the results of pilot tests, when the database of waterproof methods was applied to design stage, saving time and reducing mistakes for selecting waterproof method were gained. In addition, when the database of waterproof methods was applied to construction stage, effects such as evaluation of applicability of waterproof method, improvement of constructability and post management were expected.

• 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 the Korea Society of Computer and Information
• /
• v.20 no.9
• /
• pp.55-60
• /
• 2015

This paper introduces a program structure that minimizes the client's business logic by reducing the client's specifications as a way of minimizing the limitations of online game platforms. The objective of this thesis is to design an online game that is based on a 3-tier client/server structure, and thus using this 3-tier structure to ultimately create an online Sutda game that anyone can enjoy. The progression of newly released games is highly based on the mobile market and the number of online games being launched is decreasing. As the mobile game market grows, more and more multi-platform games are being developed and target platforms within online games are greatly diversifying. Through these situations, this thesis minimizes the client's business logic through a 3-tier structure of application-middleware-database, and also proposes an online game client/server that allows three or more users to participate simultaneously through the server.