Information Management Academic Community Updates
It was so nice to see this article posted on an Informix event in Campo Grande, Brazil, that was taught by our December Young Professsional Alexandre Marini: http://informixoncampus.blogspot.com/2011/06/informix-on-campus-in-brazil.html
Thanks to Alexandre (and his wife Vanessa) and also to Miguel Carbone for their great initiative to spread the word about Informix to their university community!
To learn more about Alexandre, you can read our article about him that was posted in Dec 2010:
PatFletcher 060001U06U Tags:  ibm informix initiative im management academic ids ypp database information 3,080 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.
Not only did Informix recently release a new, exciting version of their product (Informix 11.7), but the Informix team has also been busy adding classes to the Academic Initiative courseware site. Faculty and their students can now gain access to **SEVEN** additional Informix courses on the Academic Initiative web site. You can find these courses in the Information Management section of the Academic Initiative web site:
You have to scroll down a bit since we are getting quite a few courses out there (but that is a GOOD problem to have....)
Check out the courses, and if you have any questions, email them to firstname.lastname@example.org
Skill Level: Introductory
Informix Structured Query Language V 11.5 (IX130)
Informix Stored Procedures and Triggers V 11.5 (IX711)
Skill Level: Intermediate
Informix Dynamic Server 11 Database Administration: Managing and Optimizing Data V 11 (IX221)
Informix Dynamic Server 11 System Administration (IX811)
Skill Level: Advanced
Informix Dynamic Server 11 Performance Tuning (IX401)
Informix Dynamic Server 11 Internal Architecture (IX911)
Informix Dynamic Server 11 Replication (IX421)
PatFletcher 060001U06U Tags:  certification 556 informix professional ai im database 1 Comment 2,284 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:  latin america in columbia im database box a brazil informix 2,101 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!
Glad to report on a new Informix Redbook: IBM Informix Developer's Handbook: http://www.redbooks.ibm.com/redpieces/abstracts/sg247884.html
It's a great guide to the many different interfaces for application development on Informix. It covers Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate. Check it out!
PatFletcher 060001U06U Tags:  university academic management db2 information education initiative informix databases 2 Comments 2,439 Visits
Welcome to the Information Management Academic Community Updates for Faculty Blog!
I would like to use this blog to post interesting information relevant to the academic community. Please feel free to comment and let's discuss things further! The IM Academic Community Marketing team is really interested in hearing your views about what you are seeing and hearing from your vantage point, whether that be as a university professional or a student or a business leader or an IBMer. Let us know where you see needs and we will work together to help out.
We will also use this forum to post interesting profiles of Young Professionals doing interesting real-world projects using IBM technology to learn what they are finding valuable in their early careers and what helped them get to their current positions in the first place.
Today, let me point you to this interesting study by the IBM Institute for Business Value: http://www-931.ibm.com/tela/webmail/Newsletter/7486/22705
The Strategy and Change Section points us to a report: Inheriting a Complex World It can be downloaded for the complete version.
Both CEOs and current student leaders were interviewed about what future leaders will need to be successful in our complex world. Several points jumped out at me.
- Today's current CEOs talked about creativity and and adventurous spirit being very critical. This seems to be SO important, yet often overlooked while trying to ensure that a high amount of knowledge and skills are imparted to our students in always too short a time.
- Both CEOs and students also noted how important the correct analysis of trends is/will be. CEOs noted this relative to operational dexterity and students comment on making decisions using more data. Will databases have been around for a long time now, their importance continues to grow. As does the amount data to be analyzed. Students need a strong knowledge of database fundamentals to understand how data can be managed and what capabilities are possible with data analysis. IBM has a large portfolio of data analysis products and tools. Let's work together to use these tools to teach students what they need to learn to be successful for their future.