Data access method of oracle relational database based on procedure call interface

Abstract

The invention discloses a data access method of an Oracle relation database based on the program call interface, which includes four steps: the field information of the target data table is acquired; the key value class and the content class data are obtained through mapping; the operation class code of the target data table is generated through the program call interface; the data of the target data table of the database is accessed. The key value class, the content class data and the operation class code are generated by the automatic tool software; the operation class code is generated on the basis of the bottom Oracle call interface (OCI) of the Oracle relation database so that the operation class code has good generality and portability, operates in various operating systems, supports the C / C++ language mapping and has high running efficiency; the operation class code generates the encapsulated reusable codes for the common database operation and adopts the same access method towards all the target databases so that the operation difficulty is lowered greatly and the programming efficiency is improved.

Description

technical field [0001] The invention relates to the field of computer databases, in particular to a data access method of an Oracle relational database based on a program calling interface. Background technique [0002] With the development of computer information technology, Oracle, as an excellent relational database, plays an important role in more and more applications. Oracle has a wide range of applications in many fields due to its superior stability and excellent performance. Its high performance is the key factor that makes Oracle superior to other databases. Now there are many solutions for data access of Oracle relational database, many products provide solutions for data access and processing of Oracle database, such as ADO.NET, etc. Strict requirements; In addition, although Oracle provides technologies such as Pro*C / C++ for database access, it is cumbersome to use and difficult to debug, and only one interface tool is provided, and all database access codes an...

AI Technical Summary

Problems solved by technology

[0004] Aiming at the defects such as poor versatility, complex operation and low efficiency of the current data access technical solutions of Oracle relational databases, the present invention provides a data access method for Oracle relational databases based on a program call interface, which is simple to operate, easy to implement and generate High code execution efficiency can avoid writing a large number of database access codes, and can shield data access details, improve development efficiency, and reduce development difficulty

Images