• Title/Summary/Keyword: Oracle Test

Search Result 22, Processing Time 0.033 seconds

Test Assertion Language for Unit Test : Design and Implementation (단위 테스트를 위한 테스트 어서션 언어 설계 및 도구 구현)

  • Shin, Woo-Chang
    • Journal of Information Technology Services
    • /
    • v.10 no.4
    • /
    • pp.205-218
    • /
    • 2011
  • Unit testing which is the first task to perform software testing has a major impact on reducing s/w development cost and improving s/w quality. In order to make unit testing become the formal procedure rather than ad-hoc tasks performed by developer, the language-neutral measures are necessary in the programming which is able to specify the test cases. This paper presents a test assertion language for the language-neutral specification of the test cases. The suggested language is based on the ISO/IEC 24709-1, but it supports object oriented features and can describe test cases for unit testing. The test cases that are specified by the language can be used for generating test oracle source codes by test oracle generation tools.

Implementation of Modification Performance Comparison of SQLite3 Mobile Databases (SQLite3 모바일 데이터베이스의 갱신 성능 비교 구현)

  • Choi, Jin-oh
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2018.10a
    • /
    • pp.108-110
    • /
    • 2018
  • In mobile IT device environments, it is becoming common to use database engine, and new mobile databases are continuously developed and announced. In this paper, the most common mobile database, SQLite3 is selected and experimented to test and understand the update performance and characteristics. The results of experiment are compared with the one of Oracle database at the same condition to evaluate the experiment.

  • PDF

Development of Options Trading System using KOSPI 200 Volatility Index (코스피 200 변동성지수를 이용한 옵션투자 정보시스템의 개발)

  • Kim, Sun Woong;Choi, Heung Sik;Oh, Jeong Hwan
    • Journal of Information Technology Services
    • /
    • v.13 no.2
    • /
    • pp.151-161
    • /
    • 2014
  • KOSPI 200 index options market has the highest trading volume in the global options markets. The risk and return structure of options contracts are very complex. Volatility complicates options trading because volatility plays a central role in options pricing process. This study develops a trading system for KOSPI 200 index options trading using KOSPI 200 volatility index. We design a database system to handle the complex options information such as price, volume, maturity, strike price, and volatility using Oracle DBMS. We then develop options trading strategies to test how the volatility index is related to the prices of complicated options trading strategies. Back test procedure is presented with PL/SQL of Oracle DBMS. We simulate the suggested trading system using historical data set of KOSPI 200 index options from December 2008 to April 2012.

Search Performance Experiments of SQLite Database on Linux Environments (Linux환경에서 SQLite 데이터베이스의 검색 성능 실험)

  • Kim, Soo-hwan;Choi, Jin-oh
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2016.10a
    • /
    • pp.445-447
    • /
    • 2016
  • SQLite, Realm, etc. are database engines which are suitable for small devices that have large resource restriction and are used a lot in mobile devices based on Linux. These engines are open source programs and have advantages which are lighter weight and faster speed than general purpose databases. This paper implements performance test program and performs performance experiment of SQLite database to test search efficiency in Linux environments. The experiment is processed by comparison with the results of a Oracle database working out at the same environment.

  • PDF

The Node Scheduling of Multi-Threaded Process for CC-NUMA System (CC-NUMA 시스템을 위한 다중 스레드 프로세스의 노드 스케줄링 설계 및 구현)

  • Kim, Jeong-Nyeo;Kim, Hae-Jin;Lee, Cheol-Hoon
    • The Transactions of the Korea Information Processing Society
    • /
    • v.7 no.2
    • /
    • pp.488-496
    • /
    • 2000
  • this paper describes the design and implementation of node scheduling for MX Server that is CC-NUMA System COMSIX, the operating system of MX Server, is designed to suit for CC-NUMA Architecture. MX Server consists of up to 8 nodes, and each node is connected by SCI ring. This node scheduling scheme considers data locality for performance improvement of Oracle8i DBMS on the CC-NUMA architecture. For DBMS such as Oracle8i, a multi-threaded process may be run to tie on particular disk. We have developed a CG binding function that the multi-threaded process bound the node. Currently, We don't have an available CC-NUMA Platform. Instead of MX Server, we developed the Node scheduling scheme for multi-threaded process to suit server platform on the PC test-bed and tested completely.

  • PDF

Turing's Cognitive Science: A Metamathematical Essay for His Centennial (튜링의 인지과학: 튜링 탄생 백주년을 기념하는 메타수학 에세이)

  • Hyun, Woo-Sik
    • Korean Journal of Cognitive Science
    • /
    • v.23 no.3
    • /
    • pp.367-388
    • /
    • 2012
  • The centennial of Alan Mathison Turing(23 June 1912 - 7 June 1954) is an appropriate occasion on which to assess his profound influence on the development of cognitive science. His contributions to and attitudes toward that field are discussed from the metamathematical perspective. This essay addresses (i)Turing's mathematical analysis of cognition, (ii)universal Turing machines, (iii)the limitations of universal Turing machines, (iv)oracle Turing machine beyond universal Turing machine, and (v)Turing test for cognitive science. Turing was a ground-breaker, eager to move on to new fields. He actually opened wider the scientific windows to the mind. The results show that first, by means of mathematical logic Turing discovered a new bridge between the mind and the physical world. Second, Turing gave a new formal analysis of operations of the mind. Third, Turing investigated oracle Turing machines and connectionist network machines as new models of minds beyond the limitations of his own universal machines. This paper explores why the cognitive scientist would be ever expecting a new Turing Test on the shoulder of Alan Turing.

  • PDF

Modification Performance Comparison of SQLite3 Mobile Databases (SQLite3 모바일 데이터베이스의 갱신 성능 비교)

  • Choi, Jin-oh
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.22 no.12
    • /
    • pp.1571-1576
    • /
    • 2018
  • Recently, the attractive changes of mobile device are a improvement of the computing performance, dramatic improvement of storage capacity, constant connection to the internet, and sophisticated development of display technology. As a result, database applications utilizing mobile devices are emerging. These applications include databases for mobile servers, databases for edge computing, and fog computing. Therefore, it is important to pay attention to the current mobile database and pay attention to whether it has suitable performance for the applications. In this paper, the most common mobile database, SQLite3 is selected and experimented to test and understand the update performance and characteristics. The results of experiment are compared with the one of Oracle database at the same condition to evaluate the experiment. As a result, Insert Performance of SQLite3 has a lot of points to be improved and Update performance is very good. Especially, the performance of Range Query is excellent.

Implementation and Experiment for Search Performance Analysis of SQLite Mobile Database (SQLite 모바일 데이터베이스의 검색 성능 분석을 위한 구현 및 실험)

  • Choi, Jin-oh
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.21 no.2
    • /
    • pp.333-338
    • /
    • 2017
  • Recently, because of the mobile device generalization tendency, a lot of new mobile applications which need mobile database on mobile devices appear. SQLite, Realm, etc. are representative mobile databases, and they are the database engines which are suitable for small devices that have large resource restriction and are used a lot in mobile devices based on Linux. These engines are open source programs and have advantages which are lighter weight and faster speed than general purpose databases. This paper focuses on the performance experiments and analysis of SQLite, which is front runner in mobile database fields. Considering the target mobile environments, the test is performed at Linux environment. And this paper implements performance test program and performs performance experiment of SQLite database to test search efficiency. The experiment is processed by comparison with the results of a Oracle database working out at the same environment.

An Integrated Approach to the GIS Data Reengineering for the New Korea Geodetic Datum (세계측지계 도입에 따른 공간데이터 재정비를 위한 통합모델 연구)

  • Lee Yang-Won;Park Key-Ho
    • Journal of the Korean Geographical Society
    • /
    • v.40 no.2 s.107
    • /
    • pp.153-171
    • /
    • 2005
  • The newly adopted Korea Geodetic Datum (a.k.a. KGD2002) calls for massive reengineering work on geospatial dataset. The main focus of our study is placed on the strategy and system implementations of the required data reengineering with a keen attention to integrated approaches to interoperability, standardization, and database utilization. Our reengineering strategy includes file-to-file, file-to-DB, DB-to-file, and DB-to-DB conversion for the coordinate transformation of KGD2002. In addition to the map formats of existing standards such as DXF and Shapefile, the newly recommended standards such as GML and SVG are also accommodated in our reengineering environment. These four types of standard format may be imported into and exported from spatial database via KGD2002 transformation component. The DB-to-DB conversion, in particular, includes not only intra-database conversion but also inter-database conversion between SDE/Oracle and Oracle Spatial. All these implementations were carried out in multiple computing environments: desktop and the Web. The feasibility test of our system shows that the coordinate differences between Bessel and GRS80 ellipsoid agree with the criteria presented in the existing researches.

Performance Evaluation of I/O Intensive Stress Test in Cluster File System SANiqueTM (집중적인 입출력 스트레스 테스트를 통한 클러스터 파일 시스템 SANiqueTM의 성능평가)

  • Lee, Kyu-Woong
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.14 no.2
    • /
    • pp.415-420
    • /
    • 2010
  • This paper describes the design overview of shared file system $SANique^{TM}$ and analyzes the performance evaluation results of I/O intensive stress test based on various cluster file system architectures. Especially, we illustrate the performance analysis for the comparison results between the $SANique^{TM}$ and the Linux file system EXT3 system that is used to generally in Unix world. In order to perform our evaluation, Oracle 10g database system is operated on the top of cluster file system, and we developed the various kinds of testing tools which are compiled by ESQL/C from Oracle. Three types of architectures are used in this performance evaluation. Those are the cluster file system $SANique^{TM}$, EXT3 and the combined architecture of $SANique^{TM}$ and EXT3. In this paper, we present that the results of $SANique^{TM}$ outperforms other cluster file systems in the overhead for providing the true sharing over the connecting server nodes.