Category Archives: Data Warehousing

New Methods to Optimize Data Warehouse Performance and Lower Costs

Data warehouses tend to grow very quickly because they integrate data from multiple sources and maintain years of historical data for analytics.  A number of our customers have data warehouses in the hundreds of terabytes to petabytes range.  Managing such a large amount of data becomes a challenge.  How do you curb runaway costs in such an environment?  Completing maintenance tasks within the prescribed window and ensuring acceptable performance are also big challenges.

We have provided best practices to archive aged data from data warehouses.  Archiving data will keep the production data size at almost a constant level, reducing infrastructure and maintenance costs, while keeping performance up.  At the same time, you can still access the archived data directly if you really need to from any reporting tool.  Yet many are loath to move data out of their production system.  This year, at Informatica World, we’re going to discuss another method of managing data growth without moving data out of the production data warehouse.  I’m not going to tell you what this new method is, yet.  You’ll have to come and learn more about it at my breakout session at Informatica World:  What’s New from Informatica to Improve Data Warehouse Performance and Lower Costs.

I look forward to seeing all of you at Aria, Las Vegas next month.  Also, I am especially excited to see our ILM customers at our second Product Advisory Council again this year.

 

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Archiving, Data Governance, Data Warehousing, Database Archiving, Enterprise Data Management | Tagged , , , , , , , , | Leave a comment

Informatica World Healthcare Path

Join us this year at Informatica World!

We have a great line up of speakers and events to help you become a data driven healthcare organization… I’ve provided a few highlights below:

Participate in the Informatica World Keynote sessions with Sohaib Abbasi and Rick Smolan who wrote “The Human Face of Big Data”  — learn more via this quick YouTube video: http://www.youtube.com/watch?v=7K5d9ArRLJE&feature=player_embedded

With more than 100 interactive and in-depth breakout sessions, spanning 6 different tracks, (Platform & Products, Architecture, Best Practices, Big Data, Hybrid IT and Tech Talk), Informatica World is an excellent way to ensure you are getting the most from your Informatica investment. Learn best practices from organizations who are realizing the potential of their data like: Ochsner Health, Sutter Health, UMass Memorial, Qualcomm and Paypal.

Finally, we want you to balance work with a little play… we invite you to network with industry peers at our Healthcare Cocktail Reception on the evening of Wednesday, June 5th and again during our Data Driven Healthcare Breakfast Roundtable on Thursday, June 6th.

See you there!

FacebookTwitterLinkedInEmailPrintShare
Posted in Application Retirement, B2B, Complex Event Processing, Data Integration, Data Integration Platform, Data masking, Data Migration, Data Warehousing, Healthcare, Informatica Events, Master Data Management, Uncategorized | Tagged , | Leave a comment

Turn the Data Warehouse into a Glass House

Jim Harris, OCDQ

The data warehouse’s goal is timely delivery of trusted data to support decision-enabling insights. However, it’s difficult to get insights out of an environment that’s hard to see inside of. This is why, as much as is possible given the necessities of data privacy, a data warehouse should be turned into a glass house, allowing us to see data quality and business intelligence challenges as they truly are.

Trusted data is not perfect data. Trusted data is transparent data, honest about its imperfections, and realistic about the practical trade-offs between delivery and quality. You can’t fix what you can’t see, but even more important, concealing or ignoring known data quality issues is only going to decrease business users’ trust of the data warehouse. Perfect data is impossible, but the more control enforced wherever data originates, and the more monitoring performed wherever data flows, the better overall data quality will be in the warehouse. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Privacy, Data Quality, Data Warehousing | Tagged , | 1 Comment

Data Chaos: Public Enemy Number One

This year marks the 20th anniversary for Informatica. Twenty years of solving the problem of getting data from point A to point B, improving its quality, establishing a single view and managing it over its life-cycle. Yet after 20 years of innovation and leadership in the data integration market, when one would think the problem had been solved, all data had been extracted, transformed, cleansed and managed, it actually hasn’t — companies still need data integration. Why?  Data is complicated business. And with data increasingly becoming central to business survival, organizations are constantly looking for ways to unlock new sources of it, use it as an unforeseen source of insight and do it all with greater agility and at lower cost. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Big Data, CIO, Data Integration, Data Integration Platform, Data Warehousing | Tagged , , , , , , , | Leave a comment

Is It Time For a New ICC Book?

In a recent visit to a client, three people asked me to autograph their copies of Integration Competency Center: An Implementation Guidebook. David Lyle and I published the book in 2005, but it was clear from the dog-eared corners and book-mark tabs that it is still relevant and actively being used today.  Much has changed in the last seven years including the emergence of Big Data, Data Virtualization, Cloud Integration, Self-Service Business Intelligence, Lean and Agile practices, Data Privacy, Data Archiving (the “death” part of the information life-cycle), and Data Governance.  These areas were not mainstream concerns in 2005 like they are today.  The original ICC (Integration Competency Center) book concepts and advice are still valid in this new context, but the question I’d like readers to comment on is should we write a new book that explicitly provides guidance for these new capabilities in a shared services environment? (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Governance, Data Integration, Data Quality, Data Services, Data Warehousing, Integration Competency Centers | Tagged | Leave a comment

I Can’t Describe It, “But I Know It When I See It”

So wrote Potter Stewart, Associate Justice of the Supreme Court in Jacobellis v. Ohio opinion (1964). He was talking about pornography. The same holds true for data. For example, most business users have a hard time describing exactly what data they need for a new BI report, including what source system to get the data from, in sufficiently precise terms that allow designers, modelers and developers to build the report right the first time. But if you sit down with a user in front an analyst tool and profile the potential source data, they will tell you in an instant whether it’s the right data or not. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Data Integration, Data Migration, Data Quality, Data Services, Data Warehousing, Enterprise Data Management, Integration Competency Centers, Profiling | Tagged , , , | Leave a comment

A Cloud Connector for Google’s Big Data Analytics

Today Informatica announced that we have joined Google’s Cloud Platform Partner Program, with the introduction of a true cloud-based connector for Google BigQuery. Taking advantage of the power of social media, Google made the announcement through their Developer Blog, noting that the new members of their partner program will, “make it much easier to automatically load data from a broad set of sources, as well as to analyze and visualize the data with spectacular dashboards. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Cloud Computing, Data Integration, Data Synchronization, Data Warehousing, PaaS, SaaS | Tagged , , , , , , , , , | Leave a comment

It’s All About Connecting the Dots

Before the kids got out of class for the summer, my daughter’s fourth grade class was learning about product marketing.  Her teacher is a good friend of ours and she knows I work with Informatica’s product marketing teams a great deal, so she asked, or I think it was closer to volunteered me to come into the class and talk a little about marketing concepts.

I have taken plenty of marketing classes in college, and have worked closely with marketing teams throughout my career; however, I’m not really qualified to talk marketing, but I mean they are fourth graders, how hard could it be right?

(more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in data replication, Data Warehousing, Partners, Uncategorized | Leave a comment