Posts Tagged ‘DB2’

DB2 9.7

Monday, April 27th, 2009

A IBM acabou de anunciar uma nova versão do DB2 :)

Que tem esta versão de novo?
  1. Imensas melhorias em termos de performance.
  2. Melhor gestão automática da base de dados, menos necessidade de DBA.
  3. Melhor compressão de XML (inlined).
  4. Compressão de indexes e de documentos XML no XDA.
  5. Suporte de XML em datawarehousing.
  6. Suporte do tipo de dados XML em stored procedures.
As novas alterações representam poupanças enormes nos custos normalmente associados a uma base de dados.
Versão grátis DB2 Express-C estará disponível em Junho. Para mais informações consulta aqui a press release.

IMS Industry Bundle

Sunday, September 28th, 2008

What is a pureXML Industry Bundle?

An industry bundle is composed of test scripts and test XML messages to illustrate how to create, index and populate an XML table, how to query the stored XML using XQuery or SQL/XML and return portions of XML, how to create views on the XML messages, how to shred the XML into relational format.

What are the goals of an industry bundle?

An industry bundle for an industry has the following goals:
- to help software developers, systems programmers, and database administrators get started with DB2 9 in the context of an industry using the XML messages that are often used as an exchange format in that industry
- to enable technical IT staff to quickly demonstrate to their colleagues the capabilities of the pureXML support in DB2, e.g., the ability to:
* store, index, and query XML easily without needing to convert the XML
(shred) to relational format
* store, index, and query well formed XML conforming to specific XML
schemas in a uniform way
* query stored XML and relational data together in a straightforward way
* process stored XML as though it is relational so that existing tools
and software can still be used
* shred XML messages into relational form where required

What is IMS?

In service to the community of organizations and individuals enhancing learning worldwide through the use of technology, IMS GLC is a global, nonprofit, member association that provides leadership in shaping and growing the learning and educational technology industries through collaborative support of standards, innovation, best practice and recognition of superior learning impact.

More information at IMS.

My industry bundle was related to IMS, so I got a bunch of IMS schemas, examples and with DB2 I created the “IMS Industry Bundle”. You can download it here.

Marcelo Sousa, DB2 Ambassador

DB2 on Campus @ UM – 03/10/08

Saturday, September 27th, 2008

Friday (2008/10/3;10:00-13:00 14:30-17:30)
Anfiteatro A4, Complexo Pedagógico I, Campus de Gualtar

Getting Started with DB2
Raul F. Chong – IBM Toronto Lab
(Speech in English)

- Find out what DB2 Express-C is all about.
- Understand DB2 architecture, tools, security.
- Learn how to administer DB2 databases.
- Write SQL, XQuery, stored procedures.
- Develop database applications for DB2.
- Practice using hands-on exercises.
- Prepare for the DB2 on Campus exam.

DB2 on Campus @ UM – 02/10/08

Saturday, September 27th, 2008

Thursday (2008/10/02; 14:30-16:00)
Anfiteatro A4, Complexo Pedagógico I, Campus de Gualtar

Web 2.0 demos with DB2
Raul F. Chong – IBM Toronto Lab
(Speech in English)

DB2 version 9.5 is a hybrid data server that allows users to store both, relational and XML data natively.  IBM is making this technology available for free using the DB2 Express-C edition.  Raul F. Chong, the DB2 on Campus program manager, will be visiting your university to show you this new and exciting technology using Web 2.0 demos.

Raul will also describe the DB2 Student Ambassador program, a volunteer offering specifically designed to students.  Getting to know this product is important for application developers using Service Oriented Architecture (SOA) since it can improve performance considerably.  Having this free edition of DB2, allows students incorporate the latest technologies in their application at no cost.

DB2 on Campus @ Universidade do Minho

Thursday, September 11th, 2008

Depois de no ano passado recebermos uma apresentação sobre a tecnologia DB2 dada por Vítor Rodrigues, receberemos este ano a workshop DB2 on Campus nos próximos dias 2 e 3 de Outubro no pólo de Gualtar da Universidade do Minho.

A workshop será nos apresentada por Raul Chong, um consultor do grupo Information Management Services do IBM Toronto Laboratory com uma vasta experiencia em DB2 SQL Procedural Language.

Se quiserem ter uma ideia do evento, podem assistir a screencasts disponibilizados no blog DB2 Express-C.

Mais informações sobre o evento e inscrições serão disponibilizadas brevemente!

Qualquer duvida envia para db2minho@gmail.com

Online Testing System ready for testing!

Wednesday, April 9th, 2008

Our very own open-source online testing system is ready for testing. This will be a part of the future DB2 on Campus website having a vital role in it has it provides the authentication and testing mechanism that will be used. You can check out how to install it (Linux) here and send feedback to db2minho [at] gmail.com. Finding vunerabilities in the code would be of great assistance! :)

Open Source Online Test System

Monday, March 24th, 2008

Well the latest project developed within our group is the OSOTS. Here’s a quick preview.

If you want you can visit the project here and get the code from our git repository.

DB2 Express-C merchandise

Monday, March 24th, 2008

You can check out some nice DB2 Express-C merchandise here. Please don’t buy that ugly hat! :P

Screen-cast: METS Standard with IBM DB2 Express C using XForms a user-interface and Ruby on Rails as a Rest Web-services #3

Thursday, March 6th, 2008

Originally posted at:

Screen-cast: METS Standard with IBM DB2 Express C using XForms as user-interface and Ruby on Rails as a Rest Web-services #2

Thursday, March 6th, 2008

Originally posted at: