• Title/Summary/Keyword: relational

Search Result 2,119, Processing Time 0.027 seconds

Block-wise Skipping for Embedded Database System (임베디드 데이터베이스 시스템을 위한 블록 단위 스키핑 기법)

  • Chong, Jae-Hyok;Park, Hyoung-Min;Hong, Seok-Jin;Shim, Kyu-Seok
    • The KIPS Transactions:PartD
    • /
    • v.16D no.6
    • /
    • pp.835-844
    • /
    • 2009
  • Today, most of all the query processors in the world generally use the 'Pipelining' method to acquire fast response time (first record latency) and less memory usage. Each of the operator nodes in the Query Execution Plan (QEP) provides Open(), Next(), and Close() functions for their interface to facilitate the iterator mechanism. However, the embedded database systems for the mobile devices, based on the FLASH memory, usually require a function like Previous(), which returns the previous records from current position. It is because that, in the embedded environment, the mobile devices cannot fully provide it main memory to store all the query results. So, whenever needed the previously read records the user (program) should re-fetch the previous records using the Previous() function: the BACKWARD data fetch. In this paper, I introduce the 'Direction Switching Problem' caused by the Previous() function and suggest 'Block-wise Skipping' method to fully utilize the benefits of the block-based data transfer mechanism, which is widely accepted by most of the today's relational database management systems.

Performance Comparison of DW System Tajo Based on Hadoop and Relational DBMS (하둡 기반 DW시스템 타조와 관계형 DBMS의 성능 비교)

  • Liu, Chen;Ko, Junghyun;Yeo, Jeongmo
    • KIPS Transactions on Software and Data Engineering
    • /
    • v.3 no.9
    • /
    • pp.349-354
    • /
    • 2014
  • Since Hadoop which is the Big-data processing platform was announced, SQL-on-Hadoop is the spotlight as the technique to analyze data using SQL on Hadoop. Tajo created by Korean programmers has recently been promoted to Top-Level-Project status by the Apache in April and has been paid attention all around world. Despite a sensible change caused by Hadoop's appearance in DW market, researches of those performance is insufficient. Thus, this study has been conducted to help choose a DW solution based on SQL-on-Hadoop as progressing the test on comparison analysis of RDBMS and Tajo. It has shown that Tajo based on Hadoop is more superior than RDBMS if it is used with accurate strategy. In addition, open-source project Tajo is expected not only to achieve improvements in technique due to active participation of many developers but also to be in charge of an important role of DW in the filed of data analysis.

A Persistence Framework Based SQL (SQL 기반 퍼시스턴스 프레임워크)

  • Cho, Dongil-Il;Rhew, Sung-Yul
    • The KIPS Transactions:PartD
    • /
    • v.15D no.4
    • /
    • pp.549-556
    • /
    • 2008
  • Web-based Enterprise Intranet System is developed Object-oriented programming language and data management is constructed using RDBMS. Between Object-oriented programming language and RDBMS bring about "Object-Relational Impedance Mismatch" due to heterogeneous paradigm. To solve this kinds of problems commonly use the ORM Framework that it is converting data between incompatible type systems in databases and object-oriented programming languages, uses complex mapping metadata. It causes difficult to develop and maintain because of inflexible in changes. This paper proposed persistence framework that solve the existing complexity of ORM framework and has more flexible in evolution of database table. This persistence framework is unnecessary meta information that connecting with entity of database table and the objects, it offers users convenience of maintenance and it allows far more flexible and affordable systems to be built because of automatically code generation. The result of testing based on the proposed persistence framework with Hibernate, iBATIS, It is similar response time with iBATIS and it has more about three times faster than Hibernate. But iBATIS has problems of mass data processing.

The Relationship of Security Organization's Social Capital and Job Satisfaction and Organizational Commitment (시큐리티 조직의 사회적 자본과 직무만족 및 조직몰입의 관계)

  • Kim, Il-Gon;Ahn, Hwang-Kwon
    • Convergence Security Journal
    • /
    • v.11 no.2
    • /
    • pp.45-54
    • /
    • 2011
  • The purpose of this study is to investigate the causal relationships among social capital, job satisfaction, and organization commitment in the Korean Security Organizations. One hundred eight one questionnaires, with a 72.4% response rate from a convenient sample of 10 security organization guards, were utilized to study the relationships between research constructs. SPSS(12.0 version) were guard to analyze the unintentionality of research concepts and reliability test, and confirmatory factor analysis were performed. Factor analyses identified three internal dimensions of relational factor as superior relation. There are among results, first, the social capital is influencing to job satisfaction positively. second, the social capital is influencing to organizational commitment positively. third, the job satisfaction is influencing to organizational commitment positively.

A study on the Effects of Ties and Trust Relationship between the Clients and Consultants on the Consulting Performance (고객과 컨설턴트 간의 유대관계 및 신뢰관계가 컨설팅성과에 미치는 영향에 관한 연구)

  • Choi, Chang-Ho;You, Yen-Yoo
    • Journal of Digital Convergence
    • /
    • v.12 no.10
    • /
    • pp.87-96
    • /
    • 2014
  • The first, this study analyzed empirically the effects of the ties(structural) and the trust(relational) between the clients(small and medium sized enterprises) and consultants on the consulting performance, the second, verified the moderating effects of the consultant's competence and the client's participation in the effect of the ties and the trust on the consulting performance. The result of empirical analysis was as follows. The ties and the competence based trust had a positive effects on the consulting performance. Meanwhile, the client's participation had no moderating effect, the consultant's competence moderated the effect of the ties and the trust on the consulting performance. From the above empirical analysis, we appreciated that the building of the strong ties and the trust between the client and consultant is very important to promote consulting performance with the enhancing the consultant's competence.

The traffic performance evaluation between remote server and mobile for applying to encryption protocol in the Wellness environment (웰니스 환경에서 암호화 프로토콜 적용을 위한 모바일과 원격 서버간 트래픽 성능 평가)

  • Lee, Jae-Pil;Kim, Young-Hyuk;Lee, Jae-Kwang
    • Journal of Digital Convergence
    • /
    • v.11 no.11
    • /
    • pp.415-420
    • /
    • 2013
  • U-WHS refers to a means of remote health monitoring service to combine fitness with wellbing. U-WHS is a system which can measure and manage biometric information of patients without any limitation on time and space. In this paper, we performed in order to look into the influence that the encryption module influences on the communication evaluation in the biometric information transmission gone to the smart mobile device and Hospital Information System.In the case of the U-WHS model, the client used the Objective-c programming language for software development of iOS Xcode environment and SEED and HIGHT encryption module was applied. In the case of HIS, the MySQL which is the Websocket API of the HTML5 and relational database management system for the client and inter-server communication was applied. Therefore, in WIFI communication environment, by using wireshark, data transfer rate of the biometric information, delay and loss rate was checked for the evaluation.

A Study on the Jeong-Jung-Dong [Movement in Silence] Expression Contemporary Design (현대 패션에 나타난 정중동(靜中動)의 표현 연구)

  • Lee, Yonkyu;Kan, Hosup
    • Journal of the Korean Society of Costume
    • /
    • v.67 no.2
    • /
    • pp.52-67
    • /
    • 2017
  • This is the precedent study on the modern fashion design using Korean emotions, and its aim is to study the expressions in the modern fashion based on 'Jeong-Jung-Dong' idea from Korean dancing, which implicates the Korean emotion deeply among the artworks and give essence similar to the clothing. 'Jeong-Jung-Dong', a unique idea, in the Korean traditional dancing is the philosophy that involve the paradox expression, 'Movement in Silence,' which represented the emotion of Korean dancing for a long time. The main characteristics deducted in 'Jeong-Jung-Dong' were 1) the incomplete and complete by atypical, 2) the beauty of temperance by symbolism, and 3) amusing mutual relationship. Upon the analysis results of previous studies on the expressions in the modern fashion with 'Jeong-Jung-Dong', they demonstrated the atypical expressed by metaphor, symbolic expression through margin, and mutual relational table by harmony. The analysis of modern fashion expression by 'Jeong-Jung-Dong', which is a philosophical idea in the Korean dancing, could highlight the new way of looking at the clothing and systemize the theory on the Korean emotion to seek the effective expression of artistic features for the culture together with introduction of our unique emotion in the creative design process by understanding of humanitarian and philosophical ideologies to be utilized in the future Fashion Design.

Association Analysis for Detecting Abnormal in Graph Database Environment (그래프 데이터베이스 환경에서 이상징후 탐지를 위한 연관 관계 분석 기법)

  • Jeong, Woo-Cheol;Jun, Moon-Seog;Choi, Do-Hyeon
    • Journal of Convergence for Information Technology
    • /
    • v.10 no.8
    • /
    • pp.15-22
    • /
    • 2020
  • The 4th industrial revolution and the rapid change in the data environment revealed technical limitations in the existing relational database(RDB). As a new analysis method for unstructured data in all fields such as IDC/finance/insurance, interest in graph database(GDB) technology is increasing. The graph database is an efficient technique for expressing interlocked data and analyzing associations in a wide range of networks. This study extended the existing RDB to the GDB model and applied machine learning algorithms (pattern recognition, clustering, path distance, core extraction) to detect new abnormal signs. As a result of the performance analysis, it was confirmed that the performance of abnormal behavior(about 180 times or more) was greatly improved, and that it was possible to extract an abnormal symptom pattern after 5 steps that could not be analyzed by RDB.

A Dominant Feature based Nomalization and Relational Description of Shape Signature for Scale/Rotational Robustness (2차원 형상 변화에 강건한 지배적 특징 기반 형상 시그너쳐의 정규화 및 관계 특징 기술)

  • Song, Ho-Geun;Koo, Ha-Sung
    • Journal of the Korea Society of Computer and Information
    • /
    • v.16 no.11
    • /
    • pp.103-111
    • /
    • 2011
  • In this paper, we propose a Geometrical Centroid Contour Distance(GCCD) which is described by shape signature based on contour sequence. The proposed method uses geomertrical relation features instead of the absolute angle based features after it was normalized and aligned with dominant feature of the shape. Experimental result with MPEG-7 CE-Shape-1 Data Set reveals that our method has low time/spatial complexity and scale/rotation robustness than the other methods, showing that the precision of our method is more accurate than the conventional desctiptors. However, performance of the GCCD is limited with concave and complex shaped objects.

A Study on The Impact of Perceived Crowding on Emotional Response and Revisit Intention (공항 이용객의 혼잡지각이 감정적 반응과 재방문의사에 미치는 영향에 관한 연구)

  • Kim, Seung-Lee;In, Ok-Nam
    • Journal of the Korea Society of Computer and Information
    • /
    • v.20 no.5
    • /
    • pp.141-150
    • /
    • 2015
  • The object of this study is finding out the relational effect of perceived crowding of international airport on emotional response and revisit intention. The data of this study was collected by questionnaire and based on Incheon international airport visitors. A total 260 validity sample was analyzed a frequency analysis, reliability analysis, exploratory factor analysis and correlation coefficient analysis from SPSS 21, a hypothesis through out confirmatory factor analysis and structural equation modeling from AMOS 7.0. As a result of this study, visitors' human perceived crowding of international airport and positive emotional response showed a significant effects on revisit intention.