• Title/Summary/Keyword: View Processing Technique

Search Result 131, Processing Time 0.021 seconds

TATS: an Efficient Technique for Computing Temporal Aggregates for Data Warehousing

  • Shin, Young-Ok;Park, Sung-Kong;Baik, Doo-Kwon;Ryu, Keun-Ho
    • ETRI Journal
    • /
    • v.22 no.3
    • /
    • pp.41-51
    • /
    • 2000
  • An important use of data warehousing is to provide temporal views over the history of source data. It is significant that nearly all data warehouses are dependent on relational database technology, yet relational databases provide little or no real support for temporal data. Therefore, in is difficult to obtain accurate information for time-varying data. In this paper, we are going to design a temporal data warehouse to support time-varying data efficiently. For this purpose, we present a method to support temporal query by combining a temporal query process layer with the relational database which is used as a source database in an existing data warehouse. We introduce the Temporal Aggregate Tree Strategy (TATS), and suggest its algorithm for the way to aggregate the time-varying data that is changed by the time when the temporal view is created. In addition, The TATS and the materialized view creation method of the existing data warehouse have been evaluated. As a result, the TATS reduces the size of the fact table and it shows a good performance for the comparison factor in case of processing the query for time-varying data.

  • PDF

Real-time Disparity Acquisition Algorithm from Stereoscopic Image and its Hardware Implementation (스테레오 영상으로부터의 실시간 변이정보 획득 알고리듬 및 하드웨어 구현)

  • Shin, Wan-Soo;Choi, Hyun-Jun;Seo, Young-Ho;Kim, Dong-Wook
    • The Journal of Korean Institute of Communications and Information Sciences
    • /
    • v.34 no.11C
    • /
    • pp.1029-1039
    • /
    • 2009
  • In this paper, the existing disparity aquisition algorithms were analyzed, on the bases of which a disparity generation technique that is superior in accuracy to the generation time was proposed. Basically it uses a pixel-by-pixel motion estimation technique. It has a merit of possibility of a high-speed operation. But the motion estimation technique has a disadvantage of lower accuracy because it depends on the similarity of the matching window regardless of the distribution characteristics of the texture in an image. Therefore, an enhanced technique to increase the accuracy of the disparity is required. This paper introduced a variable-sized window matching technique for this requirement. By the proposed technique, high accuracies could be obtained at the homogeneous regions and the object edges. A hardware to generate disparity image was designed, which was optimized to the processing speed so that a high throughput is possible. The hardware was designed by Verilog-HDL and synthesized using Hynix $0.35{\mu}m$ CMOS cell library. The designed hardware was operated stably at 120MHz using Cadence NC-VerilogTM and could process 15 frames per second at this clock frequency.

Spatial Join based on the Transform-Space View (변환공간 뷰를 기반으로한 공간 조인)

  • 이민재;한욱신;황규영
    • Journal of KIISE:Databases
    • /
    • v.30 no.5
    • /
    • pp.438-450
    • /
    • 2003
  • Spatial joins find pairs of objects that overlap with each other. In spatial joins using indexes, original-space indexes such as the R-tree are widely used. An original-space index is the one that indexes objects as represented in the original space. Since original-space indexes deal with sizes of objects, it is difficult to develop a formal algorithm without relying on heuristics. On the other hand, transform-space indexes, which transform objects in the original space into points in the transform space and index them, deal only with points but no sites. Thus, spatial join algorithms using these indexes are relatively simple and can be formally developed. However, the disadvantage of transform-space join algorithms is that they cannot be applied to original-space indexes such as the R-tree containing original-space objects. In this paper, we present a novel mechanism for achieving the best of these two types of algorithms. Specifically, we propose a new notion of the transform-space view and present the transform-space view join algorithm(TSVJ). A transform-space view is a virtual transform-space index based on an original-space index. It allows us to interpret on-the-fly a pre-built original-space index as a transform-space index without incurring any overhead and without actually modifying the structure of the original-space index or changing object representation. The experimental result shows that, compared to existing spatial join algorithms that use R-trees in the original space, the TSVJ improves the number of disk accesses by up to 43.1% The most important contribution of this paper is to show that we can use original-space indexes, such as the R-tree, in the transform space by interpreting them through the notion of the transform-space view. We believe that this new notion provides a framework for developing various new spatial query processing algorithms in the transform space.

Experimental Study on Artificial Crack Healing for Concrete Using Electrochemical Deposition Method (전기화학적 전착기법을 활용한 콘크리트의 인공 균열치유에 관한 실험적 연구)

  • Lee, Chang-Hong;Song, Ha-Won
    • Journal of the Korea Concrete Institute
    • /
    • v.21 no.4
    • /
    • pp.409-417
    • /
    • 2009
  • In this study, autogenous crack healing and artificial crack healing using electrochemical electro deposition method were conducted to compare in the aspects of corrosion monitoring. Furthermore, the analysis of impressed voltage characteristics, galvanic current and linear polarization resistance comparison, and photo image processing technique were performed for quantitative comparisons of healing ratio. As a result, it was found that, in view of impressed voltage of artificial crack healing, the measured voltage was increased as time goes by. From the galvanic test results of artificial crack healing, the current vs. potential distribution value were formed widely in comparison with autogenous crack healing. In this point, it was shown that artificial crack healing has more eleatic resistance capacity than autogenous crack healing technique. Finally, it was found that artificial crack healing was 1.63 times higher than autogenous healing in view of crack healing ratio.

Vision-Based High Accuracy Vehicle Positioning Technology (비전 기반 고정밀 차량 측위 기술)

  • Jo, Sang-Il;Lee, Jaesung
    • The Journal of Korean Institute of Communications and Information Sciences
    • /
    • v.41 no.12
    • /
    • pp.1950-1958
    • /
    • 2016
  • Today, technique for precisely positioning vehicles is very important in C-ITS(Cooperative Intelligent Transport System), Self-Driving Car and other information technology relating to transportation. Though the most popular technology for vehicle positioning is the GPS, its accuracy is not reliable because of large delay caused by multipath effect, which is very bad for realtime traffic application. Therefore, in this paper, we proposed the Vision-Based High Accuracy Vehicle Positioning Technology. At the first step of proposed algorithm, the ROI is set up for road area and the vehicles detection. Then, center and four corners points of found vehicles on the road are determined. Lastly, these points are converted into aerial view map using homography matrix. By analyzing performance of algorithm, we find out that this technique has high accuracy with average error of result is less than about 20cm and the maximum value is not exceed 44.72cm. In addition, it is confirmed that the process of this algorithm is fast enough for real-time positioning at the $22-25_{FPS}$.

A Study on the Internet Broadcasting Image Processing based on Offloading Technique on the Mobile Environments (모바일 환경에서 오프로딩 기술 기반 인터넷 방송 영상 처리에 관한 연구)

  • Kang, Hong-gue
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.18 no.6
    • /
    • pp.63-68
    • /
    • 2018
  • Offloading is a method of communicating, processing, and receiving results from some of the applications performed on local computers to overcome the limitations of computing resources and computational speed.Recently, it has been applied in mobile games, multimedia data, 360-degree video processing, and image processing for Internet broadcasting to speed up processing and reduce battery consumption in the mobile computing sector. This paper implements a viewer that enables users to convert various flat-panel images and view contents in a wireless Internet environment and presents actual results of an experiment so that users can easily understand the images. The 360 degree spherical image is successfully converted to a plane image with Double Panorama, Quad, Single Rectangle, 360 Overview + 3 Rectangle depending on the image acquisition position of the 360 degree camera through the interface. During the experiment, more than 100 360 degree spherical images were successfully converted into plane images through the interface below.

A Case Study of Platform Migration for an Object-Oriented CASE tool : OODesigner (객체지향 CASE 도구 OODesigner의 플랫폼 이식 사례 연구)

  • Hong, Euy-Seok;Kim, Tae-Gyun
    • The Transactions of the Korea Information Processing Society
    • /
    • v.7 no.9
    • /
    • pp.2857-2866
    • /
    • 2000
  • As software technology has made progress, object-oriented CASE tools have become more important. This paper presents the process and similarity in design and implementation of OODesigner, an object-oriented CASE tool, on three platfonns and outlines a kind of generic architecture for the design and the implementation of CASE tools. OODesigner is a tool that was initially developed to support OMT. An initial Unix version has been developed since 1994. In 1997, after the completion of the Unix version, we began developing a Java version and a Windows version supporting UML. The development of a CASE tool is a typical application of the Model-View-ControllerO'vIVC) paradigm. Thus, we obtained a common design pattern among the versions in the MVC point of views. This design similarity can be used to develop several kinds of CASE tools with the corresponding design notations.

  • PDF

High Accurate Cup Positioning System for a Coffee Printer (커피 프린터를 위한 커피 잔 정밀 측위 시스템)

  • Kim, Heeseung;Lee, Jaesung
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.21 no.10
    • /
    • pp.1950-1956
    • /
    • 2017
  • In food-printing field, precise positioning technique for a printing object is very important. In this paper, we propose cup positioning method for a latte-art printer through image processing. A camera sensor is installed on the upper side of the printer, and the image obtained from this is projected and converted into a top-view image. Then, the edge lines of the image is detected first, and then the coordinate of the center and the radius of the cup are detected through a Circular Hough transformation. The performance evaluation results show that the image processing time is 0.1 ~ 0.125 sec and the cup detection rate is 92.26%. This means that a cup is detected almost perfectly without affecting the whole latte-art printing time. The center point coordinates and radius values of cups detected by the proposed method show very small errors less than an average of 1.5 mm. Therefore, it seems that the problem of the printing position error is solved.

A Study on the Cheongshimru and Landscape Structure of Yeoju-Palkyung in Old Poems and Map (누정제영시와 고지도에 투영된 청심루와 여주팔경의 경관구조)

  • Rho, Jae-Hyun;Park, Tae-Hie
    • Journal of the Korean Institute of Traditional Landscape Architecture
    • /
    • v.29 no.2
    • /
    • pp.73-80
    • /
    • 2011
  • The study reviewed the content and the meaning of the present Yeoju Palkyung(eight scenery) through analyzing and interpreting the Palkyung poems, old maps and paintings, and classic materials transmitted in Yeoju area, and investigated the landscape structure of the area around the Cheongshimru(淸心樓: pavilion). On the other hand, many Palkyung poems and Noojeongjeyong(樓亭) poems illustrating the Cheongshimru as the view point or the objective have clarified the scenic excellence when the Cheongshimru is the view point. The Yeoju Palkyung viewed from the Cheongshimru was described as constructing all around allocation structure, and six scenes are categorized as a distant view of the visual influence while the 7th scene Ireungdogyeon and the 8th scene Pasagwau are a psychologically influencing landscapes. The panoramic composition of the Yeoju Palkyung at the Cheongshimru is interpreted as the Seunggyeong distribution considering Palchaejigyeongsaek(八采之景色), where main viewpoint is the Cheongshimru and the distant landscape is Paldaejangrim. The reputation of the Cheongshimru, the central place of the Yeoju Palkyung, is confirmed by the technique of scene processing describing a various way of illustrating landscapes such as near view, distant view, pulling view and collecting view. The restoration of Cheongshimru and Paldaesup(八大藪) currently undertaken is the essential business for the full recovery of the Yeoju Palkyung, which will be not only for physical restoration but also for the shortcut to revitalize the history and the spirit of Yeoju. Furthermore, the business direction should be reconsidered to truly understand the meaning, the value, and the structure of the Yeoju Palkyung to ensure the pursuit of the sustainability aiming at the project "Local attractions", one of the Namhangnag Four rivers project of the ministry of Land, Transport and Maritime Affairs.

Expressional Characteristics of Modern Fashion Applied Superimposition (중첩을 응용한 현대 패션의 표현적 특성)

  • Kim Hyun-Mi;Yim Ji-Young;Jang Ae-Ran
    • Journal of the Korean Society of Costume
    • /
    • v.56 no.1 s.100
    • /
    • pp.121-130
    • /
    • 2006
  • Superimposition is a transforming technique that can facilitate the creation. Superimposition in previous studies, however, has only been fragmentary described as an expression technique, so the studies have not been conducted on the basis of its aesthetic value. The purpose of this study is to investigate how superimposition is applied and expressed in terms of forms of modern fashion based on multi-dimensional features of design processing. The codes of togetherness, ambivalence, sense of space and tension in dress were determined by using the expressional Superimposition. The forms of superimposition were limited to superimposition of clothing, superimposition of body and clothing and superimposition of body and Phenomenal body. This study found that superimposition has developed, in fashion forms/types, a new 'form' by overlapping various forms and thus provides a visual shock and a sense of mystery by using mismatched and arbitrary properties among the forms. Such a superimposition influences a methodology of fashion design through a designer's subjective tendencies, as well as influences a change in the view of the world. Also, a superimposition is expected to have a definite influence on new fashion trends.