Abstract: Systems, methods, and computer media are described for index-based join size estimation. For a join operation between two tables, a filter is applied to the first table, resulting in a filter output. The filter output is then sampled. For each sample, an index for a second table is accessed and counts of records in the second table that match the sample are retrieved. Using the sample size and the retrieved counts from the index of the second table, a data size for the join operation can be efficiently and accurately estimated. Statistical confidence in the estimate can also be assessed using variance-based calculations.

Abstract: Systems, methods, and computer media are described for index-based join size estimation. For a join operation between two tables, a filter is applied to the first table, resulting in a filter output. The filter output is then sampled. For each sample, an index for a second table is accessed and counts of records in the second table that match the sample are retrieved. Using the sample size and the retrieved counts from the index of the second table, a data size for the join operation can be efficiently and accurately estimated. Statistical confidence in the estimate can also be assessed using variance-based calculations.

Abstract: A drilling rig with a modular wellbore strengthening material recovery system having an active drilling fluid tank system and on an on-rig shaker. The drilling rig with the modular wellbore strengthening material recovery system can have a processor connected to data storage, a pump, a motor, a power supply, a high solids capacity accelerated settling device, and a recovery shaker. The recovery shaker can have a top vibrating screen deck, a bottom vibrating screen deck, and a vibrating hack flow pan, which can be fluidly connected between the top vibrating screen deck and the bottom vibrating screen deck.

Abstract: Systems and techniques, including a circle feeder, for the handling of drill cuttings, providing surge storage, rig buffer storage and wet and dry cuttings blending, including temporary storage of drill cuttings, optimizing storage capacity and the efficient and regulated movement of stored cuttings to a discharge port out of the hopper. Systems and techniques, maximize available space, provide optimized surge storage to optimize the use of downstream DPCS (and other transportation devices), provide optimized rig based storage and discharge, minimize or eliminate the occurrence of ratholing, bridging, degradation, segregation, and dehydration within the hopper, control and regulate the flow of cuttings from the hopper to the discharge port from the hopper, and provide metered discharge from the hopper storage, particularly when one hopper is discharging wet cuttings and a second hopper is discharging dry cuttings, and it is desirable to blend the wet and dry cuttings after such metered discharge.

Abstract: A drilling rig with continuous microwavable particulate treatment system for treating fluid from a wellbore on an offshore platform. The system uses a materials handling controller, a vibrating sieve device or filtering device to separate particulate from drilling fluid, a cuttings discharge collection device for continuously moving the slurry to a cuttings processing station, a treatment system controller controlling the continuous cuttings processing station that uses a microwave generator creating microwaves that heat the slurry and a plurality of non-deforming microwave heatable polishing and grinding media in a vibrating trough. The system continuously creates water vapor with oil droplets and cleaned cuttings, and a vapor recovery system is used for removing the oil droplets from the water vapor having a vapor recovery system controller in communication with the material handling controller and treatment system controller.

Abstract: A continuous microwave particulate treatment system for treating fluid from a wellbore. The system uses a material handling controller, a vibrating sieve device or filtering device to separate particulate from drilling fluid, a cuttings discharge collection device for continuously moving the slurry to a cuttings processing station, a treatment system controller controlling the continuous cuttings processing station that uses a microwave generator creating microwaves that heat the slurry and a plurality of non-deforming microwave heatable polishing and grinding media in a vibrating trough. The system continuously creates water vapor with oil droplets and cleaned cuttings, and a vapor recovery system is used for removing the oil droplets from the water vapor having a vapor recovery system controller in communication with the material handling and treatment system controllers.

Abstract: A drilling rig with rig buffer storage and optional surge tank for receiving and processing drill cuttings and waste made of a drilling rig, having a tank in a frame with an inlet and an outlet, a moveable weir for expanding to accommodate additional drill cuttings, a central sweep member for cutting the drill cuttings and waste opposite a peripheral outer ring with peripheral cutting members, a controller for controlling rates of flow into and out of the rig buffer storage and the central sweep member rotation via a motor with reduction gear and wherein a first transportation system moves waste from the well bore to the rig buffer storage and a second transportation system moves cut waste and cut drill cuttings to a post treatment system, a skip, or a vessel for transport to another location.

Abstract: A clog free waste removal system for removing waste or drilling cuttings from a wellbore at the rate that waste is being produced having an incoming transportation system, a rig buffer, and optional surge tank, an outgoing transportation system, and post treatment device or transport.

Abstract: A clog free waste removal system for removing waste or drilling cuttings from a wellbore at the rate that waste is being produced having an incoming transportation system, a rig buffer, and optional surge tank, an outgoing transportation system, and post treatment device or transport.

Abstract: A drilling rig with rig buffer storage and optional surge tank for receiving and processing drill cuttings and waste made of a drilling rig, having a tank in a frame with an inlet and an outlet, a moveable weir for expanding to accommodate additional drill cuttings, a central sweep member for cutting the drill cuttings and waste opposite a peripheral outer ring with peripheral cutting members, a controller for controlling rates of flow into and out of the rig buffer storage and the central sweep member rotation via a motor with reduction gear and wherein a first transportation system moves waste from the well bore to the rig buffer storage and a second transportation system moves cut waste and cut drill cuttings to a post treatment system, a skip, or a vessel for transport to another location.

Abstract: Systems and techniques, including a circle feeder, for the handling of drill cuttings, providing surge storage, rig buffer storage and wet and dry cuttings blending, including temporary storage of drill cuttings, optimizing storage capacity and the efficient and regulated movement of stored cuttings to a discharge port out of the hopper. Systems and techniques, maximize available space, provide optimized surge storage to optimize the use of downstream DPCS (and other transportation devices), provide optimized rig based storage and discharge, minimize or eliminate the occurrence of ratholing, bridging, degradation, segregation, and dehydration within the hopper, control and regulate the flow of cuttings from the hopper to the discharge port from the hopper, and provide metered discharge from the hopper storage, particularly when one hopper is discharging wet cuttings and a second hopper is discharging dry cuttings, and it is desirable to blend the wet and dry cuttings after such metered discharge.

Abstract: A method for managing instant messaging interruptions may include comparing at least one term in an instant message to a plurality of terms in a no-response-required (NRR) library. The method may also include representing the instant message as an instant message agent character (IMAC) in response to a match between at least one term in the instant message and at least one of the plurality of terms in the NRR library.

Abstract: A system, method, and program product that receives an email message at a first computer system, the received email message being subsequent to an original email message that was addressed to a group of email recipients, and the received email message is addressed to one of the email participants that include the email recipients and the original sender of the original email message. The system, method, and computer program product identifies whether a continuity of service was set for the original email message. If the continuity of service was set for the original email message and that the received email message is addressed to the original sender, then the received email message is forwarded to the other email recipients.

Abstract: A method for managing instant messaging interruptions may include comparing at least one term in an instant message to a plurality of terms in a no-response-required (NRR) library. The method may also include representing the instant message as an instant message agent character (IMAC) in response to a match between at least one term in the instant message and at least one of the plurality of terms in the NRR library.

Abstract: A database system with methodology for automated determination and selection of optimal indexes is described. In one embodiment, for example, in a database system, a method of the present invention is described for recommending database indexes to be created for optimizing system performance, the method comprises steps of: capturing a workload representative of database queries employed during system use; creating virtual indexes for optimizing system performance during execution of the database queries captured in the workload; computing cost benefits for different combinations of the virtual indexes; and recommending physical indexes to be created based on virtual indexes that have favorable cost benefits for the captured workload.

Abstract: Apparatus and processes are provided for handling fluids in numerous industrial applications. Materials addition devices, including venturi hoppers, and other eductor assemblies, are joined in compact, horizontal, and/or vertical configurations, with one or more shearing devices, including, high and low velocity shearing devices individually, as well as, a combination high and low velocity shearing device. Pipe and valve configuration allow several alternate paths through or around such assemblies and devices, in alternate directions, including the option to backflow through the high velocity shearing device for the removal of obstructions. In the high velocity shearing devices provided, a special jet insert is provided, along with jet insert installation related apparatus, by which the jet insert is easily retained in, and removed from, the piping in the high velocity shearing device.