The Experts below are selected from a list of 21 Experts worldwide ranked by ideXlab platform

Aleksander Xhuvani - One of the best experts on this subject based on the ideXlab platform.

  • adding a new site in an existing oracle Multimaster Replication without quiescing the Replication
    International Journal of Database Management Systems, 2011
    Co-Authors: Hakik Paci, Elinda Kajo, Igli Tafa, Aleksander Xhuvani
    Abstract:

    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.

  • oracle Multimaster Replication maintance optimization
    Academicus : International Scientific Journal, 2011
    Co-Authors: Hakik Paci, Aleksander Xhuvani
    Abstract:

    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.

Hakik Paci - One of the best experts on this subject based on the ideXlab platform.

  • adding a new site in an existing oracle Multimaster Replication without quiescing the Replication
    International Journal of Database Management Systems, 2011
    Co-Authors: Hakik Paci, Elinda Kajo, Igli Tafa, Aleksander Xhuvani
    Abstract:

    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.

  • oracle Multimaster Replication maintance optimization
    Academicus : International Scientific Journal, 2011
    Co-Authors: Hakik Paci, Aleksander Xhuvani
    Abstract:

    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.

Xhuvani Aleksander - One of the best experts on this subject based on the ideXlab platform.

  • Adding a new site in an existing Oracle Multimaster Replication without quiescing the Replication
    2011
    Co-Authors: Paci Hakik, Kajo Elinda, Tafa Igli, Xhuvani Aleksander
    Abstract:

    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.Comment: 9 pages, 4 figures, in International Journal of Database Management Systems (IJDMS) (2011

Paci Hakik - One of the best experts on this subject based on the ideXlab platform.

  • Adding a new site in an existing Oracle Multimaster Replication without quiescing the Replication
    2011
    Co-Authors: Paci Hakik, Kajo Elinda, Tafa Igli, Xhuvani Aleksander
    Abstract:

    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.Comment: 9 pages, 4 figures, in International Journal of Database Management Systems (IJDMS) (2011

Pla Wuhan - One of the best experts on this subject based on the ideXlab platform.