• Title/Summary/Keyword: Data Transformation

Search Result 2,070, Processing Time 0.03 seconds

An Efficient Transformation Technique from Relational Schema to Redundancy Free XML Schema (관계형 스키마로부터 중복성이 없는 XML 스키마로의 효율적인 변환 기법)

  • Cho, Jung-Gil
    • Journal of Internet Computing and Services
    • /
    • v.11 no.6
    • /
    • pp.123-133
    • /
    • 2010
  • XML has been become the new standard for publishing and exchanging data on the Web. However, most business data is still stored and maintained in relational database management systems. As such, there is an increasing need to efficiently publish relational data as XML data for Internet-based applications. The most important issue in the transformation is to reflect structural and semantic relations of RDB to XML schema exactly. Most transformation approaches have been done to resolve the issue, but those methods have several problems. In this paper, we discuss algorithm in transforming a relational database schema into corresponding XML schema in XML Schema. We aim to achieve not only explicit/implicit referential integrity relation information but also high level of nested structure while introducing no data redundancy for the transformed XML schema. To achieve these goals, we propose a transformation model which is redundancy free and then we improve the XML Schema structure by exploring more nested structure.

Geostatistical Simulation of Compositional Data Using Multiple Data Transformations (다중 자료 변환을 이용한 구성 자료의 지구통계학적 시뮬레이션)

  • Park, No-Wook
    • Journal of the Korean earth science society
    • /
    • v.35 no.1
    • /
    • pp.69-87
    • /
    • 2014
  • This paper suggests a conditional simulation framework based on multiple data transformations for geostatistical simulation of compositional data. First, log-ratio transformation is applied to original compositional data in order to apply conventional statistical methodologies. As for the next transformations that follow, minimum/maximum autocorrelation factors (MAF) and indicator transformations are sequentially applied. MAF transformation is applied to generate independent new variables and as a result, an independent simulation of individual variables can be applied. Indicator transformation is also applied to non-parametric conditional cumulative distribution function modeling of variables that do not follow multi-Gaussian random function models. Finally, inverse transformations are applied in the reverse order of those transformations that are applied. A case study with surface sediment compositions in tidal flats is carried out to illustrate the applicability of the presented simulation framework. All simulation results satisfied the constraints of compositional data and reproduced well the statistical characteristics of the sample data. Through surface sediment classification based on multiple simulation results of compositions, the probabilistic evaluation of classification results was possible, an evaluation unavailable in a conventional kriging approach. Therefore, it is expected that the presented simulation framework can be effectively applied to geostatistical simulation of various compositional data.

A Study on the Transformation of Housing in Sohawjang (소화장(昭和莊)의 주거 변용(變容)에 관한 연구)

  • Jung, Mi-Jung;Yoo, Jae-Woo;Kim, Dong-Chul
    • Proceeding of Spring/Autumn Annual Conference of KHA
    • /
    • 2011.04a
    • /
    • pp.89-92
    • /
    • 2011
  • Built in 1944, in Busan, Sohawjang has currently remained in severe state of transformation. Sohawjang is a rare case of modern housing complex in Korea and it is a significant historic building as housing history and technique history. This study is to leave the basic data about modern housing by finding the substance of Sohawjang, a unusual case of modern housing complex in Korea, and examples of housing transformation through this study. This study attempts to find the original shape and architectural history about Sohawjang, modern apartment building, and analyze the actual conditions of transformation. For implementing, this study carried out the surveys and interviews with experimental research. As the result of the study, after the independence, various cases of transformation were investigated from floor plan of Japanese middle corridor. This study classified according to types of housing by analyzing outcomes and examined the reason and characteristic of transformation. This study discovered the Sohawjang's housing transformation cases, modern housing complex, that has not been disclosed so far and draw the characteristic of transformation as the Architectural Planning.

  • PDF

N.M.for the Effect of P.T. on Resicual Stress Relaxation (잔류응력 완화에 미치는 상변태의 수치적 모델링)

  • 장경복;손금렬;강성수
    • Journal of Welding and Joining
    • /
    • v.17 no.6
    • /
    • pp.84-89
    • /
    • 1999
  • Most of ferrous b.c.c weld materials may experience martensitic transformation during rapid cooling after welding. It is well known that volume expansion due to the phase transformation could influence on the relaxation of welding residual stress. To apply this effect practically, it is a prerequisite to establish a numerical model which is able to estimate the effect of phase transformation on residual stress relaxation quantitatively. For this purpose, the analysis is carried out in two regions. i.e., heating and cooling, because the variation of material properties following a phase transformation in cooling is different in comparison with the case in heating, even at the same temperature. The variation of material properties following phase transformation is considered by the adjustment of specific heat and thermal expansion coefficient, and the distribution of residual stress in analysis is compared with that of experiment by previous study. consequently, in this study, simplified numerical procedures considering phase transformation, which based on a commercial finite element package was established through comparing with the experimental data of residual stress distribution by other researcher. To consider the phase transformation effect on residual stress relaxation, the transition of mechanical and thermal property such as thermal expansion coefficient and specific heat capacity was found by try and error method in this analysis.

  • PDF

Characteristics and Treatment Outcomes of Patients with Malignant Transformation Arising from Mature Cystic Teratoma of the Ovary: Experience at a Single Institution

  • Oranratanaphan, Shina;Khemapech, Nipon
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.14 no.8
    • /
    • pp.4693-4697
    • /
    • 2013
  • Background: Malignant transformation arising in mature cystic teratoma (MCT) is one of the most serious complications of MCT. Squamous cell carcinoma is the most common malignant change. Some clinical findings such as advanced age group and large tumor size are significant risk factors of malignant transformation. This study was conducted in order to evaluate characteristics, cell types, treatment and outcome of malignant transformation arising from dermoid cysts in our institution. Materials and Methods: A retrospective chart review was performed. General characteristics, operative data, procedure, operative finding and operative outcome were analyzed. Statistical assessment was performed with SPSS version 17.0, using mean, mode, median and percentage to describe those data. Results: During the 10 years period, 11 cases of malignant transformation from a total of 753 cases (1.46% incidence) of MCT were reviewed. Mean age of the patients was 41.2 years (SD 4.34, range 24-70). The most common presenting symptom was a palpable mass (8 cases; 72.7%). Primary surgical staging was performed in 4 patients (36.4%). Re-staging was conducted in the other 4. Complete cytoreduction was obtained in 45.5% (5 cases) and optimal surgical resection was obtained in 36.4% (4 cases). Mean tumor size was 14.1 cm. (SD 1.55, range 6-20). Squamous cell carcinoma was found in 36.4% (4 cases) and mucinous cancer in the other 4. More than half of them were stage Ia (54.5%, 6 cases). All patients whose stage more than Ia received chemotherapy (45.5%). Mean disease free survival was 5.53 years (1.32, 0.3-10). Conclusion: According to our study, the incidence of malignant transformation was consistent with previous studies. The common malignant transformation histologic types are both squamous and mucinous carcinoma which differed from previous reports. Early detection for early stage disease and optimal surgery are important for long term survival.

A Study on the Priority of the Factors that Influence Digital Transformation Using AHP (AHP를 이용한 디지털트랜스포메이션에 영향을 미치는 요인의 우선순위에 관한 연구)

  • Jong Soo Mok;Jay In Oh
    • The Journal of Bigdata
    • /
    • v.7 no.1
    • /
    • pp.139-171
    • /
    • 2022
  • Big Data and the fourth industrial revolution are the first revolution that has not spawned a new form of energy but has triggered a new technological phenomenon called digitization. Digital transformation has caused disruptive innovation, and each country and major corporations need to respond to it. Despite this importance, empirical studies at home and abroad are insufficient. Therefore, in this study, factors affecting the promotion of corporate digital transformation were discovered through literature review, and a research model was developed and empirically analyzed by modifying and supplementing it through a Delphi study. The research model was composed of the main standards such as technology, innovation, organization, and environment and 17 sub-standards by combining the IDT and TOE models. In order to empirically analyze this, the AHP decision-making technique was used for experts in domestic digital transformation promotion companies and business partners. Companies that promote digital transformation will be able to increase the chances of achieving successful digital transformation if they take into account the factors that influence the digital transformation promotion according to the characteristics of the type of industry and company size of the group to which the company belongs.

Data Transformation through Mapping between XML and Relation Database (XML과 관계형 데이타베이스 매핑을 통한 자료의 변환)

  • Kim Gil-Choon
    • Journal of the Korea Society of Computer and Information
    • /
    • v.9 no.4 s.32
    • /
    • pp.5-12
    • /
    • 2004
  • The data transformation between XML and Relation Database is made through the Principle of mapping bewtween them. There are two ways to access SQL Server, one is to assign SQL query to URL and the other is to use template file. MS-SQL server takes advantage of OpenXML function to transform the results of executing SQL query into XML documents. That is, OpenXML first makes node tree and then transforms row set data of XML documents into XML data of relation type. In order to insert XML data into database data. data is extracted from parsing XML documents using sp_xml_preparedocument procedure, and then the document structure is mapped into tree structure and stored in a table of database. Consequently, Data transformation between XML and Relation Database is made through mapping bewtween them. This article proposes the principle of mapping between XML and Relation Database and then shows the implementation of transformation between them so that it introduces the possibilty of bringing the extension and efficiency of data and various effects.

  • PDF

Numerical Modeling of the Transformation Temperature Effect on the Relaxation of Welding Residual Stress (용접 잔류응력 완화에 미치는 변태 온도의 영향에 관한 수치적 모델링)

  • Jang, Gyoung-Bok;Kang, Sung-Soo
    • Transactions of the Korean Society of Mechanical Engineers A
    • /
    • v.24 no.10 s.181
    • /
    • pp.2552-2559
    • /
    • 2000
  • Most of ferrous b.c.c weld materials have martensitic transformation during rapid cooling after welding. It is well known that volume expansion due to the phase transformation could influence on the relaxation of welding residual stress. To apply this effect practically, it is necessary to establish a numerical model which is able to estimate the effect of phase transformation on residual stress relaxation quantitatively. For this purpose, the analysis is carried out in two regions, i.e., heating and cooling, because the variation of material properties following a phase transformation in cooling is different in comparison with the case in heating, even at the same temperature. The variation of material properties following phase transformation is considered by the adjustment of specific heat and thermal expansion coefficient, and the distribution of residual stress in analysis is compared with that of experiment by previous study. In this study, simplified numerical procedures considering phase transformation, which based on a commercial finite element package was established through comparing with the experimental data of residual stress distribution by other researcher. To consider the phase transformation effect on residual stress relaxation, the transition of mechanical and thermal property such as thermal expansion coefficient and specific heat capacity was found by try and error method in this analysis. In addition to, since the transformation temperature changes by the kind and control of alloying elements, the steel with many kinds of transformation temperature were selected and the effect of transformation on stress releasement was investigated by the numerical procedures considering phase transformation.

e-Transformation Strategy of Data Integration Model : Long-Term Care Agency Case (데이터 통합 모델 기반 e-Transformation 전략 : 장기요양기관 사례)

  • Um, Hyemi
    • Journal of Information Technology Applications and Management
    • /
    • v.28 no.3
    • /
    • pp.23-30
    • /
    • 2021
  • Korea currently provides long-term care benefits for the elderly with poor functionality, but most of the service providers are private businesses. This is the time when quality management of care services is required, which is just around the corner of the super-aged era. In this study, we would like to look at the case in which 'A company', which operates a long-term care institution, attempted to make voluntary changes ahead of social demands. The company tried to transform the social needs of quality management by judging them as opportunities, not threats, and establishing an integrated database of centers. First, the company processed data and built a cloud-based database system. Second, the company automatically linked data from existing systems for the efficiency of data utilization. Third, the company pursued visualization for the convenience of data utilization. This allowed the company to make data-driven strategic decisions internally. This is expected to increase sales as it will soon lead to securing new customers and pioneering new markets. It is also significant in that it can provide best practices for the long-term care industry.

Factors Influencing the Effects of Online Product Transformation : Online Shopping benefits, Electronic Word-of-Mouth, and Consumer Characteristics (온라인 제품전환 효과에 영향을 미치는 요인 : 온라인 쇼핑혜택, 구전, 소비자 특성을 중심으로)

  • Lee Yon-Jin;Park Cheol
    • Journal of Information Technology Applications and Management
    • /
    • v.13 no.3
    • /
    • pp.181-200
    • /
    • 2006
  • The purpose of this study is to examine factors influencing online product transformation focusing on benefits of online shopping and word of mouth. Generally, it has been known that buying search goods is more proper than experience goods in the online. However benefits of online shopping and word of mouth make product transformation from experience goods to search goods and the product transformation promote the purchase of experience goods online. We developed a conceptual model of online product transformation including benefits of online shopping(e.g. good price and convenience), online word of mouth (e.g. bulletin board and consumer reviews), and consumer characteristics (e.g. innovativeness and Internet usage). Also, we suggest several research propositions on online product transformation. The implications for marketing strategies of experience goods and furher research direction are suggested.

  • PDF