• Title/Summary/Keyword: SQL 분석

Search Result 234, Processing Time 0.027 seconds

Interactive content development of voice pattern recognition (음성패턴인식 인터랙티브 콘텐츠 개발)

  • Na, Jong-Won
    • Journal of Advanced Navigation Technology
    • /
    • v.16 no.5
    • /
    • pp.864-870
    • /
    • 2012
  • Voice pattern recognition technology to solve the problems of the existing problems and common issues that you may have in language learning content analysis. This is the first problem of language-learning content, online learning posture. Game open another web page through the lesson, but the concentration of the students fell. Have not been able to determine the second issue according Speaking has made the learning process actually reads. Third got a problem with the mechanical process by a learning management system, as well by the teacher in the evaluation of students and students who are learning progress between the difference in the two. Finally, the biggest problem, while maintaining their existing content made to be able to solve the above problem. Speaking learning dedicated learning programs under this background, voice pattern recognition technology learning process for speech recognition and voice recognition capabilities for learning itself has been used in the recognition process the data of the learner's utterance as an audio file of the desired change to a transfer to a specific location of the server or SQL server may be easily inserted into any system or program, any and all applicable content that has already been created without damaging the entire component because the new features were available. Contributed to this paper, active participation in class more interactive teaching methods to change.

Development of Natural Disaster Damage Investigation System using High Resolution Spatial Images (고해상도 공간영상을 이용한 자연재해 피해조사시스템 설계 및 구현)

  • Kim, Tae-Hoon;Kim, Kye-Hyun;Nam, Gi-Beom;Shim, Jae-Hyun;Choi, Woo-Jung;Cho, Myung-Hum
    • Journal of Korea Spatial Information System Society
    • /
    • v.12 no.1
    • /
    • pp.57-65
    • /
    • 2010
  • In this study, disaster damage investigation system was developed using high resolution satellite images and GIS technique to afford effective damage investigation system for widely disaster damaged area. Study area was selected in Bonghwa, Gyungsangbukdo where high magnitude of damages from torrential rain has occurred at July in 2008. GIS DB was built using 1:5,000 topographic map, cadastral map, satellite image and aerial photo to apply for investigation algorithm. Disaster damage investigation system was developed using VB NET languages, ArcObject component and MS-SQL DBMS for effective management of damage informations. The system can finding damaged area comparing pre- and post-disaster images and drawing damaged area according to the damage item unit. Extracted object was saved in Shape file format and overlayed with background GIS DB for obtaining detail information of damaged area. Disaster damage investigation system using high resolution spatial images can extract damage information rapidly and highly reliably for widely disaster areas. This system can be expected to highly contributing to enhance the disaster prevention capabilities in national level field investigation supporting and establishing recovery plan etc. This system can be utilized at the plan of disaster prevention through digital damage information and linked in national disaster information management system. Further studies are needed to better improvement in system and cover for the linkage of damage information with digital disaster registry.

Spatio-Temporal Semantic Sensor Web based on SSNO (SSNO 기반 시공간 시맨틱 센서 웹)

  • Shin, In-Su;Kim, Su-Jeong;Kim, Jeong-Joon;Han, Ki-Joon
    • Spatial Information Research
    • /
    • v.22 no.5
    • /
    • pp.9-18
    • /
    • 2014
  • According to the recent development of the ubiquitous computing environment, the use of spatio-temporal data from sensors with GPS is increasing, and studies on the Semantic Sensor Web using spatio-temporal data for providing different kinds of services are being actively conducted. Especially, the W3C developed the SSNO(Semantic Sensor Network Ontology) which uses sensor-related standards such as the SWE(Sensor Web Enablement) of OGC and defines classes and properties for expressing sensor data. Since these studies are available for the query processing about non-spatio-temporal sensor data, it is hard to apply them to spatio-temporal sensor data processing which uses spatio-temporal data types and operators. Therefore, in this paper, we developed the SWE based on SSNO which supports the spatio-temporal sensor data types and operators expanding spatial data types and operators in "OpenGIS Simple Feature Specification for SQL" by OGC. The system receives SensorML(Sensor Model Language) and O&M (Observations and Measurements) Schema and converts the data into SSNO. It also performs the efficient query processing which supports spatio-temporal operators and reasoning rules. In addition, we have proved that this system can be utilized for the web service by applying it to a virtual scenario.

Design and Implementation of Automatic Linking Support System for Efficient Generating and Retrieving Integrated Documents Based on Web (웹 통합문서의 효율적 생성과 검색을 위한 자동링크지원 시스템의 설계 및 구축)

  • Lee, Won-Jung;Jung, Eun-Jae;Joo, Su-Chong;Lee, Seung-Yong
    • The KIPS Transactions:PartA
    • /
    • v.10A no.2
    • /
    • pp.93-100
    • /
    • 2003
  • With the advent of distributed computing and Web service technologies, lots of users have been requiring services that can conveniently obtain and/or support well-assembled information based on Web. For this reason, we are to construct Automatic Linking Support Systems for generating Web-based integrated information and supporting retrieval information according to user's various requirements. Our system organization is based on client/server system. A server environment consisted of automatic linking engine that can provide lexical analyzing, query processing and integrated document generating functions, and databases that are made of dictionaries, image and URL contents. Also, client environments consisted of Web editor that can generate integrated documents and Web helper that can retrieve them via automatic linking engine and databases. For client's user-friendly interfaces, web editor and helper programs can directly execute by down leading from a server without setup them before inside clients. For reducing server's overheads, Parts of server's executing modules are distributed to clients on which they can be executing. As an implementation of our system, we use the JDK 1.3, SWING for user interfaces like Web editor and helper, RMI mechanism for interaction between clients and a server, and SQL server 7.0 for database development, respectively. Finally, we showed the access procedures of automatic document linking engine and databases from Web editor or Web helper, and results appearing on their screens.

A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing (비유일 외래키 조합 복합키 기반의 사실테이블 모델링과 MDX 쿼리문 작성법)

  • Yu, Han-Ju;Lee, Duck-Sung;Choi, In-Soo
    • Journal of the Korea Society of Computer and Information
    • /
    • v.12 no.1 s.45
    • /
    • pp.177-188
    • /
    • 2007
  • A star schema consists of a central fact table, which is surrounded by one or more dimension tables. Each row in the fact table contains a multi-part primary key(or a composite foreign key) along with one or more columns containing various facts about the data stored in the row. Each of the composit foreign key components is related to a dimensional table. The combination of keys in the fact table creates a composite foreign key that is unique to the fact table record. The composite foreign key, however, is rarely unique to the fact table retold in real-world applications, particularly in financial applications. In order to make the composite foreign key be the determinant in real-world application, some precalculation might be performed in the SQL relational database, and cached in the OLAP database. However, there are many drawbacks to this approach. In some cases, this approach might give users the wrong results. In this paper, an approach to fact table modeling and related MDX query composing, which can be used in real-world applications without performing any precalculation and gives users the correct results, is proposed.

  • PDF

A study on the selection of the target scope for destruction of personal credit information of customers whose financial transaction effect has ended (금융거래 효과가 종료된 고객의 개인신용정보 파기 대상 범위 선정에 관한 연구)

  • Baek, Song-Yi;Lim, Young-Bin;Lee, Chang-Gil;Chun, Sam-Hyun
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.22 no.3
    • /
    • pp.163-169
    • /
    • 2022
  • According to the Credit Information Act, in order to protect customer information by relationship of credit information subjects, it is destroyed and stored separately in two stages according to the period after the financial transaction effect is over. However, there is a limitation in that the destruction of personal credit information of customers whose financial transaction effect has expired cannot be collectively destroyed when the transaction has been terminated, depending on the nature of the financial product and transaction. To this end, the IT person in charge is developing a computerized program according to the target and order of destruction by investigating the business relationship by transaction type in advance. In this process, if the identification of the upper relation between tables is unclear, a compliance issue arises in which personal credit information cannot be destroyed or even information that should not be destroyed because it depends on the subjective judgment of the IT person in charge. Therefore, in this paper, we propose a model and algorithm for identifying the referenced table based on SQL executed in the computer program, analyzing the upper relation between tables with the primary key information of the table, and visualizing and objectively selecting the range to be destroyed. presented and implemented.

A Case Study on the Design-First Approach and using UML for a Video Rental Store (Design-First Approach 와 UML이용)

  • Kook, Joong-Kak
    • Journal of the Korea Computer Industry Society
    • /
    • v.8 no.1
    • /
    • pp.1-8
    • /
    • 2007
  • In this paper, teaching object-oriented design in a programming course is a big challenge for instructors. "Objects-first" is a popular strategy for teaching object-oriented programming in the educational settings, by introducing the concepts of objects, classes, and instances before procedural elements of a programming language. Still, this approach emphasizes coding rather than other critical aspects of software development, notably problem-solving and design. We propose a "design-first" approach, which subsumes an objects-first approach into lessons that also introduce object-oriented analysis and design, using elements of UML before implementing any code. We also present video rental store (SRS) that uses the design-first approach to help students of various teaming styles in a software engineering course. It interfaces with an IDE we have chosen specifically to support the design-first approach, and SRS which has been shown to be effective in helping students learn object-oriented programming concepts.

  • PDF

Development of Gamsung Index Database for Web (웹 기반 감성지표 DB 구축에 관한 연구)

  • 서해성;최정아;최경주;이혜은;박수찬;채균식;이상태
    • Proceedings of the Korean Society for Emotion and Sensibility Conference
    • /
    • 2001.05a
    • /
    • pp.204-209
    • /
    • 2001
  • 감성 연구의 생리, 심리, 동작 분석 등의 과정에서 발생하는 문서, 데이터, 화상, 그림, 그래픽 등의 자료 공유에 인터넷을 적용하는 것은 매우 유망하다, 본 연구에서는 현재의 인터넷 (또는 인트라넷) 환경을 고려하여 Ultra 2 DB 서버, Sun Solaris (UNIX) OS, UniSql DBMS, Apache Web 서버로 시스템을 구축하였다. 이 시스템을 이용하여 웹기반 감성데이터 베이스 시제품을 구축하여 각종 감성자료를 보급하는 체계를 1차 완료하였으며, 도메인(www.gamsung.or.kr)을 등록하여 서비스를 실시하고 있다. 이 시스템에는 1단계 감성공학기술개발 사업의 35개 연구보고서, 1단계 연구결과로서 생산한 262개 감성지표, 2단계(전반기) 연구사업의 78개 감성지표, 일본의 인간감각계측 및 응용기술개발 중심으로 생산하나 100개 감성지표, 음성데이터, 인체측정데이터, 얼굴표정데이터와 설문데이터 등의 감성데이터와 감성공학 연구자 인력, 국내제조업체 정보, 참고문헌, 감성 정보물 등을 DB화하여 인터넷을 통하여 조회, 검색할 수 있도록 하였다. 뿐만 아니라 현재 진행되고 있는 감성공학기술개발에 대한 각종 정보를 제공하고 있으며 감성공학의 기술 동향에 대해서도 소개하고 있다. 이는 한국인의 감성 연구에 적합한 감성공학 데이터 베이스 시스템 구축의 발판을 마련하였으며, 향후 소비자의 감성을 예측하고, 이를 시스템 설계에 반영할 수 있으므로 인간중심의 제품개발에 큰 기여를 할 것으로 기대된다.

A Study on the Ontology Query Module based on Natural Language (자연어 기반 온톨로지 질의 모듈 연구)

  • Kim, Won-Pil;Kong, Hyun-Jang
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.47 no.1
    • /
    • pp.146-151
    • /
    • 2010
  • For an application of ontology, query processing is mandatory field for efficient information search in the ontology. Other query processing systems tend to analyze only facts and to simply provide structural information for users. In fact, the systems do not have big difference with database systems or text based information processing systems. Therefore, in this research, the method which can provide the inferred information based on axioms is suggested in order to maximize reusability of ontology.

Development of Gamsung Index Database for Web (웹 기반 감성지표 DB 구축에 관한 연구)

  • 곽현민;조해성;이상태
    • Proceedings of the Korean Society for Emotion and Sensibility Conference
    • /
    • 2002.05a
    • /
    • pp.79-85
    • /
    • 2002
  • 감성 연구의 생리, 심리, 동작 분석 등의 과정에서 발생하는 문서, 데이터, 화상, 그림, 그래픽 등의 자료 공유에 인터넷을 적용하는 것은 매우 유망하다. 본 연구에서는 현재의 인터넷 (또는 인트라넷) 환경을 고려하여 Ultra 2 DB 서버, Sun Solaris (UNIX) OS, UniSql DBMS, Apache Web 서버로 시스템을 구축하였다. 이 시스템을 이용하여 웹기반 감성데이터 베이스 시제품을 구축하여 각종 감성자료를 보급하는 체계를 1차 완료하였으며, 도메인(www.gamsung.or.kr)을 등록하여 서비스를 실시하고 있다. 이 시스템에는 1단계 감성공학기술개발 사업의 35개 연구보고서, 1단계 연구결과로서 생산한 262개 감성지표, 2단계 연구사업의 130개 감성지표, 일본의 인간감각계측 및 응용기술개발 중심으로 생산한 125개 감성지표, 음성데이터, 음향데이터, 인체측정데이터, 얼굴표정데이터와 설문데이터 등의 감성데이터와 감성공학 연구자 인력, 국내제조업체 정보, 참고문헌, 감성 정보물 등을 DB화하여 인터넷을 통하여 조회, 검색할 수 있도록 하였다. 뿐만 아니라 현재 진행되고 있는 감성 공학기술개발에 대한 각종 정보를 제공하고 있으며 감성공학의 기술 동향에 대해서도 소개하고 있다. 이는 한국인의 감성 연구에 적합한 감성공학 데이터 베이스 시스템 구축의 발판을 마련하였으며, 향후 소비자의 감성을 예측하고, 이를 시스템 설계에 반영할 수 있으므로 인간중심의 제품개발에 큰 기여를 할 것으로 기대된다.

  • PDF