• Title/Summary/Keyword: relational model

Search Result 564, Processing Time 0.033 seconds

The Moderating Effects of Organizational Characteristics on the Relationship between Relational Characteristics and Performance in ASP Services (조직특성과 관계교환특성이 ASP 서비스 성과에 미치는 상호작용효과 분석)

  • Chung, Young-Soo;Jung, Chul-Ho
    • Journal of Information Technology Applications and Management
    • /
    • v.13 no.4
    • /
    • pp.13-39
    • /
    • 2006
  • The primary purpose of this study is to examine the interaction effects of organizational characteristics as contextual variables on the relationship between relational exchange characteristics and ASP service performance. The effect of relational exchange characteristics on ASP service performance has been also investigated. For this purposes, we developed a research model based on the literature reviews of ASP services, relational exchange theory, and contingency theory. A total of 106 usable survey responses from companies using ASP services has been analyzed in the study. The findings indicate that (1) flexibility and partnership had a positive influence upon noneconomic profit, (2) information sharing had a positive influence upon economic profit, (3) organizational size and IS maturity had a partial moderating effect on the relationship between relational exchange characteristics and ASP service performance, and (4) the subgroup analysis, conducted to determine the exact nature of interaction effect, reveals that the relationship between relational exchange characteristics and noneconomic profit is significantly stronger with a high level of organizational size than with a low level, and that the relationship between relational exchange characteristics and economic profit is significantly stronger with a low level of IS maturity than with a high level.

  • PDF

UML Extension for Object-Relational Database Design - Focusing on Oracle11g - (객체-관계형 데이터베이스 설계를 위한 UML 확장 - Oracle11g를 중심으로 -)

  • Joo, Kyung-Soo;Jho, Do-Hyung
    • Journal of Internet Computing and Services
    • /
    • v.12 no.6
    • /
    • pp.149-159
    • /
    • 2011
  • The current applications can be characterized as consisting of complex objects related by complex relationship. Therefore the relational database has been extended to object-relational database because of the complex objects. Accordingly, we need database design methodology for object-relational database. In this pager, we develop an integrated design methodology based on a extended UML class diagram for object-relational database. We make the extend UML class diagram by adding new stereotypes for object-relational database. Also we propose a guideline for transforming the extended UML class diagram to object-relational database schema. We use SQL:1999 as a object-relational data model and Oracle11g as a target object-relational database. We can build more easily and efficiently object-relational database for Oracle11g by using our methodology. Finally we applied our methodology on a computer classroom reservation system for evaluation the methodology.

The Operational Semantics of Extended Relations for Multilevel Security (다단계 보안을 위한 확장 릴레이션의 운영 의미론)

  • Cho, Wan-Soo;Bae, Hae-Young
    • 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.

  • PDF

A Query Processing Model based on the XML View in Relational Databases (관계형 데이터베이스에서 XML 뷰 기반의 질의 처리 모델)

  • Jung, Chai-Young;Choi, Kyu-Won;Kim, Young-Ok;Kim, Young-Kyun;Kang, Hyun-Syug;Bae, Jong-Min
    • The KIPS Transactions:PartD
    • /
    • v.10D no.2
    • /
    • pp.221-232
    • /
    • 2003
  • This paper addresses the query processing component of a wrapper system for a relational database model based on the XML view in integrating databases. The schema of a relational database is represented as XML Schema that is proposed by W3C. Users submit a query using the XML query language XQuery over the XML Schema. The wrapper system to be developed supports an user-defined XML view. XQuery is also used as the view definition language. In this environment, this paper suggests a new XML query processing model. We propose the composition algorithm of an XML view with an user query, the translation algorithm of XQuery into SQL, and the XML template construction algorithm for generating XML documents.

Performance Comparison of PostgreSQL and MongoDB using YCSB (YCSB를 사용한 PostgreSQL과 MongoDB 성능 비교 분석)

  • Kim, Kisung
    • Journal of KIISE
    • /
    • v.43 no.12
    • /
    • pp.1385-1395
    • /
    • 2016
  • In the era of Big Data, NoSQL databases provide solutions for problems, circumventing the limitations of traditional relational databases by using new architectures and data model. Contrary to relational database products, the range of the features architectures, and limitations of NoSQL databases is very broad. Thus, choosing the right database products requires more considerations and difficulties. The advent of NoSQL does not only promote the abundance of NoSQL products, but also stimulates the relational database realm to expand their features beyond the relational model. In order to understand NoSQL trends more accurately, here we discuss and compare NoSQL databases with relational databases. We also present the newest features associated with NoSQL in one of the most advanced open-source relational databases, PostgreSQL. To discuss future directions for PostgreSQL we analyzed the performance of NoSQL and PostgreSQL by conducting experiments using the NoSQL benchmark tool (YCSB).

RDB-based XML Access Control Model with XML Tree Levels (XML 트리 레벨을 고려한 관계형 데이터베이스 기반의 XML 접근 제어 모델)

  • Kim, Jin-Hyung;Jeong, Dong-Won;Baik, Doo-Kwon
    • Journal of Digital Contents Society
    • /
    • v.10 no.1
    • /
    • pp.129-145
    • /
    • 2009
  • As the secure distribution and sharing of information over the World Wide Web becomes increasingly important, the needs for flexible and efficient support of access control systems naturally arise. Since the eXtensible Markup Language (XML) is emerging as the de-facto standard format of the Internet era for storing and exchanging information, there have been recently, many proposals to extend the XML model to incorporate security aspects. To the lesser or greater extent, however, such proposals neglect the fact that the data for XML documents will most likely reside in relational databases, and consequently do not utilize various security models proposed for and implemented in relational databases. In this paper, we take a rather different approach. We explore how to support security models for XML documents by leveraging on techniques developed for relational databases considering object perspective. More specifically, in our approach, (1) Users make XML queries against the given XML view/schema, (2) Access controls for XML data are specified in the relational database, (3) Data are stored in relational databases, (4) Security check and query evaluation are also done in relational databases, and (5) Controlling access control is executed considering XML tree levels

  • PDF

Optimization of Fuzzy Relational Models

  • Pedrycz, W.;de Oliveira, J. Valente
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 1993.06a
    • /
    • pp.1187-1190
    • /
    • 1993
  • The problem of the optimization of fuzzy relational models for dealing with (non-fuzzy) numerical data is investigated. In this context, interfaces optimization assumes particular importance, becoming a determinant factor in what concerns the overall model performance. Considering this, several scenarios for building fuzzy relational models are presented. These are: (i) optimizing I/O interfaces in advance (independently from the linguistic part of the model); (ii) optimizing I/O interfaces in advance and allowing that their optimized parameters may change during the learning of the linguistic part of the model; (iii) build simultaneously both interfaces and the linguistic subsystem; and (iv) build simultaneously both linguistic subsystem and interfaces, now subject to semantic integrity constraints. As linguistic subsystems, both a basic type and an extended versions of fuzzy relation equations are exploited in each one of these scenarios. A comparative analysis of the differ nt approaches is summarized.

  • PDF

XML Application Design Methodology using Model of UML Class (UML Class 모델을 이용한 XML 응용 설계 방법론)

  • 방승윤;주경수
    • The Journal of Society for e-Business Studies
    • /
    • v.7 no.1
    • /
    • pp.153-166
    • /
    • 2002
  • Nowadays an information exchange on Bn such as B2B electronic commerce is spreading. Therefore the systematic and stable management mechanism for storing the exchanged information is needed. For this goal there are many research activities for connection between XML application and relational database. But because XML data have hierarchical structures and relational database can store only flat-structured data, we need to store XML data in object-relational database that support hierarchical structure. Accordingly the modeling methodology for storing XML data in object-relational database is needed. In order to build good quality application systems, modeling is an important first step. In 1997, the OMG adopted the UML as its standard modeling language. Since industry has warmly embraced UML its popularity should become more important in the future. So a design methodology based on UML is need to develop efficiently XML applications. In this paper, we propose a unified design methodology for In applications based on object-relational database using In. To this goal, first we introduce a XML modeling methodology to design W3C XML schema using UML and second we propose data modeling methodology for object-relational database schema to store efficiently XML data in object-relational databases.

  • PDF

The Influence of Firm Trust and Salesperson Trust on Commitment and Relational Citizenship Behavior (기업간 거래에서 관계적 시민행동에 관한 연구)

  • 김재욱;이성근;최지호;한계숙
    • Journal of Distribution Research
    • /
    • v.9 no.2
    • /
    • pp.75-99
    • /
    • 2004
  • The primary purpose of this research is to develop and test a model that explains the process of how trust in a supplier firm and salesperson through relational commitment influence buyer's positive and desirable behavior. In order to do so, we are empirically to examine how a supplier firm and salesperson trust can reinforce buyer's relational commitment leading to relational citizenship behavior using over 138 buying firms, Through structural equation modeling, we find that trust in a supplier firm and salesperson influence the relational commitment and relational commitment enhance relational citizenship behavior. However, trust in a supplier firm is unrelated to the buying firm's relational citizenship behavior whereas trust in salesperson has direct effect on relational citizenship behavior. Finally, we discuss several theoretical and practical implications, and suggest limitations for the research and future research issue.

  • PDF

A Researcher Model based on Ontology and a Social Network Construction Technique (온톨로지 기반의 연구자 모델링 기법과 연구자 네트워크 구축 기법)

  • Mun, Hyeon-Jeong;Jun, In-Ha;Woo, Yong-Tae
    • Journal of Korea Multimedia Society
    • /
    • v.12 no.7
    • /
    • pp.1022-1031
    • /
    • 2009
  • In this paper, we propose a researcher modeling technique based on ontology and construct social network for researchers using diverse relational properties. User ontology schema is created by extending the existing HR-XML model for a researcher model. User ontology schema and instance are created by OWL. We compose social network model for efficient cooperation between researchers using static relational properties such as educational background and dynamic relational properties such as co-authors and co-workers, etc. Closeness has direction because researcher network is differently configured by the researchers. We define inferencing rules using SWRL and inference ontology rules using racer inference machine to compose direct relationships between researchers. The proposed model for researchers can be applied to the cooperation model for researchers by retrieving common expert group dynamically.

  • PDF