• Title/Summary/Keyword: MDX

Search Result 26, Processing Time 0.031 seconds

On the Aggregation of Multi-dimensional Data using Data Cube and MDX

  • Ahn, Jeong-Yong;Kim, Seok-Ki
    • Journal of the Korean Data and Information Science Society
    • /
    • v.14 no.1
    • /
    • pp.37-44
    • /
    • 2003
  • One of the characteristics of both on-line analytical processing(OLAP) applications and decision support systems is to provide aggregated source data. The purpose of this study is to discuss on the aggregation of multi-dimensional data. In this paper, we (1) examine the SQL aggregate functions and the GROUP BY operator, (2) introduce the Data Cube and MDX, (3) present an example for the practical usage of the Data Cube and MDX using sample data.

  • PDF

Curcumin Alleviates Dystrophic Muscle Pathology in mdx Mice

  • Pan, Ying;Chen, Chen;Shen, Yue;Zhu, Chun-Hua;Wang, Gang;Wang, Xiao-Chun;Chen, Hua-Qun;Zhu, Min-Sheng
    • Molecules and Cells
    • /
    • v.25 no.4
    • /
    • pp.531-537
    • /
    • 2008
  • Abnormal activation of nuclear factor kappa B ($NF-{\kappa}B$) probably plays an important role in the pathogenesis of Duchenne's muscular dystrophy (DMD). In this report, we evaluated the efficacy of curcumin, a potent $NF-{\kappa}B$ inhibitor, in mdx mice, a mouse model of DMD. We found that it improved sarcolemmic integrity and enhanced muscle strength after intraperitoneal (i.p.) injection. Histological analysis revealed that the structural defects of myofibrils were reduced, and biochemical analysis showed that creatine kinase (CK) activity was decreased. We also found that levels of tumor necrosis factor alpha ($TNF-\alpha$), interleukin-1 beta ($IL-1\beta$) and inducible nitric oxide synthase (iNOS) in the mdx mice were decreased by curcumin administration. EMSA analysis showed that $NF-{\kappa}B$ activity was also inhibited. We thus conclude that curcumin is effective in the therapy of muscular dystrophy in mdx mice, and that the mechanism may involve inhibition of $NF-{\kappa}B$ activity. Since curcumin is a non-toxic compound derived from plants, we propose that it may be useful for DMD therapy.

A Multidimensional Analysis Framework for XML Warehouses (XML 웨어하우스에 대한 다차원 분석 프레임워크)

  • Park, Byung-Kwon;Lee, Jong-Hak
    • Asia pacific journal of information systems
    • /
    • v.15 no.4
    • /
    • pp.153-164
    • /
    • 2005
  • Nowadays, large amounts of XML documents are available in the Internet. Thus, we need to analyze them multidimensionally in the same way as relational data. In this paper, we propose a new framework for multidimensional analysis of XML documents, which we call XML-OLAP. We base XML-OLAP on XML warehouses where all fact and dimension data are stored as XML documents. We build XML cubes from XML warehouses. We propose a new OLAP language for XML cubes, which we call XML-MDX. XML-MDX statements target XML cubes and use XQuery expressions to designate measure, axis and slicer. They incorporate text mining operations for aggregating text data. We apply XML-OLAP to the United States patent XML warehouse to demonstrate multidimensional analysis of XML documents.

Multidimensional Analysis of XML Documents using XML Cubes (XML 큐브를 이용한 다차원 XML 문서 분석)

  • Park, Byung-Kwon
    • Proceedings of the Korea Association of Information Systems Conference
    • /
    • 2005.05a
    • /
    • pp.65-78
    • /
    • 2005
  • Nowadays, large amounts of XML documents are available on the Internet. Thus, we need to analyze them multi-dimensionally in the same way as relational data. In this paper, we propose a new frame-work for multidimensional analysis of XML documents, which we call XML-OLAP. We base XML-OLAP on XML warehouses where every fact data as well as dimension data are stored as XML documents. We build XML cubes from XML warehouses. We propose a new multidimensional expression language for XML cubes, which we call XML-MDX. XML-MDX statements target XML cubes and use XQuery expressions to designate the measure data. They specify text mining operators for aggregating text constituting the measure data. We evaluate XML-OLAP by applying it to a U.S. patent XML warehouse. We use XML-MDX queries, which demonstrate that XML-OLAP is effective for multi-dimensionally analyzing the U.S. patents.

  • PDF

A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing (비유일 외래키 조합 복합키 기반의 사실테이블 모델링과 MDX 쿼리문 작성법)

  • Yu, Han-Ju;Lee, Duck-Sung;Choi, In-Soo
    • 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.

  • PDF

A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing (비유일 외래키 조합 복합키 기반의 사실테이블 모델링과 MDX 쿼리문 작성법)

  • Yu, Han-Ju;Lee, Duck-Sung;Choi, In-Soo
    • Journal of the Korea Society of Computer and Information
    • /
    • v.12 no.1 s.45
    • /
    • pp.177-188
    • /
    • 2007
  • A star schema consists of a central fact table, which is surrounded by one or more dimension tables. Each row in 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 retold 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.

  • PDF

Clinical study on the maxillofacial prosthodontic treatment using dental implant: Part I-Color stability of maxillofacial elastomeric materials (치과용 임플란트를 이용한 악안면 보철치료에 관한 임상적 연구 1부-악안면보철용 실리콘의 색안정성)

  • Jin, Tai-Ho;Bowley, John F.
    • The Journal of Korean Academy of Prosthodontics
    • /
    • v.36 no.2
    • /
    • pp.379-388
    • /
    • 1998
  • 본 연구는 악안면보철용 실리콘의 색안정성을 연구하기 위하여 실리콘 재료로 MDX 4-4210 Silicone(Dow Coming. Midland, Mich.)과 A-2186(Factor II, Lakeside, Az)을 사용하고 Mars Violet. Golden Yellow, Red yellow, Raw Sienna등 4종의 색소(Factor II, Lakeside, Az)를 이용하여 시편을 제작한 후 1군은 섭씨5-55도에서 700회 thermocycling하였고, 2군은 10%의 비눗물(Ivory, Proctor & Gamble Inc,. Toronto, Ontario)에 담아 섭씨15-55도에서 700회 thermocycling하였다. 3군은 10%의 비눗물에 담아 75일간 실온에서 보관하였으며 4군은 실온의 암실에 75일간 보관하였다. 5군은 초여름인 6월 중순부터 75일간 햇볕이 잘드는 곳에 위치하였다. 이를 측색색차계(Model TC-6FX, Tokyo Denshoku Co., Japan)를 이용하여 측정하고 색변화를 연구한 결과 다음과 같은 결론을 얻었다. 1. $L^*$값의 경우 모든 실험군에서 대조군에 비해 유의하게 감소하였다. 2. $a^*$값의 경우 대부분의 실험군에서 증가하였으나 Raw sienna, Mars violet색소를 사용한 실험 3.4.5군의 MDX4-4210의 경우 감소하는 경향을 보였다. 3. $b^*$값은 실험1.2.3군의 경우 대부분 감소하였고 실험4.5.군의 경우에서 증가하였으나 3.4.5군의 경우에서 대부분 유의한 차이가 없었다. 4. ${\Delta}E$의 값은 실험군에서 대부분 감소하였으나 4군의 A-2186에서 증가하는 경향을 보였고 실험2군의 Red yellow, Mars violet을 사용한 MDX4-4210에서 비교적 큰 변화를 보였다. 5. $L^{\ast}$값과 a값의 변화량의 합은 A-2186의 경우에서 크게 나타났으나 ${\Delta}E$값의 변화량은 MDX4-4210에서 크게 나타났다. 6. $L^*$값의 변화량의 합은 실험4군에서 크게 나타났으며 $a^*$값은 1군에서, $b^*$값과 ${\Delta}E$값의 변화량의 합은 2군에서 크게 나타났다.

  • PDF

Dose Characteristics for IORT Applicator of ML-15MDX Electron Beam (ML-15MDX 술중조사용 Applicator에 의한 전자선선량 특성)

  • Choi, Tae-Jin;Lee, Ho-Joon;Kim, Yeung-Ae;Kim, Jin-Hee;Kim, Ok-Bae
    • Radiation Oncology Journal
    • /
    • v.11 no.2
    • /
    • pp.455-461
    • /
    • 1993
  • Experimental measurements of dose characteristics with pentagonal applicator at nominal energy of 4, 6, 9, 12 and 15 MeV electron beam were performed for intraoperative radiotherapy (IORT) in ML-15MDX linear accelerator. This paper presents the percent depth dose, surface dose, beam flatness and output factors of using the IORT applicator in different electron beam energy. The output factor showed as a 24 percent higher in IORT applicator than that of reference $10{\times}10cm^2$ applicator. The surface dose of using the IORT applicator showed 7.7 and 2.7 percent higher than that of reference field in 4 and 15 MeV electron beam, respectively. In our experiments, the variation of percent depth dose was very small but the output factor and flatnees at 0.5 cm depth have showed a large value in IORT applicator.

  • PDF

A new hash function based on MDx-family hash functions (MDx-계열 해쉬 함수에 기반한 새로운 해쉬 함수)

  • 신상욱
    • Journal of the Korea Institute of Information Security & Cryptology
    • /
    • v.7 no.4
    • /
    • pp.59-71
    • /
    • 1997
  • 암호적으로 안전한 해쉬 함수는 디지털 서명, 메세지 인증, 키 유도와 같은 분야에서 중요한 암호도구이다. 현재까지 제안된 소프트웨어로 고속 수행이 가능한 해쉬 함수들의 대부분은 Rivest가 제안한 MD4의 설계 원리에 기반을 두고 있다. 이들 DM계열 해쉬 함수 중에서 현재 안전하다고 알려진 전용 해쉬 함수는 SHA-1, RIPEMD-160, HAVAL등이다.본 논문에서는 디들 세가지 해쉬 함수들의 장점에 기반하여 이들 함수들이 가지는 안전성을 최대한 유지하면서 보다 효율적인 새로운 해쉬 함수를 제안한다. 제안된 해쉬 함수는 임의 길이 메시지를 512비트 단위로 처리하여 160비트의 출력을 가진다. 제안된 해쉬 함수는 입력 데이터에 의존한 순환이동(data-dependent rotation)의 특징을 가짐으로써 기존에 알려진 공격에 강인함을 보장하며 두 새의 충돌 메시지 발견을 위해서는 생일공격에 의해 2연산이 요구되어진다고 추측된다. 제안된 해쉬 함수의 성능은 수행 속도면에서 RIPEMD-160보다 약 30%보다는 약 7%효율적이다.

Approximated Model and Chaining Pattern of Hash Functions (해쉬 함수의 근사적 모델과 연쇄패턴)

  • Lee Sun-Young
    • Journal of Internet Computing and Services
    • /
    • v.7 no.1
    • /
    • pp.39-47
    • /
    • 2006
  • The evaluation of MDx family hash functions such as MD5 is difficult because the design background or a generalized model is unknown. In this paper, an approximated model is proposed to generalize hash functions. The diffusion of a input difference is tested by an approximated model for MD5. The results show that MD5 does not provide perfect diffusion, so MD5 is weak against some attacks. We propose a multiple chaining pattern which provides perfect diffusion in approximated model of hash function without extra calculation or memory. And We show the probability of differential characteristics of our proposal.

  • PDF