• Title/Summary/Keyword: Database Sharing

Search Result 335, Processing Time 0.025 seconds

A Version Management for Fast Recovery in a Database Sharing System (데이타베이스 공유 환경에서 빠른 회복을 위한 버전 관리)

  • 정용석;조행래
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2002.10c
    • /
    • pp.256-258
    • /
    • 2002
  • 데이타베이스 공유 시스템(Database Sharing System : DSS)은 고성능 트랜잭션 처리를 위해 다수 개의 노드들을 연동하며, 각 노드는 디스크 계층에서 데이타베이스를 공유한다. DSS를 구성하는 노드들이 고장날 경우, 데이타베이스를 정확한 상태로 복구하기 위한 회복 기법이 필요하다. DSS에서의 데이터베이스 회복 과정은 여러 노드에 분산된 로그 레코드의 병합 작업을 포함하며, 병합된 로그 레코드를 이용한 REDO 작업을 수행하여야 하므로 일반적인 단일 데이타베이스 시스템에 비해 많은 시간이 소요된다. 본 논문에서는 Oracle 9i에서 개발된 캐쉬 연합(cache fusion) 기법을 개선한 버전 관리 기법을 제안한다. 제안한 기법은 DSS를 구성하는 단일 노드의 고장 시 로그 병합 과정이 필요 없으므로 빠른 회복을 지원할 수 있으며, Oracle 9i에서 발생하는 빈번한 디스크 저장 오버헤드를 줄일 수 있다는 장점을 갖는다.

  • PDF

Constructing Japanese MeSH term dictionaries related to the COVID-19 literature

  • Yamaguchi, Atsuko;Takatsuki, Terue;Tateisi, Yuka;Soares, Felipe
    • Genomics & Informatics
    • /
    • v.19 no.3
    • /
    • pp.25.1-25.5
    • /
    • 2021
  • The coronavirus disease 2019 (COVID-19) pandemic has led to a flood of research papers and the information has been updated with considerable frequency. For society to derive benefits from this research, it is necessary to promote sharing up-to-date knowledge from these papers. However, because most research papers are written in English, it is difficult for people who are not familiar with English medical terms to obtain knowledge from them. To facilitate sharing knowledge from COVID-19 papers written in English for Japanese speakers, we tried to construct a dictionary with an open license by assigning Japanese terms to MeSH unique identifiers (UIDs) annotated to words in the texts of COVID-19 papers. Using this dictionary, 98.99% of all occurrences of MeSH terms in COVID-19 papers were covered. We also created a curated version of the dictionary and uploaded it to Pub-Dictionary for wider use in the PubAnnotation system.

Buffer Invalidation Schemes for High Performance Transaction Processing in Shared Database Environment (공유 데이터베이스 환경에서 고성능 트랜잭션 처리를 위한 버퍼 무효화 기법)

  • 김신희;배정미;강병욱
    • The Journal of Information Systems
    • /
    • v.6 no.1
    • /
    • pp.159-180
    • /
    • 1997
  • Database sharing system(DBSS) refers to a system for high performance transaction processing. In DBSS, the processing nodes are locally coupled via a high speed network and share a common database at the disk level. Each node has a local memory, a separate copy of operating system, and a DBMS. To reduce the number of disk accesses, the node caches database pages in its local memory buffer. However, since multiple nodes may be simultaneously cached a page, cache consistency must be ensured so that every node can always access the latest version of pages. In this paper, we propose efficient buffer invalidation schemes in DBSS, where the database is logically partitioned using primary copy authority to reduce locking overhead. The proposed schemes can improve performance by reducing the disk access overhead and the message overhead due to maintaining cache consistency. Furthermore, they can show good performance when database workloads are varied dynamically.

  • PDF

Performance Improvement of Ensemble Speciated Neural Networks using Kullback-Leibler Entropy (Kullback-Leibler 엔트로피를 이용한 종분화 신경망 결합의 성능향상)

  • Kim, Kyung-Joong;Cho, Sung-Bae
    • The Transactions of the Korean Institute of Electrical Engineers D
    • /
    • v.51 no.4
    • /
    • pp.152-159
    • /
    • 2002
  • Fitness sharing that shares fitness if calculated distance between individuals is smaller than sharing radius is one of the representative speciation methods and can complement evolutionary algorithm which converges one solution. Recently, there are many researches on designing neural network architecture using evolutionary algorithm but most of them use only the fittest solution in the last generation. In this paper, we elaborate generating diverse neural networks using fitness sharing and combing them to compute outputs then, propose calculating distance between individuals using modified Kullback-Leibler entropy for improvement of fitness sharing performance. In the experiment of Australian credit card assessment, breast cancer, and diabetes in UCI database, proposed method performs better than not only simple average output or Pearson Correlation but also previous published methods.

Study about the Influencing Factor of Knowledge Sharing to Improve a Knowledge Activity Performance (Focused On Related Factors) (지식활동성과 향상을 위한 지식공유의 영향요인에 대한 연구 (관계적 요인을 중심으로))

  • Cho, In-Su;Park, Hee-Jun
    • Proceedings of the Korea Database Society Conference
    • /
    • 2008.05a
    • /
    • pp.307-320
    • /
    • 2008
  • This study finds out the influence factor of knowledge sharing based on the viewpoint of the relationship central knowledge and inquires out the relationship between knowledge sharing and a knowledge activity performance. The related factor is set trust, openness communication and cooperation as independent variables. And the knowledge activity performance is set knowledge quality and user knowledge satisfaction as dependent variables which are influenced by knowledge sharing. This study proposes that to improve the organizational performance needs to manage not only knowledge, but also the users and surroundings.

  • PDF

공급사슬내 협업환경과 기업의 직.간접 성과

  • O, Se-Gu
    • Proceedings of the Korea Database Society Conference
    • /
    • 2010.06a
    • /
    • pp.235-247
    • /
    • 2010
  • Introduction of ICE(Integrated Collaboration Environment) has a great effect on corporate performance. In particular, it is expected that information sharing and collaboration among transaction partners will be an important factor which mediates ICE and its performance. Under such a background, this research intends to identify the influence of ICE by manufacturing industry on corporate performance through role of the parameter of information sharing and collaboration. The result of this research may be summed up as follows: ICE promotes information sharing and collaboration among enterprises, it accelerates integration of supply chain network among enterprises and cooperation. In particular, ICE has a great effect on information sharing. And information sharing has a direct effect on collaboration and performance. However, when we classify corporate performance into the "performance due to introduction", which is direct performance, and the "overall performance", which is indirect performance, the result of this research is as follows: information sharing has a great effect on the performance due to introduction, but does not have a meaningful effect on indirect performance. On the other hand, collaboration does not have any effect on the performance due to introduction, but has a meaningful effect on the overall performance, which is indirect performance. It is necessary to study and analyze additional this result in future.

  • PDF

Knowledge sharing in the evolution of Internet portals (인터넷 포털 진화에서의 지식공유)

  • Park, Seung-Bong;Kim, Jae-Young;Han, Jae-Min;Seo, Min-Kyo
    • Proceedings of the Korea Database Society Conference
    • /
    • 2008.05a
    • /
    • pp.13-30
    • /
    • 2008
  • The objective of this study is to explore a knowledge sharing typology for Internet portals based on knowledge-based view of firm. Furthermore, we provide insights into how the evolution of Internet portals takes place by describing user behavior of knowledge sharing. For doing this, we first present a typology of knowledge sharing based on the two dimensions such as knowledge donation and knowledge collection. Then we conduct case study of the Korean major portals to demonstrate a proposed typology. The main finding of the analysis is that three distinctive types of knowledge sharing patterns within portals are distinguished: collaboration, accumulation, and publishing. We conclude that user behavior of knowledge sharing is characterized as guiding factors in evolution process.

  • PDF

A Study on the Application of Web Database for Healthy City Wonju (건강도시 웹데이터베이스 활용방안 연구: 원주시 사례)

  • Nam, Eun-Woo;Park, Jae-Sung;Choe, Eun-Hee;Kim, Gyeong-Na
    • The Korean Journal of Health Service Management
    • /
    • v.6 no.1
    • /
    • pp.219-229
    • /
    • 2012
  • The purpose of this study is to introduce the web database for healthy city Wonju that contains healthy city indicators and materials. It has provided diverse information to public officers who are working on healthy city projects and citizens for monitoring and evaluating the projects, effectively. The web database was made on 2006 and was updated on 2009. The new Web database system was designed for supporting that the staffs of healthy city can manage all data update by themselves. The new Web database encompasses more recent information about health city projects. After identifying users' needs and reasons for modifying the fields of data, we added new indicators to the Web database. Some redundant indicators were deleted based on users' requests. The Web database quality evaluations were performed by using 13 quality evaluations constructs. Through all 13 constructs, less than 20% of study subjects felt that it did not satisfy their needs or expectations. Well developed and verified contents of the Web database for healthy city are very essential and important. The database makes healthy city projects alive by managing and sharing healthy city related data and indicators effectively.

A Dynamic Transaction Routing Algorithm with Primary Copy Authority (주사본 권한을 이용한 동적 트랜잭션 분배 알고리즘)

  • Kim, Ki-Hyung;Cho, Hang-Rae;Nam, Young-Hwan
    • The KIPS Transactions:PartD
    • /
    • v.10D no.7
    • /
    • pp.1067-1076
    • /
    • 2003
  • Database sharing system (DSS) refers to a system for high performance transaction processing. In DSS, the processing nodes are locally coupled via a high speed network and share a common database at the disk level. Each node has a local memory and a separate copy of operating system. To reduce the number of disk accesses, the node caches database pages in its local memory buffer. In this paper, we propose a dynamic transaction routing algorithm to balance the load of each node in the DSS. The proposed algorithm is novel in the sense that it can support node-specific locality of reference by utilizing the primary copy authority assigned to each node; hence, it can achieve better cache hit ratios and thus fewer disk I/Os. Furthermore, the proposed algorithm avoids a specific node being overloaded by considering the current workload of each node. To evaluate the performance of the proposed algorithm, we develop a simulation model of the DSS, and then analyze the simulation results. The results show that the proposed algorithm outperforms the existing algorithms in the transaction processing rate. Especially the proposed algorithm shows better performance when the number of concurrently executed transactions is high and the data page access patterns of the transactions are not equally distributed.

Development of an Object-Relational IFC Server

  • Hoon-sig Kang;Ghang Lee
    • International conference on construction engineering and project management
    • /
    • 2009.05a
    • /
    • pp.1346-1351
    • /
    • 2009
  • In this paper we propose a framework for an Object Relational IFC Server (OR-IFC Server). Enormous amounts of information are generated in each project. Today, many BIM systems are developed by various CAD software vendors. Industry Foundation Classes (IFC) developed by International Alliance for Interoperability (IAI) is an open standard data model for exchanging data between the various BIM tools. The IFC provides a foundation for exchanging and sharing of information directly between software applications and define a shared building project model. The IFC model server is a database management system that can keep track of transactions, modifications, and deletions. It plays a role as an information hub for storing and sharing information between various parties involved in construction projects. Users can communicate with each other via the internet and utilize functions implemented in the model server such as partial data import/export, file merge, version control, etc. IFC model servers using relational database systems have been developed. However, they suffered from slow performance and long transaction time due to a complex mapping process between the IFC structure and a relational-database structure because the IFC model schema is defined in the EXPRESS language which is object-favored language. In order to simplify the mapping process, we developed a set of rules to map the IFC model to an object-relational database (ORDB). Once the database has been configured, only those pieces of information that are required for a specific information-exchange scenario are extracted using the pre-defined information delivery manual (IDM). Therefore, file sizes will be reduced when exchanging data, meaning that files can now be effectively exchanged and shared. In this study, the framework of the IFC server using ORDB and IDM and the method to develop it will be examined.

  • PDF