• Journal of Information Technology Applications and Management
• /
• v.17 no.3
• /
• pp.1-24
• /
• 2010

Most of enterprises depend on a data modeler during developing their management information systems. In formulating business requirements for information systems, they widely and naturally use the interview method between a data modeler and a field worker. But, the discrepancy between both parties would certainly cause information loss and distortion that lead to let the systems not faithful to real business works. To improve or avoid modeler-dependant data modeling process, many automated data design CASE tools have been introduced. However, since most of traditional CASE tools just support drawing works for conceptual data design, a data modeler could not generate an ERD faithful to real business works and a user could not use them without any knowledge on database. Although some CASE tools supported conceptual data design, they still required too much preliminary database knowledge for a user. Against these traditional CASE tools, we proposed a Requirement-Oriented Entity Relationship Model for automated data design tool, called ROERM. Based on Non-Stop Methodology, ROERM adopts inner systematic modules for complete and sound ERD that is faithful to real field works, where modules are composed of interaction modules with a user, rules of schema operations and sentence translations. In addition to structure design of ROERM, we also devise detailed algorithms and perform an experiment for a case study.

• The Journal of Information Technology and Database
• /
• v.6 no.2
• /
• pp.45-57
• /
• 1999

This paper makes an attempt to find a systematic portion of the database design process, especially using the Entity-Relationship(E-R) model. Basically, we consider three aspects as a systematic portion of the database design process. They are, the strategy that a designer selects to design an E-R diagram, designer's cognitive style, and the knowledge and preference of the database designer. An experiment has been carried out in order to verify the systematic relationship between above-mentioned three aspects and the E-R modeling performance. The target system is a professional baseball system. A normative E-R diagram was constructed based upon 48 E-R diagrams produced during the experiment. The ANOVA process has been used to analyze the results. It has been found that there exist significant differences in query-answering capacity and the completeness of the E-R model among design methods. Individual differences in cognitive styles has not been found to be significantly related to the modeling performance.

• Journal of the Korean Society for information Management
• /
• v.23 no.4 s.62
• /
• pp.5-15
• /
• 2006

The Functional Requirements for Bibliographic Records (FRBR) is a 'conceptual model of the bibliographic universe' developed by the International Federation of Library Associations and Institutions (IFLA). Although some studies have suggested improvements in FRBR, and others explore alternative approaches, less attention has been paid to analyzing the internal coherence and consistency of the FRBR view as presented not only in the FRBR entity-relationship model and text of the FRBR document, but also in the related explanations and presentations of FRBR expositors. Our investigations have noted some interesting discrepancies between the general FRBR approach as presented in various expository documents and the specific account presented in the FRBR ER model and the FRBR document. We see that in one case these discrepancies can be easily remedied by adding additional modeling constructs and assertions, but in another case (the supposed 'inheritance' of attributes across the Group 1 entities), there is a substantial difficulty in maintaining a consistent model. We discuss several alternative approaches to enhancing the expressiveness of FRBR in order remedy this problem. We note that none is entirely satisfactory.

• 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.

• Korean Journal of Construction Engineering and Management
• /
• v.5 no.4 s.20
• /
• pp.79-86
• /
• 2004

One of the most difficult tasks in pavement management information systems is establishing the links between performance measures of a structure and the design and construction inputs. In-situ pavement performance can be considered a response variable to many project input variables, such as design, construction, and traffic loading effects. If we are to fully understand the component of pavement performance and specify the inputs through design and construction specifications to achieve that performance we must develop quantitative relationship between input and response variables through a scientific, fully integrated Pavement Performance Analysis System (PPAS). Hence, the objective of this study is to design a database model required for developing an effective database template that will allow analysis of pavement performance measures based on design and construction information linked by location. In order to select the most appropriate database model, a conceptual database model (Entity Relationship Model) and dimensional model, which is believed to be the most effective modeling technique for data warehouse project, are designed and compared. It is believed that other state highway agencies could adopt the proposed design strategy for implementing a PPAS at the discretion of the state highway agencies.

• Journal of the Korea Society for Simulation
• /
• v.11 no.2
• /
• pp.55-66
• /
• 2002

VHDL has been. widely used in modeling and simulation of hardware designs. However, complex relationship between components of the designs makes the VHDL modeling problem very difficult. Furthermore, after the initial creation of VHDL models, they evolve into many versions over their lifetime. To cope with such difficulties, this paper proposes a new methodology for the management of VHDL models supporting versions. Its conceptual bases are system entity structure and relational database. Within the methodology, a family of hierarchical structures of a design is organized in the form of VHDL model structure. It is, in turn, represented in the form of relational tables. Once the model structure is built in such a way, a specific simulation model which meets design objective is pruned from the model structure. The details of VHDL codes are systematically synthesized by combining it with the primitive models in a model base. These algorithms are also defined in terms of relational algebraic operations.

• Journal of KIBIM
• /
• v.5 no.2
• /
• pp.46-54
• /
• 2015

Vision-based tracking has been proposed as a means to efficiently track a large number of construction resources operating in a congested site. In order to obtain 3D coordinates of an object, it is necessary to employ stereo-vision theories. Detecting and tracking of multiple objects require an entity matching process that finds corresponding pairs of detected entities across the two camera views. This paper proposes an efficient way of entity matching for tracking of construction workers. The proposed method basically uses epipolar geometry which represents the relationship between the two fixed cameras. Each pixel coordinate in a camera view is projected onto the other camera view as an epipolar line. The proposed method finds the matching pair of a worker entity by comparing the proximity of the all detected entities in the other view to the epipolar line. Experimental results demonstrate its suitability for automated entity matching for 3D vision-based tracking of construction workers.

• Journal of KIISE:Databases
• /
• v.32 no.2
• /
• pp.111-119
• /
• 2005

Electronic catalog contains ich semantics associated with products, and serves as a challenging practical domain for ontology application. Ontology is concerned with the nature and relations of being. It can play a crucial role in e-commerce as a formalization of e-Catalogs. Description Logics provide a theoretical core for most of the current ontology languages. In this paper, we present an ontological model of e-Catalogs in DL. We take an Extended Entity Relationship approach for conceptual modeling method, and present the fundamental set of modeling constructs and corresponding description language representation for each construct. Additional semantic knowledge can be represented directly in DL. Our modeling language stands within SHIQ(d) which is known reasonably practical with regard to its expressiveness and complexity. We illustrate sample scenarios to show how our approach may be utilized in modeling e-Catalogs, and also implement the scenarios through a DL inference tool to see the practical feasibility.

• Journal of Digital Convergence
• /
• v.11 no.11
• /
• pp.359-366
• /
• 2013

In this paper, we studied how the data obesity can affect in which the response speed of database gradually slows down. Our research is performed by analyzing how the game data infrastructure is well-formed. Although there are a variety of ways to evaluate to measure the level of infrastructure, we performed with real information system. We analyzed data obesity by comparing the entity-relationship models between the products of real game information system and newly modeled databases. We could find data obesity is over 60% among overall average of game information system. It shows that 45% higher than standard obesity which is 15%. In this paper, data redundancy rate after performing the procedure of the data modeling was 41% resulting in an improvement of 23% compared to 64% of an existing model.

• The Journal of Society for e-Business Studies
• /
• v.12 no.3
• /
• pp.97-106
• /
• 2007

A core technology that may realize the Semantic Web is Ontology. The OWL (Web Ontology Language) has been positioned as a standard language. It requires technical expertise to directly represent the domain knowledge in OWL. Based on our experience of analyzing the fundamental relationships of concepts in e-catalog domain, we have developed a visual product information modeler called PROMOD. The modeling editor makes it possible to automatically generate the OWL codes for the given product information. We employ an Extended Entity-Relationship for conceptual modeling, enriched with modeling elements specialized for the product domain. In this paper, we present our translation schemes from EER model to OWL codes, and how to design and implement the modeling editor. We also provide a scenario to demonstrate the usage of the editor in practice.