Database Migration

14,000,000 Leading Edge Experts on the ideXlab platform

Scan Science and Technology

Contact Leading Edge Experts & Companies

Scan Science and Technology

Contact Leading Edge Experts & Companies

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

Ugrasen Suman - One of the best experts on this subject based on the ideXlab platform.

  • a model for relational to nosql Database Migration snapshot live stream db Migration model
    International Conference on Advanced Computing, 2021
    Co-Authors: Basant Namdeo, Ugrasen Suman
    Abstract:

    Data Migration is simply a process of transforming data from a source Database to target Database. Companies are moving their Database from one Database (e.g., RDBMS) to another new one (e.g., NoSQL) because of many reason such as new Database can handle more data, that could be fast, scalable etc. There are various tools and methods such as, mongify [1], mongoimport [2], sqoop [3] etc. These are available for Database Migration from RDBMS to NoSQL Databases. NoSQL uses document model, graph model, key-value etc., as compared to RDBMS Databases. NoSQL was primarily designed for storing and retrieving a large amount of data. In this paper, we have proposed a Database Migration model, which can migrate real-time as well as old data in a parallel way.The proposed model is implemented for MySQL (RDBMS) to MongoDB document Database in Java. The prototype migrates Database instance at a particular time (Snapshot of Database) as well as live data in a parallel way. Finally, our experimental evaluation of snapshot and live data Migration shows the higher performance as compared to other methods.

  • Schema design advisor model for RDBMS to NoSQL Database Migration
    International Journal of Information Technology, 2020
    Co-Authors: Basant Namdeo, Ugrasen Suman
    Abstract:

    Database schema design has a significant importance in software design. There are lots of tools and methods available for schema design in RDBMS but limited attention is given in NoSQL for schema design as it is emerging in Database technology. NoSQL requires a different approach in designing efficient schema, such as in the document Database which information should be stored as embedded document, or which information should be stored as referenced document. There are certain thumb rules for schema design in NoSQL Databases. In reengineering projects, especially in Old RDBMS to new NoSQL system, developing good and efficient Database schema is a very difficult task. In this paper, we have proposed a schema design advisor model which uses the existing software’s SQL queries load as an input along with an algorithm for schema design recommendation. Also, we have proposed a cost model for various schemas created by recommendation model. The proposed model is implemented through a prototype for the MongoDB document Database in Java. The prototype produces all possible combinations of schemas and calculates cost of each schema. Automated schema design process produces all possible combinations of NoSQL schemas, which is difficult with manual schema design approach.

Basant Namdeo - One of the best experts on this subject based on the ideXlab platform.

  • a model for relational to nosql Database Migration snapshot live stream db Migration model
    International Conference on Advanced Computing, 2021
    Co-Authors: Basant Namdeo, Ugrasen Suman
    Abstract:

    Data Migration is simply a process of transforming data from a source Database to target Database. Companies are moving their Database from one Database (e.g., RDBMS) to another new one (e.g., NoSQL) because of many reason such as new Database can handle more data, that could be fast, scalable etc. There are various tools and methods such as, mongify [1], mongoimport [2], sqoop [3] etc. These are available for Database Migration from RDBMS to NoSQL Databases. NoSQL uses document model, graph model, key-value etc., as compared to RDBMS Databases. NoSQL was primarily designed for storing and retrieving a large amount of data. In this paper, we have proposed a Database Migration model, which can migrate real-time as well as old data in a parallel way.The proposed model is implemented for MySQL (RDBMS) to MongoDB document Database in Java. The prototype migrates Database instance at a particular time (Snapshot of Database) as well as live data in a parallel way. Finally, our experimental evaluation of snapshot and live data Migration shows the higher performance as compared to other methods.

  • Schema design advisor model for RDBMS to NoSQL Database Migration
    International Journal of Information Technology, 2020
    Co-Authors: Basant Namdeo, Ugrasen Suman
    Abstract:

    Database schema design has a significant importance in software design. There are lots of tools and methods available for schema design in RDBMS but limited attention is given in NoSQL for schema design as it is emerging in Database technology. NoSQL requires a different approach in designing efficient schema, such as in the document Database which information should be stored as embedded document, or which information should be stored as referenced document. There are certain thumb rules for schema design in NoSQL Databases. In reengineering projects, especially in Old RDBMS to new NoSQL system, developing good and efficient Database schema is a very difficult task. In this paper, we have proposed a schema design advisor model which uses the existing software’s SQL queries load as an input along with an algorithm for schema design recommendation. Also, we have proposed a cost model for various schemas created by recommendation model. The proposed model is implemented through a prototype for the MongoDB document Database in Java. The prototype produces all possible combinations of schemas and calculates cost of each schema. Automated schema design process produces all possible combinations of NoSQL schemas, which is difficult with manual schema design approach.

Fernando Agraz - One of the best experts on this subject based on the ideXlab platform.

  • lightness a function virtualizable software defined data center network with all optical circuit packet switching
    Journal of Lightwave Technology, 2016
    Co-Authors: George M Saridis, Shuping Peng, Yan Yan, Alejandro Aguado, Bingli Guo, Murat Arslan, Christopher L Jackson, Wang Miao, N Calabretta, Fernando Agraz
    Abstract:

    Modern high-performance data centers are responsible for delivering a huge variety of cloud applications to the end-users, which are increasingly pushing the limits of the currently deployed computing and network infrastructure. All-optical dynamic data center network (DCN) architectures are strong candidates to overcome those adversities, especially when they are combined with an intelligent software defined control plane. In this paper, we report the first harmonious integration of an optical flexible hardware framework operated by an agile software and virtualization platform. The LIGHTNESS deeply programmable all-optical circuit and packet switched data plane is able to perform unicast/multicast switch-over on-demand, while the powerful software defined networking (SDN) control plane enables the virtualization of computing and network resources creating a virtual data center and virtual network functions (VNF) on top of the data plane. We experimentally demonstrate realistic intra DCN with deterministic latencies for both unicast and multicast, showcasing monitoring, and Database Migration scenarios each of which is enabled by an associated network function virtualization element. Results demonstrate a fully functional complete unification of an advanced optical data plane with an SDN control plane, promising more efficient management of the next-generation data center compute and network resources.

George M Saridis - One of the best experts on this subject based on the ideXlab platform.

  • lightness a function virtualizable software defined data center network with all optical circuit packet switching
    Journal of Lightwave Technology, 2016
    Co-Authors: George M Saridis, Shuping Peng, Yan Yan, Alejandro Aguado, Bingli Guo, Murat Arslan, Christopher L Jackson, Wang Miao, N Calabretta, Fernando Agraz
    Abstract:

    Modern high-performance data centers are responsible for delivering a huge variety of cloud applications to the end-users, which are increasingly pushing the limits of the currently deployed computing and network infrastructure. All-optical dynamic data center network (DCN) architectures are strong candidates to overcome those adversities, especially when they are combined with an intelligent software defined control plane. In this paper, we report the first harmonious integration of an optical flexible hardware framework operated by an agile software and virtualization platform. The LIGHTNESS deeply programmable all-optical circuit and packet switched data plane is able to perform unicast/multicast switch-over on-demand, while the powerful software defined networking (SDN) control plane enables the virtualization of computing and network resources creating a virtual data center and virtual network functions (VNF) on top of the data plane. We experimentally demonstrate realistic intra DCN with deterministic latencies for both unicast and multicast, showcasing monitoring, and Database Migration scenarios each of which is enabled by an associated network function virtualization element. Results demonstrate a fully functional complete unification of an advanced optical data plane with an SDN control plane, promising more efficient management of the next-generation data center compute and network resources.

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

  • lightness a function virtualizable software defined data center network with all optical circuit packet switching
    Journal of Lightwave Technology, 2016
    Co-Authors: George M Saridis, Shuping Peng, Yan Yan, Alejandro Aguado, Bingli Guo, Murat Arslan, Christopher L Jackson, Wang Miao, N Calabretta, Fernando Agraz
    Abstract:

    Modern high-performance data centers are responsible for delivering a huge variety of cloud applications to the end-users, which are increasingly pushing the limits of the currently deployed computing and network infrastructure. All-optical dynamic data center network (DCN) architectures are strong candidates to overcome those adversities, especially when they are combined with an intelligent software defined control plane. In this paper, we report the first harmonious integration of an optical flexible hardware framework operated by an agile software and virtualization platform. The LIGHTNESS deeply programmable all-optical circuit and packet switched data plane is able to perform unicast/multicast switch-over on-demand, while the powerful software defined networking (SDN) control plane enables the virtualization of computing and network resources creating a virtual data center and virtual network functions (VNF) on top of the data plane. We experimentally demonstrate realistic intra DCN with deterministic latencies for both unicast and multicast, showcasing monitoring, and Database Migration scenarios each of which is enabled by an associated network function virtualization element. Results demonstrate a fully functional complete unification of an advanced optical data plane with an SDN control plane, promising more efficient management of the next-generation data center compute and network resources.

  • LIGHTNESS: a function-virtualizable software defined data center network with all-optical circuit/packet switching
    'Institute of Electrical and Electronics Engineers (IEEE)', 2016
    Co-Authors: Saridis G. M., Yan Yan, Peng S., Aguado A., Guo B., Arslan M., Jackson C., Miao W., Calabretta N., Agraz Bujan Fernando
    Abstract:

    ©2016 IEEE. Personal use of this material is permitted. Permission from IEEE must be obtained for all other uses, in any current or future media, including reprinting/republishing this material for advertising or promotional purposes, creating new collective works, for resale or redistribution to servers or lists, or reuse of any copyrighted component of this work in other works.Modern high-performance data centers are responsible for delivering a huge variety of cloud applications to the end-users, which are increasingly pushing the limits of the currently deployed computing and network infrastructure. All-optical dynamic data center network (DCN) architectures are strong candidates to overcome those adversities, especially when they are combined with an intelligent software defined control plane. In this paper, we report the first harmonious integration of an optical flexible hardware framework operated by an agile software and virtualization platform. The LIGHTNESS deeply programmable all-optical circuit and packet switched data plane is able to perform unicast/multicast switch-over on-demand, while the powerful software defined networking (SDN) control plane enables the virtualization of computing and network resources creating a virtual data center and virtual network functions (VNF) on top of the data plane. We experimentally demonstrate realistic intra DCN with deterministic latencies for both unicast and multicast, showcasing monitoring, and Database Migration scenarios each of which is enabled by an associated network function virtualization element. Results demonstrate a fully functional complete unification of an advanced optical data plane with an SDN control plane, promising more efficient management of the next-generation data center compute and network resources.Peer ReviewedPostprint (author's final draft