• Title/Summary/Keyword: SQL-database

Search Result 435, Processing Time 0.027 seconds

A Case Study of Developing XML-based Web Contents Supporting PC and PDA Browser (PC 및 PDA 브라우저 지원을 위한 XML 기반의 웹 컨텐츠 개발 사례 연구)

  • Kim Kyung-A;Yong Hwan-Seung
    • Journal of Digital Contents Society
    • /
    • v.3 no.1
    • /
    • pp.59-74
    • /
    • 2002
  • Due to rapid advance of wireless communication technology and popularization of wireless devices, demand on wireless internet contents is gradually increasing. Therefore, there are many researches and solution developments to provide good qualified contents quickly for wireless internet. For example, researches into converting wired web contents into wireless web contents or using integrated markup language like XHTML basic to make contents. In this paper, I propose a method to develop XML-based web contents which uses PHP language for data fetch from MySQL database. This method use open source software for a cost saving. Due to use of PHP extension as a XSLT engine, this method is very easy to apply. For a example of this method, a web content of movie information is implemented for PC and PDA browser. Developing XML-based web contents is useful not only for supporting devices of multiple type, but also for rapid changes of user interface design and for exchange of contents between web sites.

  • PDF

Ubiquitous Service Model for Information Convergence of Jeju Island Culture, Tourism, Sport and Traffic (제주 문화·관광·체육·교통 정보를 융합한 유비쿼터스 서비스 모델)

  • Lee, Chang-Young;Yang, Jin-Seok;Kim, Do-Hyeun;An, Beongku;Kim, Nam-Soo
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.8 no.4
    • /
    • pp.97-104
    • /
    • 2008
  • Recently the navigation service and LBS (Location based Services) using map supports much information services on mobile terminal. Also Internet Web sites support user much information. But, the user has the difficulty for acquiring the service and the various information based on map because of searching the many Internet sites. Accordingly, this paper supports a convergence information service model of various culture, education, tourism, sport and traffic for accessing synthesizing information based on map. And we design and implement this model using 공개 API. We present a convergence information service model of culture, tourism, sport and bus line information form tour destination and cultural place of Jeju province using the model. Additionally, we develop this service model using apache web server on Linux environment, PHP and JavaScript, MySQL database and Map 공개 API. As this service model supports a convenience action of culture and tourism for Jeju islanders and tourists.

  • PDF

A study for Health Promotion Program of Public Health Center by using CRM (CRM(Customer Relationship Management)기법을 활용한 보건소 건강증진사업에 관한 연구)

  • 강성홍;최순호
    • Korean Journal of Health Education and Promotion
    • /
    • v.20 no.3
    • /
    • pp.125-143
    • /
    • 2003
  • With the shift of cause of death from infection to chronic, the health expenditure has risen dramatically. To curb the increasing health expenditure, programs and campaigns to promote health were proposed and implemented. Most of them, however, were not successful in achieving satisfactory results. Customer Relationship Management has been gradually accepted as an innovative approach to health promotion. The objective of this research was to develop a Customer Relationship Management system for providing comprehensive health care services to the residents in the community. Detailed objectives were as follows: The first objective was the development of the CRM system for health promotion. The second objective was the satisfaction assessment for the health promotion program using the CRM system. The third was the proposal for the effective utilization of the CRM system. The development methodology of the CRM system was Rapid Warehouse Developing Method. As a CRM system equipment, a workstation with GIS of Windows 2000 was selected. SQL Server 2000 was used as a development tool and database. The subjects of study were diabetic mellitus patients, hypertension patients, and vaccin patients. The campaign channel of patients was an autocalling system. For the satisfaction assessment, a survey was performed. The main content of the survey was satisfaction level. The satisfaction level of the health promotion program using CRM system was 79.3%. In consideration of the above findings, we suggested ways of improving the Health Promotion Program by using CRM. The first was the efficient selection of the subjects of the Health Promotion Program. The second was the development for health promotion program using CRM system(life time health of individual etc).

Development of Traffic Prediction and Optimal Traffic Control System for Highway based on Cell Transmission Model in Cloud Environment (Cell Transmission Model 시뮬레이션을 기반으로 한 클라우드 환경 아래에서의 고속도로 교통 예측 및 최적 제어 시스템 개발)

  • Tak, Se-hyun;Yeo, Hwasoo
    • The Journal of The Korea Institute of Intelligent Transport Systems
    • /
    • v.15 no.4
    • /
    • pp.68-80
    • /
    • 2016
  • This study proposes the traffic prediction and optimal traffic control system based on cell transmission model and genetic algorithm in cloud environment. The proposed prediction and control system consists of four parts. 1) Data preprocessing module detects and imputes the corrupted data and missing data points. 2) Data-driven traffic prediction module predicts the future traffic state using Multi-level K-Nearest Neighbor (MK-NN) Algorithm with stored historical data in SQL database. 3) Online traffic simulation module simulates the future traffic state in various situations including accident, road work, and extreme weather condition with predicted traffic data by MK-NN. 4) Optimal road control module produces the control strategy for large road network with cell transmission model and genetic algorithm. The results show that proposed system can effectively reduce the Vehicle Hours Traveled upto 60%.

Development of an OpenGIS Server Supporting the OpenGIS CORBA Specification (OpenGIS CORBA 사양을 지원하는 OpenGIS 서버의 개발)

  • Zhang, Yan-Sheng;Yun, Jae-Kwan;Han, Ki-Joon
    • Journal of Korea Spatial Information System Society
    • /
    • v.2 no.1 s.3
    • /
    • pp.5-16
    • /
    • 2000
  • OGC(Open GIS Consortium) suggests the 'OpenGIS Simple Feature Specification for CORBA' which is the OpenGIS implementation specification for CORBA to specify standard interfaces for reuse and interoperation among distributed heterogeneous GIS resources in the CORBA distributed computing environment. An OpenGIS server that supports this implementation specification moat correctly implement all interfaces defined in the OpenGIS implementation specification to be interoperable with wrapped GISs efficiently. In this paper, we have designed and implemented an OpenGIS server based an object relational GIS, called GEUS that integrates GIS and database technologies to provide spatial data types and spatial operators from the DBMS engine level. In the CORBA distributed computing environment, clients can access geospatial data stored in GIS wrapped by the OpenGIS server through the standard interfaces defined in the OpenGIS implementation specification for CORBA. In addition, clients can use geospatial operation features provided by a back-end GIS and interoperate with other GISs.

  • PDF

Processing large-scale data with Apache Spark (Apache Spark를 활용한 대용량 데이터의 처리)

  • Ko, Seyoon;Won, Joong-Ho
    • The Korean Journal of Applied Statistics
    • /
    • v.29 no.6
    • /
    • pp.1077-1094
    • /
    • 2016
  • Apache Spark is a fast and general-purpose cluster computing package. It provides a new abstraction named resilient distributed dataset, which is capable of support for fault tolerance while keeping data in memory. This type of abstraction results in a significant speedup compared to legacy large-scale data framework, MapReduce. In particular, Spark framework is suitable for iterative machine learning applications such as logistic regression and K-means clustering, and interactive data querying. Spark also supports high level libraries for various applications such as machine learning, streaming data processing, database querying and graph data mining thanks to its versatility. In this work, we introduce the concept and programming model of Spark as well as show some implementations of simple statistical computing applications. We also review the machine learning package MLlib, and the R language interface SparkR.

Four Consistency Levels in Trigger Processing (트리거 처리 4 단계 일관성 레벨)

  • ;Eric Hanson
    • Journal of KIISE:Databases
    • /
    • v.29 no.6
    • /
    • pp.492-501
    • /
    • 2002
  • An asynchronous trigger processor (ATP) is a oftware system that processes triggers after update transactions to databases are complete. In an ATP, discrimination networks are used to check the trigger conditions efficiently. Discrimination networks store their internal states in memory nodes. TriggerMan is an ATP and uses Gator network as the .discrimination network. The changes in databases are delivered to TriggerMan in the form of tokens. Processing tokens against a Gator network updates the memory nodes of the network and checks the condition of a trigger for which the network is built. Parallel token processing is one of the methods that can improve the system performance. However, uncontrolled parallel processing breaks trigger processing semantic consistency. In this paper, we propose four trigger processing consistency levels that allow parallel token processing with minimal anomalies. For each consistency level, a parallel token processing technique is developed. The techniques are proven to be valid and are also applicable to materialized view maintenance.

Visualization of Path Expressions with Set Attributes and Methods in Graphical Object Query Languages (그래픽 객체 질의어에서 집합 속성과 메소드를 포함한 경로식의 시각화)

  • 조완섭
    • Journal of KIISE:Databases
    • /
    • v.30 no.2
    • /
    • pp.109-124
    • /
    • 2003
  • Although most commercial relational DBMSs Provide a graphical query language for the user friendly interfaces of the databases, few research has been done for graphical query languages in object databases. Expressing complex query conditions in a concise and intuitive way has been an important issue in the design of graphical query languages. Since the object data model and object query languages are more complex than those of the relational ones, the graphical object query language should have a concise and intuitive representation method. We propose a graphical object query language called GOQL (Graphical Object Query Language) for object databases. By employing simple graphical notations, advanced features of the object queries such as path expressions including set attributes, quantifiers, and/or methods can be represented in a simple graphical notation. GOQL has an excellent expressive power compared with previous graphical object query languages. We show that path expressions in XSQL(1,2) can be represented by the simple graphical notations in GOQL. We also propose an algorithm that translates a graphical query in GOQL into the textual object query with the same semantics. We finally describe implementation results of GOQL in the Internet environments.

Development of Integrated Biomedical Signal Management System Based on XML Web Technology

  • Lee Joo-sung;Yoon Young-ro
    • Journal of Biomedical Engineering Research
    • /
    • v.26 no.6
    • /
    • pp.399-406
    • /
    • 2005
  • In these days, HIS(Hospital Information System) raise the quality of medical services by effective management of medical records. As computing environment was developed, it is possible to search information quickly. But, standard medical data exchange is not completed between medical clinic and another organ so far. In case of patient transfer, past medical record was not efficiently transmitted. It be feasible treatment delay or medical accident. It is trouble that medical records is transferred by a person and communicate with each other. Extensible Markup Language (XML) is a simple, very flexible text format derived from SGML. Originally designed to meet the challenges of large-scale electronic publishing, XML is also playing an increasingly important role in the exchange of a wide variety of data on the Web and elsewhere. Form in system of company product, relative organs that handle bio-signal data is each other dissimilar and integration and to transmit to supplement bottleneck this research uses XML. In this study, it is discussed about sharing of medical data using XML web technology to standard medical record between hospital and relative organization The data structure model was designed to manage bio-signal data and patient record. We experimented about data transmission and all-in-one between different systems (one make use of MS-SQL database system and the other manage existent bio-signal data in itself form in file in this research). In order to search and refer medical record, the web-based system was implemented. The system that can be shared medical data was tested to estimate the merits of XML. Implemented XML schema confirms data transmission between different data system and integration result.

First Order Predicate Logic Representation and Management for Information Resource Dictionary (정보자원사전에 대한 서술논리 표현과 관리)

  • 김창화
    • The Journal of Information Technology and Database
    • /
    • v.5 no.1
    • /
    • pp.13-37
    • /
    • 1998
  • 인터넷 등의 컴퓨터 통신 네트워크의 발달로 인하여 분산된 정보자원의 공유를 통한 자원에 대한 재사용성의 필요성이 대두되었다. IRD(Information Resource Dictionary)는 조직 내에서 관련된 모든 정보에 대한 데이터가 논리적으로 중앙화된 정보저장소(repository)이다. IRD 내의 데이터는 다른 데이터를 기술하므로 이른바 메타 데이터라고 하기도 한다. IRD의 사전(dictionary) 요소는 정보자원의 종류, 정보자원의 의미, 정보자원의 논리적 구조, 정보자원의 위치, 그리고 정보자원의 접근방법 등을 기술한다. FIPS ANSI의 IRDS는 이항 관계를 이용하여 무결성 제약조건을 표현하므로 제약조건 규칙의 표현과 일반적인 추론 규칙의 표현이 제한되어 있으며, 다양한 형태의 무결성 제약조건의 표현과 IRD와 관련된 여러 정보의 도출 또는 추론 및 관리에 관한 사항은 IRD 응용 고유의 문제로 간주하여 언급하고 있지 않다. 한편, FIPS IRDS는 사용자가 SQL 및 IRD에 대한 전문적 지식이 없이는 사용자 질의 작성이 어려운 점등에 대한 문제점을 안고 있다. 본 논문은 FIPS IRDS의 기본모델에서 정보자원 표현, 정보자원들간의 관계, 정보자원의 관리 정보 구분을 명확히 하기 위해 정보자원 모델을 정보자원 표현요소와 정보자원 관리요소의 두 부류로 나누어 구분하고, 각 부류에 대한 자격 질의(competency question)를 통하여 유추된 요소들을 FIPS ANSI IRDS 기본 모델의 스키마 기술 레벨과 스키마 레벨에 첨가함으로써 그 기본 모델을 확장한다. 그리고, FIPS ANSI IRDS가 제공하는 IRD 기술과 관리 기능을 그대로 포함하면서 앞에서 문제점으로 지적된 제약조건 표현과 추론규칙 표현을 위하여 확장된 기본 모델을 중심으로 각 레벨의 구성 요소들의 형식적 의미(formal semantics)와 레벨 내 혹은 레벨 구성요소들간의 관계성(relationship), 그리고 제약조건의 표현과 질의 추론 규칙들을 식별하여 FOPL(First Order Predicate Logic)로 표현한다. 또한, 본 논문은 FOPL로 표현된 predicate들과 규칙들을 구현하기 위하여 Prolog로 변환하기 위한 이론적 방법론을 제시하고 정보자원 관리를 위한 기본 함수들과 스키마 진화(schema evolution)를 위한 방법론을 제안한다.

  • PDF