Data modeling best practices for Vectorwise database
2 posters
Page 1 of 1
Data modeling best practices for Vectorwise database
We will be using Vectorwise database for our reporting needs. Fastest speed for data retrieval columnar storage of data in database are some of the promises that Vectorwise comes with. Could you please provide some data modeling bast practices for this kind of a database. Customer feels that there is no need of data modeling and we can dump data as per the reporting requirements.
rathjeevesh- Posts : 15
Join date : 2013-02-16
Re: Data modeling best practices for Vectorwise database
rathjeevesh wrote:Customer feels that there is no need of data modeling and we can dump data as per the reporting requirements.
Don't you love salespeople? Data models have nothing to do with databases per se. They have everything to do with organizing the data so it is useful and supportive of current and future need. A dimensional model should work fine.
Similar topics
» Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project
» Best Practices for SCD Dimension Tables for a Banking Data Warehouse
» Is An Historical Database Always a Data Warehouse?
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» Should a data warehouse be the reporting database?
» Best Practices for SCD Dimension Tables for a Banking Data Warehouse
» Is An Historical Database Always a Data Warehouse?
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» Should a data warehouse be the reporting database?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum