• Title/Summary/Keyword: physical database design

Search Result 122, Processing Time 0.024 seconds

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

  • 박현철;이상곤;신철수
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 2004.10a
    • /
    • 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 (사용성 평가 전용 인체모델 선정 소프트웨어 개발 및 자동차 적용사례)

  • Lim, Young-Jae;Park, Sung-Joon;Park, Woo-Jin;Park, Jun-Soo;Jung, Eui-S.;Lim, Ik-Sung
    • Journal of the Ergonomics Society of Korea
    • /
    • v.29 no.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 (개념적 설계를 배제한 관계형 데이터베이스 스키마의 설계)

  • Um Yoon-Sup
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.9 no.2
    • /
    • pp.445-453
    • /
    • 2005
  • The design process of a relational database system consists of requirement analysis, conceptual design using ER diagram, logical design, and physical design. In logical design process, the conceptual schema is transformed to relational schema, and relational schema is normalized. This traditional design process is hard to applied in real database design process, since there is an ambiguity in conceptual design process. In this paper, we suggest a new design process, which provides more structural design steps by removing the conceptual design process. In new approach, we produce the data flow diagram by the structural methodology. From the attributes in the data store of data flow diagram, we construct relational table schema, and we normalize relational schema. Finally we produced table relationship diagram in order to figure out relationships between tables.

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

  • Kim, Dong-Wook;Park, Kwang-Suk;Kim, Jung-Ja;Kim, Nam-Gyun
    • Journal of Biomedical Engineering Research
    • /
    • v.28 no.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
    • /
    • v.9 no.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
    • /
    • v.16 no.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 (분산 테이타베이스를 위한 양식을 이용한 분산 설계 방법론)

  • Lee, Hui-Seok;Kim, Hui-Jin;Kim, Yeong-Sam
    • Asia pacific journal of information systems
    • /
    • v.5 no.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

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

  • 남태희
    • KSCI Review
    • /
    • v.1 no.2
    • /
    • pp.73-94
    • /
    • 1995
  • In this paper, design of efficient NDB(Network Data Base) for the activation plan of chain information network. The DB structure build up, logical structure, store structure, physical structure, the data express for one's record, and the express using linked in the releation of data. Also express as hierarchical model on the DSD(Data Structure Diagram) from the database with logical structure. Each node has express on record type, the linked in course of connective this type, the infuence have efficent of access or search of data, in the design for connection mutually a device of physical, design for database, and construction a form of store for logical. Also activation of chain information network of efficent, using POS(Point Of Sale) system in OSI(Open Systems Interconnection) environment for network standardization, and build up network a design for system.

  • PDF

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

  • Lee Jae-Inn
    • The Journal of Information Systems
    • /
    • v.12 no.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 (병동간호업무 전산화를 위한 데이터베이스구축;간호업무기록지를 중심으로)

  • Nah, Ji-Young
    • Journal of Korean Academy of Nursing Administration
    • /
    • v.2 no.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