• Title/Summary/Keyword: SQL server

Search Result 208, Processing Time 0.03 seconds

Design and Implementation of Educational Activity Based Groupware for Elementary School (초등학교 교육활동 기반 그룹웨어의 설계 및 구현)

  • Kim, Yung-Sik;Kim, Young-Bok;Yoo, Seon-Tack
    • Journal of The Korean Association of Information Education
    • /
    • v.4 no.1
    • /
    • pp.12-23
    • /
    • 2000
  • Education using the internet, such as a virtual school and distance education, has been limited to the studies of content and method in learning, It has been less studied to make advantage of internet with regard to school administration, teachers' research, and efficient communication within a school. Therefore, it is suggested to implement groupware which can be used in a school environment. For this purpose, this study attempts to design and implement groupware on that purpose. The main content consists of 7 areas: introduction of the school(including children's room), notice room, working room, room for educational materials, individual information, parents' room, internet journey. The basic tool for a groupware is implemented on Windows NT 4.0 Server and subsequent IIS 2.0. DB management based on SQL Server 6.5 makes it enable to manage various information.

  • PDF

Privacy Protection Model for Location-Based Services

  • Ni, Lihao;Liu, Yanshen;Liu, Yi
    • Journal of Information Processing Systems
    • /
    • v.16 no.1
    • /
    • pp.96-112
    • /
    • 2020
  • Solving the disclosure problem of sensitive information with the k-nearest neighbor query, location dummy technique, or interfering data in location-based services (LBSs) is a new research topic. Although they reduced security threats, previous studies will be ineffective in the case of sparse users or K-successive privacy, and additional calculations will deteriorate the performance of LBS application systems. Therefore, a model is proposed herein, which is based on geohash-encoding technology instead of latitude and longitude, memcached server cluster, encryption and decryption, and authentication. Simulation results based on PHP and MySQL show that the model offers approximately 10× speedup over the conventional approach. Two problems are solved using the model: sensitive information in LBS application is not disclosed, and the relationship between an individual and a track is not leaked.

Development of a Volatile organic Compounds(VoCs) Liquefier on Integrated Management System based on ICT (ICT 기반의 휘발성 유기 화합물(VoC) 액화기 통합관리시스템 개발)

  • Kim, Gwan-Hyung
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.19 no.6
    • /
    • pp.1301-1306
    • /
    • 2015
  • This paper is to automate the intelligent and equipment to recycle the volatile organic compounds in various a gas stations and a laundry, in real life. In addition, based the ZigBee module and TCP/IP communications on ICT technologies, it's propose an integrated management system to monitor and manage an liquid at a remote location.Furthermore, it's propose a service model that can be freely managed from a remote location based on the app on android. In this paper, we present a communication protocol of the bridge modules and a liquefier of intelligent control system based ZigBee and MCU(Micro Controller Unit). Through the development of smart app based android mobile services in an integrated management system, it's represent for liquefier to a DB server for remote management(MS SQL 2012) and a web server (OS: Windows 2008).

Design and Implementation of Distributed Metadata Searching System using XML Web Service and JDBC (XML 웹서비스와 JDBC를 이용한 분산 메타데이터 검색 시스템의 설계 및 구현)

  • Choe, Hyunjong;Hwang, Sungwuk;Kim, Taeyoung
    • The Journal of Korean Association of Computer Education
    • /
    • v.7 no.2
    • /
    • pp.25-34
    • /
    • 2004
  • Sixteen provincial Research Institute of Education and Science(RISE) in the country have provided good qualified multimedia educational materials that was produced by some special skilled teachers to elementary, middle and high school teachers using web services. And moreover KERIS and KICE have also produced educational materials and have a plan to integrate distributed multimedia educational materials that RISE produced. The development of KERIS's KEM metadata in 2001 and the making of educational material metadata of RISE is the first step of integration plan. These metadata can be used to make integration plan possible. But before taking integration plan, the study of how to integrate and manage it should be performed. Therefore, this paper introduces the technique of XML web service and JDBC with 3-tier system as the method of integrate distributed educational material metadata. The evaluation shows these two methods have similar response time with MS SQL Server 2000 and Oracle 9i. Thus, we conclude that JDBC and XML web service can be the proper solution to search XML-formatted metadata.

  • PDF

Remote control by mobile and Labview (휴대폰과 Labview를 활용한 원격제어)

  • Park, Sang-Gug
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2008.10a
    • /
    • pp.797-801
    • /
    • 2008
  • This paper describes technical method about remote control and monitoring of local system by use personal mobile device in anytime and anywhere. Therefore, the user don't need to stay in operation room of local system. The PC server environment for the mobile connection are constructed with Apache web server, PHP and MySQL ODBC. The mobile internet homepage for the remote mobile connection is designed by Anybuilder software and mobile simulator, Openwave SDK 6.2 is used for the development. The mobile internet program can be applicate to all of domestic communication companies LGT, SKT and KTF. We use KTF mobile contains WAP browser for the test. We used NI Labview software to control and monitoring of local system. The local system, which will be controlled remotely have constructed with analog/digital signal acquisition device, signal control board and their software. By experiments, we confirmed remote control by mobile device are possible.

  • PDF

The traffic performance evaluation between remote server and mobile for applying to encryption protocol in the Wellness environment (웰니스 환경에서 암호화 프로토콜 적용을 위한 모바일과 원격 서버간 트래픽 성능 평가)

  • Lee, Jae-Pil;Kim, Young-Hyuk;Lee, Jae-Kwang
    • Journal of Digital Convergence
    • /
    • v.11 no.11
    • /
    • pp.415-420
    • /
    • 2013
  • U-WHS refers to a means of remote health monitoring service to combine fitness with wellbing. U-WHS is a system which can measure and manage biometric information of patients without any limitation on time and space. In this paper, we performed in order to look into the influence that the encryption module influences on the communication evaluation in the biometric information transmission gone to the smart mobile device and Hospital Information System.In the case of the U-WHS model, the client used the Objective-c programming language for software development of iOS Xcode environment and SEED and HIGHT encryption module was applied. In the case of HIS, the MySQL which is the Websocket API of the HTML5 and relational database management system for the client and inter-server communication was applied. Therefore, in WIFI communication environment, by using wireshark, data transfer rate of the biometric information, delay and loss rate was checked for the evaluation.

The study of EPC System S/W based on the UI (EPC시스템에서 UI기반의 소프트웨어에 대한 고찰)

  • Hwang, Seong Ha;Yoo, Sun Il;Jeong, Jin Su
    • Journal of the Korean Society of Systems Engineering
    • /
    • v.6 no.1
    • /
    • pp.61-68
    • /
    • 2010
  • Generally EPC management system was simply management concept through the normal S/W. Our LNG Plant R&D Center wanted to the excellent management system from the S/W. So We developed the R&D management S/W and EPC management S/W Built in the Microsoft Project Server. Our system made to the customer Requirements. It was just User Interface protocol. But User Interface has more Weak position, because it makes from the MS Project Servers. Ms Projector server make easy to treat the project on the WBS. EPC parts mixed WBS and normally Ms SQL Database. It has very complicated Structures. Now We planed to make the general Database and Ms Project Server, It' means to the S/W Developer and Schedule Manager ability. We will successfully integrate R&D management system and EPC system and other softwares.

  • PDF

Security of Database Based On Hybrid Blockchain (하이브리드 블록체인을 이용한 데이터베이스 보안)

  • Bae, Keun-Woo;Lee, Keun-Ho
    • Journal of Internet of Things and Convergence
    • /
    • v.6 no.1
    • /
    • pp.9-15
    • /
    • 2020
  • Recently, interest in blockchain technology has increased. The data industry is increasingly growing around the world. In addition, databases which obtain important information such as personal data are targeted by hackers. Data exposed by attackers happen frequently. In 2017, OWASP announced SQL injection is a top 1 threat to web applications. However, the proportion of data security is the smallest in the data industry. To prevent data exposure, this paper proposes a method that can protect databases by using hybrid blockchain.

Design and Implementation of Virtual Tutoring Estimation System on the Internet Environment (인터넷 환경에서 가상 학습평가 시스템 설계 및 구현)

  • 이석호;김창수;황현숙
    • Journal of Korea Multimedia Society
    • /
    • v.1 no.2
    • /
    • pp.204-214
    • /
    • 1998
  • The existing tutoring estimation systems using the authoring tools or HTML forms on the Web environment don't have been improved inconvenient factors of uni-directional interactive systems. In this paper, we design and implement the interactive tutoring estimation system which is conveniently considered to user on the internet environment. The proposed system is divided into teacher and student modules, which have the functions of the new problem insertion and deletion in database, regular examination marking for the former and lecture/test selection, scoring look, etc for the letter. The environment of server system in this thesis is implemented using the IDC file and SQL database for internet access based on Windows NT, client systems are composed to Windows 95 environment based on Explorer or Netscape to access for interactive tutoring systems.

  • PDF

An XPath Accelerator on Relational Databases: An Implementation and Its Tuning (관계형 데이터베이스를 이용한 XPath Accelerator: 구현과 튜닝)

  • Shin Jin-Ho;Na Gap-Joo;Lee Sang-Won
    • The KIPS Transactions:PartD
    • /
    • v.12D no.2 s.98
    • /
    • pp.189-198
    • /
    • 2005
  • XML is rapidly becoming the standard for data representation and exchange, and XML documents are being adopted in various applications. Since the late 1990s, some native XML database management systems(DBMSs) have been developed. More recently, commercial relational DBMS vendors try to incorporate full functionalities of XML into their products, such as Oracle, MS SQL and IBM DB2. In this paper, we implement a well-known RDBMS-based XML data storage and indexing technique, called XPath Accelerator, and tune it in an industry-leading RDBMS. Our contributions are two-folds: 1) an in-depth implementation of the XPath Accelerator technique and 2) its tuning to exploit the advanced query processing techniques of an RDBMS.