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

검색결과 410건 처리시간 0.023초

Design and Implementation of Learning And Testing System using Animation Technique based on Web (웹기반에서 애니메이션 기법을 이용한 학습평가 시스템 설계 및 구현)

  • 원미해;김창수;정신일
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • 제5권2호
    • /
    • pp.269-278
    • /
    • 2001
  • Most of education sites which are related to practical computer lecture are almost learning and testing based on character-contents. In this thesis, commercial high school needs the use of new application programs which appear quickly. So as teacher and students can contact with each other in classroom, we implemented self-teaming which has text, visual and auditory function with the use of animation technology. Not only quantity testing which has been used for the purpose of selection and arrangement, but also we designed and implemented quality testing which consider the level and individuality of student.

  • PDF

A Study of PKI-Based E-commerce Security System Design under Java Code Environment (Java Code를 중심으로한 PKI기반 전자상거래 보안시스템 설계)

  • Bang, Kee-Chun;Noh, Si Choon
    • Convergence Security Journal
    • /
    • 제13권1호
    • /
    • pp.51-57
    • /
    • 2013
  • RSA is the most widely used public key algorithms. Payment via the SSL communications, and user authentication using RSA secure shopping mall that can protect the user's valuable information in the process of building. SSL-based electronic signature technology and encryption protocols for this technology are electronic documents are delivered to the other party through a separate encryption process, the information sender to enter information on a web browser (user) and the recipient (the Web server of the site Manager), except you will not be able to decrypt the contents. Therefore, the information is encrypted during the transfer of electronic documents even if hackers trying to Sniffing because its contents can never understand. Of internet shopping mall in the user authentication 'and' Communications' SSL secure shopping mall built with the goal of the methodology are presented.

Design and Implementation of a Service Platform that Recommends the Optimal Shortest Distance as a Patrol Route

  • Jo, Yu-min;Jang, Ye-jin;Paik, Jong-ho
    • Journal of Internet Computing and Services
    • /
    • 제23권1호
    • /
    • pp.1-9
    • /
    • 2022
  • Recently, interest in living safety and crime prevention is increasing. The reality is that most women have anxiety about social safety and ultimately want a safe return to home. As a result of these issues, the Seoul Metropolitan Government and the National Police Agency are implementing various services to alleviate them. However, there are limitations such as that the service can be used only during a limited time or the process of checking whether the patrol is really completed is complicated. Therefore, in this paper, we propose a service platform that overcomes these limitations and suggests the best and shortest patrol route to the police based on the desired patrol location applied by citizens. It is designed based on the MVC pattern, and the functions are divided for each user. It is hoped that the platform will reduce crime rates and allow citizens to ultimately return home with peace of mind. Also we expect that the police will ablet to find places where they did not know about or need to patrol with more attention through the recommended route of the platform, which will be helpful in their task.

Developing an IFC-based database for construction quality evaluation

  • Xu, Zhao;Li, Bingjing;Li, Qiming
    • International conference on construction engineering and project management
    • /
    • The 7th International Conference on Construction Engineering and Project Management Summit Forum on Sustainable Construction and Management
    • /
    • pp.301-312
    • /
    • 2017
  • Quality evaluation and control represent increasingly important concerns for construction quality management. There is an evident need for a standard data model to be used as the basis for computer-aided quality management. This study focuses on how to realize evaluation of construction quality based on BIM and database technology. In this paper, the reinforced concrete main structure is taken as an example, and the BP neural network evaluation model is established by inquiring current construction quality acceptance specification and evaluation standard. Furthermore, IFC standard is extended to integrate quality evaluation information and realize the mapping of evaluation information in BIM model, contributing to the visualization and transfer sharing of evaluation information. Furthermore, the conceptual entity model is designed to build quality evaluation database, and this paper select MySQL workbench system to achieve the establishment of the database. This study is organized to realize the requirement of visualization and data integration on construction quality evaluation which makes it more effective, convenient, intuitive, easy to find quality problems and provide more comprehensive and reliable data for the quality management of construction enterprises and official construction administratiors.

  • PDF

Applicability of Geo-spatial Processing Open Sources to Geographic Object-based Image Analysis (GEOBIA)

  • Lee, Ki-Won;Kang, Sang-Goo
    • Korean Journal of Remote Sensing
    • /
    • 제27권3호
    • /
    • pp.379-388
    • /
    • 2011
  • At present, GEOBIA (Geographic Object-based Image Analysis), heir of OBIA (Object-based Image Analysis), is regarded as an important methodology by object-oriented paradigm for remote sensing, dealing with geo-objects related to image segmentation and classification in the different view point of pixel-based processing. This also helps to directly link to GIS applications. Thus, GEOBIA software is on the booming. The main theme of this study is to look into the applicability of geo-spatial processing open source to GEOBIA. However, there is no few fully featured open source for GEOBIA which needs complicated schemes and algorithms, till It was carried out to implement a preliminary system for GEOBIA running an integrated and user-oriented environment. This work was performed by using various open sources such as OTB or PostgreSQL/PostGIS. Some points are different from the widely-used proprietary GEOBIA software. In this system, geo-objects are not file-based ones, but tightly linked with GIS layers in spatial database management system. The mean shift algorithm with parameters associated with spatial similarities or homogeneities is used for image segmentation. For classification process in this work, tree-based model of hierarchical network composing parent and child nodes is implemented by attribute join in the semi-automatic mode, unlike traditional image-based classification. Of course, this integrated GEOBIA system is on the progressing stage, and further works are necessary. It is expected that this approach helps to develop and to extend new applications such as urban mapping or change detection linked to GIS data sets using GEOBIA.

A Lifelog Management System Based on the Relational Data Model and its Applications (관계 데이터 모델 기반 라이프로그 관리 시스템과 그 응용)

  • Song, In-Chul;Lee, Yu-Won;Kim, Hyeon-Gyu;Kim, Hang-Kyu;Haam, Deok-Min;Kim, Myoung-Ho
    • Journal of KIISE:Computing Practices and Letters
    • /
    • 제15권9호
    • /
    • pp.637-648
    • /
    • 2009
  • As the cost of disks decreases, PCs are soon expected to be equipped with a disk of 1TB or more. Assuming that a single person generates 1GB of data per month, 1TB is enough to store data for the entire lifetime of a person. This has lead to the growth of researches on lifelog management, which manages what people see and listen to in everyday life. Although many different lifelog management systems have been proposed, including those based on the relational data model, based on ontology, and based on file systems, they have all advantages and disadvantages: Those based on the relational data model provide good query processing performance but they do not support complex queries properly; Those based on ontology handle more complex queries but their performances are not satisfactory: Those based on file systems support only keyword queries. Moreover, these systems are lack of support for lifelog group management and do not provide a convenient user interface for modifying and adding tags (metadata) to lifelogs for effective lifelog search. To address these problems, we propose a lifelog management system based on the relational data model. The proposed system models lifelogs by using the relational data model and transforms queries on lifelogs into SQL statements, which results in good query processing performance. It also supports a simplified relationship query that finds a lifelog based on other lifelogs directly related to it, to overcome the disadvantage of not supporting complex queries properly. In addition, the proposed system supports for the management of lifelog groups by providing ways to create, edit, search, play, and share them. Finally, it is equipped with a tagging tool that helps the user to modify and add tags conveniently through the ion of various tags. This paper describes the design and implementation of the proposed system and its various applications.

Design of the Web based Mini-PACS (웹(Web)을 기반으로 한 Mini-PACS의 설계)

  • 안종철;신현진;안면환;박복환;김성규;안현수
    • Progress in Medical Physics
    • /
    • 제14권1호
    • /
    • pp.43-50
    • /
    • 2003
  • PACS mostly has been used in large scaled hospital due to expensive initial cost to set up the system. The network of PACS is independent of the others: network. The user's PC has to be connected physically to the network of PACS as well as the image viewer has to be installed. The web based mini-PACS can store, manage and search inexpensively a large quantity of radiologic image acquired in a hospital. The certificated user can search and diagnose the radiologic image using web browser anywhere Internet connected. The implemented Image viewer is a viewer to diagnose the radiologic image. Which support the DICOM standard and was implemented to use JAVA programming technology. The JAVA program language is cross-platform which makes easier upgrade the system than others. The image filter was added to the viewer so as to diagnose the radiologic image in detail. In order to access to the database, the user activates his web browser to specify the URL of the web based PACS. Thus, The invoked PERL script generates an HTML file, which displays a query form with two fields: Patient name and Patient ID. The user fills out the form and submits his request via the PERL script that enters the search into the relational database to determine the patient who is corresponding to the input criteria. The user selects a patient and obtains a display list of the patient's personal study and images.

  • PDF

The Development of a Mobile-based E-Bookstore system (모바일 E-Book Store System의 설계 및 구현)

  • Min, Gi-Hong;Jeon, Seung-Min;Kim, Song-Rae;Park, Dong-Won
    • The Journal of Engineering Research
    • /
    • 제6권1호
    • /
    • pp.29-39
    • /
    • 2004
  • In the recent IT field, the biggest concerns may be Mobile environment. This means that it becomes part of our life: the Mobile is applied to the areas of teaching, studying, commercial transaction, entertainment etc. In this paper, we implemented Mobile E-BOOK bookstore using WEB, DB, and a Mobile technology. This system takes duplex from to be available in Mobile WEB environment by PDA and actuality WEB site under desk top environment. This paper have presented big possibility in terms of embodied electronic commerce based on the Mobile-based E-BOOKstore system that has not attempted yet commercially.

  • PDF

Cache Performance Analysis of Multiprocessor Systems for OLTP Applications based on a Memory-Resident DBMS (메모리 상주 DBMS 기반의 OLTP 응용을 위한 다중프로세서 시스템 캐쉬 성능 분석)

  • Chung, Yong-Wha;Hahn, Woo-Jong;Yoon, Suk-Han;Park, Jin-Won;Lee, Kang-Woo;Kim, Yang-Woo
    • Journal of KIISE:Computing Practices and Letters
    • /
    • 제6권4호
    • /
    • pp.383-392
    • /
    • 2000
  • Currently, multiprocessors are evaluated almost exclusively with scientific applications. Commercial applications are rarely explored because it is difficult to obtain the source codes of commercial DBMS. Even when the source code is available, such as for POSTGRES, understanding the source code enough to perform detailed meaningful performance evaluations is a daunting task for computer architects.To evaluate multiprocessors with commercial applications, we have developed our own DBMS, called EZDB. EZDB is a parallelized DBMS, loosely inspired from POSTGRES, and running on top of a software architecture simulator. It is capable of executing parallel programs written in SQL. Contrary to POSTGRES, EZDB is not intended as a prototype for a production-quality DBMS. Its purpose is to easily run and evaluate the performance of commercial applications on multiprocessor architectures. To illustrate the usefulness of EZDB, we showed the cache performance data collected for the TPC-B benchmark on a shared-memory multiprocessor. The simulation results showed that the data structures exhibited unique sharing characteristics and that their locality properties and working sets were very different from those in scientific applications.

  • PDF

A Study on the Application of Standard Technology for Integrated Management of Water Hazard Information Platform (수재해 정보 플랫폼 통합관리를 위한 표준기술 적용방안)

  • KIM, Dong-Young;LEE, Jeong-Ju;CHAE, Hyo-Sok;HWANG, Eui-Ho
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • 제18권4호
    • /
    • pp.119-130
    • /
    • 2015
  • In recent years, the attention on the applications of the national or international standards to water-related information technology in practice has more increased. In particular, as the demand on spatial information technology including content development, receiving, disposal and distribution has increased, the importance of standardization has been also emphasized. However, compared with attention and demand on standardization in spatial information technology, studies on development and application of standardization are still at the initial stage. Accordingly, this study attempted to investigate the trends of international standards developed and established by International Organization for Standardization(ISO) and Open Geospatial Consortium(OGC), and to derive the adaptable integrated management standard technology for water hazard information platform. For this, we investigated big data, NoSQL, and cloud technology for the observed data provision. Furthermore, OGC WxS standard technologies for spatial information web service and ISO standards for spatial information format were investigated. Based on these investigations, we examined the strategies and plans to apply and establish the standardization for information provision.