• Title/Summary/Keyword: SQL server

Search Result 210, Processing Time 0.032 seconds

A System for Mining Traversal Patterns from Web Log Files (웹 로그 화일에서 순회 패턴 탐사를 위한 시스템)

  • 박종수;윤지영
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2001.10a
    • /
    • pp.4-6
    • /
    • 2001
  • In this paper, we designed a system that can mine user's traversal patterns from web log files. The system cleans an input data, transactions of a web log file, and finds traversal patterns from the transactions, each of which consists of one user's access pages. The resulting traversal patterns are shown on a web browser, which can be used to analyze the patterns in visual form by a system manager or data miner. We have implemented the system in an IBM personal computer running on Windows 2000 in MS visual C++, and used the MS SQL Server 2000 to store the intermediate files and the traversal patterns which can be easily applied to a system for knowledge discovery in databases.

  • PDF

A Study on Implementation and Design of Web-based Q-Cost Management System : Part 2; Implementation (웹 기반의 품질코스트 관리시스템 구축 : 제2부; 시스템 구축)

  • Kim Yon-Soo;Chung Young-Bae
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.27 no.4
    • /
    • pp.179-186
    • /
    • 2004
  • The purpose of this study is to implement web-based quality cost management system to measure the performance of quality improvement activities in the business firms. Developed WQCMS(Web-based Q-Cost Management System) have ability to collect and analyze quality data generated from various different departments in the inside or outside of the enterprise without any limitations, if end-users are able to access wide area network. It provides the capability to integrate quality information from database and to generate various easy analysis reports to management's needs using built-in analysis tool modules with real-time. The proposed system was developed using Microsoft's .Net technology, ASP.NET and MS-SQL Server 2000. By web-enabling Q-cost management system, the effectiveness of the system management and utilization was realized by easiness of information integration and economical efficiency.

A Design and Implementation based on Educational Smart Farm System (스마트 팜 교육 시스템 설계 및 구현)

  • Chung, Joong-Soo;Jung, Kwang-Wook
    • Proceedings of the Korean Society of Computer Information Conference
    • /
    • 2022.01a
    • /
    • pp.145-148
    • /
    • 2022
  • 본 논문은 스마트 팜 교육용 시스템을 IoT 기반으로 임베디드 환경에서 설계 및 구현하였다. 시스템 환경은 라즈베리파이 기반에서 노드-레드(Node-RED) 프로그램을 적용하였고 생육재배에 필요한 환경 센서와 구동장치를 연동하여 구축하였다. 센싱 정보는 유. 무선통신으로 서버로 전달되며, 데이터베이스를 근간으로 한 웹 설계는 PHP, MySQL을 사용하고, 스마트 폰 앱은 안드로이드 스튜디오를 사용하였다. 시스템 동작 과정은 센서값 인지 및 비주얼한 표시, 연동 구동장치 제어 프로그래밍, 서버 및 스마트 폰을 이용한 원격제어와 모니터링 과정을 수행할 수 있도록 설계하였다.

  • PDF

Vulnerability Defense of On-Zeroboard using CSRF Attack (CSRF 공격기법에 대한 제로보드상의 취약점 방어)

  • Kim, Do-Won;Bae, Su-Yeon;An, Beongku
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.14 no.4
    • /
    • pp.57-61
    • /
    • 2014
  • Zeroboard is a public bulletin board that can support PHP and MySQL. It has been used by many people because it is easy to use, but there is no more updates after Zeroboard4. So, there is a problem that its administrator will have nothing to do about it if zeroboard has a vulnerability. In this paper, we will discuss about CSRF(Cross Site request Forgery) which is developed and expanded by XSS(Cross Site Scripting). Also, we will find CSRF attacks and suggest an alternative method using VM-ware. The main features and contributions of the proposed method are as follows. First, make an environment construction using VM-ware and other tools. Second, analyze and prepare vulnerabilities using Proxy server. Performance evaluation will be conducted by applying possible countermeasure.

Development of a Facebook Fan Pages Analysis System to Improve Public Relations Effect (홍보 효과 증진을 위한 페이스북 팬페이지 분석 시스템 개발)

  • Choi, Minseok
    • Journal of Digital Convergence
    • /
    • v.13 no.12
    • /
    • pp.135-142
    • /
    • 2015
  • Appearance and rapid growth of the social network services (SNS) have led to changes in the distribution structure of information. Consumers can obtain various information quickly via the social network services and companies make use of a new advertising channel in them. In order to increase the effect of publicity activities through the social network services, development and application of public relations strategy by evaluating and analyzing the results of the activities is required. In this paper, a method for developing a low cost system to evaluate and analyze the results of public relations through the social networks is proposed. The proposed method was verified through building and running a demo system to collect and analyze data in the Facebook fan pages using MySQL database and PHP script on a Linux server.

Collaborative B2B architecture design using Web services (웹서비스를 이용한 Collaborative B2B 아키텍처 설계)

  • 김태운;김승완;한용호
    • Journal of Intelligence and Information Systems
    • /
    • v.9 no.1
    • /
    • pp.211-225
    • /
    • 2003
  • This paper aims at the design of collaborative architecture for business to business (B2B) applications based on Web service protocol. As different business processes should be interfaced in the B2B environment collaboration is important fur the success of B2B implementation. For the development tools, XML, Web services and ASP.NET were adopted Web services are emerging to provide a systematic and extensible framework for application-to-application interaction. The Web services framework is divided into three areas; communication protocols, service descriptions and Web discovery. Web services such as SOAP, WSDL and UDDI correspond to the three areas respectively. ASP.NET is utilized which corresponds to the component and service set located in the top layer of .NET. For the service of product category and product details, Web service architecture was implemented based upon the SQL server database.

  • PDF

A Prefetch Policy for Large Spatial Data in Distributed Environment (분산환경에서 대용량 공간데이타의 선인출 전략)

  • Park, Dong-Ju;Lee, Seok-Ho;Kim, Hyeong-Ju
    • Journal of KIISE:Software and Applications
    • /
    • v.26 no.12
    • /
    • pp.1404-1417
    • /
    • 1999
  • 웹과 같은 분산 환경에서는, 웹 브라우저 상에서 SQL 형식의 공간 질의를 수행시키는 것과 또한 서버로부터 그 질의 결과를 보는 것이 가능하다. 그러나, 격자 이미지(raster image)와 같은 대용량 공간 데이타를 포함하는 질의 결과를 웹 브라우징할 때 발생하는 많은 문제점들 중에서, 사용자 응답 시간의 지연은 매우 중요한 문제이다. 본 논문에서는 사용자의 재요청(callback) 접근 패턴이 공간적 근접성(spatial locality)을 따른다는 가정하에서의, 사용자 응답 시간을 최소화하기 위한 새로운 프리페치(prefetch) 전략에 대해서 서술한다. 본 논문의 프리페치 전략은 다음과 같이 요약될 수 있다. 첫째, 프리페치 알고리즘은 사용자의 접근 패턴을 잘 반영하는 힐버트 곡선(Hilbert-curve) 모델을 바탕으로 한다. 둘째, 프리페치 전송 비용을 줄이기 위해서 사용자의 재요청 시간 간격(think time)을 이용한다. 본 논문에서는, 힐버트 곡선을 이용한 프리페치 전략의 성능 평가를 위해서 다양한 실험을 하였으며, 그 결과로 프리페치를 하지 않는 방식보다 높은 성능 향상이 있음을 보인다.Abstract In distributed environment(e.g., WWW), it would be possible for the users to submit SQL-like spatial queries and to see their query results from the server on the Web browser. However, of many obstacles which result from browsing query results including large spatial data such as raster image, the delay of user response time is very critical. In this paper we present a new prefetch policy which can alleviate user response time on the assumption that user's callback access pattern has spatial locality. Our prefetch policy can be summerized as follows: 1) our prefetch algorithm is based on the Hibert-curve model which well replects user's access pattern, and 2) it utilizes user's callback interval to reduce prefetch network transmission cost. In this paper we conducted diverse experiments to show that our prefetch policy achieves higher performance improvement compared to other non-prefetch methods.

Multiplatform Game Development using Wire and Wireless Communication (멀티플랫폼 유무선 연동게임 개발)

  • Kang, Youn-Jun;Park, Dong-Gyu
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.13 no.4
    • /
    • pp.828-834
    • /
    • 2009
  • To get a better profit, standalone mobile game market shifts network-based mobile game. Currently, most of the game platform are separated into mobile to mobile, desktop to desktop, and console to console. Multi platform network game has a diverse problems including consistency control, object management technique, and bandwidth inconsistency. n this paper, we will introduce a multi-platform arcade game "Push-Push", which is played on desktop to mobile environment. The game guarantees realtime play between heterogeneous machine users and game item sharing between two platforms. e will focus n the issues of the 3rd generation multi platform games and propose some techniques or solving these problems. Our server database is implemented on MS SQL database, also the desktop programming tool is Visual Basic, and WIPI(Wireless Internet Platform or Interoperability) as a mobile platform.

Development of the Proportion Design Program for 40$\sim$60MPa High Strength Concrete (40$\sim$60MPa급 고강도 콘크리트 배합설계 프로그램 개발)

  • Yoo, Seung-Yeup;Choi, Dong-Ho;Lee, Sang-Rae;Koo, Ja-Sul;Kang, Suck-Hwa
    • Proceedings of the Korea Concrete Institute Conference
    • /
    • 2008.04a
    • /
    • pp.401-404
    • /
    • 2008
  • This study exploited the design of mixture proportion for the high strength concrete to establish the method of the quality control and high strength ready-mixed concrete for the application to the construction filed systematically how to output the estimated formula which could forecast mixture proportion for the high strength concrete classed 40${\sim}$60MPa through a experiment. It might contribute for systematic establishment of the method of the quality control and high strength ready-mixed concrete because it was possessed of the function of common data though a server, preservation and output of data, and estimation for the design of mixture proportion for the high strength concrete due to the experimental result, and Visual Basic, MS-SQL were used. Simply, it was produced corresponding to the condition of a laboratory, so it could be fundamental data for the design of mixture proportion for the high strength concrete. If upgrade is enforced with mixture proportion data of the each factory after then, it may contribute to the stability on quality and manufacture of high strength ready-mixed concrete to agree with the properties of each factory.

  • PDF

Design and Implementation of a Data Management System for Mobile Spatio-Temporal Query (모바일 시공간 질의을 위한 데이타 관리 시스템의 설계 및 구현)

  • Lee, Ki-Young;Lim, Myung-Jae;Kim, Joung-Joon;Kim, Kyu-Ho;Kim, Jeong-Lae
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.11 no.1
    • /
    • pp.109-113
    • /
    • 2011
  • Recently, according to the development of ubiquitous computing, the u-GIS which not only used in u-Transport, u-Care, u-Fun, u-Green, u-Business, u-Government, and u-City but also used to provides various spatial information such as the location of user is being the core technology of the ubiquitous computing environment. In this paper, we implemented an mobile spatio-temporal Query Processing Systems for handling the Spatio-Temporal Data in mobile equipment.The mobile spatio-temporal Query Processing Systems provides the spatio-temporal data type and the spatio-temporal operator that is expanded by the spatial data type and the spatial operator from OepenGIS "Simple Feature Specification for SQL". It supports arithmetic coding compression techniques that is considered with a spatio-temporal data specific character. It also provides the function of data cashing for improving the importation and exportation of the spatio-temporal data between a embedded spatio-temporal DBMS and u-GIS server.