Skip to main content
placeholder image

Delta extraction in a limited collaborative environment

Journal Article


Abstract


  • This work considers extracting delta in a distributed environment where the collaboration from highly autonomous operational database management systems is limited to granting read only access on a set of selected relational tables. In addition, due to possibly large volumes of remote source data involved, and consequently enormous overhead associated with data transfer, efficiency issues must been taken into consideration. This research is based on the observation that usually, there is a large amount of static data in relational tables. It is proposed to use some statistical techniques in data warehouse system to help us understand the essential characteristics of remote data. Based on the characteristics of remote data, some optimisation techniques are presented.

Authors


  •   Zheng, Lu (external author)
  •   Liu, Haijun (external author)
  •   Yan, Jun

Publication Date


  • 2015

Citation


  • Zheng, L., Liu, H. & Yan, J. (2015). Delta extraction in a limited collaborative environment. International Journal of Intelligent Information and Database Systems, 9 (1), 54-78. International Journal of Intelligent Information and Database Systems

Scopus Eid


  • 2-s2.0-84938776425

Ro Metadata Url


  • http://ro.uow.edu.au/eispapers/5064

Number Of Pages


  • 24

Start Page


  • 54

End Page


  • 78

Volume


  • 9

Issue


  • 1

Abstract


  • This work considers extracting delta in a distributed environment where the collaboration from highly autonomous operational database management systems is limited to granting read only access on a set of selected relational tables. In addition, due to possibly large volumes of remote source data involved, and consequently enormous overhead associated with data transfer, efficiency issues must been taken into consideration. This research is based on the observation that usually, there is a large amount of static data in relational tables. It is proposed to use some statistical techniques in data warehouse system to help us understand the essential characteristics of remote data. Based on the characteristics of remote data, some optimisation techniques are presented.

Authors


  •   Zheng, Lu (external author)
  •   Liu, Haijun (external author)
  •   Yan, Jun

Publication Date


  • 2015

Citation


  • Zheng, L., Liu, H. & Yan, J. (2015). Delta extraction in a limited collaborative environment. International Journal of Intelligent Information and Database Systems, 9 (1), 54-78. International Journal of Intelligent Information and Database Systems

Scopus Eid


  • 2-s2.0-84938776425

Ro Metadata Url


  • http://ro.uow.edu.au/eispapers/5064

Number Of Pages


  • 24

Start Page


  • 54

End Page


  • 78

Volume


  • 9

Issue


  • 1