Patent application number | Description | Published |
20080208822 | ANALYTIC ENHANCEMENTS TO MODEL CLAUSE IN STRUCTURED QUERY LANGUAGE (SQL) - A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value. | 08-28-2008 |
20110106790 | Rewrite of Queries Containing Rank or Rownumber or Min/Max Aggregate Functions Using a Materialized View - Techniques are provided for improving efficiency of database systems, and in particular, to refreshing materialized views maintained by database systems and rewriting queries to access the materialized views. According to the approaches, a ranked materialized view is incrementally refreshed, and during the incremental refresh operation, rows in the partitions of the materialized view are ranked within the partitions. | 05-05-2011 |
20110137875 | INCREMENTAL MATERIALIZED VIEW REFRESH WITH ENHANCED DML COMPRESSION - An incremental refresh of a materialized view may be simplified, and therefore made more cost efficient, by reducing the number of DML operations being merged with the materialized view during the incremental refresh. Specifically, subsequences of sequences of data manipulation language operations that have been recorded for a particular row of a base table may be inspected to determine whether the subsequences conform to particular patterns of data manipulation language operator types. If a subsequence conforms to one of the particular patterns, the subsequence may be replaced with a single substitute: either a single data manipulation language operation, or null. Refresh operations that are generated based on the simplified sequences of data manipulation language operations are more simple, and therefore, less costly to perform. | 06-09-2011 |
20110167091 | ANALYTIC ENHANCEMENTS TO MODEL CLAUSE IN STRUCTURED QUERY LANGUAGE (SQL) - A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value. | 07-07-2011 |
20140095502 | CLUSTERING A TABLE IN A RELATIONAL DATABASE MANAGEMENT SYSTEM - Techniques are provided that address the problems associated with prior approaches for clustering a fact table in a relational database management system. According to one aspect of the invention, a database server clusters a fact table in a database based on one or more dimension tables. More specifically, rows are stored in the fact table in a sorted order and the order in which the rows are sorted is based on values in one or more columns of one or more of the dimension tables. A user specifies the columns of the dimension tables on which the sorted order is based in “clustering criteria”. The database server uses the clustering criteria to automatically store the rows in the fact table in the sorted order in response to certain user-initiated database operations on the fact-table. | 04-03-2014 |
20140095520 | PRUNING DISK BLOCKS OF A CLUSTERED TABLE IN A RELATIONAL DATABASE MANAGEMENT SYSTEM - Techniques are provided for generating a “dimensional zonemap” that allows a database server to avoid scanning disk blocks of a fact table based on filter predicates in a query that qualify one or more dimension tables. The zonemap divides the fact table into sets of contiguous disk blocks referred to as “zones”. For each zone, a minimum value and a maximum value for each of one or more “zoned” columns of the dimension tables is determined and maintained in the zonemap. For a query that contains a filter predicate on a zoned column, the predicate value can be compared to the minimum value and maximum value maintained for a zone for that zoned column to determine whether a scan of the disk blocks of the zone can be skipped. | 04-03-2014 |
20140214754 | Scalable and Adaptive Evaluation of Reporting Window Functions - According to one aspect of the invention, for a database statement that specifies evaluating reporting window functions, a computation-pushdown execution strategy may be used for the database statement. The computation-pushdown execution plan includes producer operators and consolidation operators. Each producer operator computes a respective partial aggregation for each reporting window function based on a subset of rows, and broadcasts the respective partial aggregation. Each consolidation operator fully aggregates all partial aggregations broadcasted from the producer operators. Alternatively, an extended-data-distribution-key execution plan may be used. Each producer operator sends rows based on hash keys to sort operators for computing partial aggregations for at least one reporting window function based on a subset of rows. Each consolidation operator receives and fully aggregates all partial aggregations broadcasted from the sort operators. | 07-31-2014 |
20140280023 | ADAPTIVE SELECTION OF A DISTRIBUTION METHOD DURING EXECUTION OF PARALLEL JOIN OPERATIONS - A method, system, and computer program product for high-performance database systems. The method commences by estimating, during a compile phase, a statically-calculated system cost of performing parallel join operations over two relations, then selecting, during the compile phase, a first distribution method to perform the parallel join operations. Instructions (e.g., table partitioning) are communicated to two or more execution units for execution of the parallel join operations, and during execution, various measurements are taken pertaining to the performance of a first portion of the parallel join operations using the selected first distribution method. Then, responsive to the measurements a second distribution method is selected and corresponding instructions are communicated to the two or more execution units. The parallel join operations continue, now using the second distribution method. | 09-18-2014 |
20140280029 | OUT-OF-PLACE MATERIALIZED VIEW REFRESH - Techniques are provided for performing a refresh or update of a materialized view without modifying the materialized view. Such a refresh is referred to as an out-of-place materialized view refresh. An out-of-place materialized view refresh involves creating one or more outside tables into which data will be inserted. During the refresh, the materialized view may be accessible for query processing, even though the materialized view contains “stale” data. After the insertion, the one or more outside tables are made accessible for query processing and future queries will target the one or more outside tables instead of the materialized view. | 09-18-2014 |
20150199407 | PRUNING DISK BLOCKS IN A RELATIONAL DATABASE MANAGEMENT SYSTEM - Techniques are provided for generating a “dimensional zonemap” that allows a database server to avoid scanning disk blocks of a fact table based on filter predicates in a query that qualify one or more dimension tables. The zonemap divides the fact table into sets of contiguous disk blocks referred to as “zones”. For each zone, a minimum value and a maximum value for each of one or more “zoned” columns of the dimension tables is determined and maintained in the zonemap. For a query that contains a filter predicate on a zoned column, the predicate value can be compared to the minimum value and maximum value maintained for a zone for that zoned column to determine whether a scan of the disk blocks of the zone can be skipped. | 07-16-2015 |
Patent application number | Description | Published |
20130037125 | PRESSURE RELIEF VALVE ASSEMBLY - A pressure relief valve assembly includes a body having a passage extending therethrough. The body includes an upstream end adapted to be connected to a source of fluid pressure, an intermediate portion, and a downstream end having a downstream exit. A rupture disk is mounted in the passageway and blocks the fluid pressure of the source from the downstream end. In operation, the rupture disk configured to rupture above a predetermined differential fluid pressure. A catcher is disposed in the passage downstream of the rupture disk. The catcher generally includes a disk portion with at least one opening sized to prevent passage of the rupture disk through the catcher in response to a rupture disk failure while simultaneously allowing fluid flow through the catcher to the downstream exit. | 02-14-2013 |
20140048734 | PLUG VALVE HAVING PRELOADED SEAL SEGMENTS - A plug valve including a valve body having an inlet port, an outlet port and a central chamber extending between the inlet port and the outlet port. The valve also includes an inlet seal segment within the central chamber and includes a bore extending therethrough and aligned with the inlet port. An outlet seal segment is disposed within the central chamber having a bore extending therethrough and aligned with the outlet port. A plug member is disposed in the central chamber and is moveable between an open position, to facilitate fluid flow through the plug valve, and a closed position, to block fluid flow through the plug valve. First and second side segments are disposed between and interlocked to the inlet and outlet seal segments to encircle the plug member. The side segments are tensioned to preload the seal segments against the plug member to prevent the flow of fluid between the seal segments and the plug member. | 02-20-2014 |
20150042088 | SWIVEL JOINT WITH UNIFORM BALL BEARING REQUIREMENTS - A swivel joint has uniform ball bearing requirements for all bearing races. The swivel joint has a male connector and a female connector that coaxially interconnects and swivel relative to each other while still maintaining a high pressure seal. Each connector has three bearing races to form three sets of bearing races, each of which supports the same number of ball bearings. The circumference of the main set of races are enlarged by less than the diameter of one ball, so it is impossible to add another ball to the coupled male and female connectors of the swivel joint. | 02-12-2015 |
20150345646 | PLUG VALVE HAVING PRELOADED SEAL SEGMENTS - A plug valve including a valve body having an inlet port, an outlet port and a central chamber extending between the inlet port and the outlet port. The valve also includes an inlet seal segment within the central chamber and includes a bore extending therethrough and aligned with the inlet port. An outlet seal segment is disposed within the central chamber having a bore extending therethrough and aligned with the outlet port. A plug member is disposed in the central chamber and is moveable between an open position, to facilitate fluid flow through the plug valve, and a closed position, to block fluid flow through the plug valve. First and second side segments are disposed between and interlocked to the inlet and outlet seal segments to encircle the plug member. The side segments are tensioned to preload the seal segments against the plug member to prevent the flow of fluid between the seal segments and the plug member. | 12-03-2015 |
Patent application number | Description | Published |
20090008934 | SWIVEL JOINT WITH UNIFORM BALL BEARING REQUIREMENTS - A swivel joint has uniform ball bearing requirements for all bearing races. The swivel joint has a male connector and a female connector that coaxially interconnect and swivel relative to each other while still maintaining a high pressure seal. Each connector has three bearing races to form three sets of bearing races, each of which supports the same number of ball bearings. The circumference of the main set of races are enlarged by less than the diameter of one ball, so it is impossible to add another ball to the coupled male and female connectors of the swivel joint. | 01-08-2009 |
20100147866 | Ball Injector - An apparatus for loading and dispensing balls into a flow stream. The apparatus has an outer housing with a smooth cylindrical inner surface, and an inner housing, removably mounted within the outer housing. The inner housing has a hollow cylindrical body extending longitudinally between a lower guide plate and an upper guide band. A plurality of longitudinal slots are located in and extend the length of the cylindrical body and through the lower guide plate. The width of the slots is greater than the diameter of the balls. The apparatus also has a shaft with a smooth cylindrical outer surface, coaxially, rotatably, and removably mounted in the inner housing. The distance between the outer surface of the shaft and the inner surface of the outer housing is greater than the diameter of the balls. | 06-17-2010 |
20100263744 | Flowline Flapper Valve - A check valve assembly has a body having a central cavity intersected by upstream and downstream flow passages. A seat is secured by a threaded engagement in the upstream flow passage. An access bore intersects the cavity and has a support shoulder formed in it. A holder is supported on the support shoulder. A flapper is pivotally secured to the holder and located in the cavity for movement between an open position and a closed position blocking flow through the seat. A straight edge portion in the access bore engages a straight edge portion of the holder to prevent rotation of the holder. A fastener extends through a hole in the support shoulder into engagement with the seat to prevent rotation of the seat. | 10-21-2010 |
20100308246 | Plug Valve Indicator - A valve has a body having a rotatable valve element. A drive mechanism has a drive input member and a drive output member that are coupled to the valve element for rotating the valve element. A shear member is operatively located within the drive mechanism between the drive input member and the drive output member for shearing in the event the force to rotate the valve element is excessive. The valve has indicia indicating open and closed positions for the valve element. An indicator is mounted to output drive member to properly align with the indicia regardless whether the shear member has sheared or not. | 12-09-2010 |
20130000745 | FLOWLINE FLAPPER VALVE - A check valve assembly has a body having a central cavity intersected by upstream and downstream flow passages. A seat is secured by a threaded engagement in the upstream flow passage. An access bore intersects the cavity and has a support shoulder formed in it. A holder is supported on the support shoulder. A flapper is pivotally secured to the holder and located in the cavity for movement between an open position and a closed position blocking flow through the seat. A straight edge portion in the access bore engages a straight edge portion of the holder to prevent rotation of the holder. A fastener extends through a hole in the support shoulder into engagement with the seat to prevent rotation of the seat. | 01-03-2013 |
20130299727 | Plug Valve Indicator - A valve has a body having a rotatable valve element. A drive mechanism has a drive input member and a drive output member that are coupled to the valve element for rotating the valve element. A shear member is operatively located within the drive mechanism between the drive input member and the drive output member for shearing in the event the force to rotate the valve element is excessive. The valve has indicia indicating open and closed positions for the valve element. An indicator is mounted to output drive member to properly align with the indicia regardless whether the shear member has sheared or not. | 11-14-2013 |
20140048158 | AUTOMATED RELIEF VALVE CONTROL SYSTEM AND METHOD - A pressure relief valve system for use in a downhole operation may include a pressure relief valve configured to relieve pressure from high pressure tubing extending between a pump and a wellhead, and may include a sensor operably disposed to detect pressure in the high pressure tubing. The pressure relief valve system also may include a controller having a pressure threshold stored therein. The controller may be configured to receive data from the sensor and compare the detected pressure to the stored pressure threshold. A valve actuation system may be in communication with the pressure relief valve and in communication with the controller. The valve actuation system may be configured to change the state of the pressure relief valve from a closed state to an open state in response to a command signal from the controller. | 02-20-2014 |
20140048255 | AUTOMATED RELIEF VALVE CONTROL SYSTEM AND METHOD - A pressure relief valve system for use in a downhole operation may include a pressure relief valve configured to relieve pressure from high pressure tubing extending between a pump and a wellhead, and may include a sensor operably disposed to detect pressure in the high pressure tubing. The pressure relief valve system also may include a controller having a pressure threshold stored therein. The controller may be configured to receive data from the sensor and compare the detected pressure to the stored pressure threshold. A valve actuation system may be in communication with the pressure relief valve and in communication with the controller. The valve actuation system may be configured to change the state of the pressure relief valve from a closed state to an open state in response to a command signal from the controller. | 02-20-2014 |
Patent application number | Description | Published |
20130046863 | Prioritizing Local and Network Traffic - According to some aspects as described herein, a user may purchase or otherwise be provided with an accelerated service for selected software applications, devices, and/or ports to experience a high level of communication. The accelerated service may be created, for example, by using a dedicated network data flow such that the user's customer premise equipment (CPE) network access device may put priority traffic in a different upstream data flow than the commonly shared flow, which may involve tagging the traffic upstream to the network with a priority indicator such as a flow identifier. Based on similar factors, the user may also control local priority of data received downstream from the network for distribution to one or more local devices. | 02-21-2013 |
20150229561 | Prioritizing Local and Network Traffic - According to some aspects as described herein, a user may purchase or otherwise be provided with an accelerated service for selected software applications, devices, and/or ports to experience a high level of communication. The accelerated service may be created, for example, by using a dedicated network data flow such that the user's customer premise equipment (CPE) network access device may put priority traffic in a different upstream data flow than the commonly shared flow, which may involve tagging the traffic upstream to the network with a priority indicator such as a flow identifier. Based on similar factors, the user may also control local priority of data received downstream from the network for distribution to one or more local devices. | 08-13-2015 |
Patent application number | Description | Published |
20140028723 | VISUAL SCENES FOR TEACHING A PLURALITY OF POLYSEMOUS SYMBOL SEQUENCES AND CORRESPONDING RATIONALES - A method includes displaying a second electronic screen overlay on a display, in response to an initial selection of one of provided polysemous symbols, the second electronic screen overlay being the electronic screen overlay associated with the selected polysemous symbol; storing, in the memory, a plurality of visual scenes, each respective one of the plurality of visual scenes being stored in association with at least two symbol sequences beginning with the initially selected polysemous symbol; and displaying one of the plurality of visual scenes on the display, in response to selection of one of the symbols on the displayed second electronic screen overlay, the displayed visual scene being stored in the memory in association with at least two symbol sequences including, in sequence, the initially selected polysemous symbol and the selected one of the symbols on the displayed second electronic screen overlay. | 01-30-2014 |
20150177982 | APPARATUS, COMPUTER READABLE MEDIUM AND METHOD FOR EFFECTIVELY NAVIGATING POLYSEMOUS SYMBOLS ACROSS A PLURALITY OF LINKED ELECTRONIC SCREEN OVERLAYS, INCLUDING USE WITH VISUAL INDICATORS - A method, apparatus and computer readable medium are disclosed. In at least one embodiment, the method includes providing polysemous symbols for selection on an initial electronic screen overlay displayed on a display; storing, in a memory, a plurality of the selectable polysemous symbols in association with a pointer identifying display of an electronic screen overlay which is different from the initial electronic screen overlay; and displaying a second electronic screen overlay on the display, in response to initial selection of one of the provided polysemous symbols. In at least one embodiment, the second electronic screen overlay is the electronic screen overlay associated with the selected polysemous symbol. | 06-25-2015 |