• Title/Summary/Keyword: aggregate data

Search Result 672, Processing Time 0.028 seconds

On Efficient Processing of Multidimensional Temporal Aggregates In Temporal Databases (시간지원 데이타베이스에서 다차원 시간 집계 연산의 효율적인 처리 기법)

  • 강성탁;정연돈;김명호
    • Journal of KIISE:Databases
    • /
    • v.29 no.6
    • /
    • pp.429-440
    • /
    • 2002
  • Temporal databases manage time-evolving data. They provide built-in supports for efficient recording and querying of temporal data. The temporal aggregate in temporal databases is an extension of the conventional aggregate to include time concept on the domain and range of aggregation. This paper focuses on multidimensional temporal aggregation. In a multidimensional temporal aggregate, we use one or more general attributes as well as a time attribute on the range of aggregation, thus it is a useful operation for historical data warehouse, Call Data Records(CDR), etc. In this paper, we propose a structure for multidimensional temporal aggregation, called PTA-tree, and an aggregate processing method based on the PTA-tree. Through analyses and performance experiments, we also compare the PTA-tree with the simple extension of SB-tree that was proposed for temporal aggregation.

An Integrated Analysis of Recent Changes in Year-on-Year Consumer Price Index and Aggregate Import Price Index in Republic of Korea through Statistical Inference

  • Seok Ho CHANG;Soonhui LEE
    • Asia-Pacific Journal of Business
    • /
    • v.14 no.1
    • /
    • pp.365-379
    • /
    • 2023
  • Purpose - Our previous study (Chang & Lee, 2023) presented observations on the recent changes in the year-on-year (YoY) Consumer Price Index (CPI) of the Republic of Korea (ROK) after the COVID-19 pandemic. The purpose of this article is to present an integrated analysis and interpretation of the recent changes in CPI and the Aggregate Import Price Index (IPI) by incorporating recent data, specifically data from September 2022 to December 2022. Design/methodology/approach - This study collected CPI (YoY) data in the ROK from January 2019 to December 2022 using e-National Indicator System provided by the ROK. Statistical analysis was employed to analyze the data. Findings - First, we confirm the extended results of the existing study by Chang and Lee (2023). Second, we demonstrate that the Aggregate IPI in ROK increased significantly in 2022 compared to 2021. We then provide an integrated interpretation on the significant increase in CPI and aggregate IPI in ROK, which complements Chang and Lee (2023) that limits their discussion to YoY CPI. Moreover, we show that the IPI of the semiconductor in ROK decreased significantly in 2022 compared to 2021. Research implications or Originality - Our results provide important insights into the recent changes in the CPI in the ROK. The results suggest that these changes can be partially attributed to various factors, such as the global supply chain disruptions resulting from the spread of the COVID-19 pandemic and the prolonged war between Russia and Ukraine, the side effect of quantitative easing by the US Federal Reserve, heat waves and droughts caused by climate change in ROK, a surge in demand following a gradual daily recovery, US-China trade conflict, etc. Our study shows statistically comprehensive results compared to the studies that limit their discussion to YoY average growth rate.

Sources of Trade Balance Dynamics in Korea

  • Kim, Jiwoon;Yu, Jongmin
    • Journal of Korea Trade
    • /
    • v.26 no.2
    • /
    • pp.21-44
    • /
    • 2022
  • Purpose - This study quantifies sources of trade balance dynamics over the business cycle in Korea. Specifically, we quantify the relative importance of domestic and foreign factors on trade balance dynamics using a small open economy real business cycle (SOE-RBC) model and provide policy implications for stabilization policies. Aggregate productivity and interest rate spreads are considered domestic factors affecting the trade balance. A world interest rate (the U.S. interest rate) is considered a foreign factor. Design/methodology - Following Neumeyer and Perri (2005), we build the SOE-RBC model with three types of shocks: aggregate productivity, interest rate spread, and world interest shocks. The model is estimated by the generalized method of moments (GMM) using relevant business cycle statistics. The estimated model is used for quantifying the relative importance of domestic and foreign factors on trade balance dynamics in Korea. Findings - Our main findings can be summarized as follows: 85.64% of the trade balance fluctuations in Korea are explained by domestic factors, the remaining 14.35% by foreign factors. Particularly, trade balance dynamics are mostly accounted for by the change in aggregate productivity shocks (85.58%). World interest rate shocks considerably explain trade balance (14.35%), whereas the role of interest rate spread shocks that represent domestic risks is limited (0.08%). Although aggregate productivity is key in explaining trade balance dynamics in Korea, interest rates still have an essential role. This is because aggregate productivity changes induce interest rate spread variations and, thus, the trade balance significantly. The results suggest that government policies mitigating fluctuations in aggregate productivity would be effective for stabilization policies in Korea by reducing the trade balance volatility. Originality/value - Existing studies on the emerging market business cycle examine mostly Latin American countries, and the main object of the studies is the volatility of consumption rather than trade balance dynamics. Conversely, our study examines Korea rather than Latin American countries. Additionally, we examine sources of trade balance dynamics, which are relatively more important in Korea, rather than those of the volatility of consumption. Hence, we estimate the model to explicitly match moments related to trade balance in the data.

Tissue Transglutaminase is Not Involved in the Aggregate Formation of Stably Expressed $\alpha$-Synuclein in SH-SY5Y Human Neuroblastoma Cells

  • Suh, Myung-Duk;Park, Chang-Ha;Kim, Sung-Soo;Kil, Myeng-Og;Lee, Geon-Hee;Johnson, Gail V. W.;Chun, Wan-Joo
    • Archives of Pharmacal Research
    • /
    • v.27 no.8
    • /
    • pp.850-856
    • /
    • 2004
  • Intraneuronal deposition containing $\alpha$-synuclein is implicated in the pathogenesis of synuclein-opathies including Parkinsons disease (PD). Although it has been demonstrated that cytoplas-mic inclusions of wild type $\alpha$-synuclein are observed in the brain of PD patients and that $\alpha$-synuclein mutations such as A30P and A53T accelerate aggregate formation, the exact mech-anism by which $\alpha$-synuclein forms insoluble aggregates is still controversial. In the present study, to understand the possible involvement of tissue transglutaminase (tTG) in aggregate formation of $\alpha$-synuclein, SH-SY5Y cell lines stably expressing wild type or mutant (A30P or A53T) $\alpha$-synuclein were created and aggregate formation of $\alpha$-synuclein was observed upon activation of tTG. The data demonstrated that $\alpha$-synuclein negligibly interacted with tTG and that activation of tTG did not result in the aggregate formation of $\alpha$-synuclein in SH-SY5Y cells overexpressing either wild type or mutant $\alpha$-synuclein. In addition, $\alpha$-synuclein was not modi-fied by activated tTG in situ. These data suggest that tTG is unlikely to be a contributing factor to the formation of aggregates of $\alpha$-synuclein in a stable cell model.

Removal Characteristics of Mixed Heavy Metals from Aqueous Solution by Recycled Aggregate as Construction Waste (건설폐기물인 순환골재를 이용한 수용액상에서의 혼합 중금속 제거 특성)

  • Shin, Woo-Seok;Kim, Young-Kee
    • Journal of the Korean Society for Marine Environment & Energy
    • /
    • v.16 no.2
    • /
    • pp.115-120
    • /
    • 2013
  • This study examined the removal rate of mixed heavy metals from aqueous solution using recycled aggregate. The recycled aggregate is favorable for the absorbent because it contains about 95% (CaO, $SiO_2$, $Al_2O_3$ and $Fe_2O_3$), which are major ingredient of adsorbent for heavy metal. The kinetic data presented that the slow course of adsorption follows the Pseudo first and second order models. The equilibrium data were well fitted by the Langmuir model and showed the affinity order: $Cu^{2+}$ > $Pb^{2+}$ > $$Zn^{2+}{\simeq_-}Ni^{2+}$$ > $Cd^{2+}$. The results also showed that adsorption rate slightly increased with increasing pH from 6 to 10. Moreover, this trend is similar to results obtained as function of loading amount of recycled aggregate. Meanwhile, an unit adsorption rate was slightly decreased. From these results, it was concluded that the absorbents can be successfully used the removal of the heavy metals from the aqueous solutions.

On Efficient Processing of Temporal Aggregates in Temporal Databases (시간지원데이타베이스에서의 효과적인 시간지원집계 처리 기법)

  • Gang, Seong-Tak;Kim, Jong-Su;Kim, Myeong-Ho
    • Journal of KIISE:Software and Applications
    • /
    • v.26 no.12
    • /
    • pp.1418-1427
    • /
    • 1999
  • 시간지원 데이타베이스 시스템은 자료의 과거 및 현재, 그리고 미래의 상태까지 관리함으로써, 사용자에게 시간에 따라 변화하는 자료에 대한 저장 및 질의 수단을 제공한다. 시간지원 데이타베이스는 경향 분석, 버전 관리, 의료 기록 관리 및 비디오 데이타 관리 등과 같이 자료의 시간적 특성이 중요시 되는 모든 분야에 폭 넓게 응용될 수 있다. 시간지원 데이타베이스에서의 집계는 시간 애트리뷰트를 고려하지 않은 기존의 집계와는 큰 차이가 있으며, 기존의 집계 처리 기법을 이용하여 효과적으로 처리될 수 없다. 본 논문에서는 시간지원 집계를 효율적으로 처리하기 위한 새로운 자료 구조인 PA-트리를 제안하고, 이를 이용한 시간지원 집계 처리 기법을 제안한다. 또한 본 논문에서는 제안된 PA-트리를 이용한 기법과 기존의 집계 트리를 이용한 기법의 성능을 최악 경우 분석과 실험을 통해 비교한다.Abstract Temporal databases manage time-evolving data. They provide built-in supports for efficient recording and querying of temporal data. Many application area such as trend analysis, version management, and medical record management have temporal aspects, and temporal databases can handle these temporal aspects efficiently. The aggregate in temporal databases, that is, temporal aggregate is an extension of conventional aggregate on the domain and range of aggregation to include time concept. The basic techniques behind computing aggregates in conventional databases are not efficient when applied to temporal databases. In this paper, we propose a new tree structure for temporal aggregation, called PA-tree, and aggregate processing method based on the PA-tree. We compare the PA-tree with the existing aggregation tree which has been proposed for temporal aggregate.

A new formulation for strength characteristics of steel slag aggregate concrete using an artificial intelligence-based approach

  • Awoyera, Paul O.;Mansouri, Iman;Abraham, Ajith;Viloria, Amelec
    • Computers and Concrete
    • /
    • v.27 no.4
    • /
    • pp.333-341
    • /
    • 2021
  • Steel slag, an industrial reject from the steel rolling process, has been identified as one of the suitable, environmentally friendly materials for concrete production. Given that the coarse aggregate portion represents about 70% of concrete constituents, other economic approaches have been found in the use of alternative materials such as steel slag in concrete. Unfortunately, a standard framework for its application is still lacking. Therefore, this study proposed functional model equations for the determination of strength properties (compression and splitting tensile) of steel slag aggregate concrete (SSAC), using gene expression programming (GEP). The study, in the experimental phase, utilized steel slag as a partial replacement of crushed rock, in steps 20%, 40%, 60%, 80%, and 100%, respectively. The predictor variables included in the analysis were cement, sand, granite, steel slag, water/cement ratio, and curing regime (age). For the model development, 60-75% of the dataset was used as the training set, while the remaining data was used for testing the model. Empirical results illustrate that steel aggregate could be used up to 100% replacement of conventional aggregate, while also yielding comparable results as the latter. The GEP-based functional relations were tested statistically. The minimum absolute percentage error (MAPE), and root mean square error (RMSE) for compressive strength are 6.9 and 1.4, and 12.52 and 0.91 for the train and test datasets, respectively. With the consistency of both the training and testing datasets, the model has shown a strong capacity to predict the strength properties of SSAC. The results showed that the proposed model equations are reliably suitable for estimating SSAC strength properties. The GEP-based formula is relatively simple and useful for pre-design applications.

Phenomenological Model to Re-proportion the Ambient Cured Geopolymer Compressed Blocks

  • Radhakrishna, Radhakrishna;Madhava, Tirupati Venu;Manjunath, G.S.;Venugopal, K.
    • International Journal of Concrete Structures and Materials
    • /
    • v.7 no.3
    • /
    • pp.193-202
    • /
    • 2013
  • Geopolymer mortar compressed blocks were prepared using fly ash, ground granulated blast furnace slag, silica fume and metakaolin as binders and sand/quarry dust/pond ash as fine aggregate. Alkaline solution was used to activate the source materials for synthesizing the geopolymer mortar. Fresh mortar was used to obtain the compressed blocks. The strength development with reference to different parameters was studied. The different parameters considered were fineness of fly ash, binder components, type of fine aggregate, molarity of alkaline solution, age of specimen, fluid-to-binder ratio, binder-to-aggregate ratio, degree of saturation, etc. The compressed blocks were tested for compression at different ages. It was observed that some of the blocks attained considerable strength within 24 h under ambient conditions. The cardinal aim was to analyze the experimental data generated to formulate a phenomenological model to arrive at the combinations of the ingredients to produce geopolymer blocks to meet the strength development desired at the specified age. The strength data was analyzed within the framework of generalized Abrams' law. It was interesting to note that the law was applicable to the analysis of strength development of partially saturated compressed blocks when the degree of saturation was maintained constant. The validity of phenomenological model was examined with an independent set of experimental data. The blocks can replace the traditional masonry blocks with many advantages.

Aggregate Planning Using Least Cost First Assignment Algorithm of Transportation Problem (운송 문제의 최소비용 우선 배정 알고리즘을 적용한 총괄계획)

  • Lee, Sang-Un
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.21 no.5
    • /
    • pp.181-188
    • /
    • 2021
  • In preparing a aggregate production plan(APP), the transportation method generally uses a linear planning(LP) software package for TSM(transportation simplex method), which seeks initial solutions with either NCM, LCM, or VAM specialized in transportation issues and optimizes them with either SSM or MODI. On the other hand, this paper proposes a transportation method that easily, quickly, and accurately prepares a APP without software package assistance. This algorithm proposed simply assigned to least cost-first, and minimized the inventory periods. Applying the proposed algorithm to 6-benchmarking data, this algorithm can be obtained better optimal solution than VAM or LP for 4 data, and we obtain the same results for the remained 2 data.

An Experimental Study on the Properties of Engineering and Shrinkage Cracking Reduction of Fiber Reinforced Concrete Using Recycled Fine Aggregate (섬유보강 순환잔골재 콘크리트의 공학적 특성 및 수축균열저감특성에 관한 실험적 연구)

  • Kim, Gyu-Yong;Nam, Jeong-Soo;Kim, Moo-Han;Lee, Do-Heun;Song, Ha-Young
    • Journal of the Korean Recycled Construction Resources Institute
    • /
    • v.4 no.3
    • /
    • pp.82-89
    • /
    • 2009
  • Recently, the study is progressing actively about manufacture skill of concrete for promoted recycled aggregate and concrete made into recycled aggregate in the construction production field. But, application and study about recycled fine aggregate insufficient compared to recycled coarse aggregate. So, in this study, it presents basic data for development of environmental load reduction fiber reinforcement recycled fine aggregate concrete by comparison and investigation about engineering properties and shrinkage cracking of fiber reinforcement recycled find aggregate concrete for increasing shrinkage cracking reduction and long term stability of environmental load reduction concrete used recycled fine aggregate. In the result of the study, compared to natural fine aggregate, a crack-extent increased by applying recycled fine aggregate, moreover, as a water cement ratio increased, the crack size increased, as well. In addition, it's shown that the specimen mixed with PVA and Nylon, among all kinds of fibers, showed the smallest crack size, so it's verified that the mix of fiber had an effect on decreasing crack-extent.

  • PDF