Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Graphical Interface for Displaying the Transactions Per Second Rate of Individual Parallel Database Nodes

IP.com Disclosure Number: IPCOM000103566D
Original Publication Date: 1993-Jan-01
Included in the Prior Art Database: 2005-Mar-18
Document File: 4 page(s) / 94K

Publishing Venue

IBM

Related People

Schwendemann, W: AUTHOR [+2]

Abstract

A parallel database is one where the data (i.e., tables, views, etc.) is spread over n nodes (i.e., physical nodes). In demonstrating the performance improvement of a parallel database system, measured in transactions per second (TPS), a real-time monitor was created. The real-time monitor collected TPS rates from parallel server nodes, and displayed it via a speedometer image. Each node has a monitor process which periodically sent the TPS rate back to the collector node (i.e., the node that displayed the speedometer). Database performance applications are run on various nodes, and they relay completed transactions to the monitor process. The individual node TPS rate was not displayed.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 71% of the total text.

Graphical Interface for Displaying the Transactions Per Second Rate of Individual Parallel Database Nodes

       A parallel database is one where the data (i.e., tables,
views, etc.) is spread over n nodes (i.e., physical nodes).  In
demonstrating the performance improvement of a parallel database
system, measured in transactions per second (TPS), a real-time
monitor was created.  The real-time monitor collected TPS rates from
parallel server nodes, and displayed it via a speedometer image.
Each node has a monitor process which periodically sent the TPS rate
back to the collector node (i.e., the node that displayed the
speedometer).  Database performance applications are run on various
nodes, and they relay completed transactions to the monitor process.
The individual node TPS rate was not displayed.

      This article presents a graphical interface for displaying the
TPS rate per parallel node.

      A user would perform the following scenario to bring up the
window which displays the TPS rate per parallel database node.
1.  The user enters a command which brings up the initial selection
list window.
2.  The user places the sprite (i.e., mouse pointer) on the Show PDB
TPS meter row and clicks a mouse button.  The selected row will
appear in reverse video and below the Selection title.  See Fig. 1.
3.  The user places the sprite in OK box and clicks on a mouse
button.  The user is then presented with a window with a speedometer
in it.  See Fig. 2.
4...