• 제목/요약/키워드: Database management systems

Search Result 1,024, Processing Time 0.029 seconds

A NoSQL data management infrastructure for bridge monitoring

  • Jeong, Seongwoon;Zhang, Yilan;O'Connor, Sean;Lynch, Jerome P.;Sohn, Hoon;Law, Kincho H.
    • Smart Structures and Systems
    • /
    • v.17 no.4
    • /
    • pp.669-690
    • /
    • 2016
  • Advances in sensor technologies have led to the instrumentation of sensor networks for bridge monitoring and management. For a dense sensor network, enormous amount of sensor data are collected. The data need to be managed, processed, and interpreted. Data management issues are of prime importance for a bridge management system. This paper describes a data management infrastructure for bridge monitoring applications. Specifically, NoSQL database systems such as MongoDB and Apache Cassandra are employed to handle time-series data as well the unstructured bridge information model data. Standard XML-based modeling languages such as OpenBrIM and SensorML are adopted to manage semantically meaningful data and to support interoperability. Data interoperability and integration among different components of a bridge monitoring system that includes on-site computers, a central server, local computing platforms, and mobile devices are illustrated. The data management framework is demonstrated using the data collected from the wireless sensor network installed on the Telegraph Road Bridge, Monroe, MI.

Requirement Analysis for Bio-Information Integration Systems

  • Lee, Sean;Lee, Phil-Hyoun;Dokyun Na;Lee, Doheon;Lee, Kwanghyung;Bae, Myung-Nam
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 2003.09a
    • /
    • pp.11-15
    • /
    • 2003
  • Amount of biological data information has been increasing exponentially. In order to cope with this bio-information explosion, it is necessary to construct a biological data information integration system. The integration system could provide useful services for bio-application developers by answering general complex queries that require accessing information from heterogeneous bio data sources, and easily accommodate a new database into the integrated systems. In this paper, we analyze architectures and mechanisms of existing integration systems with their advantages and disadvantages. Based on this analysis and user requirement studies, we propose an integration system framework that embraces advantages of the existing systems. More specifically, we propose an integration system architecture composed of a mediator and wrappers, which can offer a service interface layer for various other applications as well as independent biologists, thus playing the role of database management system for biology applications. In other words, the system can help abstract the heterogeneous information structures and formats from the application layer. In the system, the wrappers send database-specific queries and report the result to the mediator using XML. The proposed system could facilitate in silico knowledge discovery by allowing combination of numerous discrete biological information databases.

  • PDF

A Study on Database Design Model for Production System Record Management Module in DataSet Record Management (데이터세트 기록관리를 위한 생산시스템 기록관리 모듈의 DB 설계 모형연구)

  • Kim, Dongsu;Yim, Jinhee;Kang, Sung-hee
    • The Korean Journal of Archival Studies
    • /
    • no.78
    • /
    • pp.153-195
    • /
    • 2023
  • 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.

Intelligent Query Processing Using a Meta-Database KaDB

  • Huh, Soon-Young;Hyun, Moon-Kae
    • Proceedings of the Korea Inteligent Information System Society Conference
    • /
    • 1999.03a
    • /
    • pp.161-171
    • /
    • 1999
  • Query language has been widely used as a convenient tool to obtain information from a database. However, users demand more intelligent query processing systems that can understand the intent of an imprecise query and provide additional useful information as well as exact answers. This paper introduces a meta-database and presents a query processing mechanism that supports a variety of intelligent queries in a consistent and integrated way. The meta-database extracts data abstraction knowledge form an underlying database on the basis of a multilevel knowledge representation framework KAH. In cooperation with the underlying database, the meta-database supports four types of intelligent queries that provide approximately or conceptually equal answers as well as exact ones.

  • PDF

A Study on the Systems Engineering Management Plan for the Railway Safety System (철도안전시스템에 적용한 시스템 엔지니어링 관리 계획 작성사례 연구)

  • Choi Yo-Chul;Park Young-Won;Cho Yun-Ok
    • Proceedings of the KSR Conference
    • /
    • 2005.05a
    • /
    • pp.64-69
    • /
    • 2005
  • The Systems Engineering Management Plan (SEMP) is the primary, top level technical management document for the integration of all engineering activities at the project plan phase. This document defined the activities to plan, control, and perform overall engineering integration. To develop the SEMP for Railway Safety System, several standards are reviewed and analyzed. And then a common requirement for SEMP preparation is derived from the results of analysis. Also, the SEMP example available practically applies to Railway Safety System. In particular, The SEMP focused on controling technical program management has been organized so far, but in this study the detailed contents of SEMP put stress on project management is derived. And it is related to each other between project management and technical engineering management. At the end, to continuously manage the items and contents of the SEMP, a database management and an automatic document generation system is presented using Computer-Aided Systems Engineering (CASE) tool.

  • PDF

Multiple Perspectives on Knowledge Management : Social Network, Resource Dependency, and Institutionalization Theories (지식경영에 대한 제 접근 : 사회적 네트워크, 자원의존 및 제도화 이론을 중심으로)

  • Moon, Gyewan;Kim, Kiwhan;Choi, Sukbong
    • Knowledge Management Research
    • /
    • v.10 no.4
    • /
    • pp.43-60
    • /
    • 2009
  • The current study attempts to provide the field of knowledge management with theoretical grounds from the perspective of social network, resource dependency, and institutional theory. Social network theory considers that knowledge management plays a critical role in organizational innovation through the process of knowledge sharing/creation, communication systems, and a cooperative culture and trust, whereas resource dependency perceives knowledge management as contributing to cost reduction through the process of knowledge capture/storage, database systems, and reward/incentive systems. Plus, from the perspective of institutionalization, this study discusses that organizations can not benefit from knowledge management if it is adopted with the motive of isomorphic change. Finally, this study compares and integrates the three perspectives, and discusses the implications and limitations.

  • PDF

A Development of Central Policy Database for managing Heterogeneous Firewall Systems (이종의 침입 차단시스템 관리를 위한 중앙 정책 데이터베이스 개발)

  • Lee, Dong-Young;Chung, Tai-Myoung
    • The KIPS Transactions:PartD
    • /
    • v.9D no.6
    • /
    • pp.1063-1070
    • /
    • 2002
  • With a remarkable growth and expansion of Internet, the security issues emerged from intrusions and attacks such as computer viruses, denial of services and hackings to destroy information have been considered as serious threats for Internet and the private networks. To protect networks from intrusions and attacks, many vendors have developed various security systems such as firewalls and intrusion detection systems. However, managing these systems individually demands too much work and high cost. Thus, integrated and autonomous security management for various security products has become more important. In this paper, we present the architecture of the WISMSF (Web-based Integrated Security Management System for Firewalls) and the merits of centralized approach for managing heterogeneous firewalls and implement the prototype of the central policy database that is a component of the WISMSF engine. The WISMSF engine supports an integrated view for policies, the integrity of polities and the easy recovery and addition of policies. And also, we define the policy conflicts of WISMSF and present the policy recovery process to support to the policies consistence.

Development of Hydrologic Data Management System Based on Relational Database (관계형 데이터베이스를 이용한 수문자료 관리시스템 개발)

  • Kim, Hak-Kwan;Park, Seung-Woo;Kim, Sang-Min
    • Journal of Korea Water Resources Association
    • /
    • v.39 no.10 s.171
    • /
    • pp.855-866
    • /
    • 2006
  • In this paper, the Hydrologic Data Management System (HDMS) was developed for the efficient management of hydrologic data. The applicability of the system was demonstrated using the hydrologic data of study watershed located in the southwest from Suwon city MySQL 5.0, relational database management system, and MS Visual Basic 6.0 were used for the development of MS windows based HDMS. The primary components of the HDMS are data search system, data management system, and data analysis system. Data search and management systems provide basic functions for the efficient data search, storage, update and export. Data analysis system enables the users to get the further and diverse hydrologic statistical information from the stored data. Furthermore, the accuracy and quality of hydrologic data was analyzed and evaluated through data analysis system.

Development of the Quality of Service management program using the fourth generation language (제4세대 언어를 사용한 서비스품질 관리 프로그램의 개발)

  • 박순달;정호연;서정대;김태호
    • Korean Management Science Review
    • /
    • v.9 no.1
    • /
    • pp.41-52
    • /
    • 1992
  • The QOS(Quality of Service) recognized by the customer will become the most important thing under the competitive telecommunications market. Korea Telecom is going to develop many system to manage the telecommunication network, to improve the level of QOS, and to increase the revenue. Operation and Maintenance Adiministration System is one of the systems developed to meet those purposes efficiently. This system gathers qualities data from telephone offices or operation centers and analyze the results of QOS improvement activities and evaluate overall QOS. And also system makes it possible to improve the cost/effectiveness of operation and maintenance of telecommunication network. Operation and Maintenance Administration System has four functional modules, i.e., the user interface module, the database management module, the QOS management module, and the database conversion module. The purpose of this study is to develop the QOS management program, one of the four functional modules of the system,using FOCUS 4GL/DBMS. Since Operation and Maintenance Administration System is developed using FOCUS 4GL, every user can handle and maintain the system very easily and reduce system backlogs.

  • PDF

A Study on the DB Management System for Outage Management of Power System (전력계통설비 정지관리를 위한 DB관리 구축방안에 관한 연구)

  • Kim T. W.;Heo J. Y.;Kim C. W.;Lee S. W.;Kim J. C.;Lee G. Y.;Lee S. J.;Lee C. G.;Cho B. S.
    • Proceedings of the KIEE Conference
    • /
    • summer
    • /
    • pp.110-112
    • /
    • 2004
  • The outage management is very important because the outage causes a severe damage to the power system. Therefore, the utilities employ the outage management system, which is different from each others. This paper suggests the four kind of database systems for outage management. The efficiency of the outage management may be improved by using the suggested database system.

  • PDF