We accept

Database Migration and Structures: Bee Colony Optimization

Abstract: It really is compulsory for two servers to be appropriate when you have to either transfer or export the data. All the machines have unique standard protocol service by which they communicate. It isn't easy for a server to directly transmit or have the data from some other server. A live example is the developed rules at different websites like JAVA, Aesthetic Studio as well as others. This task becomes more advanced as it pertains to communication of data along using its architecture. This newspaper targeted their work in migrating the data from one server to some other by using XAML protocol where three machines have been included to migrate the data. The first server is the server from where in fact the data needs to be migrated, the second server is the server where data is fetched to be migrated and the third server is the server where data needs to be migrated. The entire work has been performed using Development tool visual studio 2010 with data bottom part connection with SQL SERVER 05. With this paper we are proposing a technique for migration of the platform architecture combined with the data with perfect reliability to another cloud system using Simple Bee Colony Search engine optimization (BCO) concept will take a lot of effort because of the sophisticated architecture of something protocol. This may lead to a new age in the cloud processing.

Keywords: BCO, Data Migration, XAML, SQL SERVER 05.


Cloud computing can be an Internet based computing technology, where in fact the expression 'cloud' means Internet and 'processing' identifies services that can seen directly online. Cloud provider sustains the 'cloud' data server or cluster that is assortment of computer to provide processing services on a sizable scale. For providing both software services as well as management services this size can be used. Any device like Personal computers', tablets, smartphones, etc. personal provides access to cloud computing services, as these devices can hook up to the internet. This is because the technology infrastructure of cloud processing is not based on consumer premises. Cloud computing comes in various forms, styles, and sizes as there may be variety of cloud formations [1].

Cloud Computing can be also described as type of application and program. Platform methods to supply the machines or machines; machine can be online or physical. Machines can be configure and reconfigure. Kind of application will depend on the demand of its consumer, various resources can be found over the internet through cloud computing. Resources come in varieties - hardware and software resources can be utilized in scalable and adaptable manner. Also the expenses can be reduced.

There are mainly three areas of cloud processing:

  • Iaas (Infrastructure as a Service) - amount crunching, data safe-keeping and management services (computer machines).
  • SaaS (Software as something) - 'web founded' applications (like Gmail).
  • PaaS (Platform as a Service) - essentially an operating system in the cloud like Google AppEngine [2].

Data migration the term 'migration' is the process of moving from one location to another. Along the way of Data migration, the data is transferred between various computer systems, storage types, or forms. To accomplish an automatic migration, data migration is usually performed programmatically.

To give a competent data migration method, data is mapped to the new system from the prior old system providing a design by data loading and data removal. Programmatic data migration consists of many steps but it typically includes data removal in which the data from the old system writes to the current system [3].

In migration, to enhance the quality of data, eliminate the redundancy or invalid information, manual and automated data cleaning is mainly done. Before deploying to the new system, various migration steps like planning, extraction, loading, cleaning and verification are largely repeated for most applications whether of high or average complexity.

Four major types of data migration:

  • Software migration
  • Repository migration
  • Safe-keeping migration
  • Business process migration
  1. BEE COLONY Marketing (BCO):

The bee colony marketing (BCO) has been recently unveiled as new way in neuro-scientific Swarm Intelligence. There is a colony of honey bees that can extend their selves within the long distances. To exploit large number of food bees expand itself in multiple guidelines at the same time. The unnatural bees represent the agencies, which collectively solves complicated problems.

The algorithm BCO is influenced by the initial behavior of the bees' in character. By creating colony of manufactured bees, BCO can successfully used to resolve complex problems. The tendencies of the unnatural bees is partially like the action of bees' in characteristics and partly dissimilar to the patterns of bees' in mother nature.

The BCO algorithm is actually, based on society. The population of the man-made bees looks for the valid solution in the population. An man-made bee solves complicated problems and referred to as real estate agents. One solution is produced to the every problem by the manufactured bees [4].

Bee colony optimization includes two stages:

A) Forward cross: In onward cross, search space is explored by every man-made bee, also obtains a fresh solution and improves the perfect solution is and then bees' again go back to the nest.

B) Backward pass: After bees' get back to the nest they shared the solutions of various information.


Consiglio Nazionale delle Ricerche et. al (2012) explain the working above the cloud platforms going back few decades. According to him the overall migration issue increases when your data is not secure at the main one platform. Now the issue comes that whether we can transfer the data with the architecture from one end to some other. He suggested that if we may use the TCP/IP approach to discover of which server the data is likely to be migrated in case we can configure it to the server from where in fact the data needs to be migrated can change lives in to the migration but he did not talk about how an existing structures allows the next server to be configured into itself [5].

Diva Agawam discusses the server compatibility, matching to them as a basic network the PC equipments have been over, with the popularization of technology of embedded system and the internet. Traditional Ethernet fields are infiltrated from embedded equipments. Besides Computer, there are several inserted gadgets as nodes present. End user can easily send the correlative information if he has the web server being able to access agreement. The administrator can easily control and validate the gadgets but being able to access it over IP, is a superb challenge [6].

R. SUCHITRA said that in cloud environment, there is need of Server consolidation of online machines for cost slicing and energy saving. With live migration server loan consolidation can be achieved of online machines. For Server Loan consolidation, we propose a been packing algorithm which is customized to lessen the instantiation of new servers and to all the migrations that aren't necessary. The algorithm is simulated using multiple test instances and using java. For live migration of online machines, ideas are extracted from the decreasing strategy of First Fit algorithm [7].

Jayson Tom Hilter talks about the Cleaning soap proto contacting in his words. Cleaning soap is a messaging construction, based on XML. Over the internet for exchanging formatted data, Cleaning soap is specially designed. It could be understand with the exemplory case of sending the entire documents and using reply and need messages or. It is not affected with the various operating system, programming languages, or system of distributed processing. A more successful way was needed to explain the messages and exactly how these text messages are communicated. The WSDL (Web Services Information Words) is a specific form of XML Schema, carried out by Microsoft and IBM for determining the XML meaning, its operation, and its protocol mapping of any web service used during SOAP or other XML protocol [8].

Qura-Tul-Ain Khan, Said Nasser "talks that cloud computing is a computing platform which is present in large data center. To provide cloud processing resources various issues occurs like level of privacy issues, security, and access, regulations, trustworthiness, electricity and other issues. In every field cloud processing is able to address the servers to satisfy their wide selection of needs [9].


The proposed architecture migration system has been put in place using VSUAL STUDIO 2010. The performance of varied repository migration and structures migration system is analyzed and discussed. Two servers minimum are involved in the info migration. To migrate the structures system by using XAML vocabulary pattern preventing the time hold off of the info migration and guaranteeing the security analysis of the data getting migrated. The purpose of this work is justified when the data along with the structures is migrated to some other platform. To achieve the goal, a mid level XAML architecture would be drawn which would show the compatibility with both server. In the process, the middle server would first evaluate the architecture of the first server from where the data has to be migrated and would make the XAML for it. As XAML is one of the most light weight dialect and it is supported by all other platforms also, it would be easier for the next server to adapt the language. The middle server would do amendments in the local XAML according to the architecture which needs to be migrated to another sever. After the second XAML is generated, it would use the TCP IP protocol service combined with the SQL Query injector to copy the XAML from one end to some other and would migrate the structures completely.

The successful migration of the structures is reviewed by various parameters. Three parameters are widely-used:

  1. Accuracy
  2. Reliability
  3. Error rate

Accuracy: Accuracy and reliability is the proximity of measurement results. Here we express the correctness in conditions of percentage. Ratio varies from 0-100. Here we attain the best accuracy that means data is migrated efficiently [10].



TN is the number of true negative cases

FP is the amount of fake positive cases

FN is the number of wrong negative cases

TP is the number of true positive cases

Fig. (a) Accuracy graph

As shown in the above graph, maximum exactness is gained i. e, 95% plus more than this. With this proposed model for migration accuracy and reliability achieves best results.

Reliability: Consistency is the ability of a component or something to execute the tasks efficiently for confirmed time under provided conditions. It's the Consistency and validity of test results motivated through statistical methods after repeated trials without degradation or failure [11].



R(t) = reliability

e = exponential (2. 178)

= failure time

m = mtbf (mean time between failures)

t = time

Fig. (b) Trustworthiness graph

As shown in above graph, maximum correctness is obtained i. e, 93% and even more than this. On this proposed model for migration trustworthiness achieves best results.

Error Rate: An Error rate is a deviation from correctness or correctness. A 'oversight' is an error the effect of a mistake: the problem being misjudgment, carelessness, or forgetfulness [12].



, (energy per little bit to noise vitality spectral density proportion) or,

Es/ (energy per modulation sign to noise density).

Fig. (c) Mistake Rate graph

As shown in above graph, bare minimum mistake rate is attained i. e, 5%. Within this proposed model for migration error rate is very less.

As mentioned previously the three guidelines are evaluated from the proposed work. Accuracy, Reliability and Error rate, all three variables achieves best results.

Accuracy (%)

Reliability (%)

Error rate (%)
















Table I: Reliability, Reliability and mistake rate prices (in %) computed from different data's schemas that are migrated.

Fig. (d) Graph represents above table values per variety of time execution

The above amount has two axis x-axis symbolizes the amount of time the execution occurs and y-axis symbolizes the percentage of most three variables.


This research has a great opportunity in reducing the strain within the server to provide the optimized result. In such a work done till now, it successfully migrates the produced architecture and its data to some other server. Here proposed a new approach predicated on Bee Colony Optimization (BCO) technique and Go Daddy server. The transfer accuracy is almost 90-95 percent. For successful migration XAML is used, as XAML is one of the very most light weight dialect and it is supported by all other platforms also, it might be easier for the second server to modify the language. Problem rate is very less, therefore the proposed approach is effective in migration.

In future, this process can be applied to the system with an increase of than two servers in the migration. The existing system does not examine any computation time for the analysis that how much time has been elapsed in the transfer. So in future time elapsed in transferring the data taken into account. Also, the copy of the data is limited i. e. in the generation of the structures system; you should not generate greater than a fixed variety of columns.

More than 7 000 students trust us to do their work
90% of customers place more than 5 orders with us
Special price $5 /page
Check the price
for your assignment