Abstract: Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: receiving an incoming query statement, wherein the incoming query statement comprises a query statement expression that includes an input variable; predicting an input variable value associated to the input variable; selecting an access path for runtime execution of the query statement in dependence on the predicted input variable value; and performing runtime execution of the query statement using the selected access path.

Abstract: One or more computer processors match a query pattern to a received query; context information related to the received query; retrieve a set of query records including the same context information as the obtained context information from an index knowledge base, wherein each query record in the set of query records include context information related to a respective history query, the query pattern, an index type associated with the query pattern, and performance information relating to the query pattern and the index type; determine that a subset of the retrieved query records includes one or more query patterns equivalent to the matched query pattern; select a query pattern and an associated index type from the subset of query records based on associated performance information in the set of query records; and perform the received query by applying the selected query pattern and the associated index type.

Abstract: A method of managing a storage system comprises detecting a reference to a first page in the storage system. The method also comprises creating a first candidate block for the first page based on the detecting. The first candidate block may comprise a continuous series of pages that begins with the first page. The method also comprises monitoring subsequent references to pages within the first candidate block. The method also comprises determining that the first candidate block meets a first set of hot-block requirements. The method also comprises relocating the first candidate block to a hot-block space in a buffer pool based on the determining, resulting in a first hot block.

Abstract: A computer implemented method processes a query. A number of processor units processes the query to identify a result set in response to receiving the query from a first client. The number of processor units stores, the result set in a shared cache assigned to a group of clients, wherein result set stored in the shared cache is accessible by the group of clients. The number of processor units returns the result set to a second client in the group of clients from the shared cache in response to receiving the query from the second client in the group of clients.

Abstract: A system for monitoring cells, which includes a device for monitoring cell-substrate impedance, the device having a plurality of wells on a nonconductive substrate, where each of the plurality of wells has an electrode array fabricated on the substrate for measurement of cell-substrate impedance; an impedance analyzer that measures cell-substrate impedance from the plurality of wells; electronic circuitry with multiple analogue-to-digital conversion channels, where the electronic circuitry electrically connects the electrode arrays to the impedance analyzer such that the electrode arrays are electrically monitored at millisecond time resolution; and a software program that analyzes the measured cell-substrate impedance.

Abstract: Methods that provide dynamic index management for a set of computing storage resources are disclosed herein. One method includes collecting, by a processor, a set of current performance data for a set of storage resources storing data and implementing a set of indexes for the data stored on the set of storage resources based on an optimized performance predicted for the set of storage resources based on the collected set of current performance data and a set of predicted performance data that identifies the set of indexes. Also disclosed herein are apparatus, systems, and computer program products that can include, perform, and/or implement the methods for providing dynamic index management for a set of computing storage resources.

Abstract: A method and a device for improving performance of a data processing model, a storage medium and an electronic device are provided. A piece of data in a determined test data read currently is determined as target data. Outlier detection parameters in a detection module are acquired. Detection of concept drift is performed on the data processing model based on the target data and the outlier detection parameters. A detection module is triggered to update each of the outlier detection parameters and the data processing model is retrained when concept drift is successfully detected. After the data processing model is already trained, a piece of data to be read next is determined as the target data, the updated outlier detection parameters in the detection module are acquired, and the detection is resumed until all the pieces of data in the test data stream are read.

Abstract: A computer-implemented method, system and computer program product for handling lock contentions of an index (e.g., SQL index). Leaf pages of an index are monitored for a lock contention during an insert operation of index keys by the transactions. Upon detecting a lock contention of a leaf page, the next index key to be inputted into such a leaf page is routed to a queue of a buffer. The index key that was stored in the queue of the buffer is then mapped to the particular leaf page experiencing the lock contention where the transaction originally attempted to store such an index key, where such mapping is stored in a data structure. Upon such a leaf page no longer experiencing a lock contention, the appropriate index keys are then removed from the buffer and stored in the appropriate leaf page based on the mapping identified in the data structure.

Abstract: A method and apparatus for image formation, a capturing apparatus and an electronic device. The method includes: determining at least two groups of image capture parameters of a to-be-captured image from a prestored parameter library based on classification information on the to-be-captured image; forming at least two preview images by using the at least two groups of image capture parameters; and displaying the at least two preview images on a screen. Hence, a user may be made to quickly obtain accurate and personalized image capture parameters, and acquisition or determination of the image capture parameters is made more convenient and intelligent, thereby better improving the users experience.

Abstract: A computer implemented method for identifying problematic database operations includes identifying database transactions which exhibit performance issues and corresponding parse trees, transforming corresponding parse trees to create historical descriptor arrays, detecting a new database transaction, generating a new descriptor array corresponding to the new database transaction, analyzing the new descriptor array and the historical descriptor arrays to determine whether the new descriptor array indicates a performance issue corresponding to the new database transaction, and responsive to determining that the new descriptor array indicates a performance issue, adding the new database transaction to a resource controlled pool. The method may additionally comprise encoding one or more data items associated with the database.

Abstract: Modifying an index for a database is provided. An index tree for the database is traversed by: identifying a next node in the index tree, requesting a lock of the next node in the index tree, responsive to locking of the next node in the index tree, releasing a lock of a current node of the index tree, and making the next node in the index tree the current node of the index tree, until the current node of the index tree is a leaf node of the index tree. Responsive to determining to split the leaf node, the lock of the leaf node is released and, after releasing the lock of the leaf node, a lock of a non-leaf node parent of the leaf node in the index tree is requested.

Abstract: A computer-implemented method masks shard operations in a distributed database. The method includes performing a shard operation on a first table with a first column and a second column, where the shard operation divides the first table into a first shard with the first column and a second shard with the second column. The method also includes receiving a query, where the query is configured to perform at least a first command. The method further includes determining the first command is directed to the first column. The method includes updating the query to access the first shard in place of the first table. The method also includes executing the query and returning a set of results for the query to a source of the query.

Abstract: The present disclosure provides pharmaceutical compounds, compositions and methods, especially as they are related to compositions and methods for the treatment of tumors and related diseases related to the dysregulation of kinase (such as EGFR (including HER), Alk, PDGFR, but not limited to) pathways.

Abstract: A method includes receiving, by a computing device, a Structured Query Language (SQL) query from a user; generating, by the computing device, execution structures from the SQL query; generating, by the computing device, test results by running the SQL query with the execution structures; building, by the computing device, logs which record information of the running of the SQL query; generating, by the computing device, a candidate execution structure using the information from the logs; normalizing, by the computing device, the SQL query using the candidate execution structure; running, by the computing device, the normalized SQL query in a database; and comparing, by the computing device, results of the normalized SQL query to the test results.

Abstract: A growth-promoting bacterial agent capable of improving content of soybean oil, preparation method, and use thereof are provided. The growth-promoting bacterial agent is fermented by a DW1 strain, the classification name of the DW1 strain is Bacillus sp., the DW1 strain is deposited in the China Center for Type Culture Collection on Jul. 16, 2021, and the deposit number is CCTCC NO: M 2021889. The growth-promoting bacterial agent of the present disclosure has the ability to dissolve insoluble phosphorus and insoluble potassium and can increase content of readily available phosphorus and readily available potassium in the soil, which has an obvious promoting effect on the growth of soybean and improves soybean yield. The growth-promoting bacterial agent of the present disclosure promotes bacteria and can significantly improve the content of soybean oil. At the same time, it has an affinity of soybean agglutinin and can agglutinate with the soybean agglutinin.

Abstract: A computer implemented method processes a search query from a requestor. A number of processor units selects an access path from access paths for each database in a set of databases based on reducing a cost for searching the set of databases using a set of access paths selected for the set of databases in response to receiving the search query from a requestor. The number of processor units receives a result set from searching the set of databases using the set of access paths selected for the set of databases. The number of processor units removes a number of duplicate records from records in the result set. The number of processor units sends the result set with the number of duplicate records removed to the requestor.

Abstract: Methods for identifying compounds that modulate cellular responses stimulated by IgE, which include providing an impedance-based system that monitors cell-substrate impedance of cells on a substrate; introducing cells to the substrate of the system; adding at least one test compound and IgE to the cells, wherein the at least one test compound is suspected of modulating cell responses stimulated by the IgE; adding an antigen to the cells; monitoring the cell-substrate impedance of cells on the substrate; and analyzing the cell-substrate impedance to evaluate whether the at least one test compound alters a cellular response to stimulation with the IgE.

Abstract: An approach is provided in which the approach segments each one of multiple components corresponding to multiple component levels in an SQL database system into multiple functions. The approach combines a first one of the multiple functions with a second one of the multiple functions into an image, and invokes the image to process an SQL query using the first function and the second function.

Abstract: A computer-implemented method improves the performance of write ahead logging. The method includes generating a set of query data and a set of log data, where the set of log data is configured to create a write ahead log, and the set of query data is configured to make changes to data in a database. The method also includes writing the set of query data to a virtual file system. The method further includes separating the set of log data into a set of control intervals, where each control interval includes an entry. The method includes writing, each entry into a log buffer, where the writing the set of query data to the virtual file system and the writing each entry into the log buffer are performed in parallel. The method also includes combining each entry into a complete log.

Abstract: Building a first layer model of a three-layer model based on attributes that are sensitive features is provided. A first dimension reduction of sensitive features removes each sensitive feature having an indicator that it is present in a patch and does not contribute to one or more of three probabilities. A second dimension reduction of insensitive features is performed using vectorizing and using one-hot encoding. The remaining insensitive features are main features. One or more second layer models of the three-layer model is built based on the main features. The third layer model is built based on a verification dataset and the first layer model. Regression test coverage is recommended based on prediction result of the third layer model, and wherein regression tests are selected. The training dataset is updated based on probability calculations of the first layer model.