• Title/Summary/Keyword: 데이터베이스 구조화

Search Result 339, Processing Time 0.029 seconds

An Exploratory Study on the Big Data Convergence-based NCS Homepage : focusing on the Use of Splunk (빅데이터 융합 기반 NCS 홈페이지에 관한 탐색적 연구: 스플렁크 활용을 중심으로)

  • Park, Seong-Taek;Lee, Jae Deug;Kim, Tae Ung
    • Journal of Digital Convergence
    • /
    • v.16 no.7
    • /
    • pp.107-116
    • /
    • 2018
  • One of the key mission is to develop and prompte the use National Competency Standards, which is defined to be the systemization of competencies(knowledge, skills and attitudes) required to perform duties at the workplace by the nation for each industrial sector and level. This provides the basis for the design of training and detailed specifications for workplace assessment. To promote the data-driven service improvement, the commercial product Splunk was introduced, and has grown to become an extremely useful platform because it enables the users to search, collect, and organize data in a far more comprehensive, far less labor-intensive way than traditional databases. Leveraging Splunk's built-in data visualization and analytical features, HRD Korea have built custom tools to gain new insight and operational intelligence that organizations have never had before. This paper analyzes the NCS homepage. Concretely, applying Splunk in creating visualizations, dashboards and performing various functional and statistical analysis and structure without Web development skills. We presented practical use and implications through case studies.

Application Method of Regular Expressions and Suffixes to improve the Accuracy of Automatic Domain Identification of Public Data (공공데이터의 도메인 자동 판별 정확도 향상을 위한 정규표현식 및 접미사 적용 방법)

  • Kim, Seok-Kyoun;Lee, Kwanwoo
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.22 no.4
    • /
    • pp.81-86
    • /
    • 2022
  • In this work, we propose a method for automatically determining the domain of columns of file data structured by csv format. New data can be generated through convergence between data and data, and the consistency of the joined columns must be maintained in order for these new data to become an important resource. One of the methods for measuring data quality is a domain-based quality diagnosis method. Domain is the broadest indicator that defines the nature of each column, so a method of automatically determining it is necessary. Although previous studies mainly studied domain automatic discrimination of relational databases, this study developed a model that can automate domains using the characteristics of file data. In order to specialize in the domain discrimination of file data, the data were simplified and patterned using a regular expression, and the contents of the data header corresponding to the column name were analyzed, and the suffix used was used as a derived variable. When derivatives of regular expressions and suffixes were added, the result of automatically determining the domain with an accuracy of 95% greater than the existing method of 87% was derived. This study is expected to reduce the quality measurement period and number of people by presenting an automation methodology to the quality diagnosis of public data.

Influence of Rainfall Intensity and Saturated Permeability on Slope Stability during Rainfall Infiltration (강우침투시 강우강도와 포화투수계수가 안전율에 미치는 영향)

  • Lee, Seung-Rae;Oh, Tae-Kyu;Kim, Yun-Ki;Kim, Hee-Chul
    • Journal of the Korean Geotechnical Society
    • /
    • v.25 no.1
    • /
    • pp.65-76
    • /
    • 2009
  • The unsaturated characteristics of Korean weathered granite soils have been studied to investigate the influence of saturated permeability, rainfall intensity and soil-water characteristic curve (SWCC) on the slope stability. The upper, average and lower SWCCs were estimated from the publication and experimental results using the statistical concept. The roughly estimated SWCC can be used for the soils without experimental results by relating SWCC with the particle size distribution curve. An appropriate ratio between the saturated permeability and the rainfall intensity ($k_s$/i) was also suggested for practical use in designing the slopes by investigating the time-dependent variation of slope instability during the rainfall. The slope stability was deteriorated from the initiation of rainfall and recovered again after the factor of safety reached the critical value. The FS of the slope decreased at first and then increased after reaching the critical value during the rainfall. As a result, the slope instability was not related with an absolute rainfall intensity but with the ratio between the saturated permeability and the rainfall intensity. In case of the upper SWCC, the critical condition occurred when the ratio between the saturated permeability and the rainfall intensity was in the range of $1.0{\sim}2.0$.

Community Structure and Species Composition of Pinus densiflora for. erecta Forest in Mt. Cheonchuk (천축산 일대 금강소나무림의 군집구조 및 종조성)

  • Byeon, Jun Gi;Park, Byeong Joo;Joo, Sung Hyun;Cheon, KwangIl
    • Korean Journal of Plant Resources
    • /
    • v.33 no.1
    • /
    • pp.1-14
    • /
    • 2020
  • This study was conducted to analyze community structure and species composition of Pinus densiflora for. erecta Stand in Mt. Cheonchuk (653 m). Field survey was carried out from June to September in 2013. 74 plots (20×20 m) were set up, 5 herb layer plots (3×3 m) were constructed for each plot, and there, Diameter at Breast Heigh t(DBH), height, environmental factor, annual growth were measured. Vascular plants were surveyed as following; 66 family, 165 genus, 211 species, 2 sub species, 29 variety, 6 form 248 taxa. Results of cluster analysis for P. densiflora for. erecta forest, 3 communities were divided into; Quercus mongolica (P-1), Quercus variabilis (P-2) and Quercus aliena-Stephanandra incisa (P-3). There were significant environmental factors that organic layer, annual growth, CEC, total total nitrogen, organic matter and pH for each community. As a result of DCA, P-1 and P-2 were distributed large range of environmental factors but relatively limited in P-3. Distributions of herb layer were affected by sand, cation exchange capacity, silt and total nitrogen. Results of MRPP test for herb layer communities, it was significantly analyzed (A=0.003, P<0.008). Species diversity index was highly recorded in P-3 and influenced by cation exchange capacity, total nitrogen, annual growth in consequence of NMS analysis.

The strategy of Co-opetition in accordancd with the rapid changes of the environments of global port competition (글로벌 항만경쟁 환경의 급변에 따른 코피티션(Co-opetition) 전략 활용 방안)

  • Yun, Hee-Sook
    • Journal of Korea Port Economic Association
    • /
    • v.23 no.3
    • /
    • pp.79-101
    • /
    • 2007
  • The purpose of this study is to identify key factors of Co-opetition through examining the environmental and structural changes in the ports industry and suggest a few Co-opetition strategies for enhancing our ports capabilities in the long-term. In recent years, the trend toward market liberalization and globalization in ports industry has made rapid progress and it made the competition fiercer. To survive in this rapid changes, the ports have traditionally pursed a competitive strategy. However, an alternative strategy replacing the traditional strategy was introduced: namely, 'Co-opetition' a buzzword combining competition and co operation. Policy proposals this study suggests are the construction of a database regarding costs and benefits of ports for more effective analysis and improving the competitive power of a shipping company operating national flag carriers for achieving the purpose of Co-opetition and adoption of selection and concentration strategy for increasing the possibility of Co-opetition success.

  • PDF

A Study of the Combination Method for Earthwork Equipments Using the Environmental Loads and Costs (토공사 환경오염물질 부하량 및 공사비를 이용한 장비조합방법 연구)

  • Kang, Min-Ho;Park, Hyung-Keun
    • KSCE Journal of Civil and Environmental Engineering Research
    • /
    • v.33 no.3
    • /
    • pp.1215-1224
    • /
    • 2013
  • Great efforts have been made worldwide to reduce the Green House Gas (GHG) emission following the "Kyoto Protocol" declared during the United Nations Framework Convention on Climate Change in 1997. Many industries have restructured to meet the standard set by the Protocol. However, no clear guidance has been established for the purpose of reducing the GHG emission in construction industry. In addition, no significant effort has been made to conserve the energy during construction activities. For more effective energy saving in construction industry, it is essential to collect data about energy consumption, quantity of environmental emissions and costs. However, most studies on sustainable construction have been concentrated on the use of equipment, maintenance and repair works during construction due to the difficulties of collecting such data. This study suggests a method to select the most environmentally friendly equipment combination for earthwork with comparing environmental loads and costs using the database of Life Cycle Inventory in the Ministry of Knowledge Economy and Ministry of Environment of Korea.

A Development of Real-time Vibration Monitoring and Analysis System Linked to the Integrated Management System of Ministry of Public Safety and Security (국민안전처 통합관리시스템 연계 가능한 시설물 진동 감지 및 분석 시스템 개발)

  • Lim, Ji-Hoon;Jung, Jin-Woo;Moon, Dae-Joong;Choi, Dong-Ho
    • Journal of the Korea institute for structural maintenance and inspection
    • /
    • v.20 no.3
    • /
    • pp.130-139
    • /
    • 2016
  • A frequency of earthquake occurrence in the Republic of Korea is increasing over the past few decades. In this situation, an importance of earthquake prevention comes to the fore because the earthquake does damage to structures and causes severe damage of human life. For the earthquake prevention, a real-time vibration measurement for structures is important. As an example, the United States of America and Japan have already been monitoring real-time earthquake acceleration for the important structures and the measured acceleration data has been managed by forming database. This database could be used for revising the seismic design specifications or predicting the damage caused by earthquake. In Korea, Earthquake Recovery Plans Act and Enforcement Regulations are revised and declared lately. Ministry of Public Safety and Security is constructing a integrated management system for the measured earthquake acceleration data. The purpose of this research is to develop a real-time vibration monitoring and analysis system for structures which links to the integrated management system. The developed system contains not only a monitoring function to show real-time acceleration data but also an analysis system to perform fast fourier transform, to obtain natural frequency and earthquake magnitude, to show response spectrum and power spectrum, and to evaluate structural health. Additionally, this system is designed to be able to link to the integrated management system of Ministry of Public Safety and Security. It is concluded that the developed system can be useful to build a safety management network, minimize maintenance cost of structures, and prevention of the structural damage due to earthquake.

A Study on the Correlation between Coal Mining Subsidence and Underground Goaf (페탄광지역의 지반침하발생과 지하 채굴적의 상관관계 연구)

  • Choi, Jong-Kuk;Kim, Ki-Dong;Song, Kyo-Young;Jo, Min-Jeong
    • Economic and Environmental Geology
    • /
    • v.41 no.4
    • /
    • pp.453-464
    • /
    • 2008
  • This study is to examine a relation between coal mining subsidence occurrence at abandoned underground coal mines and underground goaf with respect to surface geology, subsurface structure, depth and thickness of coal beds and the distribution of drifts. A study is carried out at the site where susceptibility of coal mining subsidence was proven high in a previous study. In that previous study, the susceptibility of coal mining subsidence was spatially analyzed by GIS using digitized geological maps, investigation reports, digitized mining tunnel maps without consideration of subsurface structure and the multi-level arrangement of drifts. Here we analyze geological characteristics around the goaf and the distribution of coal seam based upon digitized geological maps and investigation reports on the study area. And digitized mining tunnel maps are also used to analyze the depth and multi-level arrangement of drifts. The results show that weakened surface rock strength, relatively shallow depth and large thickness of coal seam below the surface are closely related to the coal mining subsidence occurrence. Complicatedly inter-connected drifts, shallow depth of drifts and surface rock fractures are revealed as additional control factors affecting coal mining subsidence. These factors examined in this study as well as original factors should be taken into account for the quantitative estimation of coal mining subsidence occurrence at abandoned underground coal mine.

상품에 대한 공급자 검색 문제 해결하기 위한 지능형 상품 에이전트 개발

  • Chae, Sang-Yong;Kim, Gyeong-Pil;Kim, U-Ju;Kim, Chang-Uk
    • Proceedings of the Korea Inteligent Information System Society Conference
    • /
    • 2005.11a
    • /
    • pp.475-480
    • /
    • 2005
  • 인터넷상에 존재하는 수 많은 웹 페이지들에는 정형화되지 않은 각종 정보들이 이종의 형태로 산재되어 있다. 현재의 검색 기술을 통하여 필요한 정보를 찾아내는 것은 시간과 비용이 많이 소요되는 비효율적인 방법으로 이뤄지고 있다. 이러한 상황에서 사용자가 원하는 정보를 검색 및 추출해내어 정형화시키는 것은 매우 중요하다. 전자상거래의 폭발적 성장에도 불구하고 전자상거래 표준 활용 및 적용이 미비하여 e- Procurement, e-Marketplace, on-Line Shopping Mall 등에서 소비자가 원하는 상품 정보를 손쉽게 획득하지 못하고 있다. 이는 공급자에게는 보다 많은 매출의 기회를 구매자에게는 보다 좋은 자재 및 상품을 저렴한 가격에 소싱 할 수 있는 기회를 제공하지 못하는 문제점이 발생한다. 본 연구에서 제안하고자 하는 지능형 상품 에이전트는 소비자가 구매하고자 하는 특정 상품에 대한 공급자 검색 문제를 해결하기 위하여, 시스템 내부 정보의 확장 및 지식화 뿐만 아니라 웹 상의 다양한 상품 정보를 자동적으로 수집 및 가공하여 저장하는 역할을 수행한다. 이러한 연구를 위해서 사용한 기술은 우선 database 의 schema 를 읽어 들일 수 있는 DB schema reader, 인터넷 웹 페이지(웹문서)를 방문해서 다양한 정보들의 URL을 수집하는 일을 하는 Meta Search Engine 과 Focused Crawler, 그리고 다른 형태의 데이터 구조를 특정 목적에 따라 표준화된 형태로 바꾸는 Wrapper가 있다. 이러한 기술들을 연동하여 필요한 정보들을 추출 공급자 검색 문제를 해결하고자 하는 것이 연구의 목적이다. 정보추출은 사용자의 관심사에 적합한 문서들로부터 어떤 구체적인 사실이나 관계를 정확히 추출하는 작업을 가리킨다.앞으로 e-메일, 매신저, 전자결재, 지식관리시스템, 인터넷 방송 시스템의 기반 구조 역할을 할 수 있다. 현재 오픈웨어에 적용하기 위한 P2P 기반의 지능형 BPM(Business Process Management)에 관한 연구와 X인터넷 기술을 이용한 RIA (Rich Internet Application) 기반 웹인터페이스 연구를 진행하고 있다.태도와 유아의 창의성간에는 상관이 없는 것으로 나타났고, 일반 유아의 아버지 양육태도와 유아의 창의성간의 상관에서는 아버지 양육태도의 성취-비성취 요인에서와 창의성제목의 추상성요인에서 상관이 있는 것으로 나타났다. 따라서 창의성이 높은 아동의 아버지의 양육태도는 일반 유아의 아버지와 보다 더 애정적이며 자율성이 높지만 창의성이 높은 아동의 집단내에서 창의성에 특별한 영향을 더 미치는 아버지의 양육방식은 발견되지 않았다. 반면 일반 유아의 경우 아버지의 성취지향성이 낮을 때 자녀의 창의성을 향상시킬 수 있는 것으로 나타났다. 이상에서 자녀의 창의성을 향상시키는 중요한 양육차원은 애정성이나 비성취지향성으로 나타나고 있어 정서적인 측면의 지원인 것으로 밝혀졌다.징에서 나타나는 AD-SR맥락의 반성적 탐구가 자주 나타났다. 반성적 탐구 척도 두 그룹을 비교 했을 때 CON 상호작용의 특징이 낮게 나타나는 N그룹이 양적으로 그리고 내용적으로 더 의미 있는 반성적 탐구를 했다용을 지원하는 홈페이지를 만들어 자료 제공 사이트에 대한 메타 자료를 데이터베이스화했으며 이를 통해 학생들이 원하는 실시간 자료를 검색하여 찾을 수 있고 홈페이지를 방분했을 때 이해하기 어려운 그래프나 각 홈페이지가 제공하는 자료들에 대한 처리 방법을 도움말로 제공받을 수 있게 했다. 실시간 자료들을 이용한 학습은 학생들의 학습 의욕과 탐구 능력을 향상시켰으

  • PDF

Research Trends Analysis in the field of Overseas Public Library Programs based on Keyword Profiling (키워드 프로파일링에 기초한 국외 공공도서관 프로그램 분야의 연구 동향 분석)

  • Kim, Pan Jun
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.56 no.3
    • /
    • pp.27-46
    • /
    • 2022
  • Today, public libraries are contributing deeply to our society by strengthening their ability and services to identify and respond to users' needs through various programs. However, it is difficult to find a study that analyzed the research status of public library programs or changes over time. Therefore, for the purpose of systematically grasping research trends in the field of overseas public library programs, an intellectual structure analysis based on keyword profiling was performed. Specifically, subject terms analysis, network analysis and cluster analysis, and analysis by period/year were performed based on the controlled keywords (subject terms) of journal articles papers searched in the LISTA database. As a result, first, it was found that 9 subjects corresponding to all global/hot/local topics are leading the research in the field of overseas public library programs. Second, five research areas in the field of overseas public library programs(cultural programs, outreach programs, activity programs, public services, community) could be visualized and clearly identified. Third, research in the field of overseas public library programs began in earnest in the late 1990s and was active from the mid-2000s to the early 2010s, and after that, it was found to be somewhat stagnant until recently. This study is the result of specifically identifying research trends on programs that recently emerged as a major task of public libraries, and can be used as basic data and prior knowledge to explore the development direction of public library programs in the future.