• 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 Korean Society of Transportation
• /
• v.18 no.4
• /
• pp.117-126
• /
• 2000

Conventional methods for collecting origin-destination trips have been mainly relied on the surveys of home or roadside interview. However, the methods tend to be costly, labor intensive and time disruptive to the trip makers, thus the methods are not considered suitable for Planning applications such as routing guidance, arterial management and information Provision, as the parts of deployments in Intelligent Transport Systems Motivated by the problems, more economic ways to estimate origin-destination trip tables have been studied since the late 1970s. Some of them, which have been estimating O-D table from link traffic counts are generally Entropy maximizing, Maximum likelihood, Generalized least squares(GLS), and Bayesian inference estimation etc. In the Paper, with user equilibrium constraint we formulate GLS problem for estimating O-D trips and develop a solution a1gorithm by using Genetic Algorithm, which has been known as a g1oba1 searching technique. For the purpose of evaluating the method, we apply it to Seoul inner ringroad and compare it with gradient method proposed by Spiess(1990). From the resu1ts we fond that the method developed in the Paper is superior to other.

• Korea journal of population studies
• /
• v.24 no.1
• /
• pp.67-90
• /
• 2001

Korea National Statistical Office(KNSO) estimated period birth rates, period death rates, and probability of dying for infant(q$q_{0}$) at period life table, considering the unregistered infant deaths. As Ministry of Health and Welfare(MHW) conducted 1993 and 1996 birth cohort infant death surveys. KNSO re-estimated infant mortality levels(especially q$q_{0}$). For the re-estimation, reference data were derived from death registration. MHW surveys, death registration of developed countries. Model Life Tables, and Life Table for Japan. Seventeen simulations were made by the combination of estimation methods and reference data. The final $q_{0}$ was estimated based on the relationship between $q_{0}$ of MHW 1993 survey and $q_{1-4}$ of registered deaths for the period of 1971~1997. For 1993, $q_{0}$ was calculated directly from the 1993 MHW survey and interpolation and extrapolation were made for 1995 and 1997 using the relative decrease rates of $q_{0}$ between 1993 and 1996 MHW surveys. Utilizing the formular of Coale-Demeny North Model, $q_{0}$ was transformed into $m_{0}$ for the period 1971~1997. Finally, cremation data are found to be very useful for the estimation of 1998 infant mortality level by supplementing unregistered infant deaths, especially neonatal deaths. Furthermore, they are found to be very useful to produce fetal and perinatal death statistics.

• Journal of the Korea Society of Computer and Information
• /
• v.19 no.4
• /
• pp.111-122
• /
• 2014

Legislation are social norms that give directly or indirectly, huge impact on the social or corporate, personal problems, unlike a normal document. Also, over time it has a feature constantly changing by the laws enactment and amendment, repealed. The amendment statement automatic generated system is used for purpose of proclamation to those. However, existing system is able to generate amendment statement just text body of law how compare and analyze the current legislation and amendment legislation. However, actual legislation to be created attached table of the table form in complex structure besides simple text form as body text. In this paper, we additional implement attached table processing to existing the amendment statement automatic generated system that containing the table does not handle attached table. We were analyse to the amendment statement generated grammar and table structure in attached table of the legislation for processing to attached table. Also proposed a method to compare attached table in the table. So, it is enable the automatic generation with amendment statement which various forms of legislation the documents.

• Journal of the Institute of Electronics Engineers of Korea SD
• /
• v.44 no.8
• /
• pp.30-37
• /
• 2007

An exponentiation in $GF(2^m)$ is a basic operation for several algorithms used in cryptography, digital signal processing, error-correction code and so on. Existing hardware implementations for the exponentiation operation organize by Right-to-Left method since a merit of parallel circuit. Our paper proposes a polynomial exponentiation structure with a trinomial that is organized by Left-to-Right method and that utilizes a weakly dual basis. The basic idea of our method is to decrease time delay using precomputation tables because one of two inputs in the Left-to-Right method is fixed. Since $T_{sqr}$ (squarer time delay) + $T_{mul}$(multiplier time delay) of ow method is smaller than $T_{mul}$ of existing methods, our method reduces time delays of existing Left-to-Right and Right-to-Left methods by each 17%, 10% for $x^m+x+1$ (irreducible polynomial), by each 21%, 9% $x^m+x^k+1(1, by each 15%, 1% for $x^m+x^{m/2}+1$.

• Asian Pacific Journal of Cancer Prevention
• /
• v.15 no.21
• /
• pp.9301-9305
• /
• 2014

Background: Pain is one of the most terrifying symptoms for cancer patients. Although most patients with cancer pain need opioids, complete relief of pain is hard to achieve. This study investigated the factors influencing persistent pain-free survival (PPFS) and opioid efficiency. Materials and Methods: A prospective study was conducted on 100 patients with cancer pain, hospitalized at the medical oncology clinic of Akdeniz University. Patient records were collected including patient demographics, the disease, treatment characteristics, and details of opioid usage. Pain intensity was measured using a patient self-reported visual analogue scale (VAS). The area under the curve (AUC) reflecting the pain load was calculated from daily VAS tables. PPFS, the primary measure of opioid efficacy, was described as the duration for which a patient reported a greater than or equal to two-point decline in their VAS for pain. Predictors of opioid efficacy were analysed using a multivariate analysis. Results: In the multivariate analysis, PPFS was associated with the AUC for pain (Exp (B)=0.39 (0.23-0.67), P=0.001), the cumulative opioid dosage used during hospitalisation (Exp (B)=1.00(0.99-1.00), P=0.003) and changes in the opioid dosage (Exp (B)=1.01 (1.00-1.01), P=0.016). The change in VAS score over the standard dosage of opioids was strongly associated with current cancer treatment (chemotherapy vs. others) (${\beta}=-0.31$, T=-2.81, P=0.007) and the VAS for pain at the time of hospitalisation (${\beta}=-0.34$, T=-3.07, P= 0.003). Conclusions: The pain load, opioid dosage, concurrent usage of chemotherapy and initial pain intensity correlate with the benefit received from opioids in cancer patients.

• Journal of Environmental Policy
• /
• v.8 no.1
• /
• pp.49-72
• /
• 2009

To analyze the direct and indirect $CO_2$ emission structure according to industries in Korea, a hybrid IO table quantifying the section of energy in the IO table is needed. However, the results of the recent researches revealed differences in the total amount of $CO_2$ emission by researchers in addition to significant standard deviation in industrial distribution. This study intends to make comparative analysis of the existing method of making an IO table for energy and environment and presents an improvement scheme to contribute to an improvement in calculation of the total amount of $CO_2$ emission and estimation of the emission by industries in Korea. For this purpose, division was made into use as raw materials of energy and that as fuel and a new hybrid IO table was made by removing confounding factors caused by the product tax and subsidies. As a result, the oil and coal industry emitted 5.2 times less $CO_2$ after removing energy inputted as raw materials from the transaction table than before. The amount of $CO_2$ emission estimated by using the IO table based on basic price was found to be 2.7% less than by using the IO table based on the producer price.

• Journal of Environmental Health Sciences
• /
• v.37 no.5
• /
• pp.376-386
• /
• 2011

Objectives: The aim of this study was to evaluate the microbial hazards posed by food utensils and fixtures in food service operations at selected middle and high schools located in Seoul, Korea. Methods: We collected 200 samples of utensils and fixtures including cups, spoons/chopsticks, food trays and tables from five different schools in Seoul. Target microorganisms of this study were divided into two groups: total bacterial count and total coliform as indicators of microbial contamination and Bacillus cereus and Staphylococcus aureus as pathogens of food poisoning. We used selective media to quantify microbial concentration and 16S rRNA PCR assay for qualitative analysis. In addition, intensive interviews with nutritionists were conducted and observations were made to identify factors that may affect microbial contamination. Logistic regression analysis was employed to examine the relationship between the microbial concentration and operation characteristics of each operation. Results: The level of microbial concentration in school B and C were significantly lower than in school A, D and E (p<0.05). Some samples from school A, D and E showed over 3.4 log CFU/100 $cm^2$ (total bacterial count) and 1.0 log CFU/100 $cm^2$ (total coliform), which requires immediate hygienic action. The number of customers per staff member, periodicity of hygiene education for staff and daily operation time of sterilizers were also found to be important factors related with the microbial contamination of food service operations. Conclusions: These results suggested that not only a HACCP (Hazard Analysis and Critical Control Point) approach, but also efforts to assess internal risk factors within operations be needed to reduce the microbial contamination of food utensils and fixtures. This study is expected to provide preliminary data for assessing microbial hazards in food service operations.

• KDI Journal of Economic Policy
• /
• v.12 no.1
• /
• pp.3-29
• /
• 1990

Korean input-output tables for 1975 and 1985 are first deflated into 1975 constant domestic prices(hypothetical terms), and the constant price I-O data are used to decompose the sources of industrial growth and structural change during the 1975-85 period. Using the same methodology, our results for the 1975-85 period are then linked to the results for the earlier period(1955-75) in order to analyze and evaluate the "demand-side" sources of industrialization over the past three decades. The results from the decomposition of the whole economy indicate that over three decades(1955-85) the relative contribution of domestic demand expansion (DDE) to growth and structural change has continuously declined while the contribution of export expansion(EE) has generally continued to rise. The contribution of import-substitution(IS) which had been significantly higher than that of EE during 1955-63 declined substantially, remaining at an insignificantly low level during the period following 1963. Although it is well known that the government's industrial policy in the 1970s emphasized import-substitution in heavy and chemical industries, no significant changes in the export-oriented growth pattern could be observed even for that period, except for a minor decline in the relative contribution of EE. This may be attributed to the substantially larger, backward-linkage effects of EE than that of IS. The sources-of-growth decompositions for major branches of the manufacturing sector generally support the major conclusions derived from the decomposition for the whole economy. The IS contribution which had been significantly high in almost all manufacturing branches during the 1955-63 period declined to low levels in all but two branches, heavy industry and machinery, during the following period. On the other hand, the relative contribution of EE showed a continuous rise in almost all manufacturing branches(except food processing). Finally, the sources of growth for 1975-85 which were decomposed by detailed sub branches, are analyzed by correlating them with changes in relative prices and industrial protection rates by sub-branches for the same period. A major result is that contrary to general expectations, the EE contributions by sub-branch are not negatively correlated with the nominal rates of protection and/or the effective rates of protection for the same sub-branches. It is also found that no statistically significant, positive correlation exists between IS contributions and nominal protection rates or effective protection rates. These unexpected results may be explained by the peculiar nature of the Korean system of industrial incentives for the past period.

• Journal of Korean Society of Forest Science
• /
• v.61 no.1
• /
• pp.15-19
• /
• 1983

To establish the stand volume table of Pinus koraiensis S. et Z. and Larix leptolepsis Gord. mean diameter at breast height (D), mean height, basal area per ha, stand from height (H.F), basal area height, number of trees per ha, volume per ha, stand age and site were investigated for 107 plots of P. koraiensis and 82 plots of L. leptolepsis throughout the country. The obtained results are as follows; 1) the relationships between stand volume (V) and H.F. were log V=1.3855+0.1168 H.F and log V+0.9929+0.1543 H.F in P. koraiensis and L. leptolepsis, respectively. 2) The relationship between D and H.F was estimated as H.F = 1.2569+0.2576D for P. koraiensis and as H.F = 4.3045+0.1443D for L. leptolepsis 3) Estimated errors calculated with the application of these stand volume tables were 18.29% and 19.22%r for P. koraiensis and L. leptolepsis respectively.