• Title/Summary/Keyword: group-by query

Search Result 49, Processing Time 0.029 seconds

Mining of Subspace Contrasting Sample Groups in Microarray Data (마이크로어레이 데이터의 부공간 대조 샘플집단 마이닝)

  • Lee, Kyung-Mi;Lee, Keon-Myung
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.21 no.5
    • /
    • pp.569-574
    • /
    • 2011
  • In this paper, we introduce the subspace contrasting group identification problem and propose an algorithm to solve the problem. In order to identify contrasting groups, the algorithm first determines two groups of which attribute values are in one of the contrasting ranges specified by the analyst, and searches for the contrasting groups while increasing the dimension of subspaces with an association rule mining strategy. Because the dimension of microarray data is likely to be tens of thousands, it is burdensome to find all contrasting groups over all possible subspaces by query generation. It is very useful in the sense that the proposed method allows to find those contrasting groups without analyst's involvement.

Design and Implementation of Active Database Based Query Processing System for Educational Information (능동 데이터베이스 기반 교육 정보 질의 처리 시스템의 설계 및 구현)

  • Lee, Tae-Jung;Lee, Soo-Jung;Lee, Jae-Ho
    • Journal of The Korean Association of Information Education
    • /
    • v.4 no.1
    • /
    • pp.109-119
    • /
    • 2000
  • In this paper, we design and implement educational system by using active database technique in www environments. The developed system consists of three modules such as user group interface, active-based monitor, and expert group interface. The roles of each module are summarized as follows. The user group interface provides with system accessibility the users who registered in the developed system. The active-based monitor, triggering modules, consists of three sub-modules such as keyword parser, exception handler, and DB access module. Also it manages five items such as keyword index, Q&A DB, user group mailing list, and expert group mailing list. The expect group interface provides answer filling form for the expert who registered in the developed system.

  • PDF

Algorithm of certificate security based-on using query language (사용자 질의어를 이용한 개인 인증 보안 알고리즘)

  • Lee, Chang-Jo
    • Convergence Security Journal
    • /
    • v.11 no.6
    • /
    • pp.45-51
    • /
    • 2011
  • Certificate security oriented cyber certificate is important tool for the purpose of offering user-authentication service based on on-line system. In the paper, we analyzed management implement which could make the efficient use of certificate security oriented cyber terror response. This algorithm called SOL(Security Oriented Language) will make efficient use of the service about authentication consisting of the basis in the age of information through efficient management and partial use of each certificates. Especially, SOL could be used efficiently by grafting a small group of on-line system which is operated with particular purposes.

Cluster-based Image Retrieval Method Using RAGMD (RAGMD를 이용한 클러스터 기반의 영상 검색 기법)

  • Jung, Sung-Hwan;Lee, Woo-Sun
    • The KIPS Transactions:PartB
    • /
    • v.9B no.1
    • /
    • pp.113-118
    • /
    • 2002
  • This paper presents a cluster-based image retrieval method. It retrieves images from a related cluster after classifying images into clusters using RAGMD, a clustering technique. When images are retrieved, first they are retrieved not from the whole image database one by one but from the similar cluster, a similar small image group with a query image. So it gives us retrieval-time reduction, keeping almost the same precision with the exhaustive retrieval. In the experiment using an image database consisting of about 2,400 real images, it shows that the proposed method is about 18 times faster than 7he exhaustive method with almost same precision and it can retrieve more similar images which belong to the same class with a query image.

A Lifelog Management System Based on the Relational Data Model and its Applications (관계 데이터 모델 기반 라이프로그 관리 시스템과 그 응용)

  • Song, In-Chul;Lee, Yu-Won;Kim, Hyeon-Gyu;Kim, Hang-Kyu;Haam, Deok-Min;Kim, Myoung-Ho
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.15 no.9
    • /
    • pp.637-648
    • /
    • 2009
  • As the cost of disks decreases, PCs are soon expected to be equipped with a disk of 1TB or more. Assuming that a single person generates 1GB of data per month, 1TB is enough to store data for the entire lifetime of a person. This has lead to the growth of researches on lifelog management, which manages what people see and listen to in everyday life. Although many different lifelog management systems have been proposed, including those based on the relational data model, based on ontology, and based on file systems, they have all advantages and disadvantages: Those based on the relational data model provide good query processing performance but they do not support complex queries properly; Those based on ontology handle more complex queries but their performances are not satisfactory: Those based on file systems support only keyword queries. Moreover, these systems are lack of support for lifelog group management and do not provide a convenient user interface for modifying and adding tags (metadata) to lifelogs for effective lifelog search. To address these problems, we propose a lifelog management system based on the relational data model. The proposed system models lifelogs by using the relational data model and transforms queries on lifelogs into SQL statements, which results in good query processing performance. It also supports a simplified relationship query that finds a lifelog based on other lifelogs directly related to it, to overcome the disadvantage of not supporting complex queries properly. In addition, the proposed system supports for the management of lifelog groups by providing ways to create, edit, search, play, and share them. Finally, it is equipped with a tagging tool that helps the user to modify and add tags conveniently through the ion of various tags. This paper describes the design and implementation of the proposed system and its various applications.

Face Recognition based on Hybrid Classifiers with Virtual Samples (가상 데이터와 융합 분류기에 기반한 얼굴인식)

  • 류연식;오세영
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.40 no.1
    • /
    • pp.19-29
    • /
    • 2003
  • This paper presents a novel hybrid classifier for face recognition with artificially generated virtual training samples. We utilize both the nearest neighbor approach in feature angle space and a connectionist model to obtain a synergy effect by combining the results of two heterogeneous classifiers. First, a classifier called the nearest feature angle (NFA), based on angular information, finds the most similar feature to the query from a given training set. Second, a classifier has been developed based on the recall of stored frontal projection of the query feature. It uses a frontal recall network (FRN) that finds the most similar frontal one among the stored frontal feature set. For FRN, we used an ensemble neural network consisting of multiple multiplayer perceptrons (MLPs), each of which is trained independently to enhance generalization capability. Further, both classifiers used the virtual training set generated adaptively, according to the spatial distribution of each person's training samples. Finally, the results of the two classifiers are combined to comprise the best matching class, and a corresponding similarit measure is used to make the final decision. The proposed classifier achieved an average classification rate of 96.33% against a large group of different test sets of images, and its average error rate is 61.5% that of the nearest feature line (NFL) method, and achieves a more robust classification performance.

Strategies to Improve Nutrition for the Elderly in Suwon : Analysis of Dietary Behavior and Food Preferences (수원지역 노인 영양개선 전략 연구 : 식습관 및 식품기호도 분석)

  • 임경숙;민영희;이태영;김영주
    • Korean Journal of Community Nutrition
    • /
    • v.3 no.3
    • /
    • pp.410-422
    • /
    • 1998
  • To promote health status, strategies and interventions to improve nutrition should be based on the proper diagnosis of the subject's eating patterns. The elderly usually have traditional food habits and preferences, and it is very difficult to change them. This study was designed to identify dietary behavior and food preference of the elderly, in order to provide baseline data for the Elderly Nutrition Intervention Program for the Public Health Center. A survey questionnaire was made for use by trained interviewers to query 151elderly people from 5 community elderly centers located in Suwon, Korea. The majority of them ate regularly and partook of all available side dishes. Their major dietary problems were frequent consumptions of salty foods, and eating too quickly. They consumed grains and vegetables regularly, but seldomly ate dairy products, fruits, meat and food prepared with oil. They also tended to eschew ready made processed food, high cholesterol food, and fast food. Also they did not dine out as much as younger people. Desirable eating habit score were not significantly influenced by socioeconomic variables and nutrition-related characteristics. These included nutrition knowledge, Nutritional Risk Index(NRI) and a score of health concerns. However, meal balance scores were significantly higher in the younger group(p<.05), the higher household income group(p<.05). According to stepwise multiple regression analysis, NRI was the most important determinant of a desirable eating habit score for the male elderly, whereas the score of health concerns was mo9st important for female elderly subjects. The greatest predictor of the meal f balance score was nutrition knowledge. The elderly liked sweet tasting food, grains, rice, stews and Korean style soups. They disliked sour food, dairy products, processed food, and bread. The results indicate that the Elderly Nutrition Education Program should focus on increasing consumption of dairy products, fruits and food with oil, prepared by traditional Korean cooking methods. It also suggests that the program planning should consider the socioeconomic status of the elderly, such as income and education level, as well as concern for health.

  • PDF

Exploring Secondary Students' Dialogic Argumentation Regarding Excretion via Collaborative Modeling (배설에 대한 협력적 모델링 과정에서 나타난 중학교 학생들의 대화적 논변활동 탐색)

  • Lee, Shinyoung;Kim, Hui-Baik
    • Journal of The Korean Association For Science Education
    • /
    • v.37 no.6
    • /
    • pp.1037-1049
    • /
    • 2017
  • The purpose of this study is to explore how the flow of discourse move and their reasoning process in dialogic argumentation during group modeling on excretion. Five groups of three to four students in the second grade of a middle school participated in the modeling practice of a Gifted Center. Analysis was conducted on argumentation during the modeling activity in which students should explain how the waste product (ammonia) leaves the body. It was found that there was a sequential argumentative process-tentative consensus, solving the uncertainty, and consensus. There were several discourse moves - 'claim' and 'counterclaim' in the stage of tentative consensus, 'query' and 'clarification of meaning' in the stage of solving the uncertainty, and 'change of claim' in the stage of consensus. Students participated in the dialogic argumentation by constructing argument collaboratively for reaching a consensus. Critical questioning in the stage of solving the uncertainty and reasoning in the stage of consensus were the impact factors of dialogic argumentation. By answering the critical questions, students changed their claims or suggested new claims by defending or rebutting previous claims. Students justified group claims with diverse argumentation scheme and scientific reasoning to reach a group consensus. These findings have implication for science educators who want to adopt dialogic argumentation in science classes.

An Analysis of Key Words Related to Traditional Korean Medicine Using Big Data of Two Search Engines (2대 포털사이트 빅데이터를 이용한 한방관련 키워드 분석)

  • Ahn, Jung-Yun;Keum, Ga-Jeong;Jang, Ah-Ryeong;Song, Ji-Chung
    • The Journal of Korean Medical History
    • /
    • v.30 no.2
    • /
    • pp.45-61
    • /
    • 2017
  • Objectives : This research aims to investigate the consumer's interest in the Korean Medicine (KM) industry by using Google-trends and Naver-Data lab. A quick and uncomplicated way for those who are already involved with KM industry but do not have expertise in utilizing Big-data searches, is introduced. Methods : 'Direct keyword' was set by FGI (Focus Group Interview) and 'Detailed keyword' was set by using relevant word search and autocomplete search functions in the search engine. By inquiring Naver-Data lab, keyword search volumes are compared by age and sex, date range, and originating region of the researcher. It is possible to determine whether the data is reliable or authentic through examining the associated query. Selected direct keywords used through FGI (Focus Group Interview) were 'Acupuncture', 'Herbal Medicine', 'Cupping', 'Musculoskeletal Disease', 'Diet', and 'Stemina'. Based on these keywords, the following results were derived from the keyword analysis. Results : From August 2016, there was a noticeable surge of interest in men's 'Cupping'. The search for 'Diet' increased in the second quarter of 2016 from all ages. The search volume of 'Stemna' for individuals in their 20s is higher than that of those in their 30s or 40s'. Researchers from the region of Chungcheongbuk-do had a higher level of interest in analgesics and less interest in Korean Medicine. There is a greater interest in the KM market from European countries and America, than from Korea, China, and other Asian countries. Discussion : Despite the limitations of the research, it is meaningful to introduce a quick and easy data search method to compare information by age, sex, and region. Conclusion : The future of research into Korea Medicine and this market is confirmed by our data results which indicate interest from Europe, the United States, and other western countries, but less interest from Korea, China and other Asian countries.

Electromyographic Activity of the Biceps Brachii Muscle in Shoulders With Anterior Instability (전방 불안정성 견관절에서 이두박근의 근전도 활동성)

  • Kim Seung-Ho;Ha Kwon-Ick;Kim Hyeon-Sook;Kim Seon-Woo;Park Jong Hyuk;Kim Young-Min
    • Clinics in Shoulder and Elbow
    • /
    • v.3 no.2
    • /
    • pp.87-94
    • /
    • 2000
  • Purpose : The purpose of this study was to evaluate the activity of the biceps brachii muscle in the vulnerable abduction and external rotation position of the shoulder in patients with anterior instability. Materials and Methods: This experimental study include a prospective analysis of the electromyographic(EMG) data on a group of patients with traumatic unilateral anterior instability of the shoulder. The EMG data of unstable shoulders was compared with those of opposite shoulders as control. The optimal sample size for the case-control study was calculated using an nQuery Advisor program(nQuery Adviser 3.0, Statisticl solutions Ltd., Ireland). The EMG analyses were conducted in 76 shoulders in 38 patients who had a traumatic anterior instability in one shoulder. The EMG records were obtained at different position of shoulder, which included 0° , 45° , 90° and 120° of shoulder abduction. In each angle of shoulder abduction, the arms were placed in an external rotation as tolerated by the anterior apprehension. The paired-sample T test was used to compare the difference of the root mean square(RMS) voltages between the stable and unstable shoulders in each degree of arm position. Results : The RMS voltage of the biceps muscle was significantly greater in the unstable shoulder than opposite stable shoulder in all position of the arm(p<0.001). The RMS voltage of the biceps was maximal at 90° and 120° of external rotation in the unstable shoulder(p<0.05). The RMS voltage of the supraspinatus muscle revealed no differences in any of the test conditions(p=0.904, 0.506, 0.119 and 0.781 in 0° , 45° , 90° and 120° , respectively) Conclusion: In the vulnerable abduction and external rotation position, the biceps muscle plays an active compensatory role in the unstable shoulder while not in the stable shoulder.

  • PDF