Data Migration from Visual Basic Interfaces to Excel Tables Prevent
Conflict Using Proposed Models
HASSAN B. HASHIM
Middle Technical University
Baghdad, IRAQ
Abstract: - In relational and complex spreadsheets, relational and non-relational database models, high-speed data
migration with scalable structure using visual Basic Excel programming language implementations with proposed
migration model. One of the primary purposes behind making a point of interaction through the Visual Basic
Application (VBA) is that most PC clients with logical preparation will currently know about Succeed and its
significant capabilities (like arranging furthermore, plotting datasets). Even though Excel itself is in many cases
utilized as an information storehouse by clients. The time factor, reliability, and credibility of migrating this data
from one table to another through programming interfaces were measured using the link codes between the tables.
In this paper, the migration and migration of homogeneous and heterogeneous data are investigated by using two
types of different migration models of data to measure and match these data and the extent of their integration after
migration. Specifies the target data for migration from the input tables in the Excel program to the target tables in
larger databases. Furthermore, the two models (A, B) middleware provide an architecture that can be extended to
support Relational database management systems (RDBMS) and other graphing databases. Experiments were
performed using excel tables, both of which are related as source information bases, and as the data set for the source
and target datasets, the migration time between these tables for the two models was calculated While retaining the
same characteristics
Key-Words: - Migration, Excel Tables, Model, Integration Data, Migration Models
Received: May 19, 2022. Revised: October 26, 2022. Accepted: December 5, 2022. Published: December 31, 2022.
1 Introduction
Mix and Relocation Difficulties Emerge Each Time an
Association Moves to Another Information Framework
or Wishes to Consolidate Various Information
Frameworks, Either Inside or Because of a
Consolidation. However, Reviews Show That Over
80% Of All Information Coordination Undertakings
Fizzle. Information Quality Is Basic to Any
Information Combination and Movement Drive
Achievement, And Associations Pass on This
Viewpoint to The Last Moment at Their Danger.
Information issues stay unidentified in a regular
information combination or relocation situation during
the underlying task of aging and checking. Addressing
these impromptu information issues can consume up to
70% of the time and spending plan lately modification
test with not making arrangements for information at
the start is that commons are common however actually
these information quality issues can fundamentally
affect the usefulness of the whole framework.
Information issues can cause can likewise prompt
differences to be in a different way tong made,
occupying superfluous extra space and effect adversely
framework execution. that without guaranteeing
information quality before movement or mix,
associations can't ensure the access value ability of
value informally able seriously influencing business
execution. Visual Fundamental for Applications and
various procedures are commonly layered on top of
Succeed bookkeeping sheets to endorse the exactness
of the entered data regards and work on clients'
association in such designs inside estimation sheets.
For sure, even with these additional endorsement
layers, bookkeeping sheets are at this point leaned to
bungles. Our philosophy is to familiarize some
development with Succeed, and we have consequently
made a gadget, Tables, to determine the issue of staying
aware of conditions between factors. for high security
for moving huge extension data records to the cloud
informational index organization between cloud data
development processes that gives quick stretches.
Assessing the effortlessness of the work has
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
131
Volume 2, 2022
differentiated the display and leaving cloud
development organizations [1] [2].
The inspiration driving this study is to give a thorough
assessment of the investigation tries so far focused on
the issue of table understanding and to portray
structures that assist with changing heterogeneous
tables into huge information. The "table sorting out
issue" involves the customized extraction of huge
information from tables that can be exploited for data
blend, data exchange, and noticing questions. In this
review, we ponder the chief methodologies proposed
over the latest 15 years. a deliberate data evaluation
system that uses an organization mode that can
normally channel data, survey quality, make genuine
reports, and scatter reports. This detached
programming plan thought permits the proposed
construction to be applied to various intelligent
contraptions; it's joining into existing examination
office information the leader's systems [3][4].
The proposed model is allotted into three stages. the
model is made considering the clinical records, and
patients are circled across three data sources (SQL,
MongoDB, and succeed). for research, Large
Information Mining Approaches in Cloud
Frameworks, and address cloud-viable issues and
processing procedures to advance Huge Information
Mining in Cloud Frameworks [5] [6].
The Joint Master Detail Framework (JESS) is
presented by the world's most noteworthy single
wellspring of thermodynamic data about fluid
electrolyte game plans. Pc presents our revelations
concerning privacy expects a huge informational
collection of hate tables in a book; they should be
consistently created, created the look, at, and
unequivocally expected for dealing with by
tremendous extension, motorized workplaces,
including tests for impulsive mix-ups and inside
consistency. It's essential to supervise cloud data
unequivocally and grow the important protection. Each
period of the data development interaction ought to be
gotten, similar to data exposure, portrayal, and ordering
of permission to the essential data. Appropriated
capacity organizations are brought together [7][8].
part in data movement plans and ought not to disregard
orders. Without sufficient data quality, data
development is incomprehensible. present a method of
self-changing data migration, which thus changes
development strategies and their limits concerning the
movement circumstance and organization level plans,
hence adding to the self-organization of informational
collection systems and supporting a deft development
[9] [10].
explore information movement basics. To expand the
effectiveness of static examination, for executing
strategies like information approval, ETL process,
Movement of information utilizing Talent, and
distributed computing. the Georgia Groundwork of
Development "Georgia Tech" Relationship for an
Undeniable Level Figuring Environment Speed bunch
used computerization to migrate research enrolling data
from the old Rich handling place (Rich) to the new
Coda server ranch Coda in 2020 [11] [12].
Level Data Movement Scaling (HDS), a powerful
Attack 6 scaling plan, for HDP Code. it simply moves
an unassuming amount of data from the old plate to the
new circle to recuperate I/O load changing among all
plates including old and new. various huge
concentrations in data migration as Techniques
Troubles, needs, frameworks, Classes, Risks, and Uses
with Disseminated registering [13] [14].
issues, for instance, growing the number of association
visits will be thwarted. For phenomenal applications,
designs a useful and dynamic data migration
computation considering the connection rule mining
model to upgrade the development execution. NET
Center works with the live migration of diligent
multilingual data in heterogeneous fogs. This paper
presents the check of the thought for live movement of
the data database of an application worked with on any
maintained fogs to any completed cloud's data store
[15] [16].
Hermes is stamina is an informational index structure
model that, strangely, doesn't rely upon refined data
partitioning to achieve high flexibility and execution.
data (re-)distributing, and live data development by
exploring the lined trades to be executed by and by.
This presents AMANDA, a versatile middleware for
customized movement among social and non-social
informational indexes considering a client-portrayed
design a plan that offers support for different sources
and targets instructive lists. We review the presence of
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
132
Volume 2, 2022
AMANDA by evaluating the improvement in speed,
question execution, demand execution, and movement
rightness, from two Social Data databases [17] [18].
different sorts of data are used to evaluate development
and versatility, and how corresponding data sorts out
which assessment questions they can address.
implications of movement assurance. to respond to the
inquiry through an investigation of different periods of
movement, looking at conventional and novel
information sources and models at each stage. We
focus on three periods of relocation, with each stage
portraying the cutting edge and late turns of events and
thoughts [19] [20].
one more readiness test development procedure was
made to recognize unaltered arrangement tests to be
utilized in wetland assembling and change evaluations
over the Overall Shad Egan Wetland areas of
southwestern Iran. the new methodology for arranging
NoSQL arranged portion dot database social
informational collections. To show this way of thinking
has been made programming including PostgreSQL as
an RDBMS and Cassandra as a NoSQL arranged
portion database [21] [22].
to seclude the movement methodology into three
structures as shown by the cloud association models
essentially. Different cycles ought to be considered for
various advancement frameworks, and different
undertakings will be united appropriately. The target of
to ponder the highlights and system of information
improvement, investigate strategies to help information
movement among social and story information models,
and fabricate a numerical model and calculation for
information advancement [23] [24].
the security of data migration is the focal issue for
clients who use the cloud to move their data and
application. Cloud development is the apex point where
the cloud boss meets with basic issues at the hour of
data movement beginning with one association's server
and afterward onto the following server. In this survey,
simply the work depiction, and Fat records of the
legacy structure were considered, but if a plan for each
step is described from this point forward, it will, in
general, be made as a standard framework for data
movement [25] [26] [27].
2 Research Methodology
The design of the processing model has three stages:
1- Entering data from the source tables, which
processes the data entered through the visual
Basic language codes through the interfaces.
2- Adoption of two new data migration models
(A, B) homogeneous and heterogeneous
according to their classification.
3- Evaluate, check and match the processed and
staged data to the target tables by linking them
to the source tables.
The most troublesome instance of movement is the one
where the source and target data sets depend on various
advancements and simultaneously have various
information models, it is this case will be additionally
thought of and broken down in the structure of this
work. Endless supply of information development from
the source base to the objective base, the client
approaches the objective base and discards the source
base See Fig (1).
Fig 1, Process stream chart for information migration
Schematically locally depicts the process of migrating
data from tables. Regarding advancements, there are
two sorts of information movement (homogeneous, and
heterogeneous). Shows a schematic of heterogeneous
and homogeneous migration. Heterogeneous migration
is thought about when various information stockpiling
models are utilized in the source and target data sets.
Arrangement by information model classes all the more
precisely mirrors the degree of intricacy of information
relocation contrasted with the dispersion of data set
frameworks.
The data in tables ( ,2,31 ) is homogeneous data entered
from the interfaces that were designed in the Visual
Basic applications) VBA), the data is processed in the
interface through codes and then this information is
transmitted to the target tables (1,2,3) See Fig (2) Model
A.
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
133
Volume 2, 2022
Fig 2, Scheme of the Homogeneous (Model A)
Sheets (4,5) for which heterogeneous information and
data are transferred by forming a relationship with
similar columns in the target tables (1,2,3) of the for)
See Fig (3) model B.
Fig 3, Scheme of the Heterogeneous (Model B)
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
134
Volume 2, 2022
Table 1, Class A employee data
Table 2, Class B employee data
Table 3, Class C employee data
Sheet 5, Bank Data A
Sheet 6, Bank Data B
3 Proposed Framework
All the philosophy-based existing frameworks for
information mixed from homogeneous and
heterogeneous information sources manage to
incorporate information from similar sorts of
information stores (social/non-relational) however
with various outlines. Certain coordination
procedures were additionally proposed to join social
and non-social information sources. The proposed
framework consolidates the information from
Accounting sheets to recognize Representative
information, compensations, advancements, and
occupation grade changes. Putting away information
across various information sources sorts helps in
quicker recovery of the necessary information. The
Proposed framework assists the Organization and
money chiefs with questioning the Worker records
put away across different information sources
without the information on the inquiry expected to
get to them See Fig (4).
No
Gender
Job Title
Scientific Title
Salary
Benefits
Withholding
Discount
Total
No
Gender
Job Title
type of
employment
Salary
Benefits
Withholding
Discount
Total
No
Gender
Job Title
type of
employment
Salary
Benefits
Withholding
Discount
Total
Reference
Value date
Payer name
Payer account
Amount
Beneficiary name
Beneficiary account
Remittance
Information
Details of
Charges
Reference
Value date
Payer name
Payer account
Amount
Beneficiary name
Beneficiary account
Remittance
Information
Details of
Charges
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
135
Volume 2, 2022
Fig 4, Workflow System Architecture
4 Data Stores Utilized
many data stores are utilized in the proposed
framework Excel. Microsoft succeeds in accounting
sheet programming that is accessible for various
working frameworks. Succeed in corpora number-
cruncher here’s, diagramming instruments, turning
tables, and visual essentials for applications, a huge
scope programming language. Succeed-based
calculations are for the most part used for the
segmenting and limit of data, finishing computations,
information understanding, and examination,
representations and revealing, planning and
bookkeeping, timetables and schedules, managerial
and executive obligations, mechanizing dreary
errands, and determining.
5 Processing data migration
The data migration is processed through codes to link
this data with the tables linked between them in the
Model for the first stage, as in the following See Fig
(5,6).
Fig 5, data migration is processed through codes
Fig (5) Code to migrate data from the input interface
to the text list associated with the target column
number (39) of the homogeneous data model table.
Fig 6, data migration is processed through codes
6 prevent inconsistencies in target
tables
The code to migrate data from the input interface to
the text list associated with the target column number
(11) of the homogeneous data model table from the
model (A) the To heterogeneous form sheet (5) (B)
for banks See Fig (7).
Fig 7, migrate data from the input interface
The code to migrate the data from the list of texts
associated with the column number (4) of the target
in the heterogeneous data model sheet (5) (B) See Fig
(8).
Fig 8, migrate the data from the list
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
136
Volume 2, 2022
The code to migrate the data from the list of texts
associated with the column number (4) of the target
in the heterogeneous data model sheet (6) (B) for
banks See Fig (9).
Fig 9, to migrate the data from the list of texts
The transfer of an information file of type (CSV) to
banks after it has been matched with the data of the
to disburse using employees' salaries through the
electronic card See Fig (10)
Fig 10, information file of type (CSV) to banks
7 Discuss the results
In this section, we evaluate the efficiency of models
(A) and (B) by the models e feasible concerning the
tasks below:
1. Validity of Migration: Queries were
performed for each entity (in the input tables)
to guarantee that all table lines were
effectively relocated to the objective data
tables.
2. Execution of the question: Inquiries have
been made to guarantee that similar
questions can be executed in the source data
tables (Form(A) in a single target data file
and then transferred to the target information
tables.
3. Query performance: Evaluate execution time
for queries in the form (A) and This
correlation intends to check whether the
movement between various tables merits
performing.
4. Migration speed: the time required to
produce target data See Fig (11,12).
Fig 11, Query performance comparison
between tables input and table target model
(A)
Fig 12, Query performance comparison between
target model (A) and model (B)
8 Conclusion
This paper presents two models (A, B). a middleware
to move information from interface applications in
Visual Essential to Succeed bookkeeping sheets by
giving adaptability to clients in the relocation cycle,
which permits clients to pick the whole objective
accounting sheet or simply a piece of it. Moreover,
the two models (A, B) middleware gives engineering
that can be reached out to help Social data set
administration frameworks (RDBMS) and different
frameworks data sets. Experiments were performed
using excel tables, both relationaltonal source
databases, and target databases. For the source and
target datasets, the migration datasets seen in these
tables for the two models whereas calculated with the
following characteristics.
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
137
Volume 2, 2022
(1) Its adaptability in permitting clients to determine
specific tables and traits for movement, and doesn't
need that all data sets be relocated.
(2) Its versatility and coordination with any data set
given RDBMS and non-social models.
(3 ( Direct inquiry utilization mode, which doesn't
need extra bundles or other explicit information,
making it easier for the developer to use.
(4) High reliability (100%) furthermore, great
execution time in information movement.
Reference
[1] Rao, G. M., Srinivas, K., Samee, S., Venkatesh,
K., Dadheech, P., Raja, L., & Yagnik, G. (2021,
March). A Secure and Efficient Data Migration Over
Cloud Computing. In IOP Conference Series:
Materials Science and Engineering (Vol. 1099, No.
1, p. 012082). IOP Publishing
[2]Bonfitto, S., Casiraghi, E., & Mesiti, M. (2021).
Table understanding approaches for extracting
knowledge from heterogeneous tables. Wiley
Interdisciplinary Reviews: Data Mining and
Knowledge Discovery, 11(4), e1407.
[3] Tu, Y., Tang, H., Gong, H., & Hu, W. (2022). A
Flexible Data Evaluation System for Improving the
Quality and Efficiency of Laboratory Analysis and
Testing. Information, 13(9), 42.
[4] Thirumahal, R., Sudha Sadasivam, G., & Shruti,
P. (2022). Semantic Integration of Heterogeneous
Data Sources Using Ontology-Based Domain
Knowledge Modeling for Early Detection of
COVID-19. SN Computer Science, 3(6), 1-13.
[5] Gao, C. (2019). Research on the Application of
Big Data in Security Information Collection.
[6] Rowland, D., & May, P. M. (2019). Progress in
Aqueous Solution Modeling: Better Data and Better
Interfaces. Journal of Solution Chemistry, 48(7),
1066-1078.
[7] Aruna, M. G., Hasan, M. K., Islam, S., Mohan, K.
G., Sharan, P., & Hassan, R. (2022). Cloud-to-cloud
data migration using self-sovereign identity for 5G
and beyond. Cluster computing, 25(4), 2317-2331.
[8] Azeroual, O., & Jha, M. (2021). Without data
quality, there is no data migration. Big Data and
Cognitive Computing, 5(2), 24.
[9] Hillenbrand, A., Störl, U., Nabiyev, S., & Klettke,
M. (2022). Self-adapting data migration in the
context of schema evolution in NoSQL
databases. Distributed and Parallel Databases, 40(1),
5-25.
[10] Saranya, N., Brindha, R., Aishwariya, N.,
Kokila, R., Matheswaran, P., & Poongavi, P. (2021,
March). Data Migration using ETL Workflow.
In 2021 7th International Conference on Advanced
Computing and Communication Systems
(ICACCS) (Vol. 1, pp. 1661-1664). IEEE.
[11] Liu, F. C., Weiner, M. D., Manalo, K., Jezghani,
A., Blanton, C. J., Stone, C., ... & Lara, R. (2021,
December). Human-in-the-Loop Automatic Data
Migration for a Large Research Computing Data
Center. In 2021 International Conference on
Computational Science and Computational
Intelligence (CSCI) (pp. 1752-1758). IEEE.
[12] Yuan, Z., You, X., Lv, X., Li, M., & Xie, P.
(2021). HDS: optimizing data migration and parity
update to realize RAID-6 scaling for HDP. Cluster
Computing, 24(4), 3815-3835.
[13] Hussein, A. A. (2021). Data Migration Need,
Strategy, Challenges, Methodology, Categories,
Risks, use with Cloud Computing, and Improvements
in Its Using with Cloud Using Suggested Proposed
Model (DMing 1). Journal of Information
Security, 12(01), 79.
[14] Luo, J., Li, X., Feng, Y., & Wang, L. (2022,
April). Research on Web Big Data Migration
Algorithm base
[15] Kaur, K., Bharaniy, S., Bharania, S., Aggarwal,
K., Nayyar, A., & Sharma, S. (2022). Energy-
efficient polyglot persistence database lives
migration among heterogeneous clouds. The Journal
of Supercomputing, 1-30.
[16] Lin, Y. S., Tsai, C., Lin, T. Y., Chang, Y. S., &
Wu, S. H. (2021, June). Don't Look Back, Look into
the Future: Prescient Data Partitioning and Migration
for Deterministic Database Systems. In Proceedings
of the 2021 International Conference on Management
of Data (pp. 1156-1168).
[17] Queiroz, J. S., Falcão, T. A., Furtado, P. M.,
Soares, F. L., Souza, T. B. F., Cleis, P. V. V., ... &
Giuntini, F. T. (2022). AMANDA: A Middleware for
Automatic Migration between Different Database
Paradigms. Applied Sciences, 12(12), 6106.
[18] Kirchberger, M. (2021). Measuring internal
migration. Regional Science and Urban
Economics, 91, 103714.
[19] Sîrbu, A., Andrienko, G., Andrienko, N.,
Boldrini, C., Conti, M., Giannotti, F., ... & Sharma,
R. (2021). Human migration: the big data
perspective. International Journal of Data Science
and Analytics, 11(4), 341-360.
[02] Fekri, E., Latifi, H., Amani, M., &
Zobeidinezhad, A. (2021). A Training Sample
Migration Method for Wetland Mapping and
Monitoring Using Sentinel Data in Google Earth
Engine. Remote Sensing, 13(20), 4169.
[21] Dourhri, A., Hanine, M., & Ouahmane, H.
(2021, November). A New Algorithm for Data
Migration from a Relational to a NoSQL Oriented
Column Database. In The Proceedings of the
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
138
Volume 2, 2022
International Conference on Smart City
Applications (pp. 795-814). Springer, Cham.
[22] Amin, R., Vadlamudi, S., & Rahaman, M. M.
(2021). Opportunities and challenges of data
migration in the cloud. Engineering
International, 9(1), 41-50.
[23] Peretiatko, M., Shirokopetleva, M., & Lesna, N.
(2022). Research of Methods to Support Data
Migration Between Relational and Document Data
Storage Models. Innovative Technologies and
Scientific Solutions for Industries, (2 (20)), 64-74.
[24] Kumar, A., Dadheech, P., Singh, V., & Raja, L.
(2021). Performance modeling for secure migration
processes of legacy systems to cloud computing.
In Data Deduplication Approaches (pp. 255-279).
Academic Press.
[25] Ceresnak, R., Matiasko, K., & Dudas, A. (2021,
January). Influencing migration processes by real-
time data. In 2021 28th Conference of Open
Innovations Association (FRUCT) (pp. 1-7). IEEE.
[26] Altendeitering, M. (2021, October). Mining data
quality rules for data migrations: a case study on
material master data. In International Symposium on
Leveraging Applications of Formal Methods (pp.
178-191). Springer, Cham.
[27] Shin, H. (2021). A Study on Data Migration of
Legacy Information System.
Creative Commons Attribution License 4.0
(Attribution 4.0 International, CC BY 4.0)
This article is published under the terms of the Creative
Commons Attribution License 4.0
https://creativecommons.org/licenses/by/4.0/deed.en_US
International Journal of Computational and Applied Mathematics & Computer Science
DOI: 10.37394/232028.2022.2.18
Hassan B. Hashim
E-ISSN: 2769-2477
139
Volume 2, 2022