Post reply

Historical data reports

  • July 5, 2006 at 11:35 am

    #76545

    Hi. We have a huge database for our website. SQL Server 2000. There are certain reports/stats that the higher management needs to view. Much of the data is historical. I want to optimize database look-ups for historical data. Basically store the historical reports in a separate database so that any looks are not complex queries, but only static results outputted. Any suggestions as to how this can be done?

    Thanks.

  • July 5, 2006 at 11:54 am

    #647585

    Sounds like you need to do some research on data warehousing and ETL.

    The absolute basics:

    Design the new DB (data warehouse)

    Set it up

    Create a DTS package (or two or three...) to move / transform the data from the old DB to the new one.

    Schedule a job to move the data on a regular basis.

    Have fun, it's one of my favorite topics...

  • July 7, 2006 at 8:38 am

    #648003

    Pam, once you move the data into the warehouse, then you've got to use MDX to query that data, right?  Is it worth it?  That's a lot of work!  Setting up the cubes...moving the data and transforming it...and then developing a custom application to query it.

    Am I thinking about this in the wrong way?

    Thanks...Chris

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply