Abstract: Initially, a table in the database is baselined. The baselining function is usually built into the database system program which manages the database itself. This baselining procedure generates storage information like the number of rows in the table, the average length of a row, the number of chained/migrated rows, and the average free space per page in the table. This storage information is transferred to a monitoring routine via a transaction log. The monitoring routine accepts the storage information for the table. Next, the monitoring routine monitors the transaction log for entries which alter the storage information initially passed to it. At some point, an entity may wish to know the current storage information for the table. When this occurs, a message is passed to the monitoring routine, and the monitoring routine transfers the storage information to the requesting entity, without accessing the database.

Abstract: An improved method and system for comparing database data. Data comparison may be performed either within a database or between two databases. Sets of cyclical redundancy check values may be created, at various points in time. Corresponding cyclical redundancy check values may be compared with each other to determine if the underlying data is different; differences may be displayed. Each cyclical redundancy check value may correspond to a user-determined amount of data within the database. The user-determined amount of data may be: (1) user-specified columns within one of the plurality of tables within the database; (2) a row within one of the plurality of tables within the database; (3) a table within the database; (4) the database in its entirety; or (5) any other subset of the database. A user-determined number of bytes corresponding to a user-determined subset of the user-determined amount of data may be stored for future use.

Abstract: Initially, a table in the database is baselined. The baselining function is usually built into the database system program which manages the database itself. This baselining procedure generates storage information like the number of rows in the table, the average length of a row, the number of chained/migrated rows, and the average free space per page in the table. This storage information is transferred to a monitoring routine via a transaction log. The monitoring routine accepts the storage information for the table. Next, the monitoring routine monitors the transaction log for entries which alter the storage information initially passed to it. At some point, an entity may wish to know the current storage information for the table. When this occurs, a message is passed to the monitoring routine, and the monitoring routine transfers the storage information to the requesting entity, without accessing the database.

Abstract: Initially, a table in the database is baselined. The baselining function is usually built into the database system program which manages the database itself. This baselining procedure generates storage information like the number of rows in the table, the average length of a row, the number of chained/migrated rows, and the average free space per page in the table. This storage information is transferred to a monitoring routine via a transaction log. The monitoring routine accepts the storage information for the table. Next, the monitoring routine monitors the transaction log for entries which alter the storage information initially passed to it. At some point, an entity may wish to know the current storage information for the table. When this occurs, a message is passed to the monitoring routine, and the monitoring routine transfers the storage information to the requesting entity, without accessing the database.

Abstract: An air sock for indicating wind speed as well as direction is the subject of the present invention. A fabric type sock member is mounted on an upright standard for pivotal movement about its longitudinal axis. A spring is provided for existing pivotal movement and an arrangement is also provided for effecting pivotal movement in response to wind speed. The air sock is divided into equal quadrants of different colors so that, as the wind speed increases, a different color will be visible from an aircraft overhead. In one form of the invention, a torsion spring is utilized to resist the pivotal movement and an impeller is provided for effecting the pivotal movement. In an alternative form of the invention, a single tension spring is utilized to resist the pivotal movement and also effect the movement in response to increases in wind speed.

Abstract: A self acting lock which automatically locks down the dump body of a truck and automatically releases when the body is to be raised. Two pairs of lever arms which are pivoted together cooperate with a single acting hydraulic cylinder to provide a hoist for raising and lowering the dump body. The upper arms are pivoted to the body and the lower arms are pivoted to a pair of links which are in turn pivotally mounted to the truck frame. Each link carries a hook which engages with a keeper rod carried on the upper pair of arms to lock down the body. A leg extending from the upper arms pivots the links in a direction to engage the hooks with the keeper rod in response to lowering of the dump body to the load carrying position. The linkage is arranged such that initial extension of the cylinder pivots the links in a direction to release the hooks from the rod before continued extension of the cylinder raises the dump body in the usual manner.