• Title/Summary/Keyword: database table

Search Result 304, Processing Time 0.027 seconds

Database Table Management and Input/output Design System on the Web (웹 기반 서버 데이터베이스 테이블 관리 및 입출력 형태 정의 시스템)

  • 한순희
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.3 no.2
    • /
    • pp.433-445
    • /
    • 1999
  • Today's Web tends to change from simple guideline to more complex information Provider based on large amount of data, enabling a better understanding of the objects. It provides various information retrieval techniques. Therefore, these data have to be stored and maintained in a database system for efficiency and consistency. But database system absolutely requires systematic and consistent management techniques. As a consequence, a high trained and well-educated person should do it. In this paper, we design and implement a tool for easy and reliable database table creation and management on the web. If users log in this system, they can get a list of tables created by themselves and will find a hyper link per each table. Futhermore, they can view and manage it's contents.

  • PDF

Design of an Intelligent Interlocking System Based on Automatically Generated Interlocking Table (자동생성되는 연동도표에 근거한 지능형 전자연동 시스템 설계)

  • Ko, Yun-Seok
    • The Transactions of the Korean Institute of Electrical Engineers D
    • /
    • v.51 no.3
    • /
    • pp.100-107
    • /
    • 2002
  • In this paper, we propose an expert system for electronic interlocking which enhances the safty, efficiency and expanability of the existing system by designing real-time interlocking control based on the interlocking table automatically generated using artificial intelligence approach. The expert system consists of two parts; an interlocking table generation part and a real-time interlocking control part. The former generates automatically the interlocking relationship of all possible routes by searching dynamically the station topology which is obtained from station database. On the other hand, the latter controls the status of station facilities in real-time by applying the generated interlocking relationship to the signal facilities such as signal devices, points, track circuits for a given route. The expert system is implemented in C language which is suitable to implement the interlocking table generation part using the dynamic memory allocation technique. Finally, the effectiveness of the expert system is proved by simulating for the typical station model.

Effective UML models by using database system

  • Halim, Faisal;Muttaqin, Rizal
    • Korean Journal of Artificial Intelligence
    • /
    • v.1 no.1
    • /
    • pp.1-3
    • /
    • 2013
  • This study suggested ways to control UML diagram and to make design of database and to retrieve diagram information by giving questions. The study classified elements of the diagram. For instance, class diagram was made of classes, and class was done of class name and attribute operator. The elements were transformed to be database table having basic key and foreign key information. The ways suggested had advantages of users' sharing of model information and reuse of the model. This study investigated cost saving, time saving and UML model construction by database. We had designed integrated and relation database that could save and manage UML diagram, and suggested retrieval. For instance, we classified class diagram into elements to make tables and kept relation of each element by using not only basic key of relation database but also foreign key information. We made database of modeling depending upon methods to give users convenience.

Data Extraction of Manufacturing Process for Data Mining (데이터 마이닝을 위한 생산공정 데이터 추출)

  • Park H.K.;Lee G.A.;Choi S.;Lee H.W.;Bae S.M.
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 2005.06a
    • /
    • pp.118-122
    • /
    • 2005
  • Data mining is the process of autonomously extracting useful information or knowledge from large data stores or sets. For analyzing data of manufacturing processes obtained from database using data mining, source data should be collected form production process and transformed to appropriate form. To extract those data from database, a computer program should be made for each database. This paper presents a program to extract easily data form database in industry. The advantage of this program is that user can extract data from all types of database and database table and interface with Teamcenter Manufacturing.

  • PDF

A Research on the Proposal and Application of Data Model for an Integrated System of Reinforced Concrete Structures (철근 콘크리트 구조설계 통합시스템을 위한 데이터베이스 모델 제시와 응용)

  • 정윤철;천진호;서용표;이병해
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 1998.10a
    • /
    • pp.342-351
    • /
    • 1998
  • The purpose of this study is to develop a central database and a database management system to store and manage information systematically from each module of an integrated structural design system. In order to efficiently express structural design process related to the data which is very complex, we used an object-oriented modeling methodology to propose the possibility to apply a database schema for application programs in an integrated system for reinforced concrete structural design. Based on this model, we developed an interface between each module and central database. After modeled by using object modeling technique, the database was mapped by the relational database table. Then the central database and the interface were programed by using Visual C/syo ++/, a windows environmental development tool.

  • PDF

Construction of a Spatial Database for Realizing Precision Farming (정밀농업 구현을 위한 공간 데이터베이스 구축)

  • 조성인;장영창;여운영
    • Journal of Biosystems Engineering
    • /
    • v.27 no.2
    • /
    • pp.161-172
    • /
    • 2002
  • Database as a supporting system for decision-making is one of essential parts for realizing precision farming. Application models on constructing a database for precision farming, including collection of spatial and attribute data, were suggested using a GPS, DXF files, AutoCAD, a Java application program and PostgreSQL DBMS in this study. The constructed spatial database based on the schema design of spatial and attribute data table was evaluated as a supporting system for decision-making by a simulation of a virtual variable-rate chemical applicator. The applicator could extract the values of soil property at its consecutive location in the tested field in communication with the constructed database, and prescribe the corresponding variable-rate of chemicals. The results of the study suggested the possibility that the constructed database can function a supporting system for decision-making for precision farming.

Evaluation of the Korean National Food Composition Tables

  • Park, Hong-Ju;Chun, Hye-Kyung;Lee, Sung-Hyeon
    • Preventive Nutrition and Food Science
    • /
    • v.9 no.2
    • /
    • pp.190-193
    • /
    • 2004
  • This review was conducted to evaluate the 'Korean Food Composition Table' and establish it as an internationally accepted database by examining its contents and evolution over time. The food composition table has been published by National Rural Living Science Institute, every 5 years, listing the nutrient content for each food, as both the raw agricultural product and processed foods, since the 1$^{st}$ edition in 1979 by RDA (Rural Development Administration). This is the basic data applied to the evaluation of the nutritional value of foods in Korea. The data is used as a useful tool in many fields, not only for the establishment of the National Food Supply Plan but also for nutritional research, the draft of National Food Policy, and in clinical and epidemiological research. The database is also utilized by food service providers and food processors, etc. Consumers and the international society have been interested in the quality and safety of foods and raw agricultural products. As these data expand in volume, the type of foods included in the composition table is expanded to cover new additions for the convenience of users of the 'Nutrient Data Base' as judged by the publishers. The form of these reports varies, according to the current information, from a simple booklet to CD-ROM and to the Web service. We expect to continue to make improvements in the National Standard Table for food composition through expanding both the quantity and quality of data in an orderly manner. This effort can help food composition data to be comprehensively developed systematically and gradually at the national level.l.

New Database Table Design Program of Real Time Network for High Speed Train

  • Cho, Chang-Hee;Park, Min-Kook;Kwon, Soon-Man;Kim, Yong-Ju;Kim, Sung-Shin
    • 제어로봇시스템학회:학술대회논문집
    • /
    • 2003.10a
    • /
    • pp.2164-2168
    • /
    • 2003
  • Real time control system such as in factory automation fields, defense field, aerospace, railway industries, financial trading and so forth, includes multiple computers on multiple nodes, and share data to process various actions and functions. This is similar to multitasking in a multiprocessor computer system. The task processing efficiency of such system is proportionally increased by process speed of each process computer. And also it is greatly influenced by communication latencies of each node. To provide proper operation of such real time system, a network that can guarantee deterministic exchange of certain amount of data within a limited time is required. Such network is called as a real time network. As for modern distributed control system, the timeliness of data exchange gives important factor for the dynamics of entire control system. In a real time network system, exchanged data are determined by off-line design process to provide the timeliness of data. In other word, designer of network makes up a network data table that describes the specification of data exchanged between control equipments. And by this off-line design result, the network data are exchanged by predetermined schedule. First, this paper explains international standard real time network TCN (Train Communication Network) applied to the KHST (Korean High Speed Train) project. And then it explains the computer program developed for design tool of network data table of TCN.

  • PDF

Implementation of SGML Basic Parser (SGML(Standardized Genernal Markup Language)에 대한 기본 파서의 구현)

  • 홍은선;정회경;이수연
    • The Journal of Korean Institute of Communications and Information Sciences
    • /
    • v.17 no.5
    • /
    • pp.495-508
    • /
    • 1992
  • This paper describes on implementation of SGML(Standardized General Markup Language )parser, which can analize SGML documents and its DTD(Document Type Deflnitton) defined according to the SGML( ISO 8879) .We have constructed a yacc definition file to present the rules of SGML DTD and documents, by which incoming SGML DTD and documents can be parsed Into the appropriate tokens. with the tokens a database with the stuctures such as entity table, element table and so on is built to vali-date the logical structure of the inconung SGML documents. The additional functions of this parser Include the automatic transforminng of the incoming documents with the short references into the complete SGML documents. Several test SGML documents have tested to clarify an implementation of this parser and experimental results are satisfactory.

  • PDF

A Train Ticket Reservation Aid System Using Automated Call Routing Technology Based on Speech Recognition (음성인식을 이용한 자동 호 분류 철도 예약 시스템)

  • Shim Yu-Jin;Kim Jae-In;Koo Myung-Wan
    • MALSORI
    • /
    • no.52
    • /
    • pp.161-169
    • /
    • 2004
  • This paper describes the automated call routing for train ticket reservation aid system based on speech recognition. We focus on the task of automatically routing telephone calls based on user's fluently spoken response instead of touch tone menus in an interactive voice response system. Vector-based call routing algorithm is investigated and mapping table for key term is suggested. Korail database collected by KT is used for call routing experiment. We evaluate call-classification experiments for transcribed text from Korail database. In case of small training data, an average call routing error reduction rate of 14% is observed when mapping table is used.

  • PDF