Abstract
Traditionally, database management systems (DBMSs) have been associated with high-cost, high-quality functionalities. That is, powerful capabilities are provided, but only in response to careful design, procurement, deployment and administration. This has been very successful in many contexts, but in an environment in which data is available in increasing quantities under the management of a growing collection of applications, and where effective use of available data often provides a competitive edge, there is a requirement for various of the benefits of a comprehensive data management infrastructure to be made available with rather fewer of the costs. If this requirement is to be met, automation will need to be deployed much more widely and systematically in data management platforms. This paper reviews recent results on autonomic data management, makes a case that current practice presents significant opportunities for further development, and argues that comprehensive support for automation should be central to future data management infrastructures.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Agrawal, S., Bruno, N., Chaudhuri, S., Narasayya, V.R.: Autoadmin: Self-tuning database systems technology. IEEE Data Eng. Bull. 29(3), 7–15 (2006)
Babu, S., Bizarro, P.: Adaptive query processing in the looking glass. In: CIDR, pp. 38–249 (2005)
Babu, S., Bizarro, P., DeWitt, D.: Proactive Re-Optimization. In: Proc. ACM SIGMOD, pp. 107–118 (2005)
Barringer, H., Rydeheard, D.E.: Modelling evolvable systems: A temporal logic view. In: We Will Show Them (1), pp. 195–228. College Publications (2005)
Belhajjame, K., Embury, S.M., Paton, N.W., Stevens, R., Goble, C.A.: Automatic annotation of web services based on workflow definitions. In: International Semantic Web Conference, pp. 116–129 (2006)
Bhattacharjee, B., Glider, J.S., Golding, R.A., Lohman, G.M., Markl, V., Pirahesh, H., Rao, J., Rees, R., Swart, G.: Impliance: A next generation information management appliance. In: CIDR, pp. 351–362 (2007)
Blunschi, L., Dittrich, J.-P., Girard, O.R., Karakashian, S.K., Vaz Salles, M.A.: A dataspace odyssey: The imemex personal dataspace management system. In: CIDR, pp. 114–119 (2007)
Calvanese, D., De Giacomo, G., Lenzerini, M., Nardi, D., Rosati, R.: Information integration: Conceptual modeling and reasoning support. In: Proc. of the 6th Int. Conf. on Cooperative Information Systems (CoopIS 1998), pp. 280–291 (1998)
Chaudhuri, S., Weikum, G.: Rethinking database system architecture: Towards a self-tuning risc-style database system. In: VLDB, pp. 1–10 (2000)
Dageville, B., Dias, K.: Oracle’s self-tuning architecture and solutions. IEEE Data Eng. Bull. 29(3) (2006)
Elnaffar, S., Powley, W., Benoit, D., Martin, P.: Today’s dbmss: Dow autonomic are they? In: Proc. 14th DEXA Workshop, pp. 651–655. IEEE Press, New York (2003)
Eurviriyanukul, K., Fernandes, A.A.A., Paton, N.W.: A foundation for the replacement of pipelined physical join operators in adaptive query processing. In: EDBT Workshops, pp. 589–600 (2006)
Gounaris, A., Paton, N.W., Fernandes, A.A.A., Sakellariou, R.: Adaptive query processing: A survey. In: Eaglestone, B., North, S.C., Poulovassilis, A. (eds.) Advances in Databases. LNCS, vol. 2405, pp. 11–25. Springer, Heidelberg (2002)
Gounaris, A., Smith, J., Paton, N.W., Sakellariou, R., Fernandes, A.A.A.: Adapting to Changing Resources in Grid Query Processing. In: Pierson, J.-M. (ed.) Data Management in Grids. LNCS, vol. 3836, pp. 30–44. Springer, Heidelberg (2006)
Halevy, A.Y., Franklin, M.J., Maier, D.: Principles of dataspace systems. In: PODS, pp. 1–9 (2006)
Hellerstein, J.L., Tilbury, D.M., Diao, Y., Parekh, S.: Feedback Control of Computing Systems. Wiley, Chichester (2004)
Jacob, B., Lanyon-Hogg, R., Nadgir, D.K., Yassin, A.F.: A Practical Guide to the IBM Autonomic Computing Toolkit. IBM Redbooks (2004)
Kabra, N., DeWitt, D.J.: Efficient mid-query re-optimization of sub-optimal query execution plans. In: SIGMOD Conference, pp. 106–117 (1998)
Karlin, A.R.: On the performance of competitive algorithms in practice. In: Fiat, A. (ed.) Online Algorithms. LNCS, vol. 1442, pp. 373–384. Springer, Heidelberg (1998)
Kephart, J.O., Chess, D.M.: The Vision of Autonomic Computing. IEEE Computer 36(1), 41–50 (2003)
Kephart, J.O., Das, R.: Achieving self-management via utility functions. IEEE Internet Computing 11(1), 40–48 (2007)
Leonardi, E., Bhowmick, S.S.: Xandy: A scalable change detection technique for ordered xml documents using relational databases. Data Knowl. Eng. 59(2), 476–507 (2006)
Lightstone, S., Lohman, G.M., Zilio, D.C.: Toward autonomic computing with db2 universal database. SIGMOD Record 31(3), 55–61 (2002)
Madhavan, J., Cohen, S., Dong, X.L., Halevy, A.Y., Jeffery, S.R., Ko, D., Yu, C.: Web-scale data integration: You can afford to pay as you go. In: CIDR, pp. 342–350 (2007)
Markl, V., Lohman, G.M., Raman, V.: Leo: An autonomic query optimizer for db2. IBM Systems Journal 42(1) (2003)
Markl, V., Raman, V., Simmen, D.E., Lohman, G.M., Pirahesh, H.: Robust query processing through progressive optimization. In: Proc. ACM SIGMOD, pp. 659–670 (2004)
McBrien, P., Poulovassilis, A.: Data integration by bi-directional schema transformation rules. In: Proc. ICDE, pp. 227–238 (2003)
Paton, N.W., Raman, V., Swart, G., Narang, I.: Autonomic Query Parallelization using Non-dedicated Computers: An Evaluation of Adaptivity Options. In: Proc. 3rd Intl. Conference on Autonomic Computing, pp. 221–230. IEEE Press, New York (2006)
Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J. 10(4), 334–350 (2001)
Raman, V., Han, W., Narang, I.: Parallel querying with non-dedicated computers. In: Proc. VLDB, pp. 61–72 (2005)
Shah, M.A., Hellerstein, J.M., Chandrasekaran, S., Franklin, M.J.: Flux: An adaptive partitioning operator for continuous query systems. In: Proc. ICDE, pp. 353–364. IEEE Press, New York (2003)
Ullman, J.D.: Information integration using logical views. In: Afrati, F.N., Kolaitis, P.G. (eds.) ICDT 1997. LNCS, vol. 1186, pp. 19–40. Springer, Heidelberg (1996)
Urhan, T., Franklin, M.J., Amsaleg, L.: Cost based query scrambling for initial delays. In: SIGMOD Conference, pp. 130–141 (1998)
Walsh, W.E., Tesauro, G., Kephart, J.O., Das, R.: Utility functions in autonomic systems. In: Proc. ICAC, pp. 70–77. IEEE Press, New York (2004)
Weikum, G., Mönkeberg, A., Hasse, C., Zabback, P.: Self-tuning database technology and information services: from wishful thinking to viable engineering. In: Proc. VLDB, pp. 20–31 (2002)
Zilio, D.C., Rao, J., Lightstone, S., Lohman, G.M., Storm, A., Garcia-Arellano, C., Fadden, S.: Db2 design advisor: Integrated automatic physical database design. In: Proc. VLDB, pp. 1087–1097 (2004)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Paton, N.W. (2007). Automation Everywhere: Autonomics and Data Management. In: Cooper, R., Kennedy, J. (eds) Data Management. Data, Data Everywhere. BNCOD 2007. Lecture Notes in Computer Science, vol 4587. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-73390-4_2
Download citation
DOI: https://doi.org/10.1007/978-3-540-73390-4_2
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-73389-8
Online ISBN: 978-3-540-73390-4
eBook Packages: Computer ScienceComputer Science (R0)