Abstract: A computer implemented method, system, and program product are provided. In response to receiving a request for a structured query language (SQL) statement from a requestor, a current request count is incremented. A matching entry in a discards list is located, whereby the match comprises, a discarded SQL statement equaling the requested SQL statement. Based on there being the matching entry, the matching entry is removed from the discards list. A proximity between the current request count and a previous request count is created. A threshold is created based on a configurable number of times of a maximum SQL statement cache size. The poolability of the requested SQL statement is determined. The requested SQL statement is returned to the requestor. Periodically, maintenance is performed on the discards list.

Abstract: Systems and methods of the present disclosure enable a processor to receive at least one proposed file structure and input the at least one proposed file structure into an instant structure generation model that generates unique candidate file structures. The processor may access accepted historical file structures and input the unique candidate file structures and the accepted historical file structures into at least one structure similarity machine learning model to output a subset of unique candidate file structures. The processor may display a list of the subset of unique candidate file structures via a graphical user interface that includes a one-click action element for each unique candidate file structure.

Abstract: Compositions that include cannabinoids other than tetrahydrocannabinol (THC), such as cannabigerol (CBG) in combination with tetrahydrocannabinol (THC) or formulated to be combined with THC, and methods of preparation and use thereof are described. The compositions may be useful to reduce the risk of THC-induced anxiety and/or to produce a different intoxicating effect compared to THC alone.

Abstract: A computer implemented method manages connections. A number of processor units monitor connection requests to access a set of backend resources. The number of processor units identify request groups for the connection requests based on authentication data in the connection requests. The number of processor units analyze the connection requests to identify a usage trend for connections by the request groups. The number of processor units predict the usage trend of the connections for a period of time to form a predicted usage trend for connections in the period of time. The number of processor units manage a connection pool based on the predicted usage trend for the connections in the period of time.

Abstract: A computer implemented method manages connections in a connection pool. A computer system creates a modified call stack for a connection request in response to receiving the connection request. The modified call stack comprises elements that call prepared statements that are part of an application logic for the connection request. The computer system identifies a group of potential connections from the connections in the connection pool matching the connection request. The group of potential connections is associated with a group of associated modified call stacks that call the prepared statements. The computer system determines a group of weighted match scores for the group of associated modified call stacks from a comparison of the modified call stack with the group of associated modified call stacks. The computer system selects a connection from the group of potential connections based on a highest weighted match score in the group of weighted match scores.

Abstract: Processing methods is provided. A method is designated as schedulable. A completion stage is generated for the method. A return of the completion stage corresponding to the method is received. It is determined whether a state of the completion stage indicates continued execution of the method. In response to determining that the state of the completion stage does indicate continued execution of the method, a set of executions of the method is continued based on an execution return of the method being a null return.

Abstract: A computer implemented method manages connections. A number of processor units monitor connection requests to access a set of backend resources. The number of processor units identify request groups for the connection requests based on authentication data in the connection requests. The number of processor units analyze the connection requests to identify a usage trend for connections by the request groups. The number of processor units predict the usage trend of the connections for a period of time to form a predicted usage trend for connections in the period of time. The number of processor units manage a connection pool based on the predicted usage trend for the connections in the period of time.

Abstract: An example operation may include one or more of connecting, by a transaction manager node, to a blockchain configured to store transaction data, receiving, by the transaction manager node, a transaction from a user node, the transaction includes a transactional operation, performing, by the transaction manager node, the transactional operation on an at least one two-phase commit capable resource, writing, by the transaction manager node, the transaction data into a recovery log, committing, by the transaction manager node, the transaction to the blockchain, and in response to an unknown outcome of the commit of the transaction, executing a recovery operation.

Abstract: An example operation may include one or more of connecting, by a transaction manager node, to a blockchain configured to store transaction data, receiving, by the transaction manager node, a transaction from a user node, the transaction includes a transactional operation, performing, by the transaction manager node, the transactional operation on an at least one two-phase commit capable resource, writing, by the transaction manager node, the transaction data into a recovery log, committing, by the transaction manager node, the transaction to the blockchain, and in response to an unknown outcome of the commit of the transaction, executing a recovery operation.

Abstract: A technique provides for combining a subsea housing, e.g. a subsea low-pressure wellhead housing, and a casing. The casing may be in the form of a large diameter conductor positioned in a seabed to facilitate deployment of desired types of tubulars and other components in a subsea well. The casing is inserted into the subsea housing along an interior surface of the subsea housing. The casing is joined to the subsea housing by radial expansion of the casing until the casing is forced into a suitable engagement with the subsea housing.

Abstract: A mineral extraction system may include a running tool configured to install a wellhead component in a wellhead assembly. The mineral extraction system may also include a plurality of sensors configured to monitor parameters of the running tool during the process of installing the wellhead component. Additionally, the mineral extraction system may include a controller configured to receive signals from the sensors and to provide indications based on the signals.

Abstract: A technique provides for the combined use of a tool and a sensor system to deploy a subsea structural casing. The tool has an engagement region configured to couple with the subsea structural casing. The sensor system is operatively coupled with the tool and comprises a plurality of sensors. The sensors are used to monitor height of the subsea structural casing above a mud line as well as angular deviation of the structural casing during deployment of the subsea structural casing into a seabed.

Abstract: Described herein are methods and systems that can provide independent energy generation as well as systems for the generation of other useful products, such as chemicals. In addition, the systems and methods can provide ways of harnessing the potential of biomass feedstock to generate of multitude of products including green crude, biogas, electricity, heat, fatty acids, biodiesel, ammonia, and chemical products. In many cases, the systems and methods herein utilize anaerobic microorganisms, including aquatic and ruminant organisms, to digest material and create products.

Abstract: A mineral extraction system may include a running tool configured to install a wellhead component in a wellhead assembly. The mineral extraction system may also include a plurality of sensors configured to monitor parameters of the running tool during the process of installing the wellhead component. Additionally, the mineral extraction system may include a controller configured to receive signals from the sensors and to provide indications based on the signals.

Abstract: Described herein are methods and systems that can provide independent energy generation as well as systems for the generation of other useful products, such as chemicals. In addition, the systems and methods can provide ways of harnessing the potential of biomass feedstock to generate of multitude of products including green crude, biogas, electricity, heat, fatty acids, biodiesel, ammonia, and chemical products. In many cases, the systems and methods herein utilize anaerobic microorganisms, including aquatic and ruminant organisms, to digest material and create products.

Abstract: A shingle and a method of roofing using a plurality of the shingles. The shingle comprises an upper surface comprising an attachment area and an exposed area having a coating and an inking. The attachment area is in a plane lower than a plane of the exposed area and extends longitudinally along a top of the exposed area and horizontally along a side of the exposed area. The shingle comprises a bottom surface opposite the upper surface and an adhesive layer applied to a length of the attachment area adjacent to the exposed area. The shingles are attached to each other by the adhesive layer.

Abstract: An apparatus contains photosynthetic marine microorganisms within water, to permit the marine microorganisms to be cultivated and harvested. A self-supporting buoyant frame of the apparatus is to be placed within the water. A mesh lining of the apparatus is situated within the interior of the frame. The mesh lining is adapted to permit the water and nutrients to enter through the mesh lining while at least substantially preventing the marine microorganisms that are being cultivated from escaping through the mesh lining. A funnel of the apparatus is attached to a corresponding hole at a bottom of the mesh lining, and is adapted to permit the marine microorganisms that have been cultivated to be harvested. A buoyancy leveling subsystem of the apparatus is adapted to control an extent to which the frame is submerged within the water.

Abstract: Undesirable components are removed from water while photosynthetic marine microorganisms within the water are contained, cultivated, and harvested. An apparatus is placed within the water. The apparatus has a mesh lining adapted to permit the water, the undesirable components, and nutrients to enter through the mesh lining while at least substantially preventing the marine microorganisms that are being cultivated from escaping through the mesh lining. The marine microorganisms are cultivated, including by adding the nutrients to the water. The nutrients at least accelerate growth of the marine microorganisms, where the marine microorganisms feed off the undesirable components and the nutrients. The marine microorganisms that have been cultivated are then harvested, which includes removing the marine microorganisms from the water.

Abstract: A system, method, and computer program for design validation, comprising defining a plurality of requirements; extracting said plurality of requirements; comparing a design against said plurality of requirements; and reporting a result of said comparison, and appropriate means and computer-readable instructions.

Abstract: The status of a video call is displayed in a simplified and intuitive graphical user interface that presents status information of individual video devices of the video call with graphical or color indications with a gauge metaphor, such as a vertically or horizontally aligned bar of icons. Each video device of the video call is represented by an icon having a display position or color so that the icons are arranged to depict video devices together that have similar states. For instance, a video call is represented by a bar of icons ordered by the status of each video device with icons having the same color located contiguous with each other so that a video call with an overall good status appears as a green bar and a video call with an overall poor status appears as a red bar with red icons indicating failed video devices. A summary icon summarizes the overall state of a video call by indicating the color or graphical information of the video device of the video call that has the problem of greatest concern.