• Title/Summary/Keyword: Online Index Maintenance

Search Result 3, Processing Time 0.023 seconds

A Study on the DB-IR Integration: Per-Document Basis Online Index Maintenance

  • Jin, Du-Seok;Jung, Hoe-Kyung
    • Journal of information and communication convergence engineering
    • /
    • v.7 no.3
    • /
    • pp.275-280
    • /
    • 2009
  • While database(DB) and information retrieval(IR) have been developed independently, there have been emerging requirements that both data management and efficient text retrieval should be supported simultaneously in an information system such as health care, customer support, XML data management, and digital libraries. The great divide between DB and IR has caused different manners in index maintenance for newly arriving documents. While DB has extended its SQL layer to cope with text fields due to lack of intact mechanism to build IR-like index, IR usually treats a block of new documents as a logical unit of index maintenance since it has no concept of integrity constraint. However, In the DB-IR integrations, a transaction on adding or updating a document should include maintenance of the posting lists accompanied by the document. Although DB-IR integration has been budded in the research filed, the issue will remain difficult and rewarding areas for a while. One of the primary reasons is lack of efficient online transactional index maintenance. In this paper, performance of a few strategies for per-document basis transactional index maintenance - direct index update, pulsing auxiliary index and posting segmentation index - will be evaluated. The result shows that the pulsing auxiliary strategy and posting segmentation indexing scheme, can be a challenging candidates for text field indexing in DB-IR integration.

Efficient Dynamic Index Structure for SSD (SPM) (SSD에 적합한 동적 색인 저장 구조 : SPM)

  • Jin, Du-Seok;Kim, Jin-Suk;You, Beom-Jong;Jung, Hoe-Kyung
    • The Journal of the Korea Contents Association
    • /
    • v.10 no.2
    • /
    • pp.54-62
    • /
    • 2010
  • Inverted index structures have become the most efficient data structure for high performance indexing of large text collections, especially online index maintenance, In-Place and merge-based index structures are the two main competing strategies for index construction in dynamic search environments. In the above-mentioned two strategies, a contiguity of posting information is the mainstay of design for online index maintenance and query time. Whereas with the emergence of new storage device(SSD, SCRAM), those do not consider a contiguity of posting information in the design of index structures because of its superiority such as low access latency and I/O throughput speeds. However, SSD(Solid State Drive) is not well suited for traditional inverted structures due to the poor random write throughput in practical systems. In this paper, we propose the new efficient online index structure(SPM) for SSD that significantly reduces the query time and improves the index maintenance performance.

A Study on Effectiveness of Chronic Disease Online Program Due to COVID-19 (COVID-19로 인한 만성질환 관리 비대면 프로그램의 효과성 연구)

  • Kim, Yeunmi;Kim, Hyunjin
    • Journal of Digital Convergence
    • /
    • v.20 no.4
    • /
    • pp.759-768
    • /
    • 2022
  • The purpose of this study is to apply a chronic disease management non-face-to-face program for the prevention and management of chronic disease and to confirm the effect of a one-group pre-and post-design similar experimental study. The program consisted of nursing, nutrition, and exercise programs for 12 weeks. The subjects were 69 adult men and women using the chronic disease management center at public health centers, and the period was from May 3 to August 6, 2021. Systolic pressure, diastolic pressure, fasting blood sugar, BMI, depression, and quality of life were measured before and after the program. Data were analyzed with SPSS 20.0. As a result, systolic pressure, diastolic pressure, fasting blood glucose, and quality of life were found to be significant. Depression was not significant, but mild depression was reduced. Developing, applying, and managing various non-face-to-face programs for chronic disease management will contribute to the prevention of chronic diseases and the promotion of health maintenance.