This thesis follows up two views on the data migration project. First of all there is a basic description of data migration within MBI model. This model is created by information technology department on the University of Economy in Prague. The thesis fills in this model data migration task and related objects as task roles or documents. In the next part the thesis focus on concrete project of implementation of core banking system. More detail is dedicated to the data migration part of this project. First there are described principles of work in data migration and next the thesis aims on data model of data migration which is used as a documentary tool. This model is evaluated from the benefits and risks view for data migration and next there are described creation and updating of it. These activities are provided mostly by macros in VBA script language, which are created here for these purposes. In the end some options of model extension are designed and evaluated.

The goal of this diploma thesis is to analyze process of migration data within the scope of SAP systems. Based on this analysis suitably desing and implement migration framework that will be used for migration of data between SAP systems. Entire migration framework and migration proces is built on technological platform SAP NetWeaver and is implemented in programming language ABAP. Functionality of the framework is presented by the case study that is represented by proper data set.

This project investigates the feasibility of migrating from an SQL database utilizing complex stored procedures to a NoSQL database, specifically focusing on the Saab application BAAS. The motivation behind the investigation is that the stored procedures are complex to maintain. The aim is to determine whether such a migration can simplify the database structure while maintaining acceptable performance levels. The study involves developing a proof of concept by translating a frequently used SQL stored procedure into application-sided logic implemented with MongoDB, a document-oriented NoSQL database. Performance tests comparing execution times of SQL stored procedures and the NoSQL alternative showed that while SQL stored procedures are faster due to primarily pre-compilation and optimized indexing, the NoSQL solution achieves acceptable execution times and offers enhanced maintainability and flexibility. This report provides a detailed evaluation of the potential benefits and drawbacks of migrating to NoSQL, emphasizing the importance of optimizing indexing strategies to close the performance gap. The findings suggest that, despite the time investment required for migration, the reduction in complexity and improved maintainability may justify the transition for organizations facing similar challenges.

Made available in DSpace on 2014-12-17T13:53:34Z (GMT). No. of bitstreams: 1 MariaITM_DISSERT.pdf: 1350553 bytes, checksum: 48697460834d64c94a81cc553077f873 (MD5) Previous issue date: 2012-08-29 / This work aims to analyze risks related to information technology (IT) in procedures related to data migration. This is done considering ALEPH, Integrated Libray System (ILS) that migrated data to the Library Module present in the software called Sistema Integrado de Gest?o de Atividades Acad?micas (SIGAA) at the Zila Mamede Central Library at the Federal University of Rio Grande do Norte (UFRN) in Natal/Brazil. The methodological procedure used was of a qualitative exploratory research with the realization of case study at the referred library in order to better understand this phenomenon. Data collection was able once there was use of a semi-structured interview that was applied with (11) subjects that are employed at the library as well as in the Technology Superintendence at UFRN. In order to examine data Content analysis as well as thematic review process was performed. After data migration the results of the interview were then linked to both analysis units and their system register with category correspondence. The main risks detected were: data destruction; data loss; data bank communication failure; user response delay; data inconsistency and duplicity. These elements point out implication and generate disorders that affect external and internal system users and lead to stress, work duplicity and hassles. Thus, some measures were taken related to risk management such as adequate planning, central management support, and pilot test simulations. For the advantages it has reduced of: risk, occurrence of problems and possible unforeseen costs, and allows achieving organizational objectives, among other. It is inferred therefore that the risks present in data bank conversion in libraries exist and some are predictable, however, it is seen that librarians do not know or ignore and are not very worried in the identification risks in data bank conversion, their acknowledge would minimize or even extinguish them. Another important aspect to consider is the existence of few empirical research that deal specifically with this subject and thus presenting the new of new approaches in order to promote better understanding of the matter in the corporate environment of the information units / Este estudo se prop?e a analisar os riscos de tecnologia da informa??o (TI) decorrentes do processo de migra??o de dados do ALEPH para o m?dulo biblioteca do Sistema Integrado de Gest?o de Atividades Acad?micas (SIGAA) na Biblioteca Central Zila Mamede (BCZM), da Universidade Federal do Rio Grande do Norte (UFRN). Assim, os procedimentos metodol?gicos tra?ados constaram de uma pesquisa explorat?ria e qualitativa, com a realiza??o de um estudo de caso na BCZM para detalhar e compreender o fen?meno. O instrumento de coleta de dados utilizado foi a entrevista semiestruturada, aplicada a (11) onze sujeitos, lotados na Biblioteca e na Superintend?ncia de Inform?tica da UFRN. Para exame dos dados utilizou-se a an?lise de conte?do, mediante a t?cnica de an?lise tem?tica. Ap?s a transcri??o, os relatos foram relacionados ?s unidades de registro e ?s unidades de contexto correspondentes ?s categorias. Os principais riscos que emergiram na transfer?ncia dos sistemas foram: a destrui??o de dados; a perda de dados; a falha de comunica??o com banco de dados da Institui??o; paralisa??o parcial do sistema; a demora no tempo de resposta para o usu?rio; a inconsist?ncia de dados e a duplicidade de dados. Como implica??es constataram-se transtornos que afetam tanto os usu?rios externos quantos os usu?rios internos do sistema, ocasionando estresses, retrabalho e aborrecimentos. As medidas para a gest?o de riscos que surgiram com maior frequ?ncia foram: um bom planejamento, apoio da administra??o central e mais simula??es de testes pilotos. Para as vantagens dessa gest?o, tem-se a diminui??o de: riscos, ocorr?ncia de problemas e custos eventuais n?o previstos, al?m de possibilitar alcan?ar os objetivos organizacionais, entre outras. Infere-se, portanto, que os riscos na convers?o de base de dados em bibliotecas existem e alguns s?o previs?veis; no entanto, verificou-se que os bibliotec?rios desconhecem ou ignoram e n?o se preocupam em identific?-los, em uma convers?o de base de dados visando a minimiz?-los ou san?-los. Outro importante aspecto a considerar ? a exist?ncia de poucas pesquisas emp?ricas, voltadas especificamente para esse tema, havendo a necessidade de novas abordagens para elucid?-lo no ambiente corporativo das unidades de informa??o

This diploma thesis deals with the selection of an appropriate information system which should help to make the company processes more effective. It should also save time and enable faster adaptation to new changes in the company PORTABELL. The first part describes the essential theory to get the reader acquainted with the issues, the second part is dedicated to the analysis of corporate environment and its trouble spots. The last part deals with the selection of the information system. The information system is chosen based on the predetermined criteria and requirements.