NDLI: Herramienta para el Modelado de la Replicación de MYSQL Basada en la Ingeniería Dirigida por Modelos

Please wait, while we are loading the content...

Herramienta para el Modelado de la Replicación de MYSQL Basada en la Ingeniería Dirigida por Modelos

Content Provider	Semantic Scholar
Author	Ubillús, Bautista Ricardo, Efraín
Copyright Year	2015
Abstract	To model the MySQL replication, the database administrators (DBAs) use diagramming tools, such as Microsoft Visio. However, this type of tools do not allow automatically validating if the MySQL replication model is free of errors. Thus, we can have erroneous documentation of the MySQL replication models. These tools also do not allow automatically generating from the model, the mysqlreplicate commands of configuration. Due to the lack of these features, these are done manually, which becomes a tedious task, error prone, and time consuming, especially if the number of servers MySQL of the model is high, with 15, 20, 25 or more servers. This research proposes the development of the tool MySQL Replication Modeling that allows to the DBA’s modeling the MySQL replication and automatically validate if the model is correct, showing if there are errors. In addition, once the DBA has fixed and validated the model, the tool is capable of generating the mysqlreplicate commands of configuration. The tool was developed following the phases of the Rational Unified Process (RUP) and based on the Model Driven Engineering (MDE) under the Eclipse platform. The results demonstrate that the proposed tool MySQL Replication Modeling allows automatically validate a MySQL replication model, and reduce in more than 87% the time to identify and fix a MySQL replication model with 25 servers compared with the use of the tool Microsoft Visio 2013. The results also demonstrate that with the use of the proposed tool the time to generate the mysqlreplicate commands of configuration is reduced in more than 99% compared with the use of the tool Microsoft Visio 2013. Keywords: MySQL Replication Modeling, Model Driven Engineering, MDE.
File Format	PDF HTM / HTML
Alternate Webpage(s)	http://cybertesis.unmsm.edu.pe/xmlui/bitstream/handle/cybertesis/4347/Bautista_ue.pdf?isAllowed=y&sequence=1
Language	English
Access Restriction	Open
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in