Abstract: A DBMS receives a database-access request that includes an instruction to non-destructively read a database table row. The DBMS assigns the request a TSN identifier and creates a TSN image that identifies all TSNs assigned to transactions that are not yet committed. The DBMS traverses a linked list of log entries that identifies a chronological history of transactions performed on the same row. The DBMS infers that the table row currently contains data stored by the most recently logged transaction that is not contained in the TSN image and that has thus been committed. The DBMS then continues to process statements of the transaction based on the assumption that the row contains the inferred value. The DBMS performs this procedure without acquiring a shared lock on the data page or on the index leaf page that points to the table row.

Abstract: Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: receiving, by a production database, a query statement for processing by the production database; the production database in performing runtime execution processing of the query statement identifying one or more query statement value of the query statement; the production database in performing runtime execution processing of the query statement establishing, using a predictive model, an access path based on the identified one or more query statement value; and the production database using the established access path in performing runtime execution processing of the query statement.

Abstract: Disclosed are a backlight module, a control method therefor and a display device, a driving method therefor. A backlight source is divided into light-emitting areas, and a current control circuit for driving the light-emitting area to emit light is configured for each light-emitting area. The light-emitting areas in the backlight module are arranged in one-to-one correspondence to the current control circuits.

Abstract: An error recovery method and apparatus, and a system are disclosed. At least two CPUs in a lockstep mode can exit the lockstep mode when an error occurs in at least one CPU, and the CPU in which the error occurs and a type of the error are determined. When the error can be recovered, the CPU in which the error occurs can be recovered according to a correctly running CPU. This helps the at least two CPUs run again at a position at which a service program is interrupted.

Abstract: In an approach for optimizing query executions a processor receives a request to transfer data from a first table to a second table. A processor detects a relationship between the first table and the second table, wherein the relationship is based on a similarity between the first table and the second table. A processor identifies at least a first access path for transferring the data from the first table to the second table. A processor calculates a first cost of transferring the data from the first table to the second table using the first access path based on the similarity between the first table and the second table, wherein the first cost indicates estimated processor usage to transfer the data.

Abstract: The present disclosure provides methods and systems for detecting or inferring levels of Copy Number Variants (CNVs) in cell-free nucleic acid samples to detect or assess cancer and prenatal diseases. Cell-free nucleic acid methylation sequencing data may be utilized to distinguish tumor-derived or fetal-derived sequencing reads from normal cfDNA sequencing reads. Each cell-free nucleic acid sequencing read (e.g., containing tumor or fetal methylation markers) may be classified as corresponding to a tumor/fetal-derived or a normal-plasma cell-free nucleic acid, based on the methylation cfDNA sequencing data (e.g., obtained using Bisulfite sequencing or bisulfite-free sequencing methods) and tumor/fetal methylation markers. Next, a profile of the tumor/fetal-derived sequencing read counts may be constructed and then normalized. The CNV status (e.g., gain or loss) of each genomic region may be inferred, and a diagnosis or prognosis can be made based on a subjects inferred CNV profile.

Abstract: A liquid storage and controlled-release device and a biological detection chip. The liquid storage and controlled-release device comprises a liquid storage capsule with a liquid storage body which is deformable under a pressure, and a sealing layer for sealing the liquid storage body. A support platform is provided right below the liquid storage capsule and tightly connected with the liquid storage capsule, wherein, a directional release chamber is provided at the middle of the support platform, and the directional release chamber is provided with a guiding chamber for collecting the liquid and a sharp edge for inducing break. Compared with the conventional technology, the opening for liquid release is at the end far away from the rotation center, so that the liquid can be released completely by the centrifugal force, ensuring the quantitative release of stored liquid and reducing the influence on the accuracy of the subsequent detection.

Abstract: The present disclosure provides a driving circuit and a driving method thereof, an array substrate, a display device, and a driving method thereof. The driving circuit is applied for driving a light-emitting element and a fingerprint detection element, and includes: a driving sub-circuit, outputting a light-emitting driving current to the light-emitting element under the control of a driving node; a data writing sub-circuit, communicating a data input terminal with the driving node in response to a scanning signal of a scanning signal terminal; a first energy storage sub-circuit, coupled to the driving node and a control signal terminal; a detection sub-circuit, outputting a detection current under the control of an output terminal of the fingerprint detection element; and a data output sub-circuit, outputting a detection current to the data output terminal in response to the scanning signal of the scanning signal terminal.

Abstract: An approach is provided for accessing data in a database. A query which accesses item(s) in the data is received. The query has multiple conditions whose execution produces a final result. Amounts of filtering of portions of the data caused by utilizing different types of indexes to filter the portions are determined. Greatest amounts of filtering for the portions are determined. Types of indexes are selected so that a utilization of a given type of index causes a greatest amount of filtering for a given portion. Data access methods for the portions of data are generated. During runtime, process tasks are generated for the multiple conditions in the query. An execution flow is controlled. The execution flow executes the process tasks by utilizing the data access methods to generate initial results. The final result of the query is generated by combining the initial results from the process tasks.

Abstract: Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: examining data of breaches of a geofence by client computer devices to determine respective positions of the breaches; receiving by a database system transaction data from client computer devices, the transaction data defined by insert query data; changing a structure of an index of a certain table of the database system in response to the receiving; generating logging data in response to the receiving of the transaction data; providing using the logging data prediction specifying data, the prediction specifying data specifying one or more change predicted to occur with respect to the index; and modifying the index in dependence on the prediction specifying data.

Abstract: Embodiments of the present invention provide systems and methods for detecting data redundancy within a database and optimizing data access operations. The embodiments identify a candidate column to determine the relationship between the candidate column against the remaining columns. The system calculates the vector angles of rows based on candidate column pairs and determines the difference in the angle between the candidate column and the corresponding rows of data in the comparison columns. If the candidate column has a greater angle than the compared column, then the compared column is identified as redundant and is marked for the decluttering process.

Abstract: A computer-implemented method dynamically changes an access plan during run-time. The method includes, receiving, from a host, a query, that is configured to retrieve a set of data from a database. The method also includes, generating an access plan, the access plan comprising a plurality of commands. The method further includes, creating, for a first command of the plurality of commands, a plurality of mini plans including a first mini plan and a second mini plan. The method includes, analyzing each mini plan of the plurality of mini plans. The method also includes, changing, dynamically and in response to the analyzing, the access plan.

Abstract: An approach is provided for optimizing a join operation that includes receiving, by one or more processors of a computer system, a join request associated with a fact table and a plurality of related dimension tables; identifying, by the one or more processors of the computer system, a join relationship from the fact table and the plurality of related dimension tables; matching, by the one or more processors of the computer system, different tables of the fact table and the plurality of related dimension tables; filtering, by the one or more processors of the computer system using data parallelism, the fact table and the plurality of related dimension tables, wherein the filtering occurs prior to performing the join request; and performing, by the one or more processors of the computer system, the join operation pursuant to the join request.

Abstract: Database configuration tuning is provided. A set of database nodes having similar data factors is selected in a centerless network of database nodes. Configuration models corresponding to the set of database nodes are trained using data parallelism. Trained configuration models corresponding to the set of database nodes are combined to form a federated configuration model. It is determined whether performance indicators corresponding to the set of database nodes are greater than a performance threshold level. In response to determining that the performance indicators corresponding to the set of database nodes are greater than the performance threshold level, a database configuration corresponding to the federated configuration model is recommended to a new database node. The new database node is joined to the centerless network.

Abstract: The present disclosure provides a method, an apparatus, a device and a system for sign language translation, where a server receives video information sent by a terminal device, and preprocesses the video information to obtain at least one sign language action; the at least one sign language action is input into a sign language model for classification and prediction to obtain a word corresponding to the at least one sign language action; each word is input into a language model to determine whether an intention expression is complete; and each word is sent to the terminal device when the intention expression is complete, so that the terminal device displays each word, thereby realizing the translation of the sign language action into text, enabling the ordinary persons to better understand intentions of the hearing impaired, thus improving efficiency of communications.

Abstract: A lightweight database-management system (DBMS) is based on a dynamic microservices architecture that implements each granular DBMS feature or function as a distinct, independently executable microservice. The DBMS's Parser front-end responds to each incoming query by selecting the first bind-time database feature needed to process the query. The Parser forwards its selection through a Channel-Binding subsystem to an Event Services Activation subsystem that activates a corresponding microservice to perform the selected feature. The first feature then selects the next required bind-time feature for activation, and this process continues sequentially until all required bind-time microservices have been identified, activated, and run. Runtime query-processing features are then sequentially selected in a similar manner. However, each selected runtime microservice is preloaded but not run.

Abstract: A display device and a display method of the same are provided. The display device includes: a color electrophoretic display pixel layer and a liquid crystal layer; the color electrophoretic display pixel layer includes electrophoretic display pixel units arranged in an array, each of the electrophoretic display pixel units includes three pixel sub-units, and each of the electrophoretic display pixel units is configured to display a color by mixing colors of the three pixel sub-units; the liquid crystal layer is disposed on a light-emitting surface of the color electrophoretic display pixel layer, and a luminous flux of light emitted from the color electrophoretic display pixel layer is changed by controlling a deflection angle of a liquid crystal in the liquid crystal layer.

Abstract: An approach is provided for evaluating a performance of a query. A risk of selecting a low performance access path for a query is determined. The risk is determined to exceed a risk threshold. Based on the risk exceeding the risk threshold and using a machine learning optimizer, first costs of access paths for the query are determined. Using a cost-based database optimizer, second costs of the access paths are determined. Using a strong classifier operating on the first costs and the second costs, a final access path for the query is selected from the access paths.

Abstract: In an approach for optimizing query executions a processor receives a request to transfer data from a first table to a second table. A processor detects a relationship between the first table and the second table, wherein the relationship is based on a similarity between the first table and the second table. A processor identifies at least a first access path for transferring the data from the first table to the second table. A processor calculates a first cost of transferring the data from the first table to the second table using the first access path based on the similarity between the first table and the second table, wherein the first cost indicates estimated processor usage to transfer the data.

Abstract: A method, an apparatus, a system, and a computer program product for handling security threats in a network data processing system. A computer system determines a connection type for a connection in response to detecting the connection between a target resource in the network data processing system and a requestor. The computer system redirects the connection to a virtual resource in place of the target resource when the connection type is a threat connection, wherein the requestor originating the connection to the target resource is unable to perceive a redirection of the connection to the virtual resource. The computer system records information in the connection redirected to the virtual resource to form recorded information. The computer system adjusts a security policy for handling connections in the network data processing system using the recorded information, wherein the security threats in the network data processing system are decreased using the security policy.