• Journal of KIISE:Databases
• /
• v.34 no.1
• /
• pp.18-34
• /
• 2007

In order to provide various business analysis methods, OLAP(On-Line Analytical Processing) systems represent their data with multidimensional structures. These multidimensional data are often delivered to users in the horizontal format of tables whose columns are corresponding to values of dimension attributes. Since the horizontal tables nay have a large number of columns, they cannot be stored directly in relational database systems. Furthermore, the tables are likely to have many null values (i.e., sparse tables). In order to manage the horizontal tables efficiently, we can store them as the vertical format of tables which has dimension attribute names as their columns thus transforms the columns of horizontal tables into rows. In this way, every queries for horizontal tables have to be transformed into those for vertical tables. This paper proposed a technique for transforming horizontal table queries into vertical table ones by utilizing not only traditional relational algebraic operators but also the PIVOT operator which recent DBMS versions are providing. For achieving this goal, we designed a relational algebraic expression equivalent to the PIVOT operator and we formally proved their equivalence. Then, we developed a transformation technique for horizontal table queries using the PIVOT operator. We also performed experiments to analyze the performance of the proposed method. From the experimental results, we revealed that the proposed method has better performance than existing methods.

• Analytical Science and Technology
• /
• v.26 no.1
• /
• pp.106-112
• /
• 2013

PDE plays an important role in cAMP-mediated cellular signaling within the cells. The proper targeting of each PDE is mediated by unique N-terminal of each PDE isoform. It has been recently reported that supershort-, short- and long-forms of PDE4 in Aplysia were cloned in Aplysia. Long-form of ApPDE4 was localized at plasma membrane and presynaptic terminal in Aplysia sensory neurons. However, it remains elusive which part of ApPDE4 is minimal region for the proper targeting and what are the effects on the cell functions. Here, we identified that N-terminal 13 amino acids of ApPDE4 long-form is minimal regions for the plasma membrane targeting. In addition, overexpression of ApPDE4(N20)-mRFP could induce morphological changes in HEK293T cells. Interestingly, mRFP-$PLC{\delta}1$(PH), which selectively binds to PI4,$5P_2$, could induce morphological changes in similar with that by ApPDE4(N20)-mRFP. These results suggested that binding of ApPDE4(N20) to lipids including PI4,$5P_2$ might be responsible for targeting of ApPDE4 to plasma membrane and morphological changes in HEK293T cells.

• Analytical Science and Technology
• /
• v.19 no.3
• /
• pp.194-202
• /
• 2006

In this work, extraction and purification of the possible whitening agents from the Chinese plants; Chrysanthemum morifolium Ramat (xizang cai ju hua), Rhodiola sachalinensis, and Terminalia chebula Retzius have been described. The chopped leaves of Chrysanthemum morifolium Ramat and Terminalia chebula Retzius were added to water and ethyl ether, respectively. Components were separated on a GS310 column ($21.5{\times}500mm$ i.d., $10-15{\mu}m$) and concentrated into four or three portions. The chopped leaves of Rhodiola salientness were added to methanol and separated and concentrated on a column ($C_{18}$ column, $3.9^{\circ}$�F8;300 mm i.d., $15{\mu}m$) into two parts. The whitening effects of extracts were examined by in-vitro melanin production assay, in melana and B16 cells at a concentration of $10{\mu}g/ml$. The ethyl acetate layer of Chrysanthemum morifolium Ramat showed 92% melanin inhibitory at $200{\mu}g/ml$, the extract of Rhodiola sachalinensis showed a whitening effect of about 60% melanin inhibitory, which was more efficient than the whitening effect of arbutin (45.6%). The methanol extract of Terminalia chebula Retzius inhibited melanin expression by 90% at $100{\mu}g/ml$; however, it was toxic to B16 melanoma cells.

• Sim-seong Yeon-gu
• /
• v.26 no.1
• /
• pp.1-35
• /
• 2011

The number of Frida Kahlo's works is 143, 55 of which are her own portraits. She spent a great deal of time on the production of her works, a large portion of which is taken up by her portraits. Art and creation by artist are the expressive process of artist's unconsciousness. Certain works express personal unconsciousness and collective, archetypal unconsciousness. These works evoke certain impressive image or unknown emotion in their mind impulsively. Artist could talk with their own work in this process. The producted symbolic images want to seek harmony with the artist's consciousness. This study has examined, from the viewpoint of analytical psychology, the psychological changes of Frida Kahlo by way of interpreting 4 of her own realistic portraits. These particular 4 works were finished in the most critical life time of Frida Kalho. We tried to find out what the purpose of her work would be. From the examination the following characteristics were gound. 1) Her portraits are not only concerned with her personal life and personal unconscious, but they also contain elements of the collective unconscious. 2) She experienced a psychological healing for herself in the process of transforming shocking events into painful portraits. 3) Her self portraits are the expression of the creative transformation she underwent.

• Korean Journal of Food Science and Technology
• /
• v.44 no.5
• /
• pp.621-627
• /
• 2012

Assessment was made of the effects of Aralia cordata Thunb (DH) on the cell proliferation, inducible nitric oxide synthase (iNOS) mRNA gene expression and nitric oxide (NO) production in RAW 264.7 macrophage cells. For the screening of anti-inflammatory activities, ethanolic extracts of 55 species of traditional herbal medicines were examined for inhibitory effects, and it was confirmed that DH possessed inhibitory effects on NO production. As a result, DH significantly decreased the production of NO and iNOS gene expression at a concentration of $250{\mu}g/mL$. The chloroformsoluble fractionates have the strongest No synthesis inhibitory effect. It is presumed that the inhibition of NO production in LPS-stimulated RAW 264.7 cells by DH components occurred via the modulation of iNOS and DH, and that the active compound from DH may be useful for therapeutic management of inflammatory-associate diseases.

• Journal of Communications and Networks
• /
• v.14 no.4
• /
• pp.374-384
• /
• 2012

Utilizing artificial noise (AN) is a good means to guarantee security against eavesdropping in a multi-inputmulti-output system, where the AN is designed to lie in the null space of the legitimate receiver's channel direction information (CDI). However, imperfect CDI will lead to noise leakage at the legitimate receiver and cause significant loss in the achievable secrecy rate. In this paper, we consider a delayed feedback system, and investigate the impact of delayed CDI on security by using a transmit beamforming and AN scheme. By exploiting the Gauss-Markov fading spectrum to model the feedback delay, we derive a closed-form expression of the upper bound on the secrecy rate loss, where $N_t$ = 2. For a moderate number of antennas where $N_t$ > 2, two special cases, based on the first-order statistics of the noise leakage and large number theory, are explored to approximate the respective upper bounds. In addition, to maintain a constant signal-to-interferenceplus-noise ratio degradation, we analyze the corresponding delay constraint. Furthermore, based on the obtained closed-form expression of the lower bound on the achievable secrecy rate, we investigate an optimal power allocation strategy between the information signal and the AN. The analytical and numerical results obtained based on first-order statistics can be regarded as a good approximation of the capacity that can be achieved at the legitimate receiver with a certain number of antennas, $N_t$. In addition, for a given delay, we show that optimal power allocation is not sensitive to the number of antennas in a high signal-to-noise ratio regime. The simulation results further indicate that the achievable secrecy rate with optimal power allocation can be improved significantly as compared to that with fixed power allocation. In addition, as the delay increases, the ratio of power allocated to the AN should be decreased to reduce the secrecy rate degradation.

• Korean Journal of Pharmacognosy
• /
• v.43 no.4
• /
• pp.279-285
• /
• 2012

The Mume Fructus (MF) has been used for relieves cough, arrests arrest chronic diarrhea, treat fluid depletion, and treat ascariasis in Korea. In this study, a high-performance liquid chromatography (HPLC) method was established for simultaneous determination of six main components of MF. Additionally, we were investigated the anti-inflammatory and anti-allergic effects of MF extract on lipopolysaccharide (LPS)-treated RAW264.7 cells and tumor necrosis factor (TNF)-${\alpha}$/interferon (IFN)-${\gamma}$-treated HaCaT cells. The analytical column for separation was used a Gemini $C_{18}$ column maintained at $40^{\circ}C$. The mobile phase consisted of 1.0% (v/v) acetic acid in water (A) and 1.0% (v/v) acetic acid in acetonitrile (B). The flow rate was 1.0 mL/min and the detector was a photodiode array (PDA) set at 280 nm and 320 nm. We evaluated the inhibitory effect of MF extract on the production of inflammatory markers, nitric oxide (NO) and prostaglandin $E_2$ ($PGE_2$) in LPS-stimulated RAW264.7 cells and thymus- and activation-regulated chemokine (TARC/CCL17) in TNF-${\alpha}$/IFN-${\gamma}$-treated HaCaT cells, respectively. We confirmed the genes expression related with TARC, macrophage-derived chemokine (MDC/CCL22) and regulated on activation, normal T cell expressed and secreted (RANTES/CCL5) in HaCaT keratinocyte cells by MF extract. The contents of the five compounds in MF were 0.22-1.01 mg/g. Also, the MF extract show inhibition of about 78% and 75% on NO and $PGE_2$ production at the concentration 1000 mg/mL in RAW264.7 cells. MF extract suppressed the hTARC level and genes expression such as TARC, MDC, and RANTES on TNF-${\alpha}$/IFN-${\gamma}$-treated HaCaT cells.

• Journal of the Society of Cosmetic Scientists of Korea
• /
• v.43 no.2
• /
• pp.115-124
• /
• 2017

The objective of this study was to investigate skin whitening effect of Resorcinol dipentyl ether [1,3-di(pentyloxyl)benzene] by in vitro experiments. Resorcinol dipentyl ether was prepared by alkylation of resorcinol with 1-bromopentane. The reaction products were confirmed by NMR, MS and other analytical equipments. In order to evaluate the skin safety of resorcinol dipentyl ether, the cytotoxicity of the cells constituting the skin (keratinocyte, melanocyte, fibroblast) was analyzed and similar cell viability was observed in all cell lines as compared with the control group. Inhibition of extracellular melanin synthesis effect of resorcinol dipentyl ether was approximately 65.75% at $20{\mu}g/mL$ and inhibition of intracellular melanin synthesis effect of resorcinol dipentyl ether was approximately 53.89% at $20{\mu}g/mL$. The real-time PCR and western blot analysis of mRNA expression and protein expression of tyrosinase, TRP-1, and TRP-2 related to melanogenesis revealed that melanin inhibitory effect of resorcinol dipentyl ether was inhibited from the transcription stage respectively. Finally, this study suggested applicability of Resorcinol dipentyl ether [1,3-di(pentyloxyl)benzene] as a whitening functional cosmetic new material.

• Journal of The Korean Association For Science Education
• /
• v.34 no.4
• /
• pp.359-366
• /
• 2014

In this study, we try to examine its features by using the methods of systematic infographics analysis for visualization materials that are used in Physics I textbooks. Thus, after developing the analytical framework infographics, visualization materials is described in the section "information and communication" and have been analyzed separately as "data visualization" and "Infographics." The results of this study are as follows. First, the analysis framework of infographics can be classified contents of the information, visual representation, and media method. Second, the visualization materials that are displayed in the section "information and communication" of Physics I textbook are of higher quality than most schematized data that are graphically, simple information. Third, the features of visualization materials in textbooks have many relations & functions on 'information content', text & metaphor on 'visual element', illustration & comparison on 'expression type', graphic on 'expression mode', printed matter on 'media method', and horizontal & vertical type on 'the flow of attention'. From the analysis results, in the section "information and communication" of Physics I textbook uses a lot of visualization materials, however it does not provide rich infographics but only simple graphical materials. By utilizing the results of the analysis of textbook and analysis framework of infographics, which has been developed through the this study, let us hope that the opportunity to be able to grasp the importance of infographics in science education be provided.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.11 no.6
• /
• pp.2831-2847
• /
• 2017

In this paper, a joint destination-relay selection and antenna mode selection scheme for full-duplex (FD) relay network is investigated, which consists of one source node, N FD amplify-and-forward (AF) relays and M destination nodes. Multiple antennas are configured at the source node, and beamforming technique is adopted. Two antennas are employed at each relay, one for receiving and the other for transmitting. Only one antenna is equipped at each destination node. In the proposed scheme, the best destination node is firstly selected according to the direct links between the source node and destination nodes. Then the transmit and receive mode of two antennas at each relay is adaptively selected based on the relaying link condition. Meanwhile, the best relay with the optimal Tx/Rx antenna configuration is selected to forward the signals. To characterize the performance of the proposed scheme, the closed-form expression of the outage probability is derived; meanwhile, the simple asymptotic expressions are also obtained. Our analysis shows that the proposed scheme obtains the benefits of multi-relay diversity and multi-destination diversity. Moreover, extra space diversity in the medium SNR region can be achieved due to the antenna selection at the relay. Finally, Monte-Carlo simulations are provided to consolidate the analytical results, and show the effectiveness of the proposed scheme.