• Title/Summary/Keyword: SUM

Search Result 6,206, Processing Time 0.033 seconds

Efficient Processing of MAX-of-SUM Queries in OLAP (OLAP에서 MAX-of-SUM 질의의 효율적인 처리 기법)

  • Cheong, Hee-Jeong;Kim, Dong-Wook;Kim, Jong-Soo;Lee, Yoon-Joon;Kim, Myoung-Ho
    • Journal of KIISE:Databases
    • /
    • v.27 no.2
    • /
    • pp.165-174
    • /
    • 2000
  • Recent researches about range queries in OLAP are only concerned with applying an aggregation operator over a certain region. However, data analysts in real world need not only the simple range query pattern but also an extended range query pattern that finds ranges which satisfy a special condition specified by using several aggregation operators. In this work, we define the general form of the extended range query and propose an efficient processing method for the 'MAX -of-SUM' query, which is the representative form of the extended range query pattern. The MAX-of-SUM query finds the range which has the maximum range sum value in data cube where the size of the range is given. The proposed query processing method is based on the prediction of the scope of the range sum values. That is, the search space on the query processing can be reduced by using the result of the prediction, and hence, the query response time is also reduced.

  • PDF

Prediction of Retention Indices of Various Compounds in Gas-Liquid Chromatography (기체-액체 크로마토그래피에서 화합물의 머무름 지표의 예측에 관한 연구)

  • Cha, Gi Won;Lee, Deok Jae
    • Journal of the Korean Chemical Society
    • /
    • v.38 no.2
    • /
    • pp.108-121
    • /
    • 1994
  • The retention indices of branched-chain alkane, benzene ring, alcohol, amine, ketone, aldehyde and cyclic compounds were measured at 150, 180 and $210^{\circ}C$ on OV-1701 and OV-1 capillary columns. The group retention factors (GRF) of the substituents and the st` ructure retention factors (SRF) of the molecular structure change are derived from the retention indices of reference compounds and series of homologues. The $GRF_f$ equation of `f'th substituent is $GRF_f\;=\;I_{obs}-(100Z + \sum\limits_{i{\neq}f}GRF_i$ + {\sum}$SRF_i$)and the SRFf equation of `f'th molecular structure group is $SRF_f\;=\;I_{obs}-(100Z + {\sum}GRFi + \sum\limits_{i{\neq}f}SRF_i$). The predicted retention indices for those compound were in agreement, within the error of $\pm2$ and $\pm3%$, with the observed values that were obtained using the OV-1701 and OV-1 capillary column, respectively. The $\Delta$ xi of the substituents and $\Delta$ yi of the molecular structure change according to temperature change are derived from the $\Delta'/^{\circ}C$ of reference compounds and series of homologues. The $\Delta$ xi equation of the `f'th substituent is ${\Delta}x_f = {$\Delta}'/^{\circ}C+ \sum\limits_{i{\neq}f}\Delta$ xi + {\sum}{\Delta}yi\;and\;{\Delta}yi$ equation of the `f'th molecular structure group is ${\Delta}y_f$ = {\Delta}'/^{\circ}C+{\sum}{\Delta}xi +\sum\limits_{i{\neq}f}{\Delta}yi$. The predicted $\Delta'/^{\circ}C$ for these compounds were in agreement, within the error of ${\pm}18%$ and 17%, with the observed values that were obtained using the OV-1701 and OV-1 capillary column, respectively.

  • PDF

ON DIRECT SUMS IN BOUNDED BCK-ALGEBRAS

  • HUANG YISHENG
    • Communications of the Korean Mathematical Society
    • /
    • v.20 no.2
    • /
    • pp.221-229
    • /
    • 2005
  • In this paper we consider the decompositions of subdirect sums and direct sums in bounded BCK-algebras. The main results are as follows. Given a bounded BCK-algebra X, if X can be decomposed as the subdirect sum $\bar{\bigoplus}_{i{\in}I}A_i$ of a nonzero ideal family $\{A_i\;{\mid}\;i{\in}I\}$ of X, then I is finite, every $A_i$ is bounded, and X is embeddable in the direct sum $\bar{\bigoplus}_{i{\in}I}A_i$ ; if X is with condition (S), then it can be decomposed as the subdirect sum $\bar{\bigoplus}_{i{\in}I}A_i$ if and only if it can be decomposed as the direct sum $\bar{\bigoplus}_{i{\in}I}A_i$ ; if X can be decomposed as the direct sum $\bar{\bigoplus}_{i{\in}I}A_i$, then it is isomorphic to the direct product $\prod_{i{\in}I}A_i$.

SOLUTION OF A VECTOR VARIABLE BI-ADDITIVE FUNCTIONAL EQUATION

  • Park, Won-Gil;Bae, Jae-Hyeong
    • Communications of the Korean Mathematical Society
    • /
    • v.23 no.2
    • /
    • pp.191-199
    • /
    • 2008
  • We investigate the relation between the vector variable bi-additive functional equation $f(\sum\limits^n_{i=1} xi,\;\sum\limits^n_{i=1} yj)={\sum\limits^n_{i=1}\sum\limits^n_ {j=1}f(x_i,y_j)$ and the multi-variable quadratic functional equation $$g(\sum\limits^n_{i=1}xi)\;+\;\sum\limits_{1{\leq}i<j{\leq}n}\;g(x_i-x_j)=n\sum\limits^n_{i=1}\;g(x_i)$$. Furthermore, we find out the general solution of the above two functional equations.

ON STABILITY OF A GENERALIZED QUADRATIC FUNCTIONAL EQUATION WITH n-VARIABLES AND m-COMBINATIONS IN QUASI-𝛽-NORMED SPACES

  • Koh, Heejeong;Lee, Yonghoon
    • Journal of the Chungcheong Mathematical Society
    • /
    • v.33 no.3
    • /
    • pp.319-326
    • /
    • 2020
  • In this paper, we establish a general solution of the following functional equation $$mf\({\sum\limits_{k=1}^{n}}x_k\)+{\sum\limits_{t=1}^{m}}f\({\sum\limits_{k=1}^{n-i_t}}x_k-{\sum\limits_{k=n-i_t+1}^{n}}x_k\)=2{\sum\limits_{t=1}^{m}}\(f\({\sum\limits_{k=1}^{n-i_t}}x_k\)+f\({\sum\limits_{k=n-i_t+1}^{n}}x_k\)\)$$ where m, n, t, it ∈ ℕ such that 1 ≤ t ≤ m < n. Also, we study Hyers-Ulam-Rassias stability for the generalized quadratic functional equation with n-variables and m-combinations form in quasi-𝛽-normed spaces and then we investigate its application.

CHROMATIC SUMS OF NONSEPARABLE SIMPLE MAPS ON THE PLANE

  • Li, Zhaoxiang;Liu, Yanpei
    • Journal of applied mathematics & informatics
    • /
    • v.12 no.1_2
    • /
    • pp.129-142
    • /
    • 2003
  • In this paper we study the chromatic sum functions for rooted nonseparable simple maps on the plane. The chromatic sum function equation for such maps is obtained . The enumerating function equation of such maps is derived by the chromatic sum equation of such maps. From the chromatic sum equation of such maps, the enumerating function equation of rooted nonseparable simple bipartite maps on the plane is also derived.

DECOMPOSITION OF THE KRONECKER SUMS OF MATRICES INTO A DIRECT SUM OF IRREDUCIBLE MATRICES

  • Gu, Caixing;Park, Jaehui;Peak, Chase;Rowley, Jordan
    • Bulletin of the Korean Mathematical Society
    • /
    • v.58 no.3
    • /
    • pp.637-657
    • /
    • 2021
  • In this paper, we decompose (under unitary similarity) the Kronecker sum A ⊞ A (= A ⊗ I + I ⊗ A) into a direct sum of irreducible matrices, when A is a 3×3 matrix. As a consequence we identify 𝒦(A⊞A) as the direct sum of several full matrix algebras as predicted by Artin-Wedderburn theorem, where 𝒦(T) is the unital algebra generated by Tand T*.

A SUFFICIENT CONDITION FOR THE INTEGRABILITY OF REES-STANOJEVIĆ SUM

  • Ram, Babu
    • Kyungpook Mathematical Journal
    • /
    • v.19 no.2
    • /
    • pp.257-260
    • /
    • 1979
  • We show that the condition S of Sidon is sufficient for the integrability of the limit of Rees-$Stanojevi{\acute{c}$ cosine sums $g_n(x)={\frac{1}{2}}{\limits\sum^{n}_{k=0}}{\Delta}a_k+{\limits\sum^{n}_{k=1}}{\limits\sum^{n}_{j=k}}{\Delta}a_j\;cos\;kx$.

  • PDF