Abstract: The invention relates to a system (2) for deicing an aircraft turbine engine inlet cone (4) comprising air-diffusing means (18) intended to equip the inlet cone of the turbine engine so as to deliver hot air thereto. According to the invention, it also comprises a circuit (20) for removing pressurizing air from at least one bearing enclosure of the turbine engine, this circuit communicating with the air-diffusing means in order to be able to supply the latter with hot air.

Abstract: A multistage compressor for a turbomachine, in particular an airplane turboprop or turbojet, the compressor comprising a double-walled casing having an inner wall made up of shrouds surrounding respective annular rows of moving blades and annular rows of straightening stator vanes, said shrouds being connected to the outer wall of the casing by independent suspension means enabling the radial clearances between the outer ends of the moving blades and the shrouds of the inner wall of the casing to be adjusted independently from one compression stage to another.

Abstract: A multistage compressor for a turbomachine, in particular an airplane turboprop or turbojet, the compressor comprising a double-walled casing having an inner wall made up of shrouds surrounding respective annular rows of moving blades and annular rows of straightening stator vanes, said shrouds being connected to the outer wall of the casing by independent suspension means enabling the radial clearances between the outer ends of the moving blades and the shrouds of the inner wall of the casing to be adjusted independently from one compression stage to another.

Abstract: An improved system and method for storing, reusing and recompiling execution plans for SQL database queries. The system. The system validates the performance of a newly compiled plan prior to replacing a currently stored execution plan and compares the resource cost of the recompiled plan with the cost of the currently stored plan. In the event that the resource cost of the recompiled plan is not greater than the stored plan resource cost, the system replaces the currently stored execution plan with the recompiled plan.

Abstract: The invention relates to a de-oiler system for an aeroengine including a casing defining a volume containing a rotary shaft and a mixture of air and oil for processing. The system comprises: a hollow rotary tube; a de-oiler structure fastened to said tube and constrained to rotate with said tube, said de-oiler structure having an inlet first face communicating with said volume and an outlet second face connected to the passage formed in said hollow tube; and transmission means between said hollow tube and said shaft for communicating to said hollow tube a speed of rotation V about its axis in such a manner that said speed of rotation V is greater than the speed of rotation v of said rotary shaft.

Abstract: An improved system and method for storing, reusing and recompiling execution plans for SQL database queries. The system. The system validates the performance of a newly compiled plan prior to replacing a currently stored execution plan and compares the resource cost of the recompiled plan with the cost of the currently stored plan. In the event that the resource cost of the recompiled plan is not greater than the stored plan resource cost, the system replaces the currently stored execution plan with the recompiled plan.

Abstract: An improved workload management system and method for a database system. The improved workload management system evaluates certain workload management rules dynamically at key points during database query execution rather than relying on enforcement prior to query activation. In the case of product join operations, the workload management system evaluates the potential impact on system performance by the product join operation after input tables have been populated, but prior to the execution of the join operation. Delaying workload management enforcement to this point ensures that the sizes of inputs and outputs are reliably known and improves system performance impact estimates at a point early enough to prevent any serious performance degradation from an inefficient product join.

Abstract: A system and method for selectively recompiling stored execution plans within a database system. In one technique the execution plans include respective version numbers of database software operable within the database system during compilation of the respective plans. A request is received to execute one of the stored execution plans, and the stored execution plan is retrieved from computer memory. A version number is obtained of database software operable within the database system during retrieval of the stored execution plan. The obtained version number is compared with the version number associated with the retrieved execution plan. On detecting a mismatch between the obtained version number and the retrieved version number, the stored execution plan is recompiled. In another technique the stored execution plans include respective cost parameters representing the hardware capabilities of the system at the time of plan compilation.

Abstract: A method and system for managing execution of a query that provides an avenue for runtime optimization, or more specifically runtime re-optimization. This allows for more efficient execution plans to be generated, and reduces the risk of major complications due to inadvertently poor estimates. In other cases such a query management system is used for alternate purposes, such as throttling system resource consumption for demanding queries.