Re: [Info-ingres] Re: is there an equivavlent to auto_increment in ingres ?

"--CELKO--" <jcelko212@xxxxxxxxxxxxx> wrote in message
news:1121852694.717039.5680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Isn' t queuing an example of --shudder-- procedure and not data?
>
> One of the basic rules is to model the elements and structures in
> sepratre tables. I'd have a table for the queue elements (people in a
> butcher shop) and another for the queue tickets (00 to 99) associated
> with them. For computer jobs, we had all kinds of rules about queue
> priority, such as "Student jobs come in with priority 1000+", "Teacher
> jobs come in with prioirity 100+" and "Payroll comes in with prioirity
> 10+" and servicing the queue "decrement prioirity numbers by 1 every 2
> minutes" and "service as many jobs with the lowest prioirity numbers as
> will fit into main storage".

I'm not sure how your example affects the requirement to easily identify
individual jobs to a user and hold the information in one or more tables.

On the system I have in mind we have several tables involved. The queue
table is effectively holding the queue tickets and does have priority rules,
etc.
If I hadn't suggested a queue number and said transactionid, I doubt an
eyebrow would be raised. In my case a simplistic transaction id (job number)
is using an integer, automatically incremented as jobs are added.

Paul

> _______________________________________________
> Info-ingres mailing list
> Info-ingres@xxxxxxxxxxxxxxx
> http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
>


.

Relevant Pages

  • RE: Problems Printing After XP Upgrade from 98SE
    ... Can you print any local print jobs correctly in the system which ... Does the issue occur on only one Windows XP client or all other Windows ... | all of the jobs from the queue and print a test page from XP, ... |> Use the net.exe command to establish a persistent connection. ...
    (microsoft.public.windowsxp.help_and_support)
  • [ANN] ruby queue : rq-2.3.1
    ... added 'stage' option to submit mode, which allows submission in a 'holding' state. ... an central nfs mounted priority work queue in a synchronized fashion. ... single node is running jobs from it, the system will continue to process jobs. ... the first argument to any rq command is the name of the queue. ...
    (comp.lang.ruby)
  • Re: multicore management system
    ... The queue manager ran one heavy IO ... with one heavy comp, but only one mixed one at a time. ... you have "named batch queues". ... whereas the jobs standing in "line" are Pending). ...
    (Debian-User)
  • Re: Print queue administration
    ... but it gives the ops the sort of mouse-driven ... For notification you need to consider where it will be convenient for them. ... Most of our printers are HP's connected via jetdirects and are smaller jobs ... The helpdesk or I fix the odd queue down etc. using qcan, qadm, etc (command ...
    (AIX-L)
  • Re: TUNE
    ... batch jobs would be given ... decremented to the limit of the CS queue ... To join/leave the list, search archives, change list settings, * ...
    (comp.sys.hp.mpe)