Information Management Academic Community Updates
PatFletcher 060001U06U Tags:  latin america in columbia im database box a brazil informix 2,084 Visits
Just heard about several successful Informix programs that were held recently in Columbia:
Great initiative by these schools and our IBMers as well! This grass roots movement is creating lots of excitement for the Information Management products in Latin America.
We are also getting GREAT response to the DB2 Academic Associate Certification programs in South America, and have a lot of classes organized: http://www.ibm.com/developerworks/wikis/display/im/DB2+Academic+Associate+Workshop
Contact imschool@us,ibm.com if you want to discuss getting a program started at your university and we will talk!
I was excited to receive this report about the first of the three DB2 Academic Associate Certification workshops held in Budapest, Hungary:
31 August – 2 September 2010
Budapest IBM Innovation Center organized its first free DB2 Fundamentals and Application Development course for university students and teachers between 31 August and 2 September 2010. Despite the fact that we announced the course in the middle of the summer and planned it for 24 participants, more than 100 students and teachers applied. Because of the big demand we decided to add two additional workshops in October for those whom we could not accept in September.
The workshop began at 9 a.m. and finished at 5 p.m. every day at the IBM Innovation Center (IIC), where Ferenc Rada, the leader of IIC welcomed the participants, then Tamás Piri (IIC) delivered the education in Hungarian.
First the students got better acquainted with the IBM DB2 database and the parts of application development, then after the theoretical part they could practice the operational and development tasks with hands on labs in the perfect educational environment of the IIC. The students also received education materials in the form of a course work book and a DVD to be able to practice their knowledge on their own time after the class.
Besides the professional education, the students could hear about the current IBM trainee positions and they could ask questions to János Ponczók from HR. Then Szilvia Kovács (from Software Marketing) spoke about the 48 hours programming contest in November, where everyone can try their fresh knowledge that they gained at the workshop, and the best students will get valuable prizes.
At the end of the 3 day course the participants could take a free exam in English in an internationally approved exam system. The best students got IBM gifts at the end of the course.
We can say in general that the students were quite receptive to learning about the DB2 database and database concepts, which was totally new for them. This was reflected very well by their questions and their interest all during the course.
There were 21 participants at the September course from 7 higher educations: Budapest University of Technology and Economics (7), University of Debrecen (1), Eötvös Loránd University (2), Dennis Gabor Applied University (1), Pannon University (3), Pázmány Péter Catholic University (3), University of Pecs (3) and University of Szeged (1). In October participants from
Additional information about the DB2 Academic Associate Certification program available here.
PatFletcher 060001U06U Tags:  certification 556 informix professional ai database im 1 Comment 2,264 Visits
A new professional certification, the Informix 11.50 Application Development Certification, has just been published; http://www-03.ibm.com/certify/tests/ovr556.shtml
This is great timing as the new Redbook on Informix Application Development has also recently been made available. http://www.redbooks.ibm.com/redpieces/abstracts/sg247884.html
The Redbook covers a variety of application development tools: Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate
You can get a no-charge Linux virtual image of the Informix 11.50 product, including their client developer kit, from the Informix on Campus website: http://www.informixoncampus.blogspot.com/
This image can be used on both Windows and Linux systems, and is a quick way to get up and running and ready to do application development on Informix
PatFletcher 060001U06U Tags:  initiative academic education database faculty university db2 certification 2 Comments 4,784 Visits
Kudos to the AI team and the IBM Innovation Center in Hungary! They held two additional training and certification testing sessions in October for the Information Management DB2 Academic Associate Certification program. They took the time to get feedback from the students on the program, and provided the following write-up and pictures:
Because of the big demand from university teachers and students for the DB2 Fundamentals and Application Development workshop held at the Budapest Innovation Center, we decided to add two additional courses in October (5-7 and 19-21 October) for those whom we could not participate in September.
We had 42 participants from 7 universities at the two October workshops: Budapest University of Technology and Economics (7), University of Debrecen (1), Eötvös Loránd University (9), Dennis Gabor Applied University (3), West Hungarian University (1), University of Óbuda (1), Pannon University (1), Peter Pazmany Catholic University (1), University of Pécs (2), University of Szeged (1) and College of Dunaújváros (1).
This time we were interested in the participants’ opinion about the course so you can a read a short review of student feedback below.
Most of the students heard about the workshop through their university correspondence list and some of them through ONIK (which is a group for university informatics students) or the IBM Academic Initiative newsletter sent to faculty members who belong to this free program.
Why did you apply for the course?
Because we were interested to learn more about IBM’s DB2 software and to widen our knowledge, as this was a unique education on a topic that we don’t learn at the university. It was also tempting because the course and the exam at the end are free and the certification we got can be put on our CV as well. For those who already worked in the database area, it was a good way to deepen their knowledge.
Did you learn database management earlier?
There is basic database management at almost all universities; most students learn SQL as part of that course. But this was the first time that we could try a database program in practice, with the integrated hands on labs that are included as part of this program.
Were you aware of the DB2 product before this course?
Students were familiar with the DB2 name, but they did not have the chance to use the actual software previously. Editor’s note: Students attending the course each receive a DVD to keep that contains a Linux virtual image of the DB2 Express-C and Data Studio products. Students can continue to use the software after the course for other school projects and for further learning and investigation
How could the DB2 course material be used further in your university?
It could be made available as an optional lesson or practice lab in the curricula. Also, if there would be more posters about IBM software at the universities, students would be more aware. Editor’s note: Faculty members, the course is organized in modules with appropriate teaching materials, scripted notes and integrated hands on labs so that it can be easily incorporated in your curricula. The DB2 Academic Associate Program site contains additional information on this program
What was your opinion about the workshop?
It was a very useful course with good atmosphere at a pleasant place. According to some participants it’s a pity that these three days are so tough and it would be much better if they could learn for one week in the late afternoon and evening hours. According to others it is great that the course was scheduled into the three full day course. It was much more convenient for those who come from the countryside or who work and have to take some days off. Editor’s note: The course can be organized a number of ways to best meet the needs of the faculty and students. It was also very positive that we could meet the IBM HR colleague so we could get a more complete view about the career opportunities at the company. The server room was also very popular among us as we don’t get a chance everyday to see such large capacity servers.
How hard was the exam?
The exam itself was not so difficult as more than half of the participants passed it, but it was hard that the questions were in English and we had to take the exam on the last day of the course. Editor’s note: The exam is available in four languages: English, Spanish, Chinese and Portuguese. It would have been much better if the exam had been a bit later so we had more time to prepare for it (such as for the university exams). But some other participants were very happy that the exam was at the end of the course as they didn’t have to come to
Where will you be able to use what you learned?
It will be useful to be able to list this course and certification when we apply for job. It will also be useful at our workplace (for those students also working). The content is also good to learn because it covers content that is common to any relational database. One thing is for sure: it was worth coming to the workshop.
PatFletcher 060001U06U Tags:  ibm informix im initiative management academic ids ypp database information 3,040 Visits
Young professionals building successful careers using IBM Information Management products
Alexandre Marini – Informix DBA improving database performance in Brazil
Meet Alexandre Marini, an Informix Database Administer working in
He currently works at the Local State Financial Department of Mato Grosso do Sul (Secretaria da Fazenda do MS). Read below to learn more about Alexandre’s role maintaining the government database systems and some of the technical challenges he faces on the job.
Typical day for a database administrator
As a database administrator, Alexandre is responsible for operating two types of systems for the MS government. The Informix-based OLTP (Online Transaction Processing) systems manage the daily transactions for tax documents in the state. These databases are integrated with the larger Brazilian national tax system. They are also connected into the mail system and aid in preventing tax evasion. Alexandre manages eight instances of the OLTP environment.
Alexandre also manages one instance of an OLAP (Online Analytical Processing) database. This instance is optimized for handling Decision Support System (DSS) queries that generate supervisory and executive management reports. The OLAP database contains historical data from the OLTP system and other data sources that enable the government to observe longer term trends and analyze metrics to make better business decisions.
Technical challenges on the job
Alexandre works hard to keep his databases healthy and fully available for his customers. He continues to improve his skills as evidenced by completing two Informix professional certifications last May (Informix Dynamic Server 11.50 Fundamentals and System Administration for Informix Dynamic Server) He also stays current with new Informix features and functionality. These skills helped him solve a challenge when a disk space problem shrank the amount of available disk space to a critically low level. Alexandre implemented the Informix Storage Optimization feature to compress the data and shrink the amount of disk space required for the database. This enabled the database instance to be back up and running smoothly on the existing, smaller number of disks in no time.
- Informix just released an exciting new version, v11.7, in October 2010. Read more about this feature-rich release at http://www.ibm.com/developerworks/data/products/informix/.
- Two versions of the Informix product are available at no cost and can be downloaded from the web. You can learn more about all of the Informix versions at http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/
- Faculty members who belong to IBM’s free Academic Initiative (http://www.ibm.com/developerworks/university/academicinitiative/) can also access free courseware covering Informix data topics as well as courseware covering Infosphere Data Architect and Data Studio.
Favorite aspect of the job
Alexandre loves the enthusiastic environment that surrounds his job and the atmosphere that encourages continued study and new technology skill growth. Alexandre describes his job environment, stating, “I’ve got great work friends here. We are always helping others, giving technical suggestions to help other teams improve their work quality and solve some of their problems.”
Alexandre is also very excited to be working with the Brazilian Informix User Group and increasing the visibility of this group within his work community.
Technical skills required on the job
The core computer science, database and operating system concepts Alexandre learned in school continue to be important for understanding and finding solutions to database management problems. He describes their importance, stating, “That gave me critical knowledge to recommend hardware and installation techniques to other teams, improving overall database performance.”
Why Informix over other databases?
During the acquisition period at the local state financial department in MS, the Informix family of products were highly recommended by other government bureaus in Pride in accomplishment Alexandre is proud of developing encrypted reports that prevent tax fraud. He is also proud to have implemented some Informix data replication features that improved the overall structure of the database system and lowered the amount of resources required to manage the database environment. Alexandre continues to improve his database skills and is looking forward to continue to work with big enterprises, implementing high availability on environments, partaking in systems migrations, and spreading Informix features and benefits throughout the marketplace over the next several years. Advice to peers pursuing a similar career path Alexandre would give the following advice to his peers, “Make an effort to thoroughly learn all the concepts; this will help to apply your knowledge into different areas of technology. Recommended Links
Pride in accomplishment
Alexandre is proud of developing encrypted reports that prevent tax fraud. He is also proud to have implemented some Informix data replication features that improved the overall structure of the database system and lowered the amount of resources required to manage the database environment.
Alexandre continues to improve his database skills and is looking forward to continue to work with big enterprises, implementing high availability on environments, partaking in systems migrations, and spreading Informix features and benefits throughout the marketplace over the next several years.
Advice to peers pursuing a similar career path
Alexandre would give the following advice to his peers, “Make an effort to thoroughly learn all the concepts; this will help to apply your knowledge into different areas of technology.