• Title/Summary/Keyword: Entity-Relationship model

Search Result 96, Processing Time 0.03 seconds

Extracting Entity-Relationship Schema Using Form Model in Relational Database Systems (관계 데이터베이스 시스템에서 Form Model을 이용한 개체-관계 스키마의 추출)

  • 김미화;황태희;배석찬
    • Proceedings of the Korea Society for Industrial Systems Conference
    • /
    • 2000.11a
    • /
    • pp.425-429
    • /
    • 2000
  • 데이터 모델링 접근은 주로 순 공학을 사용하여 미래의 필요구조에 초점을 맞추고 있기 때문에 새로운 데이터베이스를 설계하기 위해서는 많은 시간과 노력, 개발비가 필요하다. 그러나 기존의 데이터베이스를 재사용 한다면 개발에 필요한 시간과 노력, 개발비를 줄일 수 있을 뿐 아니라 자료의 재활용면에서 효율적이다. 본 논문에서는 사용 가능한 데이터베이스 application을 재사용하기 위해 Form model을 이용하여 새로운 데이터베이스 설계의 바탕이 되는 개체-관계 스키마를 추출하는 방법에 대해 연구하였다.

  • PDF

Data Modeling for Cell-Signaling Pathway Database (세포 신호전달 경로 데이타베이스를 위한 데이타 모델링)

  • 박지숙;백은옥;이공주;이상혁;이승록;양갑석
    • Journal of KIISE:Databases
    • /
    • v.30 no.6
    • /
    • pp.573-584
    • /
    • 2003
  • Recent massive data generation by genomics and proteomics requires bioinformatic tools to extract the biological meaning from the massive results. Here we introduce ROSPath, a database system to deal with information on reactive oxygen species (ROS)-mediated cell signaling pathways. It provides a structured repository for handling pathway related data and tools for querying, displaying, and analyzing pathways. ROSPath data model provides the extensibility for representing incomplete knowledge and the accessibility for linking the existing biochemical databases via the Internet. For flexibility and efficient retrieval, hierarchically structured data model is defined by using the object-oriented model. There are two major data types in ROSPath data model: ‘bio entity’ and ‘interaction’. Bio entity represents a single biochemical entity: a protein or protein state involved in ROS cell-signaling pathways. Interaction, characterized by a list of inputs and outputs, describes various types of relationship among bio entities. Typical interactions are protein state transitions, chemical reactions, and protein-protein interactions. A complex network can be constructed from ROSPath data model and thus provides a foundation for describing and analyzing various biochemical processes.

Banco do Brasil - Individual Entity Customer Satisfaction with the Digital Relationship Model

  • Mattana, Fabiano;Maldaner, Luis Felipe;Vaccaro, Guilherme Luis Roeche;Mattana, Luciano
    • World Technopolis Review
    • /
    • v.8 no.2
    • /
    • pp.120-134
    • /
    • 2019
  • The main objective of this study was to investigate the customer's satisfaction level with the digital relationship model of Banco do Brasil Exclusive Business Offices situated in Rio Grande do Sul. Banco do Brasil is one of the largest Brazilian and global financial institutions and conducted a restructuring customer's relationship model since 2015, creating new specific service structures for certain segments, among them exclusive offices. This research had a qualitative step with an internal documentary analysis about the company and a semi-structured interview with manager's offices, in order to check the strategy and the foundations of business model, as well as identify perceptions and the difficulties in implementing this new structure. The quantitative step held the findings about customer satisfaction level in relation to the quality of services provided by offices, through an electronic survey based on the Servqual Scale developed by Parasuraman et al. (1988), which measures the difference between customer's expectations and perception in five dimensions: tangibility, reliability, understanding, safety and empathy. The results shown that Banco do Brasil customers' are satisfied with services offered through the digital model and the new business structure, in which is offered a humanized service together with the best technology. It was found, also, that digital probably would not replace the physical world, but they complement one another. Digital offices and physical agencies will coexist, improving value proposition delivery and better customers experience, satisfy them and build their loyalty.

A Study on the Predicted Model of the Relationship Between Financial Information and Market Beta (재무정보와 베타예측모델에 관한 연구)

  • 신창섭
    • The Journal of Information Technology
    • /
    • v.1 no.2
    • /
    • pp.25-37
    • /
    • 1998
  • The paper discusses several means for estimating appropriating discount rates to value non-traded assets. That Is, this study discusses the relationship between market equity beta and observable finance information. The relationship can in principle be used to determine betas for non-traded entity for which conventional market model or pure-play techniques are impractical. In addition, the paper shows on model researched by Patterson in 1993. Patterson's research investigates the cross-sectional relationship market beta and accounting beta in Canadian capital market.

  • PDF

Conceptual Data Modeling and Information Retrieval System Design (개념적 데이터 모델링과 정보검색 시스템 디자인)

  • Oh Sam-Gyun
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.33 no.4
    • /
    • pp.133-156
    • /
    • 1999
  • The purpose of this paper is to show how conceptual data modeling can enhance current information retrieval (IR) systems. The conceptual database design provides for: 1) data mining capability to discover new knowledge based on the relationships between entities, and 2) integrating current separate databases into one IR system (e.g., integrating ISI Citation, a thesaurus, and bibliographic databases into one retrieval system) . Further, as new user requirements are unfolded, modifications of IR systems based on conceptual data modeling will be much easier to make than they were in the current IR systems because conceptual modeling facilitates flexible modifications. The enhanced Entity-Relationship (ER) model was employed in this study to develop conceptual schemas of IR data.

  • PDF

A study on Multiple Entity Data Model Design for Visual-Arts Archives and Information Management in the case of the KS X ISO 23081 Multiple Entity Model (시각예술기록정보 관리를 위한 데이터모델 설계 KS X ISO 23081 다중 엔티티 모델의 적용을 중심으로)

  • Hwang, Jin-hyun;Yim, Jin-hee
    • The Korean Journal of Archival Studies
    • /
    • no.33
    • /
    • pp.155-206
    • /
    • 2012
  • Interests in archives management are getting expanded from the public sector into the cultural and artistic field for the ten years after legislation of "Act on the Management of Public Archives" in 1999. However, due to lack of recognition on the importance of archives in the cultural and artistic field, it is rather frequent that information is kept scattered or archives are lost. As an example, absence of precise contract documents or notes of bestowal keeps people from locating great amount of cultural properties, and because of it these creative properties are in the risk of thefts, the closed-door auctioning, or trades in unofficial channels. As how a nation manages cultural and artistic creation inside the nation reflects its cultural level, it can be said that one of the indexes to notice the extent of a nation's cultural level is to take a look at how they are circulated. This study started from this point. Growing economy and rising interests in culture and art made the society more cognizant of the importance and value that visual artworks have, but the archives and information which are showing the context of these artworks and are produced in the course of social interaction are relatively disregarded because too much emphasis lies on the work itself. It is harder to find archives or documentations in Korea than in other advanced countries about the artists themselves or philosophical discourse on the background of the artworks. There is not so much interest to preserve the archives and information produced after the exhibition also, and they are used for no more than promotion or reference. Hereupon, the researcher recognized the importance of visual arts archives and believed that systemic management on them are high in need. And metadata is an essential way for the systemic management, as recently management on artworks or their archives are conducted using the system of the agencies even though they are not produced electronically. The objective of this study is to manage visual arts archives systematically by designing a data model reflecting traits of visual arts archives. Metadata are needed in the every course of archives from acquisition to management, preservation and application. Visual arts archives find its rich value only when a systemic relationship is established among information on artist, artwork and events including exhibition. By establishing a Multiple Entity Data Model, in which artworks, artists and events (exhibitions) make relationship all together, metadata for management on visual arts archive gets more efficiency and at the same time explanatory trait of the archive gets higher. For this reason we, in the study, tried to design a data model by setting each as an independent entities and designating relations between them, in order to find a way to manage visual arts archives more systematically.

A Study on the Organizational Politics and Turnover Intention by Position in the Mergers and Acquisitions (M&A 과정에서 직급별로 인지하는 조직정치와 이직 의도에 관한 연구)

  • Jung, Byoungho;Lee, Jaejin
    • Journal of Korea Society of Digital Industry and Information Management
    • /
    • v.17 no.3
    • /
    • pp.105-119
    • /
    • 2021
  • The purpose of this study is to examine the organizational politics, resistance change, turnover intention, and organizational commitment of organizational members during mergers and acquisitions. Recently, many companies are interested in mergers and acquisitions for business diversification and market extension. A merger is a legal consolidation of two entities into one, whereas an acquisition occurs when one entity takes ownership of another entity's stock, equity interests, or assets. This research model establishes a structural equation model. This model is set in a causal relationship between manager's organizational politics, peer organizational politics, and change resistance and the change resistance has a causal relationship of turnover and tissue immersion. In particular, this study will test different of organizational politics by position. Research results, the organizational politics of managers and colleagues have shown increasing change resistance. The change resistance has resulted in a reduction of organizational commitment and an increase of turnover intention. Next, the position analysis showed that top management level, middle management level, and working-level officials showed different organizational politics. The working-level officials are influenced by their manager politics and are influenced in organizational commitment and turnover intention by change resistance. The middle manager level is influenced by the organizational politics of bosses and colleagues, and organizational commitment is weakened by change resistance. The CEO level is not affected by organizational politics in the company, but the turnover intention is strengthened and the organizational commitment is weakened by the change resistance. This study has contributed to further updating the theory of organizational politics based on mergers and acquisitions. As a practical implication, we suggest an organizational integration strategy for a new organization.

A Methodology for Deriving An Object Model by Using Structured Analysis Results (구조적 분석 산출물을 이용한 객체 모델 유도 방법론)

  • 이희석;배한욱;유천수
    • Journal of the Korean Operations Research and Management Science Society
    • /
    • v.21 no.3
    • /
    • pp.175-195
    • /
    • 1996
  • In conventional analysis methods, data and process are loosely coupled for building information systems. Several object oriented approaches have been proposed to integrate data and process. However, object oriented analysis requires a radical paradigm and thus system analysts find difficulties in generating object models direcctly from end users. To alleviate these difficulties, this paper proposes a methodology for deriving an object model by using structured analysis results. Objects are obtianed primarily from entities in Entity-Relationship Diagram. Methods are obtained through the analysis of the relationship between processes and data stores in Data Flow Diagram Methods are assigned to the objects by using object/process matrices. A real-life case is illustrated to demonstrate the usefulness of the methodology.

  • PDF

A Database Model for Financial Feasibility Study of Buildings Offered for Sale (분양형 건축물의 재무적 타당성검토를 위한 데이터베이스 모델)

  • Oh Hyun-Suk;Jung Jae-Gwan;Koo Kyo-Jin;Hyun Chang-Taek
    • Proceedings of the Korean Institute Of Construction Engineering and Management
    • /
    • autumn
    • /
    • pp.577-580
    • /
    • 2003
  • The purpose of this study was to make a database model for financial feasibility study of buildings offered for sale which is helpful for improvement of business ability in construction and confidence of a project from a related participant. At first, we studied several thesis and met some professionalist which work for construction and did a first survey for examining latest situation of a feasibility study in construction. As a result, even though feasibility study is important, factors for information management wasn't systemized. So we did a second survey for fixing Factors of the database model. The database model was composed of the factors that we got from the second survey. ER(Entity-Relationship) analysis was used to making it. We expect thar we can get more reasonable information to study financial feasibility study and can diminish risks of project through the database model. So the result of this study was to make a database model for more reasonable financial feasibility study of building offered for sale.

  • PDF

ERD Representation using Auto-Generated Form and SQL (자동 생성 폼과 SQL을 이용한 ERD 표현)

  • Ra, Young-Gook
    • The Journal of the Korea Contents Association
    • /
    • v.9 no.5
    • /
    • pp.61-75
    • /
    • 2009
  • Generally, the development of the database application includes the requirement analysis phase of creating ERD (Entity Relationship Diagram) and process models, coding, and testing. From the above phases, the analysis phase is not most formalized. It is usually hard task because (1) customers don't know the details of the desired system; (2) developers can't with ease understand the business logic of the customers; (3) the outcomes of the analysis, which are ERD and process models, are not easy to understand to the customers. This paper propose that the executional forms, which are better to understand the systems, should be presented to the customers instead of the ERD. These forms should accept the data input so that customers can review the various aspects of the outcome models. The developers should be able to instantly implement the business logic and also should be able to visually demonstrate the logic in order to get the details of it. For this goal, the customer supplied business logic should be able to be implemented by the references between forms, actions, constraints from the perspective of the data flow. The customers try to execute the forms implementing the business logic and review their supplied logic find new necessary business logic of their own. Iterating these processes for the requirement analysis would result in the success of the analysis which is sufficiently detailed without conflicts.