Doing performance consulting, database system and application tuning exposes me to many different database designs. There are many different aspects to properly analyze a database schema design. The following five simple database design performance tips are the first five critical aspects that can be quickly analyzed and evaluated especially in the early stages of development.
. . . → Read More: Big Data: Five Simple Database Design Performance Tips
Processing rows inside the DB2 engine is always faster than trying to do the same processing within an application program or outside of DB2. A common program performance mistake is executing two SQL statements and then matching or merging the data inside the application. The DB2 engine processes the data faster through a single SQL . . . → Read More: Big Data: DB2 SQL Performance Is Faster Using OLD TABLE
Companies are more stressed and looking for every advantage or differentiator to gain the competitive advantage. Working with Big Data is in IT fashion as a way to gain new insights from customers, suppliers and partners for delivering the best products, customer service and profits. Executing these Big Data initiatives is always an interesting opportunity . . . → Read More: Big Data: 3 Keys for Effective Big Data Success
When companies and projects are considering their Big Data applications, it seems that everyone forgets the decades of advancement, computing platforms and databases technologies have gone through. Platform and database are critical to the success of your company’s Big Data initiative and choosing a mature technology can help your project succeed and give your processing . . . → Read More: 3 Big Data Issues: Security, Governance and Archiving
IBM announced its fourth quarter 2012 earnings and they discussed them last week at IBM Software kickoff that I attended with a few other Gold Consultants last week. The numbers speak for themselves and show that IBM’s Big Data solutions are being embraced by companies worldwide and probably your competitors. The discussion showed that Information . . . → Read More: Big Data: IBM’s Mainframe Customers Base Grows
Watching the Facebook IPO and followed by all the Morgan Stanley, NASDAQ and other parties bickering, pointing fingers and preparing lawsuits reminds me of many of the struggling IT projects that I have assisted with as a DB2 consultant. The failures of the Facebook IPO show how having unaligned interests always leads to failure. Even . . . → Read More: DB2 Performance Lessons from the Facebook IPO Failures
There are many great features in DB2 10 and as the system migrations happen more companies are experiencing improved performance. The clients doing migrations from DB2 Version 8 to DB2 10 are especially happy experiencing the performance improvements in DB2 Version 9 once they make it to Version 10.
There are many areas where performance . . . → Read More: DB2 10 Performance Improvements
DB2 Leads with Innovation Benefiting DB2 Business Intelligence Applications
2008 DB2 Magazine article shows how DB2 on the System Z platform supports cost efficiencies and DB2 performance for DB2 business intelligence applications.
Better DB2 Business Intelligence Performance Management
2003 DB2 Magazine article shows how to get better DB2 business intelligence performance by taking advantage of DB2 views, especially a DB2 materialized view.
DB2 9 Provides a DB2 Performance Boost
2007 DB2 Magazine provides specific examples of DB2 SELECT, DB2 FETCH and more to show how DB2 9 for DB2 zos can improve DB2 performance.