• Title/Summary/Keyword: Relational

Search Result 2,125, Processing Time 0.027 seconds

Relational Data Extraction and Transformation: A Study to Enhance Information Systems Performance

  • Forat Falih, Hasan;Muhamad Shahbani Abu, Bakar
    • Journal of information and communication convergence engineering
    • /
    • v.20 no.4
    • /
    • pp.265-272
    • /
    • 2022
  • The most effective method to improve information system capabilities is to enable instant access to several relational database sources and transform data with a logical structure into multiple target relational databases. There are numerous data transformation tools available; however, they typically contain fixed procedures that cannot be changed by the user, making it impossible to fulfill the near-real-time data transformation requirements. Furthermore, some tools cannot build object references or alter attribute constraints. There are various situations in which tool changes in data type cause conflicts and difficulties with data quality while transforming between the two systems. The R-programming language was extensively used throughout this study, and several different relational database structures were utilized to complete the proposed study. Experiments showed that the developed study can improve the performance of information systems by interacting with and exchanging data with various relational databases. The study addresses data quality issues, particularly the completeness and integrity dimensions of the data transformation processes.

EMPIRICAL ASSOCIATIONS BETWEEN INTELLECTUAL CAPITAL AND PERFORMANCE OF ARCHITECTURE FIRMS

  • Chung-Fah Huang;Li-Ren Yang
    • International conference on construction engineering and project management
    • /
    • 2009.05a
    • /
    • pp.1023-1029
    • /
    • 2009
  • Intellectual capital is one of the most valuable assets of any enterprise. This empirical investigation examines the causal relationship between intellectual capital and the performance of architecture firms. More than 100 architecture firms across Taiwan have each been assessed for the levels of human capital, structural capital, relational capital, and business performance. The results suggest that the architecture firms exhibit higher levels of relational capital. However, the firms indicate relatively low levels of human capital. Additionally, the results from the correlation analysis suggest that all the four measures (human capital, structural capital, relational capital, and business performance) are highly correlated. The findings from the path analysis also indicate that human capital may influence the performance of architecture firms via structural capital and relational capital.

  • PDF

The Effect of Mileage Program in e-Business on Brand Loyalty : Focused on the Mediating Roles of Trust and Relational Commitment (e-Business에서의 마일리지프로그램이 신뢰와 관계몰입을 통해 브랜드애호도에 미치는 영향)

  • Lee Joung-Sil;Lim Chae-Kwan;Park Bong-Gyu
    • The Journal of the Korea Contents Association
    • /
    • v.5 no.4
    • /
    • pp.28-35
    • /
    • 2005
  • This paper examines empirically the effect of mileage program in e-Business on brand loyalty, and the mediating role of customers' trust and relational commitment. The results show that customer's benefits and convenience of the program significantly influences positively customer's trust. In addition, customer's trust also influences positively relational commitment, and relational commitment significantly influences positively brand loyalty. Thus, trust and relational commitment should be considered in the mileage program to improve the brand loyalty of internet shopping mall. Implications and limitations of this study are suggested.

  • PDF

Visualizations of Relational Capital for Shared Vision

  • Russell, Martha G.;Still, Kaisa;Huhtamaki, Jukka;Rubens, Neil
    • World Technopolis Review
    • /
    • v.5 no.1
    • /
    • pp.47-60
    • /
    • 2016
  • In today's digital non-linear global business environment, innovation initiatives are influenced by inter-organizational, political, economic, environmental, technological systems, as well as by decisions made individually by key actors in these systems. Network-based structures emerge from social linkages and collaborations among various actors, creating innovation ecosystems, complex adaptive systems in which entities co-create value. A shared vision of value co-creation allows people operating individually to arrive together at the same future. Yet, relationships are difficult to see, continually changing and challenging to manage. The Innovation Ecosystem Transformation Framework construct includes three core components to make innovation relationships visible and articulate networks of relational capital for the wellbeing, sustainability and business success of innovation ecosystems: data-driven visualizations, storytelling and shared vision. Access to data facilitates building evidence-based visualizations using relational data. This has dramatically altered the way leaders can use data-driven analysis to develop insights and provide ongoing feedback needed to orchestrate relational capital and build shared vision for high quality decisions about innovation. Enabled by a shared vision, relational capital can guide decisions that catalyze, support and sustain an ecosystemic milieu conducive to innovation for business growth.

Acceleration of Building Thesaurus in Fuzzy Information Retrieval Using Relational products

  • Kim, Chang-Min;Kim, Young-Gi
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 1998.06a
    • /
    • pp.240-245
    • /
    • 1998
  • Fuzzy information retrieval which uses the concept of fuzzy relation is able to retrieve documents in the way based on not morphology but semantics, dissimilar to traditional information retrieval theories. Fuzzy information retrieval logically consists of three sets : the set of documents, the set of terms and the set of queries. It maintains a fuzzy relational matrix which describes the relationship between documents and terms and creates a thesaurus with fuzzy relational product. It also provides the user with documents which are relevant to his query. However, there are some problems on building a thesaurus with fuzzy relational product such that it has big time complexity and it uses fuzzy values to be processed with flating-point. Actually, fuzzy values have to be expressed and processed with floating-point. However, floating-point operations have complex logics and make the system be slow. If it is possible to exchange fuzzy values with binary values, we could expect sp eding up building the thesaurus. In addition, binary value expressions require just a bit of memory space, but floating -point expression needs couple of bytes. In this study, we suggest a new method of building a thesaurus, which accelerates the operation of the system by pre-applying an ${\alpha}$-cut. The experiments show the improvement of performance and reliability of the system.

  • PDF

On supporting full-text retrievals in XML query

  • Hong, Dong-Kweon
    • International Journal of Fuzzy Logic and Intelligent Systems
    • /
    • v.7 no.4
    • /
    • pp.274-278
    • /
    • 2007
  • As XML becomes the standard of digital data exchange format we need to manage a lot of XML data effectively. Unlike tables in relational model XML documents are not structural. That makes it difficult to store XML documents as tables in relational model. To solve these problems there have been significant researches in relational database systems. There are two kinds of approaches: 1) One way is to decompose XML documents so that elements of XML match fields of relational tables. 2) The other one stores a whole XML document as a field of relational table. In this paper we adopted the second approach to store XML documents because sometimes it is not easy for us to decompose XML documents and in some cases their element order in documents are very meaningful. We suggest an efficient table schema to store only inverted index as tables to retrieve required data from XML data fields of relational tables and shows SQL translations that correspond to XML full-text retrievals. The functionalities of XML retrieval are based on the W3C XQuery which includes full-text retrievals. In this paper we show the superiority of our method by comparing the performances in terms of a response time and a space to store inverted index. Experiments show our approach uses less space and shows faster response times.

The Performance of Franchisees from the Franchisor's and Franchisee's Intangible Assets

  • Kim, Young-Ho;Bae, Il-Hyun;Kim, Janghyun
    • Journal of Distribution Science
    • /
    • v.16 no.4
    • /
    • pp.35-47
    • /
    • 2018
  • Purpose - This study seeks to find out the factors affecting the performance of franchisees from the franchisor's and franchise's intangible assets. In order to explain the process, this study explores the concept of LMX, Relational Capital, and Decision Rights Delegation. Research design, data, and methodology - To verify the proposed hypotheses, a questionnaire survey was conducted for franchise store owners, and to test the hypotheses, structural equation modeling was established. Results - First, franchisor's intangible assets affect the quality of LMX, but don't affect the relational capital. And the quality of LMX affects the relational capital. In addition, "the effect of delegation of decision rights on relational capital" and "the effect of relational capital on franchisee's performance" were significant. However, the effect of delegation of decision rights on franchisee's performance wasn't significant. Second, the intangible assets of the franchise have a positive effect on the quality of the LMX and the degree of delegation of decision rights, and the quality of the LMX has a positive effect on the delegation of decision rights. Conclusions - This study would suggest operational implications for the formation of vertical and horizontal relationships and the cooperation between the main members of the franchise business.

A Design Methodology of Relational Database Schema Without the Conceptual Design Step (개념적 설계를 배제한 관계형 데이터베이스 스키마의 설계)

  • Um Yoon-Sup
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.9 no.2
    • /
    • pp.445-453
    • /
    • 2005
  • The design process of a relational database system consists of requirement analysis, conceptual design using ER diagram, logical design, and physical design. In logical design process, the conceptual schema is transformed to relational schema, and relational schema is normalized. This traditional design process is hard to applied in real database design process, since there is an ambiguity in conceptual design process. In this paper, we suggest a new design process, which provides more structural design steps by removing the conceptual design process. In new approach, we produce the data flow diagram by the structural methodology. From the attributes in the data store of data flow diagram, we construct relational table schema, and we normalize relational schema. Finally we produced table relationship diagram in order to figure out relationships between tables.

Customer Loyalty and Perception Differences in Relational Benefit: Focusing on Restaurant Industries (외식고객의 충성도 분류에 따른 관계편익 지각 차이에 대한 연구)

  • Kim, Hyungmin;Yoon, Jiyoung
    • Culinary science and hospitality research
    • /
    • v.24 no.1
    • /
    • pp.50-62
    • /
    • 2018
  • The purpose of this study was to overview the meaning of customer loyalty to segment customers based on their loyalty and to analyze the difference of loyal customers' perception of relational benefits in the restaurant industries. A self-administered questionnaire was distributed to 500 adults with dining experience at restaurants. Participants were given a brief description of loyalty and were made to choose a specific restaurant they felt loyal to and one with no loyalty. Attitudinal and behavioral loyalty were used in cluster analysis resulting 4 cluster groups. Each group was named true, spurious, latent, and low loyalty. After the groups were separated, ANOVA was used to see if the score of perceived relational benefit showed difference. All four relational benefit including social, psychological, economic, and customization benefit showed significant difference(p<.001). True loyal customers perceived relational benefit as the highest while low loyal customers showed the lowest. For latent and spurious loyal customers, it was found that latent loyal customers showed higher perception than spurious customers.

Social Information Processing according to Sex and Types of Aggression of Children (아동의 성과 공격성 유형에 따른 사회정보처리과정 : 해석단계와 반응결정단계를 중심으로)

  • Kim, Ji-Hyun;Park, Kyung-Ja
    • Journal of the Korean Home Economics Association
    • /
    • v.47 no.1
    • /
    • pp.105-113
    • /
    • 2009
  • The purpose of this study was to explore differences in social information processing according to children's sex and types of aggression in response to instrumental and relational provocation factors. Two hundred and fifty-one 4, 5, and 6 graders were selected from an elementary school in Seoul. To evaluate their social information processing, the Intent Attributions and Feelings of Distress(Crick, 1995; Fitzgerald & Asher, 1987) and Response Decision Instrument(Crick & Werner, 1998) were revised and analyzed. A peer-nomination measure(Crick, 1995; Crick & Grotpeter, 1995) was used to select aggressive groups. Data were subjected to descriptive statistical analysis and multivariate [2(sex: M, F)${\times}$3(type of aggression: overt, relational, overt and relational aggression)] analysis of variance. Findings revealed that children's social information processing patterns were different according to sex and type of aggression. Also aggressive children responded differently in their social information processing according to instrumental and relational provocation factors. Implications of these findings for the role of gender, aggression type, and provocation type are discussed in order to better understanding of children's social information processing.