Method and apparatus for converting script language SQL of Oracle

Abstract

The invention provides a method and an apparatus for converting a script language SQL of Oracle. The method comprises the steps of according to a conversion request input by a user, obtaining a to-be-converted SQL script file of Oracle; analyzing the to-be-converted SQL script file to generate an analytic result; according to the analytic result and a pre-obtained mapping relationship between the script language SQL of Oracle and a script language of a target database system, generating clauses of a script statement of the target database system, wherein the target database system is Hive or Hbase; and converting the clauses of the script statement of the target database system into an executable script file of the target database system. According to the method for converting the script language SQL of Oracle, the SQL script file of Oracle can be conveniently and quickly converted into script files of other database systems.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for converting Oracle script language SQL. Background technique [0002] In the traditional information technology (IT, Information Technology) industry, large-scale application systems mostly use professional relational database products to build their database systems. Among them, Oracle database occupies the largest market share. Oracle uses advanced structured query language (SQL, Structured Query Language)-based large-scale relational database, generally speaking, it is a collection of a large number of regular data manipulated in a language that facilitates logical management, and is currently one of the most popular client / server architecture databases. [0003] Under a certain data scale, Oracle provides good support for the system's data storage, access and management, but in today's deepening informatization, the data scale that the system needs to carry and...

AI Technical Summary

Problems solved by technology

Oracle uses SQL, and HBase uses a custom shell to create tables, query, and update data, while Hive uses the SQL-like language HiveQL to implement data operations. The main problems caused by this difference are: First, the application needs Writing different data access codes for Oracle, HBase, and Hive increases the difficulty of data integration. In addition, when the program is changed, it also needs to be modified according to different underlying data access methods, which increases the difficulty of maintenance; second, the legacy system Difficulties in upgrading. For example, when many enterprises consider migrating IT assets to big data platforms, a big problem is the transformation of legacy systems, and the core of which is the modification of data access layer codes.

The code volume of large-scale enterprise-level IT systems is often in the millions, which means that any change to the system may involve a large number of modifications, and the upgrade of the data access layer mainly involves the traditional relational database (such as Oracle) SQL Rewriting, if it is completely rewritten by programmers manually, it will require a huge amount of work

Images