• Journal of Internet Computing and Services
• /
• v.10 no.2
• /
• pp.99-116
• /
• 2009

For the mapping of two dimensional table structures of relational databases to the hierarchical XML documents, we apply the foreign key relationships of relational databases. In other words, the primary key of another table referenced by a foreign key of one tuple is mapped to the parent of the foreign key. Then XML hierarchies with order are expressed. In addition, the XML view file generated by the foreign key mappings shows side effects in the case of the relational database update for the satisfaction of referential integrity constraint in the foreign key. Thus, by inferring the foreign key roles at the generation of XML hierarchies, we can anticipate where the side effects occur in the hierarchies. We keep the XML view files up-to-date by reflecting the side effects to the XML files at the update of the underlying relational databases.

• 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 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.

• Journal of the Korea Society of Computer and Information
• /
• v.16 no.3
• /
• pp.53-63
• /
• 2011

Many techniques have been proposed to store and query XML data efficiently. One way achieving this goal is using relational database by transforming XML data into relational format. It is important to transform schema to preserve the content, the structure and the constraints of the semantics information of the XML document. Especially, key constraints are an important part of database theory. Therefore, the proposal technique has considered the semantics of XML as expressed by primary keys and foreign keys. And, the proposal technique can preserve not only XML data constraints but also the content and the structure and the semantics of XML data thru transformation process. Transforming information is the content and the structure of the document(the parent-child relationship), the functional dependencies, semantics of the document as captured by XML key and keyref constraints. Because of XML schema transformation ensures that preserving semantic constraints, the advantages of these transformation techniques do not need to use the stored procedure or trigger which these data ensures data integrity in the relational database. In this paper, there is not chosen the ID/IDREF key which supported in DTD, the inheritance relationship, the implicit referential integrity.

• Proceedings of the Plant Resources Society of Korea Conference
• /
• 2021.04a
• /
• pp.33-33
• /
• 2021

자웅산(264.3m)은 DMZ 접경지역인 경기도 파주시 법원읍에 위치하며, 백두대간 줄기 중 한북정맥을 따라 동쪽으로는 노고산(401m), 서쪽으로는 명학산(220m) 사이에 위치하고 있다. 2020년 4월부터 10월까지 계절별로 1회씩 총 3회 식물상 조사를 진행하였고 화상자료와 증거표본을 확보하였다. 본 조사로부터 자웅산 일대에 자생하는 관속식물은 82과 208속 267종 9아종 22변종 4품종으로 총 303분류군이 확인되었다. 양치식물은 10과 18분류군, 나자식물은 2과 6분류군, 쌍자엽식물이 62과 226분류군, 단자엽식물이 8과 53분류군으로 확인되었다. 개나리(Forsythia koreana (Rehder) Nakai), 백운산원추리(Hemerocallis hakuunensis Nakai), 키버들(Salix koriyanagi Kimura ex Goerz) 등 3과 3분류군의 특산식물이 확인되었다. 침입외래식물로는 가시도꼬마리(Xanthium italicum Moretti), 단풍잎돼지풀(Ambrosia trifida L.), 미국개기장(Panicum dichotomiflorum Michx.), 서양민들레(Taraxacum officinale F.H.Wigg.), 애기망초(Conyza parva Cronquist) 등 7과 23분류군으로 조사되어 조사식물 303분류군의 7.6%를 차지하였다. 환경부 지정 식물구계학적 특정종은 V등급이 미나리냉이(Cardamine leucantha (Tausch) O.E.Schulz), IV등급이 당단풍나무(Acer pseudosieboldianum (Pax) Kom.), 산복사나무(Prunus davidiana (Carrière) Franch.) 등 2분류군, III등급이 금낭화(Dicentra spectabilis (L.) Lem.), 꽃쥐손이(Geranium platyanthum Duthie), 분비나무(Abies nephrolepis (Trautv. ex Maxim.) Maxim.) 등 7분류군이 확인되어 III등급 이상의 특정종은 10분류군으로 파악된다.

• Proceedings of the Plant Resources Society of Korea Conference
• /
• 2019.04a
• /
• pp.31-31
• /
• 2019

서부 민통지역은 육군 제 1사단, 육군 제 25사단, 육군 제 28사단 관할지역에 걸쳐있다. 경기도 파주시 민통지역은 육군 제1사단 관할지역으로 장단면, 군내면, 진동면을 포함한다. 연천군 반정리는 육군 제 25사단 관할 지역 내에 있다. 본 조사에서는 장단면 일대와 군내면 정자리 덕진산성, 진동면 동파리 일월봉, 임진강변, 수내천, 세월천을 중심으로 세 개 면과 연천군 장남면 반정리의 식물상을 조사하여, 서부 민통지역의 주요 식물들의 분포를 자세히 파악하고자 하였다. 2012년 4월부터 2018년 10월까지 조사를 통해 463점의 표본을 확보하였고, 총 96과 307속 415종, 3아종, 45변종 6품종의 469분류군이 확인되었다. 조사 시기 중 멸종위기종은 발견되지 않았으며, 우리나라 특산식물로는 고려엉겅퀴, 벌개미취, 키버들 등 7분류군이 확인 되었다. 식물구계학적 특정종으로는 Ⅴ등급 통발을 비롯, IV등급 8종, III등급 11종, II등급 11종, I등급 16종이 발견되었다. 서부 민통지역에서 확인된 외래 및 귀화식물은 단풍잎돼지풀을 포함한 35분류군으로 전체 식물의 7.5%에 해당한다. 최근 무분별한 개발로 인한 민통지역 자연자원의 보전대책 수립도 요구된다.

• Clinical and Experimental Pediatrics
• /
• v.49 no.5
• /
• pp.552-557
• /
• 2006

Purpose : The recent results observed in precocious puberty and the hope that interrupting puberty might increase adult height have led to an attempt to use GnRH agonist(GnRHa) in children with premature puberty and a poor growth prognosis. We aimed to analyze the growth promoting effect of GnRHa in girls with early puberty and low predicted adult height(PAH). Methods : Thirty six girls were recruited. They were grouped according to the GnRHa treatment period(group 1>6 mo, n=18; group 2<6 mo, n=18). The following variables were analyzed before and after GnRHa treatment : chronological age(CA), bone age(BA), ${\Delta}age$(CA-BA), height, target height (TH), PAH, serum IGF-1, IGFBP-3. Results : Duration of the GnRHa treatment was $0.89{\pm}0.81yr$($1.37{\pm}0.92yr$ in group 1, and $0.41{\pm}0.08yr$ in group 2). Before treatment, none of the variables were different between the two groups. There were no differences in the following variables the between two groups at the end of treatment : CA, BA, ${\Delta}age$, PAH, serum IGF-1, IGFBP-3. But, growth velocity(GV) and PAH increment during treatment were significantly reduced in group 1. Compared with initial PAH, PAH at the end of treatment was significantly increased($3.7{\pm}3.2cm$). The last serum levels of IGF-1 and IGFBP-3 were lower than those before treatment. Conclusion : Even though last PAH didn't approach TH, short term GnRHa administration in early puberty with low predicted PAH was somewhat effective. But, GnRHa administration suppressed the growth hormone-IGF-1 axis. Therefore, it is recommended that growth hormone(GH) should be used in combination with GnRHa.

• Proceedings of the Plant Resources Society of Korea Conference
• /
• 2018.10a
• /
• pp.45-45
• /
• 2018

경상북도 봉화군에 위치한 갈방산(712m)은 백두대간 옥석산(1,244m)에서 분기한 문수지맥의 산지 가운데 하나다. 본 연구는 갈방산 일대 관속식물의 분포상을 파악하고자 2017년 5월부터 2018년 9월까지 진행되었다. 연구 결과 92과 265속 373종 4아종 44변종 5품종으로 총 426분류군의 관속식물이 조사지에서 확인되었다. 이는 경상북도 관속식물 1,684분류군(Korea National Arboretum, 2016)의 25.3%, 한반도 관속식물 4,499분류군(Korea National Arboretum, 2018; Http://www.nature.go.kr/kpni/)의 9.5%에 해당되는 것으로 분석되었다. 갈방산 일대의 주요 식물 가운데 한국특산식물은 11분류군(키버들, 병꽃나무, 처녀치마 등)이 확인되었고, 산림청 지정 희귀식물은 VU등급(세잎승마) 1분류군, LC등급(도깨비부채, 태백제비꽃) 2분류군으로 총 3분류군의 희귀식물이 분포하는 것으로 조사되었다. 또한, 식물구계학적 특정식물 V등급 1분류군, IV등급 2분류군, III등급 10분류군, II등급 16분류군, I 등급 23분류군이 확인되었고, 외래식물은 총 22분류군으로 도시화지수(%) 6.3%, 귀화율은 5.2%에 해당되는 것으로 분석되었다. 조사된 식물의 유용성 분석 결과, 식용식물 345분류군(81%), 섬유용식물 4분류군(0.9%), 약용식물 85분류군(20.0%), 관상용식물 18분류군(4.2%), 목초용식물 109분류군(25.6%) 목재용식물 15분류군(3.5%) 등으로 확인되었다. 요컨대 갈방산 일대의 식물 현황을 제시함으로써 본 연구 결과물이 갈방산 일대의 희귀특산식물과 유용식물의 보전 및 활용 방안을 마련하기 위한 기초자료로 활용 될 것이라 기대한다.

• Korean Journal of Environment and Ecology
• /
• v.36 no.1
• /
• pp.30-55
• /
• 2022

This study conducted a flora survey in the areas of Mt. Sambong (282m) and Mt. Jaung (263m), located in Paju-si, Gyeonggi-do. A total of 434 taxa, including 6 forms, 34 varieties, 11 subspecies, 383 species, 271 genera, and 94 families, were surveyed in the two mountain areas. The ferns were identified as 24 taxa from 10 families, the gymnosperms as 8 taxa from 2 families, the dicotyledonous plants as 322 taxa from 73 families, and the monocotyledonous plants as 80 taxa from 9 families. Five taxa, including Salix koriyanagi, Cimicifuga heracleifolia, Forsythia koreana, Paulownia coreana, and Hemerocallis hakuunensi, were identified as the Korean endemic plants. Eight taxa, including Cimicifuga heracleifolia, Tylophora floribunda, and Iris minutiaurea as Vulnerable species, andAristolochia contorta, Viola diamantiaca, Lithospermum erythrorhizon, Lilium distichum, andArisaema heterophyllumas Least Concern species, were designated as rare and endangered plants designated by the Korea Forest Service. The invasive alien plants were 40 taxa, including Rumex crispus, Phytolacca americana, Cerastium glomeratum, Silene armeria, Chenopodium album, Chenopodium ficifolium, Magnolia obovata, Potentilla supina, Amorpha fruticosa, Medicago sativa, Robinia pseudoacacia, Trifolium repens, Euphorbia supina, Hibiscus trionum, and Oenothera biennisaccounting for 9.2 percent of the 434 taxa of the surveyed plants. As this area is a mountainous area close to settlement facilities, it is believed that ecological preservation measures and measures of specialized plants should be implemented.

• Korean Journal of Plant Resources
• /
• v.36 no.1
• /
• pp.32-61
• /
• 2023

To investigate the distribution of vascular plants growing at Wetland in Daegu·Gyeongbook, we surveyed from June 2020 to October in 2021. The flora of wetland was classified as a total of 459 taxa comprising of 104 families, 286 genus, 406 species, 12 subspecies, 34 varieties, 6 forma, 1 hybrid. Among them, the rare plants species 5 taxa, endemic plants 11 taxa, floristic regional indicator plants 57 taxa, naturalized plants 27 taxa and wetland plants 74 taxa were recorded. The percentage of urbanization index was 8.44%, the naturalized ratio was 5.88%, respectively.