• Title/Summary/Keyword: SQL-based

Search Result 410, Processing Time 0.021 seconds

An Ontology-Based GIS for Genomic Data Management of Rumen Microbes

  • Jelokhani-Niaraki, Saber;Tahmoorespur, Mojtaba;Minuchehr, Zarrin;Nassiri, Mohammad Reza
    • Genomics & Informatics
    • /
    • v.13 no.1
    • /
    • pp.7-14
    • /
    • 2015
  • During recent years, there has been exponential growth in biological information. With the emergence of large datasets in biology, life scientists are encountering bottlenecks in handling the biological data. This study presents an integrated geographic information system (GIS)-ontology application for handling microbial genome data. The application uses a linear referencing technique as one of the GIS functionalities to represent genes as linear events on the genome layer, where users can define/change the attributes of genes in an event table and interactively see the gene events on a genome layer. Our application adopted ontology to portray and store genomic data in a semantic framework, which facilitates data-sharing among biology domains, applications, and experts. The application was developed in two steps. In the first step, the genome annotated data were prepared and stored in a MySQL database. The second step involved the connection of the database to both ArcGIS and $Prot{\acute{e}}g{\acute{e}}$ as the GIS engine and ontology platform, respectively. We have designed this application specifically to manage the genome-annotated data of rumen microbial populations. Such a GIS-ontology application offers powerful capabilities for visualizing, managing, reusing, sharing, and querying genome-related data.

On supporting full-text retrievals in XML query

  • Hong, Dong-Kweon
    • International Journal of Fuzzy Logic and Intelligent Systems
    • /
    • v.7 no.4
    • /
    • pp.274-278
    • /
    • 2007
  • As XML becomes the standard of digital data exchange format we need to manage a lot of XML data effectively. Unlike tables in relational model XML documents are not structural. That makes it difficult to store XML documents as tables in relational model. To solve these problems there have been significant researches in relational database systems. There are two kinds of approaches: 1) One way is to decompose XML documents so that elements of XML match fields of relational tables. 2) The other one stores a whole XML document as a field of relational table. In this paper we adopted the second approach to store XML documents because sometimes it is not easy for us to decompose XML documents and in some cases their element order in documents are very meaningful. We suggest an efficient table schema to store only inverted index as tables to retrieve required data from XML data fields of relational tables and shows SQL translations that correspond to XML full-text retrievals. The functionalities of XML retrieval are based on the W3C XQuery which includes full-text retrievals. In this paper we show the superiority of our method by comparing the performances in terms of a response time and a space to store inverted index. Experiments show our approach uses less space and shows faster response times.

Java Method Technique for the Integration of Web and Object-Relational Database System (웹과 객체-관계 데이터베이스 시스템 연동을 위한 Java 메소드 기법)

  • 윤현진;용환승
    • Journal of Korea Multimedia Society
    • /
    • v.1 no.2
    • /
    • pp.142-153
    • /
    • 1998
  • In this paper, Java Method approach for the integration of Web and Object-Relational DBMS is proposed. For the purpose, we extend to use Java language in programming user-defined function which is one of important characteristic of Object-Relational DBMS with object concept. Therefore we can retrieve not only database objects but also their associated Java methods to run in clients. Finally, to demonstrate the feasibility of the proposed Java Method technique, we designed and implemented this Java method system based on three-tier client/server architecture using JDBC(Java Database Connectivity) and Java RMI(Remote Method Invocation).

  • PDF

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

  • Hwang, Seong Ha;Yoo, Sun Il;Jeong, Jin Su
    • Journal of the Korean Society of Systems Engineering
    • /
    • v.6 no.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

Design and Implementation of A Brokering System for Ships and Cargos (선박과 화물에 대한 중개 시스템의 설계 및 구현)

  • Seo Sang-Koo;Yoon Kyung-Hyun
    • Journal of Information Technology Applications and Management
    • /
    • v.12 no.1
    • /
    • pp.49-68
    • /
    • 2005
  • It is one of the crucial components of electronic logistics systems to manage logistics information of cargos and transportation companies and to mediate appropriate brokerage between them. Due to the advance of e-Commerce technologies many kinds of logistics transactions can be handled by means of EDI or XML/EDI applications. but the brokering processing relies mostly on the traditional processes and the research in this field is still at the initial stage. In this paper we study a logistics brokering system for ships and cargos and describe the design and implementation of the system. We analyze the brokering constraints for logistics of cargos and ships and construct an optimization model for their brokering. We also suggest a brokering procedure and a simple heuristic algorithm with respect to the proposed matching criteria. The experimental result shows that the proposed greedy-based heuristic algorithm performs very well. In its response time the proposed algorithm executed within a couple of seconds independently of the number of cargos and the container capacities of ships. The output of the algorithm is very close to that of the optimal solution. showing higher than 95% of approximation. The proposed system is implemented for the Web environment using JSP and PL/SQL.

  • PDF

The Development of a System for Product Search Using a Sensibility and Configuration Database on Designing Men's Jackets (신사복 재킷디자인의 감성 및 형상 데이터베이스를 이용한 제품검색 시스템 개발에 관한 연구)

  • Park, Yun-A
    • Journal of the Korean Home Economics Association
    • /
    • v.44 no.4 s.218
    • /
    • pp.133-144
    • /
    • 2006
  • The contemporary period is called "the age of sensibility" in which each individual consumer seeks to have her or his own products. Businesses are in need of design developments with an emphasis on customer sensitivity, and at the same time consumers must understand their own sensitivity to acquire information on designs that suit them. This research established a sensitivity and configuration database on designing men's jackets using the sensitivity engineering approach to clothing design information. The user interface was created on the Internet. Sixty-seven sensitivity terms of vocabulary appropriate for the assessment of men's jacket design were selected, and the different designs were classified into six items and 24 categories. Thirty men's jackets with different designs were produced for sensory testing and the results were analyzed in accordance with general linear I statistics. A sensitivity database was established for each category. My-sql, PHP, Java Script, and Html were used for the configuration database work. The configuration of items/categories, with the most appropriate sensitivity database information assigned to the selected sensitivity vocabulary, was programmed for display on the computer screen. The sensitivity vocabulary of a customer's choice for each factor was selected for the program to run, while the category and product configuration of the men's jacket most suitable for the search was displayed based on the user interface.

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
    • Journal of The Korean Astronomical Society
    • /
    • v.40 no.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.

A Study of classification the predicate in "Biwiron(脾胃論)" (비위론에 기재된 술어의 분류에 관한 연구)

  • Kim, Myung-Hee;Lee, Byung-Wook;Kim, Eun-Ha
    • Journal of Korean Medical classics
    • /
    • v.23 no.1
    • /
    • pp.163-186
    • /
    • 2010
  • Objective and Background : Attempt to express knowledge by IT is the current of the times, knowledge of the oriental medicine have to meet the needs of the times. It takes 'classification system of the oriental medicine terms' and 'system of the predicate' for explaining the relation between concepts to express knowledge by IT technique. Researches for 'classification system of the oriental medicine terms' are in progress already, researches for 'system of the predicate' are insufficient. Subject of study : We proceeded to study of the predicate in Idongwon(李東垣)'s "Biwiron(脾胃論)" has clear theory system and considerable influence upon knowledge of the oriental medicine for studying 'system of the predicate' which expresses knowledge of the oriental medicine in early stage. Method : Acquire Chinese play a predicate part in "Biwiron(脾胃論)", translate the Chinese to answer the context, group the similar predicate, decide representative predicate of group. And attempt to make classification system of the representative predicate with Term management system based on SQL Server 2005. Results and Considerations : I classify the predicate which predicate diagnosis, treatment, symptoms and knowledge of the oriental medicine into existence, condition, cognition and will. This classification seems to be useful to explain factors which have an effect on demonstration and treatment.

Design of Efficient Query Language to support Local information administration environment (지역정보 관리 환경을 지원하기 위한 효율적인 질의 언어의 설계)

  • Kang, Sung-Kwan;Rhee, Phill-Kyu
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2008.06c
    • /
    • pp.36-40
    • /
    • 2008
  • SIMS manages data for various spatial and non-spatial as integral management system to support space information administration environment and support several application works. Without being limited to spatial data that existent spatial Data Mining question language advances handling in this paper, did so that can find useful information from various data connected with automatically data collection, artificial satellite side upside service, remote sensing, GPS. Mobile Computing and data about Spatio-Temporal. Also, we designed spatial Data Mining query language that support a spatial Data Mining exclusive use system based on SIMS.

  • PDF

A Vehicle Management System based on a Moving Object Query Language (이동 객체 질의어 기반 차량 관리 시스템)

  • Jung Young-Jin;Choi Hyun-Mi;Tung Hoang Do Thanh;Ryu Keun-Ho
    • 한국공간정보시스템학회:학술대회논문집
    • /
    • 2004.12a
    • /
    • pp.91-97
    • /
    • 2004
  • GPS 및 무선 통신 기술의 발달과 무선기기의 소형화, 고속 네트워크 구축 등에 힘입어 휴대전화 사용 고객이나 차량의 위치 추적이 용이해지고 있다. 이로 인해 차량 및 고객이 변화하는 위치에 따라 적절한 서비스를 제공하는 위치 기반 서비스가 활발히 연구되고 있으며, 원활한 교통 소통 및 물류 수송을 위해 차량의 위치 정보를 적절히 활용, 관리하는 차량 추적 및 관리 시스템이 개발되고 있다. 그러나 개발된 차량 관리 시스템들은 각 시스템마다 서로 다른 차량 위치 데이터 저장 구조 및 질의 처리 방식과 색인 기법 등을 활용하기 때문에, 시스템간의 호환 및 정보 교환 등에 어려움을 갖고 있다. 따라서 이 논문에서는 차량 관리 시스템간의 정보 교환 및 차량의 위치 및 궤적 데이터의 효과적인 질의를 지원하기 위한 이동 객체질의어를 설계하고, 이를 지원하는 차량 관리 시스템을 구현한다. 제시된 이동 객체 질의어는 SQL를 기반으로 물류 관리 시스템에서 특정 구간 사이의 궤적, 특정 지점에서의 출발 렌 도착 시간 및 불확실한 위치 추정 등과 같은 차량의 이동에 대한 정보를 얻기 위해 지원된다. 그리고, 물류 차량 관리를 포함한 다양한 이동 객체 관리 시스템에서 이러한 이동 객체 질의어와 같은 어떤 표준화된 질의어를 지원할 경우, 서로 간의 정보 활용에 많은 도움을 줄 수 있다.

  • PDF