• KSCI Review
• /
• v.14 no.2
• /
• pp.185-197
• /
• 2006

A star schema consists of a central fact table, which is surrounded by one or more dimension tables. Each row int the fact table contains a multi-part primary key(or a composite foreign key) along with one or more columns containing various facts about the data stored in the row Each of the composit foreign key components is related to a dimensional table. The combination of keys in the fact table creates a composite foreign key that is unique to the fact table record. The composite foreign key, however, is rarely unique to the fact table record in real-world applications, particularly in financial applications. In order to make the composite foreign key be the determinant in real-world application, some precalculation might be performed in the SQL relational database, and cached in the OLAP database. However, there are many drawbacks to this approach. In some cases, this approach might give users the wrong results. In this paper, an approach to fact table modeling and related MDX query composing, which can be used in real-world applications without performing any precalculation and gives users the correct results, is proposed.

• Journal of Internet Computing and Services
• /
• v.18 no.4
• /
• pp.121-131
• /
• 2017

With emergence of Internet, social media, and mobile service, the consumers have actively presented their opinions and sentiment, and then it is spreading out real time as well. The user-generated text data on the Internet and social media is not only the communication text among the users but also the valuable resource to be analyzed for knowing the users' intent and sentiment. In special, economic participants have strongly asked that the social big data and its' analytics supports to recognize and forecast the economic trend in future. In this regard, the governments and the businesses are trying to apply the social big data into making the social and economic solutions. Therefore, this study aims to reveal the capability of social big data analysis for the economic use. The research proposed a social big data analysis model and an online consumer sentiment index. To test the model and index, the researchers developed an economic survey ontology, defined a sentiment dictionary for sentiment analysis, conducted classification and sentiment analysis, and calculated the online consumer sentiment index. In addition, the online consumer sentiment index was compared and validated with the composite consumer survey index of the Bank of Korea.

• Journal of the Korean Ceramic Society
• /
• v.42 no.2 s.273
• /
• pp.132-139
• /
• 2005

Sintering behavior of $BaO-Nd_{2}O_3-TiO_2$ with a Pb-based glassceramics frit were investigated in order to understand an effect of glassceramics as a low temperature sintering agent on dielectric ceramics. A green sheet form was fabricated through tape casting method with the glassceramic fut added $BaO-Nd_{2}O_3-TiO_2$. The dispersion properties, rheological properties and final density of dielectric composit slurry as a function of amount and composition of organic additives was examined. The dispersants' addition was effective in controlling dispersion of the ceramics in solution. The addition of excessive dispersant showed adverse effect on dispersion. The prepared slurries, containing ceramic : powders, glass-ceramics and various kinds of organic viechles, exhibited typical shear thinning behavior. The best properties of tape casting appeared powder to solvent ratio 65 : 35 and amount of the binder 6 wt$\%$ and plasticizer 3 wt$\%$. The viscosity of the slurry was 677 cps and green/sintered density in the tape was $3.3 g/cm^3,\;5.56 g/cm^3$ respectively.

• The Korean Journal of Financial Management
• /
• v.12 no.2
• /
• pp.239-271
• /
• 1995

본 연구는 현재 미국에서 거래되고 있는 세 가지 주가지수선물 상호간의 일중(intradaily) 가격선도(price leadership) 관계에 관한 실증분석이다. 본 연구가 기존의 연구와 다른점은, 기존의 연구가 주가지수선물과 그 기준이 되는 현물 가격사이의 가격 선도 관계에 초점을 두고 있는데 반하여 본 연구는 주가지수선물 시장 사이에서 존재하는 가격 선도관계를 분석하고 있다는 점이다. 실증 분석의 대상이 된 주가지수선물들은 Chicago Mercantile Exchange의 Standard and Poor's 500 Index(S&P 500), New York Futures Exchange의 New York Stock Exchange Composit Index (NYSE), 그리고 Chicago Board of Trade의 Major Market Index(MMI)이다. 만약 이들 시장들이 정보의 전달에 있어서 효율적(informationally efficient) 이라면 이들 가격간에 선도-지연(lead-lag) 현상은 존재하지 않을 것이다. 그러나 어느 한 시장이 새로운 정보를 선물가격에 반영하는데 다른 시장에 비해 상대적으로 느리다면, 이들 시장 상호간에는 가격의 전이(transmission)현상이 존재하게 될 것이다. 이들 선물간의 일중 가격선도 관계 연구는 이러한 시장의 효율성 문제를 밝히는데 의의가 있을 뿐만 아니라, 시장간의 단기적 가격 괴리를 이용하려는 차익거래자들에게도 유용하게 쓰일 수 있을 것이다. 본 연구는 위에서 언급한 각각의 주가지수선물들이 가격 선도성을 가질 수 있는 이유와 관련된 다음과 같은 세 가지 가설을 설정하였다. 첫째 가설은, 가격의 선도성은 거래량과 관련이 있다는 것이다. 즉, 이들 주가지수선물 중 가장 거래량이 많은 S&P 500 선물이 다른 선물을 선도할 것이라는 가설이다. 둘째, 가격의 선도성은 주가지수를 구성하는 주식의 수에 비례한다는 가설이다. 다시 말하면, 보다 않은 수로 구성된 주가지수일수록 정보처리 속도가 빠르다는 가설이다. 따라서, 본 연구에 포함된 주가지수선물 중 가장 많은 수의 주식을 대상으로 하는 NYSE 선물이 다른 선물을 선도할 것이다. 마지막 가설은 정보의 처리는 대형주 혹은 기관선호주(institutionally-favored)들이 주도한다는 것이다. 따라서, 주로 이와 같은 주식들로 구성 된 MMI 선물이 선도성을 가질 수 있다는 것이다. 위의 가설들을 검증하고 시장간의 가격 선도관계를 분석하기 위하여 본 연구는 vector autoregressive(VAR) 모형을 이용하여 충격-반응 함수(impulse response functions)를 계산하고, 분산분해(variance decomposition)를 수행하였다. 또한 가격 상호간에 존재할지도 모르는 공적분(cointegration)관계를 Johansen(1991)과 Jokansen and Juselius (1992) 등이 제시한 다변량 공적분 검정(multivariate cointegration test)를 통하여 분석하였다. 분석기간은 1986년 1월부터 1990년 7월까지이며, 각 주가지수선물들의 5분 간격 data를 사용하였다. 연구결과, 충격-반응 분석은 어느 한 시장에서의 충격(shock)은 다른 시장으로 매우 빠르게 전달되고 있음을 보여 주었다. 그러나 충격의 지속정도는 그 충격의 진원지에 따라 달랐다. 즉, NYSE나 MMI 선물로부터 발생 한 충격은 다른 시장의 가격에 5분 안에 반영을 끝냈지 만 S&P 500 선물에서 발생한shock은 그 이상 지속되었다. 또한, 분산분해 결과 S&P 500 선물이 자기자신 뿐만 아니라 다른 시장의 예상하지 못했던 움직임(unexpected movements)을 설명하는데 가장 큰 설명력(explanatory power)을 가지고 있었다. 결론적으로 S&P 500 선물이 다른 선물을 약 5분 간격으로 선도하였다. 이는 가격의 선도가 거래량과 밀접한 관계가 있음을 보여 주는 것이다.

• Analytical Science and Technology
• /
• v.27 no.6
• /
• pp.308-313
• /
• 2014

The effect of electrochemical characteristics of dye-sensitized solar cells (DSSC) upon employing multi-wall carbon nanotube (MWCNT) on both working electrode and counter electrode were examined with using EIS, J-V curves and UV-Vis absorption spectrometry. When 0.1 wt% of MWCNT was employed in the $TiO_2$-MWCNT composit on working electrode, the energy conversion efficiency increased about 12.5% compared to the $TiO_2$ only working electrode. The higher light conversion efficiency may attribut to the high electrical conductivity of MWCNT in $TiO_2$-MWCNT composite which improves the electron transport in the working electrode. However, higher amount of MWCNT than 0.1 wt% in the $TiO_2$-MWCNT composite decreases the light conversion efficiency, which is mainly ascribed to the decreased transmittance of light by MWCNT and to the decreased adsorption of dye onto $TiO_2$. The MWCNT employed counter electrode exhibited much lower light conversion efficiency of DSSC than the Pt-counter electrode, while the MWCNT-Pt counter electrode showed similar in light conversion efficiency to that of Pt-counter electrode.

• Journal of Navigation and Port Research
• /
• v.30 no.8 s.114
• /
• pp.711-719
• /
• 2006

A series of geotechnical centrifuge model tests and numerical modelling have been performed to study engineering characteristics of the composite ground reinforced by both the Sand Compaction Piles(SCPs) and the deformation-reducing sheet piles. The research has covered several key issues such as the load-settlement relation, the stress concentration ratio and the final water content of the ground Totally three centrifuge tests have been conducted by changing configuration of the sheet piles, i.e., a test without the sheet pile, a test with the sheet pile at a single side and a test with the sheet piles at the both sides. In the model tests, a vertical load was applied in-flight on the ground surface. On the other hand, class-C type numerical modelling has been performed by using the SAGE-CRISP to compare the centrifuge test results using an elasto-plastic model for SCPs and the Modified Cam Clay model for the soft clay. It has been found that the sheet piles can restraint failure of foundation, thereby increasing yield stress of the ground. The stress concentration ratio was in the range of $2{\sim}4$. In addition, numerical analysis results showed reductions both in the ground heave($20{\sim}30%$) and in the horizontal movement($28{\sim}43%$), demonstrating the deformation-reducing effect of the sheet piles.

• Journal of the korean academy of Pediatric Dentistry
• /
• v.29 no.2
• /
• pp.180-188
• /
• 2002

Newly developed curing units(plasma arc curing units) operate at relatively high intensity and are claimed to result in optimum properties of composite resin in a short curing time. The purpose of this study was to evaluate the microhardness and microleakage at the resin-tooth interface of two types of composite resins polymerized with visible light and plasma arc curing units. The results from the present study can be summarized as follows 1. Microhardness in each depth was shown to be higher in group AHL than AP3 & AP6. Group ZHL was lower than AP6 at surface(p<0.05) and had no statistically significant difference at 1mm and 2mm(p>0.05). In other depths, group ZHL was higher than ZP3 and ZP6(p<0.05). 2. The incremental reduction in microhardness with depth was shown to be in all group except in surface-1mm of group AHL and $1{\sim}2mm$ of group ZHL(p<0.05). 3. Degree of microleakage in all oops were shown to be higher in gingival margin than occlusal margin but no statistically significant difference(p>0.05). 4. Differences between curing methods in microleakage were shown to be no statistically significant difference(p>0.05). 5. Differences between composite resins in microleakage were shown to be no statistically significant differ once(p>0.05).

• Journal of Periodontal and Implant Science
• /
• v.28 no.2
• /
• pp.219-237
• /
• 1998

Numerous bone graft materials have been used in Periodontics, in an attempt to reach the main goal of periodontal therapy, i.e. the regeneration of periodontal tissue lost due to destructive periodontal diseases. The present study investigates the effect of composite graft of DFDB and Calcium sulfate with and without Calcium sulfate barrier in Periodontal 1-wall intrabony defects in dogs. Following the initiation of general anesthesia by I.V. administration of 40mg/Kg of Pentobabital, second premolar was extracted and full thickness flap elevated. The crown portion of premolars was removed. Exposed root canals were sealed with Caviton and covered completely with flap. After the healing period of 8 weeks, the surgical sites were re-opened and 1-wall intrabony defects were created, and treated with flap operation alone(control group), with composit graft of 80% DFDB and 20% Calcium sulfate(Experimental group 1), with composite graft of DFDB and calcium sulfate with calcium sulfate membrane( Experimental group 2). Healing response was histologically observed after 8 weeks and the results were as follows : 1. New bone formation was 70 % in the control group, 93 % in the Experimental group I, 89 % in the Experimental group II. There was a no differences between Experimental groups. 2. New cementum formation was not significantly different between control and two Experimental groups. 3. The length of connective tissue adhesion was 30 % in the control, 7% in the Experimental group I and 11 % in the Experimental group II. 4. After 8weeks, calcium sulfate was completely resorbed, while DFDB particle remained. These results suggest that the use of composite graft of allogenic DFDB and Calcium sulfate with and without Calcium sulfate barrier in periodontal 1 wall intrabony defects have little effect on connective tissue adhesion, but has beneficial effect on new alveolar bone and new cementum formation, and prevent downgrowth of epithelium and connective tissue effectively.

• Journal of the Korea Society of Computer and Information
• /
• v.12 no.1 s.45
• /
• pp.177-188
• /
• 2007

A star schema consists of a central fact table, which is surrounded by one or more dimension tables. Each row in the fact table contains a multi-part primary key(or a composite foreign key) along with one or more columns containing various facts about the data stored in the row. Each of the composit foreign key components is related to a dimensional table. The combination of keys in the fact table creates a composite foreign key that is unique to the fact table record. The composite foreign key, however, is rarely unique to the fact table retold in real-world applications, particularly in financial applications. In order to make the composite foreign key be the determinant in real-world application, some precalculation might be performed in the SQL relational database, and cached in the OLAP database. However, there are many drawbacks to this approach. In some cases, this approach might give users the wrong results. In this paper, an approach to fact table modeling and related MDX query composing, which can be used in real-world applications without performing any precalculation and gives users the correct results, is proposed.

• Food Science and Preservation
• /
• v.15 no.1
• /
• pp.21-29
• /
• 2008

This study investigated the fermentation and quality characteristics of a fermented beverage, prepared by semi-anaerobic culture, using sea tangle extract. A central composit design using alcohol(0, 0.5, 1.0, 1.5, 2.0% [all v/v] ), sugar(0, 5, 10, 15, 20% [all w/v] ) and $65^{\circ}Brix$ citrus juice(0, 1.0, 2.0, 3.0, 4.0 % [all v/v] ) was used to find the optimal mix for fermentation. Sensory characteristics, such as color, flavor, taste, sweetness, saltiness, sourness and overall quality, were measured using a response surface methodology computer program. The optimal conditions that produced the highest acidity of 0.94 were 2.0 % ethanol, 10.17 % sucrose and 1.99 % citrus juice. The optimal conditions that produced gel 20.13 nun in thickness were 1.98% alcohol, 10.94% sucrose and 1.62% citrus juice. The overall optimal conditions that satisfied all the sensory requirements for a sea tangle beverage were 1.0% alcohol, 10.0% sucrose and 4.05% citrus juice.