MIGRATION OF LEGACY DATABASE ORACLE/MS SQL TO HANA DATABASE TO IMPROVE REAL-TIME ONLINE ANALYTICAL PROCESSING AND ONLINE TRANSACTION PROCESSING FROM ONE DATA MODEL
- Version
- Download 2
- File Size 338.55 KB
- Download
MIGRATION OF LEGACY DATABASE ORACLE/MS SQL TO HANA DATABASE TO IMPROVE REAL-TIME ONLINE ANALYTICAL PROCESSING AND ONLINE TRANSACTION PROCESSING FROM ONE DATA MODEL
Authors:
Naresh Kumar Rapolu
Nareshkumar.rapolu@gmail.com
Abstract- The following research project has explored the vitality of the migration of legacy databases, specifically Oracle with MS SQL to the HANA database. This has been effective to improve the possibilities of real-time online analytical and transaction processing. It has emerged to be ethical to migrate the challenges faced while migrating to the HANA database with efficient approaches like the development of a migration plan and proposing a comprehensive assessment of existing data structures. This has paved the path for transitioning HANA databases for streamlining data management of data models.
Keywords: SAP HANA, Real-Time Online Analytical Processing, Database Migration, OLAP, OLTP, Data Models