scottishpoet schrieb:
> "I would define a DSS query as complex and long running query" is no
> doubt how IBM would define it too.
[quoted text clipped - 17 lines]
>>
>> Joerg
"Complex" is a very nice word always ;-)
I would like to know how IBM defines DSS / OLTP query. IBM gives advices
for systems using DSS queries, but how should I know if the queries on
my system are DSS queries ?
Is a 2,3 or 4 join query a DSS query already ?
TBP - 28 Oct 2006 13:11 GMT
> scottishpoet schrieb:
>> "I would define a DSS query as complex and long running query" is no
[quoted text clipped - 26 lines]
>
> Is a 2,3 or 4 join query a DSS query already ?
Isn't the V10 Information center (centre) great :)
Stick in oltp and you get :
OLTP applications are often used to capture new data or update existing
data. An order-entry system is a typical example of an OLTP application.
OLTP applications have the following characteristics:
* Transactions that involve small amounts of data
* Indexed access to data
* Many users
* Frequent queries and updates
* Fast response times
Stick in DSS and you get :
DSS applications often report on or consolidate data that OLTP
operations have captured over time.
These applications provide information that is often used for
accounting, strategic planning, and decision making.
Data in the database is typically queried but not updated during DSS
operations.
Typical DSS applications include payroll, inventory, and financial reports.