• Journal of the Institute of Electronics Engineers of Korea CI
• /
• v.39 no.5
• /
• pp.1-10
• /
• 2002

Efficient processing of expensive queries that include joins and/or aggregate functions is crucial in data warehousing environment since there reside enormous volume of data. In this paper, we propose a new method for processing of queries that have both of joins and aggregate functions. The proposed method first performs grouping of the dimension table and then processes join by using the bitmap join index. This makes only the fact table accessed for processing aggregate functions, and thus resolves the serious performance degradation of the existing method. For showing the superiority of the proposed method, we suggest the cost models for the proposed and existing ones, and perform extensive simulations based on the TPC-H benchmark.

• Journal of Internet Computing and Services
• /
• v.16 no.5
• /
• pp.11-17
• /
• 2015

In the general transmission power control model that is used for wearable sensor systems, if RSSI value gets out of the Target RSSI Margin, then the sink node finds new transmission power by using TPC(Transmission Power Control) Algorithm. At this time, the sink node sends the control packet to the sensor node for delivering the newly calculated transmission power. However, when the wireless network channel condition is poor, even it is consuming a lot of control packets, the sink node could not find an appropriate transmission power so it only waste of energy. Therefore, we proposed a new control packet transmission decision method that the sink node changes the transmission power when the wireless network channel condition is stabilized. It makes waste of energy decline. In this paper, we apply control packet transmission decision method to Binary TPC algorithms and analyze the results to evaluate the proposed method. We propose three methods that judge the state of wireless network channel. We experiment that methods and analysis the results.

• Journal of Information Technology Applications and Management
• /
• v.21 no.4
• /
• pp.225-245
• /
• 2014

ICT based convergence application is one of the most prevalent industrial issue these days. Despite of criticalness and potential economic opportunities of the ICT based convergence, theoretical research to analyze the feasibility and estimate the economic impact of the application is rather limited. This paper is intended to fill this research gap. In this respect, we develop theoretical framework to quantitatively estimate the differential benefits of convergent applications, which necessarily include underling ICT technology's contribution attributes extractions, and resulting value increments engendered from user's process effectiveness when ICT based service application is adopted. The research model to assess the differential value of the ICT based service application is developed, grounded on theoretical framework of TPC (Technology-to-performance chain) and contingency fit theories. Scenario based survey method is adopted, and SmartPLS 2.0. is used for statistical analysis of the structural equation model using 312 questionnaire. Valid statistical results are presented to provide useful insight.

• Korean Chemical Engineering Research
• /
• v.54 no.3
• /
• pp.310-314
• /
• 2016

The search for natural antioxidants as alternatives to synthetic products is growing. Microalgae have emerged as a source of natural antioxidants with significant and diverse health-promoting properties. In this study, the effects of hot-water extraction conditions on total polyphenol compounds (TPC) production were investigated for lipid extracted microalgae (LEA). In order to enhance the polyphenol productivity, the extraction variables including solvents, temperature, time and ethanol concentration were optimized. The results showed hot-water extraction provided a higher extraction efficiency than the organic solvents and extraction at high temperatures showed a better extraction efficiency. While hot-water extract showed a higher extraction efficiency compared to 98% ethanol extraction, the mixture of water and ethanol (40:60 v/v) showed the highest production of polyphenols. The maximum polyphenols of 3.35 mg GAE (gallic acid equivalent)/g DM were obtained at the optimized extraction time of 10 min, $100^{\circ}C$ and 40% ethanol, respectively. Although Tetraselmis KCTC 12236BP was preprocessed by hexane to remove lipid for bio-diesel production, the results showed LEA contains relatively high level of polyphenols compared to untreated microalgae which can be used in the production of value-added materials. The predictions obtained from the developed Peleg's model were compared with the experimental data under the same operating conditions. The predicted and experimental data were consistent, indicating the reliability of the model.

• Journal of the Korean Society of Food Science and Nutrition
• /
• v.43 no.4
• /
• pp.618-623
• /
• 2014

Sarijang, a soy sauce made from fermented black soybean (Rhynchosia nulubilis), sulfur fed duck, dried bark of Ulmus davidiana, Allium sativum, and bamboo salt, has been demonstrated to exert anti-inflammatory and anti-tumor activities. However, the antioxidant properties of Sarijang have not yet been elucidated. In this study, the antioxidant effects of Sarijang were investigated by determining total phenolic content (TPC), DPPH radical scavenging activity (DPPH RSA), total radical trapping antioxidant potential (TRAP), oxygen radical absorbance capacity (ORAC), and cellular antioxidant capacity (CAC). The inhibitory effects of Sarijang on oxidative stress-induced DNA damage (200 ${\mu}M$ $H_2O_2$, 250 ${\mu}M$ Fe-NTA, and 200 ${\mu}M$ HNE) in human leukocytes were evaluated by comet assay. The TPC of Sarijang was $1.04{\pm}0.01$ mg GAE/mL. DPPH RSA, TRAP, and ORAC values of Sarijang increased in a dose-dependent manner. The $IC_{50}$ for DPPH RSA of Sarijang was $11.2{\pm}0.3$ mg/mL, whereas $IC_{50}$ of TRAP was $209.5{\pm}2.0$ mg/mL. 2,2'-Azobis(2-amidinopropane) dihydrochloride (AAPH)-induced oxidative stress and oxidative stress-induced DNA damage in HepG2 cells were effectively abrogated by all tested concentrations of Sarijang (1~100 ${\mu}g/mL$). These results suggest that Sarijang has antioxidative activity and protective effects against oxidative DNA damage.

• Food Science and Preservation
• /
• v.22 no.1
• /
• pp.1-11
• /
• 2015

Raspberries are a good resource of polyphenols and have a powerful antioxidant activity, but shelf life for raspberries is short which brings a lot of economic losses. In this study, we try to use cool-air ($20{\sim}40^{\circ}C$) or hot-air ($60{\sim}100^{\circ}C$) to produce semi-dried raspberries with extended shelf life, and to determine the best method for improving fruit quality by minimizing nutrient losses during drying processes. The effects of process variables (drying temperature and processing time) on the quality of final dried raspberries were investigated. Response surface methodology was employed to establish statistical models for simulating the drying processes, and the moisture residue content and the loss ratios of total phenolic content (TPC), vitamin C (VC), and ellagic acid (EA) that result from the drying processes of raspberries using either hot or cool-air were predicted. Superimposed contour plots have been successfully used in the determination of the optimum zone within the experimental region. Optimal conditions determined for achieving minimal losses of TPC, VC, and EA, and a final moisture residue of 45% using the hot-air drying process were a drying temperature of $65.75^{\circ}C$ and a processing time of 4.3 hr. While for the cool-air process, the optimal conditions predicted were $21.3^{\circ}C$ and 28.2 hr. Successful application of response surface methodology provided scientific reference for optimal conditions of semi-drying raspberries, minimizing nutrient losses and improving product quality.

• Journal of Mushroom
• /
• v.16 no.1
• /
• pp.22-30
• /
• 2018

This study was performed to determine optimal extraction conditions of fermented Polygonum multiflorum root by Lentinula edodes (JMI10079) Pegler mycelials using response surface methodology. The independent factors were extraction temperature (X1: $40-100^{\circ}C$), extraction time (X2: 2-10 hrs.), and the ratio of water to sample (X3: 33-100 mg/mL). Their effects were assessed on dependent variables of the extract properties, which included soluble solid contents (Y1), $^{\circ}Brix$ of sample extract (Y2), total polyphenol content (Y3), total flavonoid content (Y4), 2,2'-azino-bis(3-ethylbenzothiazoline-6-sulphonic acid) radical cation scavenging activity (Y5) and 2,2-diphenyl-1-picrylhydrazyl radical scavenging activity (Y6). The experimental data obtained were fit to a second-order polynomial equation. The optimal extraction conditions for fermented P. multiflorum root were: X1: $91.22^{\circ}C$, X2: 7.72 hrs, and X3: 39.71 mg/mL.