Abstract: Computer technology where a data table and its index are created using a VOLATILE column type. Records are inserted with a final value and index is inserted with staging value. One bit is used in the data record header to indicate whether it is in-sync with its index. One bit in index key header indicates either this can be an index only update or needs to be a regular update. In the beginning, when a record is inserted into data page, both flag bits will be in the off status, meaning the data record is not in sync with its index entry and only index-only update(s) may be performed. This can prevent needless updates to a data page stored in a volatile memory (for example, a random access memory).

Abstract: This disclosure provides systems, methods and apparatus, including computer programs encoded on computer storage media, for responding to a maximum permissible exposure (MPE) condition in uplink communications. In one aspect, a user equipment (UE) wireless device may detect an MPE condition associated with a cell in an uplink channel from the UE in the wireless communication network. The UE may configure a medium access control layer control element (MAC-CE) to indicate information related to the cell associated with the detected MPE condition and an alternative beam that avoids an MPE condition for use in uplink communications. The configured MAC-CE may include a synchronization signal/physical broadcast channel resource block indicator (SSBRI) or a channel state information resource indicator (CRI) that indicates an alternative UE panel, a feasible UE panel, Tx beam for UL transmissions or Tx beam for UL transmissions taking into account the detected MPE condition.

Abstract: Embodiments of the present disclosure relate to a method, system, and computer program product for block level lock on a data table. According to the method, in response to first transactional processing to be applied on a data table, one or more processors determine that first target data to be accessed during execution of the first transactional processing is comprised in a continuous range of data in the data table. One or more processors determine whether a block lock is available for locking the continuous range of data for the first transactional processing. In accordance with a determination that the block lock is available, one or more processors grant the first transactional processing with the block lock, the block lock being associated with lock information indicating the continuous range of data.

Abstract: Embodiments of the present disclosure provide methods and devices for formatting a database. The method can include clustering, into each block, a set of sequence of elements from each column of a database; generating a file storing one or more blocks having the clustered set of sequences of elements; providing a first table storing file schema information that associates the elements with the file; and providing a second table for storing block schema information that associates the columns with the one or more blocks.

Abstract: The presently-disclosed subject matter describes fusion proteins comprising butyrylcholinesterase (BChE) having an improved production yield and biological half-life and nucleotides encoding the same.

Abstract: The present disclosure provides systems and methods for prefetching data in databases. One method for prefetching data in a database comprises receiving a database query on the database, determining one or more sets of adjacent columns access by the database query, and for each set of adjacent columns of the one or more determined sets, prefetching data in the adjacent columns.

Abstract: A method for making a burnout fabric includes: (1) pre-treating a greige fabric; (2) processing the pre-treated greige fabric with a burnout paste containing sulfuric acid, synthetic gum tragacanth, and sodium alginate; and (3) post-treating the greige fabric after the burnout treatment to obtain a burnout fabric. The method according to the present invention is simple in process, low in cost, and easy to implement, and the burnout fabric obtained thereby has an attractive and clear pattern, featuring a three-dimensional effect and a high quality.

Abstract: The present disclosure provides a method for applying a virtual controller in a game watch. The method includes the following steps: receiving, by a virtual controller, gesture information of a wearer, the gesture information at least including real-time spatial position data of a gyroscope, a real-time speed of current movement, an instant turning speed, an instant pitching speed, and an instant maximum speed; in a continuous moving process of the gyroscope, preprocessing, by the virtual controller, the gesture information, determining speed data generated by a small-range movement as “No real actions are generated” for culling out; further processing valid data.

Abstract: The disclosure relates to the field of medical instruments, and discloses a control device and method for a ventilation therapy equipment, and ventilation therapy equipment. The ventilation therapy equipment has multiple working modes. The control device includes an identification device used for identifying a type of an accessory of the ventilation therapy equipment; and a controller used for determining and controlling, according to the identified type of the accessory, the ventilation therapy equipment to switch to a working mode corresponding to the type of the accessory. The control device can automatically switch the corresponding working modes according to different types of accessories, and is more convenient and intelligent, so that a lot of time can be saved for a doctor and a patient.

Abstract: The present disclosure provides a method for generating a classification model in a database system. The method comprises generating a plurality of database tables by performing data clustering on a database, acquiring a plurality of queries associated with information from the database, generating training data by executing each of the plurality of queries on the plurality of database tables, and training a classification model using the training data, wherein the classification model is used to select a database table for a query based on corresponding performance information associated with the query on the database during executing of the query. The present disclosure also provides a method for executing a query on a database using a classification model. The method comprises obtaining the classification model, obtaining a database query, generating a target table by inputting the database query into the classification model, and executing the database query on the target table.

Abstract: Disclosed herein are polypeptide molecules having Prostate apoptosis response-4 (Par-4) pro-apoptotic activity in cancer cells and enhanced biological half-life, and related methods. Specifically, the disclosure provides a composition comprising Par-4 polypeptide fusion protein, and a method of inducing apoptosis in a cancer cell using the composition, wherein the cancer cell is metastatic.

Abstract: Compounds and compositions are provided that can inhibit microsomal prostaglandin E synthase-1 (mPGES-1). The compounds and compositions can reduce inflammation in a subject, such as inflammation caused by an inflammation disorder or symptoms thereof. Pharmaceutical compositions comprising the compound are also provided. Furthermore, methods are provided for reducing inflammation and/or inhibiting mPGES-1. The methods can comprise administering an effective amount of the composition to a subject.

Abstract: Efficient large column values storage in columnar databases is disclosed, including: providing a database comprising a write storage, a read storage, and an auxiliary storage, and wherein the auxiliary storage is used to store a large column value of a row that is associated with either the write storage or the read storage, wherein the large column value comprises a column value that meets a set of large column value criteria; and operating the database using the write storage, the read storage, and the auxiliary storage.

Abstract: The methods and computer systems for storing a query plan in a cache. The method can include: determining a use frequency of the query plan; determining a target storage layer for storing the query plan based on the determined use frequency, wherein the cache includes at least two storage layers and each of the storage layers is associated with a compression level of query plans; processing the query plan according to the compression level of the target storage layer; and storing the processed query plan in the target storage layer.

Abstract: Embodiments of the present disclosure provide methods and devices for inserting data in a database. The method can include caching one or more rows of data in a delta table in response to a request to insert the one or more rows in a destination table, wherein the destination table is one of a group of destination tables of a first database, and wherein the delta table contains requested changes of rows of the destination table, the changes being caused by a data operation; determining a priority of the destination table based on runtime information of the destination table relative to the group of destination tables; and scheduling the merging of the inserted rows from the delta table to the destination table based on the determined priority of the destination table. The destination table is in a format of a file storing one or more blocks, each block having a set of sequence of elements clustered from each column of the destination table.

Abstract: Compounds and compositions are provided that can inhibit microsomal prostaglandin E synthase-1 (mPGES-1). The compounds and compositions can reduce inflammation in a subject, such as inflammation caused by an inflammation disorder or symptoms thereof. Pharmaceutical compositions comprising the compound are also provided. Furthermore, methods are provided for reducing inflammation and/or inhibiting mPGES-1. The methods can comprise administering an effective amount of the composition to a subject.

Abstract: Disclosed methods of inhibiting microsomal prostaglandin E2 (PGE2) synthase-1 (mPGES-1) make use of ceftriaxone, aztreonam, cefotetan, pharmaceutically-acceptable salts thereof, and combinations thereof.

Abstract: Compounds and compositions are provided that can inhibit microsomal prostaglandin E synthase-1 (mPGES-1). The compounds and compositions can reduce inflammation in a subject, such as inflammation caused by an inflammation disorder or symptoms thereof. Pharmaceutical compositions comprising the compound are also provided. Furthermore, methods are provided for reducing inflammation and/or inhibiting mPGES-1. The methods can comprise administering an effective amount of the composition to a subject.

Abstract: Intelligent merging for efficient updates in columnar databases are disclosed, including: determining a current age associated with a row in a database, wherein the database comprises a write storage and a read storage, wherein the row is located in the write storage; determining a set of one or more merge criteria based at least in part on a modification age distribution, wherein the modification age distribution is dynamically determined based at least in part on previous transactions at the database; determining whether the current age meets the set of merge criteria; and in response to a determination that the current age meets the set of merge criteria, merging the row from the write storage into the read storage.

Abstract: Compositions and methods are provided for use in binding opioids, such as 6-MAM, morphine, heroin, hydrocodone, oxycodone, meperidine, and fentanyl, while avoiding binding to OUD treatment agents, such as naloxone and naltrexone. Methods are also provided for use in a systematic structure-based virtual screening and design approach for identification of such antibodies. Methods are also provided for use in treating OUD. Methods are also provided for use in detecting an opioid in a sample.