Abstract: The present application provides a cover body mechanism, wherein the cover body mechanism comprises a first cover body, a handle, a second cover body, a connecting base and a sealing ring, wherein a bottom of the first cover body is provided with a groove; wherein the connecting end is movably accommodated in the groove through the second channel opening and connected with the groove through a second rotating shaft; wherein the connecting ring is sleeved with an upper side of the second cover body, an upper end of the connecting arm is movably accommodated in the groove through the first channel opening and is connected with the connecting end through a first rotating shaft; wherein the sealing ring is capable of deforming outward and expanding with the rise of the second cover body, so as to be sealingly contact to an inner side wall of a storage cavity in the sealed tank body.

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, computer program products, and systems are presented. The methods include, for instance: receiving a request for a lock on a page from a virtual database amongst two or more virtual databases, the virtual database including a number of containers respectively corresponding to the same number of database components of the virtual database. A copy of the page is refreshed with a latest copy of the page in an overall cache prior to granting the lock based on ascertaining that the page is not locked by any other virtual database. The virtual database is granted with the lock and have an exclusive access to the page.

Abstract: A computer-implemented method for performing an operation in a tree structure is provided according to embodiments of the present disclosure. In the computer-implemented method, an operation to be performed in a tree structure may be received. The tree structure may comprise a plurality of non-leaf nodes and a plurality of leaf nodes. The operation may be associated with a record comprising a pair of key and value. One of the non-leaf nodes may be determined based on the key of the record. Then, the operation may be performed in the determined non-leaf node.

Abstract: The present invention relates to methods and compositions for using plasma Indian hedgehog (IHH) as a biomarker for diagnosing, and as a therapeutic target for treating, liver conditions including non-alcoholic steatohepatitis (NASH).

Abstract: A system, program product, and method for enhancing automatic multidimensional query processing. The method includes executing a database query including semi-joining a plurality of dimension tables with a fact table. The method also includes identifying for extraction one or more data values from each dimension table of the plurality of dimension tables. The data values from each dimension table of the plurality of dimension tables are associated with a respective record identification (RID), thereby defining one or more RIDs. The method further includes generating a plurality of RID lists. Each RID list of the plurality of RID lists includes a collection of the one or more RIDs for the respective dimension table. The method also includes merging the plurality of RID lists, sorting, subject to the merging, the plurality of RIDs as a function of data location, and fetching the data values from the fact table.

Abstract: Systems and methods are provided for automated classification of data using fingerprints. In embodiments, a method includes: generating, by a computing device based on predetermined rules, a fingerprint of a data column in a data set to be classified, the fingerprint comprising dimensions, wherein each of the dimension is assigned an attribute representing a characteristic of data in the data column; determining, by the computing device, that the fingerprint matches one or more target fingerprints by comparing the fingerprint to the target fingerprints, wherein each target fingerprint is associated with a class and includes dimensions, and each dimension is assigned an attribute representing a characteristic of data in the class; and assigning, by the computing device, one or more classes to the data column based on the one or more target fingerprints, thereby generating classified data.

Abstract: This disclosure provides a method, a computing system, and a computer program product for managing prefetching of pages in a database system. The method comprises obtaining shared information associated with page access, wherein the shared information associated with the page access includes information associated with the page access from a plurality of computing nodes. The method further comprises determining whether to prefetch a number of pages into a global buffer pool based at least on the shared information associated with the page access using a sequential prefetching method.

Abstract: A method, system, and computer program product for providing data security through database map restructuring are provided. The method identifies related data tables within a set of data tables within a database. The method identifies a set of related data types within the related data tables. A set of similarities is determined among the set of related data types. The related data types are mapped based on the set of similarities. Based on the mapping, method restructures one or more data tables of the set of data tables to generate a restructured data table.

Abstract: A processor may allocate a first buffer segment from a buffer pool. The first buffer segment may be configured with a first contiguous range of memory for a first data partition of a data table. The first data partition comprising a first plurality of data blocks. A processor may store the first plurality of data blocks in order into the first buffer segment. A processor may retrieve the target data block from the first buffer segment in response to a data access request for a target data block of the first plurality of data blocks.

Abstract: An immersion liquid supply and recovery device (2) with new-type pumping and drainage cavities includes pumping and drainage openings, pumping and drainage cavities, and sealed pumping and drainage channels, wherein the pumping and drainage cavities are in communication with an immersion flow field by means of the multiple pumping and drainage openings, and the pumping and drainage openings in communication with the different pumping and drainage cavities are circumferentially distributed in a crossed manner; at least two pumping and drainage cavities are provided, and each of the pumping and drainage cavities is in communication with an immersion liquid recovery system by one sealed pumping and drainage channel respectively; and the communication points of the pumping and drainage cavities and the sealed pumping and drainage channels are evenly arranged in the circumferential direction of the pumping and drainage cavities.

Abstract: A method, computer program product, and computer system are provided. Statistics for each columnar table are extracted from an online analytical processing (OLAP) database catalog. A transaction table map is created from transaction log records of an online transaction processing (OLTP) database. The transaction table map includes a counter of log records in a transaction and a timestamp indicating a longevity of the transaction. Based on the counter or the longevity exceeding a predefined threshold, the transaction is transformed, and sent to the OLAP database where it is replayed.

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: 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: 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.