融合知识表示的关系型数据库操作框架

Intelligent Operation Framework for Relational Database Application

关系型数据库指采用关系模型来组织数据的数据库,需要使用结构化查询语言(SQL)来操作其中的数据,面向应用时只能按照开发者设定好的程序规则进行数据库操作,程序规则的修改和新增过程繁琐且需要一定专业度,对普通用户不友好。为提高关系型数据库应用的扩展性和普适性,利用知识表示理论对数据库操作相关知识进行概念建模,使用框架结合规则的知识表示法建立数据库操作的一般化范式,基于关系型数据库的操作特点,结合关系模型及结构化查询语句的语法语义研究设计推理算法,将面向用户的数据库操作指令抽象成逻辑符号,并将事物之间的内在联系抽象为逻辑符号间的规则约束,使用求解系统根据逻辑符号表示的规则约束进行问题求解。基于上述理论及算法,设计并实现一种融合知识表示的关系型数据库操作框架,将用户输入转化成数据库操作语句,实现数据库系统操作。由应用实例可知,所提操作框架能在与关系型数据库友好兼容的基础上嵌入应用系统,程序规则易扩展,应用系统的使用和更新维护难度低,自适应性强,可以为用户提供更加灵活智能的数据库操作管控服务。

Relational database refers to the database that uses relational model to organize data.It needs to use structured query language(SQL)to operate the data.When facing the application,it can only operate the database according to the program rules set by the developer.The process of modifying and adding program rules is cumbersome and requires a certain degree of professionalism,which is not friendly to ordinary users.In order to improve the expansion and universality of the application of relational database,this paper uses the knowledge representation theory to model the knowledge related to database operation,uses the knowledge representation method of framework combined with rules to establish the general paradigm of database operation,and studies and designs the reasoning algorithm based on the operation characteristics of relational database and the syntax and semantics of relational model and structured query sentences.The user oriented database operation related things are abstracted into logical symbols,and the internal relationship between them is abstracted into the rule constraints between logical symbols.The problem is solved according to the rule constraints represented by logical symbols using the solving system.Based on the above theories and algorithms,a relational database operation framework integrating knowledge representation is designed and implemented,user input is converted into database operation statements to realize database system operation.It can be seen from the application example that the proposed operation framework can be embedded into the application system on the basis of friendly compatibility with relational database.The program rules are easy to expand,the application system has low difficulty in use,update and maintenance,and has strong self adaptability.It can provide users with more flexible and intelligent database operation management and control services.