• Title/Summary/Keyword: Relational performance

Search Result 355, Processing Time 0.031 seconds

A Goal-Oriented Performance Management Model with DB Performance Index for Relational Database System (성능지수를 고려한 관계형 데이터베이스 시스템의 목표지향형 성능관리 모델)

  • Park, SangYong;Kim, Jeong-Dong;Baik, Doo-Kwon
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2009.04a
    • /
    • pp.313-316
    • /
    • 2009
  • 관계형 데이터베이스를 사용하는 응용시스템들은 어플리케이션 소스 코드에 내재된 SQL을 통하여 데이터를 액세스하게 되며, SQL을 통한 데이터베이스 액세스 성능은 응용시스템의 성능에 결정적인 영향을 미치기 때문에, 관계형 데이터베이스시스템의 튜닝에 대해서는 많은 연구가 이루어져 왔다. 그러나 데이터베이스시스템 튜닝을 통해 얻은 성능 수준은 응용시스템의 변경이나 데이터 저장량 증가 등 여러 요인에 의해 다시 저하될 수 있으며, 이와 같은 성능 수준의 변화를 정량적으로 관리하면서 최소 비용으로 성능 수준을 유지할 수 있도록 튜닝 시점을 결정하는 방법에 대한 연구는 현재까지 연구된 바가 없다. 이 논문에서 제시하는 DB 성능지수와 이를 이용한 데이터베이스시스템의 성능관리 모델은 특정 벤더에 종속되지 않고 성능수준을 정량화함으로써 이해관계자들에게 성능 수준의 변화를 가시적으로 보이고 데이터베이스 관리자의 성능관리 및 튜닝 시점 판단을 지원하여 일정 수준의 성능을 유지할 수 있는 방법으로 활용될 수 있다.

Performance Comparison of Join Operations Parallelization by using GPGPU (GPGPU 기반 조인 연산 병렬화 성능 비교)

  • Lee, Jong-Sub;Lee, Sang-Back;Lee, Kyu-Chul
    • Database Research
    • /
    • v.34 no.3
    • /
    • pp.28-44
    • /
    • 2018
  • In a database system, the most expensive operation among relational operations is a join operation. Generally, CPU-based join operations uses parallel processing with either 1 core or 16 cores at most, which does not significantly improve the function. On the other hand, GPGPU(General-Purpose computing on Graphics Processing Units) allows parallel processing through thousands of processing units, greatly reducing the time required to perform join operations. Parallelization of the operation using GPGPU uses NVIDIA's CUDA SDK. In this paper, we implement parallelization of the join operation using GPGPU and compare the performances. The used join operations are Nested Loop Join (NLJ), Sort Merge Join (SMJ) and Hash Join (HJ), and GPGPU equipment uses TITAN Xp, GTX 1080 Ti and GTX 1080. We measure and compare the performance of join operations based on CPU and GPGPU. We compare this performance with the performance of the previous study on the join operation based on GPGPU. The results of experiment show that the performance based on GPGPU is 6~328 times faster than the one based on CPU.

The Effects of Global Entrepreneurship and Social Capital Within Supply Chain on the Export Performance (글로벌 기업가정신과 공급사슬 내 사회적 자본이 수출성과에 미치는 영향)

  • Yoon, Heon-Deok;Kwak, Ki-Young;Seo, Ri-Bin
    • Asia-Pacific Journal of Business Venturing and Entrepreneurship
    • /
    • v.7 no.3
    • /
    • pp.1-16
    • /
    • 2012
  • Under the international business circumstance, global supply chain management is considered a vital strategic challenge to small and medium-sized enterprises(SMEs) suffering from deficient resources and capabilities to exploit overseas markets comparing with large corporations. That is because they can expand their business domains into overseas markets by establishing strategic alliances with global supply chain partners. Although a wide range of previous researches have emphasized the cooperative networks in the chain, most are ignoring the importance of developing relational characteristics such as trust and reciprocity with the partners. Besides, verifying the relational factors influencing firms' export performances, some studies proposed different and inconsistent factors. According to the social capital theory, which is the social quality and networks facilitating close cooperation of inter-individual and inter-organization, provides the integrated view to identify the relational characteristics in the aspects of network, trust and reciprocal norm. Meanwhile, a number of researchers shows that global entrepreneurship is the internal and intangible resource necessary to promote SMEs' internationalization. Upon closer examination, however, they cannot explain clearly its influencing mechanism in the inter-firm cooperative relationships. This study is to verify the effect of social capital accumulated within global supply chain on SMEs' qualitative and quantitative export performance. In addition, we shed new light on global entrepreneurship expected to be concerned with the formation of social capital and the enhancement of export performances. For this purpose, the questionnaires, developed through literature review, were collected from 192 Korean SMEs affiliated in Korean Medium Industries Association and Global Chief Executive Officer's Club focusing on their memberships' international business. As a result of multi-regression analysis, the social capital - network, trust and reciprocal norm shared with global supply chain partner - as well as global entrepreneurship - innovativeness, proactiveness and risk-taking - have positive effect on SMEs' export performances. Also global entrepreneurship affects positively social capital which has mediating effect partially in the relationship between global entrepreneurship and performances. These results means that there is a structural process - global entrepreneurship(input), social capital(output), and export performances(outcome). In other words, a firm should consistently invest in and develop the social capital with global supply chain partners in order to achieve common goals, establish strategic collaborations and obtain long-term export performances. Furthermore, it is required to foster the global entrepreneurship in an organization so as to build up the social capital. More detailed practical issues and discussion are made in the conclusion.

  • PDF

Evolution of Relationship Marketing in the New Reality: Focused on the Pervasiveness of Digital New Media and the Enlargement of Customer Participation (21세기 새로운 현실에서 Relationship Marketing의 진화: 디지털 뉴미디어 환경의 보편화와 고객 참여의 고도화를 중심으로)

  • Lim, Jong Won;Cho, Ho Hyeon;Lee, Jeong Hoon
    • Asia Marketing Journal
    • /
    • v.13 no.4
    • /
    • pp.105-137
    • /
    • 2012
  • After relationship marketing emerged as a new approach in the marketing field in the 1980s, it has been widely studied in the United States, Europe and Asia. Rapid environmental changes and global competition has made it inevitable for companies to consider their relationships with the environment more closely. Under these circumstances, relationship marketing has held a position as a pivotal paradigm in the field of strategy as well as in marketing. In addition, relationship marketing has overcome the limitations of a traditional marketing research while providing richer implications in company's marketing activities. The paradigm shift to relationship marketing has brought fundamental changes in a marketing point of view. First, in philosophical aspects, unlike past research which focused solely on customer satisfaction, organizational relationship parameters which focuses on trust and commitment has become key elements of successful relationship marketing while shifts in thoughts naturally take place from adaptive marketing to strategic marketing. Second, in structural aspects, the relational mechanism of governance such as network structure with a variety of relational partners has emerged as a new marketing organization from the previous simple structure focusing on the micro-economic, marketbased trading between seller and customer. Third, in behavioral aspects, it proposed the strategic course of the action of gaining an advantage over the competition on the individual firm level by focusing on building long-term relationships and considering partnership with the components in the entire marketing system, rather than with one-time transaction-centric action between a seller and a customer. Fourth, in the aspects of marketing performance, marketing performance was sought through the long-term and cooperative relationship with various stakeholders, including customers in the marketing system, focusing on the overall competitive advantage based on relationship rather than individual performance of individual companies' marketing activities, such as market share and customer satisfaction. However, studies of relationship marketing were mostly centered in interorganizational relationships focusing on the relational structure and properties of commercial sector in the marketing system. Paradoxically, the circumstance of the consumer's side that must be considered is evolving again in relationship marketing. In structural aspects, a community, as the new relationship governance structure in the digital environment, and in behavioral aspects, the changing role of consumer participation demanding big changes in the digital environment engaged in the marketing system. The possibility of building a relationship marketing community for common value creation is presented in terms of organization of consumers with the focus on changing marketing environment and marketing system according to the new realities of the 21st century- the popularity of digital environments and the diffusion of customer participation. Therefore, future research of relationship marketing must seek for a truly integrated model including all of the existing structure and properties of the research oriented relationship from both the commercial and consumer sector.

  • PDF

Storage and Retrieval of XML Documents Without Redundant Path Information (경로정보의 중복을 제거한 XML 문서의 저장 및 질의처리 기법)

  • Lee Hiye-Ja;Jeong Byeong-Soo;Kim Dae-Ho;Lee Young-Koo
    • The KIPS Transactions:PartD
    • /
    • v.12D no.5 s.101
    • /
    • pp.663-672
    • /
    • 2005
  • This Paper Proposes an approach that removes the redundancy of Path information and uses an inverted index, as an efficient way to store a large volume of XML documents and to retrieve wanted information from there. An XML document is decomposed into nodes based on its tree structure, and stored in relational tables according to the node type, with path information from the root to each node. The existing methods using path information store data for all element paths, which cause retrieval performance to be decreased with increased data volume. Our approach stores only data for leaf element path excluding internal element paths. As the inverted index is made by the leaf element path only, the number of posting lists by key words become smaller than those of the existing methods. For the storage and retrieval of U data, our approach doesn't require the XML schema information of XML documents and any extension of relational database. We demonstrate the better performance of on approach than the existing approaches within the scope of our experiment.

Multiple Pipelined Hash Joins using Synchronization of Page Execution Time (페이지 실행시간 동기화를 이용한 다중 파이프라인 해쉬 결합)

  • Lee, Kyu-Ock;Weon, Young-Sun;Hong, Man-Pyo
    • Journal of KIISE:Computer Systems and Theory
    • /
    • v.27 no.7
    • /
    • pp.639-649
    • /
    • 2000
  • In the relational database systems, the join operation is one of the most time-consuming query operations. Many parallel join algorithms have been developed to reduce the execution time. Multiple hash join algorithm using allocation tree is one of most efficient ones. However, it may have some delay on the processing each node of allocation tree, which is occurred in tuple-probing phase by the difference between one page reading time of outer relation and the processing time of already read one. In this paper, to solve the performance degrading problem by the delay, we develop a join algorithm using the concept of 'synchronization of page execution time' for multiple hash joins. We reduce the processing time of each nodes in the allocation tree and improve the total system performance. In addition, we analyze the performance by building the analytical cost model and verify the validity of it by various performance comparison with previous method.

  • PDF

Performance Evaluation of XML Materialized View Refresh (XML 실체뷰 갱신 기법의 성능 평가)

  • Sung, Ho-Sang;Moon, Chan-Ho;Kang, Hyung-Chul
    • The KIPS Transactions:PartD
    • /
    • v.10D no.3
    • /
    • pp.387-398
    • /
    • 2003
  • Materialized views have received much attention for query performance improvement. They need to be refreshed whenever their underlying data sources are updated. They could be recomputed from scratch or they could be incrementally refreshed by reflecting only those portions of updates that affect them. With emergence of XML as the standard for data exchange on the Web, active research is under way on effectively storing and retrieving XML documents. In this paper, we describe a performance study on the incremental refresh of XML materialized views for the case where XML documents are stored in a relational DBMS, and XML materialized views are maintained with incremental refresh. We describe implementation of a prototype XML storage system that supports XML materialized views and their incremental refresh, and report the performance results obtained with the implemented system through a detailed set of experiments on the incremental refresh of XML materialized views. The results show that the XML view maintenance with incremental refresh outperforms the ordinary view recomputation.

Structural Relationship between Intellectual Capital and Organizational Performance in a Customer Service Organization: Focused on the Role of Dynamic Capability (고객서비스 조직의 지적자본과 조직성과 간의 구조적 관계: 동적역량의 역할을 중심으로)

  • Park, Paul;Cheong, Ki-Ju;Kim, Sora;Ryu, Il
    • The Journal of the Korea Contents Association
    • /
    • v.14 no.12
    • /
    • pp.911-923
    • /
    • 2014
  • This study explores which organizational capital is important for the customer service center and how the organizational capital is linked to organization's performance through dynamic capability. In this study, total of 389 employees in customer service centers were surveyed for the analysis. The results indicate that relational capital and organizational culture were positively linked with collaborative behavior, capital share, and capital transformation. Also, structural capital was a significant factor in collaborative behavior. Organizational performance was positively affecting collaborative behavior and capital share. This study provides a practical guideline on how to manage organizational capital and supplement shortcomings for managers and counsellors at the customer service centers. Furthermore, the implications for the reinforcement and development of organizational capital were suggested in building a customer service center as a strategic and fundamental part of the company.

The Effect of Ethical Management on Performance of Retailer-Vendor Relationship: The Mediating Effect of Equity from Vendor Perspective (소매업체-공급업체 관계에서 윤리경영 평가가 관계성과에 미치는 영향: 공급업체 공정성 지각의 매개효과를 중심으로)

  • Hur, Won-Moo;Park, Jin-Yong;Kim, Min-Sung
    • Journal of Distribution Research
    • /
    • v.13 no.2
    • /
    • pp.59-78
    • /
    • 2008
  • The purpose of this study is to investigate the effect of vendor perceived equity on the performance of retailer-vendor relationship. The empirical study of 386 vendors identified the following results. First, retailers' ethical management positively influenced on vendors' perception on procedural justice and interactional equity, whereas boundary personnel's ethical management positively influenced only on interactional equity. Second, distributive equity was positively influenced by procedural equity and interactional equity. Third, the performance of retailer-vendor relationship was directly affected by distributive equity and interactional equity, whereas procedural equity indirectly influenced on the relationship via distributive equity.

  • PDF

Impact of Service Quality on the Intent of Continuous Use of Railroad Logistics - Focusing on the Mediation Effect of Logistics (철도물류의 지속적 이용의도에 미치는 서비스 품질의 영향력 - 물류성과의 매개효과를 중심으로)

  • Kim, Jong-Man;Lee, Yong-Sang
    • Journal of the Korean Society for Railway
    • /
    • v.20 no.3
    • /
    • pp.389-399
    • /
    • 2017
  • This study analyzes the impact on continuous use of railroad logistics by mediating the logistics performance of recognition on the logistics service quality. According to the results, economic quality, information quality and relationship quality have impacts on the intent of continuous use by fully mediating logistics performance. Based on these results, a model for intent of continuous use of railroad logistics was proposed. As for the results of this study, it can be seen that the continuous use of railroad logistics is formed by the logistics performance due to the use of railroad logistics and, for this, a practical direction is suggested: the improvement of service is required, by which the recognition can be enhanced for the economic quality, information quality and relationship quality of the customers.