• 한국보건간호학회지
• /
• 제18권1호
• /
• pp.154-166
• /
• 2004

The purpose of this study was to design and implementation of database for school health activity. This database system was designed stand-alone application for college school health center without a hospital affiliation and the database system was made of relational database management system, Microsoft access 2000 to be made GUI (Graphic user interface) type design and made up 7 tables: patients. symptoms. departments, income and outgo. medical cures. and medicine. The construction of this database system was patient management. code management. medicine management. and statistics management. The results of the database system were as follows; 1) This database system could be used for college school health center. 2) This database system could be made correct statistic data. 3) This database system could be managed income and outgo. 4) This database system could be changed for the better activity of community health service. 5) This database system could be simply attired administrative system. This database system will be used for students and employees to protect and promote health to measure for health level and quality of health service. In conclusion. this database system can be applied for unit health center to manage the college school health activity and advanced data management can be applied for health profession to do quality improvement. cost containment. management information system. and decision support system.

• 한국정보과학회논문지:데이타베이스
• /
• 제29권3호
• /
• pp.207-216
• /
• 2002

오늘날 우리는 HTML 폼을 통해 지역 데이타베이스뿐 아니라 원격 데이타베이스도 쉽게 접근할 수 있다. HTML 폼으로 데이타베이스 웅용을 구현하는 것이 쉽기는 하나 아직 HTML 폼과 CGI 프로그램은 코딩되어야만 한다. 본 논문에서는 웹 기반 데이타베이스 웅용을 자동 생성하는 도구를 소개하는데, 이 도구는 응용 데이타베이스 구축을 위한 SQL 문장들, 사용자 인터페이스로 사용되는 품들, 그리고 그 폼들을 통해 이루어진 질의를 처리하는 자바 서블릿을 생성한다. 생성될 테이블들과 폼들은 응용을 위한 클래스 다이어 그램으로부터 결정된다. 따라서 WebSiteGen으로 명명한 우리의 소프트웨어 도구는 웹기반 데이타베이스 응용의 구현을 자동화한다.

• 대한산업공학회지
• /
• 제41권2호
• /
• pp.162-172
• /
• 2015

This paper proposes a Product Data Management (PDM) system architecture that supports end-user computing for small and medium businesses (SMBs) in Korea to build and maintain efficient and sustainable information systems for their product development. Its open database with relational tables enables existing common application programs such as Microsoft office suites to access product data in PDM systems. In addition, the interactive query processor provided by database management systems helps design engineers to build ad hoc queries in standard SQL database language to response different data requirements during their product development. The PDM architecture with the open database allows design engineers or technical staffs in SMBs to build and maintain their application programs for product development by themselves. To show the feasibility of the proposed architecture, this study implemented a prototype PDM system based on the architecture and database, and represents real-world product data with the implemented PDM system.

• Journal of the Korean Data and Information Science Society
• /
• 제15권4호
• /
• pp.707-716
• /
• 2004

Recently, many areas of application such as statistics and industrial engineering are interested in the effective education of databases. In this article we design and implement a database learning system based on learner management techniques. The system supports a personalized/ team-centered learning environment, monitoring the learning attitude of learners, and a method for the assessment.

• 천문학회지
• /
• 제47권3호
• /
• pp.115-122
• /
• 2014

The New Vacuum Solar Telescope (NVST) is a 1-meter vacuum solar telescope that aims to observe the fine structures of active regions on the Sun. The main tasks of the NVST are high resolution imaging and spectral observations, including the measurements of the solar magnetic field. The NVST has been collecting more than 20 million FITS files since it began routine observations in 2012 and produces maximum observational records of 120 thousand files in a day. Given the large amount of files, the effective archiving and retrieval of files becomes a critical and urgent problem. In this study, we implement a new data archiving system for the NVST based on the Fastbit Not Only Structured Query Language (NoSQL) database. Comparing to the relational database (i.e., MySQL; My Structured Query Language), the Fastbit database manifests distinctive advantages on indexing and querying performance. In a large scale database of 40 million records, the multi-field combined query response time of Fastbit database is about 15 times faster and fully meets the requirements of the NVST. Our slestudy brings a new idea for massive astronomical data archiving and would contribute to the design of data management systems for other astronomical telescopes.

• 한국지반공학회:학술대회논문집
• /
• 한국지반공학회 2010년도 추계 학술발표회
• /
• pp.1282-1288
• /
• 2010

In this study, Site Investigation Program of cut slope is developed using related techniques and experience got from practical application of Inventory Survey Program of cut slope in work for last 4 years. The Site Investigation Program is designed to can be loaded to the Mobile PC for convenience of carrying in filed, convenience of data input and revision, application of diverse programs, convenience of confirming data and facility of establishment of real-time database system using wireless communication like Inventory Survey Program. Also, for connection with Inventory Survey Program, it has a same work process and can establish real-time database system of almost data obtained in filed using stability analysis tool loaded in this program. Application of this developed program is expected to be an opportunity that can contribute to development of slope investigation and database system area using IT techniques.

• 산업공학
• /
• 제17권2호
• /
• pp.226-232
• /
• 2004

In shipbuilding area, data sharing is one of the crucial issues. Recently, for collaborative design, ship structural CAD systems adopt the database as its primary storage. Database is useful to deal with the large amount of design information among the heterogeneous design department and design stage. To make the database-based CAD system object-oriented database(OODB) and object-relational database(ORDB) can be used. It is important to select proper database because the CAD system performance mainly depends on access performance of database. In this research, using prototype CAD system from other research, access performance of OODB and ORDB form CAD system was evaluated. STEP application protocol was used as the database schema and experiment was made in query by property and query by region. The results give some idea of how to choose the database for CAD systems.

• 산업공학
• /
• 제16권4호
• /
• pp.485-495
• /
• 2003

This paper reports on the application of the integration of mathematical programming model and database in a decision support system (DSS) for the planning of the multi-reservoir operating system. The DSS is based on a multi-objective, mixed-integer goal programming (MIGP) model, which can generate efficient solutions via the weighted-sums method (WSM). The major concern of this study is seamless, efficient integration between the mathematical model and the database, because there are significant differences in structure and content between the data for a mathematical model and the data for a conventional database application. In order to load the external optimization results on the database, we developed a systematic way of naming variable/constraint so that a rapid identification of variables/constraints is possible. An efficient database structure for planning of the multi-reservoir operating system is presented by taking advantage of the naming convention of the variable/constraint.

• 한국데이타베이스학회:학술대회논문집
• /
• 한국데이타베이스학회 1994년도 DB산업기술 활성화를 위한 학술대회 및 기술 심포지움
• /
• pp.105-129
• /
• 1994

The information system of corporations are facing a new environment expressed by miniaturization, decentralization and Open System. It is therefore of utmost importance for corporations to adapt flexibly th such new environment by providing for corresponding changes to their existing information systems. The objectives of this study are to identify this new environment faced by today′s information system and develop effective methods for data resource management under this new environment. In this study, it is assumed that the new environment faced by information systems can be specified as Distributed Computing Environment, and in order to achieve such system, presents Client/server architecture as its representative computing structure, This study defines Client/server architecture as a computing architecture which specialize the fuctionality of the client system and the server system in order to have an application distribute and perform cooperative processing at the best platform. Furthermore, from among the five structures utilized in Client/server architecture for distribution and cooperative processing of application between server and client this study presents two different data management methods under the Client/server environment; one is "Remote Data Management Method" which uses file server or database server and. the other is "Distributed Data Management Method" using distributed database management system. The result of this study leads to the conclusion that in the client/server environment although distributed application is assumed, the data could become centralized (in the case of file server or database server) or decentralized (in the case of distributed database system) and the data management method through a distributed database system where complete responsibility and powers with respect to control of data used by the user are given not only is it more adaptable to modern flexible corporate environment, but in terms of system operation, it presents a more efficient data management alternative compared to existing data management methods in terms of cutting costs.

• 한국지반공학회:학술대회논문집
• /
• 한국지반공학회 2010년도 추계 학술발표회
• /
• pp.1274-1281
• /
• 2010

Cut Slope Management System(CSMS) is a systematic maintenance and management system designed to prevent the collapse of cut slopes located along national roads and to minimize damages caused by slope collapse related accidents. In order to implement a maintenance and management system that will ensure safe road operation, the Korean government has started the inventory of cut slopes and developed a cut slope database since 2006. The study on the application of cut slope database is on-going and part of this study is the development of cut slope database management system (Slope-navi) using GIS technology and navigation system for the effective and efficient cut slope management using Information Technology. Using the Navigation Cut Slope Data Management System the previously developed database was checked and verified. The converted cut slope inventory data and field investigation reports of about 20,000 cut slopes were loaded in the navigation map. Through the development of the navigation's cut slope data search system, a systematic and efficient cut slope database management and operation in the prevention of slope collapse and remedial measure selection was established.