• Title/Summary/Keyword: Database Publish

Search Result 31, Processing Time 0.026 seconds

Integrated Methods of Various Media Generators in The SuperSQL Query Process System

  • Shin Sang-Gyu;Kim Tai-Suk;Toyama Motomichi
    • Journal of Korea Multimedia Society
    • /
    • v.9 no.6
    • /
    • pp.720-727
    • /
    • 2006
  • In this paper, we propose a method which allows the SuperSQL query processor to share as much code as possible among various, generators, each of which is responsible for the output of a certain medium. SuperSQL is an enhanced query-processing system that converts database records into a variety of formats such as XML, HTML, PDF and etc. However, the existing SuperSQL media generator would require creation of a different processor for each medium, causing duplicated development cost. This research makes three main contributions: First, it analyzes the structures of various media, examining any possibility of integration based on their common structure. Second, it also facilitates the addition of a new output media generator by separating constructors and decorators from each medium. Last, it provides an integrated user interface to each media by method of the Media Abstraction Table Concept. We also show the performance and feasibility of our system using experimental results.

  • PDF

Design of State Based Product Flow Control Framework in RFID-enabled Logistics Network

  • U Sang-Hun;Choi Ja-Yeong;Kim Chang-Uk
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 2006.05a
    • /
    • pp.1272-1281
    • /
    • 2006
  • RFID 기술을 이용함으로써 얻을 수 있는 많은 장점으로 인하여, 공급망에서 발생하는 실시간 제품 정보를 수집하고 관리하기 위하여 RFID 기술이 도입되고 있다. 기존의 RFID 기반의 공급망 관리 시스템은 제품의 위치에 따른 가시성은 확보할 수 있지만, 제품의 모든 상태에 따른 가시성은 확보하지 못한다는 단점이 있다. 이러한 단점을 해결하기 위해, 본 논문에서는 공급망 상의 제품 이동을 계획하고, 제품이 계획에 따라 이동할 때 발생하는 정보를 실시간으로 모니터링하고 통제할 수 있는 제품 상태 기반의 물류 통제 시스템을 설계하고 개발하였다. 이를 위해 본 연구에서는 첫째, 공급망에서 발생하는 제품 상태의 정의와 상태 변화의 흐름을 state chart로 표현하고, 둘째, 공급망에서의 폐쇄형관리 패러다임을 통한 제품 통제(감시 및 예외처리)를 정의하였으며, 셋째, Temporal data modeling을 통해 RFID 데이터 기반의 Database를 설계하고, 마지막으로, Publish/Subscribe 모델을 통해 효율적인 제품 상태 기반의 물류 통제 시스템 아키텍처를 설계하였다.

  • PDF

Performance of Distributed Database System built on Multicore Systems

  • Kim, Kangseok
    • Journal of Internet Computing and Services
    • /
    • v.18 no.6
    • /
    • pp.47-53
    • /
    • 2017
  • Recently, huge datasets have been generating rapidly in a variety of fields. Then, there is an urgent need for technologies that will allow efficient and effective processing of huge datasets. Therefore the problems of partitioning a huge dataset effectively and alleviating the processing overhead of the partitioned data efficiently have been a critical factor for scalability and performance in distributed database system. In our work we utilized multicore servers to provide scalable service to our distributed system. The partitioning of database over multicore servers have emerged from a need for new architectural design of distributed database system from scalability and performance concerns in today's data deluge. The system allows uniform access through a web service interface to concurrently distributed databases over multicore servers, using SQMD (Single Query Multiple Database) mechanism based on publish/subscribe paradigm. We will present performance results with the distributed database system built on multicore server, which is time intensive with traditional architectures. We will also discuss future works.

Defining and Processing XML View of Relational Data with Publication Functions of SQL/XML (SQL/XML의 출판 함수를 이용한 관계 데이터의 XML 뷰 정의 및 처리)

  • Lee, Sang-Wook;Kim, Jin;Kang, Hyun-Chul
    • Journal of Information Technology Applications and Management
    • /
    • v.16 no.4
    • /
    • pp.245-261
    • /
    • 2009
  • Since XML emerged as a standard for data exchange on the web, it has been widely used for applications like e-Commerce, CRM, and BI. However, it is common that most of business data is stored in relational database systems, and it is expected that business data management would still be centered around the relational database systems. As such, the technique of viewing relational data as XML and processing XML queries against it is required. To meet such a need, in the SQL/XML standard, the functions to publish relational data as XML are provided. In this paper, we propose the techniques of providing an XML view of relational data defined by an SQL/XML statement in DTD(Document Type Definition), and of processing XPath queries against the XML view by translating them into SQL/XML statements, and describe the validation of such techniques through implementation and tests.

  • PDF

Design of IoT Gateway for Storing Sensor Data using Ardulink based MQTT (Ardulink 기반 MQTT를 이용한 센서 데이터 저장을위한 IoT 게이트웨이 설계)

  • Nkenyereye, Lionel;Jang, Jong-Wook
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2017.10a
    • /
    • pp.744-747
    • /
    • 2017
  • The Internet of things (IoT) needs to be an event-driven approach for efficient real time response and processing. An IoT gateway is sometimes employed to provide the connection and translation between devices and the cloud. Storing data in the local database, and then forwarding it on the cloud is a task to be relegated to a gateway device In this paper, we propose the design of the IoT gateway with Fog computing for storing data from sensors into a local database. In the procedure of designing storing tasks, we propose to use the interfacing software known as Ardulink MQTT bridge. MQTT is a protocol for sensors to publish data to the clients. When it comes to needing historical data, MQTT connector can push MQTT data into SQL database. We write an MQTT client and based on the message topic insert the values into a SQL Database The design of IoT gateway with Fog computing adds value because it provides processing of the data across multiple devices before it sends to the cloud.

  • PDF

Collective Experience: A Database-Fuelled, Inter-Disciplinary Team-Led Learning System

  • Celi, Leo A.;Mark, Roger G.;Lee, Joon;Scott, Daniel J.;Panch, Trishan
    • Journal of Computing Science and Engineering
    • /
    • v.6 no.1
    • /
    • pp.51-59
    • /
    • 2012
  • We describe the framework of a data-fuelled, interdisciplinary team-led learning system. The idea is to build models using patients from one's own institution whose features are similar to an index patient as regards an outcome of interest, in order to predict the utility of diagnostic tests and interventions, as well as inform prognosis. The Laboratory of Computational Physiology at the Massachusetts Institute of Technology developed and maintains MIMIC-II, a public deidentified high- resolution database of patients admitted to Beth Israel Deaconess Medical Center. It hosts teams of clinicians (nurses, doctors, pharmacists) and scientists (database engineers, modelers, epidemiologists) who translate the day-to-day questions during rounds that have no clear answers in the current medical literature into study designs, perform the modeling and the analysis and publish their findings. The studies fall into the following broad categories: identification and interrogation of practice variation, predictive modeling of clinical outcomes within patient subsets and comparative effectiveness research on diagnostic tests and therapeutic interventions. Clinical databases such as MIMIC-II, where recorded health care transactions - clinical decisions linked with patient outcomes - are constantly uploaded, become the centerpiece of a learning system.

A Bibliometric Study of E-commerce Reputation

  • WIJAYA, Tony
    • The Journal of Industrial Distribution & Business
    • /
    • v.13 no.6
    • /
    • pp.1-7
    • /
    • 2022
  • Purpose: This study aims to investigate an overview of the reputation of e-commerce from 2001-2021. Research design, data and methodology: This study uses a bibliometrics technique involving published results from the Scopus database. Keyword tracking uses the terms e-commerce + reputation. The data collected meets the criteria for the type of journal publication. Data was collected using the Publish or Perish (PoP) program and exported into VOSviewer. Bibliometrics examines certain fields of science based on several components such as author and co-author, citation and co-citation, keywords related to theme mapping, origin, and source of publication. Data was collected using the Publish or Perish (PoP) program and exported into VOSviewer. Results: The results show the total citations from 118 papers are 1429, with citations per paper of 12.11 and citations per year of 68.05. The trend of publications from 2001-2021 shows the dynamics of increasing or decreasing, but this trend is still developing. Conclusions: This paper also presents articles that have contributed greatly to the study of e-commerce reputation, the most productive authors, and clustered themes regarding e-commerce reputation. Reputation is an important area of e-commerce research. Reputation is also essential factors for e-commerce in facing business competition and needs to be a consideration for digital business practitioners.

Concord: A Proactive Lightweight Middleware to Enable Seamless Connectivity in a Pervasive Environment

  • Hsu Sam;Mutha Mahesh;Pandya A.S.;Lho Young-Uhg
    • International Journal of Fuzzy Logic and Intelligent Systems
    • /
    • v.5 no.3
    • /
    • pp.189-195
    • /
    • 2005
  • One of the major components of any pervasive system is its proactive behavior. Various models have been developed to provide system wide changes which would enable proactive behavior. A major drawback of these approaches is that they do not address the need to make use of existing applications without modifying the applications. To overcome this drawback, a middleware architecture called 'Concord' is proposed. Concord is based on a simple model which consists of Lookup Server and Database. The rewards for this simple model are many. First, Concord uses the existing computing infrastructure. Second, Concord standardizes the interfaces for all services and platforms. Third, new services can be added dynamically without any need for reconfiguration. Finally, Concord consists of Database that can maintain and publish the active set of available resources. Thus Concord provides a solid system for integration of various entities to provide seamless connectivity and enable proactive behavior.

A Case Study on the Web Publishing of Relational DB Via XML (XML을 이용한 관계DB의 웹출판에 관한 사례)

  • 우원택
    • Proceedings of the Korea Association of Information Systems Conference
    • /
    • 2001.12a
    • /
    • pp.64-82
    • /
    • 2001
  • HTML revolutionized the way we specify the appearance of data on the Internet. Today, XML (the eXtensible Markup Language) is changing the way we specify the meaning of data. XML, lets document authors define their own markup tags and attribute names to assign meaning to the data elements in the document. Further, XML elements can be nested and include references to indicate data relationships, as Listing One. Unlike HTML, XML markup tags do not describe how to render the data. Rather, they provide descriptions of data, allowing software to understand the meaning of the data automatically For publishing, instead, XSL, the eXtensible Stylesheet Language as a separate language , is in charge of specifying the presentation of XML documents. The purpose of this study is to discover how to transform your organizations relational data into potential e-commerce, business-to-business, and web application with XML and XSL documents. For this purpose, the literature survey, first of all, was undertaken to understand the basic structures of XML documents. Second, one case implementation was performed to understand how to transform Access 2002 XML Files into HTML with XSLTand VB script. The results come out to be successful, more or less. But the limitations of it still exist. One immediate limitation is that XML documents are essentially tree structure, as dictated by the nesting of elements. However, relational database tables are two dimensional matrix structure. In addition, real-world data often is graph structured-a single data element may be referenced in multiple ways. However, this study is useful for understanding how to convert relational database into XML documents and to publish them using XSL or VB script.

  • PDF

Development Methods of Database Connectivity for Data Distribution Service based on Database (데이터베이스 기반의 데이터 분배 서비스를 위한 데이터베이스 커넥티비티 개발 방법)

  • Son, Yun-Hee;Yim, Hyung-Jun;Kim, Chum-Su;Chang, Hye-Min;Choi, Hoon;Lee, Kyu-Chul
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2012.06b
    • /
    • pp.95-97
    • /
    • 2012
  • OMG(Object Management Group)의 데이터 분배 서비스(DDS: Data Distribution Service)는 발간(publish)/구독(subscribe) 모델에 기반하여 동일한 타입의 데이터를 실시간으로 주고 받는 데이터 중심의 분산 환경에서 많이 사용되는 통신 미들웨어 기술이다. 하지만 DDS는 실시간으로 발생하는 데이터에 대하여 일회성인 특징을 갖기 때문에 추후 데이터에 대한 분석, 검증 등을 위해 영속성을 제공할 필요성이 증대되고 있다. 이러한 추세를 반영하듯 RTI DDS, PrismTech Opensplice 등의 대표적인 DDS 시스템에서는 데이터베이스를 연동하기 위한 연구를 진행하고 있다. 실시간 통신 미들웨어인 DDS와 데이터베이스의 연동은 DBMS 애플리케이션이 일반적으로 데이터베이스를 사용하는 것뿐만 아니라 DDS의 시맨틱을 알지 못하더라도 데이터 중심의 발간/구독 모델을 유기적으로 활용할 수 있는 장점을 지닌다. 본 논문에서는 이를 위해 DDS 시스템인 DB-ReTiCom의 데이터베이스를 사용하기 위한 커넥티비티를 제안하고 사용자 친화적 인터페이스를 위한 변환 방법을 제시한다.