APPLICATION OF XML IN IBM DB2 9 DATABASE

Naloga obravnava uporabo XML (eXtended Markup Language) v sistemu za upravljanje z bazo podatkov IBM DB2 verzija 9. Predstavljeni so osnovni koncepti delovanja različnih baz podatkov s poudarkom na podatkovnem tipu XML. Kratko je opisan sistem DB2 9, njegov grafični vmesnik za administratorja ter pomožna orodja. Kreirana je obsežna testna baza podatkov. Prikazane so možnosti manipulacije in poizvedovanja na podatkovnem tipu XML s pomočjo poizvedovalnih jezikov Xquery in SQL/XML. Prikazana je obdelava XML-a, ko je ta shranjen v polju tipa CLOB in XML. Primerjava obdelave podatkov je pokazala, da je tehnologija "pure" XML uporabnejša kot obdelava CLOB-a. Testiranje je tudi pokazalo, da je "pure" XML v splošnem hitrejši in fleksibilnejši pristop.This research explores the usability of XML (eXtended Markup Language) in IBM DB2 9. Basic concepts of different database management systems are presented with focus on XML data type. DB2 9, it\u27s graphical user interface and tools are briefly described. Large database for testing purposes is created. Data manipulation and query is applied with query languages Xquery and SQL/XML. Processing of XML, which is stored in CLOB data type and in XML data type, is shown. The comparison showed that “pure” XML technology is more usable than CLOB data type processing. Testing have also shown that “pure” XML is generally faster and more flexible approach