|
|
|
Software Central: SQL Server | | Fine tuning SQL Server for High Traffic Website | |
| Hi Suresh:
Here is a link but it talked more about OLAP products.
http://www.sgroves.demon.co.uk/olaplnks.htm
www.olapreport.com
MSDN has very good articles on how to build OLAP databases on SQLServer.
A Brief overview on OLAP to make it simple.(Don't go by technical jorgan)
OLAP is nothing but redisigning the OLTP database for faster reporting.
Consider a senario where in Wallmart is doing businness all over USA. If the wallmart top officials, Auditors want to see the sales reports then it will be night mare for them to see the reports on millions of records in the transaction table's.
Here their OLTP(Online Transaction Processing) Systems have very good normaliaed databases. So to get a report they need lot of joins over the tables.
So for better performance in reporting they will redesign the database with redundent data.
Ex:
OLTP:
ItemsMaster
ItemDetial
TransMaster
TransDetail
OLAP:
Select important columns for reporting and make all four tables into a single table or probably 2 tables based on the report requirements. So less joins and faster performance.
OLAP products have facilities to load the data needed for reporting into some sort of cubes so that there won;t be any DB hit to make reports much faster.
U can write back to me for any queries you have on OLAP.
All the best..
Posted by: Mr. Raaboyee Taraaniki Kaaboyee MLA At: 25, Sep 2004 1:52:18 AM IST
Thanks a lot RTK MLA garu!
I am using sql server.
I will start reading more about OLAP and it's concepts. I don't have any idea about it so far.
Meanwhile, if you have any links / online references that explains OLAP and migrating to OLAP and related areas, please let me know.
Thanks once again,
- Suresh
Posted by: Mr Suresh KVS At: 24, Sep 2004 11:30:27 PM IST
move to OLAP instead of OLTP.
Its not advisable to store millions of records in a single OLTP table.
If it is Oracle then create a seperate table space for only this table and store this table space separately on a different datafile and then try to index this table.
If SQL-Server then there is no way except moving to OLAP using DTS packages.
Posted by: Mr. Raaboyee Taraaniki Kaaboyee MLA At: 22, Sep 2004 0:59:33 AM IST
Hi Guys,
I am working for a client - they have more than 7 million records in a table and we need to prepare reports based on that table.
I am currently using indexes and stored procedures, but still, I am getting time out errors many times.
Can anybody advise me how to make my reports faster?
Thanks in advance....
Posted by: Mr Suresh KVS At: 2, Sep 2004 3:04:07 AM IST
| |
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
