• Title/Summary/Keyword: schema design

Search Result 494, Processing Time 0.029 seconds

Design of Integrated Database Schema for Improving Usability of Rural Information (농촌정보 활용성 증대를 위한 통합데이터베이스 설계)

  • Lee, Ji-Min;Kyo, Suh;Kim, Han-Joong;Lee, Jeong-Jae
    • Journal of Korean Society of Rural Planning
    • /
    • v.11 no.2 s.27
    • /
    • pp.43-49
    • /
    • 2005
  • As information has been brought to public attention, information storage as well as information usability has been important. Rural information is produced in many areas and institutions. However, it is difficult to use rural information comprehensively. Since formats for management are various, it is difficult to have unified frame. In this research, a schema of database fer integrating rural data is designed to improve usability using dimensional modeling. First of all, rural data are analyzed for designing integrated rural database schema. Rural data used are 'National Agricultural Statistics' and 'Gun annual statistical report'. Analysis shows that there are three considerations; administrative district, time-dependency and classification of data. Considering these three requisite, we designed database schema using dimensional modeling. The reason of using dimensional modeling is to improve usability and effectiveness. If the database was designed using ER modeling, many tables have to be joined every searching time. Separately from integrated rural database schema, user's database schema is designed considering usability. Through user's database, users can modify data or generate new data and save these processes. These make it possible to use generated data repeatedly. We evaluate usability, contribution, and effectiveness of data manipulation on the integrated rural database. We propose an integrated rural database structure improving the accessibility and usability of rural data and information and verified the data model based on a practical example.

A Study of Display Sampling and Visual Momentum (디스플레이 표집과 시각타성에 관한 연구)

  • Yang, Lee-Gha
    • Archives of design research
    • /
    • v.20 no.3 s.71
    • /
    • pp.39-48
    • /
    • 2007
  • This study explored the Eye Movement, the horizontal and vertical flow of vision, and genetic, cultural and empirical schema, and the differentiation of the visual system of the cerebrum through the engineering psychological or the cognitive neuroscientific experiments measuring Eye Movement to maximize the efficiency of the Public Sign System in the urban environment. Accordingly, the study derived an algorithm that can bring out the most efficient visual design measurement by using EMR test and bitmap counting method. The scientific test data in this study will show the existence of the momentum of differentiation and visual sampling by the Schema and Sensory Qualia of the human.

  • PDF

Database Development for Archiving Detailed Design Information of Steel Bridges (강교량의 설계정보 데이터베이스 구축)

  • 이상호;정연석
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2003.04a
    • /
    • pp.313-320
    • /
    • 2003
  • The efficient and well organized database is essential for the management of information in every industrial field. In this study, a practical and effective database which can handle 3-D information of steel bridges is built on the basis of a STEP-based data model. The data model of steel bridge information is classified into geometric and non-geometric part and the design information is represented by linking geometric information and life cycle supported non-geometric information. Especially, the shape information is represented by boundary representation method, which is one of the representative methods of solid model information. In this study, ISO/STEP(STandard for the Exchange of product model data) AP203(configuration controlled design) EXPRESS schema is used to represent the shape information of steel bridge. The syntax of EXPRESS schema of developed data model is verified by NIST Expresso - is a tool for parsing and compiling EXPRESS schema. Also, this study verifies the conformance of the data model by applying to the real data of Hannam bridge. Therefore, the constructed database using STEP-based data model of steel bridges can be used effectively in the concurrent engineering point of view with transferring and sharing steel bridge information.

  • PDF

Design and Implementation of Video GIS for Web Applications

  • Yoo, Jae-Jun;Choi, Kyoung-Ho;Jang, Byoung-Tae;Lee, Jong-Hun
    • Proceedings of the KSRS Conference
    • /
    • 2003.11a
    • /
    • pp.396-398
    • /
    • 2003
  • Recently as users' requests for geographic information systems are being more various, several new functions are being added to existing geographic information systems. One of them is linkage of spatial geographic data and video / image data to offer more realistic information of geographic objects to users. Geographic information systems implementing this function are called video geographic information system. In this paper, we design and implement a video geographic information system for providing map data, video data and link information of them to web applications. We 1) design system architecture of a video geographic information system, 2) analyze some processes to construct link information of map data and video data, 3) design database schema to store map data, video data, and link information, and 4) design some XML/GML schema used to query and retrieve these data for web applications.

  • PDF

Automated Enterprise Data Model by Formulating Requirements

  • Lee, Sang-Won
    • Journal of Information Technology Applications and Management
    • /
    • v.16 no.4
    • /
    • pp.263-283
    • /
    • 2009
  • Although some CASE tools supported conceptual data design, they required for users too much preliminary knowledge to learn how to use and handle them. In addition, in a number of studies on conceptual data design with natural language, they claimed passive participation for users with conforming to messages predefined by CASE tools. As an alternative to these traditional CASE tools, we proposed an ERD formulator for automated data design tool, called ERDF, so that even ordinary users, not necessarily data modeler, are capable of formulating ERD on business requirements by use of ERDF. We, first of all, introduced NSM as the standard methodology. We also designed the structure of ERDF including main controller, input controller, operation controller, regulation controller, schema controller, and output controller. We then defined conceptual domains and basic operations to lay down schema operations as well as sentence rules to handle input sentence in natural language. To get an ERD that is faithful to business requirements, we laid out supplementary design for dialogue and confirmation of soundness and completion.

  • PDF

On the Development of Pipe Equipment in 3D Ship CAD (3차원 선박 CAD를 위한 배관 의장품의 Part Master 정보 구축)

  • Lee, Jang-Hyun;Lee, Hwang-Beom;Hwang, Se-Yun;Ha, Sung-Cook;Lee, Chan-Woo
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2007.04a
    • /
    • pp.819-824
    • /
    • 2007
  • Outfitting system in ship design has huge kinds of standard part. Data base of and automatic design procedure of part master should be included in ship cad in order to reduce the design time. Present study shows an process of part master DB construction of pipe equipments using 3-dimensional CAD environment Attribute and properties of part masters are chosen from JIS standard. As the schema of part masters are stored in data base, 3D geometric model is parsed from the schema.

  • PDF

A formal representation of data exchange for slope stability analysis of smart road design and construction

  • Dai, Ke;Huang, Wuhao;Wen, Ya;Xie, Yuru;Kim, Jung In
    • International conference on construction engineering and project management
    • /
    • 2022.06a
    • /
    • pp.1130-1137
    • /
    • 2022
  • The Industry Foundation Classes (IFC) provides standardized product models for the building construction domain. However, the current IFC schema has limited representation for infrastructure. Several studies have examined the data schema for road and highway modeling, but not in a sufficiently comprehensive and robust manner to facilitate the overall integrated project delivery of road projects. Several discussions have focused on slope engineering for road projects, but no solution has been provided regarding the formalized parametric modeling up to now. Iterative design, analysis, and modification are observed during the process of slope design for road projects. The practitioners need to carry out the stability analysis to consider different road design alternatives, including horizontal, vertical, and cross-section designs. The procedure is neither formalized nor automated. Thus, there is a need to develop the formal representation of the product and process of slope analysis for road design. The objective of this research is to develop a formal representation (i.e., an IFC extension data schema) for slope analysis. It consists of comprehensive information required for slope analysis in a structured manner. The deliverable of this study contributes to both the formal representation of infrastructure development and, further, the automated process of slope design for road projects.

  • PDF

Environmental Design and Cognitive Ecology (환경디자인과 인지생태론)

  • Kim, Joo-Mi
    • Journal of Science of Art and Design
    • /
    • v.13 no.1
    • /
    • pp.23-37
    • /
    • 2008
  • Recently, there are getting popular form generation-related design methodologies and scientific discourses about the nature of nature in the environmental design. The necessity of visual perception and cognitive research is growing in this respect. Accordingly, this study was designed to discuss environmental design and cognition in the ecological perspective. This study was intended to study the structural factors of cognitive ecological space. This study focused on the systematic principle of new environmental design based on cognitive ecological approaches and what kinds of design effects this design principle has on the human being in the long nm. The results are as follows. First, the results suggests that fractal pattern should be an alternative to design cognitive ecological space and new paradigm of architecture is based on the nature of nature and human sensibility. Accordingly, they have proposed that fractal design is more empirical and environment-friendly than rational linear design. Second, this study classified the variables of cognitive ecological space into nature, tradition, preference judgement, aesthetic value, and schema. Accordingly, such features as symbol, tradition, and nature restricted by modernistic ideology should be added to new paradigm-based environmental design. Third, accordingly, this study stresses that cognitive ecological environmental design doesn't include buildings of modernism and deconstruction and is based on new science of complexity.

  • PDF

The Course of Schema Activation in Processing of Humor Text (유머텍스트 처리에서 스키마의 활성화 과정)

  • Choi, Young-Geon;Shin, Hyun-Jung
    • The Journal of the Korea Contents Association
    • /
    • v.15 no.9
    • /
    • pp.425-435
    • /
    • 2015
  • Though most researchers studying humor in recent years agree that 'incongruity' is essential factor of humor elicitation, they have different views in the course of schema activation in processing humor text. One of the different views on schema activation in processing humor text is wether schemata are activated concurrently or selectively. While concurrent activation view suggests that different schemata are concurrently activated because we perceive them at the same time, selective activation view suggests that different schemata are selectively activated because we use selective attention for their perception. This study was conducted to verify these two different views. We clarified that different schemata were activated in processing of humor text, and we examined whether Vaid's experiment failed or not. Experiment was designed mixed 2 (schema1, schema2) ${\times}$ 3 (setup, incongruity, resolution) ${\times}$ (humor, control) factorial design and latin square counterbalancing. As a result of experiment, we got data that different schemata were activated in the course of 'Incongruity' at the same time. Most of all, the activated schemata were kept activation in the course of 'Resolution'. This result suggest that different schemata were activated concurrently.

Design and Implementation of Transformation of XML Schema to Relational Schema (XML 스키마로부터 관계형 스키마 변환 기법 설계 및 구현)

  • 최정규;민미경
    • Proceedings of the Korea Multimedia Society Conference
    • /
    • 2003.11a
    • /
    • pp.392-395
    • /
    • 2003
  • XML은 W3C에서 제안된 웹 상에서 데이터를 표현하고 교환하는 표준이다. XML 문서를 관계형 데이터베이스나 객체지향 데이터베이스에 바로 저장하기에는 적합하지 못하기 때문에, XML문서에서 DTD를 이용하여 관계형 데이터베이스 스키마를 추출하고, 저장하는 방법에 대한 연구가 활발히 진행되고 있다. 그러나 DTD는 타입이 제한되어있고, 확장의 어려움이 있기 때문에 XML 스키마를 이용하여 DTD의 단점을 보완하고, 관계형 데이터 베이스 스키마를 추출하여 저장할 수 있게 되었다. 본 논문에서는 XML 스키마를 관계형 스키마로 변환하는 기법을 제안하고 구현 결과를 보인다. 제안된 방법은 XML 스키마를 이용하므로, 타입의 확장성 및 유연성 등을 제공할 수 있다.

  • PDF