• Title/Summary/Keyword: SQL server

Search Result 208, Processing Time 0.037 seconds

Development of On-Line Computer Dictionary Supporting Hangul (한글을 지원하는 온라인 컴퓨터 용어 사전의 개발)

  • 황병연;박성철
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2001.04b
    • /
    • pp.184-186
    • /
    • 2001
  • 본 논문에서는 컴퓨터 신조어를 빠른 시간 내에 제공하고 한국적으로 용어를 재정의 할 뿐만 아니라 효율적인 검색 인터페이스를 갖춘 온라인컴퓨터 용어 사전을 개발하였다. 신조어를 발리 서비스하기 위해서 FOLDOC(Free On-Line Dictionary Of Computing)의 사전을 이용하여 영문 해설을 우선적으로 제공하고, 각 용어를 한 명 이상의 번역자가 한국어로 재정의 하도록 하였다. 또한 SQL과 MS-SQL Server를 이용해서 다양한 검색 인터페이스를 제공하여 사용자가 적은 정보만으로도 원하는 용어를 손쉽게 찾을 수 있게 하였다.

  • PDF

Natural Language Interface with Combinatory Categorial Grammar (결합범주문법을 이용한 자연언어 인터페이스)

  • 이호동;박종철
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2000.10b
    • /
    • pp.173-175
    • /
    • 2000
  • 본 연구에서는 전자상거래 데이터베이스를 대상으로 결합범주문법을 이용한 자연언어질의 인터페이스를 구현한다. 이를 위해 질의문을 분석하고 표현 방법을 논의한다. 또한 SQL 형식언어로 변환하기 위한 어휘 표현 및 유도 방법을 보인다. 제안하는 방법은 구문분석 과정에서 SQL 형식의 질의문을 직접 유도하는 것으로 기존 연구에서 제안됐던 중간논리언어 변환단계를 거치지 않으므로 과정이 간결해져 시스템의 성능향상을 가져올 수 있다. 시스템은 웹 기반과 client/server 구조로 구현된다.

  • PDF

Network Hacking and Implementation Techniques using Faked ARP Reply Unicast Spoofing according to various Server Types (위조 ARP 응답 유니캐스트 스푸핑을 이용한 서버 유형별 네트워크 해킹 및 구현기술 연구)

  • Choi, Jae-Won
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.21 no.1
    • /
    • pp.61-71
    • /
    • 2017
  • ARP Spoofing is a basic and core hacking technology for almost all sniffing. It makes change the flow of packets by faking the 2nd layer MAC address. In this paper we suggested an efficient hacking technology for sniffing remote servers in the switched network environment. The suggested 'Faked ARP Reply Unicast Spoofing' makes the bidirectional packets sniffing possible between the client and server, and it makes simplify the procedures for ARP sniffing and hacking program. In this paper we researched the network hacking and implementation technologies based on the suggested ARP spoofing. And we researched various types of servers hacking such as Root ID and PW of Telnet/FTP server, Root ID and PW of MySQL DB server, ID and PW of Web Portal Server, and account information and transaction history of Web Banking Server. And also we researched the implementation techniques of core hacking programs for the ARP Spoofing.

Design and Implementation of Web-based Virtual Makeup Simulation System (웹 상에서의 가상 메이크업 시뮬레이션 시스템 설계 및 구현)

  • Shon, Hyung-Do;Lee, Jae-Hyub
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.8 no.2
    • /
    • pp.167-173
    • /
    • 2002
  • The VMSS(Virtual Makeup Simulation System) is a virtual simulation system which can apply makeup, hair style, accessory to user's own face image through internee connection. The simulation result can be stored to server side DB and also can be printed out on client side printer. It is implemented using Java so, clients don't need any other client program to run the VMSS except Web browser and Java Plug-in installed on browser. IIS (Internet Information Server) Web server of Window 2000 and MS-SQL 7 are used to develop the overall system. Commercial JDBC Driver Type 4 is used to connect the applet and DB. It suggests a new direction of Web-based contents service development and can be applied to many other areas.

Group Management System based on Apache Web Server and Android App (Apache 웹서버와 Android 앱 기반의 동호회 관리 시스템)

  • Eun, Jong-Min;Oh, Jae-Kon;Kim, Jeong-Joon
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.18 no.2
    • /
    • pp.141-147
    • /
    • 2018
  • The group is one of the hobbies and other life groups, and each person in the group directly attends the meeting and works on the topic of the group. In this paper, we implemented voting, announcements, surveys, and suggestions, which are necessary functions for similar groups including group. We also provide web sites based on Apache web server for convenience of Android smartphone applications, OS except Android, Group management can be managed by using the manager's website which can manage the whole group management. It is designed with Apache web server, web communication language PHP, MySQL database, and Android.

An Implementation of Web-based Client/Server Architecture using Distributed Objects (분산 객체를 이용한 웹기반 클라이언트 / 서버 구조의 구현)

  • 박희창;이태공
    • Journal of the military operations research society of Korea
    • /
    • v.23 no.2
    • /
    • pp.25-44
    • /
    • 1997
  • Internet users been rapidly increased due to the convenient GUI environment. Current Web-based HTTP/CGI client/server architecture has several problems such as the CGI bottleneck, no maintaince of state, and no load balancing. However, with Java and CORBA technologies called“Object Web technology”, we can solve them because Java is not only a mobile code but also a platform-independent code, and CORBA has ability to build distributed object and language-independent object model. The goal of “Object Web technology”is to create multivendor, multiOS, multilanguage“legoware”using objects. This paper implement“Book Search System”which is Web-based client/server architecture using distributed objects. Environments of this implementation are Hangul Windows NT(included IIS) server, Hangul Windows 95 client, Visigenic's VisiBroker for Java 1.2 which is a product of CORBA 2.0, HTTP protocol on TCP-IP-based, Sybase SQL Anywhere 5.0 database server, and the interface between application server and database is JDBC-ODBC bridge middleware.

  • PDF

Adaptable Online Game Server Design

  • Seo, Jintaek
    • Journal of information and communication convergence engineering
    • /
    • v.18 no.2
    • /
    • pp.82-87
    • /
    • 2020
  • This paper discusses how to design a game server that is scalable, adaptable, and re-buildable with components. Furthermore, it explains how various implementation issues were resolved. To support adaptability, the server comprises three layers: network, user, and database. To ensure independence between the layers, each layer was designed to communicate with each other only via message queues. In this architecture, each layer can have an arbitrary number of threads; thus, scalability is guaranteed for each layer. The network layer uses input/output completion ports(IOCP), which shows the best performance on the Windows platform, it can handle up to 5,000 simultaneous connections on a typical entry-level computer, despite being built with a single-threaded user layer. To completely separate the database from the game server, the SQL code was not directly embedded in the database layer.

Efficient Management of Tunnel Construction Informations using ITIS(Intelligent Tunnelling Information System) (ITIS를 활용한 효율적인 터널 정보화 시공 관리)

  • Kim, Chang-Yong;Hong, Sung-Wan;Bae, Gyu-Jin;Kim, Kwang-Teom;Son, Moo-Rak;Han, Byeong-Hyeon
    • Proceedings of the Korean Geotechical Society Conference
    • /
    • 2004.03b
    • /
    • pp.946-951
    • /
    • 2004
  • ITIS is applied to the several tunnel construction sites in Korea. Tunnel construction properties which are acquired from these sites are transferred to information management server(SQL 2000 server)by client application program in real time. Access permission to DB server depends on the user's roles. Some functions which cannot be embodied in SQL Server are serviced through XML and GMS server is used for spatial data based on GIS part. This system is supposed to give engineers the advantages which are not only easy handling of the program and computerized documentation on every information during construction but also analyzing the acquired data in order to predict the structure of ground and rock mass to be excavated later and show the guideline of construction. Neung-Dong tunnel and Mu-Gua express way tunnel are now under construction and with this system they have 3D visualized map of the geology and tunnel geometry and accumulate database of construction information such as tunnel face mapping results, special notes and pictures of construction and 3D monitoring data, all matters on the stability of rock bolts and shotcrete, and so on. Ground settlement prediction program included in ITIS, based on the artificial neural network(ANN) and supported by GIS technology is applying to the subway tunnel. This prediction tool can make it possible to visualize the ground settlement according to the excavation procedures by contouring the calculated result on 3D GIS map and to assess the damage of buildings in the vicinity of construction site caused by ground settlement.

  • PDF

External Merge Sorting in Tajo with Variable Server Configuration (매개변수 환경설정에 따른 타조의 외부합병정렬 성능 연구)

  • Lee, Jongbaeg;Kang, Woon-hak;Lee, Sang-won
    • Journal of KIISE
    • /
    • v.43 no.7
    • /
    • pp.820-826
    • /
    • 2016
  • There is a growing requirement for big data processing which extracts valuable information from a large amount of data. The Hadoop system employs the MapReduce framework to process big data. However, MapReduce has limitations such as inflexible and slow data processing. To overcome these drawbacks, SQL query processing techniques known as SQL-on-Hadoop were developed. Apache Tajo, one of the SQL-on-Hadoop techniques, was developed by a Korean development group. External merge sort is one of the heavily used algorithms in Tajo for query processing. The performance of external merge sort in Tajo is influenced by two parameters, sort buffer size and fanout. In this paper, we analyzed the performance of external merge sort in Tajo with various sort buffer sizes and fanouts. In addition, we figured out that there are two major causes of differences in the performance of external merge sort: CPU cache misses which increase as the sort buffer size grows; and the number of merge passes determined by fanout.

Using of RAM for Performance Tuning in Web Database Server (웹 데이터베이스 서버 성능개선을 위한 램의 활용)

  • 이원조;이단영;고재진
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2000.10a
    • /
    • pp.311-313
    • /
    • 2000
  • 인터넷 E-Business를 위한 ASP를 이용한 웹사이트 구축이 급속도로 증가하는 추세로 대화형 서비스를 제공하기 위해 데이터베이스인 MS SQL Server의 적용이 많아졌다. 따라서 본 연구에서는 웹사이트 구축시 데이터베이스의 성능개선을 위한 임시테이블의 램 활용기법에 대한 효율적인 모델을 제안하고 성능을 평가하였다. 이와 같은 결과로 웹서버의 성능개선에 임시테이블의 램 활용에 대한 기법이 유익하게 활용될 것이다.

  • PDF