Problems in datawarehousing 1

[sairaochowdary]

Hi guys
i have some doubts in datawarehousing.
1.can we use reporting tools with OLTP.
2.can we use OLTP instead of OLAP.
3.what is the limitation in indexing


Thanks
Sairaochowdary

 

[johnherman]

1. Reporting tools can be used against OLTP systems, but in most situations, the use of these tools while transactions are occuring will degrade the performance of the OLTP. This is a major reason why data warehouses are implemented.
2. OLTP (On Line Transaction Processing) and OLAP (On Line Analytical Processing) are two different concepts which require different aspects to database structures and tuning. OLTP, by definition, is transaction based and concerned with only a few rows at a time. OLAP usually involves the retrieval (and analysis) of may rows of data, large sets of data.
3. Indexing is also different between OLAP and OLTP. I'm not sure what you mean by limitations.

BTW, this question would be better suited for the Data Warehousing general discussion forum rather than Cognos.

-----------------

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[DoubleD]

Well stated johnherman.
A star for you for an excellent explanation of OLTP vs OLAP.

Pain is stress leaving the body.

DoubleD

 

[johnherman]

Thanks DoubleD. You might also like the following little quip about OLTP and OLAP.

OLTP systems are designed, built, and optimized to put data into database systems, one or two rows at a time.

OLAP systems are designed, built, and optimized to get data out of database systems, sets at a time.

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[MDXer]

sairaochowdary,

What type of doubts do you have? If you can provide specific areas of concern maybe you will get some useful answers.

As john stated you would be better off addressing your concerns in the

Data warehousing general discussion forum

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck