• Title/Summary/Keyword: 시트

Search Result 1,571, Processing Time 0.028 seconds

SQL Extensions for Handling Spreadsheets and PIVOT tables in OLAP Environment (OLAP 환경에서 스프레드시트와 피벗 테이블을 다루기 위한 SQL의 확장)

  • Shin, Sung-Hyun;Kim, Jin-Ho;Moon, Yang-Sae;Kim, Sang-Wook
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2008.06c
    • /
    • pp.21-25
    • /
    • 2008
  • 온라인 분석 처리(On-Line Analytical Processing: OLAP)은 데이터 웨어하우스로부터 다차원 데이터를 분석하거나 의사 결정을 위한 유용한 정보를 제공하고 있다. 데이터 분석을 위해, OLAP에서는 다차원 데이터를 표현한 스프레드시트(spreadsheet) 또는 피벗 테이블(PIVOT table)을 널리 사용하고 있다. 스프레드시트와 피벗 테이블은 서로 유사한 형태로써 분석의 기준이 되는 애트리뷰트들이 많은 구조이다. 사용자들은 흔히 사용되고 있는 SQL 구문을 이용하여 스프레드시트 또는 피벗 테이블에서 손쉬운 데이터 분석을 요구한다. 그러나, RDBMS에서 제공하는 SQL 구문의 사용으로, 이는 다차원 데이터를 효과적으로 분석할 수 없다. 그 이유는 SQL 구문이 다양한 데이터 분석의 목적으로 사용되거나, 요약된 집계 정보를 도출하는 데 한계가 있기 때문이다. 따라서, 본 연구에서는 SQL 구문을 확장하여 다차원 데이터를 표현한 스프레드시트를 손쉽게 조작하고, 요약된 집계를 계산하는 셀(cell) 구문을 제안한다. 이 방법은 스프레드시트와 피벗 테이블에서 행과 열이 교차하는 좌표(coordinate)를 이용하여, 특정 셀의 조작 및 선택한 부분/전체 영역에 대한 집계 정보를 계산하는 방법이다. 결과적으로, RDBMS에서 사용되는 SQL 구문이 친숙한 사용자들이 제안한 셀 구문을 이용하면, 다양한 관점에 따라 손쉽게 스프레드시트와 피벗 테이블을 다룰 수 있을 것으로 사료된다.

  • PDF

Ride Quality Analysis Using Seated Human Vibration Modeling (시트-인체 진동 모델링을 이용한 승차감 해석)

  • Kang, Ju Seok
    • Journal of the Korean Society for Railway
    • /
    • v.18 no.3
    • /
    • pp.194-202
    • /
    • 2015
  • In this paper, dynamic modeling with viscoelastic properties of a human body resting on a seat is presented to quantitatively analyze ride quality of passengers exposed to vertical vibrations. In describing the motions of a seated body, a 5 degree-of-freedom multibody model from the literature is investigated. The viscoelastic characteristics of seats used in railway vehicles are mathematically formulated with nonlinear stiffness characteristics and convolution integrals representing time delay terms. Transfer functions for the floor input are investigated and it is found that these are different in accordance with the input magnitude due to nonlinear characteristics of the seat. Measured floor input at the railway vehicle is used to analyze realistic human vibration characteristics. Frequency weighted RMS acceleration values are calculated and the effects of the seat design parameters on the frequency weighted RMS acceleration values are presented.

아라미드섬유 및 탄소섬유 시트로 보강된 철근 콘크리트보의 전단특성

  • 구봉근;김태봉;김창운;류택은
    • Proceedings of the Korean Institute of Industrial Safety Conference
    • /
    • 1997.11a
    • /
    • pp.165-169
    • /
    • 1997
  • 기존 구조물의 보강을 하는 데는 휨모멘트 및 전단력에 대하여 충분한 보강 효과를 가지는 것과 함께 시공성을 만족해야만 한다. 현재 연속 섬유시트 중 아라미드섬유시트(AFS) 및 탄소섬유시트(CFS)는 기존구조물의 보강재로 사용한 사례가 증가하고 있으나 합리적인 보강설계방법이 확립되어 있지 않은 현 시점에서는 적절한 보강이 이루어지지 않는 경우가 많다 AFS 및 CFS에 의해 RC보의 적절한 보강을 위해서는 AFS 및 CFS를 이용한 기존 콘크리트 구조물의 보강설계방법의 구축이 급선무이다. (중략)

  • PDF

A Methodology for Driver's Comfort Evaluation (운전자의 안락감 평가 방법)

  • 김선웅;박세진
    • Proceedings of the Korean Society for Emotion and Sensibility Conference
    • /
    • 2002.05a
    • /
    • pp.171-176
    • /
    • 2002
  • 자동차 시트 시스템의 개발은 주요한 연구 과제가 되어 왔으며, 이러한 분야의 연구들은 일반적으 로 두 개의 형태로 나누어지는데, 그 첫 번째는 자동차 시트의 위치나 인체 측정학적인 요구 조건에 대한 연구이고, 두 번째는 시트의 안락감 성능에 대한 연구이다. 본 연구는 후자인 시트의 안락감 성능을 평가하기 위한 방법론적인 접근을 하고자 한다. 안락감을 평가하는 방법으로는 크게 정성적인 평가방법과 정량적인 평가 방법이 있다. 과거에는 주로 정성적인 평가방법이 사용되었지만, 최근에는 정량적인 평가 방법들이 많이 개발되어 활용되고 있다. 따라서 이러한 평가 방법들을 체계적으로 분석해 봄으로써 각 방법들에 대한 장ㆍ단점을 이해하고 적절하게 활용하는 가이드라인을 제공하고자 하였다.

  • PDF

Experimental Study on Reinforcement Effects of PET Sheet (PET 섬유의 보강효과에 관한 실험적 연구)

  • Ha, Sang-Su
    • Journal of the Korea institute for structural maintenance and inspection
    • /
    • v.21 no.5
    • /
    • pp.163-169
    • /
    • 2017
  • Although the strength of polyethylene terephthalate (PET) fibers which are generally used to make plastic bottles is low, the deformability of PET fibers is substantially high. Due to these material characteristics, a PET fiber can be used as a reliable strengthening material to resist a large deformation caused by earthquake and research pertinent to application of PET fibers is actively conducted in Japan. Therefore, in this study, experiments have been carried out to investigate the lateral confinement effect of PET fibers and to assess the applicability of PET fibers to construction fields by comparing the strengthening effect of PET fibers to that of carbon and glass fiber sheets. For this purpose, concrete cylinder specimens with parameters of different concrete strength and strengthening layers of carbon fiber sheets, glass fiber sheets, and PET fibers were respectively tested using two sets of cylinders for each parameter. As a result, specimens strengthened with carbon fiber sheets and glass fiber sheets failed due to sudden decrease of strength as with existing studies. However, specimens with PET fibers reached their maximum strength and then failed after gradual decrease strength without failure of PET fibers. In addition, although the strength of specimens with PET fibers did not significantly increase in comparison with that of specimens with carbon fiber sheets and glass fiber sheets, specimens with PET fibers indicated considerable deformability. Thus, a PET fiber can be considered as an effective strengthening material.

Development of embedded type antenna structure with NFC and WPC complex function (NFC 와 WPC 복합기능의 삽입형 안테나 복합체 개발)

  • Park, Rog-gook;Lee, Deok-soo;Jang, Jeong-sun
    • Journal of Platform Technology
    • /
    • v.6 no.4
    • /
    • pp.59-68
    • /
    • 2018
  • The objective of this study is to develop an embedded antenna structure with NFC and WPC composite functions. By selecting stable materials, the optimal component ratio of the polymer sheet was determined. The low cost embedded winding method compared to the existing FPCB was devised. During the winding process, characterization and process technology were developed. We also fabricated a ferrite mold to process the WPC grooves and developed the process technology for optimizing the WPC antenna. The following conclusions were obtained. (1) Optimum composition ratio was derived as Fe 87.5%, Si 7%, Al 5.5% and selected as the final material. (2) Optimal sheet conditions were derived from the experimental evaluation method and the experimental design method through the combination test of the optimized sheet and the conventional mass production FPCB. (3) According to coil diameter and inner diameter, Q value fluctuation, resistance value and efficiency fluctuation are obtained. Therefore, the most suitable coil condition is selected and Rx matching is performed. (4) The EMV load modulation test and the cognitive distance test of the polymer sheet and the ferrite sheet showed that the recognition distance of the polymer sheet at 1k and 4K was 32-33 mm and the recognition distance of the ferrite sheet at the same condition was 30-31 mm.

Performance Measurement of The Hybrid Sheet with Dual Function of Electromagnetic-Shielding and Heat-Dissipating (전자파차폐 및 방열 기능을 가지는 하이브리드시트 성능측정)

  • Ahn, Sung-Su
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.22 no.5
    • /
    • pp.530-536
    • /
    • 2021
  • This paper presents the performance measurement results of a hybrid sheet with both shielding and heat dissipation functions developed by laminating copper mesh sheets and natural graphite sheets, which are used widely as electromagnetic shielding and heat-dissipating materials in electronic devices, without a pressure-sensitive adhesive (PSA). The results were compared by measuring the vertical and horizontal thermal conductivity with two other products to confirm the heat dissipation performance. A radiation emission test confirmed the electromagnetic shielding performance using a 3m electromagnetic anechoic chamber according to the CISPR 11 standard. In the case of vertical thermal conductivity, the proposed hybrid sheet was approximately 8.63 times higher than that of an aluminum sheet with heat dissipation coating and 18.7 times higher than that of a copper sheet laminated with artificial graphite with PSA. The proposed hybrid sheet was approximately 0.64 times that of the sheet, and approximately 1.76 times that of the heat-dissipated aluminum sheet in case of horizontal thermal conductivity. Measurements after applying each sheet in the same heat source revealed the proposed hybrid sheet to have the best heat dissipation performance. The radiation emission test showed that significantly radiation noise had been removed.

A Study on Automatic Position Detection System for the Detachable Mobile Seat of a Vehicle for the Handicapped (장애인 차량을 위한 탈착식 시트의 자동 위치감지시스템에 관한 연구)

  • Youn, Jae-Woong;Lee, Soo Cheol
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.17 no.7
    • /
    • pp.25-33
    • /
    • 2012
  • This paper deals with the development of automatic docking system for the detachable mobile seat(DMS) of a vehicle for the handicapped people who are unable to ride in a car by oneself. Although such vehicles for the handicapped already exist, there is a need for a vehicle with improved docking method for convenience. This paper presents an automatic docking system using two ultrasonic sensors. In order to identify the precise location of the mobile seat in front of the vehicle door, the capability of ultrasonic sensor for detecting the part edge is analyzed and mathematical modeling is performed to measure the exact location of the side edge. And also, this paper presents an automatic docking method using this sensor system and the car lift which is provided in the inside of the car.

Human Body Vibration Analysis under Consideration of Seat Dynamic Characteristics (시트 동특성을 고려한 인체 진동 해석)

  • Kang, Juseok
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.13 no.12
    • /
    • pp.5689-5695
    • /
    • 2012
  • In this study, vibration properties of seat and human body are analyzed through test and numerical analysis methods by taking into account the viscoelastic characteristics of polyurethane foam as seat material which is applied for vehicle. These viscoelastic characteristics which show nonlinear and quasi-static behavior are obtained by compression test. In addition, the viscous elastic property of polyurethane foam is modelled mathematically by using convolution integral and nonlinear stiffness model. In order to analyze the performance on ride comfort of seat, vertical vibration model is established by using dynamic model of seat and vertical vibration model of human body at ISO5982, and so the related motion equations are derived. A numerical analysis simulation is applied by using the nonlinear motion equation with Runge-Kutta integral method. The dynamic responses of seat and human body on the input of vibration acceleration measured at the floor of the railway vehicle are examined. The variation of the index value at ride comfort on seat design parameters is analyzed and the methodology on seat design is suggested.

Preserving and Breakup for the Detailed Representation of Liquid Sheets in Particle-Based Fluid Simulations (입자 기반 유체 시뮬레이션에서 디테일한 액체 시트를 표현하기 위한 보존과 분해 기법)

  • Kim, Jong-Hyun
    • Journal of the Korea Computer Graphics Society
    • /
    • v.25 no.1
    • /
    • pp.13-22
    • /
    • 2019
  • In this paper, we propose a new method to improve the details of the fluid surface by removing liquid sheets that are over-preserved in particle-based water simulation. A variety of anisotropic approaches have been proposed to address the surface noise problem, one of the chronic problems in particle-based fluid simulation. However, a method of stably expressing the preservation and breakup of the liquid sheet has not been proposed. We propose a new framework that can dynamically add and remove the water particles based on anisotropic kernel and density to simultaneously represent two features of liquid sheet preservation and breakup in particle-based fluid simulations. The proposed technique well represented the characteristics of a fluid sheet that was breakup by removing the excessively preserved liquid sheet in a particle-based fluid simulation approach. As a result, the quality of the liquid sheet was improved without noise.