基于C语言与SQLServer的嵌入式编程及图像处理技术

将SQL嵌入到C语言中混合编程,程序中含有两种不同计算模型的语句,一种是描述性的面向集合的SQL语句,一种是过程性的高级语言语句。两种语言各有分3-,SQL语句负责操纵数据库,而C语言语句负责控制程序流程。利用高级语言的过程性结构来弥补SQL语句实现复杂应用系统方面的不足。给出了C语言与嵌入式SQL编程在不同版本SQLServer中的图像处理应用实例。     

数据库SQL查询语句优化方法的研究

通过了解RDBMS优化器的执行策略,并分析了影响SQL查询语 句效率的因素,提出了SQL查询语句的基本优化方法,充分利用这些方法能提高SQL查询语句 的执行效率。     

SQL语言在教师管理系统中的应用

结构化查询语言SQL是一个综合的、通用的、功能极强的关系数据库语言,讨论SQL语言在教师信息管理系统中实现的方法以及如何编写和执行Select语句,并给出了具体的实例.     

基于自裁剪异构图的NL2SQL模型

自然语言转换为结构化查询语言（NL2SQL）是语义解析领域的重要任务,其核心为对数据库模式和自然语言问句进行联合学习。现有研究通过将整个数据库模式和自然语言问句联合编码构建异构图,使得异构图中引入大量无用信息,并且忽略了数据库模式中不同信息的重要性。为提高NL2SQL模型的逻辑与执行准确率,提出一种基于自裁剪异构图与相对位置注意力机制的NL2SQL模型（SPRELA）。采用序列到序列的框架,使用ELECTRA预训练语言模型作为骨干网络。引入专家知识,对数据库模式和自然语言问句构建初步异构图。基于自然语言问句对初步异构图进行自裁剪,并使用多头相对位置注意力机制编码自裁剪后的数据库模式与自然语言问句。利用树型解码器和预定义的SQL语法,解码生成SQL语句。在Spider数据集上的实验结果表明,SPRELA模型执行准确率达到71.1%,相比于相同参数量级别的RaSaP模型提升了1.1个百分点,能够更好地将数据库模式与自然语言问句对齐,从而理解自然语言查询中的语义信息。     

Semantic interpretation of a database query language

In this paper, we will discuss a system that semantically interprets a formal database accessing language and generates natural language from this interpretation. In the past, the major way of communication between a user and a database was by means of a formal language. One such language is the SQL query language. Even though constructed as a user friendly language, SQL exemplifies the same difficulties for users as do other formal languages, namely a fairly rigid syntax, the necessity of variable binding, the lack of pronouns, and in the case of erroneous queries error messages that do not provide much insight. To alleviate some of the formal language problems, yet utilize the power of the formal language, we set out to build a natural language ‘umbrella’ for the SQL user. Our goal was not to build a natural language query system, but rather to use semantic knowledge and natural language for paraphrasing the formal language (SQL) and producing error messages as a feedback mechanism. In this way we build a genuine help facility, which would not only aid the user in dealing with SQL, but also trap erroneous queries.     

SQL编译器的语义分析研究

SQL是一种结构化查询语言,它是当今的标准数据库语言,所有主要的数据库系统都使用它。文中主要讲解了基于Linux系统的SQL语言编译器语义分析方法。     

SQL语言例程化的设计与实现

本文提出了对SQL语言教学的一种处理方法,即将抽象的SQL语言例程化,使用户在输入必要的SQL语句后,便可以得到语句执行的结果,很好地实现了多媒体教学。文中重点阐述了查询语句例程化的设计分析与实现。     

T-SQL在图形设计中的应用

T-SQL是Microsoft SQL Server实现的语言,符合SQL-92标准。它是SQL Server开发人员的必备工具。本文用一个实例来说明T-SQL也能实现用数据库中的数据来进行图形设计。     

SQL语言的面向对象功能的扩展

本文首先介绍了数据库语言ＯＳＱＬ的设计思想。以面向对象的数据模型为理论依据，在标准关系数据库语言ＳＱＬ的基础上扩充了面向对象功能，设计出了一个全新的面向对象数据库语言ＯＳＱＬ。该语言既保留了ＳＱＬ原有的特性，又能支持面向对象、对象分布、对象主动行为及多媒体复杂信息的管理，是一个成功的分布式面向对象数据库语言。     

基于树状模型的复杂自然语言查询转SQL技术研究

自然语言查询转SQL(NL2SQL)是指将自然语言表达的查询文本自动转化成数据库系统可以理解并执行的结构化查询语言SQL表达式的技术.NL2SQL可以为普通用户提供数据库查询访问的自然交互界面,从而实现基于数据库的自然问答.复杂查询的NL2SQL是当前数据库学术界的研究热点,主流方法采用序列到序列(Seq2seq)的编解码方式对问题进行建模.然而,已有的工作大多基于英文场景,面向中文领域实际应用时,中文特殊的口语化表达导致复杂查询转化困难;此外,现有工作难以正确输出包含复杂计算表达式的查询子句.针对上述问题,提出一种树状模型取代序列表示,将复杂查询自顶向下分解为多叉树,树结点代表SQL的各组成元素,采用深度优先搜索来预测生成SQL语句.在Du SQL中文NL2SQL竞赛的两个官方测试集中,该方法分别取得了第1名和第2名的成绩,验证了其有效性.     

SQL Server数据库组合查询的实现方法

应用软件的开发,要求设计人员能够实现数据库信息的组合查询功能,这是软件评价的重要指标之一。本文阐述了在客户服务器环境下,使用Powerbuilder语言编程,访问SQL Server数据库时组合查询的实现方法,着重介绍SQL语言的子查询方法和PB的过滤器方法。     

基于C/C++与ORACLE9i的嵌入式SQL编程技术

The programming technology about Embedded SQL discuss the form of Embedded SQL base on C/C language and ORACLE9i DBMS in this paper. We have also discussed the communications between the sentence of Embedded SQL and C/C language and have provided the code.     

基于C／C＋＋与ORACLE9i的嵌入式SQL编程技术

针对嵌入式SQL编程技术，本文论述了C/C 语言与ORACLE9i的嵌入式SQL的形式，嵌入式SQL语句与C／C 宿主语言之间的通信．并给出了代码实例。     

分布式面向对象数据库语言OSQL的设计

本文以面向对象的数据模型为理论依据，介绍了数据库语言ＯＳＱＬ的设计思想，该语言既保留了ＳＱＬ原有的特性，又能支持面向对象，对象分布、对象主动行为及多媒体复杂信息的管理，是一个成功的分布式面向对象数据库语言。     

Intelligent SQL

Intelligent SQL is an intelligent database engine interface language which incorporates object-oriented, inferencing, and multi-media constructs. It is intended to be a powerful extension of existing SQL dialects. It also provides querying capabilities for object-oriented databases. Intelligent SQL was prototyped at Ashton-Tate. This paper discusses the main features of Intelligent SQL.     

基于四元索引结构和SQL语言的XPath优化方案

针对五元索引结构在编码上的不足,提出了更为紧凑的四元索引结构.基于该结构扩展了SQL语言,根据XML数据的底层结构实现了扩展的SQL运算符,设计了基于SQL语言的XPath优化方案.实验表明,基于四元索引结构的优化方案在性能上有了显著改善.     

一种支持流数据的查询语言

流数据的查询应用十分广泛,而标准SQL语言不支持这类查询功能,因此有必要对标准SQL语言进行扩展,以满足流数据的查询应用需求。支持流数据的查询语言StreamSQL在标准SQL语言的基础上增加了对流数据对象的处理机制,通过引入滑动窗口的概念,以支持流数据与关系表的相互转换操作,同时提供用户自定义函数功能,弥补了SQL在流数据处理方面的不足。     

Logical errors in database SQL retrieval queries

SQL is often used to express questions imposed by users. It is well known that this process is not error-free in that it may result in syntactically or semantically incorrect SQL queries. This article is meant to probe deeper into SQL queries that are incorrect, due to delusion errors. A classification of natural language questions will be introduced. The purpose of this classification is two-fold. Firstly, it gives insight into possible errors and enables us to distinguish between types of errors. Secondly, it is a means of determining the influence of measures (for instance, SQL training) that can be taken to reduce the number of aforementioned errors. For discussion, several of these measures will be presented and related to the classification.Abbreviations RA Relational algebra - SQL structured query language     

SQL/SDA: a query language for supporting spatial data analysis andits Web-based implementation

An important trend of current GIS development is to provide easy and effective access to spatial analysis functionalities for supporting decision making based on geo-referenced data. Within the framework of the ongoing SQL standards for spatial extensions, a spatial query language, called SQV/SDA, has been designed to meet such a requirement. Since the language needs to incorporate the important derivation functions (e.g., map-overlay and feature-fusion) as well as the spatial relationship and metric functions, the functionality of the FROM clause in SQL is developed in addition to the SELECT and WHERE clauses. By restructuring the FROM clause via a subquery, SQL/SDA is well-adapted to the general spatial analysis procedures using current GIS packages. Such an extended SQL, therefore, stretches the capabilities of previous ones. The implementation of SQL/SDA on the Internet adopts a hybrid model, which takes advantage of the Web GIS design methods in both the client side and server side. The client side of SQL/SDA, programmed in the Java language, provides a query interface by introducing visual constructs such as icons, listboxes, and comboboxes to assist in the composition of queries, thereby enhancing the usability of the language. The server side of SQL/SDA, which is composed of a query processor and Spatial Database Engine (SDE), carries out query processing on spatial databases after receiving user requests