Abstract: An ultra-shared-nothing parallel database system includes at least one master node and multiple slave nodes. A database consisting of at least one fact table and multiple dimension tables is partitioned and distributed across the slave nodes of the database system so that queries are processed in parallel without requiring the transfer of data between the slave nodes. The fact table and a first dimension table of the database are partitioned across the slave nodes. The other dimension tables of the database are duplicated on each of the slave nodes and at least one of these other dimension tables is partitioned across the slave nodes.
Abstract: A relational database workload manager is provided for dynamically managing processing priorities assigned to queries executing within a relational database management system (RDBMS). The workload manager monitors executing query process threads and at set time intervals reduces the processing priority assigned to each executing query. This automated method of managing relational database queries allows short executing queries within a mixed database workload to remain relatively quick without complicated setup and management.
Abstract: A secure relational database system is provided which utilizes a non-invasive encryption technique. Data pages stored or retrieved by a relational database management system are diverted to a multi-channel hardware encryption engine for processing. Each data page is divided into multiple buffers and distributed among the channels of the hardware encryption engine to be processed simultaneously. The data page is then reassembled and passed on to its intended destination.
Abstract: An ultra-shared-nothing parallel database system includes at least one master node and multiple slave nodes. A database consisting of at least one fact table and multiple dimension tables is partitioned and distributed across the slave nodes of the database system so that queries are processed in parallel without requiring the transfer of data between the slave nodes. The fact table and a first dimension table of the database are partitioned across the slave nodes. The other dimension tables of the database are duplicated on each of the slave nodes and at least one of these other dimension tables is partitioned across the slave nodes.