• Current Research on Agriculture and Life Sciences
• /
• v.26
• /
• pp.45-54
• /
• 2008

The purpose of this research is to develope street trees management program for more an effective street trees management. The principal point of this program is to relate spatial data and attribute data that is the main concept in GIS(Geographic Information System). To do this function, MapObjects which is ESRI's mapping and GIS components was used to process spatial data and Access which had been developed by MS was used to manipulate attribute data in this program. Visual Basic also was used to design and develop user interfaces and procedures, relate two sort of data, and lastly complete Application. Relational data model was adopted to design tables and their relation, Antenucci's GIS development model was selected to design and complete this program. The configuration of this application is composed of management data and reference data. The management data includes the location of street tree, a growth condition, a surrounding environment, the characters of tree, an equipments, a management records and etc. The reference data include general information about tree, blight and insects.

• Journal of the Korean Society of Hazard Mitigation
• /
• v.5 no.4 s.19
• /
• pp.9-15
• /
• 2005

This research developed the RMIS(Risk Management Information System) which focus on works of risk management fields required of apply of a space information, and focus on the DB to establish and apply the space information efficiently with research scope on the LPG refueling station in city. On the basis of the RMIS, this research provides the baseline to lead on an efficiency of safety inspection of LPG refueling station, advance risk assessment, and efficient making decision of an accident correspondence assessment with interlocking the GIS representing risk through the automation of a quantitative risk assessment standardize requirement to control at real-time. The RMIS development process is as follows. firstly, Relational Database(RDB) was developed by using fundamental data both On-site and Off-site relating data as peforming risk assessment on the LPG refueling station in city. Second, the risk management integral database system was developed to monitor and control the risk efficiently for user with using the Visual Basic Program. Third, through interlocking the risk management integral database system and the GIS(Falcon-map) was suggested the decision making method. Represented results through out the RMIS program development are as follows. Firstly, the RMIS was established the mutual information to advance management the risk efficiently for user and inspector with using the risk management data. Second, as this study managed risk for on-site and off-site separately and considered effect for inside and outside of facility, constructed the basis on safety management which can respond to major accident. Third, it was composed the baseline to making decision that on the basis of user interface.

• Journal of Korean Society of Occupational and Environmental Hygiene
• /
• v.19 no.4
• /
• pp.347-362
• /
• 2009

The United Nation agreed to adopt the Globally Harmonized System of Classification and Labelling of Chemicals (GHS) until 2008 to solve the significant differences enough to result in different labels or MSDS for the same chemical in different jurisdictions. Though the GHS is an ideal solution in the respect of pursuing only one format of a MSDS throughout the world, it may cause confusion at the beginning due to lack of information. So the Korean Ministry of Labor (MOL) revised the Industrial Safety and Health Act (ISHA) and related public notice on the classification & labelling of chemicals according to the GHS in 2006. The transition period for the implementation of the GHS for substances was set until Jun 30, 2010, and for mixtures until Jun 30, 2013. To promote the implementation of the GHS in Korea, we developed an application program for constructing MSDS database and a management program for providing MSDS contents on the web in accordance with the GHS. We analyzed the sixteen sections of MSDS by the GHS guideline, and the result showed the necessity to construct logically connected DB for chemical identifier, hazard classification, label, standard phrases and regulatory information. Each section of a MSDS was divided into sub-databases to update the database efficiently. According to Relational Database Management System (RDBMS), the sub-databases were automatically assembled and subsequently a full MSDS is produced. At present, MSDS database for 6,314 substances has been built and provided through internet as the MSDS Editing program. During the service period from January 1 to March 31, 13,666 users have searched MSDSs for 33,401 substances. During program review, some comments about the classification results and other MSDS element sources were reported but no technical bug reported. We expect that the MSDS DB management system in accordance with GHS will accelerate the implementation of the GHS in Korea.

• Journal of Korean Academy of Nursing Administration
• /
• v.12 no.1
• /
• pp.14-22
• /
• 2006

Purpose: The purpose of this study is developing the nursing information system which contains the core elements of nursing practice, the Nursing Minimum Data Set (NMDS) that should be collected and documented all the settings in which nursing care is provided. Method: The program was developed under the hospital information system by TCP/IP protocol and used NANDA, Nursing Interventions Classification (NIC), and Nursing Outcomes Classification (NOC) to fill out the elements of NMDS. The Oracle was used as DBMS under the Windows 98 environment and Power Builder 5.0 was used as a program language. Results: This study developed linkage among the NANDA-NOC-NIC to facilitate choosing correct nursing diagnosis, interventions, and outcomes and stimulate nurses' critical thinking. Also the system developed includes nursing care sensitive patient outcomes, so nurses can actively involve in nursing effectiveness research by analyzing the data stored in the database or by making relational databases with other health care related databases. Conclusion: The program developed in this study ultimately can be used for the nursing research, policy development, reimbursement of nursing care, and calculating staffing and nursing skill mix by providing tool to describe and organize nursing practice and measure the nursing care effectiveness.

• The Journal of the Korea Contents Association
• /
• v.15 no.9
• /
• pp.403-410
• /
• 2015

Since 1970, MRI has greatly been developing in terms of strength of magnetic field, the number of receipt channels, and short time of examination. With the development of digital systems and wireless network, hospitals have also acquired, saved, and managed digital images taken by various kinds of medical imaging equipment. However, domestic universities fail to provide practice training course independently thanks to expensive practice equipment and high maintenance cost, and rely on clinical training. Therefore, this study developed a MR patient diagnosis program based on Windows PC to help out students before their working in clinical filed. The designed Relational Database of MRI Simulator is made up of seven tables according to functions and data characteristics. Regarding the designed patient information, each stepwise function was classified by the patient registration method in clinical field. In addition, on the assumption of the basic information for diagnosis, each setting and content were classified. The menu by execution step was arrayed on the left side for easy view. For patient registration, a patient's name, gender, unique ID, birth date, weight, and other types of basic information were entered, and the patient's posture and diagnosis direction were set up. In addition, the body regions for diagnosis and Pulse Sequence were listed for selection. Also, Protocol name and other additional factors were allowed to be entered. The final window was designed to check diagnosis images, patient information, and diagnosis conditions. By learning how to enter patient information and change diagnosis conditions in this program, users will be able to understand more theories and terms learned in practice and thereby to shorten their learning time in actual clinical work.

• IE interfaces
• /
• v.16 no.1
• /
• pp.8-15
• /
• 2003

With rapid growth of internet technology, companies have developed an information system such as the electronic catalog for product data in the E-Business. Due to the heuristic nature of the catalog search for proper tools in the specific process, the intelligent and user friendly methods residing in the search process give a comfortable environment even for the beginners in the field. In this paper, we develop a web based catalog for machining tools especially in Milling process. It has two distinct procedures for the users of the catalog; Search and Analysis. The Search is to select a proper cutter, insert, component combination in the developed relational database based on the cutting process and material. The Analysis is to suggest a recommended optimal cutting conditions based on the machining tools and selected materials. All of these procedures are stored in a server with a program based on the ASP and Java Script where the procedure is initiated by the client using the internet which is accessed through insert. With the success on implementing the above engineering database in the internet, we can provide the foundation for developing PDM with heuristic procedure.

• Journal of the military operations research society of Korea
• /
• v.22 no.1
• /
• pp.81-96
• /
• 1996

In a relational database environment, partitioning of data is directly concerned with the amount of data that needs to be required in a query or transaction. In this paper, we consider non-overlapping, vertical partitioning. Vertical partitioning algorithm in this paper is composed of two phases. In phase 1, we cluster the attributes with zero-one integer program that maximize affinity among attributes. The result of phase 1 is called 'Initial Fragments'. In phase 2, we modify Initial Fragments that is not directly considered by cost factors, making use of a transaction-based partitioning method. A transaction-based partitioning method is partitioning attributes according to a set of transactions. In this phase we select logical accesses which needs to be required in a transaction as comparison criteria. In phase 2, proposed algorithm consider only small number of modification of Initial Fragments in phase 1. This algorithm is so insensible to number of transactions and of attributes that it can applied to relatively large problems easily.

• International conference on construction engineering and project management
• /
• 2009.05a
• /
• pp.956-961
• /
• 2009

When construction engineers perform their work in the jobsite, they have to record as-built conditions in the project log (Data Collection). On the other hand, the engineers often have to refer to the construction documents when necessary at the job faces (Data Access). The practice of Data Collection and Data Access in the jobsite can be greatly enhanced by utilizing mobile computing with wireless communications. In this paper, two cases of mobile computing applications for construction field management are presented; Mobile Specifications System and Mobile Data Collection System. The demonstration of the process for developing two mobile applications is the primary purpose of the paper. The problems and issues involved with adopting mobile computing for construction field are also presented. The simple information framework for mobile computing has been also proposed as an outcome of the research. As for development tools, readily available relational database and wireless network have been used. The use of commercial mobile broadband was examined for data communication where local area network is not available.

• The KIPS Transactions:PartD
• /
• v.16D no.6
• /
• pp.835-844
• /
• 2009

Today, most of all the query processors in the world generally use the 'Pipelining' method to acquire fast response time (first record latency) and less memory usage. Each of the operator nodes in the Query Execution Plan (QEP) provides Open(), Next(), and Close() functions for their interface to facilitate the iterator mechanism. However, the embedded database systems for the mobile devices, based on the FLASH memory, usually require a function like Previous(), which returns the previous records from current position. It is because that, in the embedded environment, the mobile devices cannot fully provide it main memory to store all the query results. So, whenever needed the previously read records the user (program) should re-fetch the previous records using the Previous() function: the BACKWARD data fetch. In this paper, I introduce the 'Direction Switching Problem' caused by the Previous() function and suggest 'Block-wise Skipping' method to fully utilize the benefits of the block-based data transfer mechanism, which is widely accepted by most of the today's relational database management systems.

• The Journal of the Korea Contents Association
• /
• v.13 no.9
• /
• pp.410-417
• /
• 2013

Long-term behavior analysis considering construction sequence should be performed in the design and the actual construction of reinforced tall buildings. Most of the analytical studies on this subject, however, has not been applied directly to the structural design and the construction caused by the simple approach. As the axial force redistribution of shores and columns is time-dependent, the actual construction sequence with the placement of concrete, form removal, reshoring, shore removal, and the additional load application is very important. Object-oriented analysis program considering construction sequence, especially time-dependent deformation in early days, is developed. This system is composed of input module, database module, database store module, analysis module, and result generation module. Linkage interface between the central database and each of the related module is implemented by the visual c# concept. Graphic user interface and the relational database table are supported for user's convenience.