• Title/Summary/Keyword: aggregate data

Search Result 672, Processing Time 0.028 seconds

Load Shedding Method based on Grid Hash to Improve Accuracy of Spatial Sliding Window Aggregate Queries (공간 슬라이딩 윈도우 집계질의의 정확도 향상을 위한 그리드 해쉬 기반의 부하제한 기법)

  • Baek, Sung-Ha;Lee, Dong-Wook;Kim, Gyoung-Bae;Chung, Weon-Il;Bae, Hae-Young
    • Journal of Korea Spatial Information System Society
    • /
    • v.11 no.2
    • /
    • pp.89-98
    • /
    • 2009
  • As data stream is entered into system continuously and the memory space is limited, the data exceeding the memory size cannot be processed. In order to solve the problem, load shedding methods which drop a part of data to prevent exceeding the storage space have been researched. Generally, a traditional load shedding method uses random sampling with optimized rate according to data deviation. The method samples data not to distinguish those used in spatial query because the method uses only a random sampling with optimized rate according to data deviation. Therefore, the accuracy of query was reduced in u-GIS environment including spatial query. In this paper, we researched a new load shedding method improving accuracy of the query in u-GIS environment which runs spatial query and aspatial query simultaneously. The method uses a new sampling method that samples data having low probability used in query. Therefore proposed method improves spatial query accuracy and query processing speed as applying spatial filtering operation to sampling operator.

  • PDF

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

An Experimental Study on the Strength Properties and Durability Performance of Recycled Concrete with Water to Cement Ratio and Unit Water Content (물시멘트비 및 단위수량에 따른 순환콘크리트의 강도 특성과 내구성능에 관한 실험적 연구)

  • Kim, Young-Sun;Kim, Jung-Jin;Seok, Won-Kyun;Lee, Joo-Ho;Kim, Gyu-Yong
    • Journal of the Korean Recycled Construction Resources Institute
    • /
    • v.6 no.3
    • /
    • pp.88-93
    • /
    • 2011
  • To resolve the problem which is demand and supply imbalance of fine aggregate by the shortage of natural fine aggregate and the environment regulations, the studies for the application of recycled fine aggregate made from waste concrete have been recently carried out. The objective of this study is to shed light on the mechanical properties and durability performance of concrete using recycle fine aggregate with various water to cement ratios and unit water contents. And it is intend to propose the fundamental data for structural application of recycled concrete. In particular, the effects according to the variations of water to cement ratios and unit water contents in recycled concrete with recycled fine aggregate replacement of 100 percent are discussed by the test results, such as air content, slump, time of set, compressive strength, tensile strength, carbonation, chloride penetration.

  • PDF

Uniaxial Behavior of Reinforced Concrete Column with Recycled Fine Aggregate (순환잔골재를 치환한 철근콘크리트 기둥의 압축거동 특성)

  • Jang, Gwang-Soo;Kim, Yun-Su;Yun, Hyun-Do;Choi, Ki-Sun;You, Young-Chan;Kim, Keung-Hwan
    • Proceedings of the Korea Concrete Institute Conference
    • /
    • 2008.04a
    • /
    • pp.5-8
    • /
    • 2008
  • The use of recycled aggregates is increasing due to problems of lack of natural aggregates. But there are no appropriate design recommendations and basic data for structural members using recycled fine aggregate concrete. This paper is to evaluate compression behavior of reinforced concrete column with displacement level of recycled fine aggregate. For these purpose, four recycled fine aggregate replacement levels (0%, 30%, 60%, 100%) were considered in this paper. Four columns with 400mm${\times}$400mm in cross section are tested under axial load. Experimental results were compared using current code(KCI2007). Compressive strength of reinforced concrete columns with recycled fine aggregate showed higher than that provided in KCI 2007. The KCI provision were conservative and subsequently can be used for design of reinforced recycled fine aggregate concrete column.

  • PDF

A Study on the Strength Properties and Life Cycle Assessment of Recycled Fine Aggregate Concrete (순환잔골재 혼입 콘크리트의 강도 특성 및 전과정 환경영향 평가 연구)

  • Choi, Won-Young;Kim, Sang-Heon;Lee, Sea-Hyun;Jeon, Chan-Soo
    • Journal of the Korean Recycled Construction Resources Institute
    • /
    • v.7 no.2
    • /
    • pp.123-130
    • /
    • 2019
  • The purpose of this study is to confirm the strength characteristics of concrete according to the mixing ratio of recycled fine aggregates and to use it as basic data for the use of recycled fine aggregates in concrete. For this purpose, the target design compression strength was set at 27MPa. Considering practical use of recycled aggregate, the mixing ratio of recycled fine aggregate was set at 0, 30, 60, and 100%, and the unconfined concrete and hardened concrete were tested. The LCA method was used to evaluate the environmental impact of recycled fine aggregate concrete, and the effectiveness of recycled fine aggregate in the production of concrete was verified.

Constructing Database and Probabilistic Analysis for Ultimate Bearing Capacity of Aggregate Pier (쇄석다짐말뚝의 극한지지력 데이터베이스 구축 및 통계학적 분석)

  • Park, Joon-Mo;Kim, Bum-Joo;Jang, Yeon-Soo
    • Journal of the Korean Geotechnical Society
    • /
    • v.30 no.8
    • /
    • pp.25-37
    • /
    • 2014
  • In load and resistance factor design (LRFD) method, resistance factors are typically calibrated using resistance bias factors obtained from either only the data within ${\pm}2{\sigma}$ or the data except the tail values of an assumed probability distribution to increase the reliability of the database. However, the data selection approach has a shortcoming that any low-quality data inadvertently included in the database may not be removed. In this study, a data quality evaluation method, developed based on the quality of static load test results, the engineering characteristics of in-situ soil, and the dimension of aggregate piers, is proposed for use in constructing database. For the evaluation of the method, a total 65 static load test results collected from various literatures, including static load test reports, were analyzed. Depending on the quality of the database, the comparison between bias factors, coefficients of variation, and resistance factors showed that uncertainty in estimating bias factors can be reduced by using the proposed data quality evaluation method when constructing database.

A system's approach for an aggregate control of order entry-production schedule-shippment cycle (수주-생산-출하관리의 효율성제고 종합방안)

  • Jeong, Byeong-Hui;Yeo, Sang-Hwan;Lee, Myeon-U;Yun, Jo-Deok
    • Journal of Korean Institute of Industrial Engineers
    • /
    • v.7 no.2
    • /
    • pp.43-54
    • /
    • 1981
  • In a complex production system, the efficient control of order entry-production schedule-shippment cycle is one of the most important managerial aspects. In this paper, an aggregate control mechanism has been developed. The result showed steps for improving and for optimizing the total systems efficiency. A simplified guidelines for a con ceptual data base has been suggested.

  • PDF

An Experimental Study on The Effect of Mixed Sand Used Sea and River Sand as Fine Aggregate of Concrete (해사와 강모래의 혼합재를 사용한 콘크리트에 관한 실험적 연구)

  • 남상일;김문한;김무한
    • Proceedings of the Korea Concrete Institute Conference
    • /
    • 1992.10a
    • /
    • pp.31-36
    • /
    • 1992
  • This paper, an experimental study on the effect of mixed sand used sea and river as fine aggregate of concrete, is connected with the properties of fresh and hardended concrete and steel corrosion to investigate workability and engineering properties and general steel bar's corrosion of concrete used mixed sand. After analyzing positively fresh and hardenend concrete and ratio of the corrosion area affected by the autoclave cycle, the purpose of this paper is to provide an experimental data developing concrete used mixed sand.

  • PDF

Priority Aggregation for AHP Based on Experts Opinions (AHP 가중치 결정에서의 다수 전문가 의견종합 방법)

  • 김성철;어하준
    • Journal of the Korean Operations Research and Management Science Society
    • /
    • v.19 no.3
    • /
    • pp.41-51
    • /
    • 1994
  • The Analytic Hierarchy Process (AHP) is widely used for evaluation of large projects. If a group of experts with different expertise are involved in a AHP decision, they need some way to aggregate their opinions. In this paper, we suggest a way to aggregate the experts' priorities in a given hierarchy using the concept of the Bayesian decision analysis. A criterion that can be used for screening out unreliable data is introduced, and it is used for priority aggregation. Some numerical results are shown to illustrate the procedure.

  • PDF

An Experimental Study on the Water-Proofing Properties of Cement Mortar with the Grading Variations of Fine Aggregate (잔골재의 입도분포 변화에 따른 시멘트 모르터의 방수특성에 관한 실험적 연구)

  • 윤기원;류현기;한천구
    • Proceedings of the Korea Concrete Institute Conference
    • /
    • 1991.04a
    • /
    • pp.33-36
    • /
    • 1991
  • This study is designed for analyzing the properties of water-proofing on cement mortar according to the using ethylene vinyle acetate emulsion, and the fine aggregate grading such as uniform, gab and continuosly grading. And is aimed for presenting the reference data on the practical use.

  • PDF