不用SQL Server Analysis Services而直接用SQL Server做数据仓库,有问题吗?

anfield 2003-03-31 09:58:52
我的毕业设计是做销售行业的数据仓库并进行数据挖掘,本来希望用 SQL Server Analysis Services做数据仓库,但后来发现用 JSP通过页面要发送命令控制Analysis Services并非像发送SQL语言控制SQL Server各种操作那么容易,也在这里问过很多次,没人能够解决我要用JSP t通过WEB发送命令控制Analysis Services个中存操作的要求,最后决定不用Analysis Services做数据仓库,而直接用 SQL Server做,至于多维表,数据挖掘的功能,可以自己写JavaBean取得Analysi Services的功能,但我担心的是,在毕业答辩的时候,这样的折中方法行得通吗?老师会不会因为我并没有使用SQL Server专门的数据仓库技术 Analysis Services而刁难我呢?会不会说我的数据仓库并非真正意义上的数据仓库呢?请帮忙。
...全文
87 2 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
SophiaWang 2003-03-31
  • 打赏
  • 举报
回复
数据仓库涉及到的技术是多方面的,它除了包括Analysis Services外,还有关系数据库(Relation Database)、DTS(Data Transaction Services)、复制、English Query、Meta Data Services等!因此不用担心没有使用到Analysis Services而偏离了数据仓库技术!!
不过,作为毕业答辩的课题来做的话,最后还是建议你与你的项目指导老师进行沟通,看他们具体是个什么要求!!!以免违背了他们的要求,而使毕业设计失败!!
祝好运~~~
anfield 2003-03-31
  • 打赏
  • 举报
回复
谢谢你,到底你上面所说的Analysis Services,关系数据库(Relation Database)、DTS(Data Transaction Services)、复制、English Query、Meta Data Services 能否都用JSP通过SQL访问控制?

不用SQL Server Analysis Services而直接用SQL Server做数据仓库,有问题吗?
Understand Microsofts dramatically updated new release of its premier toolset for business intelligence. The first major update to Microsofts state-of-the-art, complex toolset for business intelligence (BI) in years is now available and what better way to master it than with this detailed book from key members of the products development team. If youre a database or data warehouse developer, this is the expert resource you need to build full-scale, multi-dimensional, database applications using Microsofts new "SQL Server 2012 Analysis Services" and related tools. Discover how to solve real-world BI problems by leveraging a slew of powerful new Analysis Services features and capabilities. These include the new DAX language, which is a more user-friendly version of MDX; PowerPivot, a new tool for performing simplified analysis of data; BISM, Microsofts new Business Intelligence Semantic Model; and much more. This title serves as an authoritative guide to Microsofts new "SQL Server 2012 Analysis Services" BI product and is written by key members of the Microsoft Analysis Services product development team. It covers "SQL Server 2012 Analysis Services", a major new release with a host of powerful new features and capabilities. Topics include using the new DAX language, a simplified, more user-friendly version of MDX; PowerPivot, a new tool for performing simplified analysis of data; BISM, Microsofts new Business Intelligence Semantic Model; and, a new, yet-to-be-named BI reporting tool. This title explores real-world scenarios to help developers build comprehensive solutions. Get thoroughly up to speed on this powerful new BI toolset with the timely and authoritative "Professional Microsoft SQL Server 2012 Analysis Services with MDX".

22,299

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧