Abstract: A method for query processing includes receiving a query, and determining a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations. Based on the determination, the method includes processing the query to generate an output, and performing a predetermined number of maximum group by operations on the output based on the query type to generate a response to the query.

Abstract: The disclosed invention ensures safe operation of an electrical switchgear by preventing an operator from contacting or interacting with an active circuit breaker. One way this is accomplished is through a locking system that prevents a door to the interior of the switchgear from opening until the circuit breaker is in a disengaged position. A second way this is accomplished is by a manipulation restriction system that prevents the circuit breaker from being manually moved unless the door is closed. Another way this is accomplished is by a circuit breaker decoupler, accessible from the exterior of the switchgear that can directly manipulate the circuit breaker into disengagement.

Abstract: This specification discloses techniques for communicating data between a first execution context on a computing system and a second execution context on the computing system. The first execution context can execute content from a first origin, the second execution context can execute content from a second origin that is different from the first origin, and the first execution context and the second execution context can each be restricted from accessing data of the other as a result of a same-origin policy implemented by the computing system. The method can include establishing a bi-directional communication channel between the first execution context and the second execution context.

Abstract: A powered banding device includes a housing and a plurality of gripping rollers within the housing that are configured to pull a tail end of a band through a feed slot as the gripping rollers rotate. The device also includes torque circuitry coupled to an electric motor driving the plurality of gripping rollers, which the torque circuitry is configured to calculate a torque on the band using a motor current to determine when to stop pulling. A roller pin is configured to move through a roller slot after the electric motor stops pulling to form a fold in the band as the roller pin moves to an end of a downward curved portion of the roller slot. A cutter blade behind the roller pin follows the roller pin and cuts the band above the roller pin and flattens a cut end over a buckle of the band.

Abstract: A laminate comprises a first layer comprising a plurality of lower opacity zones positioned within a higher opacity zone is provided. The plurality of lower opacity zones form a first pattern. The laminate comprises a second layer comprising a second pattern. The laminate comprises a non-joined span of the first and second layers having a dimension of at least about 20 mm. A first portion of the second pattern is visible through at least some of the plurality of lower opacity zones when the first layer, within the non-joined span, is in a first position relative to the second layer, within the non-joined span. A second portion of the second pattern is visible through at least some of the plurality of lower opacity zones when the first layer, within the non-joined span, is in a second position relative to the first layer, within the non-joined span.

Abstract: A method and system of monitoring crimp quality of a crimp terminal in a hydraulic crimping apparatus. The method includes: determining a pressure of a hydraulic fluid supplied to a hydraulic crimping head of the hydraulic crimping apparatus; determining a flow of the hydraulic fluid supplied to the hydraulic crimping head of the hydraulic crimping apparatus; and analyzing the pressure and the flow of the hydraulic fluid to determine if a crimp is defective or not defective.

Abstract: A system, method, and apparatus for Internet Protocol television streaming are disclosed. An example apparatus includes a remote access point configured to receive television programming via a data feed from a television service provider. The remote access point is specifically assigned to an application operating on a client device. The apparatus also includes a connection controller configured to determine television programming received in the remote access point is to be transmitted to the specific application operating on the client device and transmit the encrypted television programming to the application via a secure communication channel. The apparatus also includes a management controller configured to provision a virtual local area network between the remote access point and the connection controller and provision the secure communication channel from the connection controller to the application operating on the client device.

Abstract: Crimp tooling includes an anvil and a wire crimper. The anvil includes a base and a tip with a cradle at the tip for supporting a terminal. The anvil has first and second anvil guide surfaces located relative to the cradle. The wire crimper has first and second legs on opposite sides of a crimp slot that receives the cradle and the terminal supported by the cradle. The wire crimper defines a crimp profile in the crimp slot configured to form the terminal during crimping. The first and second legs have first and second wire crimper guide surfaces, respectively. The first and second wire crimper guide surfaces are configured to engage the first and second anvil guide surfaces, respectively, to guide a position of the wire crimper relative to the anvil.

Abstract: A laminate comprises a first layer comprising a plurality of lower opacity zones positioned within a higher opacity zone is provided. The plurality of lower opacity zones form a first pattern. The laminate comprises a second layer comprising a second pattern. The laminate comprises a non-joined span of the first and second layers having a dimension of at least about 20 mm. A first portion of the second pattern is visible through at least some of the plurality of lower opacity zones when the first layer, within the non-joined span, is in a first position relative to the second layer, within the non-joined span. A second portion of the second pattern is visible through at least some of the plurality of lower opacity zones when the first layer, within the non-joined span, is in a second position relative to the second layer, within the non-joined span.

Abstract: The present disclosure is directed to absorbent articles with substrates or topsheets having repeating patterns of apertures comprising a plurality of repeat units. Each of the repeat units comprises at least three apertures.

Abstract: A three-dimensional, nonwoven substrate having at least a non-apertured zone and an apertured zone, and articles or absorbent articles including one of more of such substrates are provided.

Abstract: Systems and methods for improving search results using social routing are provided. In example embodiments, an affinity metric and match metric are determined for a plurality of users. The affinity metric indicates an interaction level between a given user and the match metric indicates how well the given user matches parameters of a search string. Based on a correlation between the affinity metric and the match metric, one or more items of content may be transmitted to one or more selected users. Improved search results can then be generated based on interactions with the one or more items of content.

Abstract: Systems and methods for improving search results using assessment based routing are provided. In example embodiments, social network data for members in an organization and members outside the organization is accessed. An internal member and external member may share one or more attributes, such as working on the same project or within the same company. An electronic assessment can be sent to the internal member to generate assessment data about the external member. The assessment data can be included in an electronic message sent to the external member. Interaction data from the electronic message can be received when the external member opens and interacts with the electronic message.

Abstract: Systems, methods, and apparatuses for installing a software product using timestamp validation and system identification validation are disclosed. An example method to lock a software product in a software wrapper includes determining a unique hard drive serial number of a user device to which the software product is to be installed and generating a hash number of the unique hard drive serial number. The example method also includes determining a campaign identifier of the software product from a secure variable within the software product and generating a date-time code based on a current date and time. The method further includes assembling the date-time code and the campaign identifier into an unlock code, encrypting the unlock code using the hash number as a passphrase key to create an encrypted unlock code, and applying the encrypted unlock code to an end of a filename of an installer using a command line parameter.

Abstract: In an example, data from a source location is merged into a target location containing existing data, in which the source location and the target location contain tuples of data. For each tuple in the source location, during a single operation, a determination is made as to whether there is a matched tuple in the target location that satisfies a predetermined condition. For each matched tuple that satisfies the predetermined condition, the matched tuple in the target location is updated with a count value that is equal to a count of the matched tuple in the source location and the target location. In addition, for each tuple that does not have a matched tuple that satisfies the predetermined condition, the unmatched tuple is inserted into the target location.

Abstract: A mobile hologram apparatus is disclosed. An example apparatus includes a sheet folded along preformed creases into a pyramid structure configured to be actuated between a compressed state and an uncompressed state. The pyramid structure has a base section and a top section connected by four side sections. The pyramid structure in the compressed state has a height that is less than 1/10th the height of the pyramid structure in the uncompressed state. The apparatus also includes an elastic band connected to a perimeter of the base section of the pyramid structure and configured to cause the pyramid structure to self-actuate from the compressed state to the uncompressed state.

Abstract: A mobile hologram apparatus is disclosed. An example apparatus includes a sheet folded along preformed creases into a pyramid structure configured to be actuated between a compressed state and an uncompressed state. The pyramid structure has a base section and a top section connected by four side sections. The pyramid structure in the compressed state has a height that is less than 1/10th the height of the pyramid structure in the uncompressed state. The apparatus also includes an elastic band connected to a perimeter of the base section of the pyramid structure and configured to cause the pyramid structure to self-actuate from the compressed state to the uncompressed state.

Abstract: In various implementations, methods and systems for drawing in a three-dimensional (3D) virtual reality environment are provided. An intersection between a user input and an object, associated with a three-dimensional (3D) virtual reality environment is identified. An anchor position is determined for a drawing surface based on the identified intersection. A gaze direction of a user in the 3D virtual reality environment is identified. A drawing surface configuration for the drawing surface with respect to the 3D virtual reality environment is determined based on the gaze direction, where the drawing surface configuration indicates how the drawing surface is defined in the 3D virtual reality environment. The drawing surface is defined in the 3D virtual reality environment at the determined anchor position with the determined drawing surface configuration. A drawing is generated on the drawing surface based on drawing input.

Abstract: Systems, methods, and apparatuses for installing a software product using timestamp validation and system identification validation are disclosed. An example method to lock a software product in a software wrapper includes determining a unique hard drive serial number of a user device to which the software product is to be installed and generating a hash number of the unique hard drive serial number. The example method also includes determining a campaign identifier of the software product from a secure variable within the software product and generating a date-time code based on a current date and time. The method further includes assembling the date-time code and the campaign identifier into an unlock code, encrypting the unlock code using the hash number as a passphrase key to create an encrypted unlock code, and applying the encrypted unlock code to an end of a filename of an installer using a command line parameter.