Abstract: A system, method, and computer-readable medium for grouping of database object access counts per processing module in a parallel processing system. Each processing module manages an intermediate cache allocated thereto that stores database object access counts local to the respective processing module. The processing modules are configured in a hierarchical configuration. The intermediate caches managed by the processing modules at the lowest level of the configuration are forwarded to a parent processing module and merged with the intermediate cache allocated to the parent processing module. A root processing module merges the intermediate caches received from one or more parent processing modules with the root processing module's intermediate cache to generate a final cache. An objects access count data structure is then generated by the root processing module.

Abstract: Process for making a flexible polyurethane foam by reacting a polyisocyanate and a polyol composition in the presence of water, a reactive amine catalyst and a specific metal salt.

Abstract: An integrated device comprises at least one input connector (62) linked to an internal conductive line (64) and at least two output connectors (70A,70B) each respectively linked to an conductive branch (69A, 69B), wherein a single moving part (65), simultaneously serving the functions of a phase-shifter and a power-distributor, which comprises a shared segment (67) divided into two conductive arms (68A, 68B), the shared segment (67) linking the internal conductive line (64) to each of the conductive branches (69A, 69B) respectively, so as to vary, by an equal but opposite quantity, the length of the electric path between the input connector (62) and each of the output conductors (70A,70B) when the moving part (65) moves. The moving part (65) can be actuated from outside the housing, preferentially by means of a transmission bar (66).

Abstract: Excess capacity (or excess resources) can be used in a capacity controlled environment to effectively manage data storage of a database. In this context, excess capacity can, for example, be controlled used as needed, as configured and/or on a temporary basis. Management of data storage in a database can, for example, include operations associated with moving or relocating data of the database. Relocation of data can, for example, be performed to relocate data deemed to be “hot” data to a location that can provide a faster access time in order to improve the overall efficiency of the database system.

Abstract: A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan for the database query is generated using estimated cost information; one or more steps of the query execution plan are executed to retrieve data from a database stored on the computer system. Actual cost information is generated for each of the executed steps, and the estimated cost information is re-calculated using the actual cost information. One or more resource allocation rules defined on one or more steps of the query execution plan are executed, based on the estimated cost information, wherein the resource allocation rules include one or more defined actions. The estimated cost information may be re-calculated using the actual cost information when confidence in the estimated cost information is low, but the estimated cost information may not be re-calculated when confidence in the estimated cost information is high.

Abstract: The dual polarised radiating element comprises four dipoles each comprising one stand and two arms. A first arm and a second arm belonging to two adjacent dipoles, form a straight radiating strand composed of a single part and the four radiating strands are arranged so as to form a disjoint square at the corners. The antenna comprises at least one first radiating element operating in a first frequency band and at least one second radiating element operating in a second frequency band and having at least one dipole that is arranged at the centre of the square formed by the radiating strands of the first radiating element, the radiating elements being arranged above a common reflector such that the transverse strands of the first radiating elements are located between two adjacent second radiating elements.

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 computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis.

Abstract: Capacity of a database system and/or a computing system that includes a database can be effectively changed from a current computing capacity to another computing capacity. This can be achieved by causing usage capacity of at least one of resource to be changed when the database is active. By way of example, capacity of a database system can be regulated by delaying the execution of the database work based on a target capacity. As a result, database work can take relatively longer to complete when the capacity of a database is effectively regulated to be below its full capacity. In effect, a portion of available capacity (excess capacity) can be made inaccessible to the database. However, excess capacity can be used to manage various services of the database in accordance with one or more service criteria (e.g., Service Level Goals or Agreements).

Abstract: Excess capacity available to a database system in a capacity controlled environment can be effectively managed. In particular, excess capacity that is not made available for normal operations of a database system can be used to manage errors, especially situations that may hinder expected performance of the database system. In addition, excess capacity can be used to optimize or further optimize database queries, especially those that meet a criterion (e.g., not fully optimize, not optimized as expected).

Abstract: A system, method, and computer-readable medium for automatic and dynamic control of optimizer settings in a large complex system environment are provided. The described mechanisms significantly increase the potential of achieving Service Level Goals for classes of queries where optimizer aggression is needed. Confidence threshold parameters are automatically controlled to facilitate generation of query execution plans to conform with associated Service Level Goals.

Abstract: An aircraft engine module handling assembly including a carriage, a pivoting portion at a top of the carriage, a module support tooling, and an additional mechanism for assembly of the tooling on the pivoting portion, such that the module can be rotated from an original vertical position, observed when it reaches an assembly shop in a crate, to a horizontal position suitable for its assembly with another module of an engine.

Abstract: Crystalline foam and process for making it by first creating a crystalline arrangement of gas bubbles in curable composition and allowing this composition to cure subsequently.

Abstract: A de-oiler system for an aircraft engine including a casing defining a volume containing a rotary shaft and a mixture of air and oil for processing is disclosed. The system includes a hollow rotary axle; a de-oiler structure fastened to the hollow rotary axle and rotating together with the hollow rotary axle, the de-oiler structure having an inlet first face communicating with the volume and an outlet second face connected to a passage formed in the hollow rotary axle; and a transmission device between the hollow rotary axle and the rotary shaft for communicating to the hollow rotary axle a speed of rotation V about its axis in such a manner that the speed of rotation V is greater than a speed of rotation v of the rotary shaft.

Abstract: A system, method, and computer-readable medium for automatic and dynamic control of optimizer settings in a large complex system environment are provided. The described mechanisms significantly increase the potential of achieving Service Level Goals for classes of queries where optimizer aggression is needed. Confidence threshold parameters are automatically controlled to facilitate generation of query execution plans to conform with associated Service Level Goals.

Abstract: Devices for intaking gases from the boundary layer through ducts hollowed out in blades. These devices are suitable for variable setting blades, installed on the stator using pivots. The seal is maintained despite the variation in the relative position between the moving pivots through which ducts pass, and the fixed intake header pipe.

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 system, method, and computer-readable medium for grouping of database object access counts per processing module in a parallel processing system are provided. Each processing module manages an intermediate cache allocated thereto that stores database object access counts local to the respective processing module. The processing modules are configured in a hierarchical configuration and processing modules at the lowest level of the configuration forward their respective intermediate cache to a processing module configured as a parent to the respective processing module. On receipt of intermediate cache(s) from lower level processing modules, a processing module merges the received intermediate caches with the intermediate cache allocated to the processing module. The process is iteratively repeated until a root processing module receives the intermediate caches from processing modules configured as child nodes thereto.

Abstract: A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan for the database query is generated using estimated cost information; one or more steps of the query execution plan are executed to retrieve data from a database stored on the computer system. Actual cost information is generated for each of the executed steps, and the estimated cost information is re-calculated using the actual cost information. One or more resource allocation rules defined on one or more steps of the query execution plan are executed, based on the estimated cost information, wherein the resource allocation rules include one or more defined actions. The estimated cost information may be re-calculated using the actual cost information when confidence in the estimated cost information is low, but the estimated cost information may not be re-calculated when confidence in the estimated cost information is high.

Abstract: A computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis.