|
|
此文章由 henda 原创或转贴，不代表本站立场和观点，版权归 oursteps.com.au 和作者 henda 所有！转贴必须注明作者、出处和本声明，并保持内容完整
原帖由 ccj5124 于 2006-1-12 17:34 发表 
报表只是最后的展示。
规范的报表，我们用jsp做好了界面，用户只需点击日期和查询范围即可出月报周报日报，但是报表结果是我们用存储过程每天晚上计算出来的；jsp是这里面最次要的东西，关键就是了解需求然后编写存储过程。 ...
DW is conceptual, any tools work just fine, what you need to master is either bill inmon's or kimball's methodology, either topdown or bottomup, that matter a lot for the job you are applying, at least in Australia and Europe.
to learn different tools there is always developer version free to download. cognos has free version available online, SQL has express version free for developer, it even has the whole basic bi solution built and ready for download, adventureworks.
organisations are moving to self-sufficient reporting technology, find out cognos reporting server, qlikview, edgeBI from crystal report.
I don't understand how you can develop your own DW tools for reporting, unless it is just a plain simple spreadsheet or bar chart, then a simple table and SQL query data extraction will do the work. For data mining and OLAP you will need tools for optimization, ROLAP, MOLAP, near realtime, data mining algorithm, perspective, linked cubes etc, there is a lot more in DW than just extracting data every night and making sure SCD runs correctly.
if you have no idea how to install BI/DW tools and environments for testing, you are probably not worth a grain of what you called yourself. developing data extraction package is only an ETL developer, not a DW developer. |
评分
-
查看全部评分
|
宠物秀-我家帅哥-长耳 (2007-4-18) 笨鼠 
楼主:ccj5124
发表于 2006-1-12 16:34
