Autonomic features of the IBM DB2 universal database for linux, UNIX, and windows

Author

Garcia-Arellano, Christian M. ; Lightstone, Sam S. ; Lohman, Guy M. ; Markl, Volker ; Storm, Adam J.

Author_Institution

IBM Toronto Lab., Markham, Ont.

Volume

36

Issue

3

fYear

2006

fDate

5/1/2006 12:00:00 AM

Firstpage

365

Lastpage

376

Abstract

Thevast majority of the world´s structured data are now stored and managed by relational database management systems (RDBMSs). These systems provide powerful data management capabilities. However, as the power and functionality of these systems has grown, so has the complexity of their administration. In this paper, we show how the IBM DB2 Universal Database for Linux, UNIX, and Windows (DB2 UDB) product has exploited autonomic computing to reduce this administration complexity and become more self-managing. We survey the major autonomic computing features in the DB2 UDB product and describe the benefits, with experimental data in some cases

Keywords

Linux; relational databases; IBM DB2 Universal Database; Linux; RDBMS; UNIX; Windows; administration complexity; autonomic computing; data management; relational database management systems; Energy management; Humans; Linux; Physics computing; Power system management; Relational databases; Spatial databases; Storms; Trademarks; Transaction databases; Automation; DB2; IBM; autonomic computing; database; physical database design; self-managing; tuning; workload;

fLanguage

English

Journal_Title

Systems, Man, and Cybernetics, Part C: Applications and Reviews, IEEE Transactions on

Publisher

ieee

ISSN

1094-6977

Type

jour

DOI

10.1109/TSMCC.2006.871572

Filename

1629201