Oracle Multimaster Replication Maintance Optimization.
This paper presents a new solution for adding a new database server on an existing Oracle Multimaster data replication system. In normal conditions adding a new database server on this system we cannot insert, delete and update data during this time. So during this time the system is down and we can...
| Publicado en: | Academicus no. 3; pp. 145 - 153 |
|---|---|
| Autores principales: | , |
| Formato: | Artículo |
| Publicado: |
Academicus
2011
|
| Materias: | |
| Acceso en línea: | Ver este registro en EBSCOhost |
| fields | @attributes: recordID: 1 pdfLink: plink: https://search.ebscohost.com/login.aspx?direct=true&db=hlh&AN=75899112&site=ehost-live header: @attributes: shortDbName: hlh uiTerm: 75899112 longDbName: Humanities International Complete uiTag: AN controlInfo: bkinfo: jinfo: jid: 20793715 BK4T jtl: Academicus issn: 20793715 maglogo: N pubinfo: dt: 2011 iid: 3 pid: 68858 pub: Academicus artinfo: ui: 75899112 10.7336/academicus.2011.03.10 ppf: 145 ppct: 8 formats: fmt: @attributes: type: P size: 167KB tig: atl: Oracle Multimaster Replication Maintance Optimization. aug: au: Paci, Hakik Xhuvani, Aleksander affil: Faculty of Information Technology, Polytechnic University of Tirana, Albania su: Databases Church work Data warehousing Data replication Albania sug: subj: Albania Databases Church work Data warehousing Data replication keyword: Keywords: Oracle Multimaster Data Replication Replication Replication group ab: This paper presents a new solution for adding a new database server on an existing Oracle Multimaster data replication system. In normal conditions adding a new database server on this system we cannot insert, delete and update data during this time. So during this time the system is down and we can make only queries. The time for adding the new database server depends on the number of tables on the replication group and on the network conditions. To reduce this time we propose to replace the Replication group in more than one replication group based on logic of database schema. So we will have a replication group for base data, one replication group for most populated tables and another group for non most used tables. Using this method on the Oracle database schema with 250 replication tables and communication speed 1Mbit/s, the time reduced seven times. This research is implemented on border control system (Total Information Management System at Ministry of Interior) in Albania and using this solution we can add or remove replication sites with minimal down time. pubtype: Academic Journal doctype: Article src: R language: English refInfo: copyright: @attributes: flag: Y custom: Copyright of Academicus is the property of Academicus and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. item: Academicus holder: Academicus dt: @attributes: year: 2011 holdings: @attributes: islocal: N |
|---|