Earticle

Internet accessibility has been growing due to the diffusion of smartphones in today's society. Therefore, people can generate data anywhere and are confronted with the challenge that they should process a large amount of data. Since the appearance of relational database management system (RDBMS), most of the recent information systems are built by utilizing it. RDBMS uses foreign-keys to avoid data duplication. The transactions in the database use attributes, such as atomicity, consistency, isolation, durability (ACID), which ensures that data integrity and processing results are stably managed. The characteristic of RDBMS is that there is high data reliability. However, this results in performance degradation. Meanwhile, from among these information systems, some systems only require high-performance rather than high reliability. In this case, if we only consider performance, the use of NoSQL provides many advantages. It is possible to reduce the maintenance cost of the information system that continues to increase in the use of open source software based NoSQL. And has a huge advantage that is easy to use NoSQL. Therefore, in this study, we prove that the leverage of NoSQL will ensure high performance than RDBMS by applying NoSQL to database systems that implement RDBMS.

Background: Interest in cardiac rehabilitation therapy has been increasing in Korea after the addition of cardiac rehabilitation as a benefit item in the National Health Insurance Service in 2017. However, few epidemiological studies have characterized cardiac rehabilitation in Korea. Objects: To assess the national epidemiological data on cardiac rehabilitation therapy in Korea from 2017 to 2023. Methods: This study analyzed MM453, a prescription code for cardiac rehabilitation therapy in the Health Insurance Review and Assessment database. The data reviewed included the total number of cases per year and the number of cardiac rehabilitation therapy prescriptions per 100,000 people, along with sex and age distribution of patients undergoing cardiac rehabilitation therapy. Results: The number of cardiac rehabilitation therapy prescriptions in Korea increased from 4,443 in 2017 to 15,646 in 2023 (252.1% increase in 7 years). The incidence per 100,000 person-years rose from 8.64 in 2017 to 30.22 in 2023. The number of males undergoing therapy increased from 3,183 (incidence: 12.35) in 2017 to 11,276 (incidence: 43.53) in 2023. The number of females undergoing therapy increased from 1,260 (incidence: 4.91) in 2017 to 4,370 (incidence: 16.89) in 2023. The highest number of patients undergoing therapy from 2017 to 2023 was observed in the 60s age group (patients: 4,747, incidence: 9.17), followed by the 70s, 50s, and > 80s age groups. Conclusion: From 2017 to 2023, the number of patients undergoing cardiac rehabilitation therapy in Korea increased consistently. The therapy is approximately 2.6 times more common in males than that in females and is predominantly administered to individuals in their 60s, followed by those in their 70s, 50s, and 80s and above.

As Internet of Things(IoT) technologies expand, it is crucial to ensure secure and scalable database access for isolated private networks. Conventional solutions like Virtual Private Networks and port forwarding often struggle with performance, security risks, and operational overhead. To address these challenges, this study developed the DB-to-MQTT(DMQP), a messaging framework that enables remote database queries without exposing backend systems. By leveraging the MQTT protocol, DMQP facilitates asynchronous, reliable communication through a topic-based structure via a public broker. To evaluate DMQP's performance, physical network tests were conducted across South Korea, China, and India. The results showed that DMQP outperforms the conventional Direct Database Client Connection(DDCC) method for payloads under 50 KB. This study demonstrated that DMQP provides a reliable and secure system for Industrial IoT and smart manufacturing. Furthermore, this study identified the framework as a scalable solution for environments requiring both robust security and high performance.

The promulgation of the overall framework of Chinese students' development of core literacy has made the implementation of core literacy into specific teaching activities an urgent problem to be solved in the field of education. Based on the analysis of the problems existing in the undergraduate education under the mode of emphasizing theory and neglecting practice, this paper constructs the practical teaching system of Database Principle Course Based on the core quality, expounds the implementation strategy of practical teaching, and probes into how to train the students in the practical teaching of database principle Cultivate scientific spirit, learning ability, practical innovation, responsibility and other core literacy. After 5 rounds of practice, students have achieved better development in independent development and collaborative work, and their awareness of practical innovation has been significantly improved.

국내 많은 PC 제조업체 및 전문수리센터의 엔지니어들이 효율적인 진단 데이터베이스 시스템이나 CAD 툴의 부재로 신속하고 정확한 PC 장애 진단 및 보수에 많은 어려움을 겪고 있다. 본 논문에서는 이러한 문제를 해결하기 위하여, PC 유지보수를 위한 진단 데이터베이스 시스템을 제안한다. 제안하는 진단 데이터베이스 시스템을 사용하면 소프웨어 및 하드웨어 장애를 갖는 PC를 정확하고 신속히 진단할 수 있어 고객의 만족도를 높일 수 있다. 나아가 일선에서 일하는 PC 정비사들로 하여금 유지 보수 기술을 축적하고 소비자들의 PC 성능에 대한 신뢰도를 향상시킬 수 있게 된다.

Many of the domestic PC manufactures and professional PC repair shops are suffering from lack of efficient diagnostic database systems or CAD tools for diagnosis and repair of PCs. In order to solve this problem, a new diagnostic database system for PC maintenance and repair is presented in this paper. We can perform accurate and rapid diagnosis for the PCs with software and hardware troubles by using proposed database system and thus the number of customers who are satisfied with service results are to be increased. Furthermore our research outputs make it possible the experts in PC repair field accumulate maintenance techniques and enhance the reliability of performance evaluated by customers.

This study aimed at developing the standard questionnaire database system for rural development. By the previous study for the hierarchical listing of the factors related to rural development in the village level, the targetting questionnaire items pool was proposed. The data base system basically consisted of 3 parts: general, principal and sectoral parts for rural development. General and principal parts had the detailed questionnaires without any further hierarchy, but sectoral one 4-step hierarchy from high/medium/low levels to detailed questionnaires. Tentatively, total 417 questionnaires statements were written with 5 questioning styles: single choosing, multiple choosing, tabular, writing and special questions. Through the checking done by college students team from rural area, the database system having 467 questioning statements was finally developed.

메인 메모리 DBMS는 구동과 동시에 디스크에 존재하는 테이블의 내용이 메모리로 모두 올라가는 구조로 운영된다. 그러나, 메인메모리 DMBS도 디스크 파일시스템을 사용하여 데이터를 저장하고 트랜잭션 로그파일을 파일 시스템에 유지하여야 하기 때문에 CPU가 메모리에 접근하여 처리하는 속도에는 한계가 있게 마련이다. 본 논문에서는 메인메모리 DBMS인 Altibase 시스템에서 구현된 기술들이 디스크기반 DBMS인 Sybase와 얼마나 차이가 있는지를 어플리케이션 측면에서 성능분석을 통하여 평가하였다. 메인메모리 DBMS의 어플리케이션 성능이 디스크기반 DBMS에서의 어플리케이션 성능과 비교하면, 메인 메모리 DBMS의 성능이 축구승무패 단일게임에서는 1.24배 ~ 3.36배, 축구승무패와 축구 스페셜 두 게임에 동시 발매시 1.29배 ~ 7.9배의 성능향상이 있었으며, 발매 트랜잭션의 응답시간 시험결과 1.78배 ~ 6.09배의 빠른 응답시간을 보였다.

The main memory DBMS is operated which the contents of the table that resides on a disk at the same time as the drive is in the memory. However, because the main memory DBMS stores the data and transaction log file using the disk file system, there are a limit to the speed at which the CPU accesses the memory. In this paper, I evaluated the performance through analysis of the application side difference the technology that has been implemented in Altibase system of main memory DBMS and Sybase of disk-based DBMS. When the application performance of main memory DBMS is in comparison with the disk-based DBMS, the performance of main memory DBMS was outperformed 1.24~3.36 times in the single soccer game, and was outperformed 1.29~7.9 times in the soccer game / special soccer. The result of sale transaction response time showed a fast response time of 1.78 ~ 6.09 times.

락은 멀티프로세서 환경에서 공유 데이터에 대한 접근을 안전하게 하는 잘 알려진 일반적인 방법이다. 1960년대에 상호 배제가 소개된 후에 많은 스핀락 알고리즘이 제안되었고 운영체제나 데이터베이스 시스템에 사용되어 왔다. 이 연구에서 고성능 멀티코어 시스템 상에서 락 알고리즘이 데이터베이스 시스템에 미치는 영향을 측정하였다. 평가를 위해 그 동안 멀티코어 상에서 성능 개선을 위해 재구조화된 최신 MySQL 5.6 및 MySQL에 탑재된 InnoDB 엔진을 사용하였다. InnoDB의 스핀락 함수를 수정하여 다양한 락 알고리즘들을 구현하였고 구현된 락 알고리즘들을 멀티코어 환경에서 평가하였다.

A lock is a general and popular way of serializing accesses to shared data in multiprocessor environments. After the mutual exclusion was first introduced in 1960s, many spinlock algorithms have been proposed and deployed to real systems such as operating systems and (transactional) database systems. In this study, we measure impacts of a lock mechanism on a database system under various CPU configurations using a high-end multicore system. For the evaluation, we use the most up-to-date version of MySQL (version 5.6) with InnoDB engine, which has been substantially re-architected to improve scalability on multicore machines. We changed the original spinlock function of InnoDB to evaluate various spinlock mechanisms on multicore machines.

본 연구는 데이터베이스 시스템 품질 개선 성숙도 모델의 필요성을 인식하고 우선 일차연구로 데이터베이스 시스템 품질 평가에 적용할 수 있는 품질 평가 모듈을 개발하고자 한다. 데이터베이스 시스템 품질 관리 및 개선을 위해서는 데이터베이스 시스템 품질을 체계적으로 평가하기 위한 평가 모듈이 필요하다. 이러한 필요성에 따라 본 연구는 다음의 목적을 수행한다. 첫째 데이터베이스 시스템 품질 평가를 위해 ISO/IEC 9126시리즈를 기반으로 품질평가 특성과 부특성을 선정하고 평가 모듈(메트릭)을 개발한다. 둘째 산업계와 학계간에 인지하고 있는 품질 평가특성의 중요도에 대해 비교 분석한다. 품질 평가 모듈을 개발하여 정량적 평가에 적용할 수 있는 이론적 실증적 토대를 마련하였다는 점에서 중요한 의의를 갖으며 이는 데이터베이스 시스템 품질 평가에 대한 연구의 기초자료로 활용될 수 있을 것이다. 또한 후속연구에서는 데이터베이스 시스템 품질 평가를 통해 품질을 개선할 수 있는 품질 개선 성숙도 모델을 개발하는 연구로 진행되어야 할 것이다.

This study is to develop quality assessment module to apply database system quality assessment thus, recognizing necessity of database system quality improvement maturity model. To manage and improve of database system quality, assessment module is needed to assess database system quality systematically. This study is to perform for the purpose of follows. First, this study is to select quality characteristics and sub characteristics on based on ISO/IEC 9126 series and to develop assessment module for database system quality assessment. Second, this study is to compare and to analysis about quality assessment characteristics of two groups. This study is to have significance to apply quantitative assessment in theoretical and practical basis and is to applicate basic materials of study in database system quality assessment. Also, in succeeding study, it will be to develop of database system quality improvement maturity model.

네트워크 컴퓨팅의 급속한 발전과 기업의 인터넷/익스트라넷의 일반적인 사용으로 미래의 비즈니스 환경은 기업의 이익 및 효율성을 최대화하기 위해 기업 통합(Enterprise Integration) 및 가상 기업 (Virtual Enterprise)가 실현 될 것으로 예상된다. 기업간의 정보 공유을 기반으로 하는 가상 기업을 운영하기 위해서는 가상 기업의 정보 전달 수단과 관련된 작업 프로세스, 가상 기업에 참여하는 구성원 및 CAlS의 구현을 기반으로 하는 가상 기업의 지원 환경으로 이루어진다. 가상 기업의 환경으로 제공되는 CALS 구현을 위한 통합 데이터 환경을 지원하는 시스템은 각 지역 데이터의 자치성을 보장하며, 사용자에게 단일의 전역적인 뷰를 제공하기 위해 네트워크로 연결된 기업간의 이질적인 데이터베이스를 투명하게 엑세스할 수 있도록 제공되어야 한다. 본 논문에서는 가상기업 지원 환경으로 제공되는 통합데이터 환경을 위하여 각 기업에 존재하는 기존의 시스템을 유지하면서 이질적인 데이터베이스들을 투명하게 엑세스할 수 있는 방법으로 웹환경에서 Java/CORBA 기술과 관계형 데이터베이스, 객체지향형 데이터베이스와 파일 정보를 수용하기 위한 객체 질의 언어를 사용하는 데이터베이스 브로커 시스템을 설계 및 구현한다.

In recent days network computing technologies have bee developed rapidly and the extended use of Internet applications for enterprises such as internet/extarnet in and between enterprises has been increased enormously. Therefore the business in the future will be executed by virtual enterprise. Virtual enterprises which is based on information sharing between enterprises are composed of work processes related to information exchange between virtual enterprises, the team members who are representatives of the organizations that are participated in the actual business of virtual enterprises, and members who are representatives of the organizations that are participated in the actual business of virtual enterprises, and environment that are provided by supporting CALS(continuous Acquisition and Life cycle Support or commerce At light Speed). Supporting system of IDE(Integrated Data Environment)for CALS implementation that is provided as an environment of virtual enterprises has to ensure the autonomies of local data and to provide the accessibility of heterogeneous database of enterprises on network transparently for giving user a single global view of data. This paper introduce the design and implementation of the database broker system that can be accessed data transparently by the suers of participated enterprises in the integrated data environment supporting virtual enterprises. The system uses java/CORBA technology in Web environment and Object Query language (OQL) to process the queries of relational database system, object-oriented database system, and file information.

In the complexity and diversity of modern society, there is an urgent need for an information system which can systematically collect, manage and analyze data. Especially in the discipline of nursing, a nursing informarion system is necessary to maximize nursing resources and improve nursing care in the present system which is faced with increases in client needs and multiple changes in hospital environments. This research was done to provide a basis for the development of an integrative nursing information system for the future, by designing dababases items which were extracted from an analysis of the ward nursing information system on general wards excluding the OPD, ICU, OR and CSR with functions using a different system from the wards, and the design of output screen used the database items. The ward nursing information system was analysed through analysis of nursing practice related to recordings, such as the worksheet, kardex, and other nursing practice recordings, on 25 wards. The development of the database was the part of the construction of hospital information system and used the database development life cycle which is related to the system development life cycle. The database development steps included selection of database management system and design of a physical database following the principles of the order communication system which is been developing at Y University Hospital. Conceptual database and Logical database were designed using the base of 25 data items and fields derived from analysing the worksheet, the data items and fields derived from the kardex and other nursing practice recording, from these 19 data base tables were framed through transforming the relational database. Through this process, four types of output material for nursing practice recording which nurses can carry and use during their nursing practice were produced.

RDBMS는 전 세계적으로 많이 사용하는 데이터베이스 시스템으로, 행정정보 데이터세트(이하 데이터세트)는 RDBMS를 이용하여 행정정보시스템에서 생산되는 방대한 규모의 데이터를 의미한다. 행정적인 문서 위주로 생산되는 업무시스템과는 달리 행정정보시스템은 기관의고유한 업무 중심으로 기록들이 생산되고 있다. 이러한 기록들은 기존의 결재문서류와 메타데이터 등이 달라 표준기록관리시스템으로 이관이 쉽지 않다. 2022년 ｢공공기록물법 시행령｣ 개정으로 기록물의 관리권한만 이전하는 유형에 데이터세트가 포함되었고, 개정의 핵심 내용은 행정정보시스템에서 기록의 생애주기를 관리해야 하는 것으로 볼수 있다. 그러나 현재까지는 행정정보시스템에서 데이터세트를 어떻게관리해야 하는지 모색된 바는 없었다. 이에 본 연구에서는 기록의 생애주기를 관리하기 위해 행정정보시스템에 탑재해야 하는 기록관리모듈의 DB를 설계하고자 한다. ISO 16175-1:2020의 예시를 수정·보완하여 “인사관리시스템”을 설계하고, 인사관리 데이터세트를 식별 및 평가함으로써 행정정보시스템에서의 기록관리를 위한 구체적인 실행 예시를 보여주고자 한다. 본 연구에서 설계한 프로토타입 시스템이 실제기관에서 사용하고 있는 시스템에 비해 데이터의 양이 적고, 기록관리모듈의 DB가 헹정정보시스템에 적용 가능한지 현업에 계신 기록연구사분들과 IT 개발자들에게 검증을 받지 못한 한계점은 있다. 그러나, 예시를 통해서 데이터세트가 무엇인지 실체를 파악할 수 있었고, 행정정보시스템에서 데이터세트를 어떻게 관리해야 하는지 알 수 있었다. 그리고 행정정보시스템에서 기록관리 모듈의 필요성을 확인할 수 있었다. 향후 완전한 기록관리 모듈이 완성되고 국가기록원에서 기록관리 모듈에 대한 표준이 만들어진다면, 관련 기관에서 데이터세트를 관리하는데 필요한 모듈이 될 수 있을 것이라 기대한다.

RDBMS is a widely used database system worldwide, and the term dataset refers to the vast amount of data produced in administrative information systems using RDBMS. Unlike business systems that mainly produce administrative documents, administrative information systems generate records centered around the unique tasks of organizations. These records differ from traditional approval documents and metadata, making it challenging to seamlessly transfer them to standard record management systems. With the 2022 revision of the ‘Public Records Act Enforcement Decree,’ dataset was included in the types of records for which only management authority is transferred. The core aspect of this revision is the need to manage the lifecycle of records within administrative information systems. However, there has been little exploration into how to manage dataset within administrative information systems. As a result, this research aims to design a database for a record management module that needs to be integrated into administrative information systems to manage the lifecycle of records. By modifying and supplementing ISO 16175-1:2020, we are designing an “human resource management system” and identifying and evaluating personnel management dataset. Through this, we aim to provide a concrete example of record management within administrative information systems. It’s worth noting that the prototype system designed in this research has limitations in terms of data volume compared to systems currently in use within organizations, and it has not yet been validated by record researchers and IT developers in the field. However, this endeavor has allowed us to understand the nature of dataset and how they should be managed within administrative information systems. It has also affirmed the need for a record management module’s database within administrative information systems. In the future, once a complete record management module is developed and standards are established by the National Archives, it is expected to become a necessary module for organizations to manage dataset effectively.

Objectives: To establish a system for integrated risk assessment of EDCs in Korea, infrastructure for providing toxicity data of ecological media should be established. Some systems provide soil ecotoxicity databases along with aquatic ecotoxicity information, but a well-structured ecotoxicity database system is still lacking. Methods: Aquatic and soil ecotoxicological information were collected by a toxicologist based on a human readable data (HRD) format for collecting ecotoxicity data that we provided. Among these data, anomalies were removed according to database normalization theory. Also, the data were cleaned and encoded to establish a machine-readable data (MRD) ecotoxicity database system. Results: We have developed a multi-purpose ecotoxicity database model focusing on EDCs, ecological species, and toxic effects. Also, we have constructed a web-based data searching system to retrieve, extract, and download data with greater availability. Conclusions: The results of our study will contribute to decision-making as a tool for efficient ecological risk assessment of EDCs in Korea.

Agricultural facilities can be designed by conceptual preliminary primary and detailed design stages. because each stage has a different objective, it must be applied to dissimilar design and analysis level. Engineers have to judge from evaluation that is estimated agricultural resources in the conceptual design stage. Methods of computer aided design are achieved to individual functions however it is inefficient to perform entire processes of design and hard to systematically accumulate results o design. Study on the integrated structural design system has been continued. but those system have adopted “closed architecture”which is known to inflexible method for developing applications. In this study the design platform is an environment that can support to integrated design system independently and an design platform is proposed by analyzing design processes using object oriented method. The concepts of software platform have resulted from several practical ideas, OOA/OOP and related some points. This paper aims at developing the software platform of a software environment to support the design phases of the agricultural facilities.

최근 개인정보보호법 제정에 따라 인터넷에서 개인정보를 취급하는 공공기관 및 기업들은 개인정보 보호를 위해 접 근제어, 암호화 등 기술적 대책을 강구하고 있다. 개인정보 유출시 공공기관이나 기업은 이미지 훼손뿐만 아니라, 법적 책임을 면할 수 없는 실정이다. 그러나, 대용량 데이터베이스 시스템에서 매 접속 시마다 개인정보 항목에 대해 접근제 와와 암·복호화를 하도록 하는 것은 성능 저하이 원인이 된다. 본 논문에서는 동시 트랜잭션이 많은 Oracle DBMS 환경 에서 JVM(Java Virtual Machine)을 이용한 경량화 시스템을 설계·구현하여 성능에 최소한 영향을 미치면서 개인정보보 호법에 정한 요구사항을 효율적이고 안전하게 수행하는 시스템을 제안하였다. 제안 시스템을 A 공공기관 포털 및 인사 시스템 내 개인정보 보호에 적용하여 성능 차이를 검증하였다.

Recently, according to the establishment of personal information protection Act, the public and private organizations are taking a step to protect personal information rights and interests by employing the technical methods such as the access control mechanism, cryptography, etc. The result of the personal information leakage causes a serious damage for the organization image and also has to face with the responsibility by law. However, applying access control and cryptographic approach on the personal information item for every connection to large database system causes significant performance degradation in a large database system. In this paper, we designed and implemented the light weight system using JVM (Java Virtual Machine) for the Oracle DBMS environment which the concurrent transaction occurs many, thereby the proposed system provides the minimum impact on the system performance and meets the need of personal information protection. The proposed system was validated on the personal information protection system which sits on a ‘A’ public organization’s portal site and personnel information management system.