Adding a new site in an existing Oracle Multimaster replication without quiescing the replication

This paper presents a new solution, which adds a new database server on an existing Oracle Multimaster Data replication system with Online Instantiation method. During this time the system is down, because we cannot execute DML statements on replication objects but we can only make queries. The time...

Full description

Bibliographic Details
Main Authors: Paci, Hakik, Kajo, Elinda, Tafa, Igli, Xhuvani, Aleksander
Format: Text
Language:unknown
Published: arXiv 2011
Subjects:
Databases cs.DB
FOS Computer and information sciences
DML
Online Access:https://dx.doi.org/10.48550/arxiv.1109.1302
https://arxiv.org/abs/1109.1302
id ftdatacite:10.48550/arxiv.1109.1302
record_format openpolar
spelling ftdatacite:10.48550/arxiv.1109.1302 2023-05-15T16:01:21+02:00 Adding a new site in an existing Oracle Multimaster replication without quiescing the replication Paci, Hakik Kajo, Elinda Tafa, Igli Xhuvani, Aleksander 2011 https://dx.doi.org/10.48550/arxiv.1109.1302 https://arxiv.org/abs/1109.1302 unknown arXiv arXiv.org perpetual, non-exclusive license http://arxiv.org/licenses/nonexclusive-distrib/1.0/ Databases cs.DB FOS Computer and information sciences article-journal Article ScholarlyArticle Text 2011 ftdatacite https://doi.org/10.48550/arxiv.1109.1302 2022-04-01T13:53:36Z This paper presents a new solution, which adds a new database server on an existing Oracle Multimaster Data replication system with Online Instantiation method. During this time the system is down, because we cannot execute DML statements on replication objects but we can only make queries. The time for adding the new database server depends on the number of objects, on the replication group and on the network conditions. We propose to add a new layer between replication objects and the database sessions, which contain DML statements. The layer eliminates the system down time exploiting our developed packages. The packages will be active only during the addition of a new site process and will modify all DML statements and queries based on replication objects. : 9 pages, 4 figures, in International Journal of Database Management Systems (IJDMS) (2011) Text DML DataCite Metadata Store (German National Library of Science and Technology)
institution Open Polar
collection DataCite Metadata Store (German National Library of Science and Technology)
op_collection_id ftdatacite
language unknown
topic Databases cs.DB
FOS Computer and information sciences
spellingShingle Databases cs.DB
FOS Computer and information sciences
Paci, Hakik
Kajo, Elinda
Tafa, Igli
Xhuvani, Aleksander
Adding a new site in an existing Oracle Multimaster replication without quiescing the replication
topic_facet Databases cs.DB
FOS Computer and information sciences
description This paper presents a new solution, which adds a new database server on an existing Oracle Multimaster Data replication system with Online Instantiation method. During this time the system is down, because we cannot execute DML statements on replication objects but we can only make queries. The time for adding the new database server depends on the number of objects, on the replication group and on the network conditions. We propose to add a new layer between replication objects and the database sessions, which contain DML statements. The layer eliminates the system down time exploiting our developed packages. The packages will be active only during the addition of a new site process and will modify all DML statements and queries based on replication objects. : 9 pages, 4 figures, in International Journal of Database Management Systems (IJDMS) (2011)
format Text
author Paci, Hakik
Kajo, Elinda
Tafa, Igli
Xhuvani, Aleksander
author_facet Paci, Hakik
Kajo, Elinda
Tafa, Igli
Xhuvani, Aleksander
author_sort Paci, Hakik
title Adding a new site in an existing Oracle Multimaster replication without quiescing the replication
title_short Adding a new site in an existing Oracle Multimaster replication without quiescing the replication
title_full Adding a new site in an existing Oracle Multimaster replication without quiescing the replication
title_fullStr Adding a new site in an existing Oracle Multimaster replication without quiescing the replication
title_full_unstemmed Adding a new site in an existing Oracle Multimaster replication without quiescing the replication
title_sort adding a new site in an existing oracle multimaster replication without quiescing the replication
publisher arXiv
publishDate 2011
url https://dx.doi.org/10.48550/arxiv.1109.1302
https://arxiv.org/abs/1109.1302
genre DML
genre_facet DML
op_rights arXiv.org perpetual, non-exclusive license
http://arxiv.org/licenses/nonexclusive-distrib/1.0/
op_doi https://doi.org/10.48550/arxiv.1109.1302
_version_ 1766397253993365504

Similar Items