Abstract: The invention relates to a method and database system for rewriting a SQL query having at least one null sensitive expression (NSE) in a select list of the query, the query comprising at least one outer join command to be performed on at least two tables and involving a view or a Derived Table (DT). The method comprising the steps of: identifying at least one unmatching row belonging to the view or DT using non-nullable fields that belong to the outermost table in the view or DT; converting the NSE(s) from the at least one identified rows into a SQL case construct; and performing the at least one outer join. The database system comprising means for rewriting a SQL query having at least one null sensitive expression (NSE) in a select list of the query, the query comprising at least one outer join command to be performed on at least two tables and involving a view or a Derived Table (DT).

Abstract: A system and method for managing database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein a database tuning agent function of the regulator uses statistics on physical and logical data access in order to perform automated block size management for database objects.

Abstract: An air-cooled electronic component cabinet has an air sampling conduit to enable smoke detection from air from different areas within the cabinet. An air sampling conduit has one or more orifices to sample air from the different areas within the cabinet, such as adjacent different electronic chassis assemblies or enclosures stacked in a rack within the cabinet. An axial fan or blower draws air samples into the conduit, or the air samples are drawn in by operation of convection or other airflow established within the cabinet. In the air sampling conduit, the air samples are mixed and conveyed for sampling by one or more smoke detection devices mounted, e.g., within the conduit, or within an attached expansion joint section to reduce the airflow velocity or accommodate multiple smoke detection devices. Orifices in the air sampling conduit varying in size or number at different conduit areas regulate associated sampled air proportions.

Abstract: A method, computer program and system for regulating the workload of a database system as it processes one or more requests are disclosed. The requests are grouped into workload groups and are processed by one or more of a plurality of subsystems within the database system. Each subsystem has resources. The system has resources. The subsystem resources and the system resources are allocated across the workload groups. The method, computer program and system include monitoring, at a subsystem level, the processing of the requests and adjusting the allocation of subsystem resources to workload groups to achieve a subsystem goal and monitoring, at a system level, the processing of the requests and adjusting the allocation of system resources to workload groups to achieve a system goal. The subsystems are arranged in a hierarchical network.

Abstract: A printed circuit board includes at least two conductive traces, each having a first portion and a second portion. The printed circuit board also includes a cross-over section that includes two electrically conductive portions, each connecting electrically to the first and second portions of a corresponding one of the conductive traces, such that the conductive traces in their first portions lie on opposite sides of each other as they do in their second portions.

Abstract: Request processing is optimized. The request has elements. The method, computer program and database system includes selecting an access path for the request taking into consideration a stored actual request element cost, processing the request using the selected access path, producing one or more actual request element costs, and storing the one or more actual request element costs.

Abstract: A method and computer program for clustering a string are described. The string includes a plurality of characters. R unique n-grams T1 . . . R are identified in the string. For every unique n-gram TS, if the frequency of TS in a set of n-gram statistics is not greater than a first threshold, the string is associated with a cluster associated with TS. Otherwise, for every other n-gram TV in the string T1 . . . R, except S, if the frequency of n-gram TV is greater than the first threshold, and if the frequency of n-gram pair TS-TV is not greater than a second threshold, the string is associated with a cluster associated with the n-gram pair TS-TV. Otherwise, for every other n-gram TX in the string T1 . . . R, except S and V, the string is associated with a cluster associated with the n-gram triple TS-TV-TX. Otherwise, nothing is done.

Abstract: A database system is able to receive a query that specifies an inequality join involving at least a first relation and a second relation. A plurality of segments of the first relation are sorted in the cache. Each sorted segment of the first relation in the cache is compared with the second relation.

Abstract: A method for processing a trigger are described. The trigger is associated with a subject table in a relational database and defines a triggering statement and one or more triggered actions. The method includes determining that a triggering statement of a trigger will execute on a subject table row of a subject table and requesting a transition table in response to determining that the triggering statement will execute. The transition table includes a transition table row. The transition table row includes a first value associated with the subject table row and a second value associated with the subject table row. The method further includes reading the transition table row from the transition table and identifying a processing unit to receive the transition table row and a triggered action of the trigger. The method also includes transmitting the transition table row and the triggered action to the identified processing unit to be processed.

Abstract: There is provided a method, a system and a machine readable medium to execute a spatial query against a plurality of input tables of a distributed database.

Abstract: Methods and systems for locating related reports are provided. A report application identifies a first report to process along with preference selections associated with finding related reports to the first report being processed. A data preparation application performs an initial filter against a report data store using the first report and the preference selections. The data preparation application passes candidate reports and the first report to a data mining application. The data mining application uses the first report, the candidate reports, and a report usage data store to find relationships and associations with additional reports. In one embodiment, the additional reports are ranked and organized before being presented to the report application as related reports to the first report.

Abstract: Methods, systems, and data structure custom queries for segmentation. Queries are imported into a segmentation tool and modified. The queries are associated with data sources that are not mapped within the segmentation tool. Parts of the queries are manually supplied or imported into the segmentation tool and parts of the queries are automatically generated based table and key selections associated with a customer hierarchy. When the custom queries are executed the query results provide customer segmentations for desired marketing campaigns.

Abstract: A circuit board includes reference plane layers and a dielectric between the reference plane layers. A resistive element is also provided between the reference plane layers to provide a resistive path between the reference plane layers. Optimally, a decoupling capacitor is provided having a first electrode electrically connected to the resistive element, and a second electrode electrically connected to one of the reference plane layers.

Abstract: A database system includes object relational tables having at least one complex attribute. The database system also includes an optimizer module that selects a join plan for a given query that specifies a join of multiple tables. If the query includes a function selected from the group consisting of a selection predicate applied on a complex attribute, a projection applied on a complex attribute, and a user-defined data type method, then a join path for the join query is determined based in part on a cost associated with application of the function. Application of the function is performed on one of a base table and a join table depending on which has a lower cardinality. The join table is a result of a join of the base table and another table.

Abstract: A revenue management system for a travel provider, such as airline, a car rental agency, a cruise line, a lodging provider; a travel agency; a bus line or a passenger rail service provider. The revenue management system comprises a database for storing revenue, product and service, and customer information; a logical data model comprising a plurality of entities and relationships defining the manner in which the revenue, product and service, and customer information is stored and organized within the database; and a revenue management application for analyzing the revenue, product and service, and customer information contained within the database to manage inventory, pricing and demand forecasting for the travel provider.

Abstract: A method and apparatus receives customer feedback and analyzes words in the customer feedback. The words in the customer feedback are compared to rating data to generate an indication to rate the customer feedback. The rating data associates predefined words with respective values. In one arrangement, the rating data is according to a user-defined data type (UDT) stored in a relational table.

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 and apparatus of analyzing a target system comprises receiving information relating to an environment of the target system and storing cost data based on the environment information. The plan and its estimated performance for a query may be determined based on the cost data. The environment information may pertain to the environment of a parallel system (e.g., a multi-node parallel system, a single-node parallel system having plural central processing units or a system running plural virtual processors) that is running a parallel database. The cost data may identify a number of nodes in the target system, a number of central processing units in each node of the target system, and other types of system information. The cost data may be stored in a relational table having a plurality of rows. Each row of the relational table may correspond to a different target system.

Abstract: A circuit board construction which reduces unwanted electrical effects and lower signal quality resulting from the use of vias in relatively thick circuit boards or in circuit boards carrying signals of relatively high frequency. The circuit board includes a through-hole in the circuit board substrate for carrying a conductive via stub, the stub having an inherent stub characteristic; and a compensation element, such as a surface mount capacitor, positioned on the substrate such that when the stub is carried by the through-hole the inherent stub characteristic is adjusted to define a compensated stub characteristic.

Abstract: Methods and systems for business decision-making are provided. Business data elements are fused together to form fused data sets. The fused data sets are analyzed as sets and business rules are applied to the sets. Based on the analysis and the applied business rules an automated business decision is selected and made.