Big Data: Five Simple Database Design Performance Tips

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

Big Data: DB2 SQL Performance Is Faster Using OLD TABLE

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

Big Data: 3 Keys for Effective Big Data Success

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

3 Big Data Issues: Security, Governance and Archiving

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

Big Data: IBM’s Mainframe Customers Base Grows

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

Java Performance: Three Java Performance Testing Considerations for Architects

There exists a wide variety of performance tuning techniques for optimizing any type of application. Java performance with all of its intricacies presents more challenges. Lies, damn lies, and Java performance statistics truly need to be gathered many different ways to validate your performance. The following three key areas in Java performance can really help . . . → Read More: Java Performance: Three Java Performance Testing Considerations for Architects

DB2 Performance Lessons from the Facebook IPO Failures

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

DB2 10 Performance Improvements

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

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

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.