Skip to main content

Automation Everywhere: Autonomics and Data Management

  • Conference paper
Data Management. Data, Data Everywhere (BNCOD 2007)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 4587))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Agrawal, S., Bruno, N., Chaudhuri, S., Narasayya, V.R.: Autoadmin: Self-tuning database systems technology. IEEE Data Eng. Bull. 29(3), 7–15 (2006)

    Google Scholar 

  2. Babu, S., Bizarro, P.: Adaptive query processing in the looking glass. In: CIDR, pp. 38–249 (2005)

    Google Scholar 

  3. Babu, S., Bizarro, P., DeWitt, D.: Proactive Re-Optimization. In: Proc. ACM SIGMOD, pp. 107–118 (2005)

    Google Scholar 

  4. Barringer, H., Rydeheard, D.E.: Modelling evolvable systems: A temporal logic view. In: We Will Show Them (1), pp. 195–228. College Publications (2005)

    Google Scholar 

  5. 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)

    Google Scholar 

  6. 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)

    Google Scholar 

  7. 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)

    Google Scholar 

  8. 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)

    Google Scholar 

  9. Chaudhuri, S., Weikum, G.: Rethinking database system architecture: Towards a self-tuning risc-style database system. In: VLDB, pp. 1–10 (2000)

    Google Scholar 

  10. Dageville, B., Dias, K.: Oracle’s self-tuning architecture and solutions. IEEE Data Eng. Bull. 29(3) (2006)

    Google Scholar 

  11. 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)

    Google Scholar 

  12. 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)

    Google Scholar 

  13. 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)

    Chapter  Google Scholar 

  14. 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)

    Chapter  Google Scholar 

  15. Halevy, A.Y., Franklin, M.J., Maier, D.: Principles of dataspace systems. In: PODS, pp. 1–9 (2006)

    Google Scholar 

  16. Hellerstein, J.L., Tilbury, D.M., Diao, Y., Parekh, S.: Feedback Control of Computing Systems. Wiley, Chichester (2004)

    Google Scholar 

  17. Jacob, B., Lanyon-Hogg, R., Nadgir, D.K., Yassin, A.F.: A Practical Guide to the IBM Autonomic Computing Toolkit. IBM Redbooks (2004)

    Google Scholar 

  18. Kabra, N., DeWitt, D.J.: Efficient mid-query re-optimization of sub-optimal query execution plans. In: SIGMOD Conference, pp. 106–117 (1998)

    Google Scholar 

  19. 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)

    Chapter  Google Scholar 

  20. Kephart, J.O., Chess, D.M.: The Vision of Autonomic Computing. IEEE Computer 36(1), 41–50 (2003)

    Google Scholar 

  21. Kephart, J.O., Das, R.: Achieving self-management via utility functions. IEEE Internet Computing 11(1), 40–48 (2007)

    Article  Google Scholar 

  22. 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)

    Article  Google Scholar 

  23. Lightstone, S., Lohman, G.M., Zilio, D.C.: Toward autonomic computing with db2 universal database. SIGMOD Record 31(3), 55–61 (2002)

    Article  Google Scholar 

  24. 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)

    Google Scholar 

  25. Markl, V., Lohman, G.M., Raman, V.: Leo: An autonomic query optimizer for db2. IBM Systems Journal 42(1) (2003)

    Google Scholar 

  26. 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)

    Google Scholar 

  27. McBrien, P., Poulovassilis, A.: Data integration by bi-directional schema transformation rules. In: Proc. ICDE, pp. 227–238 (2003)

    Google Scholar 

  28. 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)

    Chapter  Google Scholar 

  29. Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J. 10(4), 334–350 (2001)

    Article  MATH  Google Scholar 

  30. Raman, V., Han, W., Narang, I.: Parallel querying with non-dedicated computers. In: Proc. VLDB, pp. 61–72 (2005)

    Google Scholar 

  31. 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)

    Google Scholar 

  32. 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)

    Google Scholar 

  33. Urhan, T., Franklin, M.J., Amsaleg, L.: Cost based query scrambling for initial delays. In: SIGMOD Conference, pp. 130–141 (1998)

    Google Scholar 

  34. 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)

    Google Scholar 

  35. 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)

    Google Scholar 

  36. 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)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Richard Cooper Jessie Kennedy

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics