Abstract: Embodiments of the disclosure provide methods, systems, computer program products for manipulating a table with an XML column in database. According to the method, a SQL statement for a table is received first, wherein the table comprises an XML column which is a representation of a plurality of logical columns of the table, there is at least one XML element in at least one row and in the XML column of the table, and each of the at least one XML element corresponds to a non-null value in a specific row and in a logical column of the plurality of logical columns of the table. Then the SQL statement is parsed. And then the SQL statement is transformed into a hybrid statement being able to process the XML column in response to the parsing result indicating that the SQL statement relates to at least one logical column of the plurality of logical columns. At last the hybrid statement is executed.

Abstract: An approach is provided in which a method, system, and program product build a time series prediction model based on one or more relationships between a first set of keywords in a set of first news articles and a second set of keywords in a set of second news articles. The time series prediction model includes a time-based interest level adjustment corresponding to a publication time between the set of first news articles and the set second of news articles. The method, system, and program product use the time series prediction model to compute an inherited initial interest level of a third news article that includes a set of new keywords based on the set of new keywords and the time-based interest level adjustment. The method, system, and program product assign the inherited initial interest level to the third news article.

Abstract: Embodiments of the present disclosure describe an approach for database query processing with database clients. According to the approach, a first set of queries are obtained from a plurality of clients in communication with a database server. A second set of queries are generated by normalizing the first set of queries. A set of access paths corresponding to the second set of queries are determined for retrieving data from at least one of the plurality of clients and the database server. Data is retrieved from at least one of the plurality of clients and the database server based on the set of access paths.

Abstract: Systems and methods for high availability distributed data storage are provided. In embodiments, a method includes: receiving, by a remote direct memory access (RDMA) switch operatively coupled to a computing device, a request to access a page of a database; determining, by the RDMA switch, a validation state of the page; determining, by the RDMA switch, a status of the page; updating, by the RDMA switch, the status of the page based on the validation state and the request; and reporting, by the RDMA switch, the validation state.

Abstract: A method, computer program product, and computer system for improving performance of a SQL execution sequence of SQL statements. The SQL execution sequence is recorded in an event log. Original results of executing the SQL statements and an original CPU cost of executing the SQL statements in accordance with the original access path are recorded in a logical log. A new access path is generated from analysis of the event log and the logical log. The SQL statements are executed in accordance with the new access path resulting in new results of executing the SQL statements including a new CPU cost of executing the SQL statements in accordance with the new access path. In response to a determination that the new results replicate the original results and that the new CPU cost is less than the original CPU cost, the original access path is replaced with the new access path.

Abstract: A wearable probe includes a sensor module and a control module. The sensor module includes a transmission source to transmit signals into the tissue at a source position, and two detectors to detect a result of the signals, the two detectors including a first detector positioned at a first separation distance from the source position and a second detector positioned at a second separation distance from the source position. The control module includes a controller and a battery to power the controller and the sensor module. The control module includes a processor, a memory including instructions, and a communications interface. The instructions cause the processor to control the sensor module to transmit signals into the tissue and detect results of the signals with the at least two detectors, receive the detected results, store the detected results in the memory, and transmit the detected results to a remote device.

Abstract: This disclosure provides a computer-implemented method, a computer system and a computer program product for database compression oriented to combinations of fields of a database record. One or more combinations of fields of a record of a database are determined that satisfy a frequency criterion indicating that access frequencies of the one or more combinations of fields are higher than an access frequency threshold. The record is reorganized based on the one or more combinations of fields to store fields of each combination of the one or more combinations of fields in a respective contiguous storage space. The reorganized record is compressed by applying a compression scheme to the one or more combinations of fields.

Abstract: A computer-implemented method to transform and execute queries by merging sparsely populated columns. The method includes receiving, from a host, a first query configured to perform a command on one or more target columns in a database. The method further includes analyzing a set of statistics for the database. The method also includes determining, based on the analyzing, a first column of the one or more target columns is included in a set of sparse columns. The method includes generating a plurality of access plans for the first query, including a first access plan that merges the first column with a second column. The method further includes transforming, based on the first access plan, the first query to merge the first column with the second column. The method also includes executing, in response to the transforming of the first query, the first query.

Abstract: A blower includes a motor housing, a volute disposed on an outer surface of the motor housing, a motor shaft extending through the motor housing, a motor disposed in the motor housing and coaxially mounted to the motor shaft, and a mixed flow impeller disposed in the motor housing and coaxially mounted to the motor shaft. The mixed flow impeller is configured to circulate air inside the motor housing.

Abstract: Described herein is medical imaging technology for concurrent and simultaneous synthesis of a medical CA-free-AI-enhanced image and medical diagnostic image analysis comprising: receiving a medical image acquired by a medical scanner in absence of contrast agent enhancement; providing the medical image to a computer-implemented machine learning model; concurrently performing a medical CA-free-AI-enhanced image synthesis task and a medical diagnostic image analysis task with the machine learning model; reciprocally communicating between the image synthesis task and the image analysis task for mutually dependent training of both tasks. Methods and systems and non-transitory computer readable media are described for execution of concurrent and simultaneous synthesis of a medical CA-free-AI-enhanced image and medical diagnostic image analysis.

Abstract: A die separation ring that causes non-uniform expansion of a semiconductor wafer during a semiconductor wafer expansion process. The die separation ring includes an annular body that extends about a central axis. The annular body of the die separation ring includes a first portion having a first elevation and a second portion having a second elevation that is lower than the first elevation. A third portion extends between the first portion and the second portion forming a transition between the first portion and the second portion.

Abstract: The disclosure provides a laser surface treatment method and a laser surface treatment station. The laser surface treatment method is applied to a surface to be adhesively bonded of a casting of a vehicle body-in-white part, wherein the laser surface treatment method comprises the following steps: S1: providing the casting of the vehicle body-in-white part, the casting having been demolded and machined; and S2: performing laser surface treatment on the surface to be adhesively bonded of the casting, the surface to be adhesively bonded being used for a subsequent adhesive application process for connection of the casting, wherein the laser surface treatment is carried out by pulse laser, and the laser surface treatment employs the following parameters: an average laser power greater than 500 W; a laser frequency ranging from 5 kHz to 10 kHz; and laser single-point energy greater than 50 mJ.

Abstract: A display panel and control methods thereof are provided. In one example, the display panel includes, a first substrate and a second substrate opposite to each other, and a solution encapsulated between the first substrate and the second substrate. In some examples, the solution includes opaque charged particles. In some examples, the first substrate includes a first electrode, the first electrode including a plurality of discrete sub-electrodes, and the second substrate includes a second electrode. Further, the control method may include adjusting an electric field between each of the plurality of discrete sub-electrodes and the second electrode, causing the opaque charged particles to undergo a gathering motion or a scattering motion.

Abstract: In an approach for database self-diagnosis and self-healing, a processor receives a problem description related to a database. A processor classifies the problem description into a natural language description portion and a database-know-who content portion. A processor processes the natural language description portion using natural language processing techniques. A processor evaluates the database-know-who content portion. A processor combines a result of processing the natural language description portion and evaluating the database-know-who content portion. A processor identifies a solution based on the problem description and the combined result. A processor solves a problem using the identified solution.

Abstract: A system collects statistical data for a data page, divides the data page into parts, analyzes the data page and the statistical data, based on compression efficiency of one or more compression methods for each part of each page, to determine a compression method for each part of page, and compresses, based on the analyzing, the parts of the data page.

Abstract: The disclosure relates to an aluminum alloy and a component part prepared therefrom. The aluminum alloy comprises: 7-9 wt% of silicon (Si), 0.15-0.45 wt% of chromium (Cr), 0.1-0.3 wt% of vanadium (V), at least 0.01 wt% of strontium (Sr), 0.1-0.2 wt% of titanium (Ti), 0-0.5 wt% of manganese (Mn), 0-0.8 wt% of iron (Fe) and the balance being aluminum and inevitable impurities. The aluminum alloy of the disclosure can be exempt from heat treatment process after casting in the processing process, so as to contribute to energy conservation and emission reduction, and the component part prepared therefrom can achieve desired mechanical properties.

Abstract: A display substrate and a display device are disclosed, the display substrate has a plurality of sub-pixels arranged in an array, and includes a base substrate, a driving circuit layer, a light-emitting device layer, and a black matrix layer. Each sub-pixel includes a pixel driving circuit in the driving circuit layer and a light-emitting device in the light-emitting device layer, and the black matrix layer includes a plurality of first light-transmitting openings respectively exposing light-emitting devices (EM) of the plurality of sub-pixels, and includes a plurality of second light-transmitting openings respectively between the plurality of first light-transmitting openings. The driving circuit layer includes a plurality of light-transmitting portions, and each of the plurality of second light-transmitting openings is provided corresponding to at least one of the plurality of light-transmitting portions for transmitting light in a predetermined angle range with the surface of the display substrate.

Abstract: A display substrate and a display device are disclosed, the display substrate has a plurality of sub-pixels and includes a base substrate, a driving circuit layer, a light-emitting device layer, and a black matrix layer, the driving circuit layer includes a first signal line and a second signal line arranged parallel to each other and arranged periodically, the black matrix layer includes a plurality of first light-transmitting openings and a plurality of second light-transmitting openings, the plurality of second light-transmitting openings are respectively arranged between the plurality of first light-transmitting openings and orthographic projections of the plurality of second light-transmitting openings (1132) on the base substrate (-1-04)-are respectively between an orthographic projection of one first signal line {&4-on the base substrate 0-04-)-and an orthographic projection of one second signal line (82)-closest to the one first signal line (84)-on the base substrate

Abstract: Database log writing is based on log pipeline contention. A determination is made as to whether contention in writing data to a log pipeline, which is used in writing data from memory to storage, is at a prespecified level. Based on determining that the contention in writing the data to the log pipeline is at the prespecified level, a split operation is automatically performed to create a new log pipeline.

Abstract: Waveguides, such as light guides, made entirely of elastomeric material or with indents on an outer surface are disclosed. These improved waveguides can be used in scissors, soft robotics, or displays. For example, the waveguides can be used in a strain sensor, a curvature sensor, or a force sensor. In an instance, the waveguide can be used in a hand prosthetic. Sensors that use the disclosed waveguides and methods of manufacturing waveguides also are disclosed.