Patent application number | Description | Published |
20140108459 | FUNCTIONALITY OF DECOMPOSITION DATA SKEW IN ASYMMETRIC MASSIVELY PARALLEL PROCESSING DATABASES - Database queries are optimized through the functionality of decomposition data skew in an asymmetric massively parallel processing database system. A table having data skew is restructured by (1) storing original data values of a distribution key in a special switch column added to the table, (2) replacing the original data values of the distribution key with modified data values such as randomly generated data values, and (3) partitioning the rows across the nodes of the asymmetric massively parallel processing database system based on the distribution key. The original data values that are stored and replaced may only comprise a subset of the original data values that cause data skew in the table. Data skew is reduced, which improves performance, yet the original data values remain available, which reduces the impact on collocated joins. | 04-17-2014 |
20140149388 | METHOD AND SYSTEM FOR ESTIMATING THE SIZE OF A JOINED TABLE - A method, system, and/or computer program product estimate a cardinality of a joined table (T) obtained by joining at least a first data column (R) and a second data column (S), where R and S each comprise attribute values. A first density distribution function f(x) describes a frequency of the attribute values of R. A second density distribution function (g(x)) describes the frequency of the attribute values of S. A first information on values in R is based on a sample of values of R. A second information on values in S is based on a sample of values of S. One or more processors then estimate a cardinality of a joined table (T) based on the first and second density distribution function (f(x), g(x)) and the first and second information on values. | 05-29-2014 |
20140156635 | OPTIMIZING AN ORDER OF EXECUTION OF MULTIPLE JOIN OPERATIONS - A computer-implemented method, system, and/or computer program product optimizes an order of execution of column join operations. A first partitioning of the first data column splits the first data column into first subsets of rows. A second partitioning of the second data column splits the second data column into a second subsets of rows. A first value frequency information indicates a frequency of attribute values within a subset of rows of the first data column processed. A second value frequency information indicates a frequency of attribute values within a subset of rows of the second data column. Cardinalities of sub-tables derived by a respective joining of the subsets of rows of the first and second data columns are estimated, based on the first and second value frequency information. An order of execution of multiple join operations is then optimized based on the estimated cardinalities of the sub-tables. | 06-05-2014 |
20150186465 | AVOIDANCE OF INTERMEDIATE DATA SKEW IN A MASSIVE PARALLEL PROCESSING ENVIRONMENT - A computer-implemented method for minimizing join operation processing time within a database system based on estimated joined table spread of the database system has been provided. The computer-implemented method includes, estimating value distribution of data in a joined table, wherein the joined table is a result of join operation between two instances of tables of a database system. The computer-implemented method further includes determining boundaries for partitioning at least one range of attributes of the estimated value distribution, wherein the boundaries for partitioning at least one range of attributes of the estimated value distribution corresponds to a same number of rows of the joined table. The computer-implemented method further includes determining at least one assignment of the determined partition of the at least one range of attributes to processing units of the database system. | 07-02-2015 |
20150186466 | AVOIDANCE OF INTERMEDIATE DATA SKEW IN A MASSIVE PARALLEL PROCESSING ENVIRONMENT - A computer-implemented method for minimizing join operation processing time within a database system based on estimated joined table spread of the database system has been provided. The computer-implemented method includes estimating value distribution of data in a joined table, wherein the joined table is a result of join operation between two instances of tables of a database system. The computer-implemented method further includes determining boundaries for partitioning at least one range of attributes of the estimated value distribution, wherein the boundaries for partitioning at least one range of attributes of the estimated value distribution corresponds to a same number of rows of the joined table. The computer-implemented method further includes determining at least one assignment of the determined partition of the at least one range of attributes to processing units of the database system. | 07-02-2015 |
20150370647 | DIRECTED BACKUP FOR MASSIVELY PARALLEL PROCESSING DATABASES - Creating a data backup of data on a first computer system to restore to a second computer system, each of the first and second computer system including one or more nodes, each node configured to manage a subset of the data. Receiving, by the first computer system, identification of data to back up and node configuration information for the second computer system. Creating, by the first computer system, a backup of the data from the one or more nodes of the first computer system, configured in accordance with the node configuration information of the second computer system, such that the backed up data is directly manageable by the one or more nodes of the second computer system. | 12-24-2015 |
20150370651 | DIRECTED BACKUP FOR MASSIVELY PARALLEL PROCESSING DATABASES - Creating a data backup of data on a first computer system to restore to a second computer system, each of the first and second computer system including one or more nodes, each node configured to manage a subset of the data. Receiving, by the first computer system, identification of data to back up and node configuration information for the second computer system. Creating, by the first computer system, a backup of the data from the one or more nodes of the first computer system, configured in accordance with the node configuration information of the second computer system, such that the backed up data is directly manageable by the one or more nodes of the second computer system. | 12-24-2015 |
Patent application number | Description | Published |
20090099629 | SYSTEM AND METHOD FOR PATIENT TEMPERATURE CONTROL - A patient temperature control system and method are provided for automated temperature control according to a programmed protocol. In one aspect, at least one programmed protocol may be established for each of a plurality of patient thermal therapy phases. In turn, the temperature of a thermal exchange medium may be controlled, based at least in part, upon the programmed protocol, during each of the phases. In another aspect, a plurality of programmed protocols may be established, wherein a selected one of the protocols (e.g. selected by a user at a user interface) may be utilized for automated temperature control during patient thermal therapy. The protocol(s) may include a target patient temperature and/or a set duration for one or more of the phase of thermal therapy. Further, the protocol(s) may be user-definable and modifiable during therapy. In a multi-phase configuration, automatic termination and initiation of successive phases may be selectively established by a user, based on target patient temperature data and/or set duration data on a phase-specific basis. | 04-16-2009 |
20090131835 | PATIENT TEMPERATURE RESPONSE CONTROL SYSTEM AND METHOD - A system and method are provided that employ a monitoring device to monitor at least one patient physiological response to a change in temperature of the patient (e.g. pursuant to induced hypothermia therapy), wherein a monitoring signal is provided by the monitoring device. In turn, an output (e.g. a visual and/or auditory output) may be provided to a user indicative of at least one measure of patient response to the change in temperature. Alternatively or additionally, a processor may be provided to process the monitoring signal and provide an output employable by medical personnel to control a patient shivering response to the patient temperature change. Such information may comprise information regarding one or more anti-shivering medicament(s), e.g. corresponding dosage and/or frequency information for use by medical personnel in the administration of the anti-shivering medicament. In one approach, a motion sensor may be selectively attached to a patient's chin to provide a wireless monitoring signal to a transceiver. In turn, the transceiver may provide the monitoring signal to the processor on an ongoing basis to output information useful in the administration of an anti-shivering medicament, including updated information that takes into account a patient's response to a prior administration of one or more medicaments in conjunction with the subsequent administration of an anti-shivering medicament. | 05-21-2009 |