• 제목/요약/키워드: Physical Database Design

검색결과 122건 처리시간 0.024초

자동차용 강판의 물성 데이터베이스 (Database of Steel Sheet for Automotive body)

  • 박현철;이상곤;신철수
    • 한국정밀공학회:학술대회논문집
    • /
    • 한국정밀공학회 2004년도 추계학술대회 논문집
    • /
    • pp.1483-1486
    • /
    • 2004
  • Purpose of this paper is to accummulate database of automotive steel sheet from mild steel to high strength steel in cold rolled steel sheets. Physical properties, mainly mechanical properties, of steel sheet are tested and all data are arranged to one sheet. Methods of test are composed of FLD, tensile strength test, chemical composition, surface roughness and product conditions. Finally this database will be helpful to automotive body designers and die designers to design automotive body parts and tools in a material point of view.

  • PDF

사용성 평가 전용 인체모델 선정 소프트웨어 개발 및 자동차 적용사례 (Development Software to Select Boundary Manikins for Product Evaluation: Applied to an Automobile Case)

  • 임영재;박성준;박우진;박준수;정의승;임익성
    • 대한인간공학회지
    • /
    • 제29권6호
    • /
    • pp.831-841
    • /
    • 2010
  • Usability evaluation of physical products involves characterizing complex physical interactions between humans and products. Human models known as manikins have been widely utilized as usability evaluation tools for automobile interior package design. When combined with computer-aided design software programs, such manikins can be used to simulate driving postures and evaluate driver-interior fits early in the design process, and therefore, may greatly facilitate achieving high-quality design in a cost-efficient manner. The purpose of this study was to define a set of manikins for designing automobile interior packages for the South Korean male population. These manikins were conceptualized as "boundary" manikins, which represent individuals lacking in certain physical capacities or having usability-related issues (e.g., an individual with the 5th percentile forward reach capability, an individual with the 95th percentile shoulder width). Such boundary manikins can serve as an efficient tool for determining if an automobile interior design accommodates the majority of the population. The boundary manikins were selected from the large sample of Korean males whose anthropometric dimensions were described in the recent Size Korea anthropometric database. For each male in the database, his comfortable driving posture was represented using a kinematic body linkage model and various physical capacity measured and usability-related characteristics relevant to driver accommodation were evaluated. For each such measure, a boundary manikin was selected among the Korean males. The manikins defined in this study are expected to serve as tools for ergonomic design of automobile interior packages. The manikin selection method developed in this study was implemented as a generic software program useful for various product design applications.

개념적 설계를 배제한 관계형 데이터베이스 스키마의 설계 (A Design Methodology of Relational Database Schema Without the Conceptual Design Step)

  • 엄윤섭
    • 한국정보통신학회논문지
    • /
    • 제9권2호
    • /
    • pp.445-453
    • /
    • 2005
  • 관계형 데이터베이스의 설계 과정은 요구사항 분석, ER 모델을 이용한 개념적 설계, 논리적 설계, 그리고 물리적 설계 과정으로 구성된다. 논리적 설계과정은 ER 다이어그램으로 구성된 개념적 스키마를 관계형 스키마로 전환하여 정규화시키는 과정으로 이루어진다. 이런 기존의 설계 과정에서 요구사항의 분석 후 개념적 스키마를 도출하는 개념적 설계 과정이 명확치 않음으로 인해서, 실제 데이터베이스 설계현장에서 적용하기 어려운 점이 있다. 본 논문에서는 작업과정이 모호한 개념적 설계를 제거함으로 보다 체계적으로 데이터베이스 스키마를 설계할 수 있는 방법을 제안한다. 구조적 설계 방법을 이용하여 자료 흐름도를 작성하고, 자료흐름도의 자료저장소에 파악된 애트리뷰트를 이용하여 관계합성으로 관계형 스키마를 도출한다. 관계형 스키마를 정규화하고, 정규화된 테이블로부터 데이터의 의미를 파악하여 테이블 관계도를 작성함으로써 최종 논리적 스키마를 결정한다.

고령자의 시각기능데이터베이스 구축을 위한 시각기능계측에 관한 연구 (Studies on Visual Function Measurements for Building Visual Function Database of the Elderly)

  • 김동욱;박광석;김정자;김남균
    • 대한의용생체공학회:의공학회지
    • /
    • 제28권5호
    • /
    • pp.618-627
    • /
    • 2007
  • As our society progresses rapidly toward an aged society, there is a stiff increase in the population of the aged persons who have difficulties in adjusting themselves to environments due to declines of their physical functions. Therefore, there is a great need for the concept of 'Universal Design' that demands the design of overall social structure to care for the elderly. Due to this reason, the physical function of the aged persons should thoroughly be studied for the development of rehabilitation and training equipments to help the recovery of physical functions of the elderly. Among the variety of physical functions of the elderly, visual functions, motion characteristics, hearing functions, and somatosensory functions have significant influence toward everyday lives and are physical functions to study for the construction of urgently needed physical function databases of the elderly. This study concentrates on visual functions among the variety of physical functions of the elderly. To measure various visual functions of the elderly, a measurement room for the elderly has been developed, which can mimic everyday lives and perform measurements of visual functions with subjects in seated position. The measurement items for the construction of the database were capabilities in everyday vision according to changes in arrangement of colors and light intensity and capabilities in everyday vision, color distinction, dark adaptation, and light glare against changes in contrast.

Effects of hippotherapy on children with cerebral palsy: systematic review and meta-analysis

  • Kim, Kwon-Hoi;Lee, Suk-Min
    • Physical Therapy Rehabilitation Science
    • /
    • 제9권1호
    • /
    • pp.55-65
    • /
    • 2020
  • Objective: The most important goal of hippotherapy is to improve function, gait, and balance. The purpose of this study was to investigate the effects of hippotherapy on function, gait, and balance of children with cerebral palsy (CP). Design: A systematic review and meta-analysis. Methods: We've searched the PubMed, EMBASE, and Cochrane Library CENTRAL databases for English experimental studies published up until September 2018. To analyze the effects of hippotherapy on the function, gait, and balance of children with cerebral palsy, the systematic review and meta-analysis were performed on Patient/Participants/Population Problem, Intervention, Comparison, Outcome with Timing, Setting Study Design. Papers retrieved from the database were removed from the literature management database. Methodological quality evaluation was evaluated using Cochrane's risk of bias. Data was analyzed using the Revman 5.3 program of the Cochrane library. Results: In this study, we found that the effect size of hippotherapy, denoted as d, was -3.82, and that hippotherapy had the most effect on gait, but no statistical significant difference was observed. We also found no significant difference in function and balance after hippotherapy. It was found from the funnel plot that there was no publication bias as the plot was symmetrically distributed around the dotted line. Conclusions: There are many unclear studies and a lack of randomized controlled trials (RCTs) in this research area. More RCTs on the effects of hippotherapy on children with CP should be conducted in the future.

Investigation on the Side Effects of Denormalizing Corporate Databases

  • Lee, Sang-Won;Kim, Nam-Gyu;Moon, Song-Chun
    • Journal of Information Technology Applications and Management
    • /
    • 제16권2호
    • /
    • pp.135-150
    • /
    • 2009
  • Corporate databases are usually denormalized, due to the data modelers' impetuous belief that denormalization could improve system performance. By providing a logical insight into denormalization, this paper attempts to prevent every database modeler from falling into the denormalization pit. We indicate loopholes in the denormalization advocates' assertions, and then present four criteria to analyze the usefulness and validity of denormalization; 1) the level of concurrency among transactions, 2) the database independence of the application program, 3) the independence between the logical design and the physical one, and 4) the overhead cost to maintain database integrity under various query patterns. This paper also includes experimental results to evaluate performance of denormalized and fully normalized structures under various workloads.

  • PDF

분산 테이타베이스를 위한 양식을 이용한 분산 설계 방법론 (A Form Based Distribution Design Methodology for Distributed Databases)

  • 이희석;김희진;김영삼
    • Asia pacific journal of information systems
    • /
    • 제5권2호
    • /
    • pp.101-129
    • /
    • 1995
  • This paper proposes a form-based distributed database design methodology ($FD^3$). The methodology consists of five design phases such as (i) form requirement analysis (ii) schema integration (iii) distribution analysis (iv) distribution design, and (v) local logical/physical design. In the $FD^3$, all the important design information for each phase is obtained by using an organizations forms, Users requirements are analyzed by using forms that contain logical and quantitative information for distribution design. $FD^3$ resolves naming conflicts by employing SQLs based on the form field data in the schema integration phase. Furthermore, $FD^3$ enhances the quality of distributed database design by incorporating communication costs into the design model. A real-life case is illustrated to demonstrate the usefulness of the $FD^3$.

  • PDF

효율적인 NDB 설계 및 유통 정보 NETWORK 활성화 방안 (The Activation Plan of Chain Information Network And Efficent NDB Design)

  • 남태희
    • 한국컴퓨터정보학회지
    • /
    • 제1권2호
    • /
    • pp.73-94
    • /
    • 1995
  • 본 논문은 유통정보 네트워크 활성화 방안에 대하여 효율적인 NDB(Network Data Base)을 설계하였다. NDB(Network Data Base)의 구조는 논리 구조, 격납 구조, 물리 구조로 형성되어 데이터는 하나의 레코드로서 표현되고 데이터들 간의 관계는 링크로서 표현되었다. 또한 데이터베이스의 논리적 구조를 표현한 자료 구조도(Data Structure Diagram:DSD)가 계층 모델로 나타내었다. 각 노드는 레코드 타입을 나타내었고, 타입들을 연결하는 방향을 지닌 링크, 논리적인 격납 형태로 구성되어 데이터베이스를 설계하는데 물리 매체상 서로 연관성 있게 설계되어 자료의 검색과 억세스 효율에 큰 영향을 미쳤다. 또한 설계된 시스템에 네트워크를 형성하고, 네트워크 표준화를 위해 OSI 환경하에서 POS(Point Of Sale)시스템을 이용하여 효율적인 유통 정보 네트워크를 활성화시켰다.

  • PDF

웹기반 사이버 상담시스템의 설계 및 구현 (Design and Implementation of web based cyber counseling system)

  • 이재인
    • 한국정보시스템학회지:정보시스템연구
    • /
    • 제12권2호
    • /
    • pp.21-39
    • /
    • 2003
  • Many people including teachers and students' parents must assist each student who will be a hero of future to develop their potential abilities and acquire various skills. Counseling is a fundamental thing to achieve this goal. But, in reality, it is usually difficult to do counseling which makes it possible to establish desirable self-view and world view expertly and systema tically because of burdensome task of teachers, spatial and time limit and students' extracurri cular activities. Taking advantages of computer networking, this research was designed to solve various problematic situations we can usually face with in school and home, to reduce limitations among three parties: teachers, parents and students, and to keep record continuously on the process and contents of counseling. And, also, this research is focused to web-based counseling network that makes possible to build database system easily adapts to specialty of each schools. Web based counseling system will provide these advantages: 1. Through analyzing and editing which will be done by expert In of accumulated database, to realize more systematic and expert database will be possible. 2. Owing to the physical characteristic of cyber space, counseling will be done any time and anywhere the computer is. 3. Because it is possible to minimize social limitations on physical condition, communication channel and anonymity of cyber space, counseling will be relatively easy to perform. 4. The contents of counseling will be automatically recorded on the database.

  • PDF

병동간호업무 전산화를 위한 데이터베이스구축;간호업무기록지를 중심으로 (Database Design in Ward Nursing Information System)

  • 나지영
    • 간호행정학회지
    • /
    • 제2권1호
    • /
    • pp.73-96
    • /
    • 1996
  • In the complexity and diversity of modern society, there is an urgent need for an information system which can systematically collect, manage and analyze data. Especially in the discipline of nursing, a nursing informarion system is necessary to maximize nursing resources and improve nursing care in the present system which is faced with increases in client needs and multiple changes in hospital environments. This research was done to provide a basis for the development of an integrative nursing information system for the future, by designing dababases items which were extracted from an analysis of the ward nursing information system on general wards excluding the OPD, ICU, OR and CSR with functions using a different system from the wards, and the design of output screen used the database items. The ward nursing information system was analysed through analysis of nursing practice related to recordings, such as the worksheet, kardex, and other nursing practice recordings, on 25 wards. The development of the database was the part of the construction of hospital information system and used the database development life cycle which is related to the system development life cycle. The database development steps included selection of database management system and design of a physical database following the principles of the order communication system which is been developing at Y University Hospital. Conceptual database and Logical database were designed using the base of 25 data items and fields derived from analysing the worksheet, the data items and fields derived from the kardex and other nursing practice recording, from these 19 data base tables were framed through transforming the relational database. Through this process, four types of output material for nursing practice recording which nurses can carry and use during their nursing practice were produced.

  • PDF