OSCAR中嵌入式SQL的设计与实现

Design and Implementation of the Embedded SQL System in OSCAR

实现了一个嵌入式SQL系统,支持在C语言中嵌入SQL语句。该系统是对象关系型数据库管理系统OSCAR客户端的重要组成部分,分为两部分实现:预处理模块和ESQL运行库。预处理模块根据ESQL语言的语法规则分析和识别ESQL语句,并且转换为实现相同功能的C语言函数调用;ESQL运行库实现这些C函数,通过网络通信库与服务器端通信,并执行SQL语句,返回结果值。

To enable an embedding of SQL statements in C language, the embedded SQL system is implemented. The system plays a crucial role in the client part of OSCAR, an object relational database management system. It includes two components: preprocess module and ESQL runtime library. The former parses ESQL statements with the syntactic rules of ESQL language, and translates them into corresponding C function calls. The latter implements the C functions that communicate with the server via network communication library. The server then executes the SQL statements and returns results to the client.