Migration of Stored Procedure to Distributed Cloud Database

Many legacy applications rely on a single instance relational database. In the age of big data, applications with growing popularity may continue to generate large amount of data. The data would be beyond the limit of a traditional relational database. These applications can be migrated to a distributed database system for acquiring high scalability and performance. But the migration process is complicated especially for user defined stored procedure. In order to obtain the correct behavior, a stored procedure usually has to be rewritten in the application code. This rewriting is usually a time consuming and unpleasant task. This study gives a mechanism for migrating stored procedure from single instance relational database to distributed sharded database without the need of application code rewriting. In the migration solution offered by this study, Oracle stored procedure code is parsed, analyzed, and translated so as to be stored and executed globally in a sharded database.