• Title/Summary/Keyword: Relational Data Model

Search Result 336, Processing Time 0.026 seconds

A XML Instance Repository Model based on the Edge-Labeled Graph (Edge-Labeled 그래프 기반의 XML 인스턴스 저장 모델)

  • Kim Jeong-Hee;Kwak Ho-Young
    • Journal of Internet Computing and Services
    • /
    • v.4 no.6
    • /
    • pp.33-42
    • /
    • 2003
  • A XML Instance repository model based on the Edge-Labeled Graph is suggested for storing the XML instance in Relational Databases, This repository model represents the XML instance as a data graph based on the Edge-Labeled Graph, extracts the defined value based on the structure of data path, element, attribute, and table index table presented as database schema, and stores these values using the Mapper module, In order to support querry, XML repository model offers the module translating XQL which is a query language under XPATH to SQL, and has DBtoXML generator module restoring the stored XML instance. As a result, it is possible to represent the storage relationship between the XML instances and the proposed repository model in terms of Graph-based Path, and it shows the possibility of easy search of specific element and attribute information.

  • PDF

A System Model for Storage Independent Use of SPARQL-to-SQL Translation Algorithm (SPARQL-to-SQL 변환 알고리즘의 저장소 독립적 활용을 위한 시스템 모델)

  • Son, Ji-Seong;Jeong, Dong-Won;Baik, Doo-Kwon
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.14 no.5
    • /
    • pp.467-471
    • /
    • 2008
  • With active research on Web ontology, various storages and query languages have been developed to store Web Ontology. As SPARQL usage increases and most of storages are based on relational data base, the necessity of SPARQL-to-SQL translation algorithm development becomes issued. Even though several translation algorithms have been proposed, there still remain the following problems. They do not support fully SPARQL clauses and they are dependent on a specific storage model. This paper proposes a new model to use a specific translation algorithm independently on storages.

ON THE PROPERTIES OF POSITIVE BOOLEAN DEPENDENCIES BY GROUPS IN THE DATABASE MODEL OF BLOCK FORM

  • TRUC, TRINH NGOC;THANG, TRINH DINH;TUYEN, TRAN MINH
    • Journal of applied mathematics & informatics
    • /
    • v.40 no.3_4
    • /
    • pp.531-543
    • /
    • 2022
  • The article proposed a new type of data relationship: Positive Boolean dependencies by groups on block and slice in the database model of block form, where instead of considering value pairs, we consider a group of p values (p ≥ 2). From this new concept, the article stated and demonstrated the equivalence of the three types of deduction, namely: deduction by logic, deduction by block with groups, deduction by block has no more than p elements with groups. Operations on blocks or slices performed for index attributes on blocks, the properties related to this new concept as theorem the equivalen of the three types of deduction, closure of set positive Boolean dependencies by groups and representation and tight representation set of positive Boolean dependencies by groups when the block degenerated into relation are true in the relational database model and also stated and proven in this paper.

Effects of usage motivation for omni-channel services on continuance and affective commitment and brand purchase intention (옴니채널 서비스 이용 동기가 지속적 몰입과 정서적 몰입 및 브랜드 구매의도에 미치는 영향)

  • Choi, Mi Young
    • The Research Journal of the Costume Culture
    • /
    • v.27 no.6
    • /
    • pp.553-568
    • /
    • 2019
  • This study examined motivation to use omni-channel services on mobile devices in fashion stores and the effects of such usage motivation on brand purchase intention through continuous and affective commitment. Data were collected on consumers in their 20s and 30s who experienced omni-channel services during shopping for or purchasing fashion products. An online survey asked 413 consumers to rate their brand purchase intention. Sub-levels of each variable were examined using SPSS 25.0, followed by confirmatory factor analysis using AMOS 19.0. In addition, path analysis using structural equation modeling was applied to analyze associations between variables. The statistical results were mixed. First, only two dimensions of usage motivation for omni-channel services, hedonic and relational motivation, had positive effects on continuous and affective commitment. Second, continuous commitment had a greater effect on purchase intention of brands that provided omni-channel services than it did on affective commitment. Third, of the dimensions of usage motivation, utilitarian motivation had a direct influence on purchase intention in the modified model, while social motivation did not affect service commitment and purchase intention. Finally, our findings suggest that brand loyalty can be built by encouraging service commitments through hedonic and relational motivation, based on the usability of omni-channel services.

The Effect Factors on the Purchase Intension of Smart Car as of High Innovative Technology and Product; Consumer's Individual Attributes, Perceived Benefit and Switching Cost

  • Ahn, Yeon S.
    • Journal of the Korea Society of Computer and Information
    • /
    • v.21 no.9
    • /
    • pp.113-119
    • /
    • 2016
  • In this paper, a research model is proved empirically which includes factors related on the purchase intention of smart car as high innovative product in advance of commercialization. As one of relating to consumer's expectation benefit factors, individual attribute factor includes product knowledge, individual innovativeness, and sociality. Consumer's expectation benefit factor includes perceived ease-of-use, usefulness, and enjoyment. As of switching cost variables, there are financial, uncertainty, relational and psychological switching costs factors. Analysis were performed using data from the 257 respondents as random sampling among potential consumers. Purchase intention were affected by individual innovativeness mediated by perceived enjoyment, and individual sociality by perceived ease-of-use and enjoyment also. Relational switching costs factor was only a significant control variable between purchase intention with consumer's expectation benefit factor. This result presents some implications for making the new smart car's detail concept and marketing strategy related to targeting the consumer as high innovative product and technology firms including smart car makers.

An Attribute Replicating Vertical Partition Method by Genetic Algorithm in the Physical Design of Relational Database (관계형 데이터베이스의 물리적 설계에서 유전해법을 이용한 속성 중복 수직분할 방법)

  • 유종찬;김재련
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.21 no.46
    • /
    • pp.33-49
    • /
    • 1998
  • In order to improve the performance of relational databases, one has to reduce the number of disk accesses necessary to transfer data from disk to main memory. The paper proposes to reduce the number of disk I/O accesses by vertically partitioning relation into fragments and allowing attribute replication to fragments if necessary. When zero-one integer programming model is solved by the branch-and-bound method, it requires much computing time to solve a large sized problem. Therefore, heuristic solutions using genetic algorithm(GA) are presented. GA in this paper adapts a few ideas which are different from traditional genetic algorithms, for examples, a rank-based sharing fitness function, elitism and so on. In order to improve performance of GA, a set of optimal parameter levels is determined by the experiment and makes use of it. As relations are vertically partitioned allowing attribute replications and saved in disk, an attribute replicating vertical partition method by GA can attain less access cost than non-attribute-replication one and require less computing time than the branch-and-bound method in large-sized problems. Also, it can acquire a good solution similar to the optimum solution in small-sized problem.

  • PDF

Design and Implementation of Sensor Registry Data Model for IoT Environment (IoT 환경을 위한 센서 레지스트리 데이터 모델의 설계 및 구현)

  • Lee, Sukhoon;Jeong, Dongwon;Jung, Hyunjun;Baik, Doo-Kwon
    • KIPS Transactions on Software and Data Engineering
    • /
    • v.5 no.5
    • /
    • pp.221-230
    • /
    • 2016
  • With emerging the Internet of Things (IoT) paradigm, the sensor network and sensor platform technologies have been changed according to exploding amount of sensors. Sensor Registry System (SRS) as a sensor platform is a system that registers and manages sensor metadata for consistent semantic interpretation in heterogeneous sensor networks. However, the SRS is unsuitable for the IoT environment. Therefore, this paper proposes sensor registry data model to register and manager sensor information in the IoT environment. We analyze Semantic Sensor Network Ontology (SSNO) for improving the existed SRS, and design metamodel based on the analysis result. We also build tables in a relational database using the designed metamodel, then implement SRS as a web application. This paper applies the SSNO and sensor ontology examples with translating into the proposed model in order to verify the suitability of the proposed sensor registry data model. As the evaluation result, the proposed model shows abundant expression of semantics by comparison with existed models.

Proposal for Semantic Digital Archive for UNESCO Intangible Cultural Heritage Sites List: Centering on User-Centric Relational Facet Navigation (유네스코 무형문화유산 시맨틱 디지털 아카이브 구축: 이용자 중심 관계형 패싯 네비게이션을 중심으로)

  • Park, Sun-hee
    • Journal of Korean Society of Archives and Records Management
    • /
    • v.19 no.4
    • /
    • pp.63-86
    • /
    • 2019
  • UNESCO clearly has a good user interface compared to other sites. However, it does not have a structure in which user-centric knowledge curating is employed by users. As such, the knowledge structure should be expressed differently in advance for users to enjoy such benefits. At present, almost all current information systems are lacking with semantic and contextual information. Moreover, these systems are deemed insufficient of interlinking various kinds of thoughts in our minds. Thus, it is necessary to model in advance what users are likely to think and provide an interface that they can easily utilize based on that modeling. Furthermore, there is a need for a new structural theory based on semantic technology that can make that possible. Therefore, in this proposal, theoretical and practical insights were presented for user interface implementation to which relational facet navigation based on the structural theory is applied. Moreover, this proposal intends to suggest a "thinking expansion platform" that allows users' ideation of different concepts, including those unfamiliar to them.

The Impact of Digital Strategies on Corporate Performance: Focusing on Relational Behavior Dimensions, Cognitive Dimensions and Sustaining Digital Transformation (디지털 전략이 기업성과에 미치는 영향: 관계적 행동차원, 인지차원 및 지속적인 디지털 전환을 중심으로)

  • Hyun-Ah Yang;Young-Wook Seo
    • Industry Promotion Research
    • /
    • v.9 no.3
    • /
    • pp.41-55
    • /
    • 2024
  • This study analyzes the impact of digital strategy on firm performance through relational behavior, cognitive dimensions, and continuous digital transformation based on social capital theory. The research model was tested using data collected from a survey of 300 domestic corporate employees who have worked for over a year, conducted from February 20 to 23, 2024, using Smart PLS 4.0. The key findings of the study are as follows: First, it was confirmed that digital strategy plays a crucial role in promoting cooperation and interaction within the organization, enhancing members' understanding and perception of digital technology, and strengthening the firm's competitiveness through continuous change and innovation. Second, continuous digital transformation and cognitive dimensions positively impact firm performance, while the influence of relational behavior dimensions was found to be insignificant. These findings suggest that digital strategy can significantly affect firm performance by fostering interaction and perception changes within the organization, beyond mere technology adoption, and provide strategic implications for Korean firms to effectively pursue digital transformation.

A Graph Model of Heterogeneous IoT Data Representation : A Case Study from Smart Campus Management (이종 IoT 데이터 표현을 위한 그래프 모델: 스마트 캠퍼스 관리 사례 연구)

  • Nguyen, Van-Quyet;Nguyen, Huu-Duy;Nguyen, Giang-Truong;Kim, Kyungbaek
    • Annual Conference of KIPS
    • /
    • 2018.10a
    • /
    • pp.984-987
    • /
    • 2018
  • In an Internet of Thing (IoT) environment, entities with different attributes and capacities are going to be connected in a highly connected fashion. Specifically, not only the mechanical and electronic devices but also other entities such as people, locations and applications are connected to each other. Understanding and managing these connections play an important role for businesses, which identify opportunities for new IoT services. Traditional approach for storing and querying IoT data is used of a relational database management system (RDMS) such as MySQL or MSSQL. However, using RDMS is not flexible and sufficient for handling heterogeneous IoT data because these data have deeply complex relationships which require nested queries and complex joins on multiple tables. In this paper, we propose a graph model for constructing a graph database of heterogeneous IoT data. Graph databases are purposely-built to store highly connected data with nodes representing entities and edges representing the relationships between these entities. Our model fuses social graph, spatial graph, and things graph, and incorporates the relationships among them. We then present a case study which applies our model for representing data from a Smart Campus using Neo4J platform. Through the results of querying to answer real questions in Smart Campus management, we show the viability of our model.