Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / October 2006

Tip: Looking for answers? Try searching our database.

Definition of DSS/OLTP queries ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jörg RÃ1/4schenschmidt - 28 Oct 2006 09:05 GMT
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 - 28 Oct 2006 10:56 GMT
"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

> Hi all,
>
[quoted text clipped - 11 lines]
>
> Joerg
Joerg Rueschenschmidt - 28 Oct 2006 12:07 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.