A Context-based Prototype for decision making in database administration
Abstract
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).
Keywords
Full Text:
PDFReferences
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.