• Title/Summary/Keyword: Database management

Search Result 3,884, Processing Time 0.032 seconds

Database Modeling for Environmental Product Life Cycle Management (환경영향을 고려한 제품 전 주기 관리 데이터 모델링)

  • 황오현;강무진
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 2001.04a
    • /
    • pp.358-362
    • /
    • 2001
  • Environmental Product Life Cycle Management is an activity for defining and describing the product, process of activity environmentally. The activity involves the full life cycle stages of the product; evaluating environmental releases at each stage, determining the aggregate and specific impacts of the releases, developing opportunities to effect environmental improvements. This paper presents a methodological approach for database modeling to build Product Life Cycle Management system and show a set of database modeling. Additionally, a key issue for database is the quality of the provided information.

  • PDF

CONSTRUCTION OF TEST SERVERS FOR KMTNet DATA MANAGEMENT (KMTNet 시험운영 서버 구축)

  • Kim, D.J.;Lee, C.U.;Kim, S.L.
    • Publications of The Korean Astronomical Society
    • /
    • v.26 no.4
    • /
    • pp.159-168
    • /
    • 2011
  • We constructed two test server systems for KMTNet data management. One is the photometry database server which is optimized for stable operation, and the other is the photometric data process server which is optimized for fast I/O between devices. The performances of servers and data storage units were tested using various methods. Database upload was also checked using five different methods. From tests, we concluded that the most efficient method to upload photometric data processing results to database is the use of three nodes with job scheduler under the InnoDB engine. In this study we provide the test results for prototype servers for KMTNet data management.

Development of Expert Systems based on Dynamic Knowledge Map and DBMS (동적지식도와 데이터베이스관리시스템 기반의 전문가시스템 개발)

  • Jin Sung, Kim
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 2004.10a
    • /
    • pp.568-571
    • /
    • 2004
  • In this study, we propose an efficient expert system (ES) construction mechanism by using dynamic knowledge map (DKM) and database management systems (DBMS). Generally, traditional ES and ES developing tools has some limitations such as, 1) a lot of time to extend the knowledge base (KB), 2) too difficult to change the inference path, 3) inflexible use of inference functions and operators. First, to overcome these limitations, we use DKM in extracting the complex relationships and causal rules from human expert and other knowledge resources. Then, elation database (RDB) and its management systems will help to transform the relationships from diagram to relational table. Therefore, our mechanism can help the ES or KBS (Knowledge-Based Systems) developers in several ways efficiently. In the experiment section, we used medical data to show the efficiency of our mechanism. Experimental results with various disease show that the mechanism is superior in terms of extension ability and flexible inference.

  • PDF

Test Database Management Program Development of Hanvit 350 (한국형 고속열차 시운전시험데이터 통합관리 프로그램 개발)

  • Lee, Tae-Hyung;Park, Choon-Soo;Choi, Seong-Hoon
    • Proceedings of the KSR Conference
    • /
    • 2007.11a
    • /
    • pp.1586-1589
    • /
    • 2007
  • A prototype high-speed train system, Hanvit-350, has been developed in Korea since 1996. The train has reached the maximum speed of 352.4km/h during a test run on December 2004. It is presently undergoing various tests to stabilize its performance and to secure reliability. Until now, around 420 runs have been conducted and accumulates 190,000km trial run. The test database management program is developed using existing analysis program, LabVIEW and database program, Microsoft-SQL. The test database management program is used to analysis of test results and will be used to find out the correlation characteristics between parameters.

  • PDF

DESIGN AND IMPLEMENTATION OF MULTIMEDIA MATADATA MANAGEMENT SYSTEM FOR HETEROGENOUS SOURCES

  • Park, Seong-Kyu;Lee, Yang-Koo;Chai, Duck-Jin;Kim, Hi-Seok;Ryu, Keun-Ho
    • Proceedings of the KSRS Conference
    • /
    • 2008.10a
    • /
    • pp.398-401
    • /
    • 2008
  • With the advance of internet and computer processing technique, users can easily access and use the multimedia contents involving the various pictures, videos and audios information. And users request more convenient and accurate multimedia services. In these environments, it is difficulties to integrate and manage metadata standards because there are various standards in multimedia applications according to types of services and data formats individually. In this paper, we design and implement the multimedia metadata management system for integrating from heterogeneous sources. In our system, we managed heterogeneous metadata by integrating to unified schema using mapping table. Through proposed system, users can search multimedia data easily without considering variety of application services.

  • PDF

Designing Components for mapping from XML DTD to ORDB Schema (XML DTD의 객체-관계형 데이터베이스 스키마로의 변환을 위한 Component 설계)

  • 이정수;주경수
    • Journal of Information Technology Applications and Management
    • /
    • v.9 no.1
    • /
    • pp.71-84
    • /
    • 2002
  • As the application area of XML extends to the database from simple contents, the technology for the storage and management of XML also grows with the XML. One of the main issues is how to efficiently manage the XML by using the previous DBMS. Many studies have been performed for the efficient management based on the XML application and database interface. However, the XML data is based on the object and has the hierarchical structure. Accorkingly, a modeling plan needs to store the XML data on the variety type of database. In this paper, for easier connection between XML application and database system, we have designed components for the transformation from XML DTD to ORDB schema. The method of the design for the transformation from XML DTD to ORDB schema is chosen the method of CBD.

  • PDF

The Status Quo of Graph Databases in Construction Research

  • Jeon, Kahyun;Lee, Ghang
    • International conference on construction engineering and project management
    • /
    • 2022.06a
    • /
    • pp.800-807
    • /
    • 2022
  • This study aims to review the use of graph databases in construction research. Based on the diagnosis of the current research status, a future research direction is proposed. The use of graph databases in construction research has been increasing because of the efficiency in expressing complex relations between entities in construction big data. However, no study has been conducted to review systematically the status quo of graph databases. This study analyzes 42 papers in total that deployed a graph model and graph database in construction research, both quantitatively and qualitatively. A keyword analysis, topic modeling, and qualitative content analysis were conducted. The review identified the research topics, types of data sources that compose a graph, and the graph database application methods and algorithms. Although the current research is still in a nascent stage, the graph database research has great potential to develop into an advanced stage, fused with artificial intelligence (AI) in the future, based on the active usage trends this study revealed.

  • PDF

Datamodel for Productivity Management of Construction Project (건설공사 생산성 관리를 위한 데이터모델)

  • Ryu Han-Guk;Yu Jung-Ho;Lee Hyun-Soo
    • Proceedings of the Korean Institute Of Construction Engineering and Management
    • /
    • autumn
    • /
    • pp.442-445
    • /
    • 2002
  • Construction delay claim occurs more often than any other claim. Delay claim impacts adversely the company's existence as well as the project's monetary problem. Because the calculation of the delay is not quantitative, owing not to have enough evidence, it is hard to solve evenly the delay claim. So, it is need to cumulate structurely the construction data or evidence during the construction. This study considers the established study about construction delay claim database and the problems and then presents the relation method between phase schedule and database. Finally, this study established the productivity claim database modeling for construction project through conceptual database modeling and logical database modeling based on information needed to make construction productivity database. So. the purpose of the study is to establish the datamodel for productivity management of construction project for calculating the delay days considering the lost productivity.

  • PDF

A Database Model for Financial Feasibility Study of Buildings Offered for Sale (분양형 건축물의 재무적 타당성검토를 위한 데이터베이스 모델)

  • Oh Hyun-Suk;Jung Jae-Gwan;Koo Kyo-Jin;Hyun Chang-Taek
    • Proceedings of the Korean Institute Of Construction Engineering and Management
    • /
    • autumn
    • /
    • pp.577-580
    • /
    • 2003
  • The purpose of this study was to make a database model for financial feasibility study of buildings offered for sale which is helpful for improvement of business ability in construction and confidence of a project from a related participant. At first, we studied several thesis and met some professionalist which work for construction and did a first survey for examining latest situation of a feasibility study in construction. As a result, even though feasibility study is important, factors for information management wasn't systemized. So we did a second survey for fixing Factors of the database model. The database model was composed of the factors that we got from the second survey. ER(Entity-Relationship) analysis was used to making it. We expect thar we can get more reasonable information to study financial feasibility study and can diminish risks of project through the database model. So the result of this study was to make a database model for more reasonable financial feasibility study of building offered for sale.

  • PDF

Directions for Developing Database Schema of Records in Archives Management Systems (영구기록물관리를 위한 기록물 데이터베이스 스키마 개발 방향)

  • Yim, Jin-Hee;Lee, Dae-Wook;Kim, Eun-Sil;Kim, Ik-Han
    • The Korean Journal of Archival Studies
    • /
    • no.34
    • /
    • pp.57-105
    • /
    • 2012
  • The CAMS(Central Archives Management System) of NAK(National Archives of Korea) is an important system which receives and manages large amount of electronic records annually from 2015. From the point of view in database design, this paper analyzes the database schema of CAMS and discusses the direction of overall improvement of the CAMS. Firstly this research analyzes the tables for records and folders in the CAMS database which are core tables for the electronic records management. As a result, researchers notice that it is difficult to trust the quality of the records in the CAMS, because two core tables are entirely not normalized and have many columns whose roles are unknown. Secondly, this study suggests directions of normalization for the tables for records and folders in the CAMS database like followings: First, redistributing the columns into proper tables to reduce the duplication. Second, separating the columns about the classification scheme into separate tables. Third, separating the columns about the records types and sorts into separate tables. Lastly, separating metadata information related to the acquisition, takeover and preservation into separate tables. Thirdly, this paper suggests considerations to design and manage the database schema in each phase of archival management. In the ingest phase, the system should be able to process large amount of records as batch jobs in time annually. In the preservation phase, the system should be able to keep the management histories in the CAMS as audit trails including the reclassification, revaluation, and preservation activities related to the records. In the access phase, the descriptive metadata sets for the access should be selected and confirmed in various ways. Lastly, this research also shows the prototype of conceptual database schema for the CAMS which fulfills the metadata standards for records.