• Title/Summary/Keyword: relation table

Search Result 228, Processing Time 0.028 seconds

Mapping Design between XML and Table in Relation Database (XML과 관계 데이터베이스 자료 간의 매핑 설계)

  • Kim Gil-Choon
    • Journal of Digital Contents Society
    • /
    • v.5 no.3
    • /
    • pp.180-186
    • /
    • 2004
  • XML has an essential funtion of dealing with standardized document to be used in all academic areas and industrial areas as well as e-commerce. The transformation of XML data into Relation Database table is also necessary for data search using SQL language. Mapping relation between XMLand Table in Relation Database is required for transformation of XML. This arti치e studies the mapping relation between XML and Relation Database using DTD which enables to check the unity automatically whenever document is read so that it studied mapping design for the transformation of XML data info Relation Database table.

  • PDF

The XP-table: Runtime-efficient Region-based Structure for Collective Evaluation of Multiple Continuous XPath Queries (The XP-table: 다중 연속 XPath 질의의 집단 처리를 위한 실행시간 효율적인 영역 기반 구조체)

  • Lee, Hyun-Ho;Lee, Won-Suk
    • Journal of KIISE:Databases
    • /
    • v.35 no.4
    • /
    • pp.307-318
    • /
    • 2008
  • One of the primary issues confronting XML message brokers is the difficulty associated with processing a large set of continuous XPath queries over incoming XML seams. This paper proposes a novel system designed to present an effective solution to this problem. The proposed system transforms multiple XPath queries before their run-time into a new region-based data structure, called an XP-table, by sharing their common constraints. An XP-table is matched with a stream relation (SR) transformed from a target XML stream by a SAX parser. This arrangement is intended to minimize the runtime workload of continuous query processing. Also, system performance is estimated and verified through a variety of experiments, including comparisons with previous approaches such as YFilter and LazyDFA. The proposed system is practically linear- scalable and stable for evaluating a set of XPath queries in a continuous and timely fashion.

Research of organized data extraction method for digital investigation in relational database system (데이터베이스 시스템에서 디지털 포렌식 조사를 위한 체계적인 데이터 추출 기법 연구)

  • Lee, Dong-Chan;Lee, Sang-Jin
    • Journal of the Korea Institute of Information Security & Cryptology
    • /
    • v.22 no.3
    • /
    • pp.565-573
    • /
    • 2012
  • To investigate the business corruption, the obtainments of the business data such as personnel, manufacture, accounting and distribution etc., is absolutely necessary. Futhermore, the investigator should have the systematic extraction solution from the business data of the enterprise database, because most company manage each business data through the distributed database system, In the general business environment, the database exists in the system with upper layer application and big size file server. Besides, original resource data which input by user are distributed and stored in one or more table following the normalized rule. The earlier researches of the database structure analysis mainly handled the table relation for database's optimization and visualization. But, in the point of the digital forensic, the data, itself analysis is more important than the table relation. This paper suggests the extraction technique from the table relation which already defined in the database. Moreover, by the systematic analysis process based on the domain knowledge, analyzes the original business data structure stored in the database and proposes the solution to extract table which is related incident.

Method for improving search efficiency using relation of anatomical structure from Donguibogam(東醫寶鑑) ("동의보감"에 기재된 인체 용어 관계를 이용한 검색효율성 향상 방법)

  • Song, In-Woo;Lee, Byung-Wook
    • Journal of Korean Medical classics
    • /
    • v.25 no.4
    • /
    • pp.105-113
    • /
    • 2012
  • Objectives : Acquiring information from symptoms is one of the important method to gain clinically available information in korean medicine. Therefore, up to now, study of symptom terms was frequently implemented in promotion of various information project. In data extraction methods using symptom information from DB, information search using synonym and method using ontology is studied and utilized. However, considering concept of symptom has essential information of appeared body area and phenomenon we think that extending synonym and ontology relationship in symptom terms can be useful for search and set to this study. Methods : We collect terms relevant to human body area and structure described in Donguibogam. Synonymous relationship between collected terms is organized. Relationship between collected terms is build to human-body-knowledge table which has form of Concept+Relation+Concept. Type of relationship is limited on a range of expressing content about parts of human body. Result & Conclusion : Search condition is generated automatically using relationship of the upper area in knowledge table contents. Information of next and previous acupuncture point, upper and lower acupuncture point, left and right acupuncture point can be searched using information of acupuncture point location, order, relative position in area, direction in knowledge table contents.

Implementation of permanent Magnetic Repulsion Type of Magnetic Levitation Table Using One Degree-of-freedom Active Control (1 자유도 능동제어에 의한 영구자석 반발형 자기부상 테이블의 구현)

  • Jo, Yeong-Geun;Choe, Gi-Bong;Tadahiko Shinshi;Akira Shimokohbe
    • Journal of the Korean Society for Precision Engineering
    • /
    • v.19 no.7
    • /
    • pp.125-132
    • /
    • 2002
  • This paper shows an experimental magnetic levitation table using one degree-of-freedom active control. The magnetic levitation table using repulsions of permanent magnets was theoretically presented already. Thus the objective of this paper is to prove stable levitation with only one degree-of-freedom active control experimentally. For the design of the system, at first, permanent magnets are selected. Secondly, the spring constants of the virtual spring are obtained by simulation. Thirdly, the moving magnets are arranged using a stable layout relation. Fourthly, a linear voice coil motor is designed. Finally, the magnetic levitation system is manufactured. The phenomenon of stable levitation in the manufactured table is proven by means of dynamic time and frequency responses. The differences between the theoretical natural frequencies and experimental ones are analyzed. Also, stable range in the control direction is shown experimentally.

A Study on the Labor Inducement Coefficient of Software Industry through Reclassification of the Inter-Industry Table (산업연관표의 재분류를 통한 소프트웨어산업의 노동유발계수 분석에 관한 연구)

  • Choi, Jinho;Ryu, Jae Hong;Lim, Gyoo Gun;Shin, Ik Ho
    • Journal of Information Technology Services
    • /
    • v.13 no.3
    • /
    • pp.165-181
    • /
    • 2014
  • This study proposes the accurate labor inducement coefficient (employment inducement coefficient/hiring inducement coefficient) of Korea software industry by analyzing the inter-industry relation using the modified inter-industry table. To rewrite the inter-industry table of Korea, some previous studies related to the inter-industry analysis were reviewed and the key problems were identified. First, in the current inter-industry table published by the Bank of Korea, the output of software industry includes not only the pure software related output but also the output of non-software section due to the misclassification of the industry. This causes the output to become bigger than the actual output of software industry. Therefore, if the inter-industry table is not modified, the labor inducement coefficient would be overestimated too much. Second, during rewriting the inter-industry table, the output is changing. The inter-industry table is the table in the form of rows and columns, which records the transactions of goods and services among industries which are required to continue the activities of each industry. Accordingly, if only an output of a specific industry is changed, the reliability of the table would be degraded because the table is prepared based on the relations with other industries. This possibly causes the labor inducement coefficient to be over or underestimated. This study tries to correct these problems to get the more accurate labor inducement coefficient of the software industry. First, to get the output of the pure software section only, the data from the Korea Electronics Association (KEA) was used in the inter-industry table. Second, to prevent the difference in the outputs during rewriting the inter-industry table, the difference between the output in the current inter-industry table and the output from KEA data was identified and then it was defined as the non-software section output for the analysis. The followings are the labor inducement coefficient obtained when the output is divided into the pure software section (package software, and IT service) and non-software section. As of 2011, the employment inducement coefficients of pure software section, package software section and IT service of Korea were 8.616, 13.998, and 7.773 respectively while the labor inducement coefficients of pure software section, package software section and IT service of Korea were 7.979, 13.332, and 7.083, respectively.

A Pantographic Study on the Mandibular Movements in Patients with Temporomandibular Joint Sounds (Pantograph를 이용한 악관절잡음자의 하악운동에 관한 연구)

  • Lee, Pung Ho;Han, Kyung Soo
    • Journal of Oral Medicine and Pain
    • /
    • v.12 no.1
    • /
    • pp.85-93
    • /
    • 1987
  • The author studied on the effect of TMJ sounds to the patterns and ranges of mandibular border movements in horizontal plane with Pantograph (Denar Corp.). For study, 19 patients with TMJ sounds only and 16 students with no TM disorder were selected and classified as experimental group and control group, respectively. The subject performed right lateral movement, left lateral movement, and forward movement. Each movement were performed 3 times and the movement trajectory obtained with mechanical pantograph were observed for accordance of centric relation position, reproducibility and/or restriction of lateral movement paths, deviation of protrusive path in anterior table, restriction of protrusive condylar movement path in posterior horizontal table, presence of Fisher angle in posterior vertical table. And pantographic reproducibility Index (PRI) were obtained with pantronic by the same movement method as in the mechanical pantograph record. The obtained results were as follows : 1. In experimental group, PRI scores in those who show accordance of centric relation position were 14.4, and were 26.53 in those who did not show accordance of centric relation position. However, the PRI scores of the two subgroups show no statistically significant difference in control group. Therefore, in experimental group, the capability of accordance of centric relation position affected largely the PRI scores than in control group. 2. Deviation of protrusive path was opposite to the affected side in experimental group, and was left side in control group. 3. Restriction side of condylar movement in protrusion was ipsilateral to the deviation side in experimental group, but in control group, restriction side was not related to the deviation side. 4. PRI scores in experimental group were 23.2 (moderate dysfunction category), and in control group, were 17.8 (slight dysfunction category). The PRI scores in control group, however, implies that the evaluation of temporomandibular disorders by the PRI scores only may be unreasonable.

  • PDF

A Study on Correlation between Power of Trunk Flexors, Extensors and Lumbar Lordotic Angle in Normal Adults (정상 성인에서 체간 굴근, 신근의 근력과 요추 전만각의 상관관계에 관한 연구)

  • Choi, Bo-Mi;Yi, Jeong-Min;Kim, Hyun-Soo
    • The Journal of Churna Manual Medicine for Spine and Nerves
    • /
    • v.7 no.2
    • /
    • pp.39-52
    • /
    • 2012
  • Objectives : The purpose of this study was to investigate the correlation between lumbar lordotic angle and the power of trunk flexors, extensors in normal adults Methods : 34 normal participants participated in this study. Their lumbar lordotic angle(L1-S1 Cobb's angle and L1-L5 cobb's angle) was measured by x-ray taken on lateral direction, erect cross-arm position. And muscle power of trunk flexors and extensors of each participant measured using Cybex HUMAC NORM. Results : 1. The average of L1-S1 Cobb's angle was $47.21{\pm}8.88^{\circ}$ and the average of L1-L5 Cobb's angle was $36.32{\pm}9.62^{\circ}$(Table IV). 2. The average ratio of trunk flexors/extensors was $6.44{\pm}19.31%$(Table V). The average power of the trunk flexors was $165.18{\pm}55.05$(Newton-Meter/kg), and the power of trunk extensors was $257.18{\pm}85.53$ (Newton-Meter/kg)(Table VI). 3. Lumbar lordotic angle has no relation to the ratio of trunk flexors/extensors(Table VII, Fig. 4). 4. Lumbar lordotic angle has no relation to both the power of the trunk flexors and extensors(Table VIII, Fig. 5, Fig. 6). Conclusions : These results suggest that the lumbar lordotic angle measured by radiograph could not evaluate the power and ratio of trunk flexors, extensors.

  • PDF

Uncertainty Measurement of Incomplete Information System based on Conditional Information Entropy (조건부 정보엔트로피에 의한 불완전 정보시스템의 불확실성 측정)

  • Park, Inkyoo
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.14 no.2
    • /
    • pp.107-113
    • /
    • 2014
  • The derivation of optimal information from decision table is based on the concept of indiscernibility relation and approximation space in rough set. Because decision table is more likely to be susceptible to the superposition or inconsistency in decision table, the reduction of attributes is a important concept in knowledge representation. While complete subsets of the attribute's domain is considered in algebraic definition, incomplete subsets of the attribute's domain is considered in information-theoretic definition. Therefore there is a marked difference between algebraic and information-theoretic definition. This paper proposes a conditional entropy using rough set as information theoretical measures in order to deduct the optimal information which may contain condition attributes and decision attribute of information system and shows its effectiveness.

A Study on Evaluation of Clinical Practice of Dept. of Dental Technology - Construction of items and grading of the evaluation table at clinical practice - (치기공과 임상실습평가에 관한 연구 - 임상실습평가표 항목구성내용과 배점을 중심으로 -)

  • Lee, Hwa-Sik;Bae, Bong-Jin;Chang, Ki-Whan
    • Journal of Technologic Dentistry
    • /
    • v.29 no.2
    • /
    • pp.65-77
    • /
    • 2007
  • This study is for the purpose of studying the validity of the construction of items and grading of the evaluation table at clinical practice used as the method of evaluation when clinical practice of Dept. of Dental Technology. 205 dental technicians in 4 cities were questioned to analyze the relation between items of the evaluation table at clinical practice and its grading. The collected materials were inspected by SAS V8 for Windows. The results are as follows: 1. Making up all the items and grading seem to be appropriate because they had the marks more than midium(more than 3.28). 2. Making up detailed items and grading seem to be trusted because they had the marks more than 3.30. 3.The significance level of the relation between items of the evaluation at clinical practice and its grading by t-inspection is p<0.0001 and so it appears to be meaningful. 4. It proved to be meaningful in result of regression analysis of the influence on the construction of the evaluation at clinical practice and its grading. With this result, further study is needed for the better methods of the evaluation in its adjustment and graduated grading among the items.

  • PDF