> 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 lookups are not > complex queries, but only static results outputted. Any > suggestions as to how this can be done?
This kind of thing is exactly what OLAP and SQL Server Analysis Services are for. Basically, you have the option to install an OLAP server as well as the standard OLTP server. OLAP databases are denormalized "cubes", which make data mining a lot easier. You'll want to read all about OLAP and Analysis Services in SQL Server Books Online, but basically what you end up with is a separate database, into which you periodically import data from your OLTP (transactional) database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245435 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
