Q
Problem solve Get help with specific problems with your technologies, process and projects.

Classifying data warehouse vendors

It appears that some 'data warehouse' solutions such as Crystal provide analysis and reporting tools without a...

central repository for all the data from disparate corporate databases. Have I understood how these solutions work so that I can classify some vendors as 'virtual data warehouse solutions' and others as real warehouse solutions?

That's correct. You need the database(s) to put the data and the means to get the data there as well as tools to facilitate getting the data out and using it.

The best way to classify the vendor offerings is:
  1. ETL -- Data movement (Extraction, Transformation and Loading)
  2. Data Management -- The database management systems
  3. Data Access tools and applications -- what to do with the data
  4. Data Modeling Tools -- Tools to facilitate the development of the data model(s) in the data warehouse environment
  5. Data Repository -- The RDBMS where the "metadata" is stored (I note you used repository to refer to the data warehouse. This is common but repository actually has this other meaning).
Take a look at how SearchCRM has classified the space on their website:
> Customer Data Issues
> Data Management
> Intro to BI
> Enterprise Information Portals
> Knowledge Management
> Decision Support Systems
> Reporting
> CRM Analytics
> Clickstream analytics
> Data quality
> Data mining

There's also a strong trend towards packaging two or more of these components into one offering. You can see some of my comments on this in my last few articles at: www.mcknight-associates.com/articles.

For more information, check out SearchCRM's Best Web Links on Data Warehousing.


This was last published in July 2002

Dig Deeper on Data governance

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Meet all of our CRM / Call Center experts

View all CRM / Call Center questions and answers

Join the conversation

6 comments

Send me notifications when other members comment.

Register

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Are there any other products besides Crystal that have this virtual ability?
Cancel
Also very interested in this topic!
Cancel
You've provided a lot of good information on this topic.
Cancel
Thanks for this!
Cancel
Definitely. Hoping for more coverage on this topic in the future.
Cancel
Same
Cancel

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataManagement

SearchSAP

SearchOracle

SearchAWS

SearchContentManagement

SearchSalesforce

Close