• Title/Summary/Keyword: 데이터베이스 data input

Search Result 247, Processing Time 0.031 seconds

Efficient Construction of Open Source-based Sewage Facility Database (오픈소스 기반의 하수 시설물 데이터베이스의 효율적 구축)

  • Ko, Jeongsang;Xu, Chunxu;Yun, Heecheon
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.40 no.5
    • /
    • pp.393-402
    • /
    • 2022
  • Effective data management of underground facilities is very important in terms of human life. For this, input of up-to-date and high-accuracy data should be preceded. Therefore, it is important to have an efficient data input method. In this study, by developing a sewage facility site survey program using open source software, paper drawings could be replaced with tablet PCs. By using a tablet PC, figures and property information acquired from the field are transmitted in real time through a database server. PostGIS query is developed to automate structured editing to minimize manual work in constructing a GIS (Geographic Information System) database for sewage facilities. did. In addition, the database was built using the sewage facility GIS database building program. As a result of comparing and analyzing the existing sewage facility database construction, work process, and work time, the work process was simplified and work time was shortened. In addition, through simple customization of open source software, it will be able to be used for field surveys and database construction in other fields.

Data Input and Output of Unstructured Data of Large Capacity (대용량 비정형 데이터 자료 입력 및 출력)

  • Sim, Kyu-Cheol;Kang, Byung-Jun;Kim, Kyung-Hwan;Jung, Hoe-Kyung
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2013.05a
    • /
    • pp.613-615
    • /
    • 2013
  • Request to provide a service to XML word file recently has been increasing. In this paper, it is converted to an XML file data input (HWP, MS-Office) a Word file, stored in a database by extracting data directly input to the word processor user creates an XML mapping file I to provide a system that. This can be retrieved from the database the required data to previously created forms word processor, to generate a Word file from the application program a word processing document.

  • PDF

Development of Materials Strength Database (재료강도특성(材料强度特性) 데이터베이스 구축(構築))

  • Kim, Ik-Cheol
    • Journal of Information Management
    • /
    • v.23 no.1
    • /
    • pp.1-21
    • /
    • 1992
  • The importance of factual database is becoming larger and larger as the application of computer in design and processing is increasing. To follow up and support this demand and tendency, construction of factual database is necessary. The goal of this research project is to construct a factual database about the creep properties of high temperature materials. A factual database on the creep properties of 25 kinds of high temperature materials was constructed. Domestically produced data which were appeared in journals, theses, reports, etc., were collected and used as a input data source. Evaluation on these collected data will be done during the 2nd year of this project. In addition to this database construction, an experimental facility to produce creep crack propagation data was set up.

  • PDF

Research of organized data extraction method for digital investigation in relational database system (데이터베이스 시스템에서 디지털 포렌식 조사를 위한 체계적인 데이터 추출 기법 연구)

  • Lee, Dong-Chan;Lee, Sang-Jin
    • Journal of the Korea Institute of Information Security & Cryptology
    • /
    • v.22 no.3
    • /
    • pp.565-573
    • /
    • 2012
  • To investigate the business corruption, the obtainments of the business data such as personnel, manufacture, accounting and distribution etc., is absolutely necessary. Futhermore, the investigator should have the systematic extraction solution from the business data of the enterprise database, because most company manage each business data through the distributed database system, In the general business environment, the database exists in the system with upper layer application and big size file server. Besides, original resource data which input by user are distributed and stored in one or more table following the normalized rule. The earlier researches of the database structure analysis mainly handled the table relation for database's optimization and visualization. But, in the point of the digital forensic, the data, itself analysis is more important than the table relation. This paper suggests the extraction technique from the table relation which already defined in the database. Moreover, by the systematic analysis process based on the domain knowledge, analyzes the original business data structure stored in the database and proposes the solution to extract table which is related incident.

A Transformation Military Databases based on the Relational Data model into XML Databases (관계형 데이터 모델 기반 군사용 데이터베이스의 XML 데이터베이스로의 변환)

  • Kim, Chang-Seok;Kim, Eong-Su
    • Journal of National Security and Military Science
    • /
    • s.1
    • /
    • pp.269-310
    • /
    • 2003
  • AS Extensible Markup Language(XML) is emerging as the data format of the Internet era, there are increasing needs to efficiently transform between database and XML documents. In this paper, we propose a schema transformation method from relational database to XML database. To transform the schema, we represent input schema as Entity-Relationship diagram. Entity-Relationship model translator scans the input Entity-Relationship diagram using BFS (breadth First Search) and translates the diagram into hierarchical structure model. The XML Schema generator produces XML Scema code using the transformed hierarchical structure model. The proposed method has a merit that having reusability facility of XML Schema property in comparison with existing researches.

  • PDF

On the Fuzzy Membership Function of Fuzzy Support Vector Machines for Pattern Classification of Time Series Data (퍼지서포트벡터기계의 시계열자료 패턴분류를 위한 퍼지소속 함수에 관한 연구)

  • Lee, Soo-Yong
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.17 no.6
    • /
    • pp.799-803
    • /
    • 2007
  • In this paper, we propose a new fuzzy membership function for FSVM(Fuzzy Support Vector Machines). We apply a fuzzy membership to each input point of SVM and reformulate SVM into fuzzy SVM (FSVM) such that different input points can make different contributions to the learning of decision surface. The proposed method enhances the SVM in reducing the effect of outliers and noises in data points. This paper compares classification and estimated performance of SVM, FSVM(1), and FSVM(2) model that are getting into the spotlight in time series prediction.

Graph Database Benchmarking Systems Supporting Diversity (다양성을 지원하는 그래프 데이터베이스 벤치마킹 시스템)

  • Choi, Do-Jin;Baek, Yeon-Hee;Lee, So-Min;Kim, Yun-A;Kim, Nam-Young;Choi, Jae-Young;Lee, Hyeon-Byeong;Lim, Jong-Tae;Bok, Kyoung-Soo;Song, Seok-Il;Yoo, Jae-Soo
    • The Journal of the Korea Contents Association
    • /
    • v.21 no.12
    • /
    • pp.84-94
    • /
    • 2021
  • Graph databases have been developed to efficiently store and query graph data composed of vertices and edges to express relationships between objects. Since the query types of graph database show very different characteristics from traditional NoSQL databases, benchmarking tools suitable for graph databases to verify the performance of the graph database are needed. In this paper, we propose an efficient graph database benchmarking system that supports diversity in graph inputs and queries. The proposed system utilizes OrientDB to conduct benchmarking for graph databases. In order to support the diversity of input graphs and query graphs, we use LDBC that is an existing graph data generation tool. We demonstrate the feasibility and effectiveness of the proposed scheme through analysis of benchmarking results. As a result of performance evaluation, it has been shown that the proposed system can generate customizable synthetic graph data, and benchmarking can be performed based on the generated graph data.

Design of GIS based Korean Reach File Supporting Water Quality Modeling (수질모델링 지원을 위한 GIS 기반 한국형 Reach File 설계)

  • Kwon, Moon-Jin;Kim, Kye-Hyun;Lee, Chol-Young
    • Journal of Korea Water Resources Association
    • /
    • v.45 no.1
    • /
    • pp.1-13
    • /
    • 2012
  • Various input data required for water quality modeling have considerable impacts on modeling results and relevant analysis due to the absence of data standardization and lack of data accuracy. With this in mind, this study mainly focused on the designing Korean Reach File for more effective water quality modeling through the supply of database composed with accurate hydraulic and hydrologic data. The Korean Reach File is the hydraulic database with the locational information of individual reaches, and each reach represents the stream reach of homogeneous hydraulic characteristics. In detail, it has reach code designating each stream reach, and topological information including catalog unit, segment, marker and index. It was also designed considering linkage of existing codes such as stream name and stream code. The devised reach code was implemented to Kyungan River at the City of Gwangju of Kyunggi Province and the results showed that the reach code could effectively support the input database integrating basic numerous data required for water quality modeling based on a criterion as well as easier linkage and utilization with existing database. In addition, more systematic water quality management was enabled through the linkage of existing data such as treatment facilities, pollutant data, and management institutes using the reach codes defined for each stream section. In the future, more efforts need to be made to adopt the reach code as the national standard data thereby enabling utilization of numerous relevant database through the assigning of reach code to individual stream reaches nationwide.

Spatial Partitioning for Query Result Size Estimation in Spatial Databases (공간 데이터베이스에서 질의 결과 크기 추정을 위한 공간 분할)

  • 황환규
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.41 no.2
    • /
    • pp.23-32
    • /
    • 2004
  • The query optimizer's important task while a query is invoked is to estimate the fraction of records in the databases that satisfy the given query condition. The query result size estimation in spatial databases, like relational databases, proceeds to partition the whole input into a small number of subsets called “buckets” and then estimate the fraction of the input in the buckets. The accuracy of estimation is determined by the difference between the real data counts and approximations in the buckets, and is dependent on how to partition the buckets. Existing techniques for spatial databases are equi-area and equi-count techniques, which are respectively analogous in relation databases to equi-height histogram that divides the input value range into buckets of equal size and equi-depth histogram that is equal to the number of records within each bucket. In this paper we propose a new partitioning technique that determines buckets according to the maximal difference of area which is defined as the product of data ranges End frequencies of input. In this new technique we consider both data values and frequencies of input data simultaneously, and thus achieve substantial improvements in accuracy over existing approaches. We present a detailed experimental study of the accuracy of query result size estimation comparing the proposed technique and the existing techniques using synthetic as well as real-life datasets. Experiments confirm that our proposed techniques offer better accuracy in query result size estimation than the existing techniques for space query size, bucket number, data number and data size.

Design of INM Input Generation Module for Aircraft Noise Analysis with Flight Procedures (비행 절차에 따른 항공기 소음 분석용 INM 입력 자료 생성 모듈 설계)

  • Choi, ChulHee;Eun, YeonJu;Jeon, DaeKeun;Jun, HyangSig
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2012.10a
    • /
    • pp.178-182
    • /
    • 2012
  • PEAT(Procedure/airspace Efficiency Assessment Tool) evaluates the efficiency of the flight procedures designed by Procedure and Airspace Design Program, such as fuel consumption fight time, flyability, noise footprint and etc. For noise footprint analysis among the efficiency metrics, the input generation module for INM(Integrated Noise Model) was designed in this research. The INM input files shall contain the information about aircraft types, noise model, airport and runway configuration, number of flights, flight routes, and also should be satisfied with the exact file formats for input data, since INM is not originally executable with file inputs. Therefore, it has been designed to convert the input data given in XML file to DBF. In this paper, the design result of the module which has functionalities to generate appropriate input file for INM, and to convert and save the analysis results from INM, is presented.

  • PDF