• Title/Summary/Keyword: DB Management

Search Result 1,094, Processing Time 0.026 seconds

A Comparative Analysis of Content-based Music Retrieval Systems (내용기반 음악검색 시스템의 비교 분석)

  • Ro, Jung-Soon
    • Journal of the Korean Society for information Management
    • /
    • v.30 no.3
    • /
    • pp.23-48
    • /
    • 2013
  • This study compared and analyzed 15 CBMR (Content-based Music Retrieval) systems accessible on the web in terms of DB size and type, query type, access point, input and output type, and search functions, with reviewing features of music information and techniques used for transforming or transcribing of music sources, extracting and segmenting melodies, extracting and indexing features of music, and matching algorithms for CBMR systems. Application of text information retrieval techniques such as inverted indexing, N-gram indexing, Boolean search, truncation, keyword and phrase search, normalization, filtering, browsing, exact matching, similarity measure using edit distance, sorting, etc. to enhancing the CBMR; effort for increasing DB size and usability; and problems in extracting melodies, deleting stop notes in queries, and using solfege as pitch information were found as the results of analysis.

Development of a 3D Model-Based Demonstration DB System for Efficient Management and Utilization of Inspection and Diagnosis Data of Small and Medium-Sized Bridges (중소규모 교량의 점검·진단 데이터 효율적 관리 및 활용을 위한 3D 모델 기반 실증 DB시스템 개발)

  • Park, Se-Hyun;Jung, Dae-Sung;Seo, Jin-Sook;Kim, Tae-Hyeong
    • Journal of the Korea institute for structural maintenance and inspection
    • /
    • v.25 no.6
    • /
    • pp.1-11
    • /
    • 2021
  • As the aging of large domestic SOC facilities accelerates, facility maintenance is also changing from safety evaluation based on the current condition to performance-oriented preventive and preemptive maintenance based on the prediction of the level of future obsolescence. In particular, in the case of bridges, class 1 and 2 bridges are systematically managed along with many studies, but for small and medium-sized class 3 bridges there is no collection and utilization of historical data presenting performance degradation during their service life. Therefore, in this study, 3D model-based demonstration DB system was designed and developed to intuitively check the damage change rate at the damage location by registering the maintenance history by life cycle for each member's exterior damage in the 3D bridge object and to enable API-based comprehensive performance evaluation.

The Impact of Employee's Attributes on Corporate Pension Insurance Products Preference (기업연금보험상품 선호도에 대한 종업원 속성의 영향)

  • Joo, Heon
    • The Korean Journal of Franchise Management
    • /
    • v.7 no.2
    • /
    • pp.27-35
    • /
    • 2016
  • Purpose - The primary objective of this study is to investigate the impact of employee characteristics on employees' preference towards corporate pension products. This study can provide a guidance for maximization of benefits for employees and their affiliated corporation. Employee characteristics include average length of labour, wage system of annual salary, age, types of interest rates and size of corporation. Existing research generally concentrate on vitalizations of corporate pension product raising an imperfection, improvements, tax benefit analysis and legal consideration. Thus, this study intensively analyses the effect of employee attributes on firms' decision for corporate pension products, such as DB(defined benefit) and DC(defined contribution) type. Research design, data, and methodology - The data were collected using self-administrated questionnaire survey on corporate pension products from CEOs or HR directors 250 foreign-invested companies', purchasing pension plans in practice with domestic financial trustees (insurance companies, banks and security companies). Hypotheses testing was conducted using Logistic Regression analysis with SPSS/PC+ 21.0. Results - The findings of the study are as follows. Employees with the long length of labour are more likely to have DB plan; more likely to prefer DC plan with the dividend distribution product regarding the types of interest rate. SMEs(less than 100 employees) are more likely to select DC plan whereas high fluctuation in wage with annual salary has no impacts. In addition, the ages has no significant effect on the preference. Conclusions - This study has examined with the empirical testing that employees' variable attributes and qualities are one of the vital factors for corporation pension plan selection. Currently, majority employees are highly likely to join DB plan and Defined interest types. Corporation with less than 10 employees prefer IRP scheme while most of corporation are intended to join DC plan. In a very near future, corporation more than 300 employees will be required to purchase mandatory plan under national regulation. For maximization of employees' contentment to corporation pension insurance and for complementing the flaws of existing plans, the future studies shall also research in a perspective of employee benefit.

Evaluation of Storage Engine on Edge-Based Lightweight Platform using Sensor·OPC-UA Simulator (센서·OPC-UA 시뮬레이션을 통한 엣지 기반 경량화 플랫폼 스토리지 엔진 평가)

  • Woojin Cho;Chea-eun Yeo;Jae-Hoi Gu;Chae-Young Lim
    • The Journal of the Convergence on Culture Technology
    • /
    • v.9 no.3
    • /
    • pp.803-809
    • /
    • 2023
  • This paper analyzes and evaluates to optimally build a data collection system essential for factory energy management systems on an edge-based lightweight platform. A "Sensor/OPC-UA simulator" was developed based on sensors in an actual food factory and used to evaluate the storage engine of edge devices. The performance of storage engines in edge devices was evaluated to suggest the optimal storage engine. The experimental results show that when using the RocksDB storage engine, it has less than half the memory and database size compared to using InnoDB, and has a 3.01 times faster processing time. This study enables the selection of advantageous storage engines for managing time-series data on devices with limited resources and contributes to further research in this field through the sensor/OPC simulator.

Glycemic Index and Oral Glucose Tolerance Test of Takju (Korean turbid rice wine) Lees Extract (막걸리 박 열수추출물의 혈당지수 및 제2형 당뇨 모델 동물에서 경구혈당내성에 미치는 영향에 관한 연구)

  • Lee, Hyun-Sook;Hong, Kyoung-Hee;Yoon, Cheol-Ho;Cho, Woo-Kyoun;Kim, Soon-Mi
    • Journal of the Korean Society of Food Culture
    • /
    • v.23 no.5
    • /
    • pp.662-665
    • /
    • 2008
  • Takju lees extract is expected to be a promising material for functional food. This study was conducted in order to assess the glycemic index (GI) of Takju lees extract and its effects in an oral glucose tolerance test (OGTT). The GI for Takju lees extract was evaluated with 10 healthy young adults (Male 5, Female 5). OGTT was conducted in 20 male db/db mice, fed on a diet containing 2% Takju lees extract for 4 weeks. Those animals were subjected to OGTT after one oral administration of Takju lees extract at 2 g/kg BW. The GI of the Takju lees extract was measured at 97.97. The effects of the Takju lees extract on the oral glucose tolerance test in db/db mice evidenced no differences as compared to the control group. In conclusion, Takju lees extract is a high GI material, and it has no effect on blood glucose levels in a type II diabetic animal model. Further studies will be required to confirm its anti-diabetic effects.

A Personalized Recommendation System Using Machine Learning for Performing Arts Genre (머신러닝을 이용한 공연문화예술 개인화 장르 추천 시스템)

  • Hyung Su Kim;Yerin Bak;Jeongmin Lee
    • Information Systems Review
    • /
    • v.21 no.4
    • /
    • pp.31-45
    • /
    • 2019
  • Despite the expansion of the market of performing arts and culture, small and medium size theaters are still experiencing difficulties due to poor accessibility of information by consumers. This study proposes a machine learning based genre recommendation system as an alternative to enhance the marketing capability of small and medium sized theaters. We developed five recommendation systems that recommend three genres per customer using customer master DB and transaction history DB of domestic venues. We propose an optimal recommendation system by comparing performances of recommendation system. As a result, the recommendation system based on the ensemble model showed better performance than the single predictive model. This study applied the personalized recommendation technique which was scarce in the field of performing arts and culture, and suggests that it is worthy enough to use it in the field of performing arts and culture.

A Study on the Classification of Physical Decline in Small and Medium Cities - Focused on the analysis of building DB in the unit of Census Output Area - (중소도시의 물리적 쇠퇴등급 분류 연구 - 집계구 단위의 건축물 DB 분석을 중심으로 -)

  • Han, Da-Hyuck;Lee, Min-Seok
    • Journal of the Korean Institute of Rural Architecture
    • /
    • v.22 no.3
    • /
    • pp.41-48
    • /
    • 2020
  • The purpose of this research is to manage the physical sectors systematically, needed for the selection and direction of declining areas, such as urban regeneration and revitalization projects, by grading the density of decline indicators of buildings in small and medium cities. In five small and medium-sized cities in Jeollanam-do, the data were divided into three stages according to the density, according to the use, structure, and age of the building. Rating by element of Census Output Area, detailed designation, and management of declining areas in small and medium-sized cities are required, rather than setting the scope of declining areas based on administrative districts. It is also necessary to manage cities through complex and intra-element phasing rather than single elements in defining physical decline. The analysis based on the complex factors and boundary of the Census Output Area is meaningful in order to maintain and manage such cities in a more detailed and precise manner according to such characteristics of each region.

Development of Traffic Centralized Control System Based on Protocol Redirection for DB Protection (DB 보호를 위한 Protocol Redirection기반 트래픽 중앙통제시스템 개발)

  • Su, Yang-Jin;Lee, Jae-Pil;Park, Cheon-O;Lee, Deok-Gyu;Chang, Hang-Bae
    • Journal of Korea Multimedia Society
    • /
    • v.13 no.8
    • /
    • pp.1212-1220
    • /
    • 2010
  • The technologies of domestic user programs are not enough to convert address convert information, which was collected via port redirection server, to user traffic. Generally traffic redirection technology is a special purpose technology for I/O traffic via network device. L4 switch needs various additional costs and devices to achieve this special purpose. To solve this problem, there appears need for a central management of control and monitoring by centralizing traffic at one position regardless of network structure and it is necessary to realize redirection function of switch at network layer. Therefore this study offer development of traffic central control system through protocol redirection of client-side.

Development of Disaster Damages Information System using Spatial Images (공간영상 기반 피해정보추출시스템 개발에 관한 연구)

  • Kim, Tae-Hoon;Kim, Kye-Hyun;Shim, Jae-Hyun;Choi, Woo-Jung
    • Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
    • /
    • 2008.10a
    • /
    • pp.51-56
    • /
    • 2008
  • 본 연구에서는 광역적 피해조사를 위해 고해상도 항공사진 및 위성영상을 이용한 피해정보추출시스템을 개발하였다. 연구 대상지역은 2006년 집중호우로 큰 피해를 입은 강원도 인제지역을 선정하였으며, 해당지역 중 특히 피해가 집중된 덕산리, 덕적리 지역 약 $50km^2$에 대해서 피해 전 후 영상을 확보하고 1:5.000 수치지형도, 연속지적도 등 제반 GIS DB를 구축하였다. 피해정보추출시스템은 ArcObject 컴포넌트를 이용한 VB.NET 2005 언어를 이용해서 개발되었다. 시스템의 좌, 우 영상프레임에 피해 전, 후 영상을 비교하여 피해지역을 선정하며, 선정된 피해지역은 구축된 제반 GIS DB와 중첩기능을 통해 피해항목들을 추출할 수 있도록 개발하였다. 공공시설물의 경우 영상을 통해 판별된 피해 항목들을 피해단위에 맞추어 길이 및 면적을 산출 할 수 있도록 하였다. 피해정보추출 시스템은 고해상도 공간영상을 이용한 광역적 피해조사를 위하여 개발되었으며, 효율적인 활용을 위해서는 전국단위의 고해상도 영상 DB구축이 우선시 되어야 한다. 또한 현재 소방방재청에서 구축하고 있는 NDMS(National Disaster Management System)에 영상 DB 및 통합 영상관리시스템도 함께 구축하여 활용할 수 있는 방안이 마련되어야 한다.

  • PDF

A Study on the Improvement of Land Suitability Assessment Results Using GIS Database (디지털 지리정보DB를 활용한 토지적성평가 결과의 향상을 위한 실행방법 연구)

  • Kim, Hang-Jib
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.8 no.1
    • /
    • pp.1-12
    • /
    • 2005
  • Land suitability assessment is the procedure that assesses development, agriculture or conservation suitability of land according to such criteria as soil, location and usability. But there are many problems to execute land assessment by law. Problems include inadequate basic data, lack of linkage with the spatial planning system, and inefficiency in operation. The purpose of this study is to improve methods of land suitability assessment as a sustainable land use management tool using case study. In this study, land suitability assessment will be executed through GIS. On the basis of the results of this case study, practical and institutional problems are described, and technical solutions are suggested.

  • PDF