• Title/Summary/Keyword: Analysis of Query

Search Result 457, Processing Time 0.026 seconds

Information Technologies of Accounting and Analysis in Modern Companies

  • Yaremenko, Liudmyla;Hevchuk, Anna;Vuzh, Tetiana;Vashchilina, Elena;Yermolaieva, Maryna
    • International Journal of Computer Science & Network Security
    • /
    • v.21 no.5
    • /
    • pp.151-159
    • /
    • 2021
  • This article addresses the issue of finding optimal solutions using the information technologies of accounting and analysis in modern companies. The aim of the study is to reveal available information technologies for the needs of small, medium and large businesses operating in modern conditions. This goal is achieved by using systematization, comparison, and analysis of information, obtained under the survey and open management statistics. For the first time, the paper systematizes up-to-date information of 2021 about the most popular programs, online services, platforms and cloud services that are used to improve accounting and analytical processes in enterprises of various sizes. The main global trends in software development in terms of COVID-19 pandemic have been identified. In particular, the study defines the countries that occupy the leading positions in the informatization of business processes. An attempt was made to classify information technologies by their use by various volume of businesses. The analysis of research results of the Internet search query frequency regarding the use of information technologies enabled to determine the most popular software products worldwide. The peculiarities of information technologies, their advantages and disadvantages were examined and the common and distinctive features were compared. It was determined that for the new enterprises to implement information technologies, it is necessary to conduct a step-by-step study of all available software products. The software evaluation algorithm was described to help select the optimal software for the specific business processes. The paper also describes the way to solve the problem of using accounting and analysis software for the businesses of a specific kind of activity.

An Ontology-Based Hazard Analysis and Risk Assessment for automotive functional safety (자동차 기능안전성을 위한 온톨로지 기반의 위험원 분석 및 위험 평가)

  • Roh, Kyung-Hyun;Lee, Keum-Suk
    • Journal of the Korea Society of Computer and Information
    • /
    • v.20 no.3
    • /
    • pp.9-17
    • /
    • 2015
  • The ISO 26262 standard requires a preliminary hazard analysis and risk assesment early in the development for automotive system. This is a first step for the development of an automotive system to determine the necessary safety measures to be implemented for a certain function. In this paper, we propose an ontology-based hazard analysis and risk assessment method for automotive functional safety. We use ontology to model the hazard and SWRL(Semantic Web Language) to describe risk analysis. The applicability of the proposed method is evaluated by the case study of an ESCL(electronic steering column lock) system. The result show that ontology deduction is useful for improving consistency and accuracy of hazard analysis and risk assessment.

Designing a Repository Independent Model for Mining and Analyzing Heterogeneous Bug Tracking Systems (다형의 버그 추적 시스템 마이닝 및 분석을 위한 저장소 독립 모델 설계)

  • Lee, Jae-Kwon;Jung, Woo-Sung
    • Journal of the Korea Society of Computer and Information
    • /
    • v.19 no.9
    • /
    • pp.103-115
    • /
    • 2014
  • In this paper, we propose UniBAS(Unified Bug Analysis System) to provide a unified repository model by integrating the extracted data from the heterogeneous bug tracking systems. The UniBAS reduces the cost and complexity of the MSR(Mining Software Repositories) research process and enables the researchers to focus on their logics rather than the tedious and repeated works such as extracting repositories, processing data and building analysis models. Additionally, the system not only extracts the data but also automatically generates database tables, views and stored procedures which are required for the researchers to perform query-based analysis easily. It can also generate various types of exported files for utilizing external analysis tools or managing research data. A case study of detecting duplicate bug reports from the Firfox project of the Mozilla site has been performed based on the UniBAS in order to evaluate the usefulness of the system. The results of the experiments with various algorithms of natural language processing and flexible querying to the automatically extracted data also showed the effectiveness of the proposed system.

Morphological Analysis Study for the Development of DB on the Medicinal Herbs Manufacturing Process - with focus on the manufacturing method of Rehmanniae radix - (본초 제조 공정의 DB화를 위한 형태소 분석 연구 - 숙지황 제조 공정을 중심으로 -)

  • Kim, Thaeyul;Kim, Kiwook;Kim, Byungchul;Lee, Byungwook
    • Journal of Society of Preventive Korean Medicine
    • /
    • v.20 no.1
    • /
    • pp.111-124
    • /
    • 2016
  • Objectives : Treatment method using drugs has already been used in Korean medicine for a long time. Moreover, database has been developed and utilized for more efficient management of the treatments that use drugs. Most of such database related to knowledge on drugs is composed of origin, efficacy, temperament, ingredients and examples of application of the standardized drugs. Communication with knowledge information in other specialized areas is also accomplished by using the efficacies and ingredients with the drugs. In this study, we aimed to make data structure of the terminologies that represent the manufacturing process of herbs. However, in spite of the fact that the manufacturing process of the drugs imparts effect on their efficacies and ingredients, details of the manufacturing processes are quite limited to simple text sentences, thereby resulting in substantially lower level of utilization and difficulties in systematic researches on various factors included in the manufacturing processes in comparison to other knowledge on drugs. Methods : This Study extracted the factors necessary in the development of database by executing morphological analysis of the manufacturing process of herbs. Results : The factors are 'Order', 'Act', 'Raw material', 'Tools', 'Supporting materials', 'Intensity', 'Duration Time', 'Interval', 'Focus', 'Repetition Number', 'Untill'. We were able to tell the difference of the manufacturing process with a simple structured query language and the factors. Conclusions : Morphological analysis of medicinal herbs manufacturing Process contributes to standardization with information of the manufacturing process. And it helps to creates a quality management system through the Database.

A meta-analysis on advantages of peripheral nerve block post-total knee arthroplasty

  • You, Di;Qin, Lu;Li, Kai;Li, Di;Zhao, Guoqing;Li, Longyun
    • The Korean Journal of Pain
    • /
    • v.34 no.3
    • /
    • pp.271-287
    • /
    • 2021
  • Background: Postoperative pain management is crucial for patients undergoing total knee arthroplasty (TKA). There have been many recent clinical trials on post-TKA peripheral nerve block; however, they have reported inconsistent findings. In this meta-analysis, we aimed to comprehensively analyze studies on post-TKA analgesia to provide evidence-based clinical suggestions. Methods: We performed a computer-based query of PubMed, Embase, the Cochrane Library, and the Web of Science to retrieve related articles using neurothe following search terms: nerve block, nerve blockade, chemodenervation, chemical neurolysis, peridural block, epidural anesthesia, extradural anesthesia, total knee arthroplasty, total knee replacement, partial knee replacement, and others. After quality evaluation and data extraction, we analyzed the complications, visual analogue scale (VAS) score, patient satisfaction, perioperative opioid dosage, and rehabilitation indices. Evidence was rated using the Grading of Recommendations Assessment, Development, and Evaluation approach. Results: We included 16 randomized controlled trials involving 981 patients (511 receiving peripheral nerve block and 470 receiving epidural block) in the final analysis. Compared with an epidural block, a peripheral nerve block significantly reduced complications. There were no significant between-group differences in the postoperative VAS score, patient satisfaction, perioperative opioid dosage, and rehabilitation indices. Conclusions: Our findings demonstrate that the peripheral nerve block is superior to the epidural block in reducing complications without compromising the analgesic effect and patient satisfaction. Therefore, a peripheral nerve block is a safe and effective postoperative analgesic method with encouraging clinical prospects.

OLAP System and Performance Evaluation for Analyzing Web Log Data (웹 로그 분석을 위한 OLAP 시스템 및 성능 평가)

  • 김지현;용환승
    • Journal of Korea Multimedia Society
    • /
    • v.6 no.5
    • /
    • pp.909-920
    • /
    • 2003
  • Nowadays, IT for CRM has been growing and developed rapidly. Typical techniques are statistical analysis tools, on-line multidimensional analytical processing (OLAP) tools, and data mining algorithms (such neural networks, decision trees, and association rules). Among customer data, web log data is very important and to use these data efficiently, applying OLAP technology to analyze multi-dimensionally. To make OLAP cube, we have to precalculate multidimensional summary results in order to get fast response. But as the number of dimensions and sparse cells increases, data explosion occurs seriously and the performance of OLAP decreases. In this paper, we presented why the web log data sparsity occurs and then what kinds of sparsity patterns generate in the two and t.he three dimensions for OLAP. Based on this research, we set up the multidimensional data models and query models for benchmark with each sparsity patterns. Finally, we evaluated the performance of three OLAP systems (MS SQL 2000 Analysis Service, Oracle Express and C-MOLAP).

  • PDF

Question Analysis and Expansion based on Semantics (의미 기반의 질의 분석 및 확장)

  • Shin, Seung-Eun;Park, Hee-Guen;Seo, Young-Hoon
    • The Journal of the Korea Contents Association
    • /
    • v.7 no.7
    • /
    • pp.50-59
    • /
    • 2007
  • This paper describes a question analysis and expansion based on semantics for on efficient information retrieval. Results of all information retrieval systems include many non-relevant documents because the index cannot naturally reflect the contents of documents and because queries used in information retrieval systems cannot represent enough information in user's question. To solve this problem, we analyze user's question semantically, determine the answer type, and extract semantic features. And then we expand user's question using them and syntactic structures which are used to represent the answer. Our similarity is to rank documents which include expanded queries in high position. Especially, we found that an efficient document retrieval is possible by a question analysis and expansion based on semantics on natural language questions which are comparatively short but fully expressing the information demand of users.

Operational Experience in DB "TERMIN"

  • Shaburova, Natalya N.
    • Journal of Information Science Theory and Practice
    • /
    • v.7 no.3
    • /
    • pp.21-30
    • /
    • 2019
  • Information about the formation and filling (in 2014 to 2016) of a terminological dictionary on electronics and radioengineering and collective work (in 2017 to 2018) with a data bank "TERMIN" is presented in this article. In purpose of creating an instrument of navigating the modern scientific-technical space a net of terms with set semantic links is described. This set is based on the analysis of terms' definitions (each term is checked for inclusion in the definitions of all other terms; the definitions were borrowed from reputable reference editions: encyclopedias, dictionaries, reference books). The created model of a system that consists of different information sources, in which it (information) is indexed by the terminology of Russian State Rubricator of Scientific and Technical Information rubrics and/or keywords, is described. There is an access for the search in all these sources in the system. Searching inquiries are referred to in the language of these rubrics or formulated by arbitrary terms. The system is to refer to information sources and give out relevant information. In accordance with this model, semantic links of various types, which allow expanding a search at different modalities of query, should be set among data bank terms. Obtained links will have to increase semantic matching, i.e., they can provide actual understanding of the meaning of the information that is being sought.

Nursing Process of Abdominal Surgery Patients (복부수술환자의 간호과정)

  • Yoo, Hyung-Sook
    • Journal of Korean Academy of Nursing Administration
    • /
    • v.8 no.3
    • /
    • pp.411-430
    • /
    • 2002
  • Purpose : This study was to develop Nursing Process Model of abdominal surgery patient using nursing diagnoses of NANDA, Nursing Interventions Classification(NIC), and Nursing Outcomes Classification(NOC). Method : The data in database were collected from nursing records in sixty patients with abdominal surgery admitted in a university hospital and open questionnaires of thirteen nurses. Systematic nursing process resulting from each nursing diagnoses, most common, was developed by the statistical analysis through database query from clinical database of abdominal surgery patients. Result : 51 nursing diagnoses were identified in abdominal surgery patients. The most commonly occurred nursing diagnoses were Pain, Risk for Infection, Sleep Pattern Disturbance, Hyperthermia, Altered Nutrition: Less Than Body Requirements in order. The linkage lists of NANDA to NIC and NANDA to NOC, and the nursing activities according to nursing diagnoses of abdominal surgery patients were identified in unit. Conclusion : Nursing Process of abdominal surgery patients was comprised of core nursing diagnoses, core nursing interventions, core nursing outcomes which provides the most reliable data in unit and could make nurses facilitate nursing process easily without full consideration of knowledge about nursing language classification system. Therefore, it could support nurses' decision making and recording of nursing process especially in the computerized patient record system if unit nursing process model using standardized nursing language system which contains of their own core nursing process data was developed.

  • PDF

Analysis and Improvement of Ranking Algorithm for Web Mining System on the Hierarchical Web Environment

  • Heebyung Yoon;Lee, Kil-Seup;Kim, Hwa-Soo
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 2003.09a
    • /
    • pp.455-458
    • /
    • 2003
  • The variety of document ranking algorithms have developed to provide efficient mining results for user's query on the web environment. The typical ranking algorithms are the Vector-Space Model based on the text, PsgeRank and HITS algorithms based on the hyperlink structures and other several improvement algorithms. All these are for the user's convenience and preference. However, these algorithms are usually developed on then Horizontal and non-hierarchial web environments and are not suitable for the hierarchial web environments such as enterprise and defense networks. Thus, we must consider the special environment factors in order to improve the ranking algorithms. In this paper, we analyze the several typical algorithms used by hyperlink structures on the web environment. We, then suggest a configuration of the hierarchical web environment and also give the relations between agents of the web mining system. Next, we propose an improved ranking algorithm suitable to this kind of special environments. The proposed algorithm is considered both the hyperlink structures of the documents and the location of the user of the hierarchical web.

  • PDF