• 제목/요약/키워드: DB Design

검색결과 839건 처리시간 0.033초

Design of the Specific IP Access Deny for the Database (데이터베이스에서 지정된 IP 주소 접근 금지를 위한 기능 설계)

  • Jang, Seung-Ju;Kim, Sung-Jin
    • The Journal of Korean Institute of Communications and Information Sciences
    • /
    • 제39C권8호
    • /
    • pp.716-721
    • /
    • 2014
  • This paper proposes how to prevent of vulnerability from IP address attack of Oracle DB by C program environments. An attacker may try to login DB by connectng remote IP address. Recently an attacker use foreign IP address and try to connect to DB using known DB account. Therefore, DB data is frequently disclosed. I propose a new idea that develops specific IP address blocking module in C program in the Oracle DB. By this module, we can use the Oracle DB safely.

The Design and Implementation of Update Protocol for Spatial Data based on the Middleware : OLE DB (미들웨어 : OLE DB를 기반으로 한 공간 데이터 변경 프로토콜의 설계 및 구현)

  • 박정하;김동현;홍봉희
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 한국정보과학회 2000년도 봄 학술발표논문집 Vol.27 No.1 (B)
    • /
    • pp.45-47
    • /
    • 2000
  • 지리정보시스템 클라이언트는 Open API를 이용한 개방형((Open)구조를 지향하고 있으며 OpenGIS는 다양한 데이터 소스간의 상호운용을 지우 하는 개방형 지리정보시스템의 표준으로 자리를 잡아가고 있다. 따라서 기존의 패쇄환경(Closed Environment)에서 행해졌던 공간 데이터 동시 수정의 연구는 OLE DB와 같은 개방환경(Open Environment)에서 연구될 필요가 있다. 기존의 기법을 OLE DB에 적용할 때 문제점으로 제기되는 것은 첫째, 공간데이터 수정을 위한 변경 제어가 서버측에 위치함으로써 서버에 따라 재작성 되어야 하는 문제가 있고, 둘째, 서버의 데이터를 중복 저장하고 있는 클라이언트 데이터에 대한 일관성 유지를 위해 클라이언트의 변경 내용은 다른 클라이언트에게 통보되어야 하지만 OLE DB의 통보 메커니즘은 Rowset을 공유하는 동일 클라이언트 내에서의 통보만 가능한 구조이다. 본 논문은 공간데이터베이스 서버에 의존적인 서버부분의 기능을 미들웨어에서 구현함으로써 서버 모듈의 재작성 문제를 해결하고 서로 다른 클라이언트간의 변경 전파 프로토콜을 제시하여 서버와 독립적으로 운용할 수 있는 공간데이터 변경을 위한 OLE DB서비스 제공자 프로토콜을 설계하고 구현한 결과를 보인다.

  • PDF

An Implementation of DB Query Collecting and Analyzer Using Packet Interceptor (패킷 인터셉터를 이용한 DB 쿼리 수집 및 분석기 구현)

  • Lim, Jae-Deok;Lim, Sung-Han;Baek, Nam-Chul
    • The Journal of The Korea Institute of Intelligent Transport Systems
    • /
    • 제7권4호
    • /
    • pp.97-106
    • /
    • 2008
  • This proposed system is a part of internal control system that national highway need to support their ITS information audit. This paper explains the design and implementation of a packet interceptor and a DB query analyzer. The packet interceptor sniffs users' query packets, and then the DB query analyzer parses the SQL queries and stores the users' DB access information such as SQL queries, access data and changing data. The information may be used as the evidences on internal control of users and users' accesses.

  • PDF

Metadata Elements Design and Application for Japanese Newspaper 'Chosunsibo' Issued in Colonial Korea (일제강점기 일본어신문 『조선시보』의 메타데이터 요소 개발과 적용 연구)

  • Rho, Jee-Hyun
    • Journal of Korean Library and Information Science Society
    • /
    • 제50권4호
    • /
    • pp.137-158
    • /
    • 2019
  • This study aims to develop metadata elements and vocabularies of 'Chosunsibo' issued in Korea during the Japanese colonial era. Despite the vast amount and historical values, newspaper articles in Chosunsibo are still unsearchable and difficult to access. To the end, this study includes as follows: (1) analyzed the DB construction and metadata elements of newspapers issued in Korea during the Japanese colonial, (2) investigated the morphological characteristics and content of 'Chosunsibo', and (3) derived metadata elements, encoding schemes and controlled vocabularies for 'Chosunsibo'. The final draft was verified in three methods: (1) review and revise through data input tests, (2) consulting by a DB expert agency, and (3) drawing up of crosswalks with metadata standards and related cases. The scope of this study is to design the metadata schema of the historical newspaper 'Chosunsibo' and develop a data input system based on that schema.

Design and Implementation of a Benchmarking System Based on ArangoDB (ArangoDB기반 벤치마킹 시스템 설계 및 구현)

  • 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
    • /
    • 제21권9호
    • /
    • pp.198-208
    • /
    • 2021
  • ArangoDB is a NoSQL database system that has been popularly utilized in many applications for storing large amounts of data. In order to apply a new NoSQL database system such as ArangoDB, to real work environments we need a benchmarking system that can evaluate its performance. In this paper, we design and implement a ArangoDB based benchmarking system that measures a kernel level performance well as an application level performance. We partially modify YCSB to measure the performance of a NoSQL database system in the cluster environment. We also define three real-world workload types by analyzing the existing materials. We prove the feasibility of the proposed system through the benchmarking of three workload types. We derive available workloads in ArangoDB and show that performance at the kernel layer as well as the application layer can be visualized through benchmarking of three workload types. It is expected that applicability and risk reviews will be possible through benchmarking of this system in environments that need to transfer data from the existing database engine to ArangoDB.

Process design of superplastic forming/diffusion bonding by using pressure control (압력제어를 이용한 초소성 성형/확산접합의 공정설계)

  • Song, J.S.;Kang, K.Y.;Hong, S.S.;Kwon, Y.N.;Lee, J.H.;Kim, Y.H.
    • Proceedings of the Korean Society for Technology of Plasticity Conference
    • /
    • 한국소성가공학회 2007년도 춘계학술대회 논문집
    • /
    • pp.332-335
    • /
    • 2007
  • The superplastic forming (SPF) has been widely used in the automotive and aerospace industry because it has great advantages to produce very light and strong components. Finite element method (FEM) is used to model the process of superplastic forming/diffusion bonding (SPF/DB), to predict the pressure-time curve and to analyze the process parameter. In this study, process design of SPF/DB is carried out a 3-sheet sandwich part. SPF/DB process with pressure control was analyzed by using finite element method. For obtaining proper shape, step-by-step pressurization is proposed. The first step of SPD/DB process is obtained by applying of pressure in patches. From the next step it applied pressure to all regions (between inner sheets, between inner and face sheets). By using the proposed pressurization scheme, deficit in part shape is found to be eliminated.

  • PDF

Construction of web-based material DB and comparison of material properties using 3D graph (웹기반 재료 DB 구축 및 3D 그래프를 사용한 물성비교)

  • Chun D.M.;Ahn S.H.
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 한국정밀공학회 2005년도 춘계학술대회 논문집
    • /
    • pp.724-727
    • /
    • 2005
  • Material selection is one of the important activities in design and manufacturing. A selected material at the conceptual design stage affects material properties of the designed part as well as manufacturability and cost of the final product. Unfortunately there are not many accessible material databases that can be used for design. In this research, a web-based material database was constructed. In order to assist designers to compare different materials, two-dimensional and three-dimensional graphs were provided. Using these graphical tools, multi-dimensional comparison was available in more intuitive manner. To provide environmental safety of materials, the database included National Fire Protection Association publication Standard No.704. The web-based tool is available at http://fab.snu.ac.kr/matdb.

  • PDF

Process Design of Superplastic Forming/Diffusion Bonding by Using Design of Experiment (실험계획법을 이용한 초소성 성형/확산접합의 공정설계)

  • Song, J.S.;Kang, Y.K.;Hong, S.S.;Kwon, Y.N.;Lee, J.H.;Kim, Y.H.
    • Transactions of Materials Processing
    • /
    • 제16권2호
    • /
    • pp.144-149
    • /
    • 2007
  • The superplastic forming/diffusion bonding(SPF/DB) is widely used in the automotive and aerospace industry because it has great advantage to produce complex, light and strong parts. But the superplastic forming process requires much forming time and generates excessive thinning in the thickness distribution of formed part. It is necessary to minimize trial and error for SPF/DB Process. Finite element analysis using $L_{18}$ orthogonal may table of Taguchi method for 3-Sheet D/B process is carried out. Through the study, effect of process parameters, such as DH region size, thickness and friction coefficient, is evaluated and the optimum condition is derived.

Development of the Unified Database Design Methodology for Big Data Applications - based on MongoDB -

  • Lee, Junho;Joo, Kyungsoo
    • Journal of the Korea Society of Computer and Information
    • /
    • 제23권3호
    • /
    • pp.41-48
    • /
    • 2018
  • The recent sudden increase of big data has characteristics such as continuous generation of data, large amount, and unstructured format. The existing relational database technologies are inadequate to handle such big data due to the limited processing speed and the significant storage expansion cost. Current implemented solutions are mainly based on relational database that are no longer adapted to these data volume. NoSQL solutions allow us to consider new approaches for data warehousing, especially from the multidimensional data management point of view. In this paper, we develop and propose the integrated design methodology based on MongoDB for big data applications. The proposed methodology is more scalable than the existing methodology, so it is easy to handle big data.

Profit-oriented Impact Analysis of Demand Management Strategy on Design-Build Firms Using System Dynamics

  • Yoo, Wi-Sung
    • Journal of the Korea Institute of Building Construction
    • /
    • 제12권2호
    • /
    • pp.169-182
    • /
    • 2012
  • In the past, a strategic management of work demands has been increasingly challenged to design-build (DB) firms. Such a management is capable of providing sufficient profitable impact of a project on them. Total project profit is mainly related to actual resources, work completion time, amount of rework, and costs. The degree of recycling work packages in the DB project delivery system is used as a measure of the quality of the performed work. However, there are few models available to evaluate the impact of a demand management strategy on the DB firms and to predict its behavior. We propose a decision-making support model as an aid for assessing the amount of rework and for predicting project profit resulting in a convincible demand management strategy. This model is constructed by using a dynamic feedback approach that can analyze the problems arising in complex managerial systems. For the purpose of illustration, widely acceptable strategies were applied into the model to explore their impacts on the DB firms. The results indicate that the model is helpful for the managers in selecting the most appropriate demand management strategy for successfully achieving their objectives.