Speed of thought data warehouse analytics

IBM’s System z Software Technical Sales Boot Camp at Silicon Valley Lab was last week and I was one of the few Gold Consultants who was invited to attend. This event highlights IBM’s new technology features for the IBM sales and services teams. The event presents all type of information from software enhancements, scheduled updates . . . → Read More: Speed-of-Thought Data Warehouse Analytics

Analytics Is the Answer: Two Great IBM MIT Papers

It was informative and fun attending the IOD and IDUG conferences over the last couple of weeks. There were some great presentations at the IDUG and IOD conferences and I started to go through all of them while I was traveling back and forth from Prague and traveling for the Thanksgiving holiday. Some of the . . . → Read More: Analytics Is the Answer: Two Great IBM MIT Papers

More success factors for handling Big Data and Data Warehouse Performance Part 2

Well the votes are in, 22 billion rows is big enough data. It’s not the billions of web logs rows of a Google or Facebook but its big enough for everyone. One of the comments that struck me was that one in a million happens 22,000 times. So whatever your criterion is for big data, . . . → Read More: More Success Factors for Handling Big Data and Data Warehouse Performance Part 2

Three success factors for handling Big Data and Data Warehouse Performance Part1

Was 22 billion rows Big Data? As I began the new data warehouse project, I knew that the data warehouse performance needed to be designed from the very first data element. The new project was very interesting with complex calculations, cross referencing reports and Big Data implications and big data warehouse performance challenges. Many standard . . . → Read More: Three Success Factors for Handling Big Data and Data Warehouse Performance Part 1

DB2 10 Temporal Tables Improving Performance Again

While talking to friend of mine, I learned that DB2 10 Temporal Tables continue to be a big incentive to migrate as soon as possible to DB2 10 either from DB2 Version 9 or even DB2 Version 8. DB2 Temporal Tables can dramatically improve performance of your applications that are already maintaining timestamps or dates . . . → Read More: DB2 10 Temporal Tables Improving Performance Again

Cloud Computing and Big Data New Processing Models Advantages

As I talked about cloud computing and big data over the last couple of weeks the comments have been active and great. Please keep the comments coming. First, let me make myself perfectly clear: yes, I am a cynic and data management is critical to all aspects of IT. Being cynical of any new situation . . . → Read More: Cloud Computing and Big Data New Processing Models Advantages

Data Management is Key to Cloud Computing and Big Data Success

As I talked about last week, cloud computing and big data advertising is everywhere. In my travels to conferences big data and cloud computing advertisements highlighted the airport billboard landscape. These airport billboards and magazine special advertising sections are continually saying that cloud computing and big data will reduce infrastructure costs, improve time to market . . . → Read More: Data Management is Key to Cloud Computing and Big Data Success

Get Ready for the Cloud and Its Data Management Issues

The attack of the “Special Advertising Section” is upon us. Cloud data management is being highlighted in many magazines these days as articles on cloud computing proliferate. When I recently picked up several financial- and business-related magazines at the airport, I was bombarded by Special Advertising Sections masquerading as cloud computing articles. Reading these special . . . → Read More: Get Ready for the Cloud and Its Data Management Issues

Data Pedigree Analysis Eliminates Data Sprawl

The sports commentator of the Triple Crown horse races detailed the parents of the horse, its grandparents and great grandparents and even great-great grandparents. I quickly understood the pedigree and heritage of the horses, their racing wins and very impressive successes. Horse racing pedigrees got me to thinking about a recent CIO conversation and the . . . → Read More: Data Pedigree Analysis Eliminates Data Sprawl

DB2 Temporal Table: Table Space Clustering Design for Your DB2 Data Warehouse

Table Space Clustering Design for Your DB2 Data Warehouse

Last week we talked about the partitioning choices, options and considerations. This week we’ll talk about the other important aspect of table space design, clustering. The clustering of the data can have a huge impact . . . → Read More: DB2 Temporal Table: Table Space Clustering Design for Your DB2 Data Warehouse