The Experts below are selected from a list of 1527 Experts worldwide ranked by ideXlab platform
Yulin Zheng - One of the best experts on this subject based on the ideXlab platform.
-
sql to nosql Schema denormalization and Migration a study on content management systems
Systems Man and Cybernetics, 2015Co-Authors: Chaohsien Lee, Yulin ZhengAbstract:Content management systems (CMSs) are able to let people, who have no technical skill to manage websites, rapidly create, edit, organize and publish online contents. For example, CMSs are often used to establish e-commerce online shops, community portals, personal blogs, or organization websites. Thus, CMSs play the role of collecting data and then can be easily extended to become intelligent Internet systems. Most popular CMSs, e.g., Word Press and Joomla, rely on relational databases or SQL databases, e.g., MySQL, PostgreSQL, etc. However, due to the explosive growth of huge data, the well-structured characteristic of SQL databases may limit the scalability to handle horizontal scaling. Therefore, regarding the flexibility and the feasibility of parallel processing, cloud computing takes Not Only SQL (NoSQL) databases into consideration. How to migrate the original CMS software from SQL databases to NoSQL databases becomes one emerging and critical research issue. This paper is motivated to propose an autonomous SQL-to-NoSQL Schema denormalization and Migration. At the same time, this paper also evaluates the proposed mechanism on the realistic CMS software. Based on our experimental results, our mechanism not only helps the current CMS software migrate into the cloud platform without re-designing their database Schemas, but also improves at least 45% access performance after Schema Migration.
Roy Sterritt - One of the best experts on this subject based on the ideXlab platform.
-
A metadata driven approach to performing complex heterogeneous database Schema Migrations
Innovations in Systems and Software Engineering, 2013Co-Authors: Robert M. Marks, Roy SterrittAbstract:Enterprise software is evolving at a faster rate than ever before with customer’s expecting upgrades to occur regularly. These upgrades not only have complex consequences for legacy software but the database upgrade also. This paper discusses the challenges associated with relational database Schema Migrations which commonly occur with major upgrade releases of enterprise software. The most prevalent method of performing a Schema Migration is to execute SQL script files before or after the software upgrade. This approach performs poorly with large or complex database Migrations and also requires separate script files for each supported database vendor. A tool was developed for a complex database upgrade of an enterprise product which uses XML in a metadata-driven approach. The key advantages include the ability to abstract complexity, provide multi-database vendor support and make the database Migration more manageable between software releases. This marks an evolutionary step towards autonomic self-Migrations.
Robert Marks - One of the best experts on this subject based on the ideXlab platform.
-
a metadata driven approach to performing multi vendor database Schema upgrades
Engineering of Computer-Based Systems, 2012Co-Authors: Robert MarksAbstract:This paper discusses problems associated with relational database Schema Migrations which commonly occur with major upgrade releases of enterprise software. The most prevalent method of performing a Schema Migration is to execute SQL script files before or after the software upgrade. This approach performs poorly with large or complex database Migrations and also requires separate script files for each supported database vendor. A tool was developed for a complex database upgrade of an enterprise product which uses XML in a metadata driven approach. The key advantages include the ability to abstract complexity, provide multi-database vendor support and make the database Migration more manageable between software releases.
Chaohsien Lee - One of the best experts on this subject based on the ideXlab platform.
-
sql to nosql Schema denormalization and Migration a study on content management systems
Systems Man and Cybernetics, 2015Co-Authors: Chaohsien Lee, Yulin ZhengAbstract:Content management systems (CMSs) are able to let people, who have no technical skill to manage websites, rapidly create, edit, organize and publish online contents. For example, CMSs are often used to establish e-commerce online shops, community portals, personal blogs, or organization websites. Thus, CMSs play the role of collecting data and then can be easily extended to become intelligent Internet systems. Most popular CMSs, e.g., Word Press and Joomla, rely on relational databases or SQL databases, e.g., MySQL, PostgreSQL, etc. However, due to the explosive growth of huge data, the well-structured characteristic of SQL databases may limit the scalability to handle horizontal scaling. Therefore, regarding the flexibility and the feasibility of parallel processing, cloud computing takes Not Only SQL (NoSQL) databases into consideration. How to migrate the original CMS software from SQL databases to NoSQL databases becomes one emerging and critical research issue. This paper is motivated to propose an autonomous SQL-to-NoSQL Schema denormalization and Migration. At the same time, this paper also evaluates the proposed mechanism on the realistic CMS software. Based on our experimental results, our mechanism not only helps the current CMS software migrate into the cloud platform without re-designing their database Schemas, but also improves at least 45% access performance after Schema Migration.
Robert M. Marks - One of the best experts on this subject based on the ideXlab platform.
-
A metadata driven approach to performing complex heterogeneous database Schema Migrations
Innovations in Systems and Software Engineering, 2013Co-Authors: Robert M. Marks, Roy SterrittAbstract:Enterprise software is evolving at a faster rate than ever before with customer’s expecting upgrades to occur regularly. These upgrades not only have complex consequences for legacy software but the database upgrade also. This paper discusses the challenges associated with relational database Schema Migrations which commonly occur with major upgrade releases of enterprise software. The most prevalent method of performing a Schema Migration is to execute SQL script files before or after the software upgrade. This approach performs poorly with large or complex database Migrations and also requires separate script files for each supported database vendor. A tool was developed for a complex database upgrade of an enterprise product which uses XML in a metadata-driven approach. The key advantages include the ability to abstract complexity, provide multi-database vendor support and make the database Migration more manageable between software releases. This marks an evolutionary step towards autonomic self-Migrations.
