Hi all,

IBM talked in the Informix performance guide about DSS and OLTP queries,
but I missed a clear definition of these two types of queries.

Is a join of 2,3 or 4 tables a DSS query already ?

In general I would define a DSS query as complex and long running query,
but what is "complex" for IBM ?

Any ideas ?

Regards ...

Joerg

"I would define a DSS query as complex and long running query" is no
doubt how IBM would define it too.

What would you define as complex? Thats probably what IBM would define
as complex too

Jörg RÃ1/4schenschmidt wrote:
> Hi all,
>
> IBM talked in the Informix performance guide about DSS and OLTP queries,
> but I missed a clear definition of these two types of queries.
>
> Is a join of 2,3 or 4 tables a DSS query already ?
>
> In general I would define a DSS query as complex and long running query,
> but what is "complex" for IBM ?
>
> Any ideas ?
>
> Regards ...
>
> Joerg

scottishpoet schrieb:
> "I would define a DSS query as complex and long running query" is no
> doubt how IBM would define it too.
>
> What would you define as complex? Thats probably what IBM would define
> as complex too
>
> Jörg RÃ1/4schenschmidt wrote:
>> Hi all,
>>
>> IBM talked in the Informix performance guide about DSS and OLTP queries,
>> but I missed a clear definition of these two types of queries.
>>
>> Is a join of 2,3 or 4 tables a DSS query already ?
>>
>> In general I would define a DSS query as complex and long running query,
>> but what is "complex" for IBM ?
>>
>> Any ideas ?
>>
>> Regards ...
>>
>> 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 ?

Joerg Rueschenschmidt wrote:
> scottishpoet schrieb:
>> "I would define a DSS query as complex and long running query" is no
>> doubt how IBM would define it too.
>>
>> What would you define as complex? Thats probably what IBM would define
>> as complex too
>>
>> Jörg RÃ1/4schenschmidt wrote:
>>> Hi all,
>>>
>>> IBM talked in the Informix performance guide about DSS and OLTP queries,
>>> but I missed a clear definition of these two types of queries.
>>>
>>> Is a join of 2,3 or 4 tables a DSS query already ?
>>>
>>> In general I would define a DSS query as complex and long running query,
>>> but what is "complex" for IBM ?
>>>
>>> Any ideas ?
>>>
>>> Regards ...
>>>
>>> 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 ?

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.