• Title/Summary/Keyword: Local Database

Search Result 631, Processing Time 0.028 seconds

Efficient Processing of Grouped Aggregation on Non-Uniformed Memory Access Architecture (비균등 메모리 접근 구조에서의 효율적인 그룹화 집단 연산의 처리)

  • Choe, Seongjun;Min, Jun-Ki
    • Database Research
    • /
    • v.34 no.3
    • /
    • pp.14-27
    • /
    • 2018
  • Recently, to alleviate the memory bottleneck problme occurred in Symmetric Multiprocessing (SMP) architecture, Non-Uniform Memory Access (NUMA) architecture was proposed. In addition, since an aggregation operator is an important operator providing properties and summary of data, the efficiency of the aggregation operator is crucial to overall performance of a system. Thus, in this paper, we propose an efficient aggregation processing technique on NUMA architecture. Our proposed technique consists of partition phase and merge phase. In the partition phase, the target relation is partitioned into several partial relations according to grouping attribute. Thus, since each thread can process aggregation operator on partial relation independently, we prevent the remote memory access during the merge phase. Furthermore, at the merge phase, we improve the performance of the aggregation processing by letting each thread compute aggregation with a local hash table as well as avoiding lock contention to merge aggregation results generated by all threads into one.

A Study on Bikway Design Index for Digital Data Survey (자전거도로의 인프라 데이터 구축을 위한 설계지표 연구)

  • Jeon, Woo Hoon;Yang, Inchul
    • The Journal of the Korea Contents Association
    • /
    • v.20 no.12
    • /
    • pp.301-310
    • /
    • 2020
  • The purpose of paper is to find index for building digital database of bike infrastructure statistics by analyzing the existing design standards and manuals. The design standards and guides of both central and local governments which designates the design elements of bikeway were investigated to find the primary index, and then the attribute data of bikeway were grouped into four categories including transportation, geometry, pavement, safety and utility facility, and were analyzed to find the secondary index. A FGI(Focus Group Interview) was conducted with experts in the arena of transportation to collect the opinions on the selected index. It is found that the final twenty four design elements were selected and additional six elements were added. The proposed twenty four index of bikeway design elements are considered to be included when building the digital bikeway register database.

Development of Web-based Power Plant Simulator System (원격 훈련용 발전 시뮬레이터 개발)

  • Byun, Seung-Hyun;Kang, Hae-su;Woo, Joo-Hee;Lee, Jee-Hoon;Kim, Duck-Ho
    • KEPCO Journal on Electric Power and Energy
    • /
    • v.7 no.2
    • /
    • pp.277-283
    • /
    • 2021
  • Power plant simulators have been used for operator training, control verification and engineering verification. In general, simulators can be used in the place where they are installed by only single user group at a time. Considering high cost of simulator development, a lot of available scenarios, the diversity of user level and accessibility based on users' work location, development of simulator system that can be used by multiple user groups regardless of location is required in order to enhance utilization of simulators. In this paper, the simulator system that can be used by multiple user group simultaneously without location limitation is proposed. The simulator system is composed of simulator servers, database servers, HMI servers, a web server, web clients. Simulator server consists of control model, process model that are developed for Circulating Fluidized Bed power plant located overseas. A web server manages user accounts, operation procedures, multiple server access between web client group and simulator server group. In other words, a web server makes a user group select a simulator server at a time. The developed simulator system is integrated after implementing process model, control model, HMI, and web server. Web client systems are installed on local site where power plant is located, while simulator servers, HMI servers, database servers, and a web server are located in KEPCO RI. The developed simulator system is verified by steady-state test, malfunction test and so on via remote access.

The Effects of Government Environmental Subsidies and Corporate Environmental Expenditure for Globalization on the Profitability of Chinese Firms (글로벌 기업에 대한 환경보조금과 환경투자지출이 중국 기업의 수익성에 미치는 영향)

  • Li, Wen-Xi;Huang, Yi;Kim, Sung-Hwan
    • Asia-Pacific Journal of Business
    • /
    • v.12 no.3
    • /
    • pp.175-192
    • /
    • 2021
  • Purpose - In this study, we investigate the effects of government environmental subsidies and the globalization Chinese firms on their profitability using return on assets (ROA). Design/methodology/approach - In this study, a merged data including accounting, financial market, subsidization of the Chinese governments, local and the central, and export activities of 19,563 year-firms, for those listed on Shanghai Stock and Shenzhen Stock Exchange for 11 years from 2008 to 2018 is used. We collect subsidy data from RESSET database and financial data from CSMAR database. Then, we empirically test the test hypotheses using fixed effects models (FEM) separately and in a simultaneous equation model (SEM). Findings - Firstly, the globalization of Chinese firms has a negative impact on their profitability for some years after the year. Secondly, environmental subsidies just like other subsidies have ameliorating effects on financial performance for global firms. Such effects have lasted some years. Thirdly, environmental investments have a mostly negative impact on short- and long-term profitability for global firms. Lastly, the government's environmental subsidies in China have a positive effect on their profitability for both global and domestic firms. Research implications or Originality - We can infer that environmental investments with the help of the governmental subsidies can help Chinese firms deploy global strategies to expand markets to surpass competitors in the long run despite worsening profitability in global markets in the short run.

Image Analysis Fuzzy System

  • Abdelwahed Motwakel;Adnan Shaout;Anwer Mustafa Hilal;Manar Ahmed Hamza
    • International Journal of Computer Science & Network Security
    • /
    • v.24 no.1
    • /
    • pp.163-177
    • /
    • 2024
  • The fingerprint image quality relies on the clearness of separated ridges by valleys and the uniformity of the separation. The condition of skin still dominate the overall quality of the fingerprint. However, the identification performance of such system is very sensitive to the quality of the captured fingerprint image. Fingerprint image quality analysis and enhancement are useful in improving the performance of fingerprint identification systems. A fuzzy technique is introduced in this paper for both fingerprint image quality analysis and enhancement. First, the quality analysis is performed by extracting four features from a fingerprint image which are the local clarity score (LCS), global clarity score (GCS), ridge_valley thickness ratio (RVTR), and the Global Contrast Factor (GCF). A fuzzy logic technique that uses Mamdani fuzzy rule model is designed. The fuzzy inference system is able to analyse and determinate the fingerprint image type (oily, dry or neutral) based on the extracted feature values and the fuzzy inference rules. The percentages of the test fuzzy inference system for each type is as follow: For dry fingerprint the percentage is 81.33, for oily the percentage is 54.75, and for neutral the percentage is 68.48. Secondly, a fuzzy morphology is applied to enhance the dry and oily fingerprint images. The fuzzy morphology method improves the quality of a fingerprint image, thus improving the performance of the fingerprint identification system significantly. All experimental work which was done for both quality analysis and image enhancement was done using the DB_ITS_2009 database which is a private database collected by the department of electrical engineering, institute of technology Sepuluh Nopember Surabaya, Indonesia. The performance evaluation was done using the Feature Similarity index (FSIM). Where the FSIM is an image quality assessment (IQA) metric, which uses computational models to measure the image quality consistently with subjective evaluations. The new proposed system outperformed the classical system by 900% for the dry fingerprint images and 14% for the oily fingerprint images.

NIRS Calibration Equation Development and Validation for Total Nitrogen Contents Field Analysis in Fresh Rice Leaves (벼 생엽의 질소함량 현장분석을 위한 NIRS 검량식 개발 및 검증)

  • Song, Young-Eun;Lee, Deok-Ryeol;Cho, Seong-Hyun;Lee, Ki-Kwon;Jeong, Jong-Seong;Gwon, Yeong-Rip;Cho, Kyu Chae
    • KOREAN JOURNAL OF CROP SCIENCE
    • /
    • v.58 no.3
    • /
    • pp.301-307
    • /
    • 2013
  • This study was evaluated high end research grade Near Infrared Reflectance Spectrophotometer (NIRS) to field grade multiple Near Infrared Reflectance Spectrophotometer (NIRS) for rapid analysis at fresh rice leaf at sight with 238 samples of fresh rice leaf during year 2012, collected Jeollabuk-do for evaluate accuracy and precision between instruments. Firstly collected and build database high end research grade NIRS using with 400 nm ~ 2500 nm during from year 2003 to year 2009, seven years collected fresh rice leaf database then trim and fit to field grade NIRS with 1200 nm ~ 2400 nm then build and create calibration, transfer calibration with special transfer algorithm. The result between instruments was 0.005% differences, rapidly analysis for chemical constituents, Total nitrogen in fresh rice leaf within 5 minutes at sight and the result equivalent with laboratory data. Nevertheless last during more than 8 years collected samples for build calibration was organic samples that make differentiate by local or yearly bases etc. This strongly suggest population evaluation technique needed and constantly update calibration and maintenance calibration to proper handling database accumulation and spread out by knowledgable control laboratory analysis and reflect calibration update such as powerful control center needed for long lasting usage of fresh rice leaf analysis with NIRS at sight. Especially the agriculture products such as rice will continuously changes that made easily find out the changes and update routinely, if not near future NIRS was worthless due to those changes. Many research related NIRS was shortly study not long term study that made not well using NIRS, so the system needed check simple and instantly using with local language supported signal methods global distance (GD) and neighbour distance (ND) algorithm. Finally the multiple popular field grades instruments should be the same results not only between research grade instruments but also between multiple field grade instruments that needed easily transfer calibration and maintenance between instruments via internet networking techniques.

Using Logistic Regression for Determining the Factors Affecting Bidding Success in World Bank's International Consulting Projects in Indonesia (로그 회귀분석을 이용한 해외 엔지니어링 사업의 낙찰 성공 요인 분석 - 세계은행의 인도네시아 사업을 중심으로-)

  • Yu, Youngsu;Shin, Byungjin;Koo, Bonsang;Han, Seungheon
    • Korean Journal of Construction Engineering and Management
    • /
    • v.19 no.1
    • /
    • pp.80-89
    • /
    • 2018
  • World Bank projects enable Korean engineering firms to enter new markets and diversify their portfolio. These firms need to understand the critical factors for bidding success in such projects. The World Bank publishes as open records all their bidding history data in their open database. This provides an opportunity to identify empirically the factors that determine which firms on chosen. This research collected relevant bid data, focusing on Indonesia, to perform a logistic regression with the goal of statistically identifying significant factors that result in bidding success. Results showed that work experience, being included in a consortium, and having a local partner positively affected winning a bid. On the other hand, having a local competitor of the recipient country negatively impacts the chances of attaining a bid. Commensurately, Korean engineering firms need to increase their work experience in internationally recognized projects, and include a local partner as a joint venture partner to increase their chances, while refrain from conventional projects that can be performed by local engineering firms.

Affinity-based Dynamic Transaction Routing in a Shared Disk Cluster (공유 디스크 클러스터에서 친화도 기반 동적 트랜잭션 라우팅)

  • 온경오;조행래
    • Journal of KIISE:Databases
    • /
    • v.30 no.6
    • /
    • pp.629-640
    • /
    • 2003
  • A shared disk (SD) cluster couples multiple nodes for high performance transaction processing, and all the coupled nodes share a common database at the disk level. In the SD cluster, a transaction routing corresponds to select a node for an incoming transaction to be executed. An affinity-based routing can increase local buffer hit ratio of each node by clustering transactions referencing similar data to be executed on the same node. However, the affinity-based routing is very much non-adaptive to the changes in the system load, and thus a specific node will be overloaded if transactions in some class are congested. In this paper, we propose a dynamic transaction routing scheme that can achieve an optimal balance between affinity-based routing and dynamic load balancing of all the nodes in the SD cluster. The proposed scheme is novel in the sense that it can improve the system performance by increasing the local buffer hit ratio and reducing the buffer invalidation overhead.

Development of Web-Based Assistant System for Protein-Protein Interaction and Function Analysis (웹 기반의 단백질 상호작용 및 기능분석을 위한 보조 시스템 개발)

  • Jung Min-Chul;Park Wan;Kim Ki-Bong
    • Journal of Life Science
    • /
    • v.14 no.6 s.67
    • /
    • pp.997-1002
    • /
    • 2004
  • This paper deals with the WASPIFA (Web-based Assistant System for Protein-protein Interaction and Function Analysis) system that can provide the comprehensive information on Protein-protein interaction and function concerned with function analysis. Different from existing systems for protein function and protein-protein interaction analysis, which provide fragmentary information restricted to specific field, our system furnishes end-user with comprehensive and synthetic information on the input sequence to be analyzed, including function and annotation information, domain information, and interaction relationship information. The synthetic information that our system contains as local databases has been extracted from many resources related to function, annotation, motif and domain by various pre-processing. Employing our system, end-users can evaluate and judge the synthetic results to do protein interaction and function analysis effectively. In addition, the WASPIFA system is equipped with automatic system management and data update function that facilitates system manager to maintain and manage it efficiently.

Shot Motion Classification Using Partial Decoding of INTRA Picture in Compressed Video (압축비디오에서 인트라픽쳐 부분 복호화를 이용한 샷 움직임 분류)

  • Kim, Kang-Wook;Kwon, Seong-Geun
    • Journal of Korea Multimedia Society
    • /
    • v.14 no.7
    • /
    • pp.858-865
    • /
    • 2011
  • In order to allow the user to efficiently browse, select, and retrieve a desired video part without having to deal directly with GBytes of compressed data, classification of shot motion characteristic has to be carried out as a preparation for such user interaction. The organization of video information for video database requires segmentation of a video into its constituent shots and their subsequent characterization in terms of content and camera movement in shot. In order to classify shot motion, it is a conventional way to use element of motion vector. However, there is a limit to estimate global camera motion because the way that uses motion vectors only represents local movement. For shot classification in terms of motion information, we propose a new scheme consisting of partial decoding of INTRA pictures and comparing the x, y displacement vector curve between the decoded I-frame and next P-frame in compressed video data.