We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

Blog: William McKnight Subscribe to this blog's RSS feed!

William McKnight

Hello and welcome to my blog!

I will periodically be sharing my thoughts and observations on information management here in the blog. I am passionate about the effective creation, management and distribution of information for the benefit of company goals, and I'm thrilled to be a part of my clients' growth plans and connect what the industry provides to those goals. I have played many roles, but the perspective I come from is benefit to the end client. I hope the entries can be of some modest benefit to that goal. Please share your thoughts and input to the topics.

About the author >

William is the president of McKnight Consulting Group, a firm focused on delivering business value and solving business challenges utilizing proven, streamlined approaches in data warehousing, master data management and business intelligence, all with a focus on data quality and scalable architectures. William functions as strategist, information architect and program manager for complex, high-volume, full life-cycle implementations worldwide. William is a Southwest Entrepreneur of the Year finalist, a frequent best-practices judge, has authored hundreds of articles and white papers, and given hundreds of international keynotes and public seminars. His team's implementations from both IT and consultant positions have won Best Practices awards. He is a former IT Vice President of a Fortune company, a former software engineer, and holds an MBA. William is author of the book 90 Days to Success in Consulting. Contact William at wmcknight@mcknightcg.com.

Editor's Note: More articles and resources are available in William's BeyeNETWORK Expert Channel. Be sure to visit today!

I was just thinking about what the unique realities of data warehousing today are. As I see it, the top realities are:

• Multiple, complex applications serving a variety of users
• Exploding data size that will continue to explode with RFID, POS, CDR, and all manner of transactional data extending back years into history
• Data latency is becoming intolerable as needs demand real-time data
• A varied set of data access tools, serving a variety of purposes, for each data warehouse
• Multiple workloads streaming into the data warehouse from varied corners of the company as well as from outside the company
• A progression towards more frequent, even continuous, loading
• Data types running the gamut beyond traditional alphanumeric types

Posted October 10, 2006 9:05 PM
Permalink | 2 Comments |


Great post.

At the same time there is some light at the end of the tunnel:
LOB systems and vendors are shipping platforms with their applications that are optimized and automate the data collection and OLAP generation

So where is the problem:
These are all separate platforms and you still need to aggregate the data in order to make your BI strategy work

Some vendors are taking a different approach that leans less on “standard BI platform” and moving towards a more realistic approach of “Standard BI application”. In that scenario an application can query simultaneously multiple sources, bring them together at the application layer and solve many complexities. Panorama software (the Company I work for) is doing just that.

The benefit: a customer can use the platform that ships with their line of business systems. A platform that is optimized and maintained automatically by the system. And while having a couple of platforms can use a single set of applications that ride on top of those existing platforms.

All true, and to "Multiple workloads streaming into the data warehouse", I would add Multiple workloads streaming OUT OF the Data Warehouse TO varied corners within the company and even to partners outside the company.

Leave a comment


Search this blog
Categories ›
Archives ›
Recent Entries ›