• 제목/요약/키워드: SQL-database

검색결과 431건 처리시간 0.029초

EPC시스템에서 UI기반의 소프트웨어에 대한 고찰 (The study of EPC System S/W based on the UI)

  • 황성하;유선일;정진수
    • 시스템엔지니어링학술지
    • /
    • 제6권1호
    • /
    • pp.61-68
    • /
    • 2010
  • Generally EPC management system was simply management concept through the normal S/W. Our LNG Plant R&D Center wanted to the excellent management system from the S/W. So We developed the R&D management S/W and EPC management S/W Built in the Microsoft Project Server. Our system made to the customer Requirements. It was just User Interface protocol. But User Interface has more Weak position, because it makes from the MS Project Servers. Ms Projector server make easy to treat the project on the WBS. EPC parts mixed WBS and normally Ms SQL Database. It has very complicated Structures. Now We planed to make the general Database and Ms Project Server, It' means to the S/W Developer and Schedule Manager ability. We will successfully integrate R&D management system and EPC system and other softwares.

  • PDF

REMOTE NUMERICAL SIMULATIONS OF THE INTERACTION OF HIGH VELOCITY CLOUDS WITH RANDOM MAGNETIC FIELDS

  • Santikkan, Alfredo;Hernandez-Cervantes, Liliana;Gonzalez-Ponce, Alejandro;Kim, Jong-Soo
    • 천문학회지
    • /
    • 제40권4호
    • /
    • pp.165-169
    • /
    • 2007
  • The numerical simulations associated with the interaction of High Velocity Clouds (HVC) with the Magnetized Galactic Interstellar Medium (ISM) are a powerful tool to describe the evolution of the interaction of these objects in our Galaxy. In this work we present a new project referred to as Theoretical Virtual i Observatories. It is oriented toward to perform numerical simulations in real time through a Web page. This is a powerful astrophysical computational tool that consists of an intuitive graphical user interface (GUI) and a database produced by numerical calculations. In this Website the user can make use of the existing numerical simulations from the database or run a new simulation introducing initial conditions such as temperatures, densities, velocities, and magnetic field intensities for both the ISM and HVC. The prototype is programmed using Linux, Apache, MySQL, and PHP (LAMP), based on the open source philosophy. All simulations were performed with the MHD code ZEUS-3D, which solves the ideal MHD equations by finite differences on a fixed Eulerian mesh. Finally, we present typical results that can be obtained with this tool.

바다-$IV/I^2R$: 고차원 이미지 색인 구조를 이용한 효율적인 내용 기반 이미지 검색 시스템의 설계와 구현 (BADA-$IV/I^2R$: Design & Implementation of an Efficient Content-based Image Retrieval System using a High-Dimensional Image Index Structure)

  • 김영균;이장선;이훈순;김완석;김명준
    • 한국정보처리학회논문지
    • /
    • 제7권2S호
    • /
    • pp.678-691
    • /
    • 2000
  • A variety of multimedia applications require multimedia database management systems to manage multimedia data, such as text, image, and video, as well as t support content-based image or video retrieval. In this paper we design and implement a content-based image retrieval system, BADA-IV/I$^2$R(Image Information Retrieval), which is developed based on BADA-IV multimedia database management system. In this system image databases can be efficiently constructed and retrieved with the visual features, such as color, shape, and texture, of image. we extend SQL statements to define image query based on both annotations and visual features of image together. A high-dimensional index structure, called CIR-tree, is also employed in the system to provide an efficient access method to image databases. We show that BADA-IV/I$^2$R provides a flexible way to define query for image retrieval and retrieves image data fast and effectively: the effectiveness and performance of image retrieval are shown by BEP(Bull's Eye Performance) that is used to measure the retrieval effectiveness in MPEG-7 and comparing the performance of CIR-tree with those of X-tree and TV-tree, respectively.

  • PDF

NutriSyn(식품어휘지능망): 웹 기반 식품.음식 유의어 지식 구축 및 검색 서비스 구현 (NutriSyn: Knowledge Based Synonym Retrieval Service for Food and Dishes on the Web)

  • 홍순명;조지예;박유정;김민찬;김곤
    • 대한영양사협회학술지
    • /
    • 제15권3호
    • /
    • pp.286-297
    • /
    • 2009
  • Studies based on food analysis or food databases use the national standard food database. Although Internet information services are increasing gradually, users are only able to get definitive and profitable information using standard food terms. Until now, it has been uncommon to find food retrieval services that include users' regional or historical characteristics. Thus, this study introduces a prototype for Food and Dish Synonym Retrieval (NutriSyn) that includes synonyms and related words. The environments which NutriSyn was implemented were Linux for the server operating system, the Microsoft Windows series for the users' operating system and Apache for a web server. The development languages used are PHP, JavaScript and HTLM with a MySQL database. Users can access NutriSyn using Internet browsers. The main menu items are (1) Food Synonym DB, (2) Dish Synonym DB, (3) Food Information DB, (4) Dish Information DB, and (5) Food and Menu Synonym Retrieval. This system is expected to be a useful tool for food experts and interdisciplinary research.

  • PDF

농작물 재배 자동화를 위한 제어시스템 설계에 관한 연구 (A Study on Control system design for Automated Cultivation of product)

  • 조영석
    • 디지털산업정보학회논문지
    • /
    • 제10권1호
    • /
    • pp.55-60
    • /
    • 2014
  • Today, there is increasing the elderly population in rural community, and people of returning from the urban to the rural community are demand to be of high value-added agriculture. In this time, there are required to regularization, standardization, automation, for getting of production of high value crops. In this paper, we are study for automation cultivation control system design for produce high-value crops. this system were designed of two parts that one part is measure and control unit, another part is server part for database and server side control. the main controller for measurement and control is used MC9S08AW60, server for Database and server-side control was using MySQL with CentOS. The source code of control program was coding C and compile with GCC. the functions of measurement and control unit are digital input and output each 8channels and can be scan-able of 20 Bit with 2CH/Sec. Analog Output were designed that can be output of 4-20mA or 0-5V on 4channel. The Digital input and output part were designed 8-channel, and using the high speed photo coupler and relays. We showed that system is possible to measure a 20bit data width, 2Ch/sec as 8 channel analog signals.

SGS: Splicing Graph Server

  • Bollina, Durgaprasad;Lee, Bernett T.K.;Ranganathan, Shoba
    • 한국생물정보학회:학술대회논문집
    • /
    • 한국생물정보시스템생물학회 2005년도 BIOINFO 2005
    • /
    • pp.47-50
    • /
    • 2005
  • SGS (Splicing Graph Server) is as web application based on the MVC architecture with a Java platform. The specifications of the implemented design pattern are closely associated with the specific requirements of splicing graphs for analyzing alternative splice variants from a single gene. The paper presents the use of MVC architecture using JavaBeans as a model, with a JSP viewer and the servlet as the controller for this bioinformatics web application, with the open source apache/tomcat application server and a MySql database management system.

  • PDF

CPC (Collaborative Product Commerce) 개념의 설계 지원 시스템 개발 (Development of Design Supporting System considering CPC concept)

  • 반창우;장동영
    • 한국경영과학회:학술대회논문집
    • /
    • 대한산업공학회/한국경영과학회 2004년도 춘계공동학술대회 논문집
    • /
    • pp.39-43
    • /
    • 2004
  • A research shows that a new category of software, Collaborative Product Commerce (CPC), is now emerging, allowing discrete manufacturers to once again distinguish themselves on their products and innovations. CPC permits discrete manufacturers to significantly improve the core processes around the management functions associated with the complete product life cycle that are the basis of their existence. As a way to develop computing tools of CPC to support a design process of product, a web-based design supporting system was constructed in the paper. The system consists of C-Product system and Net Meeting Communication system to improve communications between designers and persons for verification of design. The product data files of C-Product system were designed by Pro/Engineer and converted to 3D Viewer format for being used in the web browser. Also, Net Meeting Communication system and Database were developed using ASP and Microsoft SQL 2000 Server to share diverse files that can be utilized to design on the web in real time.

  • PDF

IOT를 이용한 DB기반 농작물 자동재배에 관한 연구 (A Study on DB base Auto Cultivation of Crops Using IOT)

  • 조영석
    • 디지털산업정보학회논문지
    • /
    • 제13권4호
    • /
    • pp.25-31
    • /
    • 2017
  • In this paper, we propose a study on DB-based automatic crop cultivation that obtains crop cultivation data using IOT and automatically controls the cultivation environment using it. A system for DB-based automatic crop cultivation that automatically controls the cultivation environment is composed of a management server and a local controller. The management server was implemented using the MySQL DB in the Linux server system, and the local controller was designed and manufactured using the WiFi module and ARM Coretax-3 series MCU and confirmed its operation in the laboratory. The purpose of this study is to provide the optimal cultivation data and to grasp the cultivation status in real time when the knowledge of professional cultivation is needed like the farmers of ear farm villages. Research should continue to enable the cultivation of crops to reflect the requirements of each user.

변동성위험프리미엄을 이용한 일중변동성매도전략의 수익성에 관한 연구 (Profitability of Intra-day Short Volatility Strategy Using Volatility Risk Premium)

  • 김선웅;최흥식;배민근
    • 경영과학
    • /
    • 제27권3호
    • /
    • pp.33-41
    • /
    • 2010
  • A lot of researches find negative volatility risk premium in options market. We can make a trading profit by exploiting the negative volatility premium. This study proposes negative volatility risk premium hypotheses in the KOSPI 200 stock price index options market and empirically test the proposed hypotheses with intra-day short straddle strategy. This strategy sells both at-the-money call option and at-the-money put option at market open and exits the position at market close. Using MySQL 5.1, we create our database with 1 minute option price data of the KOSPI 200 index options from 2004 to 2009. Empirical results show that negative volatility risk premium exists in the KOSPI 200 stock price index options market. Furthermore, intra-day short straddle strategy consistently produces annual profits except one year.

Web기반 공구 Database의 구축과 최적 절삭조건의 결정

  • 이상욱;김영진
    • 한국경영과학회:학술대회논문집
    • /
    • 한국경영과학회/대한산업공학회 2003년도 춘계공동학술대회
    • /
    • pp.464-468
    • /
    • 2003
  • 인터넷의 급성장과 더욱 발전하는 On-line환경에 있어서 기업들간의 정보 교환이 실시간으로 이루어지고 있고, 서로 요구하는 정보의 양질이 높아져감에 따라 현 시점에서 데이터베이스의 관리 및 운용이 대우 중요한 요소가 되었다. 본 연구에서는 (주)대한증석과 경희대학교의 공동연구로 만들어진 KT-Guide라는 전자 카달로그를 Web상으로 구축하여, 피삭재의 절삭에 있어서 사용자가 원하는 가공형식, 공구 및 피삭재를 선택하고 적정 데이터의 입력 후에 최적절삭조건을 실시간으로 알아보고자 함을 목적으로 하고 있다. 이것은 사용자가 절삭을 사용함에 있어서 플랫폼에 제한없이 온라인환경에서 보조도구를 사용하게 하며 궁극적으로는 온라인 상으로 CAD/CAM시스템을 사용함을 목적으로 한다. 한편, 이 전의 연구에 있어서도 Web으로의 확장은 있었으나 많은 부분에 있어서 제한적이었다. DB의 관리에 있어서 MS SQL 2000으로의 Upgrade를 선택하였다. 또한, 프로그램 내부적으로는 기존의 대부분이 HTML Tag를 사용한 ASP형태였다면, 본 논문에 있어서 많은 부분이 XML로 전환되었음을 알 수 있다. 절삭조건의 최적화에는 뉴럴 네트워크를 적용하여 연구된 자료를 이용하였으며, Virtual Machining에 있어서 절삭 조건의 검색 및 Query부분은 XML을 이용하였다.

  • PDF