• 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 KIISE:Computing Practices and Letters
• /
• v.9 no.2
• /
• pp.213-225
• /
• 2003

In multimedia database system, it is very important issue how to query multimedia data and present the result of query. Also, in order to reuse the query result in other applications, multimedia database system must be considered to provide the query result which is more generalized form. In this paper, I propose a presentation model for presenting query result in multimedia database system and MMSQL based on the developed model for processing multimedia database query. This paper includes the design and implementation of MMSQL query processor. MMSQL query processor provides the presentation of query result which is SMIL (Synchronized Multimedia Integration Language) document. Therefore, MMSQL query result in this paper can be use to variant multimedia applications.

• Journal of Korea Society of Industrial Information Systems
• /
• v.9 no.3
• /
• pp.19-31
• /
• 2004

The purpose of this study is to show a case integration of web programming with database using Visual InterDev as a conceptual client and Web Server as server, Through this case study, we can see how easily dynamic web database programming used in Internet and Interanet can be developed in one integrated design environment such as Visual InterDev eliminating the inconvenience of developing database file and web page separately. Some literature survey and experimental practices were done to provide future developers with the principles and methodologies of developing web database programing using Visual InterDev with much less coding efforts and more convenient and easy way compared to other web developing tools.

• International Journal of Computer Science & Network Security
• /
• v.22 no.12
• /
• pp.107-115
• /
• 2022

Recently, big data applications need another database different from the Relation database. NoSQL databases are used to save and handle massive amounts of data. NoSQL databases have many advantages over traditional databases like flexibility, efficiently processing data, scalability, and dynamic schemas. Most of the current applications are based on the web, and the size of data is in increasing. NoSQL databases are expected to be used on a more and large scale in the future. However, NoSQL suffers from many security issues, and one of them is access control. Many recent applications need Fine-Grained Access control (FGAC). The integration of the NoSQL databases with FGAC will increase their usability in various fields. It will offer customized data protection levels and enhance security in NoSQL databases. There are different NoSQL database models, and a document-based database is one type of them. In this research, we choose the CouchDB NoSQL document database and develop an access control mechanism that works at a fain-grained level. The proposed mechanism uses role-based access control of CouchDB and restricts read access to work at the document level. The experiment shows that our mechanism effectively works at the document level in CouchDB with good execution time.

• Journal of Information Technology Applications and Management
• /
• v.10 no.3
• /
• pp.55-74
• /
• 2003

Due to the evolution of computer systems and the proliferation of Internet, numerous information resources have been constructed. The deluge of information makes the need to integrate information, which are distributed on the internet and are handled in heterogeneous systems. Recently, most of the XML -based information integration systems use XML DTD(Document Type Definition) for describing integrated global schema. However, DTD has some limitations in modeling local information resources such as datatypes. Although W3C's XML Schema is more flexible and powerful than XML DTD in specifying integrated global schema, it has more complex problems in resolving conflicts than using DTD. In this paper, we provide a taxonomy of conflict problems in integration information resources using XML Schema, and propose conflict resolution mechanism using XQuery.

• Asia pacific journal of information systems
• /
• v.16 no.4
• /
• pp.151-178
• /
• 2006

The objective of this research is to develop a formal framework and methodology to facilitate real-time data integration, thus enabling semantic interoperability among distributed and heterogeneous information systems. The proposed approach is based on the concepts of "ontology" and "semantic mediators." An ontology is developed and used to capture the intension (including structure, integrity rules and meta-properties) of the database schema. We also develop the agent communication protocol for semantic reconciliation, which is based on the theory of speech acts and agent communication language. This protocol is used by a set of semantic mediators, which automatically detect and resolve various semantic conflicts at the data- and schema-levels by referring to the ontology. A mediation-based query processing technique is developed to provide uniform and integrated access to the multiple heterogeneous information sources. Prototype tools are being implemented to provide proof of concept for this work.

• Journal of The Korean Society of Agricultural Engineers
• /
• v.59 no.5
• /
• pp.61-72
• /
• 2017

The purpose of this study is to establish an integrated management system for the efficient management of rural water, to improve current problems, and to lay the foundations for active use of rural water information. We proposed a plan for informatization with a focus on establishing a database that can be used to provide customized services to users by applying advanced IT technology and to strengthen the management system of cities and counties with poor information. Data linkage and integration, user service development and integration system, application of IT technology, advanced decision support for rural water management, strengthening of city and county management system And the details of the implementation of the key project were presented.

• Korean Journal of Geomatics
• /
• v.2 no.2
• /
• pp.99-105
• /
• 2002

The accuracy of the Digital Photologging System, designed for the construction of the road Facility Database, highly depends on the positions and attitudes of the cameras from GPS/INS integration. In this paper, the development of a loosely coupled GPS/INS is presented. The performance of the system is verified through a simulation as well as a real test data processing. Since the IMU used in this study shows large systematic errors, the possible accuracy of the positions and attitudes of this low-performance IMU when combined with precise GPS positions are assigned. Currently, the integrated system shows the positional accuracy better than 5cm in real data processing. Although the accuracy of attitude based on real test could not be assigned at this time, it is expected that better than 0.5 degrees and 1.8 degrees for horizontal and down component are achievable according to the simulation result.

• Korean Journal of Computational Design and Engineering
• /
• v.3 no.1
• /
• pp.48-56
• /
• 1998

Finite element analysis is very important in the design and analysis of mechanical engineering. The process of FEA encompasses shape modeling, mesh generation, matrix solving and post-processing. Some of these processes can be tightly integrated with the current software architectures and data sharing mode. However, complete integration of all the FEA process itself and the integration to the manufacturing processes is almost impossible in the current practice. The barriers to this problem are inconsistent data format and the enterprise-wise software integration technology. In this research, the information model based on STEP AP209 was chosen for handling finite element analysis data. The international standard for the FEA data can bridge the gap between design, analysis and manufacturing processes. The STEP-based FEA system can be further tightly integrated to the distributed software and database environment using CORBA technology. The prototype FEA system DICESS is implemented to verify the proposed concepts.

• Proceedings of the Korean Institute of Navigation and Port Research Conference
• /
• 2002.03a
• /
• pp.89-99
• /
• 2002

Since 1996, the document exchange method by EDI has been introduced in port and logistics industries in Korea to enhance the declaration activities to the Pusan Port Authority and Customs. In spite of these efforts, users such as shipping companies, shipping agents, and freight forwarders have complained the inconvenience of using EDI systems. The major reasons can be summarized as follows: repetitional EDI transfer, too much transfer time, inconvenient EDI software, and problems on message receiving confirmation. Furthermore, EDI has been used only for transmitting messages. To solve these problems, this study has adopted the integration system by applying the concept of SCM to logistics system by XML/EDl. In the view of SCM, the existing EDI has some problems because its role is only to transmit the messages. This paper is to suggest how current EDI systems in Port and logistics sector has to be chanced by Introducing SCM. The integration system gives us such advantages as accuracy of cargo data, integration of processes among firms, and keeping the trace of cargo.