The persistent struggle to improve application and database performance involves constantly analyzing different aspects of your environment, workload, and configuration. There are many different aspects that interact within your environment that impact overall performance. Database and application I/O performance is one of most important aspects to analyze because it can have a tremendous positive and . . . → Read More: Three Ways to Improve DB2 Database I/O Performance
Companies are always trying everything to gain a competitive edge, but with dysfunctional data procedures, management/CIO turnover, and lean business profits, new data projects face unprecedented difficulties. With the plethora of IT trends, directions and technologies, cloud platforms, big data, and new anemic exotic scripting languages, IT personnel are getting conflicting directions for their project . . . → Read More: Three Ways to Avoid Big Data Chaos
I have talked about many DB2 SQL performance tips before (10 Performance Guidelines and Five Big Data SQL Performance Tips). Dealing recently with tables with tens of billions of rows and crazy generated SQL from GUI interfaces has resulted in these five more SQL performance tips for your big data systems. . . . → Read More: Five More SQL Performance Tips for your Big Data
While I have talked a lot about big data through this blog it is really important to remember that our, phones, iPads, Fitbits, and all computers are listening devices. Now even your car’s navigational equipment and black box can tell the latest details of your driving skills—good and bad.
So below are three things that . . . → Read More: Big Data: Three Big Brother Reminders
The last two weeks I have talked about ways to choose meaningful business analytics and then fine tune the focus of your business analytics. This week I talk about the factors needed to further fine tune your analytics into effective results for your company. Some of the ideas might even help . . . → Read More: Big Data: Four Factors to Tune your Meaningful Analytics
Last week I talked about ways to choose meaningful analytics. Here are three more ways to make the analytics even better for your big data project.
Focus the analytics only on a specific business aspect. Last week I stressed analytical focus on the money aspects. This week we need to take that focus . . . → Read More: Big Data: Three More Ways to Choose Meaningful Analytics
The NCAA tournament is going to start in a few weeks, and everyone is going to get their basketball winning prediction bracket ready. Quicken Loans, insured by Warren Buffet, is offering $1 billion dollar prize for anyone picking a prefect bracket for the NCAA tournament. While the odds for picking a prefect . . . → Read More: Big Data: Three Ways to Choose Meaningful Analytics
Today’s big data provides more analysis opportunities and puts greater pressure on every company’s business model to produce profits. Now big data analysis can be applied and used to optimize any and all phases of your company’s business model.
Customer sentiment, website clickstreams, sensor data, geo location data, all operations logs, and any structured or . . . → Read More: Three Ways to Pursue the Correct Big Data Project
The IBM DB2 Analytics Accelerator (IDAA) continues to be improved, and the Version 4.1 enhancements really help take your SQL program performance to the next level. The following five changes within Version 4.1 of IBM’s DB2 Analytics Accelerator increase its flexibility, availability, workload balancing, and sharing capabilities.
IBM DB2 Analytics Accelerator adoption rate accelerates. The . . . → Read More: IBM DB2 Analytics Accelerator: 5 Performance Enhancements in the New Version 4.1
After implementing a big database with billions of rows, it’s time to run your applications and reports. Hopefully, the database is partitioned so the applications can utilize parallelism and complete your application and reports quickly. When you begin to write your SQL against these tables, take into consideration the first set of DB2 . . . → Read More: 5 Big Data SQL Performance Tips — Fixing Generated SQL