Supporting Problem Solving Process of Expert System Architecture in Database Administration

Andrejs Kauliņš


The present article describes the supporting problem solving process of expert system architecture in database administration. The proposed expert system produces solutions using input data from users, also recommends a better solution according to the defined task, restrictions and given optimisation goal. To generate solutions, an expert system uses the combined method to produce a solution. The present article also describes a problem domain, where an expert system could be used. In the implementation section, system design and implementation are also introduced. Conclusion section comprises further research and development steps.


Expert system architecture; decision support; ontology

Full Text:



T. Hemdi, Vvedenie v issledovanie operacij, 6-e izdanie. Moskva: Izdateljskij dom, 2001.

“The protection of natural persons with regard to the processing of personal data and on the free movement of such data, and repealing”, Regulation (EU) 2016/679 of the european parliament and of the council of 27 April 2016 on Directive 95/46/EC (General Data Protection Regulation).

V. Marahovskij, L.Rozenblum, A. Jakovlev, Modelirovanie paralleljnyh processov. Seti Petri, Kurs dlja sistemnyh arhitectorov, programmistov, sistemnyh analitikov, projektirovschikov sloznyh sistem upravlenija, Sankt-Peterburg: Professionaljnaja literatura, IT-Podgotovka, 400 s., 2014.

Dj. Piterson, Teorija setej Petri i modelirovanie sistem. Moskva: Mir, 264 s., 1984.

A. Geller, B. Spendolini, Oracle Application Express: Build Powerful Data-Centric Web Apps with APEX. Oracle Press, 2017.

J. Greenberg, Oracle Database Object-Relational Developer's Guide 12c Release 1. Oracle corp., 2014.

A. Kaulins and A. Borisovs, “Building Ontology from Relational Database”, Information Technology and Management Science, vol. 17, pp. 45–49, 2014.

S. Staab and R. Studer, “Handbook on Ontologies”, International Handbooks on Information Systems, Springer Science and Business Media, 2013.

B. Bennett, C. Fellbaum, “Formal Ontology in Information Systems”, Proceedings of the Fourth International Conference FOIS 2006. IOS Press, 2006.

C. Murray, Oracle Spatial and Graph Property Graph Developer’s Guide, Release 12.2., 243 p., 2017.

“Oracle Spatial and Graph Property Graph Java API Reference,” 2017. [Online]. Available:

Oracle® Database New Features Guide 12c Release 2 (12.2), E49697-19, Copyright © 2015, Oracle and/or its affiliates, 2017.

T. Das, “Оracle® Database Java Developer's Guide 12c Release 2 (12.2)”, E50047-11, Copyright © Oracle and/or its affiliates, 308 p., 2017.

M. Gen and R. Cheng, Genetic algorithms and engineering design. John Wiley & Sons, 411 p., 1997.

C. M. Bishop, Neural Networks for Pattern Recognition. Oxford university press, 2005.

I. Goodfellow, Y. Bengio and A. Courville, Deep Learning. MIT Press, 2016.

C. Szepesvari, Algorithms for Reinforcement Learning. Morgan and Claypool, 2010.


  • There are currently no refbacks.

Copyright (c) 2017 Andrejs Kauliņš

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.