Computer Science ›› 2022, Vol. 49 ›› Issue (11A): 211200030-9.doi: 10.11896/jsjkx.211200030

• Big Data & Data Science • Previous Articles     Next Articles

Intelligent Operation Framework for Relational Database Application

JIANG Zong-lin, LI Zhi-jun, GU Hai-jun   

  1. College of Communication Engineering,Jilin University,Changchun 130012,China
  • Online:2022-11-10 Published:2022-11-21
  • About author:JIANG Zong-lin,born in 1996,postgra-duate,is a member of China Computer Federation.His main research interests knowledge representation and reaso-ning.
    LI Zhi-jun,born in 1971,postgraduate,senior engineer.His main research interests include intelligent reasoning and human-computer interaction techno-logy.
  • Supported by:
    Jilin Science and Technology Development Plan(20190302031GX).

Abstract: 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 rela-tional 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 ope-ration management and control services.

Key words: Knowledge representation, Knowledge reasoning, Relational database

CLC Number: 

  • TP311
[1]WINIWARTER W,KAMBAYASHI Y.Natural Language In-terfaces to Databases-An Introduction[J].Proceedings of the Workshop on Computational Natural Language Learning,1997,10:125-135.
[2]GIORDANI A,MOSCHITTI A.Generating SQL queries using natural language syntactic dependencies and metadata[C]//International Conference on Application of Natural Language to Information Systems.Berlin:Springer,2012:164-170.
[3]HALLETT C.Generic querying of relational databases usingnatural language generation techniques[C]//Proceedings of the Fourth International Natural Language Generation Conference.2006:95-102.
[4]WOODS W A,KAPLAN R.Lunar rocks in natural English:Explorations in natural language question answering[J].Linguistic Structures Processing,1977,5:521-569.
[5]GREEN B F,WOLF A K,CHOMSKY C,et al.Baseball:an automatic question—answerer[C]//Proceedings of the Western Joint Computer Conference.Los Angeles:ACM,1961:219-224.
[6]GROSZ B J,JONES K S,WEBBER B L.Readings in natural language processing[R].SRI International,Menlo Park,CA(United States),1986.
[7]POPESCU A M,ARMANASU A,ETZIONI O,et al.Modern natural language interfaces to databases:Composing statistical parsing with semantic tractability[C]//Proceedings of the 20th International Conference on Computational Linguistics(CO-LING 2004).2004:141-147.
[8]BAIK C,JAGADISH H V,LI Y.Bridging the semantic gap with SQL query logs in natural language interfaces to databases[C]//2019 IEEE 35th International Conference on Data Engineering(ICDE).IEEE,2019:374-385.
[9]SAHA D,FLORATOU A,SANKARANARAYANAN K,et al.ATHENA:an ontology-driven system for natural language querying over relational data stores[C]//Proceedings of the VLDB Endowment.2016:1209-1220.
[10]YAGHMAZADEH N,WANG Y,DILLIG I,et al.SQLizer:query synthesis from natural language[J].Proceedings of the ACM on Programming Languages,2017,1(OOPSLA):1-26.
[11]SHAH A,PAREEK J,PATEL H,et al.NLKBIDB-Natural language and keyword based interface to database[C]//2013 International Conference on Advances in Computing,Communications and Informatics(ICACCI).IEEE,2013:1569-1576.
[12]LI F,JAGADISH H V.Constructing an interactive natural language interface for relational databases[J].Proceedings of the VLDB Endowment,2014,8(1):73-84.
[13]PAN X,XU S H,CAI X R,et al.Overview of database natural language interface based on deep learning [J].Computer Research and Development,2021,58(9):1925-1950.
[14]WEI Y D.Adaptive knowledge representation and reasoning of artificial intelligence [J].Journal of Shanghai Normal University(Pilosophy and Social Sciences Edition),2019,48(1):65-75.
[15]RICCA F,DIMASI A,GRASSO G,et al.A Logic-Based System for E-Tourism[J].Fundamenta Informatica,2010,105(1/2):35-55.
[16]RICCA F,GRASSO G,ALVIANO M,et al.Team-Building with Answer Set Programming in the Gioia-Tauro Seaport[J].Theory and Practice of Logic Programming,2012,12(3):361-381.
[17]GENÇAY E,SCHÜLLER P,ERDEM E.Applications of non-monotonic reasoning to automotive product configuration using answer set programming[J].Journal of Intelligent Manufactu-ring,2019,30:1407-1422.
[18]CANIUPAN M,BERTOSSI L.The Consistency ExtractorSystem:Querying Inconsistent Databases Using Answer Set Programs[C]//Scalable Uncertainty Management(SUM 2007).Lecture Notes in Computer Science,Berlin:Springer,2007.
[19]LEONE N,RICCA F.Answer Set Programming:A Tour from the Basics to Advanced Development Tools and Industrial Applications[M]//Reasoning Web.Web Logic Rules,2015:308-326.
[20]HUANG W M,HARRIE L.Towards knowledge-based geovi-sualisation using semantic web technologies:a knowledge representation approach coupling ontologies and rules[J].International Journal of Digital Earth,2020,13(9):66-78.
[21]SHANG F H,LI X,GONG M.Research on production know-ledge representation and reasoning based on Fuzzy framework [J].Computer Technology and Development,2014,24(7):38-42.
[22]HU Q,TAO H,ZOU D Q,et al.Empirical research on commo-dity knowledge fusion based on user cognitive framework [J].Information Theory and Practice,2020,43(4):94-100.
[23]XU D,WANG H,WANG M.A conceptual model of persona-lized virtual learning environments[J].Expert Systems with Applications,2005,29(3):525-534.
[24]BOLLOJU N,SUGUMARAN V.A knowledge-based object mo-deling advisor for developing quality object models[J].Expert Systems with Applications,2012,39(3):2893-2906.
[25]ALARCÓN R H,CHUECO J R,GARCÍA J M P,et al.Fixture knowledge model development and implementation based on a functional design approach[J].Robotics and Computer-Inte-grated Manufacturing,2010,26(1):56-66.
[26]Technology-Cybernetics.Investigators at University of Sao Paulo Describe Findings in Cybernetics(MOO-MDP:An Object-Oriented Representation for Cooperative Multiagent Reinforcement Learning)[J].Journal of Engineering,2019,26(2):547-559.
[27]SHIUE W,LI S T,CHEN K J.A frame knowledge system for managing financial decision knowledge[J].Expert Systems with Applications,2008,35(3):1068-1079.
[28]GELFOND M,LEONE N.Logic programming and knowledge representation-The A-prolog perspective[J].Artificial Intelligence,2002,138:3-38.
[29]GEBSER M,SCHAUB T,THIELE S.GrinGo:A New Groun-der for Answer Set Programming[C]//International Conference on Logic Programming and Nonmonotonic Reasoning.2007.
[1] WANG Jie, LI Xiao-nan, LI Guan-yu. Adaptive Attention-based Knowledge Graph Completion [J]. Computer Science, 2022, 49(7): 204-211.
[2] MA Rui-xin, LI Ze-yang, CHEN Zhi-kui, ZHAO Liang. Review of Reasoning on Knowledge Graph [J]. Computer Science, 2022, 49(6A): 74-85.
[3] HANG Ting-ting, FENG Jun, LU Jia-min. Knowledge Graph Construction Techniques:Taxonomy,Survey and Future Directions [J]. Computer Science, 2021, 48(2): 175-189.
[4] E Hai-hong, HAN Peng-hao, SONG Mei-na. Conversion Method from Relational Database to Graph Database [J]. Computer Science, 2021, 48(10): 140-144.
[5] LU Jia-wen, YAN Li. Mapping Method from Object-relational Database to RDF(S) [J]. Computer Science, 2021, 48(10): 145-151.
[6] LAI Xin, ZENG Ji-wei. Study on Mapping Transformation from Geometric Aviation Data to Relational Database [J]. Computer Science, 2020, 47(11A): 570-572.
[7] ZHANG Chun-xia, PENG Cheng, LUO Mei-qiu, NIU Zhen-dong. Construction of Mathematics Course Knowledge Graph and Its Reasoning [J]. Computer Science, 2020, 47(11A): 573-578.
[8] LI Zhi-xing, REN Shi-ya, WANG Hua-ming, SHEN Ke. Knowledge Reasoning Method Based on Unstructured Text-enhanced Association Rules [J]. Computer Science, 2019, 46(11): 209-215.
[9] ZHENG Hong-liang, HOU Xue-hui, SONG Xiao-ying, PANG Kuo, ZOU Li. Approach for Knowledge Reasoning Based on Hesitate Fuzzy Credibility [J]. Computer Science, 2019, 46(1): 131-137.
[10] YANG De-xian, SUN Hua, YU Jiong and GUO Bing-lei. Relational Database Energy Prediction Model Based on MBRC [J]. Computer Science, 2017, 44(7): 161-166.
[11] CHEN Hui and MA Ya-ping. Uncertain Extension of Description Logic SROIQ(D) for Uncertain Knowledge Representation [J]. Computer Science, 2016, 43(Z11): 88-92.
[12] MENG Hua, YUAN Ya-yan, CHU Jie-lei and WANG Hong-jun. Topological Characterization of AGM Belief Contraction Operator [J]. Computer Science, 2016, 43(9): 87-90.
[13] GE Wei-yi, ZONG Shi-qiang and YIN Wen-ke. Keyword Search for Relational Databases Based on Offline Index [J]. Computer Science, 2016, 43(4): 182-187.
[14] ZHOU Ru-qi, CHEN Yi-qun and FENG Jia-li. Knowledge Reasoning Method Based on Extended Fuzzy Petri Net [J]. Computer Science, 2016, 43(3): 75-79.
[15] LU Fang-fang and WANG Jie. Improved Method to Process Inconsistent Answer Set Program [J]. Computer Science, 2015, 42(Z6): 542-545.
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!