• Title/Summary/Keyword: Log-Structure

Search Result 352, Processing Time 0.026 seconds

The Recovery Method for MySQL InnoDB Using Feature of IBD Structure (IBD 구조적특징을이용한 MySQL InnoDB의레코드복구기법)

  • Jang, Jeewon;Jeoung, Doowon;Lee, Sang Jin
    • KIPS Transactions on Computer and Communication Systems
    • /
    • v.6 no.2
    • /
    • pp.59-66
    • /
    • 2017
  • MySQL database is the second place in the market share of the current database. Especially InnoDB storage engine has been used in the default storage engine from the version of MySQL5.5. And many companies are using the MySQL database with InnoDB storage engine. Study on the structural features and the log of the InnoDB storage engine in the field of digital forensics has been steadily underway, but for how to restore on a record-by-record basis for the deleted data, has not been studied. In the process of digital forensic investigation, database administrators damaged evidence for the purpose of destruction of evidence. For this reason, it is important in the process of forensic investigation to recover deleted record in database. In this paper, We proposed the method of recovering deleted data on a record-by-record in database by analyzing the structure of MySQL InnoDB storage engine. And we prove this method by tools. This method can be prevented by database anti forensic, and used to recover deleted data when incident which is related with MySQL InnoDB database is occurred.

Initial Risk Assessment of Benzoyl peroxide in Environment (Benzoyl peroxide의 환경에서의 초기 위해성 평가)

  • Kim Mi Kyoung;Bae Heekyung;Kim Su-Hyon;Song Sanghwan;Koo Hyunju;Park Kwangsik;Lee Moon-Soon;Jeon Sung-Hwan;Na Jin-Gyun
    • Environmental Analysis Health and Toxicology
    • /
    • v.19 no.1
    • /
    • pp.33-40
    • /
    • 2004
  • Benzoyl peroxide is a High Production Volume Chemical, which is produced about 1,371 tons/year in Korea as of 2001 survey. The substance is mainly used as initiators in polymerization, catalysts in the plastics industry, bleaching agents for flour and medication for acne vulgaris. In this study, Quantitative Structure-Activity Relationships (QSAR) are used for getting adequate information on the physical -chemical properties of this chemical. And hydrolysis in water, acute toxicity to aquatic and terrestrial organisms for benzoyl peroxide were studied. The physical -chemical properties of benzoyl peroxide were estimated as followed; vapor pressure=0.00929 Pa, Log $K_{ow}$ = 3.43, Henry's Law constant=3.54${\times}$10$^{-6}$ atm-㎥/mole at $25^{\circ}C$, the half-life of photodegradation=3 days and bioconcentration factor (BCF)=92. Hydrolysis half-life of benzoyl peroxide in water was 5.2 hr at pH 7 at $25^{\circ}C$ and according to the structure of this substance hydrolysis product was expected to benzoic acid. Benzoyl peroxide has toxic effects on the aquatic organisms. 72 hr-Er $C_{50}$ (growth rate) for algae was 0.44 mg/1.,48 hr-E $C_{50}$ for daphnia was 0.07mg/L and the 96hr-L $C_{50}$ of acute toxicity to fish was 0.24mg/L. Acute toxicity to terrestrial organisms (earth worm) of benzoyl peroxide was low (14 day-L $C_{50}$ = > 1,000 mg/kg). Although benzoyl peroxide is high toxic to aquatic organisms, the substance if not bioaccumulated because of the rapid removal by hydrolysis (half-life=5.2 hr at pH 7 at $25^{\circ}C$) and biodegradation (83% by BOD after 21 days). The toxicity observed is assumed to be due to benzoyl peroxide rather than benzoic acid, which shows much lower toxicity to aquatic organisms. One can assume that effects occur before hydrolysis takes place. From the acute toxicity value of algae, daphnia and fish, an assessment factor of 100 was used to determine the predicted no effect concentration (PNEC). The PNEC was calculated to be 0.7$\mu\textrm{g}$/L based on the 48 hr-E $C_{50}$ daphnia (0.07 mg/L). The substance shows high acute toxicity to aquatic organisms and some information indicates wide-dispersive ore of this substance. So this substance is, a candidate for further work, even if it hydrolysis rapidly and has a low bioaccumulation potential. This could lead to local concern for the aquatic environment and therefore environmental exposure assessment is recommended.

Analysis of extreme wind speed and precipitation using copula (코플라함수를 이용한 극단치 강풍과 강수 분석)

  • Kwon, Taeyong;Yoon, Sanghoo
    • Journal of the Korean Data and Information Science Society
    • /
    • v.28 no.4
    • /
    • pp.797-810
    • /
    • 2017
  • The Korean peninsula is exposed to typhoons every year. Typhoons cause huge socioeconomic damage because tropical cyclones tend to occur with strong winds and heavy precipitation. In order to understand the complex dependence structure between strong winds and heavy precipitation, the copula links a set of univariate distributions to a multivariate distribution and has been actively studied in the field of hydrology. In this study, we carried out analysis using data of wind speed and precipitation collected from the weather stations in Busan and Jeju. Log-Normal, Gamma, and Weibull distributions were considered to explain marginal distributions of the copula. Kolmogorov-Smirnov, Cramer-von-Mises, and Anderson-Darling test statistics were employed for testing the goodness-of-fit of marginal distribution. Observed pseudo data were calculated through inverse transformation method for establishing the copula. Elliptical, archimedean, and extreme copula were considered to explain the dependence structure between strong winds and heavy precipitation. In selecting the best copula, we employed the Cramer-von-Mises test and cross-validation. In Busan, precipitation according to average wind speed followed t copula and precipitation just as maximum wind speed adopted Clayton copula. In Jeju, precipitation according to maximum wind speed complied Normal copula and average wind speed as stated in precipitation followed Frank copula and maximum wind speed according to precipitation observed Husler-Reiss copula.

A Study on the Build-up Model for the Discount Rate of Technology Valuation including Intellectual Property Risk (지식자산위험을 고려한 기술가치평가 할인율 적산모형에 관한 연구)

  • Sung, Oong-Hyun
    • Journal of Korea Technology Innovation Society
    • /
    • v.11 no.2
    • /
    • pp.241-263
    • /
    • 2008
  • Within any income approach, a discount rate is used to convert some projected free cash flow to its presented value. In case of valuing companies, the most frequently used discount rate is the weighted average cost of capital(WACC) at the aggregate level. But technology valuation is different to discounting aggregate corporate cash flow since it is concerned about individual Intellectual property. Therefore, blindly applying standard discount rate such as WACC in technology valuation is unlikely to lead to the right result. The primary focus of this paper is to establish the structure of discount rate for technology valuation and to suggest the method of estimation. To determine an appropriate discount rate for technology valuation, the level of technology risk, market risk and competitive risk should be included in the structure of discount rate. This paper suggests the build-up model which consists of three components as a expansion of the CAPM. It includes (1) a risk-free rate of return, (2) general market risk premium and beta and (3) intellectual property risk premium related to technology risk and specific target market risk. However, there is no specific check list for examining the intellectual property risk until now and no specific method for quantifying its risk into risk premium. This paper developed the 10 element to determine the level of the intellectual property risk and applied estimation function such as linear function, natural log function and exponential function to transform the level of risk into risk premium. The limitation of this paper is that the range of intellectual property risk premium is inferred based on the information of foreign and domestic valuation agency. Finally, this paper explored the development of an intellectual property discount rate for technology valuation and presented the method in order to quantify the intellectual property risk premium.

  • PDF

Evaluating the Visual Contrast Rating of the Landscape Impact Factors - A case study for the Buildings in Natural Landscape - (경관영향 요소별 경관 대비성 평가 - 자연경관에 도입되는 건축물을 중심으로 -)

  • Choi, Won-Bin;Shin, Ji-Hoon
    • Journal of Korean Society of Rural Planning
    • /
    • v.24 no.3
    • /
    • pp.87-96
    • /
    • 2018
  • While cities became bigger and bigger since 1990s, many indiscretely high buildings started to be built in the mountain areas inside a city and in the rural areas in the suburb of each city. To regulate such indiscrete developments, the government prepared for some relevant legal and institutional criteria by having enacted the "Landscape Act" and established a strong management means in the legal and institutional aspects by having introduced the natural landscape deliberation system and the landscape deliberation one into the "Natural Environment Conservation Act." However, since some uniform levels of absolute height and no. of stories are suggested legally and institutionally, it is hard to consider the effects of a real building structure onto the relevant landscape. Accordingly, this thesis is intended to grasp the contrast of the landscape elements in the allowable height section, which is presented through landscape sensitivity. As the results from the visual contrast rating on a small apartment complex located in Dangjin and a large scale of apartment complex in Seosan as the apartment complexes surrounded with natural landscapes that were selected as the subjects of this study, the following conclusion can be finalized. First, there were deducted some factors, that is, forms, lines, colors, textures and sizes as the ones with which can measure and evaluate the contrasting properties when a structure gets into a natural landscape. Second, in case of a small scale of apartment complex (in the foreground) compared to a large one (in the foreground), it was found that the contrasting properties were bigger. In addition, it was also found that the contrasting property of the landscape factor of the foreground compared to that of the middle one becomes bigger depending on a distance. Third, as the results from an evaluation on the contrasting properties of the landscape factor depending on the changes of each floor of a structure, it was found that the factors, that is, forms, lines, colors, textures and sizes are very significant. Among those factors, the factors, forms and lines in a small scale of apartment complex (in the foreground) showed each log regression. But in all of the other cases, they showed each line regression. Fourth, as the results from examining the regression coefficients of the landscape factor, the coefficients of the shapes and lines have similar coefficients and the colors and the textures have similar ones, too. In case of the sizes of apartment complexes, the colors and the textures of a large apartment complex (in the foreground) have similar coefficients, in case of that in the middle ground, the shapes and lines have similar coefficients. Fifth, as the results from estimating the contrasting properties of the landscape factor on the floors within the allowed scope of the landscape sensitivity, it was found that the contrasting property was 3.5 to 4.9 in case of a small scale of apartment complex (in the foreground), but 2.5to 3.7 in case of a small scale of one. In case of a large scale of apartment complex, the value was 3.5 to 5.3, but in case of a large one in the middle ground was 2.9 to 4.9. Sixth, it was comprehended that the contrasting properties of the landscape factor become different depending on each size of apartment complex and the distance of a view point. In this study, it is intended to find the meaning from the aspect that the results can be used as the baseline data for comprehending a proper range of heights of structures objectively during a natural landscape deliberation or a landscape deliberation.

A Study on Pseudo N-gram Language Models for Speech Recognition (음성인식을 위한 의사(疑似) N-gram 언어모델에 관한 연구)

  • 오세진;황철준;김범국;정호열;정현열
    • Journal of the Institute of Convergence Signal Processing
    • /
    • v.2 no.3
    • /
    • pp.16-23
    • /
    • 2001
  • In this paper, we propose the pseudo n-gram language models for speech recognition with middle size vocabulary compared to large vocabulary speech recognition using the statistical n-gram language models. The proposed method is that it is very simple method, which has the standard structure of ARPA and set the word probability arbitrary. The first, the 1-gram sets the word occurrence probability 1 (log likelihood is 0.0). The second, the 2-gram also sets the word occurrence probability 1, which can only connect the word start symbol and WORD, WORD and the word end symbol . Finally, the 3-gram also sets the ward occurrence probability 1, which can only connect the word start symbol , WORD and the word end symbol . To verify the effectiveness of the proposed method, the word recognition experiments are carried out. The preliminary experimental results (off-line) show that the word accuracy has average 97.7% for 452 words uttered by 3 male speakers. The on-line word recognition results show that the word accuracy has average 92.5% for 20 words uttered by 20 male speakers about stock name of 1,500 words. Through experiments, we have verified the effectiveness of the pseudo n-gram language modes for speech recognition.

  • PDF

BVI PHOTOMETRIC STUDY OF THE OLD OPEN CLUSTER RUPRECHT 6

  • Kim, Sang Chul;Kyeong, Jaemann;Park, Hong Soo;Han, Ilseung;Lee, Joon Hyeop;Moon, Dae-Sik;Lee, Youngdae;Kim, Seongjae
    • Journal of The Korean Astronomical Society
    • /
    • v.50 no.3
    • /
    • pp.79-92
    • /
    • 2017
  • We present a BV I optical photometric study of the old open cluster Ruprecht 6 using the data obtained with the SMARTS 1.0 m telescope at the CTIO, Chile. Its color-magnitude diagrams show the clear existence of the main-sequence stars, whose turn-off point is located around $V{\approx}18.45mag$ and $B-V{\approx}0.85mag$. Three red clump (RC) stars are identified at V = 16.00 mag, I = 14.41 mag and B - V = 1.35 mag. From the mean $K_s-band$ magnitude of RC stars ($K_s=12.39{\pm}0.21mag$) in Ruprecht 6 from 2MASS photometry and the known absolute magnitudes of the RC stars ($M_{K_S}=-1.595{\pm}0.025mag$), we obtain the distance modulus to Ruprecht 6 of $(m-M)_0=13.84{\pm}0.21mag$ ($d=5.86{\pm}0.60kpc$). From the ($J-K_s$) and (B - V ) colors of the RC stars, comparison of the (B - V ) and (V - I) colors of the bright stars in Ruprecht 6 with those of the intrinsic colors of dwarf and giant stars, and the PARSEC isochrone fittings, we derive the reddening values of E(B - V ) = 0.42 mag and E(V - I) = 0.60 mag. Using the PARSEC isochrone fittings onto the color-magnitude diagrams, we estimate the age and metallicity to be: $log(t)=9.50{\pm}0.10(t=3.16{\pm}0.82Gyr)$ and $[Fe/H]=-0.42{\pm}0.04dex$. We present the Galactocentric radial metallicity gradient analysis for old (age > 1 Gyr) open clusters of the Dias et al. catalog, which likely follow a single relation of $[Fe/H]=(-0.034{\pm}0.007)R_{GC}+(0.190{\pm}0.080)$ (rms = 0.201) for the whole radial range or a dual relation of $[Fe/H]=(-0.077{\pm}0.017)R_{GC}+(0.609{\pm}0.161)$ (rms = 0.152) and constant ([Fe/H] ~ -0.3 dex) value, inside and outside of RGC ~ 12 kpc, respectively. The metallicity and Galactocentric radius ($13.28{\pm}0.54kpc$) of Ruprecht 6 obtained in this study seem to be consistent with both of the relations.

Statistical Properties of Material Strength of Concrete, Re-Bar and Strand Used in Domestic Construction Site (국내 현장의 콘크리트, 철근 및 강연선 재료 강도에 대한 통계 특성 분석)

  • Paik, In-Yeol;Shim, Chang-Su;Chung, Young-Soo;Sang, Hee-Jung
    • Journal of the Korea Concrete Institute
    • /
    • v.23 no.4
    • /
    • pp.421-430
    • /
    • 2011
  • As a fundamental study to introduce the reliability-based design code, a statistical study is conducted for the material strength data collected from domestic construction sites. In order to develop a rational design code based on statistics and reliability theory, it is essential to obtain the statistical properties of material strength. Material strength data for concrete, reinforcing bars, and prestressing strands which are used in domestic construction sites are collected and statistically analyzed. Then, the statistical properties are compared with those used in the process of the reliability-based calibration of internationally leading design codes. The statistical properties of the domestic data are such that the bias factor is relatively uniform between 1.13 and 1.20 and the coefficient of variation is below 0.10. Reinforcing bar data show difference among different manufacturers but there is not much difference among re-bar diameters. In the case of tendons, which are high strength materials, both of the domestic and foreign data show smaller values of the bias factor and the coefficient of variation than those of concrete and re-bar. Statistical distribution of all the material strength can be properly assumed as normal, log-normal, or Gumbel distribution after analyzing the classified data by individual construction site and manufacturer rather than the mixed data obtained from different sources in order to express the individual distribution of each structure.

A Colored Workflow Model for Business Process Analysis (비즈니스 프로세스 분석을 위한 색채형 워크플로우 모델)

  • Jeong, Woo-Jin;Kim, Kwang-Hoon
    • Journal of Internet Computing and Services
    • /
    • v.10 no.3
    • /
    • pp.113-129
    • /
    • 2009
  • Abstract Corporate activities are composed of numerous working processes and during the working flow, various business processes are being created and completed simultaneously. Enterprise Resources Planning (ERP) makes the working process simple, yet creates more complicated work structure and therefore, there is an absolute need of efficient management for business processes. The workflow literature has been looking for efficient and effective ways of rediscovering and mining workflow intelligence and knowledge from their enactment histories and event logs. As part of studies to analyze and improve the process, the concepts of 'Process Mining', 'Process re-discovery', 'BPR (Business Process Reengineering)' have appeared and the studies for practical implementation are proactively being done. However, these studies normally follow the approach throughout data warehousing for log data of process instances. It is very hard for these approaches to reflect user's intention to the rediscovering and mining activities. The process instances designed based on the consideration of analysis can make groupings effectively and when the analysis demand of user changes within the analysis domain can also reduce the cost of analysis. Therefore, the thesis proposes a special type of workflow model, which is called a colored workflow model, that is extended from the ICN (information control net) modeling methodology by reinforcing the concept of colored token. The colored tokens represent the conceptual types of constraints and criteria that can be used to classifying and grouping the workflow intelligence and knowledge extracted from the corresponding workflow models' enactment histories and event logs. Through the runtime information of process instances, it makes possible to analyze proactive and user-oriented process with the goal of deriving business knowledge from the beginning of process definition.

  • PDF

Fine mapping of rice bacterial leaf blight resistance loci to major Korean races of Xoo (Xanthomonas oryzae)

  • Lee, Myung-Chul;Choi, Yu-Mi;Lee, Sukyeung;Yoon, Hyemyeong;Oh, Sejong
    • Proceedings of the Plant Resources Society of Korea Conference
    • /
    • 2018.10a
    • /
    • pp.73-73
    • /
    • 2018
  • Bacterial leaf blight(BLB), caused by X. oryzae pv. oryzae(Xoo), is one of the most destructive diseases of rice due to its high epidemic potential. Understanding BLB resistance at a genetic level is important to further improve the rice breeding that provides one of the best approaches to control BLB disease. In the present investigation, a collection of 192 accessions was used in the genome-wide association study (GWAS) for BLB resistance loci against four Korean races of Xoo that were represented by the prevailing BLB isolates under Xoo differential system. A total of 192 accessions of rice germplasm were selected on the basis of the bioassay using four isolated races of Xoo such as K1, K2, K3 and K3a. The selected accessions was used to prepare 384-plex genotyping by sequencing (GBS) libraries and Illumina HiSeq 2000 paired- end read was used for GBS sequencing. GWAS was conducted using T ASSEL 5.0. The T ASSEL program uses a mixed linear model (MLM). T he results of the bioassay using a selected set of 192 accessions showed that a large number of accessions (93.75%) were resistant to K1 race, while the least number of accessions (34.37%) resisted K3a race. For races K2 and K3, the resistant germplasm proportion remained between 66.67 to 70.83%. T he genotypic data produced SNP matrix for a total of 293,379 SNPs. After imputation the missing data was removed, which exhibited 34,724 SNPs for association analysis. GWAS results showed strong signals of association at a threshold of [-log10(P-value)] more than5 (K1 and K2) and more than4 (K3 and K3a) for nine of the 39 SNPs, which are plausible candidate loci of resistance genes. T hese SNP loci were positioned on rice chromosome 2, 9, and 11 for K1 and K2 races, whereas on chromosome 4, 6, 11, and 12 for K3 and K3a races. The significant loci detected have also been illustrated, NBS-LRR type disease resistance protein, SNARE domain containing protein, Histone deacetylase 19, NADP-dependent oxidoreductase, and other expressed and unknown proteins. Our results provide a better understanding of the distribution of genetic variation of BLB resistance to Korean pathogen races and breeding of resistant rice.

  • PDF