Relational Database Operation Framework Based On Knowledge Representation

Relational database refers to the database that uses relational model to store data.Generally,SQL(Structured Query Language)is used to operate the data.During application,it usually exists in the application system as the data storage end.Developers need to define operation instructions according to the use requirements and execute database operations according to the generated SQL statements.The definition of operation instructions in traditional database applications is usually completed by imperative programming and object-oriented programming.It is equivalent to adding other rules and constraints on the basis of SQL to control the operation of database system.In the face of the change of operation conditions in the operation instructions,the traditional database application needs to modify the application system and operation instructions.The process is cumbersome and time-consuming.It not only needs some professional knowledge of the database,mastering the writing method of SQL statements and understanding the underlying data structure,but also has high requirements for object-oriented and imperative programming.It is extremely unfriendly to the encapsulated application system and users who do not have such knowledge.Based on this,this paper deeply analyzes the application mode of relational database,logically abstracts several database operations based on knowledge representation theory,and uses the framework representation combined with rules to represent the database operations as a unified form.Based on the above representation,research and design a SQL statement reasoning method,use the answer set language as the core language of the reasoning program,abstract the knowledge related to database operation into the acceptable logical symbols of the answer set,establish rules and constraints based on the SQL statement structure and its execution process,use the solving system to reason and solve according to the logical symbols and established rules and constraints,and generate SQL statements according to the results,The generation process of SQL statement in traditional database application is transformed into the reasoning solution process of knowledge.Based on the above theories and methods,this paper designs and implements a relational database operation framework integrating knowledge representation,receives user instructions,generates SQL statements through the reasoning and solution of the framework,and performs relevant database operations.When faced with the change of operating conditions,users do not need to write SQL statements or modify the application system.They can modify and add operation instructions by using common sense database operation knowledge such as "add,delete,modify and query".Finally,this paper carries out the offline deployment of the operation framework,shows the relevant functions of the framework,and gives the performance evaluation of the framework.The results show that the operation framework proposed in this paper can be friendly embedded into the database application system,which makes the database application operation instructions combined with the framework easy to expand,and the user's common sense database operation knowledge can realize the operation control of the database system.