Abstract
The complexity of tasks and problems in the management of databases requires the development of tools for supporting database experts. For instance, in the database administration area, when problems occur, the database administrator (DBA) is frequently the first person blamed. Most DBAs work in a fire-fighting mode and have little opportunity to plan ahead or be proactive. They must be constantly ready to analyze and correct failures based on a large set of procedures. In addition, they are continually readjusting these procedures and developing practices to manage a multitude of specific situations that differ from the generic situation by some few contextual elements. These practices have to deal with these contextual elements in order to solve the problem at hand. This paper proposes to use “Contextual Graphs” formalism to improve existing procedures used in database administration. Up to now, this improvement is achieved by a DBA through practices that adapt procedures to the context in which tasks should be performed and the incidents appear. This work present a new version of the contextual graph platform as a basis for designing and implementing a context-based intelligent assistant system for supporting database administrators.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Barrett, R., Kandogan, E., et al.: Field Studies of Computer System Administrators: Analysis of System Management Tools and Practices. In: Proceedings of CSCW (2004)
Brézillon, P.: From expert systems to context-based intelligent assistant systems: a testimony. The Knowledge Engineering Review 26(1), 19–24 (2011)
Brézillon, P.: Task-realization models in Contextual Graphs. In: Dey, A., Kokinov, B., Leake, D., Turner, R. (eds.) CONTEXT 2005. LNCS (LNAI), vol. 3554, pp. 55–68. Springer, Heidelberg (2005)
Brézillon, P., Pasquier, L., Pomerol, J.-C.: Reasoning with contextual graphs. European Journal of Operational Research 136(2), 290–298 (2002)
Brézillon, P., Pomerol, J.-C.: Contextual knowledge and proceduralized context. In: Proceedings of the AAAI 1999 Workshop on Modeling Context in AI Applications, Orlando, Florida, USA, AAAI Technical Report (July 1999)
Carneiro, A., Passos, R., Belian, R., Costa, T., Azevedo Tedesco, P., Salgado, A.C.: DBSitter: An intelligent tool for database administration. In: Galindo, F., Takizawa, M., Traunmüller, R., et al. (eds.) DEXA 2004. LNCS, vol. 3180, pp. 171–180. Springer, Heidelberg (2004)
Choobineh, J., Lo, A.W.: CABSYDD: Case-based system for database design. Journal of Management Information Systems 21(3), 281–314 (2004)
Dogac, A., Yürüten, B., Spaccapietra, S.: A Generalized Expert System for Database Design. IEEE Transactions on Software Engineering 15(4), 479–491 (1989)
Elfayoumy, S., Patel, J.: Database Performance Monitoring and Tuning Using Intelligent Agent Assistants. In: Arabnia, H.R., Deligiannidis, L., Hashemi, R.R. (eds.) Proceedings of the 2012 International Conference on Information & Knowledge Engineering, IKE 2012, WORLDCOMP 2012, July 16-19, Las Vegas Nevada. CSREA Press, USA (2012)
Kandogan, E., Maglio, P.P., Haber, E.M., Bailey, J.: On the roles of policies in computer systems management. International Journal of Human-Computer Studies 69(6), 351–361 (2011)
Haber, E.M., Bailey, J.: Design Guidelines for System Administration Tools Developed through Ethnographic Field Studies. ACM (2007)
Haber, E.M., Kandogan, E., Maglio, P.P.: Collaboration in system administration. Communications of the ACM 54(1), 46–53 (2011)
Mitrovic, A., Suraweera, P., Martin, B.: Db-suite: Experiences with three intelligent, web-based database tutors. Journal of Interactive Learning Research 15, 409–432 (2004)
Mitrovic, A., Team, T.I.: Constraint based tutors. In: Woolf, B.P., Aimeur, E., Nkambou, R., Lajoie, S. (eds.) 9th International Conference on Intelligent Tutoring Systems. LNCS, vol. 5091, pp. 29–32. Springer, Montreal (2008)
Moraes, A.C., Salgado, A.C., Tedesco, P.A.: AutonomousDB: a Tool for Autonomic Propagation of Schema Updates in Heterogeneous Multi-Database Environments. In: Fifth International Conference on Autonomic and Autonomous Systems, April 20-25, pp. 251–256. IEEE (2009)
Mullins, C.S.: Database Administration. The Complete Guide to Practices and Procedures. Addison Wesley (2012)
Palvia, P.: An Interactive DSS Tool for Physical Database Design. Information Sciences 54(3), 239–262 (1991)
Pomerol, J.-C., Brézillon, P.: Context proceduralization in decision making. In: Blackburn, P., Ghidini, C., Turner, R.M., Giunchiglia, F. (eds.) CONTEXT 2003. LNCS (LNAI), vol. 2680, pp. 491–498. Springer, Heidelberg (2003)
Oracle. Enterprise Manager Agent Downloads, http://www.oracle.com/technetwork/oem/grid-control/downloads/agentsoft-090381.html
Risco, S., Reye, J.: Evaluation of an Intelligent Tutoring System used for teaching RAD in a Database Environment. In: Proceedings of the Fourteenth Australasian Computing Education Conference, Melbourne, Australia (2012)
Sowa, J.F.: Knowledge Representation: Logical, Philosophical, and Computational Foundations. Brooks Cole Publishing Co., Pacific Grove (2000)
Tahir, H., Brézillon, P.: Procedure contextualization for collaborative database administration. In: Proceedings of the 15th International Conference on Computer Supported Cooperative Work in Design, Lausanne, Switzerland, June 8-10 (2011)
Tahir, H., Brézillon, P.: Shared context for improving collaboration in database administration. International Journal of Database Management Systems (IJDMS) 5(2), 13–28 (2013)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Tahir, H., Brézillon, P. (2013). Contextual Graphs Platform as a Basis for Designing a Context-Based Intelligent Assistant System. In: Brézillon, P., Blackburn, P., Dapoigny, R. (eds) Modeling and Using Context. CONTEXT 2013. Lecture Notes in Computer Science(), vol 8175. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-40972-1_20
Download citation
DOI: https://doi.org/10.1007/978-3-642-40972-1_20
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-40971-4
Online ISBN: 978-3-642-40972-1
eBook Packages: Computer ScienceComputer Science (R0)