• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.11 no.5
• /
• pp.11-17
• /
• 2011

In this paper, we propose ER_Modeler, which is a logical database design tool based on entity-relationship model. ER_Modeler provides the entity-relationship diagrams to be built graphically on windows and generates the graphs into the appropriate data definition language for creating relational database tables. Furthermore, ER_Modeler provides the import/export functions using XML to guarantee the interoperability with ERwin which is one of the most popular commercial products.

• Journal of IKEEE
• /
• v.7 no.2 s.13
• /
• pp.144-155
• /
• 2003

In this paper, a conceptual data model, called the UDM(Unified Data Model), to efficiently represent database structures related with object technology and complex structured data, is proposed. This model integrates major features of modern data models, such as E-R model, Semantic Object Model, and UML, especially from the viewpoint of database design. This model is basically a simplified, but extended version of the Object-Relationship Model, which was proposed to model complex structures of temporal-spatial multimedia data. This model incorporates some of the important semantic and structural information of modern database applications and it is designed to support all of the major logical database models, including relational, object-relational, object-oriented, and (semi-)structured databases. A special diagrammatic technique, called the UDD(Unified Data Diagram), is introduced as a tool for database design. Also, possible ways to derive logical views of data from this unified data model are presented. The proposed model can be utilized as a convenient and practical tool for conceptual database designs.

• Journal of Information Technology Applications and Management
• /
• v.12 no.1
• /
• pp.35-48
• /
• 2005

An architectural framework is developed for integrating geospatial and temporal data with relational information from which a spatio-temporal data warehouse (STDW) system is built. In order to implement the STDW, a generic conceptual model was designed that accommodated six dimensions: spatial (map object), temporal (time), agent (contractor), management (e.g. planting) and tree species (specific species) that addressed the 'where', 'when', 'who', 'what', 'why' and 'how' (5W1H) of the STDW information, respectively. A formal algebraic notation was developed based on a triplet schema that corresponded with spatial, temporal, and relational data type objects. Spatial object structures and spatial operators (spatial selection, spatial projection, and spatial join) were defined and incorporated along with other database operators having interfaces via the generic model.

• The Transactions of the Korea Information Processing Society
• /
• v.3 no.1
• /
• pp.87-94
• /
• 1996

In order to design an extended relational database management system supporting multilevel security, the standard relational data model is extended and new relational integrity constrains are proposed for the model. The extended relational model and proposed multilevel integrity constraniants maintain database in consistent state and produce a basis that can eliminat eambiguity of entity and relation ship representations bypoly instantiation. The proposed up dates emantics canincreases the efficiency of up date operations by supporting multilevel entry and up dates. The semantics also provides a basis for the implementation of decomposition of extended relations.

• Journal of Distribution Science
• /
• v.13 no.5
• /
• pp.45-52
• /
• 2015

Purpose - Augmented reality (AR) content used in mobile media today can accommodate a wide variety of contextual information. This indicates that making people experience a sense of presence and flow is a very significant factor in augmented reality content. Flow represents a rich immersion potential as representing the progress of emotion and the means to facilitate the operation of the smart phone. Therefore, users will have friendly relational continuance behavior with products and brands that supply this experience. Based on that, the purpose of this study is to investigate the relationships among smart phone AR application traits, presence, flow experience, and relational continuance behavior. First, AR application traits are defined as three categories sensory immersion, navigation, and manipulation, based on preceding studies. This study then examines the influence of AR application traits on the presence and flow experience and looks into the relation among presence, flow experience, and relational continuance behavior. This analysis suggests more detailed and concentrated strategic implications. Research design, data, and methodology - A research model is designed to examine the relation among AR application traits, presence, flow experience, and relational continued behavior. For data collection, questionnaire surveys were composed of multi-items for each component and the direct interview method was used for the interviews. To collect the data, after running the smart phone AR applications, the consumer behaviors of the respondents were generally determined. The questionnaire surveys were conducted for one month, October 2014. A total of 300 questionnaires were distributed with 278 questionnaires used for analysis, excluding the unanswered and insincere questionnaires. The data were analyzed using SPSS ver. 20.0 and LISREL ver. 8.51. Results - The following results are found: First, AR application traits have a significantly positive effect on presence with sensory immersion, navigation, and manipulation all having a significantly positive effect. Second, sensory immersion and manipulation among the AR application traits have a significantly positive effect on flow. However, navigation did not have a significantly positive effect on flow. Third, presence has a significantly positive effect on flow and has a significantly positive effect on relational continuance behavior. Moreover, flow also has a significantly positive effect on relational continuance behavior. This behavior tends to be formed since brands want to encourage relational continuance behavior and positive emotions with the brands being used. Relational continuance behavior accompanies repeat purchasing, positive word-of-mouth and recommendation activities, and forms of trust with the brand. Conclusions - The research results showed that smart phone AR traits had significantly positive effect on presence, flow, and relational continuance behavior. Based on this, smart phone AR application providers should establish an aggressive marketing strategy to accommodate more realistic problems in order to positively influence user behavior. Additionally, the marketers should make efforts to provide fun or convenience in the AR application operation process of the user.

• The Transactions of the Korea Information Processing Society
• /
• v.4 no.1
• /
• pp.1-10
• /
• 1997

In this paper, for useful administration of the data which have ambiguities meaningfully and hard to treat, a new relation database model using an integrated fuzzy sets and rough sets relational database one. After proposing Fuzzy-rough relational database model on the base of integrated Fuzzy and Rough sets, Application of the examples of arithmetic is analyzed through the Access DBMS and the visual basic by composing and representing database based on fuzzy and rough sets which are characterized as fuzzy sets and rough sets on Pentium computer(166Mhz). This paper was induced to reduce the data incompleteness.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1999.10a
• /
• pp.444-451
• /
• 1999

The purpose of this study is to Propose data models for central database in integrated system for structural design building. In order to efficiently express data related to structure, I analyzed the structure design process and classified data considering design step. 1 used an object-oriented modeling methodology for logical data model and relational modeling for physical data model. Based on this model, we will develop an integration system with several applications for structure design. Each application will communicate through the central database.

• The Transactions of The Korean Institute of Electrical Engineers
• /
• v.65 no.3
• /
• pp.469-476
• /
• 2016

Relational Database Management Systems have become de facto database model among most developers and users since the inception of Data Science. From IoT devices, sensors, social media and other sources, data is generated in structured, semi-structured and unstructured formats, in huge volumes, thereby the difficulty of data management greatly increases. Organizations that collect large amounts of data are increasingly turning to non relational databases - NoSQL databases. In this paper, through experiments with real field data, we demonstrate that MongoDB, a document-based NoSQL database, is a better alternative for building a Telco Subscriber Data Management System which hitherto is mainly built with Relational Database Management Systems. We compare the existing system in various phases of data flow with our proposed system powered by MongoDB. We show how various workloads at some phases of the existing system were either completely removed or significantly simplified on the new system. Based on experiment results, using MongoDB for managing telco subscriber data turned out to offer performance better than the existing system built with MSSQL Server.

• Journal of Korea Multimedia Society
• /
• v.22 no.9
• /
• pp.1036-1045
• /
• 2019

Relational databases have a notion of normalization, in which the model for storing data is standardized according to the organization's business processes or data operations. However, the graph database is relatively early in this standardization and has a high degree of freedom in modeling. Therefore various models can be created with the same data, depending on the database designers. The essences of the graph database are two aspects. First, the graph database allows accessing relationships between the objects semantically. Second, it makes relationships between entities as important as individual data. Thus increasing the degree of freedom in modeling and providing the modeling developers with a more creative system. This paper introduces different graph models with test data. It compares the query performances by the results of response speeds to the query executions per graph model to find out how the efficiency of each model can be maximized.

• Journal of Distribution Science
• /
• v.19 no.5
• /
• pp.23-34
• /
• 2021

Purpose: This study identifies the critical elements of relationship management required to be studied in distribution sciences to create a relational bond of watch manufacturers with their retailers in India. The offline watch retail market is undergoing a rapid transformation due to technology intervention in the product portfolio and the advent of online retailing. The study identifies the interrelationships amongst the constructs of interdependence, trust, affective commitment, and information exchange to form long-lasting relational bonds in the watch industry. Research design, data and methodology: We used a path analysis to investigate the relationship between interdependence, trust, affective commitment, and information exchange. Data has been collected from 143 watch retailers using judgmental sampling method. Results: The data analysis suggested the establishment of measurement and structural model. The absolute and relative goodness of fit models in the causal analysis are 0.628 and 0.959 suggesting a sufficient fit index. Based on the analysis of direct and indirect effects, the results indicate that trust fully mediates the effect of interdependence and information exchange of retailers with the manufacturer. Conclusions: Trust plays an important role in driving commitment and information exchange between watch manufacturers and retailers. Interdependence in the manufacturer-channel relationships would lead to affective commitment only when trust exists in the relationship. [AMAWATE, Vibhas.] in Web of Science and Scopus).