当前在线人数12726
首页 - 分类讨论区 - 电脑网络 - 数据库版 -阅读文章
未名交友
[更多]
[更多]
文章阅读:Re: 请教sql server DB 大侠
[同主题阅读] [版面: 数据库] [作者:xlxie] , 2007年01月25日22:21:38
xlxie
进入未名形象秀
我的博客
[上篇] [下篇] [同主题上篇] [同主题下篇]

发信人: xlxie (三老爷), 信区: Database
标  题: Re: 请教sql server DB 大侠
发信站: BBS 未名空间站 (Thu Jan 25 22:21:38 2007)

If your DB is only used to record inserting data and seldom do delete or
update.
Then, you can record update/insert date as a seperate column.
Use "select into" to do incremetal load and
if your DB is big, you will have to think about table partition.

For OLAP reporting, do you need the data warehouse and mart at the same
server
or you need a data warehousing server and a mart server?
different approach will lead to different design.

restore backups is not a quite efficient way.
If you have to do it, do a full back up weekly and incremental/differential
backup daily.
If you want to do OLTP => OLAP, that is not the solution.

Probably you will endup using DTS/SSIS to transfer the data between your
Production server and reporting servers.
Some coding will need to be done to make that happen.

【 在 mirthcyy (百无聊赖) 的大作中提到: 】
: production DB is OLTP. We do want a OLAP to do the reporting. But because
of
:  time constraints, we will only starts with OLTP dbs copying to offline
: servers insteading of doing all reporting on OLTP dbs right now.
: It's easy to get the backup of OLTP dbs and restore them on the offline
: servers, but it seems not very efficient. If we want to make changes on
: offilne server dbs like tuning index better for reporting, it has to be
made
:  every time we restore them from production dbs. So I'm wondering how we
can
:  do the incremental load like sql data compare does
: We do think about the replication but the architecture is not set up right
: now so we couldn't use it.
: ...................



--

※ 来源:·BBS 未名空间站 http://mitbbs.com·[FROM: 69.138.]

[上篇] [下篇] [同主题上篇] [同主题下篇]
[转寄] [转贴] [回信给作者] [修改文章] [删除文章] [同主题阅读] [从此处展开] [返回版面] [快速返回] [收藏] [举报]
 
回复文章
标题:
内 容:

未名交友
将您的链接放在这儿

友情链接


 

Site Map - Contact Us - Terms and Conditions - Privacy Policy

版权所有,未名空间(mitbbs.com),since 1996