Abstract: A database system may include a storage array including a plurality of storage devices configured to store database data. The database system may further include a processor in communication with the memory device. The processor may be further configured to determine usage frequency of the database data. The processor may be configured to select a subset of the database data for compression based on the usage frequency. The processor may be further configured to perform the compression of the selected subset of the database data. A method and computer-readable medium may also be implemented.

Abstract: A database system may implement compression management of tables in the database system. The compression management may include determination of a pattern of usage of various database tables in the database system. Based on this pattern of usage, the database tables may be selected as candidates for compression or decompression at the appropriate time. In one example, the pattern of usage may be based on the contents of a query log of the database system. The compression management may also include evaluation of various compression strategies to apply to a candidate database table. Each compression strategy may be evaluated to determine if application to a database table or a portion of the database table would be beneficial based on various conditions. The compression management may also include consideration of each available compression strategy to be applied solely or in combination with one another.

Abstract: A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.

Abstract: A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.

Abstract: A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.

Abstract: A processor method and apparatus for parallel computer systems for synchronizing the flushing of database segments by a node through shared disk tokens. The system provides for flushing database segments at each of the processor nodes through use of a persistent storage semaphore stored as a plurality of disk tokens and a set of control flags in a synchronization segment on a shared data storage device.

Abstract: A virtual processor method and apparatus for parallel computer systems that increases the level of parallelism to include multiple threads per node. If a processor node has a plurality of storage devices attached, a single thread can be allocated to each device. Similarly, if a processor node has multiple CPUs, each individual thread can utilize a different CPU. Thus, a task could potentially occupy all available hardware in the system. The result is increased system utilization and availability.