• Title/Summary/Keyword: Database Design for Records

Search Result 53, Processing Time 0.028 seconds

Nationwide Comprehensive GIS for Natural Environment using Spatial Data Integration Technique (공간데이타 통합 기능을 활용한 국가자연환경 종합 GIS구축)

  • Um, Jung-Sup;Kim, Yeun-Jung
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.4 no.1
    • /
    • pp.1-17
    • /
    • 2001
  • This research is primarily intended to develop a decision-making support system about the natural environment in the country by integrating various formats of spatial data into a comprehensive GIS database. The first part of the research is to design GIS database as a means of combining thematic cartographic data with field survey records. Ecosystem records acquired by a field sampling have been reproduced as digital thematic maps. The database also included various natural environment related data (map for forestry, soil, national park etc.) collected from many other agencies. The second part of the research is devoted to the design of efficient man-machine interfaces. A key concern in the GUI (graphic user interface) design process was to address the need to handle and to manage large databases by non-GIS experts. The system has been checked experimentally, enabled the users to quarry the data required simply and execute spatial analysis accommodating versatile alternatives in decision-making process. Detailed visual maps can be generated over large areas quickly and easily. The system will serve to increase the scientific and objective decision-making by overcoming serious constraints suffered from the past non-GIS-based approach. It is anticipated that this research output could be used as a valuable reference in building a nationwide natural environment GIS-DB (database) in the central and local governments.

  • PDF

Comparative Analysis of NoSQL Database's Activities and Scalability Investigation With Library Introspection

  • Seo, Chang-Ho;Tak, Byungchul
    • Journal of the Korea Society of Computer and Information
    • /
    • v.25 no.9
    • /
    • pp.1-9
    • /
    • 2020
  • In this paper, we propose a method of in-depth analysis of internal operation process by recording library calls and related information that occur in the operation process of NoSQL database. It observes and records the specified library calls, compares the internal behavior differences between the NoSQL databases through recorded library call information, and evaluates the characteristics and scalability of each database by observing changes in the number of input data. The development of computing performance and the activation of big data have led to the emergence of different types of NoSQL databases for recording and analyzing various and large amounts of data, and it is necessary to evaluate the scalability of each database in order to select a database suitable for each environment. However, it is difficult to analyze or predict how a database operates in traditional ways, such as benchmarking, observing external behavior through performance models, or analyzing structural features based on design. Therefore, it is necessary to utilize the techniques proposed in this paper to understand the scalability of NoSQL databases with high accuracy.

A Case Study of the Audio-Visual Archives System Development and Management (시청각(사진/동영상) 기록물 관리를 위한 시스템 구축과 운영 사례 연구)

  • Shin, Dong-Hyeon;Jung, Se-Young;Kim, Seon-Heon
    • Journal of Korean Society of Archives and Records Management
    • /
    • v.9 no.1
    • /
    • pp.33-50
    • /
    • 2009
  • ADD(Agency for Defense Development) has developed digital audio-visual archives management system to ensure easy access and long-term preservation for digital audio-visual archives. This paper covers total process of the system development and database management in the aspect of preservation and utilization by users' easy search through digitization of audio-visual archives. In detail, it contains system design for images and video data handling, standard workflow establishment, data quality, and metadata settings for database by converting an analog data into digital format. Also, this study emphasizes the importance of audio-visual archives management system through cost-effectiveness analysis.

A Study on Recordkeeping System in Australia (호주의 레코드키핑 시스템에 대한 연구)

  • Lee, Young-Sook
    • Journal of Korean Society of Archives and Records Management
    • /
    • v.4 no.2
    • /
    • pp.76-90
    • /
    • 2004
  • There had been substantial demand for record management system with which to efficiently control the information circulation processes, involving accumulation of recorded materials, classification of information resources, and users access to them. It converged to a collaboration of Australian federation, and Sydney Records Centre and finally induced Australian Standard Records Management, commonly known as AS 4390. AS 4390 served later as a model for International Standard of Record Management. This paper introduces the current undertaking of Recordkeeping system development in Australia, which stems from the line of AS 4390 by analysing exhibited research approaches. The analysis includes the definition, regime of Recordkeeping system, design and implementing of guidelines of Recordkeeping System and information on metadata projects. It also highlights the necessity for standardization, as is the prime factor in promoting inter-linking of Tabularium on New Southwales State, CRS(Commonwealth Record Series), database system of Canberra National Archives and Australian Government Locator Service. From year 2005, as dictates, any record management system, serving public agency will be required to adapt Professional Archives Management System, which, by far, will enhance the inter-compatibility. In its application, the government need Thesaurus to eliminate possible redundancy in use of terminology and to promote correct usage of words.

Requirement analysis for visualization of condition assessment in 3D Bridge Model (3차원 교량모델에서의 상태평가정보 가시화를 위한 요구사항 분석)

  • Huang, Meng-Gang;Kim, Bong-Geun;Lee, Sang-Ho
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2010.04a
    • /
    • pp.238-241
    • /
    • 2010
  • This paper proposed an approach to integrate bridge condition assessment related information with a 3D bridge model to visualize bridge condition assessment information in the 3D bridge model. In this approach, bridge information model plays a centric role in the data access and realizes the integration of bridge initial design and historical bridge maintenance records. Behind the bridge information model is a rational database. After the system requirements for this approach, several IFC data model extensions are suggested.

  • PDF

Ductility demands of steel frames equipped with self-centring fuses under near-fault earthquake motions considering multiple yielding stages

  • Lu Deng;Min Zhu;Michael C.H. Yam;Ke Ke;Zhongfa Zhou;Zhonghua Liu
    • Structural Engineering and Mechanics
    • /
    • v.86 no.5
    • /
    • pp.589-605
    • /
    • 2023
  • This paper investigates the ductility demands of steel frames equipped with self-centring fuses under near-fault earthquake motions considering multiple yielding stages. The study is commenced by verifying a trilinear self-centring hysteretic model accounting for multiple yielding stages of steel frames equipped with self-centring fuses. Then, the seismic response of single-degree-of-freedom (SDOF) systems following the validated trilinear self-centring hysteretic law is examined by a parametric study using a near-fault earthquake ground motion database composed of 200 earthquake records as input excitations. Based on a statistical investigation of more than fifty-two (52) million inelastic spectral analyses, the effect of the post-yield stiffness ratios, energy dissipation coefficient and yielding displacement ratio on the mean ductility demand of the system is examined in detail. The analysis results indicate that the increase of post-yield stiffness ratios, energy dissipation coefficient and yielding displacement ratio reduces the ductility demands of the self-centring oscillators responding in multiple yielding stages. A set of empirical expressions for quantifying the ductility demands of trilinear self-centring hysteretic oscillators are developed using nonlinear regression analysis of the analysis result database. The proposed regression model may offer a practical tool for designers to estimate the ductility demand of a low-to-medium rise self-centring steel frame equipped with self-centring fuses progressing in the ultimate stage under near-fault earthquake motions in design and evaluation.

Data Mining and Construction of Database Concerning Effects of Vitis Genus (산머루 관련 정보수집 및 데이터베이스의 구축)

  • Kim, Min-A;Jo, Yun-Ju;Shin, Jee-Young;Shin, Min-Kyu;Bae, Hyun-Su;Hong, Moo-Chang;Kim, Yang-Seok
    • Journal of Physiology & Pathology in Korean Medicine
    • /
    • v.26 no.4
    • /
    • pp.551-556
    • /
    • 2012
  • The database for the oriental medicine had been existed in documentation in past times and it has been developed to the database type for random accesses in the information society. However, the aspects of the database are not so diversified and the database for the bio herbal material exists in widened type dictionary style. It is a situation that the database which handles the in-depth raw herbal medicines is not sufficient in its quantity and quality. Korean wild grape is a deciduous plant categorized into the Vitaceae and it was found experimentally that it has various medical effects. It is one of the medical materials with higher potentiality of academic study and commercialization recently because it has a bigger possibility to be applied into diverse industrial fields including the medical product for health, food and beauty. We constituted the cooperative system among the Muju cluster business group for Korean mountain wild grapes, Physiology Laboratory in Kyung Hee University Oriental Medicine and Medical Classics Laboratory in Kyung Hee University Oriental Medicine with a view to focusing on such potentiality and a database for Korean wild grapes was made a touchstone for establishing the in-depth database for the single bio medical materials. First of all, the literatures based on the North East Asia in ancient times had been categorized into the classical literature (Korean literature published by government organization, Korean classical literature, Chinese classical literature and classical literature fro Korean and Chinese oriental medicine) and modern literature (Modern literature for oriental medicine, modern literature for domestic and foreign herbal medicine) to cover the eastern and western research records and writings related to Korean wild grapes and the text-mining work has been performed through the cooperation system with the Medical Classics Laboratory in Kyung Hee University Oriental Medicine. First of all, the data for the experiment and theory for Korean wild grape were collected for the Medline database controlled by the Parliament Library of USA to arrange the domestic and foreign theses with topic for Korean wild grapes and the network hyperlink function and down load function were mounted for self-thesis searching function and active view based on the collected data. The thesis searching function provides various auxiliary functions and the searching is available according to the diverse searching/queries such as the name of sub species of Korean wild grape, the logical intersection index for the active ingredients, efficacy and elements. It was constituted for the researchers who design the Korean wild grape study to design of easier experiment. In addition, the data related to the patents for Korean wild grape which were collected from European Patent Office in response to the commercialization possibility and the system available for searching and view was established in the same viewpoint. Perl was used for the query programming and MS-SQL for database establishment and management in the designing of this database. Currently, the data is available for free use and the address is as follows. http://163.180.41.43:8011/index.html

Construction of Street Trees Information Management Program Using GIS and Database (GIS와 데이터베이스를 이용한 가로수정보 관리프로그램 구축)

  • Kim, Hee-Nyeon;Jung, Sung-Gwan;Park, Kyung-Hun;You, Ju-Han
    • 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.

  • PDF

Development of an Agricultural Data Middleware to Integrate Multiple Sensor Networks for an Farm Environment Monitoring System

  • Kim, Joonyong;Lee, Chungu;Kwon, Tae-Hyung;Park, Geonhwan;Rhee, Joong-Yong
    • Journal of Biosystems Engineering
    • /
    • v.38 no.1
    • /
    • pp.25-32
    • /
    • 2013
  • Purpose: The objective of this study is to develop a data middleware for u-IT convergence in agricultural environment monitoring, which can support non-standard data interfaces and solve the compatibility problems of heterogenous sensor networks. Methods: Six factors with three different interfaces were chosen as target data among the environmental monitoring factors for crop cultivation. PostgresSQL and PostGIS were used for database and the data middleware was implemented by Python programming language. Based on hierarchical model design and key-value type table design, the data middleware was developed. For evaluation, 2,000 records of each data access interface were prepared. Results: Their execution times of File I/O interface, SQL interface and HTTP interface were 0.00951 s/record, 0.01967 s/record and 0.0401 s/record respectively. And there was no data loss. Conclusions: The data middleware integrated three heterogenous sensor networks with different data access interfaces.

Decision support Systems research in Korea (1985-1998): An Empirical Investigation through Exploratory Factor Analysis

  • Yoo, Sangjin;Eom, Sean B.
    • Korean Management Science Review
    • /
    • v.17 no.2
    • /
    • pp.151-159
    • /
    • 2000
  • This study applies factor analysis of an author cocitation frequency matrix derived from a database file that consists of a total of 1095 cited reference records taken from 95 citing decision support systems articles published in Korean journals. This study identified the influence of social psychology, cognitive psychology, management information systems, strategic management, and organizational behavior/organizational design to the development of group support systems, user-interface, and executive information systems research subspecialties. This research establishes a benchmark to be used in the future research, which is necessary to account for the ongoing changes in the intellectual development and structure of DSS Research in Korea before solid conclusion can be reached about the maturity and on-going development of the DSS field in Korean.

  • PDF