• Title/Summary/Keyword: Relational Data Model

Search Result 336, Processing Time 0.024 seconds

A Conceptual Information Model of Mechanical Assemblies Incorporating Assembly and Kinematic Constraints, and Tolerances (조립 및 기구학 구속 조건, 공차를 포함하는 기계 조립체의 개념적 정보 모델)

  • Han Y,-H.
    • Korean Journal of Computational Design and Engineering
    • /
    • v.10 no.2
    • /
    • pp.133-142
    • /
    • 2005
  • This paper proposes an object-oriented conceptual information model of mechanical assemblies, named open assembly model (OAM). The proposed assembly model primarily defines hierarchical relationships between parts and subassemblies. Together with the assembly hierarchy. the model also provides a way to represent tolerances, kinematic information, and parametric assembly constraints. Relational information such as mating conditions and degree of freedom between parts and subassemblies is captured via assembly features and relationships thereof. The information model is described using class diagrams of the Unified Modeling Language (UML), and instance diagrams are used to exemplify the proposed information model. The conceptual model presented in this paper is an integrated information model for assembly representation, which could supply necessary information for tolerance analysis and synthesis, kinematic simulation, and assembly simulation. Such a conceptual information model plays an important role for the exchange of information between modeling, analysis and planning systems. Hence, the proposed model could serve as a framework for developing data exchange standards of mechanical assemblies. The proposed model is demonstrated through a case study of a planetary gear assembly.

Sales Control Systems and Behavioral Responses: Mediating Role of Regulatory Focus and Moderating Role of P-O Fit

  • Yoo, Jaewon
    • Asia Marketing Journal
    • /
    • v.17 no.1
    • /
    • pp.123-148
    • /
    • 2015
  • Built on regulatory focus theory, this article develops a research model proposing the relationship between management controls (outcome, activity and capability), sales employees' prevention and promotion focus and their behavioral responses (feedback seeking from different sources and relationship investment). The model also suggests that salesperson perceived organizational fit (P-O fit) contributes by influencing the situational self-regulatory mechanism based on regulatory fit theory. To analyze the data, a structural equation model procedure using LISREL 8.5 was employed. To access the potential common method bias, the MV" marker method was applied using a scale theoretically unrelated to at least one scale in the analysis as the MV marker. The results showed that the greater the salesperson's perceived activity control system, the greater the extent of employee prevention focus. The findings also showed that output control and capability control system are positively related to the promotion focus of salespeople. Salespeople's prevention focus relates negatively to the relational investment and positively to organization feedback seeking. The results indicate that salespeople who have promotion focus exhibit the predicted positive influence on their relationship investment. A significant contribution of this research framework is suggesting salesperson regulatory focus as a mediator and its' effects on different types of sales-related behaviors. The author suggests that the motivational orientations of salespeople play key roles in shaping feedback seeking behaviors from different sources; broadly, that employees with a promotion focus will be more sensitive to customers' feedback, and employees with a prevention focus will seek more feedback from the organization. Furthermore, salespeople with a promotion focus will invest more resources to build relationships with customers than salespeople with a prevention focus. This research also explains the moderating role of person-organization fit on the effect of salespeople's regulatory focus and behavioral responses based on regulatory fit theory

City Information Model-based Information Management of Flood Damages (도시정보모델의 침수피해정보관리에서의 활용)

  • Park, Sang Il;Kim, Min-Su;Kim, Jong Myung;Lee, Sang-Ho
    • Journal of the Computational Structural Engineering Institute of Korea
    • /
    • v.28 no.4
    • /
    • pp.385-392
    • /
    • 2015
  • Open city information model can increase the understanding of the situation, enable the effective reuse of information due to access the semantic and relational conditions of objects, and support the reliable decision-making through linking with external references. The city information model focused on terrain and buildings was implemented based on the actual data. In addition, a process for flooding simulation was proposed using hydraulic analysis data and the city information model. The deaths and damages were estimated by flooding simulation. The availabilities were examined by detailed queries and responses based on model data of the city information model, hydraulic analysis data and the estimated damages.

A Data Model for Past and Future Location Process of Moving Objects (이동 객체의 과거 및 미래 위치 연산을 위한 데이터 모델)

  • Jang, Seung-Youn;Ahn, Yoon-Ae;Ryu, Keun-Ho
    • The KIPS Transactions:PartD
    • /
    • v.10D no.1
    • /
    • pp.45-56
    • /
    • 2003
  • In the wireless environment, according to the development of technology, which is able to obtain location information of spatiotemporal moving object, the various application systems are developed such as vehicle tracking system, forest fire management system and digital battle field system. These application systems need the data model, which is able to represent and process the continuous change of moving object. However, if moving objects are expressed by a relational model, there is a problem which is not able to store all location information that changed per every time. Also, existing data models of moving object have a week point, which constrain the query time to the time that is managed in the database such as past or current and near future. Therefore, in this paper, we propose a data model, which is able to not only express the continuous movement of moving point and moving region but also process the operation at all query time by using shape-change process and location determination functions for past and future. In addition, we apply the proposed model to forest fire management system and evaluate the validity through the implementation result.

A study on the tool management system "TOOLMAN-I" of the NC lathe for CIM (CIM 지원을 위한 선반 공구관리 시스템 "TOOLMAN-I"에 관한 연구)

  • 이재원;이용표;김광만
    • Transactions of the Korean Society of Mechanical Engineers
    • /
    • v.12 no.5
    • /
    • pp.1092-1096
    • /
    • 1988
  • This paper presents a research on the development of a system which manages be tool data for the factory using NC machines. The tool information concerning each production stages of the industry is studied in the CIM(Computer Integrated Manufacturing) view point. The system gives the characteristics of the easy and reliable processing of the tool data by the help of menu and graphic functions. The DBMS(Data Base Management System) having relational model is used for the system build-up and is interfaced with CAD system for display of the tool geometry.

A study on the development of a web-based cost management system of building interior projects (웹을 기반으로 한 실내건축공사의 원가관리 시스템 개발에 관한 연구)

  • 송영규
    • Korean Institute of Interior Design Journal
    • /
    • v.13 no.3
    • /
    • pp.197-204
    • /
    • 2004
  • This study aims at the development of a cost management system in building interior projects. Renovation and remodeling is activated and expanded much more being compared with new building construction at present. After Interior project proceeding must get out of simple estimate and assumption, then its be needed a formal work process and computerized cost management. Proceeding a building interior project management was proceed in the office and the field. Cost break down, especially, depend on the field manger and used fiend managing money because its not checked by cost manager in office manger. For this study, cost factors are defined in terms of cost break-down interior works which consist of materials and labors. A data model for cost factors was developed, and a relational database is used to realize cost data management based upon this data model. Data input and output are achieved by internet from both of wired PC and mobile phone. This system can timely display a number of needed reports for cost management that identifies cash flow and predicts budget for cost break-down works in interior projects.

A Meta-Model for the Storage of XML Schema using Model-Mapping Approach (모델 매핑 접근법을 이용한 XML 스키마 저장 메타모델에 대한 연구)

  • Lim, Hoon-Tae;Lim, Tae-Soo;Hong, Keun-Hee;Kang, Suk-Ho
    • IE interfaces
    • /
    • v.17 no.3
    • /
    • pp.330-337
    • /
    • 2004
  • Since XML (eXtensible Markup Language) was highlighted as an information interchange format, there is an increasing demand for incorporating XML with databases. Most of the approaches are focused on RDB (Relational Databases) because of legacy systems. But these approaches depend on the database system. Countless researches are being focused on DTD (Document Type Definition). However XML Schema is more comprehensive and efficient in many perspectives. We propose a meta-model for XML Schema that is independent of the database. There are three processes to build our meta-model: DOM (Document Object Model) tree analysis, object modeling and storing object into a fixed DB schema using model mapping approach. We propose four mapping rules for object modeling, which conform to the ODMG (Object Data Management Group) 3.0 standard. We expect that the model will be especially useful in building XML-based e-business applications.

The Establishment of an Activity-Based EVM - PMIS Integration Model (액티비티 기반의 EVM - PMIS 통합모델 구축)

  • Na, Kwang-Tae;Kang, Byeung-Hee
    • Journal of the Korea Institute of Building Construction
    • /
    • v.10 no.1
    • /
    • pp.199-212
    • /
    • 2010
  • To establish an infrastructure for technology and information in the domestic construction industry, several construction regulations pertaining to construction information have been institutionalized. However, there are major problems with the domestic information classification system, earned value management (EVM) and project management information system (PMIS). In particular, the functions of the current PMIS have consisted of a builder-oriented system, and as EVM is not applied to PMIS, the functions of reporting, analysis and forecast for owners are lacking. Moreover, owners cannot confirm information on construction schedule and cost in real time due to the differences between the EVM and PMIS operation systems. The purpose of this study is to provide a framework that is capable of operating PMIS efficiently under an e-business environment, by providing a proposal on how to establish a work breakdown structure (WBS) and an EVM - PMIS integration model, so that PMIS may provide the function of EVM, and stakeholders may have all information in common. At the core of EVM - PMIS integration is the idea that EVM and PMIS have the same operation system, in order to be an activity-based system. The principle of the integration is data integration, in which the information field of an activity is connected with the field of a relational database table consisting of sub-modules for the schedule and cost management function of PMIS using a relational database management system. Therefore, the planned value (PV), cost value (CV), actual cost (AC), schedule variance (SV), schedule performance index (SPI), cost variance (CV) and cost performance index (CPI) of an activity are connected with the field of the relational database table for the schedule and cost sub-modules of PMIS.

Big Data Model for Analyzing Plant Growth Environment Informations and Biometric Informations (농작물 생육환경정보와 생체정보 분석을 위한 빅데이터 모델)

  • Lee, JongYeol;Moon, ChangBae;Kim, ByeongMan
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.25 no.6
    • /
    • pp.15-23
    • /
    • 2020
  • While research activities in the agricultural field for climate change are being actively carried out, smart agriculture using information and communication technology has become a new trend in line with the Fourth Industrial Revolution. Accordingly, research is being conducted to identify and respond to signs of abnormal growth in advance by monitoring the stress of crops in various outdoor environments and soil conditions. There are also attempts to analyze data collected in real time through various sensors using artificial intelligence techniques or big data technologies. In this paper, we propose a big data model that is effective in analyzing the growth environment informations and biometric information of crops by using the existing relational database for big data analysis. The performance of the model was measured by the response time to a query according to the amount of data. As a result, it was confirmed that there is a maximum time reduction effect of 23.8%.

A Data Model for XML

  • LEE, Dae-Woo;CHOI, Ok;KIM, Young-Chan
    • Proceedings of the Korea Society of Information Technology Applications Conference
    • /
    • 2001.11a
    • /
    • pp.169-171
    • /
    • 2001
  • 본 논문에서는 XML(eXtensible Markup Language)을 위한 데이터 모델을 제시하기 위해 현재 광범위하게 사용되고 있는 관계형 데이터베이스(relational database) 개념을 적용한다. 관계형 데이터베이스는 업무 요구사항의 분석으로부터 고수준의 개념적 데이터 모델을 사용해서 데이터베이스에 대한 개념적 스키마(conceptual schema)를 생성한 다음, 고수준 개념적 데이터 모델을 구현 데이터 모델로 변환하여 논리적 데이터베이스 스키마를 생성한다. 이때, 고수준 개념적 데이터 모델링의 대표적인 방법으로 ER모델을 사용하고, 구현 데이터 모델로 관계 모델(relation model)을 사용한다. XML은 문서의 논리적 구조를 정의하는 DTD와 XML Schema 등을 갖는다. XML의 DTD와 정보 모델링 기법인 E/R 모델은 모두 작은 세계(real world)를 모델링하는 도구들이라고 할 수 있다. 본 논문에서는 XML의 DTD와 E/R 모델의 구성요소들을 분석하여 서로 사상(mapping)시키는 'XML을 위한 데이터 모델(A Data Model for XML)'을 제시한다. 최종적으로 제시된 XML을 위한 데이터 모델에 의해 작은 세계(real world)을 모델링하는 XML DTD에서 정의한 구조(XML Structure)을 따르는 유효한 XML문서(validate XML document)들은 관계형 데이터베이스에 저장할 수 있게 된다.

  • PDF