A Context-based Prototype for decision making in database administration

Hassane TAHIR


Decision Support Systems (DSS) have a great role in assisting decision makers in many organizations to identify and solve problems in order to make decisions. In the area of database management, many approaches have been used to automate procedures set for complex activities such as performance and database recovery. However, procedures need to be contextualized in order to take into account the permanent changing of technical and social contextual elements added in DBA (Database Administrator) practices. This paper presents a context-based prototype for decision making to support experts in database management and administration. The prototype uses a software-modeling tool called Contextual Graphs (CxG).  


Contextual Elements; Contextual Graphs; Database Administration; DBA; Decision Support System; Intelligent Assistant System; Practices; Procedures; Prototype for decision making

Full Text:



A. Bouramoul, M.-K. Kholladi, and B.-L Doan, Using Context to Improve the Evaluation of Information Retrieval Systems. International Journal of Database Management Systems ( IJDMS), Vol.3, No.2, May 2011.

P. Brézillon, From expert systems to context-based intelligent assistant systems : a testimony. The Knowledge Engineering Review, 26(1) : 19-24, 2011.

P. Brézillon, Task-realization models in Contextual Graphs. Modeling and Using Context (CONTEXT-05), A. Dey, B.Kokinov, D.Leake, R.Turner (Eds.), Springer Verlag, LNAI 3554, pp. 55-68, 2005

P. Brézillon, and J.-C. Pomerol, Contextual knowledge and proceduralized context. In Proceedings of the AAAI-99 Workshop on Modeling Context in AI Applications, Orlando, Florida, USA, pages 16–20, 1999.

M. Chiarini, Provenance for System Troubleshooting,

http://static.usenix.org/event/tapp11/tech/final_files/Chiarini.pdf, Workshop on the Theory and Practice of Provenance (TaPP), Heraklion, Greece, June, 2011.

A. Dogac, B. Yürüten, and S. Spaccapietra, “A Generalized Expert System for Database Design”, IEEE Transactions on Software Engineering, Volume 15, Issue 4, April, Page 479-491, 1989.

R. Dollinger, Sql lightweight tutoring module - semantic analysis of sql queries based on xml representation and linq, in `Proceedings of World Conference on Educational Multimedia, Hypermedia and Telecommunications 2010', AACE, Toronto, Canada, pp. 3323-3328, 2010.

S. Elfayoumy, and J. Patel, Database Performance Monitoring and Tuning Using Intelligent Agent Assistants. IKE 2012, in Hamid R. Arabnia, Leonidas Deligiannidis, Ray R. Hashemi Editors, WORLDCOMP’12, July 16-19, Las Vegas Nevada, USA, CSREA Press, 2012.

A. C. Moraes, A. C. Salgado, and P. A. Tedesco, AutonomousDB: a Tool for Autonomic Propagation of Schema Updates in Heterogeneous Multi-Database Environments. IEEE, Fifth International Conference on Autonomic and Autonomous Systems, April, 20-25, pp. 251-256, 2009.

Oracle, Grid Control Agent, 2013

Available at: http://www.oracle.com/technetwork/oem/grid-control/downloads/agentsoft-090381.html.

P. Palvia, "An Interactive DSS Tool for Physical Database Design," Information Sciences, Vol. 54(3), April, pp. 239-262, 1991.

S. Risco, and J. Reye, Evaluation of an Intelligent Tutoring System used for Teaching RAD in a Database Environment. Proceedings of the Fourteenth Australasian Computing Education Conference (ACE2012), Melbourne, Australia. Conferences in Research and Practice in Information Technology (CRPIT), Vol. 123, Michael de Raadt and Angela Carbone, Ed. Australian Computer Society, Inc, 2012.

I. Spiegler, and D. Widder, "Physical Database Design: A Decision Support Model", Data Base, Vol. 24,3 August, pp. 5-11, 1993.

H. Tahir, and P. Brézillon, A Context-based approach for troubleshooting database problems. International Journal of Computer Science Issues (IJCSI), Volume 11, Issue 6, No 1, November 2014.

H. Tahir, and P. Brézillon, Contextual graphs platform as a basis for designing a context-based intelligent assistant system. In: P. Brézillon, P. Blackburn, and R. Dapoigny (Eds.): CONTEXT 2013, LNAI 8175, pp. 259-273, 2013.

Lululemon Black Friday cheap nfl jerseys Lululemon factory Outlet ny Black Friday discount tiffany outlet wholesale soccer jerseys online oakley black friday cheap nhl jerseys china cheap nfl jerseys north face black friday sale cheap nfl jerseys online Jordans Black Friday Sale 2015 Cheap Moncler Cyber Monday moncler outlet cheap soccer jerseys moncler outlet black friday cheap authentic nfl jerseys north face cyber monday Louboutin Black Friday canada wholesale cheap nfl jerseys lululemon cyber monday 2015 cheap nfl jerseys from china 2015 Cheap Moncler Black Friday Sale Moncler Cyber Monday 2015 cheap jerseys Lululemon Cyber Monday Sale jordans cyber monday deals 2015 Black Friday deals Lululemon 2015 jordan black friday 2015 Moncler Jackets Black Friday Sale 2015 Louboutin Pas Cher Black Friday 2015 Canada Lululemon north face black friday cheap wholesale soccer jerseys