嵌入式SQL的应用

The Application of Embedded SQL

数据库应用系统开发中,用高级语言来写数据库应用程序时,可以用ODBC/CLI,也可以用嵌入式SQL.如果是用ODBC/CLI,则你的高级语言程序中调用ODBC/CLI的各种API函数.属于底层开发,用嵌入式SQL方式写程序执行效率更高。用嵌入式SQL的概念和实现的方法,用DBMS预编译器和开发工具,对两种开发和调用SQL的方式进行了详细地分析和比较,实现了用嵌入式SQL这种调用方法可以提高对数据库的性能和效率。

ODBC/CLI or embedded SQL may be used in the development of database application system with high-level language.With the using of ODBC/CLI,a variety of API function is called,it belongs to the underlying of the development.With the using of embedded SQL,programe excution is more efficient to write.Two kinds of development and the way in calling SQL are analysed and compared in detail.To apply such a call using the embedded SQL method can improve the database performance and efficiency.