• 제어로봇시스템학회:학술대회논문집
• /
• 제어로봇시스템학회 2005년도 ICCAS
• /
• pp.767-772
• /
• 2005

The Internet is a packet switched network which offers best-effort service, but current IP network provide enhanced services such Quality of Services, Virtual Private Network (VPN) services, Distribute Firewall and IP Security Gateways. All such services need packet classification for determining the flow. The problem is performing scalable packet classification at wire speeds even as rule databases increase in size. Therefore, this research offer packet classification algorithm that increase classifier performance when working with enlarge rules database by rearrange rule structure into Bitmap Intersection Lookup (BIL) tables. It will use packet's header field for looking up BIL tables and take the result with intersection operation by logical AND. This approach will use simple algorithm and rule structure, it make classifier have high search speed and fast updates.

• 한국경영과학회지
• /
• 제27권4호
• /
• pp.29-39
• /
• 2002

The transaction tables of the existing association algorithms have two column attributes : It is composed of transaction identifier (Transaction_id) and an item identifier (item). In this kind of structure, as the volume of data becomes larger, the performance for the SQL query statements came applicable decreases. Therefore, we propose advanced association rules algorithm of n-items which can transact multiple items (Transaction_id, Item 1, Item 2…, Item n). In this structure, performance hours can be contracted more than the single item structures, because count can be computed by query of the input transaction tables. Our experimental results indicate that performance of the n items structure is up to 2 times better than the single item. As a result of this paper, the proposed algorithm can be applied to internet shopping, searching engine and etc.

• 정보기술과데이타베이스저널
• /
• 제2권2호
• /
• pp.87-109
• /
• 1995

The index file has been used a access database records effectively. The join operation in a relational database system requires a large execution time, especially in the case of handling large size tables. If the indexes are available on the joining attributes for both relations involved in the join and the join selectivity is relatively small, we can improve the execution time of the join operation. In this paper. we investigate the performance trade-offs of parallel index-based join algorithms where different indexing schemes are used. We also present a comparison of our index-based parallel join algorithms with the hash-based parallel join algorithm.

• 한국시뮬레이션학회논문지
• /
• 제11권2호
• /
• pp.55-66
• /
• 2002

VHDL has been. widely used in modeling and simulation of hardware designs. However, complex relationship between components of the designs makes the VHDL modeling problem very difficult. Furthermore, after the initial creation of VHDL models, they evolve into many versions over their lifetime. To cope with such difficulties, this paper proposes a new methodology for the management of VHDL models supporting versions. Its conceptual bases are system entity structure and relational database. Within the methodology, a family of hierarchical structures of a design is organized in the form of VHDL model structure. It is, in turn, represented in the form of relational tables. Once the model structure is built in such a way, a specific simulation model which meets design objective is pruned from the model structure. The details of VHDL codes are systematically synthesized by combining it with the primitive models in a model base. These algorithms are also defined in terms of relational algebraic operations.

• 전자공학회논문지
• /
• 제51권2호
• /
• pp.197-204
• /
• 2014

본 논문에서는 함정 전투 시스템을 위한 메시지 지향 모델링 도구의 구조 설계에 대하여 연구한다. 함정 전투 시스템은 다양하고 대규모의 장비와 통신 서비스 그리고 데이터 분산 서비스 등으로 구성되어 있다. 각각의 장비들은 컴포넌트로서 대규모의 메시지를 발생시킨다. 이러한 메시지를 관리하기 위해 메시지 지향 모델링 도구가 개발되었다. 기존 모델링 도구는 중복되는 데이터베이스 테이블로 인해 어플리케이션 성능이 낮은 문제점이 있다. 본 논문에서는 이러한 문제점을 해결하기 위해 보다 효율적인 데이터베이스 설계 방안을 제안한다. 중복되는 테이블 수를 줄이고 어플리케이션의 응답 속도 및 처리시간을 향상시킨다. 실험 결과들은 제안하는 방법이 메시지 지향 모델링 도구 어플리케이션에 적용 가능함을 보이고, 클라이언트 노드로부터 서버로 전송되는 총 데이터양과 서버부하의 감소에 대하여 보여준다.

• 한국정보과학회논문지:데이타베이스
• /
• 제32권1호
• /
• pp.86-99
• /
• 2005

본 논문에서는 프로그램 분석 기술에 기반하여, 주어진 프로그램 내에서 트랜잭션 처리 관련 오류를 자동으로 검출해주고, 성능저하 요소가 발견되면 자동으로 개선된 코드로 변환하여 주는 시스템을 제안한다 트랜잭션 처리 오류란 트랜잭션을 열고서 닫지 않는 경우나, 잘못된 잠금수준(Locking-Level)을 설정하는 경우를 말한다 전자의 경우, 원하는 대로 데이타가 저장되지 않거나 장시간 데이타베이스 테이블을 잠금(Locking)으로써 시스템 전체의 성능을 떨어뜨릴 수 있다. 후자의 경우. 시스템에 따라 예외상황이나 프로그램의 파행적 실행 중단을 야기한다. 비효율적인 트랜잭션 처리란, 트랜잭션 영역(Boundary) 또는 잠금수준을 비효율적으로 설계하여서 다른 프로세스들의 트랜잭션을 지연시키는 경우를 말한다.

• 대한한의학원전학회지
• /
• 제32권1호
• /
• pp.171-189
• /
• 2019

Objectives : This study analyzes herbs combinations and primary virtues that constitute the prescriptions of Gyeji-tang, Mahwang-tang, and Daecheongryong-tang to effectively analyze medication preparations described in "Shanghanlun" using database, and test the results of the data structure and effectiveness of queries. Methods : This study enters "Sanghanjapbyeongronyeonggudaeseong" as the original text into the database, and even uses one provision as independent knowledge by dividing provisions in accordance with the content. Results : Five tables and 12 queries were created and used for data input and analysis. Using the types of Herbs included in the prescriptions, this study manages to search for the same or supplemented prescriptions, and the primary virtues of the prescriptions were collected and compared. Conclusions : Subject to the combination of herbs and pathology for the prescriptions described in "Shanghanlun" utilizing the database, this study found relevant texts and combinations of herbs and pathologies, and using this, the time required for theoretical research between prescriptions could be shortened.

• 농촌계획
• /
• 제11권2호
• /
• pp.43-49
• /
• 2005

As information has been brought to public attention, information storage as well as information usability has been important. Rural information is produced in many areas and institutions. However, it is difficult to use rural information comprehensively. Since formats for management are various, it is difficult to have unified frame. In this research, a schema of database fer integrating rural data is designed to improve usability using dimensional modeling. First of all, rural data are analyzed for designing integrated rural database schema. Rural data used are 'National Agricultural Statistics' and 'Gun annual statistical report'. Analysis shows that there are three considerations; administrative district, time-dependency and classification of data. Considering these three requisite, we designed database schema using dimensional modeling. The reason of using dimensional modeling is to improve usability and effectiveness. If the database was designed using ER modeling, many tables have to be joined every searching time. Separately from integrated rural database schema, user's database schema is designed considering usability. Through user's database, users can modify data or generate new data and save these processes. These make it possible to use generated data repeatedly. We evaluate usability, contribution, and effectiveness of data manipulation on the integrated rural database. We propose an integrated rural database structure improving the accessibility and usability of rural data and information and verified the data model based on a practical example.

• 한국식품영양학회지
• /
• 제26권4호
• /
• pp.886-894
• /
• 2013

The National Standard Food Composition Table published by the Rural Development Administration (RDA) provides the foundations in research, nutrition monitoring, policy and dietary practices in Korea. This databases consists of several sets of data including food descriptions, nutrients, portion weights, and source of data. The National Standard Food Composition Table have been published since 1970 and, recently, new version (8th edition) of Food Composition Table which has quantitative and qualitative nutrient data is released in 2011. In addition, the User-friendly Food Composition Table is divided into adult, children, and elderly categories depending on the subjects because we need different nutrients according to various ages. The Tables of Food Functional Composition is firstly edited in 2009. RDA published the minerals and fatty acids composition table, tables of amino acid, fat-soluble vitamin composition table, and the cholesterol table. The resulting database will be widely used. The users of the databases are from diverse fields, includeing federal agencies, the food industry, health professionals, restaurants, software application developers, academia and research organizations, international organizations, and foreign governments ect. Therefore, consistent improvements of the database is important, so that people can better address such health challenges by providing reliable and accurate data.

• 간호행정학회지
• /
• 제2권1호
• /
• pp.73-96
• /
• 1996

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.