Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2004.11D.5.1063

A Study of Integrating ASP Databases with Customer Databases  

Kim, Ho-Yoon (인하대학교 대학원 첨단정밀공학과)
Lee, Jae-Won (인하대학교 기계공학부 산업공학)
Publication Information
The KIPS Transactions:PartD / v.11D, no.5, 2004 , pp. 1063-1072 More about this Journal
Abstract
In the ASP(Application Service Provider) business, applications using database sometimes require some data from clients' databases. These days such data are extracted from client database using manual database operations as an EXCEL file and the ASP, once receiving this file, transfers it into the application's database using manual database operations. This paper describes how to deal with data transmitting between the client database and ASP database on the web without using database manual operations for data extraction and insertion. We propose a framework which enables to transmit client data in a systematical way, to match different attribute names of each database for sharing same attribute values, and to avoid exposing information about the network path of client database to the ASP. This approach consists of two steps of data processing. The first is extracting data from client database as XML format by using a downloaded client program from ASP site, the second is uploading and storing the XML file into the ASP database. The implemented prototype system shows the suggested data integration paradigm is valid and ASP business needing integration of client database can be activated using it.
Keywords
ASP; Database; XML; Data Transmission; Attribute Matching;
Citations & Related Records
Times Cited By KSCI : 4  (Citation Analysis)
연도 인용수 순위
1 Amit P. Sheth, James A. Larson, 'Federated database systems for managing distributed, heterogeneous, and autonomous databases,' ACM Computing Surveys (CSUR), Vol.22, No.3, 1990   DOI
2 http://www.bizmeka.co.kr/
3 http://www.usi.com/
4 정상혁, 주경수, 이정수, '멀티미디어 데이터베이스 : XML 데이터베이스 시스템을 기반으로 한 B2B 통합 시스템 개발', 멀티미디어학회논문지, Vol.6, No.1, pp.1-14, 2003   과학기술학회마을
5 이순철, 김성훈, '정보시스템관리(1) : ASP의 효과적 도입 방안', 2002 한국경영정보학회 추계학술대회, Vol.2002, No.0, pp.177-188, 2002
6 http://www.sds.samsung.co.kr/product/unierp/index.php
7 http://www.kointech.com/
8 Robert Orfali, Dan Harkey, Jeri Edwards, The essential distributed objects survival guide 2nd edition, Prentice Hall, 1996
9 http://www.omg.org/news/whitepapers/whtsonwp.htm
10 변광준, 'EasyConnection : 이질 데이터베이스들의 효율적 연동방식', 한국저자거래(CALS EC)학회, 한국전자거래(CALS/EC)학회지, Vol.4, No.3, pp.235-246, 1999   과학기술학회마을
11 권은정, 용환승, '데이터베이스 : XML 을 기반으로 한 관계형 데이터베이스 메타데이터 리파지토리 설계 및 구현', 정보처리학회논문지D, Vol.9-D, No.1, pp.1-10, 2002   과학기술학회마을   DOI
12 이인기, 이민수, 용환승, '웹 기반의 OLAP 메타데이터 교환 시스템의 설계 및 구현', 정보처리학회논문지D, VoI.9-D, No. 6, pp.971-980, 2002   과학기술학회마을   DOI
13 Ramon Lawrence, Ken Barker, 'Integrating relational database schemas using a standardized dictionary,' Proceedings of the 2001 ACM symposium on Applied computing, 2001   DOI
14 Erhard Rahm, Philip A. Bernstein, 'A survey of approaches to automatic schema matching,' The VLDB Journal The International Journal on Very Large Data Bases, Vol.10 No.4, pp.334-350, 2001.   DOI
15 Mark Roantree, John Murphy, Wilhelm Hasselbring, 'The OASIS multidatabase prototype,' ACM SIGMOD Record, Vol.28, No.1, 1999   DOI
16 Thomas Wiedemann, 'Web-based simulation: Simulation application service providing (SIM-ASP),' Proceedings of the 33nd conference on Winter simulation, pp.623-628, Dec., 2001