• Title/Summary/Keyword: I-O Table

Search Result 110, Processing Time 0.03 seconds

Skewed Data Handling Technique Using an Enhanced Spatial Hash Join Algorithm (개선된 공간 해쉬 조인 알고리즘을 이용한 편중 데이터 처리 기법)

  • Shim Young-Bok;Lee Jong-Yun
    • The KIPS Transactions:PartD
    • /
    • v.12D no.2 s.98
    • /
    • pp.179-188
    • /
    • 2005
  • Much research for spatial join has been extensively studied over the last decade. In this paper, we focus on the filtering step of candidate objects for spatial join operations on the input tables that none of the inputs is indexed. In this case, many algorithms has presented and showed excellent performance over most spatial data. However, if data sets of input table for the spatial join ale skewed, the join performance is dramatically degraded. Also, little research on solving the problem in the presence of skewed data has been attempted. Therefore, we propose a spatial hash strip join (SHSJ) algorithm that combines properties of the existing spatial hash join (SHJ) algorithm based on spatial partition for input data set's distribution and SSSJ algorithm. Finally, in order to show SHSJ the outperform in uniform/skew cases, we experiment SHSJ using the Tiger/line data sets and compare it with the SHJ algorithm.

Statistical Characteristics of An Advanced Wastewater Treatment Plant for Leather Industry (피혁폐수 고도처리시설의 통계학적 특성)

  • Yang, H.J.;Kwon, O.S.;Kim, J.H.;Kim, S.H.;Lee, S.J.;Jung, D.I.
    • Journal of Korean Society on Water Environment
    • /
    • v.23 no.5
    • /
    • pp.740-747
    • /
    • 2007
  • The advanced wastewater treatment plant of leather industry was selected to evaluated with its effluent water quality and statistical characteristics. Most of pollutants removal efficiencies were over 90% as well. And 95% reliability of effluent concentration were 106.8 mg/L of $COD_{mn}$, 72.04 mg/L of TN. However Effluent quality of TN exceeds the regulated limit. The range of coefficient of variation (CV) were between 0.18 and 2.49. Also, coefficient of reliability (COR) were between $0.03(BOD_5){\sim}0.63(COD_{mn})$ and 0.43 in terms of T-N, $Z_{l-a}$(Normalized Percentiles) value were 55.7 and 2.25 in terms of $BOD_5$ and T-N as shown in the following table.

Centrality Analysis of Industry Sector for National Flagship Industry Selection (국가주력산업 선정을 위한 산업의 중심성 분석)

  • Kim, Sung-Rok;Lee, Jong-Sang
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.17 no.1
    • /
    • pp.615-621
    • /
    • 2016
  • The selection of a flagship industry is based on whether the industry's developmental impact is great and whether the industry can be the center of the national economy. Here, a ripple effect may be derived by analyzing the forward and backward linkage effects, but in the case of industries that are the centerpieces of the national economy, each researcher reported different results. Consequently, they could not agree on their flagship industry despite belonging to the same time. This study presents a prestige centrality of network analysis as a way of analyzing an industry, which was the center of the national economy, and performed empirical analysis utilizing the 2013 I-O Table. The analysis showed that the industries classified as those with high centrality include the energy industry, which is essential for economic development, can create a synergy effect with other industries, such as the transportation industry, industries with a high level of export and employment, such as electronics and chemicals, and industries for domestic demand, such as wholesale and retail, food services and accommodation.

The Variation of Natural Population of Pinus densiflora S. et Z. in Korea (III) -Genetic Variation of the Progeny Originated from Mt. Chu-wang, An-Myon Island and Mt. O-Dae Populations- (소나무 천연집단(天然集團)의 변이(變異)에 관(關)한 연구(硏究)(III) -주왕산(周王山), 안면도(安眠島), 오대산(五臺山) 소나무집단(集團)의 차대(次代)의 유전변이(遺傳變異)-)

  • Yim, Kyong Bin;Kwon, Ki Won
    • Journal of Korean Society of Forest Science
    • /
    • v.32 no.1
    • /
    • pp.36-63
    • /
    • 1976
  • The purpose of this study is to elucidate the genetic variation of the natural forest of Pinus densiflora. Three natural populations of the species, which are considered to be superior quality phenotypically, were selected. The locations and conditions of the populations are shown in table 1 and 2. The morphological traits of tree and needle and some other characteristics were presented already in our first report of this series in which population and family differences according to observed characteristics were statistically analyzed. Twenty trees were sampled from each populations, i.e., 60 trees in total. During the autumn of 1974, matured cones were collected from each tree and open-pollinated seeds were extracted in laboratory. Immediately after cone collection, in closed condition, the morphological characteristics were measured. Seed and seed-wing dimensions were also studied. In the spring of 1975, the seeds were sown in the experimental tree nursery located in Suweon. And in the April of 1976, the 1-0 seedlings were transplanted according to the predetermined experimental design, randomized block design with three replications. Because of cone setting condition. the number of family from which progenies were raised by populations were not equal. The numbers of family were 20 in population 1. 18 in population 2 and 15 in population 3. Then, each randomized block contained seedlings of 53 families from 3 populations. The present paper is mainly concerned with the variation of some characteristics of cone, seed, needle, growth performance of seedlings, and chlorophyll and monoterpene compositions of needles. The results obtained are summerized as follows. 1. The meteorological data obtained by averaging the records of 30 year period, observed from the nearest station to each location of populations, are shown in Fig. 3, 4, and 5. The distributional pattern of monthly precipitation are quite similar among locations. However, the precipitation density on population 2, Seosan area, during growing season is lower as compared to the other two populations. Population 1. Cheong-song area, and population 3, Pyong-chang area, are located in inland, but population 2 in the western seacoast. The differences on the average monthly air temperatures and the average monthly lowest temperatures among populations can hardly be found. 2. Available information on the each mother trees (families) studied, such as age, stem height, diameter at breast height, clear-bole-length, crown conditions and others are shown in table 6,7, and 8. 3. The measurements of fresh cone weight, length and the widest diameter of cone are given in Tab]e 9. All these traits arc concerned with the highly significant population differences and family differences within population. And the population difference was also found in the cone-index, that is, length-diameter ratio. 4. Seed-wing length and seed-wing width showed the population differences, and the family differences were also found in both characteristics. Not discussed in this paper, however, seed-wing colours and their shapes indicate the specificity which is inherent to individual trees as shown in photo 3 on page 50. The colour and shape are fully the expression of genetic make up of mother tree. The little variations on these traits are resulted from this reason. The significant differences among populations and among families were found in those characteristics, such as 1000-seed weight, seed length, seed width, and seed thickness as shown in table 11. As to all these dimensions, the values arc always larger in population 1 which is younger in age than that of the other two. The population differences evaluated by cone, seed and seed-wing sizes could partly be attributed to the growth vigorousity. 5. The values of correlation between the characteristics of cone and seed are presented in table 12. As shown, the positive correlations between cone diameter and seed-wing width were calculated in all populations studied. The correlation between seed-wing length and seed length was significantly positive in population 1 and 3 but not in population 2, that is, the r-value is so small as 0.002. in the latter. The correlation between cone length and seed-wing length was highly significant in population 1, but not in population 2. 6. Differences among progenies in growth performances, such as 1-0 and 1-1 seedling height and root collar diameter were highly singificant among populations as well as families within population(Table 13.) 7. The heritability values in narrow sense of population characteristics were estimated on the basis of variance components. The values based on seedling height at each age stage of 1-1 and 1-0 ranged from 0.146 to 0.288 and the values of root collar diameter from 0.060 to 0.130. (Table 14). These heritability values varied according to characteristics and seedling ages. Here what must be stated is that, for calculation of heritability values, the variance values of population was divided by the variance value of environment (error) and family and population. The present authors want to add the heritability values based on family level in the coming report. It might be considered that if the tree age is increased in furture, the heritability value is supposed to be altered or lowered. Examining the heritability values studied previously by many authors, in pine group at age of 7 to 15, the values of height growth ranged from 0.2 to 0.4 in general. The values we obtained are further below than these. 8. The correlation between seedling growth and seed characteristics were examined and the values resulted are shown in table 16. Contrary to our hypothetical premise of positive correlation between 1-0 seedling height and seed weight, non-significance on it was found. However, 1-0 seedling height correlated positively with seed length. And significant correlations between 1-0 and 1-1 seedling height are calculated. 9. The numbers of stomata row calculated separately by abaxial and adaxial side showed highly significant differences among populations, but not in serration density. On serration density, the differences among families within population were highly significant. (Table 17) A fact must be noted is that the correlation between stomata row on abaxial side and adaxial side was highly significant in all populations. Non-significances of correlation coefficient between progenies and parents regarding to stomata row on abaxial side were shown in all populations studied.(Table 18). 10. The contents of chhlorophyll b of the needle were a little more than that of chlorophyll a irrespective of the populations examined. The differences of chlorophyll a, b and a plus b contents were highly significant but not among families within populations as shown in table 20. The contents of chlorophyll a and b are presented by individual trees of each populations in table 21. 11. The occurrence of monoterpene components was examined by gas liquid chromatography (Shimazu, GC-1C type) to evaluate the population difference. There are some papers reporting the chemical geography of pines basing upon monoterpene composition. The number of populations studied here is not enough to state this problem. The kinds of monoterpene observed in needle were ${\alpha}$-pinene, camphene, ${\beta}$-pinene, myrcene, limonene, ${\beta}$-phellandrene and terpinolene plus two unknowns. In analysis of monoterpene composition, the number of sample trees varied with population, I.e., 18 families for population 1, 15 for population 2 and 11 for population3. (Table 22, 23 and 24). The histograms(Fig. 6) of 7 components of monoterpene by population show noticeably higher percentages of ${\alpha}$-pinene irrespective of population and ${\beta}$-phellandrene in the next order. The minor Pinus densiflora monoterpene composition of camphene, myrcene, limonene and terpinolene made up less than 10 percent of the portion in general. The average coefficients of variation of ${\alpha}$-pinene and ${\beta}$-phellandrene were 11 percent. On the contrary to this, the average coefficients of variation of camphene, limonene and terpinolene varied from 20 to 30 percent. And the significant differences between populaiton were observed only in myrcene and ${\beta}$-phellandrene. (Table 25).

  • PDF

SPARQL Query Processing System over Scalable Triple Data using SparkSQL Framework (SparQLing : SparkSQL 기반 대용량 트리플 데이터를 위한 SPARQL 질의 시스템 구축)

  • Jeon, MyungJoong;Hong, JinYoung;Park, YoungTack
    • Journal of KIISE
    • /
    • v.43 no.4
    • /
    • pp.450-459
    • /
    • 2016
  • Every year, RDFS data tends further toward scalability; hence, the manner of SPARQL processing needs to be changed for fast query. The query processing method of SPARQL has been studied using a scalable distributed processing framework. Current studies indicate that the query engine based on the scalable distributed processing framework i.e., Hadoop(MapReduce) is not suitable for real-time processing because of the repetitive tasks; in addition, it is difficult to construct a query engine based on an In-memory Distributed Query engine, because distributed structure on the low-level is required to be considered. In this paper, we proposed a method to construct a query engine for improving the speed of the query process with the mass triple data. The query engine processes the query of SPARQL using the SparkSQL, which is an In-memory based, distributed query processing framework. SparkSQL is a high-level distributed query engine that facilitates existing SQL statement. In order to process the SPARQL query, after generating the Algebra Tree using Jena, the Algebra Tree is required to be translated to Spark Algebra Tree for application in the Spark system, and construction of the system that generated the SparkSQL query. Furthermore, we proposed the design of triple property table based on DataFrame for more efficient query processing in the Spark system. Finally, we verified the validity through comparative evaluation with the query engine, which is the existing distributed processing framework.

Characteristic of MED measurement Value of Trial Subjects from Ultraviolet Irradiation (자외선 조사 피험자의 MED 측정 값의 특성에 관한 연구)

  • Suk, Jang Mi;Park, Shin Young;Choi, Mi Ra;An, Song Yi;Kim, In Soo;Kim, Beom Joon;Park, Jin O;Jung, Sang Wook
    • Journal of the Society of Cosmetic Scientists of Korea
    • /
    • v.39 no.3
    • /
    • pp.251-257
    • /
    • 2013
  • In this study, ultraviolet protection factor (Sun Protection Factor, SPF) was investigated to provide basic data for subject safety and research of ultraviolet (UV) irradiation test in the future. Trial subjects (395 people) of skin type I, II, and III were evaluated according to skin type standard table. After measuring the skin color using a colorimeter, ITA (Individual Typology Angle) value was calculated. Subjects with 28 and above ITA value were positioned comfortably to be UV irradiated for 60 s and erythema was evaluated 24 hours after application. MED (Minimal Erythema Dose) was investigated where the minimal amount of erythema existed among UVB irradiated area. Statistical analysis was investigated using Statistical Package the Social Sciences program. As a result, the darker skin color results in the higher MED value since the higher skin type number results increased MED value and female has higher MED value than male since female has darker skin type than male. There was no relation between MED difference by ages in all different ages. However, it is hard to draw a conclusion as above since the number of subjects were not sufficient to support statistical significance for MED values by different ages. However, MED values by skin types obtained through this study can be used as a standard when MED value is expected to evaluate efficacy of sunscreen product and as basic data for further safety of clinical researches.

Effect of Temperature on Development and Life Table Parameters of Tetranychus urticae Koch (Acari: Tetranychide) Reared on Eggplants (가지에서 온도별 점박이응애 발육특성 및 생명표 통계량)

  • Kim, Ju;Lee, Sang-Koo;Kim, Jeong-Man;Kwon, Young-Rip;Kim, Tae-Heung;Kim, Ji-Soo
    • Korean journal of applied entomology
    • /
    • v.47 no.2
    • /
    • pp.163-168
    • /
    • 2008
  • Temperature dependent development of Tetranychus. urticae Koch was studied on the leaf of eggplant at 17, 22, 27, 32 and $37^{\circ}C$. T. urticae showed a minimum mortality at $27^{\circ}C$ and it increased at higher or lower temperatures than $27^{\circ}C$. The hatchability was low at 17 and $37^{\circ}C$. The duration of development decreased with increasing temperatures i.e., 5.3d at $37^{\circ}C$ and 25.8d at $17^{\circ}C$. Linear regression analysis of temperature vs. rate of development yielded the higher $r^2{\geq}0.88$ resulting in a good fit of the estimated line in the range of $17{\sim}37^{\circ}C$. Developmental zero temperature was $12.5^{\circ}C$ for the entire immature stage of female and $12.8^{\circ}C$ for that of male. Thermal constants were 80.5 and 74.7 degree days for those of female and male, respectively. Adult life span and oviposition period decreased with increasing temperatures. The number of eggs laid per female peaked at 141.0 eggs at $27^{\circ}C$, while that was a minimum 78.0 eggs at $37^{\circ}C$. Rate of hatchability, ratio of female, and $R_o$ were increased up to $27^{\circ}C$, and than declined thereafter. Intrinsic rate of natural increase (Rm) increased with rising temperatures and showed a maximum 0.5652 at $37^{\circ}C$. Also, ${\lambda}$ increased with increasing temperature. Doubling time (Dt) and generation time (T) decreased with increasing temperature.

Effect of Aluminum Sulfate Addition to Litter and Dietary Protein Levels of Broilers on Litter Nitrogen Content (육계에 급여되는 사료중의 단백질 수준과 깔짚 내의 Aluminum Sulfate 첨가가 깔짚 내의 질소 함량에 미치는 영향)

  • Park, I. H.;K. H. Nahm
    • Korean Journal of Poultry Science
    • /
    • v.30 no.2
    • /
    • pp.119-128
    • /
    • 2003
  • The two experiments in this study compared litter nitrogen (N) contents after broiler chicks were raised for 42 days. Experiment I compared litter treated with aluminum sulfate (alum) [Al$_2$(SO$_4$)$_3$ㆍ14$H_2O$] (T$_1$) with nontreated litter (T$_2$) when the broiler chicks were fed the same levels of dietary protein (23% for 0∼3 weeks, 21% for 4∼6 weeks) Experiment 2 compared the alum treated litters of broiler chicks fed high protein diets (T$_3$) having 20.4% protein for 0∼3 weeks and 19.3% for 4∼6 weeks, with lower protein diets (T$_4$) having protein levels of 18.0% for 0∼3 weeks and 17.0% for 4 6 weeks. Each treatment had four replicate cages. As shown in Table 1, T$_1$ had a significantly (P<0.0l) lower pH and significantly (P<0.05) higher total N (TN), NH$_4$-N and inorganic N (IN) than T$_2$. T$_1$ and T$_2$ had similar moisture, organic carbon (OC), NO$_3$-N and organic N (ON). Alum treatment increased available N (AN) significantly (P<0.05) from 13.75$\pm$0.0l mg/g to 14.90$\pm$0.01 mg/g and predicted available N (PAN) significantly (P<0.05) from 15.00$\pm$0.0l to 16.50$\pm$0.02. The C : N ratios were 18.84$\pm$0.40 (T$_1$) and 19.46$\pm$0.10 (T$_2$) while the C : ON ratios were 28.49$\pm$1.15 (T$_1$) and 28.34$\pm$0.20 (T$_2$) although C : N ratios or C : ON ratios did not show any difference between T$_1$ and T$_2$. In Table 2, T$_3$ had significantly (P<0.05) higher moisture, TN, NH$_4$-N, ON and IN than T$_4$, while the pH, OC and NO$_3$-N were similar in both groups. The AN of T$_3$ increased significantly (P<0.05) from 10.99$\pm$0.0l mg/g to 12.98$\pm$0.03 mg/g, while the PAN increased significantly (P<0.05) from 12.39$\pm$0.10 mg/g (T$_4$) to 14.68$\pm$ 0.30 mg/g (T$_3$). The C : N ratios increased significantly (P<0.0l) from 20.07$\pm$0.20 (T$_3$) to 24.40$\pm$0.10 (T$_3$). The C : ON ratios also increased significantly (P<0.0l) from 28.99$\pm$1.15 (T$_3$) to 35.51$\pm$0.20 (T$_4$). These current research results show increased AN contents and PAN contents in alum treated litter or with increased CP levels regardless of alum treatment. However, none of the litters in this study could initially increase mineralization.

Studies on the Organo-mercury Residues in Rice Grain -I. Mercury residues in rice seeds treated with organo-mercury fungicide- (수도(水稻)에 처리(處理)된 유기수은제(有機水銀劑)의 잔류성(殘留性)에 관(關)한 연구(硏究) -제1보(第1報) 침지용유기수은제(浸漬用有機水銀劑)로 처리(處理)된 수도종자중(水稻種子中)의 수은잔류량(水銀殘留量)에 관(關)하여-)

  • Lee, Dong-Suk
    • Applied Biological Chemistry
    • /
    • v.8
    • /
    • pp.87-93
    • /
    • 1967
  • 1) For the micro-analysis of mercury in plant materials, the method of Furutani was shown to be the simplest and most efficient way and the recovery of the assay was about 98%. 2) When the rice grain was soaked in 1/1000 diluted solution of organo-mercury fungicide for 8 hours at the end of March, the amounts of mercury residues in the brown rice and unhulled rice were 8.8 to $9.5\;{\mu}g/g$ seeds and 10.1 to $10.7\;{\mu}g/g$ seeds, respectively. 3) By washing the treated rice seeds with running water for three days, tile residual mercury concentration was reduced to 1/4 to 1/5; thus the mercury residues were 1.86 to $1.92\;{\mu}g/g$ for brown rice and 1.96 to $2.93\;{\mu}g/g$ for unhulled rice. 4) The residual mercury was present more in the unhulled rice than in the brown rice, either before or after washing of the treated seeds. 5) Among the different rice varieties, no difference was observed in mercury residues by seed treatment and washing.

  • PDF

Analyzing the impact of increase in energy price on the general price level (에너지원별 가격조정의 물가파급효과 분석)

  • Lim, Seul-Ye;Song, Tae-Ho;Yoo, Seung-Hoon
    • Journal of Energy Engineering
    • /
    • v.22 no.4
    • /
    • pp.376-385
    • /
    • 2013
  • There are conflicts about energy price increase among government, producer, and consumer. The supplier insists on price increase for escaping running a deficit and business continuity, but the consumer concerns about worsening profitability and price rise. This study investigates the effects of energy rate increase on national economy using input-ouput(I-O) analysis. This study attempts to analyze the effects of national economy due to Coke and hard-coal, Naphtha, Gasoline, Kerosene, Light oil, Heavy oil, Liquefied petroleum gas, Electric utilities, Manufactured gas supply and Steam and hot water supply (using input-output table for the year 2011, Korea.) The results of the sectoral price changes due to a 10% increase in energy price that is obtained from the Leontief price model are presented in article. The result of this analysis is presented: The impact of the 10% increase in electricity rate on the general price level is estimated to be 0.2196%. In case of Kerosene, the impact is 0.1222%. It shows that Electric utilities are approximately 18 times larger price inducing effect as Kerosene. Also, this study indicates 3 years results sequentially to make it possible to observe trend. Then, study suggests balancing price by making each energy source adjusted.