• Journal of Korean Society of Occupational and Environmental Hygiene
• /
• v.33 no.1
• /
• pp.78-90
• /
• 2023

Objectives: The purpose of this study is to standardize the process code of the work environment measurement database (WEMD) for the construction of a job-exposure matrix (JEM). Methods: The standard process code (SPC) was reclassified based on process similarity and drawing upon the code used in the existing K2B. It was supplemented through review by industrial hygiene experts. In addition, an index word database related to SPC was created and used for SPC search. A pilot evaluation project was conducted by experts to evaluate the validity of the newly reclassified standard process code. Results: A total of 70 final SPCs were developed, including 31 processes related to the construction industry. Using the Shiny program, we developed a standard code finder that can be used on the web (https://kscf.shinyapps.io/scf_app/). As a result of the pilot evaluation, it was determined that it was easier to search for standard codes than previous codes, so it was highly utilized. Conclusions: It is expected that JEM construction using industry-process information drawing on WEMD data will be possible using the 70 newly standardized process codes.

• Journal of the Computational Structural Engineering Institute of Korea
• /
• v.17 no.2
• /
• pp.105-117
• /
• 2004

In each industry field, many engineers have tried to develop integrated environments using information technology. The core technology in building integrated environments is the database based on standardized information. To meet the requirements, this study builds a database with detailed design information as a part of integrating digital information generated from every work of steel bridges. The data model used to build the database was developed based on the international standard, namely ISO/STEP. The data model is classified into geometric and non-geometric parts to represent the design information of steel bridges. The geometric parts are represented by a three dimensional solid model so that they may be able to reuse existing information. Also, the non-geometric parts represent information requirements that are analyzed by the development method of standard data model. To verify the data model, this study validates the syntax of the model on EXPRESS Engine and verifies the validation of the model by applying the design data of Hannam bridge to the database.

• Proceedings of the Korean Institute of Intelligent Systems Conference
• /
• 2003.09a
• /
• pp.384-387
• /
• 2003

Most of the real world phenomena change over time. The ability to represent and to reason geographic data becomes crucial. A large amount of non-standard applications are dealing with data characterized by spatial, temporal and/or uncertainty features. Non-standard data like spatial and temporal data have an inner complex structure requiring sophisticated data representation, and their operations necessitate sophisticated and efficient algorithms. Current GIS technology is inefficient to model and to handle complex geographic phenomena, which involve space, time and uncertainty dimensions. This paper concentrates on developing a fuzzy spatio-temporal data model based on fuzzy set theory and relational data models. Fuzzy spatio-temporal operators are also provided to support dynamic query.

• Journal of Information Technology Applications and Management
• /
• v.16 no.4
• /
• pp.245-261
• /
• 2009

Since XML emerged as a standard for data exchange on the web, it has been widely used for applications like e-Commerce, CRM, and BI. However, it is common that most of business data is stored in relational database systems, and it is expected that business data management would still be centered around the relational database systems. As such, the technique of viewing relational data as XML and processing XML queries against it is required. To meet such a need, in the SQL/XML standard, the functions to publish relational data as XML are provided. In this paper, we propose the techniques of providing an XML view of relational data defined by an SQL/XML statement in DTD(Document Type Definition), and of processing XPath queries against the XML view by translating them into SQL/XML statements, and describe the validation of such techniques through implementation and tests.

• Spatial Information Research
• /
• v.4 no.2
• /
• pp.159-179
• /
• 1996

The objective of the paper is to recommend a database format of geographic informa¬tion systems for transportation (GIS-T) based on a review of geographic data files (GDF), a European standard format for navigation and the topologically integrated geographic encoding and referenc¬ing files (TIGER) if the USA The establishment of the standard format for transportation database is important for sharing data since data collection is costly. We believe the recommended format would reduce the implementation costs for GIS-T in Korea in the future.

• Proceedings of the Korean Information Science Society Conference
• /
• 2000.10a
• /
• pp.113-115
• /
• 2000

A GIS software GEO Millennium SystemTM has been developed to integrated with spatial database that combines conventional and spatially related data. As we known well the standard query language lacks the support of spatial data type and predicate, and can not serve as the query language in the spatial database directly; some extended strategies have been proposed, but some of them need their own storage manager, some introfuce new clause into the SELECT-FROM-WHERE structure, and some is very complex and available to us. So we designed our own query language on the conventional storage manager system. It supports the Spatial Data Type and predicate, and provides the full query capabilities of SQL on the non-spatial part of the database while being tightly integrated with the spatial part, without changing the standard SQL structure.

• Proceedings of the KAIS Fall Conference
• /
• 2006.05a
• /
• pp.258-264
• /
• 2006

When make most products, the standard is made by standard of the young. These are not proper standards for making the supplies for seniors. To adapt the standards of the aged, it is necessary to construct the database which is based on the survey for producing supplies for seniors. In this study, wish to measure life eyesight and ability by color-distinguish that use Flash because uses LandoltC ring and dark adaptation that use contrast and glare to construct sight function measurement system doing to elderly, and construct database because uses measured data.

• Magazine of the Korean Society of Agricultural Engineers
• /
• v.43 no.1
• /
• pp.87-95
• /
• 2001

This study aimed at developing the standard questionnaire database system for rural development. By the previous study for the hierarchical listing of the factors related to rural development in the village level, the targetting questionnaire items pool was proposed. The data base system basically consisted of 3 parts: general, principal and sectoral parts for rural development. General and principal parts had the detailed questionnaires without any further hierarchy, but sectoral one 4-step hierarchy from high/medium/low levels to detailed questionnaires. Tentatively, total 417 questionnaires statements were written with 5 questioning styles: single choosing, multiple choosing, tabular, writing and special questions. Through the checking done by college students team from rural area, the database system having 467 questioning statements was finally developed.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 2002.04a
• /
• pp.284-291
• /
• 2002

New information technology developments continue to have a significant impact on civil engineering fields. The objective of this study is to develop STEP-based database which will be able to store and manipulate the information of steel bridges over the life cycle. In this study, there are three steps to fulfil the objective to build database and develop the application module for that data model practically and effectively To begin with, STEP methodology for a development of data model has been used for modelling data structure. And then the data model for a steel bridge's shape and structural analysis information has been made up by using AP203 (configuration controlled design) and AP203 (composite and metallic structural analysis and related design) which are the international standard in STEP Lastly, the application module for an access to information of steel bridges has been developed by means of already made database. This study show efficiently the prototype of developing information system with the existing standard technology in civil engineering fields.

• MALSORI
• /
• no.47
• /
• pp.109-120
• /
• 2003

This paper presents about the activities of speech database standardization in ETRI. Recently, with the support of government, ETRI and SiTEC have been gathering the large speech corpus for the domestic speech related companies. First, due to the lack of sharing the knowledge of speech database specification, the distributed speech database has a different format. Hence it seems to be needed to have the same format as soon as possible. ETRI and SiTEC are trying to find the better representation format of speech database. Second, we introduce a new description method of the annotation information of speech database. As one of the structured description method, XML based description will be applied to represent the metadata of the speech database. It will be continuously revised through the speech technology standard forum during this year.