Abstract: The present invention extends to methods, systems, and computer program products for performing parallel joins on distributed database data. Embodiments of the invention include a phased semi-join reduction strategy using replication and shuffle operations to join a first and a second data source. A filter building phase uses replication and pushes down a “Distinct” (e.g., SQL) operator to produce a list of join keys for the first data source (one side of the join). A shuffle phase for the second data source is modified to join to the key list produced in the first phase as a row filtering mechanism. A join phase then joins the first and second data sources.

Abstract: The present invention extends to methods, systems, and computer program products for performing parallel joins on distributed database data. Embodiments of the invention include a phased semi-join reduction strategy using replication and shuffle operations to join a first and a second data source. A filter building phase uses replication and pushes down a “Distinct” (e.g., SQL) operator to produce a list of join keys for the first data source (one side of the join). A shuffle phase for the second data source is modified to join to the key list produced in the first phase as a row filtering mechanism. A join phase then joins the first and second data sources.

Abstract: A diagnostic method for determining deformations in a transformer winding including the steps of representing the winding as a lumped parameter circuit and dividing the winding into at least two sections; generating a first set of fingerprint values based on capacitive values of the winding; the first set of finger print values indicating the location and extent of radial deformation in the winding; generating a second set of fingerprint values based on capacitive values of the winding; the second set of finger prints indicating the location and extent of axial deformation in the winding and determining the location and extent of radial or axial deformation or combination of both radial and axial deformation in the winding by comparing the measured values with the first set and second set of finger print values.

Abstract: Triggers are dynamically created and destroyed on an application database. Rules are represented in active databases as ECA (event-condition-action) items, in which an action formulates a reaction to an event and is executed after the rule is triggered when the condition is evaluated to true. The event is defined as an instantaneous and atomic (that is, the event either happens completely, or not at all) point of occurrence within an application. Events can be classified as either database, temporal, or user-defined events, and their type can be either primitive or composite.

Abstract: Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.

Abstract: A diagnostic method for determining deformations in a transformer winding comprising the steps of representing the winding as a lumped parameter circuit and dividing the winding into at least two sections; generating a first set of fingerprint values based on capacitive values of the winding; the first set of finger print values indicating the location and extent of radial deformation in the winding; generating a second set of fingerprint values based on capacitive values of the winding; the second set of finger prints indicating the location and extent of axial deformation in the winding and determining the location and extent of radial or axial deformation or combination of both radial and axial deformation in the winding by comparing the measured values with the first set and second set of finger print values.

Abstract: Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.

Abstract: A statistical process control information system includes a process information system (process IS) and an analysis information system (analysis IS). The analysis IS generates a script file and a command file. The script file includes responses to command-line queries generated by a process data extraction program, and the command file includes commands for invoking the process data extraction program and copying an extracted data file to the analysis IS. The analysis IS issues a command to the process IS to execute an extraction command routine, causing the process IS to copy and execute the command file. The analysis IS performs statistical analysis on the extracted data file and creates graphical SPC chart files, including a hypertext summary, and these are posted in a network-accessible database for users.

Abstract: A method, computer program product, and system for creating and displaying a categorization table is provided. A categorization table into a set of data records is created and displayed by first sorting the data records according to data record fields, typically using an index. Next, a header table is created having a number of category columns that will hold values corresponding to a number of index columns. The combinations of values across each header row will be unique and the row will also have a count value indicating the number of data records having the unique combination of category values that can be used to quickly access the first data record in the sorted index. In this manner, all of the data records can be successively accessed knowing the count value and the location of the first data record. Additionally, header rows having no data records associated therewith are used to form the headings and subheadings of the categorization table.

Abstract: A Client/Server Database System with improved methods for appending items to an object, such as appending data records to a database table, in the context of a multi-user environment is described. The system includes one or more Clients (e.g., Terminals or PCs) connected via a Network to a Server. The Clients store data in and retrieve data from one or more database tables resident on the Server by submitting SQL commands, some of which specify insert or append operations, for appending records to a table. For enhancing the speed in which multiple appenders (i.e., Clients) can append records, the operation of the server is modified to store an object (e.g., table) as multiple (physical) page chains. From the logical viewpoint, a single (logical) page chain of data pages is presented to each client or user. From the perspective of inserting records, however, the system has multiple page chains to insert into, thereby removing contention among multiple appenders for the last page.