Home » Developer & Programmer » Data Integration » OLAP
OLAP [message #93325] Wed, 14 July 2004 00:03 Go to next message
Messages: 5
Registered: August 2003
Junior Member
if i am going to deploye an simple database application i need a single computer for server and i can create a database according to requirment.

now if i want to run an avreage type of OLAP application please guide me minimum and maximum number of computers and how i can run OLAP application on it.

also the major difference between OLAP , OLTP and DWh application and their deployment

Re: OLAP [message #93326 is a reply to message #93325] Wed, 14 July 2004 05:02 Go to previous message
Messages: 170
Registered: April 2002
Senior Member
I can only tell you that OLAP and DW are the same.

OLTP is a transaction processing system, let's say a ticket plane salling system, or a hotel booking reservation system. That database will have several inserts and update to the tables.

OLAP (or DW) is only a huge database to query and extract information. It's intended to be used by desision making.

I hope you understand.
I cannot reply your entire question because i'm anot an expert in this issue.
Previous Topic: OWBv3 migration to OWBv9
Next Topic: Return value 2 while running the OWB Mapping package in SQL
Goto Forum:

Current Time: Mon Oct 26 05:56:20 CDT 2020